-- phpMyAdmin SQL Dump -- version 5.0.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Dec 21, 2021 at 09:35 PM -- Server version: 10.4.17-MariaDB -- PHP Version: 8.0.2 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `alolfaa_bill_empty` -- -- -------------------------------------------------------- -- -- Table structure for table `additions` -- CREATE TABLE `additions` ( `id` int(11) NOT NULL, `name_en` varchar(100) NOT NULL, `name_ar` varchar(100) NOT NULL, `price` float NOT NULL, `group_name` varchar(300) NOT NULL, `active` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `addresses` -- CREATE TABLE `addresses` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `region` text NOT NULL, `blocks` varchar(250) NOT NULL, `street` varchar(250) NOT NULL, `jadah` text NOT NULL, `building_num` varchar(10) NOT NULL, `floor` varchar(50) NOT NULL, `door_no` varchar(50) NOT NULL, `address_link` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `announcement` -- CREATE TABLE `announcement` ( `id` int(11) NOT NULL, `msg` text NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `product_id` int(11) NOT NULL, `students` varchar(200) NOT NULL, `date_added` timestamp NOT NULL DEFAULT current_timestamp(), `added_by` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `bills` -- CREATE TABLE `bills` ( `id` int(11) NOT NULL, `id_product` varchar(200) DEFAULT '0', `id_user` int(11) DEFAULT 0, `name` varchar(225) DEFAULT NULL, `start_date` varchar(30) DEFAULT NULL, `expiry_date` varchar(30) DEFAULT NULL, `date_now` varchar(30) DEFAULT NULL, `payment` varchar(250) DEFAULT '0', `name_product` varchar(250) DEFAULT NULL, `note` text DEFAULT NULL, `since_time_register` int(11) DEFAULT 0, `payment_method` int(11) DEFAULT 0, `paid` int(11) DEFAULT 0, `created` int(11) DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `bills_date` -- CREATE TABLE `bills_date` ( `id` int(11) NOT NULL, `start_date` varchar(30) DEFAULT NULL, `expiry_date` varchar(30) DEFAULT NULL, `attention_date` varchar(30) DEFAULT NULL, `date_now` varchar(30) DEFAULT NULL, `id_user` varchar(5000) DEFAULT NULL, `id_user_created` varchar(5000) DEFAULT NULL, `id_orders` int(11) DEFAULT 0, `id_producer` int(11) DEFAULT 0, `created` int(11) DEFAULT 0, `name_order` varchar(250) DEFAULT NULL, `payment` varchar(250) DEFAULT '0', `discount` varchar(250) DEFAULT NULL, `discount_remainder` varchar(250) DEFAULT '0', `discount_why` varchar(5000) DEFAULT NULL, `note` text DEFAULT NULL, `paid` int(11) DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `bills_gyab` -- CREATE TABLE `bills_gyab` ( `id` int(11) NOT NULL, `id_user` char(15) NOT NULL, `producer` int(11) DEFAULT 0, `gyab` int(1) DEFAULT 0, `day` char(8) NOT NULL, `msg` text DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `bills_orders` -- CREATE TABLE `bills_orders` ( `id` int(11) NOT NULL, `id_orders` int(11) DEFAULT 0, `id_producer` varchar(200) DEFAULT '0', `id_user` int(11) DEFAULT 0, `name` varchar(225) DEFAULT NULL, `sex` int(11) DEFAULT 0, `start_date` varchar(30) DEFAULT NULL, `expiry_date` varchar(30) DEFAULT NULL, `date_now` varchar(30) DEFAULT NULL, `item_price` float NOT NULL, `payment` varchar(250) DEFAULT '0', `discount` varchar(250) DEFAULT NULL, `discount_remainder` varchar(250) DEFAULT '0', `discount_why` varchar(5000) DEFAULT NULL, `name_order` varchar(250) DEFAULT NULL, `note` text DEFAULT NULL, `since_time_register` int(11) DEFAULT 0, `paid` int(11) DEFAULT 0, `start_date_t` varchar(20) DEFAULT NULL, `expiry_date_t` varchar(20) DEFAULT NULL, `date_now_t` varchar(20) DEFAULT NULL, `active` varchar(1) DEFAULT NULL, `created_on` timestamp NOT NULL DEFAULT current_timestamp(), `quantity` float NOT NULL, `comment` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `bills_producer` -- CREATE TABLE `bills_producer` ( `id` int(11) NOT NULL, `name` varchar(250) DEFAULT NULL, `arabic_name` varchar(300) NOT NULL, `details_eng` text NOT NULL, `details_ar` text NOT NULL, `start_date` varchar(30) DEFAULT NULL, `expiry_date` varchar(30) DEFAULT NULL, `valuess` float DEFAULT 0, `active` int(11) DEFAULT 0, `note` text DEFAULT NULL, `since_time_register` int(11) DEFAULT 0, `cat_id` int(11) NOT NULL, `type` int(11) NOT NULL COMMENT '1->product , 2->subscription', `quraan_session` tinyint(1) NOT NULL, `teacher_id` int(11) NOT NULL, `brand` varchar(200) NOT NULL, `code` varchar(20) NOT NULL, `barcode_symbology` varchar(55) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `bills_setting` -- CREATE TABLE `bills_setting` ( `id` int(11) NOT NULL, `name` varchar(250) DEFAULT NULL, `url_site` varchar(225) DEFAULT NULL, `logo` varchar(250) DEFAULT NULL, `email` varchar(250) DEFAULT NULL, `phone1` varchar(250) DEFAULT NULL, `phone2` varchar(250) DEFAULT NULL, `conditions` text DEFAULT NULL, `send_orders` int(11) DEFAULT 0, `send_notice` int(11) DEFAULT 0, `user_find` int(11) DEFAULT 0, `note_notice` text DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `bills_setting` -- INSERT INTO `bills_setting` (`id`, `name`, `url_site`, `logo`, `email`, `phone1`, `phone2`, `conditions`, `send_orders`, `send_notice`, `user_find`, `note_notice`) VALUES (1, 'أكاديمية القيم', 'http://www.andalous.org', '', 'alkiam.academy@gmail.com', '97222488 - 97205203', '24801966 - داخلي: 121', '1- تقوى الله تعالى ومراقبته . 2- اﻻلتزام باﻵداب مع الزملاء والمدربين.
\r\n3- دفع الرسوم بشكل منتظم . 4- اﻻلتزام باللباس الشرعي.
\r\n5 - الالتزام في الحضور . 6 - الغياب بعذر .\r\n', 1, 2, 2, 'هذا تنبيه بقرب موعد سداد الفاتوره ....'); -- -------------------------------------------------------- -- -- Table structure for table `bills_user` -- CREATE TABLE `bills_user` ( `id` int(11) NOT NULL, `username` varchar(250) DEFAULT NULL, `name` varchar(300) NOT NULL, `email` varchar(250) DEFAULT NULL, `cid_user` varchar(15) DEFAULT NULL, `phone_code` varchar(5) NOT NULL, `phone` varchar(250) DEFAULT NULL, `phone_father` varchar(250) DEFAULT NULL, `region` varchar(250) DEFAULT NULL, `nationality` varchar(250) DEFAULT NULL, `sex` text CHARACTER SET utf16 DEFAULT NULL, `note` text DEFAULT NULL, `since_time_register` int(11) DEFAULT 0, `age` varchar(30) DEFAULT NULL, `stop` int(11) DEFAULT 0, `blocks` varchar(250) CHARACTER SET utf16 DEFAULT NULL, `street` varchar(250) CHARACTER SET utf16 DEFAULT NULL, `jadah` text CHARACTER SET utf16 DEFAULT NULL, `building_num` varchar(10) NOT NULL, `floor` varchar(50) CHARACTER SET utf16 DEFAULT NULL, `door_no` int(11) DEFAULT NULL, `address_link` varchar(250) CHARACTER SET utf16 DEFAULT NULL, `create_on` timestamp NULL DEFAULT current_timestamp(), `pass` varchar(130) DEFAULT NULL, `approve_status` tinyint(1) DEFAULT NULL, `block` tinyint(1) DEFAULT NULL, `block_reason` text DEFAULT NULL, `father_job` varchar(200) DEFAULT NULL, `mother_job` varchar(200) DEFAULT NULL, `social_status` varchar(200) DEFAULT NULL, `total_points` int(11) DEFAULT 0, `total_balance` int(11) DEFAULT 0, `student_tags` text DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `bills_user_admin` -- CREATE TABLE `bills_user_admin` ( `id` int(11) NOT NULL, `id_user` int(11) DEFAULT 0, `gruop` int(10) DEFAULT 0, `gruop_bills` int(11) DEFAULT 0, `since_time_register` int(11) DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `datas` -- CREATE TABLE `datas` ( `id` int(11) NOT NULL, `lable` text NOT NULL, `arabic` text CHARACTER SET utf32 NOT NULL, `english` text CHARACTER SET utf32 NOT NULL, `create_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `datas` -- INSERT INTO `datas` (`id`, `lable`, `arabic`, `english`, `create_on`, `last_update`) VALUES (5, 'nationality', 'الهند', 'India', '2020-05-20 08:05:29', '0000-00-00 00:00:00'), (6, 'region', 'أبرق خيطان', 'The brightest Khaitan', '2020-05-20 08:05:04', '0000-00-00 00:00:00'), (7, 'region', 'أبو حليفة', ' Abu Halifa', '2020-05-20 08:05:49', '0000-00-00 00:00:00'), (8, 'region', 'بو فطيرة', ' Abu Fatira', '2020-05-20 08:05:33', '0000-00-00 00:00:00'), (9, 'region', 'اشبيلية', ' Seville', '2020-05-20 08:05:22', '0000-00-00 00:00:00'), (10, 'region', 'الأحمدي', ' Ahmadi', '2020-05-20 08:05:45', '0000-00-00 00:00:00'), (11, 'region', 'الأندلس', ' Andalus', '2020-05-20 08:05:08', '0000-00-00 00:00:00'), (12, 'region', 'البدع', ' Fads', '2020-05-20 08:05:27', '0000-00-00 00:00:00'), (13, 'region', 'الجابرية', 'Jabriya', '2020-05-20 08:05:43', '0000-00-00 00:00:00'), (14, 'region', 'الجهراء القديمة', 'Old Jahra', '2020-05-20 08:05:07', '0000-00-00 00:00:00'), (15, 'region', 'الجهراء', 'Jahra', '2020-05-20 08:05:39', '0000-00-00 00:00:00'), (16, 'region', 'الخالدية', 'Khalidiya', '2020-05-20 08:26:14', '0000-00-00 00:00:00'), (17, 'region', 'الحساوي', ' Al-Hasawi', '2020-05-20 08:05:40', '0000-00-00 00:00:00'), (18, 'region', 'الخيران', ' The Lagoons', '2020-05-20 08:05:09', '0000-00-00 00:00:00'), (19, 'region', 'الدسمة', 'Fat', '2020-05-20 08:05:36', '0000-00-00 00:00:00'), (20, 'region', 'الدعية', 'The supplication', '2020-05-20 08:05:56', '0000-00-00 00:00:00'), (21, 'region', 'الدوحة', 'Doha', '2020-05-20 08:05:17', '0000-00-00 00:00:00'), (22, 'region', 'الرابية', ' Hillock', '2020-05-20 08:05:05', '0000-00-00 00:00:00'), (23, 'region', 'الرحاب', 'Al-Rehab', '2020-05-20 08:05:23', '0000-00-00 00:00:00'), (24, 'region', 'الرقة', ' Tenderness', '2020-05-20 08:05:41', '0000-00-00 00:00:00'), (25, 'region', 'الرقعي', ' Riggae', '2020-05-20 08:05:00', '0000-00-00 00:00:00'), (26, 'region', 'الرميثية', ' Rumaithiya', '2020-05-20 08:05:16', '0000-00-00 00:00:00'), (27, 'region', 'الروضة', 'Kindergarten', '2020-05-20 08:05:47', '0000-00-00 00:00:00'), (28, 'region', 'الزهراء', 'Zahra', '2020-05-20 08:05:03', '0000-00-00 00:00:00'), (29, 'region', 'الزور', 'Falsehood', '2020-05-20 08:05:19', '0000-00-00 00:00:00'), (30, 'region', 'السالمي', 'Salmi', '2020-05-20 08:05:37', '0000-00-00 00:00:00'), (31, 'region', 'السالمية', 'Salmiya', '2020-05-20 08:05:56', '0000-00-00 00:00:00'), (32, 'region', 'السلام', 'Peace', '2020-05-20 08:05:13', '0000-00-00 00:00:00'), (33, 'region', 'الشامية', 'The Levantine', '2020-05-20 08:05:30', '0000-00-00 00:00:00'), (34, 'region', 'الشرق', 'the East', '2020-05-20 08:05:47', '0000-00-00 00:00:00'), (35, 'region', 'الشعب', ' The people', '2020-05-20 08:05:07', '0000-00-00 00:00:00'), (36, 'region', 'الشهداء', 'The martyrs', '2020-05-20 08:05:41', '0000-00-00 00:00:00'), (37, 'region', 'الشويخ', 'Shuwaikh', '2020-05-20 08:05:09', '0000-00-00 00:00:00'), (38, 'region', 'الصباحية', ' Morning', '2020-05-20 08:05:31', '0000-00-00 00:00:00'), (39, 'region', 'الصديق', 'the friend', '2020-05-20 08:05:40', '0000-00-00 00:00:00'), (41, 'nationality', 'أستراليا', 'australia', '2020-05-20 11:51:11', '0000-00-00 00:00:00'), (42, 'region', 'حطين', 'Hittin', '2020-06-08 08:06:13', '0000-00-00 00:00:00'), (43, 'region', 'السلام', 'Peace', '2020-06-08 08:06:50', '0000-00-00 00:00:00'), (44, 'region', 'الشهداء', ' The martyrs', '2020-06-08 08:06:09', '0000-00-00 00:00:00'), (45, 'region', 'محافظة مبارك الكبير', ' Mubarak Al-Kabeer Governorate', '2020-06-08 08:06:59', '0000-00-00 00:00:00'), (46, 'region', 'الصليبية', 'Crusader', '2020-06-08 08:06:36', '0000-00-00 00:00:00'), (47, 'region', 'أمغرة', 'Amghara', '2020-06-08 08:06:17', '0000-00-00 00:00:00'), (48, 'region', 'النعيم', 'bliss', '2020-06-08 08:06:46', '0000-00-00 00:00:00'), (49, 'region', 'القصر', 'the palace', '2020-06-08 08:06:05', '0000-00-00 00:00:00'), (50, 'region', 'الواحة', 'The oasis', '2020-06-08 08:06:53', '0000-00-00 00:00:00'), (51, 'region', 'تيماء', 'Taima', '2020-06-08 08:06:25', '0000-00-00 00:00:00'), (52, 'region', 'النسيم', 'The breeze', '2020-06-08 08:06:59', '0000-00-00 00:00:00'), (53, 'region', 'العيون', 'the eyes', '2020-06-08 08:06:55', '0000-00-00 00:00:00'), (54, 'region', 'القيصرية', 'Caesarean section', '2020-06-08 08:06:44', '0000-00-00 00:00:00'), (55, 'region', 'العبدلي', 'Abdali', '2020-06-08 08:06:15', '0000-00-00 00:00:00'), (56, 'region', 'الجهراء القديمة', 'Old Jahra', '2020-06-08 08:06:57', '0000-00-00 00:00:00'), (57, 'region', 'الجهراء الجديدة', 'New Jahra', '2020-06-08 08:06:35', '0000-00-00 00:00:00'), (58, 'region', 'كاظمة', 'Kazema', '2020-06-08 09:06:09', '0000-00-00 00:00:00'), (59, 'region', 'مدينة سعد العبد الله', 'Saad Al-Abdullah city', '2020-06-08 09:06:58', '0000-00-00 00:00:00'), (60, 'region', ' السالمي', 'Salmi', '2020-06-08 09:06:30', '0000-00-00 00:00:00'), (61, 'region', 'المطلاع', 'Insight', '2020-06-08 09:06:59', '0000-00-00 00:00:00'), (62, 'region', 'مدينة الحرير', 'Silk City', '2020-06-08 09:06:31', '0000-00-00 00:00:00'), (63, 'region', 'كبد', 'liver', '2020-06-08 09:06:02', '0000-00-00 00:00:00'), (64, 'region', 'الروضتين', 'Al Rawdatain', '2020-06-08 09:06:32', '0000-00-00 00:00:00'), (65, 'region', 'الصبية', 'The boys', '2020-06-08 09:06:28', '0000-00-00 00:00:00'), (66, 'region', 'أبرق خيطان', 'The brightest Khaitan', '2020-06-08 09:06:24', '0000-00-00 00:00:00'), (67, 'region', 'الأندلس', 'Andalus', '2020-06-08 09:06:55', '0000-00-00 00:00:00'), (68, 'region', 'اشبيلية', 'Seville', '2020-06-08 09:06:37', '0000-00-00 00:00:00'), (69, 'region', 'جليب الشيوخ', 'Jleeb Al-Shuyoukh', '2020-06-08 09:06:09', '0000-00-00 00:00:00'), (70, 'region', 'خيطان', 'Khaitan', '2020-06-08 09:06:38', '0000-00-00 00:00:00'), (71, 'region', 'خيطان الجديدة', 'New Khaitan', '2020-06-08 09:06:11', '0000-00-00 00:00:00'), (72, 'region', 'العمرية', 'Age', '2020-06-08 09:06:38', '0000-00-00 00:00:00'), (73, 'region', 'العارضية', 'Ardiya', '2020-06-08 09:06:09', '0000-00-00 00:00:00'), (74, 'region', 'العارضية الصناعية', 'Industrial Ardiya', '2020-06-08 09:06:07', '0000-00-00 00:00:00'), (75, 'region', 'العباسية', 'Abbasid', '2020-06-08 09:06:57', '0000-00-00 00:00:00'), (76, 'region', 'الفردوس', 'paradise', '2020-06-08 09:06:25', '0000-00-00 00:00:00'), (77, 'region', 'الفروانية', 'Al Farwaniyah', '2020-06-08 09:06:59', '0000-00-00 00:00:00'), (78, 'region', 'الحساوي', 'Al-Hasawi', '2020-06-08 09:06:30', '0000-00-00 00:00:00'), (79, 'region', 'الشدادية', 'Shaddiyah', '2020-06-08 09:06:01', '0000-00-00 00:00:00'), (80, 'region', 'الرابية', 'Hillock', '2020-06-08 09:06:39', '0000-00-00 00:00:00'), (81, 'region', 'الرحاب', 'Al-Rehab', '2020-06-08 09:06:13', '0000-00-00 00:00:00'), (82, 'region', 'الرقعي', 'Riggae', '2020-06-08 09:06:41', '0000-00-00 00:00:00'), (83, 'region', 'الري الصناعية', 'Industrial irrigation', '2020-06-08 09:06:12', '0000-00-00 00:00:00'), (84, 'region', 'ضاحية صباح الناصر', 'Subah Al-Nasser suburb', '2020-06-08 09:06:45', '0000-00-00 00:00:00'), (85, 'region', 'ضاحية عبد الله المبارك', 'Abdullah suburb of Mubarak', '2020-06-08 09:06:28', '0000-00-00 00:00:00'), (86, 'region', 'جابر الأحمد', 'Jaber Al-Ahmad', '2020-06-08 09:06:08', '0000-00-00 00:00:00'), (87, 'region', 'كيفان', 'Kaifan', '2020-06-08 09:06:31', '0000-00-00 00:00:00'), (88, 'region', 'النهضة', 'Renaissance', '2020-06-08 09:06:10', '0000-00-00 00:00:00'), (89, 'region', 'قرطبة', 'Cordoba', '2020-06-08 09:06:40', '0000-00-00 00:00:00'), (90, 'region', 'قرطبة', 'Cordoba', '2020-06-08 09:06:41', '0000-00-00 00:00:00'), (91, 'region', 'غرب مشرف', 'West Mishrif', '2020-06-08 09:06:12', '0000-00-00 00:00:00'), (92, 'region', 'الدعية', 'The supplication', '2020-06-08 09:06:43', '0000-00-00 00:00:00'), (93, 'region', 'السره', 'The navel', '2020-06-08 09:06:11', '0000-00-00 00:00:00'), (94, 'region', 'القيروان', 'Kairouan', '2020-06-08 09:06:36', '0000-00-00 00:00:00'), (95, 'region', 'الضجيج', 'Hype', '2020-06-08 09:06:12', '0000-00-00 00:00:00'), (98, 'department', 'قسم 1', 'dept 1', '2021-05-30 22:45:19', '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `drivers` -- CREATE TABLE `drivers` ( `id` int(11) NOT NULL, `name` varchar(70) NOT NULL, `email` varchar(45) NOT NULL, `phone` varchar(20) NOT NULL, `country` int(11) NOT NULL, `status` tinyint(1) NOT NULL, `password` varchar(45) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `expense` -- CREATE TABLE `expense` ( `id` int(11) NOT NULL, `expense_name` text CHARACTER SET utf32 NOT NULL, `expense_price` int(11) NOT NULL, `expense_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `category_id` int(11) NOT NULL, `updated_by` text CHARACTER SET utf32 NOT NULL, `create_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `status` text CHARACTER SET utf32 NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `expense_category` -- CREATE TABLE `expense_category` ( `id` int(11) NOT NULL, `category_name` text NOT NULL, `category_status` int(11) NOT NULL COMMENT '1->active,0->deactive', `create_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `id` int(11) NOT NULL, `groups` text NOT NULL, `edit` int(11) NOT NULL, `create_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `groups` -- INSERT INTO `groups` (`id`, `groups`, `edit`, `create_on`, `last_update`) VALUES (1, 'admin', 0, '2020-10-07 16:26:10', '0000-00-00 00:00:00'), (3, 'editor', 0, '2020-10-07 16:26:10', '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `gyab` -- CREATE TABLE `gyab` ( `sno` int(11) NOT NULL, `user_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `present` int(11) NOT NULL COMMENT '1->present,0->absent,2->latepresent', `date` varchar(50) NOT NULL, `create_on` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `kw_articles` -- CREATE TABLE `kw_articles` ( `id` int(11) NOT NULL, `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `text` text COLLATE utf8_unicode_ci NOT NULL, `creator_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `check_comment` enum('بلا تعليقات','تعليقات','تعليقات وردود') COLLATE utf8_unicode_ci NOT NULL, `check_rate` enum('بلا تقييم','تقييم') COLLATE utf8_unicode_ci NOT NULL, `article_order` int(11) NOT NULL, `check_homepage` enum('لا','نعم') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'لا', `yes_rate` int(11) NOT NULL, `no_rate` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `kw_article_comments` -- CREATE TABLE `kw_article_comments` ( `id` int(11) NOT NULL, `article_id` int(11) NOT NULL, `comment_text` text COLLATE utf8_unicode_ci NOT NULL, `c_date` date NOT NULL, `user_type` enum('logged','nonlogged') COLLATE utf8_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `user_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `comment_status` enum('معلق','منشور') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'معلق' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `kw_article_rate` -- CREATE TABLE `kw_article_rate` ( `id` int(11) NOT NULL, `article_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `rate` enum('نعم','لا') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `kw_article_reply` -- CREATE TABLE `kw_article_reply` ( `id` int(11) NOT NULL, `article_id` int(11) NOT NULL, `comment_id` int(11) NOT NULL, `reply_text` text COLLATE utf8_unicode_ci NOT NULL, `r_date` date NOT NULL, `user_type` enum('logged','nonlogged') COLLATE utf8_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `user_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `reply_status` enum('معلق','منشور') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'معلق' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `kw_categories` -- CREATE TABLE `kw_categories` ( `id` int(11) NOT NULL, `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `parent_id` int(11) NOT NULL DEFAULT 0, `category_order` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `kw_parent_categories` -- CREATE TABLE `kw_parent_categories` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `privacy_type` enum('عام','كلمة مرور','مستخدمين','مجموعات') COLLATE utf8_unicode_ci NOT NULL, `privacy_data` longtext COLLATE utf8_unicode_ci NOT NULL, `primary_dalel` enum('نعم','لا') COLLATE utf8_unicode_ci NOT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `language` -- CREATE TABLE `language` ( `id` int(11) NOT NULL, `english` text NOT NULL, `arabic` text NOT NULL, `label` varchar(200) CHARACTER SET latin1 NOT NULL, `create_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `language` -- INSERT INTO `language` (`id`, `english`, `arabic`, `label`, `create_on`, `last_update`) VALUES (5, 'Products', 'منتجات', 'products', '2021-06-06 20:49:26', '0000-00-00 00:00:00'), (6, 'Product bills', 'فواتير المنتجات', 'product-bills', '2020-04-20 00:34:09', '0000-00-00 00:00:00'), (7, 'The Students', 'الطلاب', 'the-students', '2020-07-27 15:32:08', '0000-00-00 00:00:00'), (9, 'Accountant report', 'تقرير الحسابات', 'the-accountant', '2020-08-14 16:06:33', '0000-00-00 00:00:00'), (10, 'member', 'عضو', 'member', '2020-04-20 00:34:33', '0000-00-00 00:00:00'), (11, 'language', 'لغة', 'language', '2020-04-20 00:34:06', '0000-00-00 00:00:00'), (12, 'Add', 'أضف', 'add', '2020-04-20 14:52:08', '2020-04-20 02:04:08'), (13, 'customer', 'الزبون', 'customer', '2020-04-20 00:34:02', '0000-00-00 00:00:00'), (14, 'civil no', 'رقم مدني', 'civil-no', '2020-04-20 00:34:28', '0000-00-00 00:00:00'), (15, 'E-mail', 'البريد الإلكتروني', 'e-mail', '2020-04-20 10:57:28', '2020-04-20 10:04:28'), (16, 'mobile', 'التليفون المحمول', 'mobile', '2020-04-20 00:34:22', '0000-00-00 00:00:00'), (17, 'Guardian', 'وصي', 'guardian', '2020-04-20 00:34:51', '0000-00-00 00:00:00'), (18, 'Nationality', 'الجنسية', 'nationality', '2020-04-20 00:34:31', '0000-00-00 00:00:00'), (19, 'Region', 'منطقة', 'region', '2020-04-20 00:34:52', '0000-00-00 00:00:00'), (20, 'The piece', 'القطعة', 'the-piece', '2020-05-19 07:12:38', '2020-05-19 07:05:38'), (21, 'Title', 'عنوان', 'title', '2020-04-20 00:34:27', '0000-00-00 00:00:00'), (22, 'Date of Birth', 'تاريخ الولادة', 'date-of-birth', '2020-04-20 00:34:43', '0000-00-00 00:00:00'), (23, 'sex', 'الجنس', 'sex', '2020-04-20 00:34:01', '0000-00-00 00:00:00'), (24, 'male', 'الذكر', 'male', '2020-04-20 00:34:26', '0000-00-00 00:00:00'), (25, 'female', 'أنثى', 'female', '2020-04-20 00:34:50', '0000-00-00 00:00:00'), (26, 'note', 'ملحوظة', 'note', '2020-04-20 00:34:08', '0000-00-00 00:00:00'), (27, 'description', 'وصف', 'description', '2020-04-20 00:34:26', '0000-00-00 00:00:00'), (28, 'Customer image', 'صورة العميل', 'customer-image', '2020-04-20 00:34:48', '0000-00-00 00:00:00'), (29, 'the delete', 'الحذف', 'the-delete', '2020-04-20 00:34:32', '0000-00-00 00:00:00'), (30, 'continuous', 'مستمر', 'continuous', '2020-04-20 00:34:15', '0000-00-00 00:00:00'), (31, 'off', 'إيقاف', 'off', '2020-04-20 00:34:34', '0000-00-00 00:00:00'), (32, 'the name', 'الاسم', 'the-name', '2020-04-20 05:04:32', '0000-00-00 00:00:00'), (33, 'the value', 'القيمة', 'the-value', '2020-04-20 05:04:50', '0000-00-00 00:00:00'), (34, 'status', 'الحالة', 'status', '2020-04-20 05:04:08', '0000-00-00 00:00:00'), (35, 'Add a product', 'أضف منتجًا', 'add-a-product', '2020-04-20 05:04:48', '0000-00-00 00:00:00'), (36, 'open', 'افتح', 'open', '2020-04-20 05:04:07', '0000-00-00 00:00:00'), (37, 'closed', 'مغلق', 'closed', '2020-04-20 05:04:19', '0000-00-00 00:00:00'), (38, 'the details', 'التفاصيل', 'the-details', '2020-04-20 05:04:41', '0000-00-00 00:00:00'), (39, 'price', 'السعر', 'price', '2020-04-20 05:04:27', '0000-00-00 00:00:00'), (40, 'Referral', 'الإحالة', 'referral', '2020-04-20 05:04:43', '0000-00-00 00:00:00'), (41, 'additions', 'الاضافات', 'additions', '2021-10-21 17:38:33', '2020-04-20 06:04:06'), (42, 'Show product', 'عرض المنتج', 'show-product', '2020-04-20 05:04:33', '0000-00-00 00:00:00'), (43, 'Data', 'البيانات', 'data', '2020-09-08 14:11:27', '0000-00-00 00:00:00'), (44, 'delete', 'حذف', 'delete', '2020-04-20 05:04:04', '0000-00-00 00:00:00'), (45, 'Edit', 'تعديل', 'edit', '2020-04-20 14:32:14', '2020-04-20 02:04:14'), (46, 'the product', 'المنتج', 'the-product', '2020-04-20 05:04:42', '0000-00-00 00:00:00'), (47, 'Current bills', 'الفواتير الحالية', 'current-bills', '2020-04-20 05:04:44', '0000-00-00 00:00:00'), (48, 'Invoices ended', 'انتهت الفواتير', 'invoices-ended', '2020-04-20 05:04:07', '0000-00-00 00:00:00'), (49, 'fees', 'الرسوم', 'fees', '2020-04-20 05:04:28', '0000-00-00 00:00:00'), (50, 'Total fees', 'الرسوم الكلية', 'total-fees', '2020-04-20 05:04:49', '0000-00-00 00:00:00'), (51, 'Total discount', 'إجمالي الخصم', 'total-discount', '2020-04-20 05:04:03', '0000-00-00 00:00:00'), (52, 'Total', 'مجموع', 'total', '2020-04-20 05:04:25', '0000-00-00 00:00:00'), (53, 'paid up', 'المدفوع', 'paid-up', '2020-04-20 05:04:43', '0000-00-00 00:00:00'), (54, 'Date added', 'تاريخ الاضافة', 'date-added', '2021-07-02 18:45:29', '2020-04-20 09:04:39'), (55, 'the number', 'الرقم', 'the-number', '2020-04-20 07:57:14', '2020-04-20 07:04:14'), (56, 'number', 'رقم', 'number', '2020-04-20 05:04:08', '0000-00-00 00:00:00'), (57, 'the beginning', 'البداية', 'the-beginning', '2020-04-20 05:04:26', '0000-00-00 00:00:00'), (58, 'End', 'النهاية', 'end', '2020-04-20 05:04:39', '0000-00-00 00:00:00'), (59, 'Payment', 'دفع', 'payment', '2020-04-20 05:04:58', '0000-00-00 00:00:00'), (60, 'Payment is made', 'يتم الدفع', 'payment-is-made', '2020-04-20 05:04:22', '0000-00-00 00:00:00'), (61, 'Active', 'نشيط', 'active', '2020-04-20 05:04:42', '0000-00-00 00:00:00'), (62, 'Not active', 'غير فعال', 'not-active', '2020-04-20 05:04:00', '0000-00-00 00:00:00'), (63, 'print', 'طباعة', 'print', '2020-04-20 05:04:31', '0000-00-00 00:00:00'), (64, 'view student', 'عرض الطالب', 'view-student', '2020-04-20 05:04:27', '0000-00-00 00:00:00'), (65, 'Export', 'تصدير', 'export', '2020-04-20 05:04:35', '0000-00-00 00:00:00'), (66, 'Expense', 'مصروفات', 'expense', '2020-10-29 11:14:24', '2020-05-08 05:05:36'), (67, 'Revenue', 'إيرادات', 'revenue', '2020-04-20 05:04:20', '0000-00-00 00:00:00'), (68, 'Balance Update', 'تحديث الرصيد', 'balance-update', '2020-04-20 05:04:50', '0000-00-00 00:00:00'), (69, 'statistics', 'الإحصاء', 'statistics', '2020-04-20 05:04:27', '0000-00-00 00:00:00'), (70, 'print an export today', 'طباعة تصدير اليوم', 'print-an-export-today', '2020-04-20 05:04:06', '0000-00-00 00:00:00'), (71, 'Add an invoice', 'أضف فاتورة', 'add-an-invoice', '2020-04-20 05:04:32', '0000-00-00 00:00:00'), (72, 'The balance', 'التوازن', 'the-balance', '2020-04-20 05:04:51', '0000-00-00 00:00:00'), (74, 'the description', 'الوصف', 'the-description', '2020-04-20 05:04:28', '0000-00-00 00:00:00'), (75, 'History', 'التاريخ', 'history', '2020-04-20 05:04:19', '0000-00-00 00:00:00'), (76, 'type', 'اكتب', 'type', '2020-04-20 05:04:36', '0000-00-00 00:00:00'), (77, 'Enter', 'أدخل', 'enter', '2020-04-20 05:04:01', '0000-00-00 00:00:00'), (78, 'AVAILABLE', 'متاح', 'available', '2020-04-20 05:04:20', '0000-00-00 00:00:00'), (79, 'Today', 'اليوم', 'today', '2020-04-20 05:04:04', '0000-00-00 00:00:00'), (80, 'KNET', 'الكي نت', 'knet', '2020-04-20 05:04:10', '0000-00-00 00:00:00'), (81, 'Movements', 'الحركات', 'movements', '2020-04-20 05:04:27', '0000-00-00 00:00:00'), (82, 'New clients', 'العملاء الجدد', 'new-clients', '2020-04-20 05:04:04', '0000-00-00 00:00:00'), (83, 'Operating ratio', 'نسبة التشغيل', 'operating-ratio', '2020-04-20 05:04:05', '0000-00-00 00:00:00'), (84, 'Expenses', 'المصروفات', 'expenses', '2020-04-20 05:04:20', '0000-00-00 00:00:00'), (85, 'Export', 'التصدير', 'export', '2020-04-20 05:04:34', '0000-00-00 00:00:00'), (86, 'Cache', 'الكاش', 'cache', '2020-04-20 05:04:48', '0000-00-00 00:00:00'), (87, 'Expenses', 'مصروفات', 'expenses', '2020-04-20 05:04:06', '0000-00-00 00:00:00'), (88, 'income', 'ايراد', 'income', '2020-04-20 05:04:19', '0000-00-00 00:00:00'), (89, 'recovery', 'تصدير', 'recovery', '2020-04-20 05:04:32', '0000-00-00 00:00:00'), (90, 'the amount', 'المبلغ', 'the-amount', '2020-04-20 05:04:57', '0000-00-00 00:00:00'), (91, 'The recipient\'s name', 'اسم المستلم', 'the-recipient-s-name', '2020-04-20 05:04:21', '0000-00-00 00:00:00'), (92, 'the phone', 'الهاتف', 'the-phone', '2020-04-20 05:04:36', '0000-00-00 00:00:00'), (93, 'The recipient', 'المستلم', 'the-recipient', '2020-04-20 07:39:08', '2020-04-20 07:04:08'), (94, 'Add a member', 'اضافة عضو', 'add-a-member', '2020-04-20 05:04:06', '0000-00-00 00:00:00'), (95, 'Members', 'الاعضاء', 'members', '2020-04-20 05:04:22', '0000-00-00 00:00:00'), (96, 'Arrangement', 'الترتيب', 'arrangement', '2020-04-20 05:04:34', '0000-00-00 00:00:00'), (97, 'the group', 'المجموعة', 'the-group', '2020-04-20 05:04:47', '0000-00-00 00:00:00'), (98, 'reports', 'التقارير', 'reports', '2020-04-20 05:04:24', '0000-00-00 00:00:00'), (99, 'modification', 'تعديل', 'modification', '2020-04-20 05:04:49', '0000-00-00 00:00:00'), (100, 'The name of the member', 'مسمى العضو', 'the-name-of-the-member', '2020-04-20 06:04:00', '0000-00-00 00:00:00'), (101, 'password', 'الباسورد', 'password', '2020-04-20 06:04:21', '0000-00-00 00:00:00'), (102, 'Collection', 'مجموعة', 'collection', '2020-04-20 06:04:43', '0000-00-00 00:00:00'), (103, 'Director', 'مدير', 'director', '2020-04-20 06:04:53', '0000-00-00 00:00:00'), (104, 'Supervisor', 'مشرف', 'supervisor', '2020-04-20 06:04:07', '0000-00-00 00:00:00'), (105, 'member', 'عضو', 'member', '2020-04-20 06:04:16', '0000-00-00 00:00:00'), (106, 'Not enabled', 'غير مفعل', 'not-enabled', '2020-04-20 06:04:33', '0000-00-00 00:00:00'), (107, 'View reports', 'عرض التقارير', 'view-reports', '2020-04-20 06:04:23', '0000-00-00 00:00:00'), (108, 'Aluser', 'اليوزر', 'aluser', '2020-04-20 06:04:13', '0000-00-00 00:00:00'), (109, 'Time', 'الوقت', 'time', '2020-04-20 06:04:21', '0000-00-00 00:00:00'), (110, 'Entry and exit', 'مدخل ومخرج', 'entry-and-exit', '2020-04-20 06:04:00', '0000-00-00 00:00:00'), (111, 'Dashboard', 'لوحة القيادة', 'dashboard', '2020-04-20 06:13:07', '2020-04-20 06:04:07'), (112, 'the list', 'القائمة', 'the-list', '2020-04-20 06:04:16', '0000-00-00 00:00:00'), (113, 'welcome', 'مرحبا بك', 'welcome', '2020-04-20 07:11:24', '2020-04-20 07:04:24'), (114, 'Search in Clients', 'البحث في العملاء', 'search-in-clients', '2020-04-20 07:04:30', '0000-00-00 00:00:00'), (115, 'invoices', 'فواتير', 'invoices', '2020-04-20 07:26:20', '2020-04-20 07:04:20'), (116, 'Main', 'الأساسية', 'main', '2020-04-20 14:32:35', '2020-04-20 02:04:35'), (117, 'Describe', 'وصف', 'describe', '2020-04-20 07:04:49', '0000-00-00 00:00:00'), (118, 'To me', 'إلي', 'to-me', '2020-04-20 07:04:20', '0000-00-00 00:00:00'), (119, 'Free to', 'مجانا ل', 'free-to', '2020-04-20 07:04:46', '0000-00-00 00:00:00'), (120, 'Addition', 'إضافة', 'addition', '2020-04-20 07:04:10', '0000-00-00 00:00:00'), (121, 'The invoice was added thanks to God', 'تمت إضافة الفاتورة بفضل الله', 'the-invoice-was-added-thanks-to-god', '2020-04-20 08:04:26', '0000-00-00 00:00:00'), (122, 'View an invoice', 'عرض فاتورة', 'view-an-invoice', '2020-04-20 08:04:41', '0000-00-00 00:00:00'), (123, 'Modify an invoice', 'تعديل فاتورة', 'modify-an-invoice', '2020-04-20 08:04:29', '0000-00-00 00:00:00'), (124, 'Advance', 'تقدم', 'advance', '2020-04-20 08:04:32', '0000-00-00 00:00:00'), (125, 'Not paid', 'غير مدفوع', 'not-paid', '2020-04-20 09:04:17', '0000-00-00 00:00:00'), (126, 'is free', 'بدون مقابل', 'is-free', '2020-04-20 09:04:42', '0000-00-00 00:00:00'), (127, 'retriever', 'المسترد', 'retriever', '2020-04-20 09:04:44', '0000-00-00 00:00:00'), (128, 'choose', 'أختر', 'choose', '2020-04-20 09:04:25', '0000-00-00 00:00:00'), (129, 'The beginning and end of the subscription', 'بداية ونهاية الاشتراك', 'the-beginning-and-end-of-the-subscription', '2020-04-20 09:04:05', '0000-00-00 00:00:00'), (130, 'Custom fees', 'رسوم الجمارك', 'custom-fee', '2020-05-18 09:28:51', '0000-00-00 00:00:00'), (131, 'no', 'لا', 'no', '2020-04-20 09:04:26', '0000-00-00 00:00:00'), (132, 'yes', 'نعم', 'yes', '2020-04-20 09:04:41', '0000-00-00 00:00:00'), (133, 'Complimentary', 'مجامله', 'complimentary', '2020-04-20 10:04:03', '0000-00-00 00:00:00'), (134, 'discount', 'خصم', 'discount', '2020-04-20 10:04:29', '0000-00-00 00:00:00'), (135, 'The reason for the discount', 'سبب الخصم', 'the-reason-for-the-discount', '2020-04-20 10:04:25', '0000-00-00 00:00:00'), (136, 'adjustment', 'تعديل', 'adjustment', '2020-04-20 10:04:24', '0000-00-00 00:00:00'), (137, 'Add Language', 'إضافة لغة', 'add-language', '2020-04-20 02:04:12', '0000-00-00 00:00:00'), (138, 'List', 'قائمة', 'list', '2020-04-20 02:04:37', '0000-00-00 00:00:00'), (139, 'English', 'الإنجليزية', 'english', '2020-04-20 02:04:19', '0000-00-00 00:00:00'), (140, 'Arabic', 'عربى', 'arabic', '2020-04-20 02:04:42', '0000-00-00 00:00:00'), (141, 'Label', 'ضع الكلمة المناسبة', 'label', '2020-04-20 02:04:24', '0000-00-00 00:00:00'), (142, 'Action', 'عمل', 'action', '2020-04-20 02:04:56', '0000-00-00 00:00:00'), (143, 'Sno', 'سنو', 'sno', '2020-04-20 02:04:53', '0000-00-00 00:00:00'), (144, 'Groups', 'مجموعات', 'groups', '2020-04-21 04:04:44', '0000-00-00 00:00:00'), (145, 'Group', 'مجموعات', 'group', '2020-04-21 04:04:45', '0000-00-00 00:00:00'), (146, 'Role', 'وظيفة', 'role', '2020-04-21 06:04:23', '0000-00-00 00:00:00'), (147, 'Select', 'تحديد', 'select', '2020-04-21 06:04:32', '0000-00-00 00:00:00'), (148, 'Permission', 'الإذن', 'permission', '2020-04-21 07:04:01', '0000-00-00 00:00:00'), (149, 'All', 'الكل', 'all', '2020-04-21 08:04:51', '0000-00-00 00:00:00'), (150, 'He can see', 'يمكنه أن يرى', 'he-can-see', '2020-04-21 08:04:30', '0000-00-00 00:00:00'), (151, 'He can\'t', 'لا يستطيع', 'he-can-t', '2020-04-21 08:04:57', '0000-00-00 00:00:00'), (152, 'Disable', 'تعطيل', 'disable', '2020-04-23 02:04:07', '0000-00-00 00:00:00'), (153, 'Enable', 'ممكن', 'enable', '2020-04-23 02:47:11', '2020-04-23 02:04:11'), (154, 'Email', 'البريد الإلكتروني', 'email', '2020-04-23 05:04:29', '0000-00-00 00:00:00'), (155, 'Password', 'كلمه السر', 'password', '2020-04-23 05:04:49', '0000-00-00 00:00:00'), (156, 'Sign in to start your session', 'سجل الدخول لبدء جلستك', 'sign-in-to-start-your-session', '2020-04-23 05:04:20', '0000-00-00 00:00:00'), (157, 'Remember Me', 'تذكرنى', 'remember-me', '2020-04-23 05:04:44', '0000-00-00 00:00:00'), (158, 'I forgot my password', 'لقد نسيت كلمة المرور', 'i-forgot-my-password', '2020-04-23 05:04:05', '0000-00-00 00:00:00'), (159, 'Register a new membership', 'تسجيل عضوية جديدة', 'register-a-new-membership', '2020-04-23 05:04:34', '0000-00-00 00:00:00'), (160, 'Sign in', 'تسجيل الدخول', 'sign-in', '2020-04-23 05:04:11', '0000-00-00 00:00:00'), (161, 'Profile', 'الملف الشخصي', 'profile', '2020-04-23 05:04:47', '0000-00-00 00:00:00'), (162, 'Logout', 'خروج', 'logout', '2020-04-23 05:04:23', '0000-00-00 00:00:00'), (163, 'Setting', 'ضبط', 'setting', '2020-05-05 02:05:45', '0000-00-00 00:00:00'), (164, 'Report', 'نقل', 'report', '2020-05-05 09:12:32', '0000-00-00 00:00:00'), (165, 'Search', 'بحث', 'search', '2020-05-05 09:05:59', '0000-00-00 00:00:00'), (166, 'Confirm password', 'تأكيد كلمة المرور', 'confirm-password', '2020-05-06 03:05:44', '0000-00-00 00:00:00'), (167, 'login', 'تسجيل الدخول', 'login', '2020-05-06 04:05:45', '0000-00-00 00:00:00'), (168, 'Add Expense', 'إضافة حساب', 'add-expense', '2020-05-07 03:05:04', '0000-00-00 00:00:00'), (169, 'Expense Name', 'اسم المصاريف', 'expense-name', '2020-05-07 03:05:27', '0000-00-00 00:00:00'), (170, 'Expense Price', 'سعر النفقة', 'expense-price', '2020-05-07 03:05:03', '0000-00-00 00:00:00'), (171, 'Expense Date', 'تاريخ النفقة', 'expense-date', '2020-05-07 03:05:31', '0000-00-00 00:00:00'), (172, 'Update By', 'تحديث بواسطة', 'update-by', '2020-05-07 03:05:23', '0000-00-00 00:00:00'), (173, 'Curriculum Academy', 'كاديمية القيم', 'curriculum-academy', '2020-05-07 05:05:39', '0000-00-00 00:00:00'), (174, 'Customer Name', 'اسم العميل', 'name-the-customer', '2020-09-03 16:27:42', '0000-00-00 00:00:00'), (175, 'invoice number', 'رقم الفاتورة', 'invoice-number', '2020-05-07 06:05:58', '0000-00-00 00:00:00'), (176, 'Start Date', 'تاريخ البداية', 'start-date', '2020-05-07 06:05:31', '0000-00-00 00:00:00'), (177, 'The value of the fees', 'قيمة الرسوم', 'the-value-of-the-fees', '2020-05-07 06:05:58', '0000-00-00 00:00:00'), (178, 'Payment status', 'حالة السداد', 'payment-status', '2020-05-07 06:05:18', '0000-00-00 00:00:00'), (179, 'Terms and Conditions', 'الشروط والآحكام', 'terms-and-conditions', '2020-05-07 06:05:46', '0000-00-00 00:00:00'), (180, 'Expiry date', 'تاريخ النهاية', 'expiry-date', '2020-05-07 06:05:06', '0000-00-00 00:00:00'), (181, 'Invoice details', 'تفاصيل الفاتورة', 'invoice-details', '2020-05-07 06:05:28', '0000-00-00 00:00:00'), (182, 'Mobile number', 'رقم الجوال', 'mobile-number', '2020-05-07 06:05:47', '0000-00-00 00:00:00'), (183, 'Issued date', 'تاريخ اصدار الفاتورة', 'the-date-the-invoice-was-issued', '2020-07-10 21:47:26', '0000-00-00 00:00:00'), (184, 'Ext', 'تحويلة', 'ext', '2020-05-07 06:05:38', '0000-00-00 00:00:00'), (186, 'God Almighty strengthens and monitors it', 'اﻻلتزام باﻵداب مع الزملاء والمدربين.', 'god-almighty-strengthens-and-monitors-it', '2020-05-07 06:05:26', '0000-00-00 00:00:00'), (188, 'Commitment to ethics with colleagues', 'الالتزام بالأخلاقيات مع الزملاء', 'commitment-to-ethics-with-colleagues', '2020-05-07 06:05:24', '0000-00-00 00:00:00'), (189, 'and trainers', 'والمدربين', 'and-trainers', '2020-05-07 06:05:54', '0000-00-00 00:00:00'), (190, 'Commitment to Islamic dress', 'دفع الرسوم بشكل منتظم', 'commitment-to-islamic-dress', '2020-05-07 06:05:30', '0000-00-00 00:00:00'), (191, 'Pay the fees regularly.', 'اﻻلتزام باللباس الشرعي.', 'pay-the-fees-regularly', '2020-05-07 06:05:52', '0000-00-00 00:00:00'), (192, 'commitment in attendance', 'الغياب بعذر', 'commitment-in-attendance', '2020-05-07 06:05:10', '0000-00-00 00:00:00'), (193, 'Absence with an excuse', 'الالتزام في الحضور', 'absence-with-an-excuse', '2020-05-07 06:05:32', '0000-00-00 00:00:00'), (194, 'Phone', 'هاتف', 'phone', '2020-05-07 06:05:09', '0000-00-00 00:00:00'), (195, 'Not paid', 'غير مدفوع', 'not-paid', '2020-05-07 06:05:04', '0000-00-00 00:00:00'), (196, 'No payment made', 'لم يتم الدفع', 'no-payment-made', '2020-05-07 06:05:09', '0000-00-00 00:00:00'), (197, 'Payment is made', 'يتم الدفع', 'payment-is-made', '2020-05-07 06:05:38', '0000-00-00 00:00:00'), (198, 'Payment is free', 'الدفع مجاني', 'payment-is-free', '2020-05-07 06:05:32', '0000-00-00 00:00:00'), (199, 'approve', 'يوافق', 'approve', '2020-05-08 04:05:24', '0000-00-00 00:00:00'), (200, 'Multiple Product', 'منتج متعدد', 'multiple-product', '2020-05-08 05:05:14', '0000-00-00 00:00:00'), (201, 'De Active', 'غير فعال', 'de-active', '2020-05-08 05:05:51', '0000-00-00 00:00:00'), (202, 'Company Logo', 'شعار الشركة', 'company-logo', '2020-05-08 05:05:59', '0000-00-00 00:00:00'), (203, 'Company Fav Icon', 'شركة فاف ايكون', 'company-fav-icon', '2020-05-08 05:05:23', '0000-00-00 00:00:00'), (204, 'Currency', 'عملة', 'currency', '2020-05-08 05:05:06', '0000-00-00 00:00:00'), (205, 'Facebook', 'موقع التواصل الاجتماعي الفيسبوك', 'facebook', '2020-05-08 06:04:09', '2020-05-08 06:05:09'), (206, 'Twitter', 'تويتر', 'twitter', '2020-05-08 05:05:44', '0000-00-00 00:00:00'), (207, 'Google Plus', 'جوجل بلس', 'google-plus', '2020-05-08 05:05:02', '0000-00-00 00:00:00'), (208, 'Instrgram', 'انستغرام', 'instrgram', '2020-05-08 05:05:19', '0000-00-00 00:00:00'), (209, 'Meta Title', 'عنوان الفوقية', 'meta-title', '2020-05-08 05:05:39', '0000-00-00 00:00:00'), (210, 'Meta Keyword', 'كلمة تعريف ميتا', 'meta-keyword', '2020-05-08 05:05:57', '0000-00-00 00:00:00'), (211, 'Meta Description', 'ميتا الوصف', 'meta-description', '2020-05-08 05:05:16', '0000-00-00 00:00:00'), (212, 'Header script', 'نص العنوان', 'header-script', '2020-05-08 05:05:33', '0000-00-00 00:00:00'), (213, 'Footer script', 'نص تذييل', 'footer-script', '2020-05-08 05:05:50', '0000-00-00 00:00:00'), (214, 'Company', 'شركة', 'company', '2020-05-08 06:05:27', '0000-00-00 00:00:00'), (215, 'category', 'الفئة', 'category', '2020-05-11 04:05:51', '0000-00-00 00:00:00'), (216, 'submit', 'إرسال', 'submit', '2020-05-14 05:05:15', '0000-00-00 00:00:00'), (217, 'Company Details', 'تفاصيل الشركة', 'company-details', '2020-05-14 05:05:37', '0000-00-00 00:00:00'), (218, 'Quantity', 'كمية', 'quantity', '2020-05-13 23:05:19', '0000-00-00 00:00:00'), (219, 'Rate', 'معدل', 'rate', '2020-05-13 23:05:46', '0000-00-00 00:00:00'), (220, 'Save', 'حفظ', 'save', '2020-05-13 23:05:57', '0000-00-00 00:00:00'), (221, 'New item', 'عنصر جديد', 'new-item', '2020-05-13 23:05:43', '0000-00-00 00:00:00'), (222, 'Remove', 'إزالة', 'remove', '2020-05-15 05:05:21', '0000-00-00 00:00:00'), (223, 'Enter the custom price, if any', 'ادخل السعر المخصص ان وجد', 'enter-the-custom-price-if-any', '2020-05-16 04:05:20', '0000-00-00 00:00:00'), (224, 'Bills', 'فواتير', 'bills', '2020-05-20 04:05:59', '0000-00-00 00:00:00'), (225, 'Student Register', 'سجل الطالب', 'student-register', '2020-05-20 04:05:27', '0000-00-00 00:00:00'), (226, 'data', 'البيانات', 'data', '2020-05-20 07:05:32', '0000-00-00 00:00:00'), (227, 'block', 'منع', 'block', '2020-05-20 09:05:21', '0000-00-00 00:00:00'), (228, 'street', 'شارع', 'street', '2020-05-20 09:05:41', '0000-00-00 00:00:00'), (229, 'Floor', 'أرضية', 'floor', '2020-05-20 09:05:04', '0000-00-00 00:00:00'), (230, 'Door number', 'رقم الباب', 'door-number', '2020-05-20 09:05:31', '0000-00-00 00:00:00'), (231, 'Address link', 'رابط العنوان', 'address-link', '2020-05-20 09:05:56', '0000-00-00 00:00:00'), (232, 'jadah', 'جدة', 'jadah', '2020-05-20 09:05:29', '0000-00-00 00:00:00'), (233, 'Register', 'تسجيل', 'register', '2020-05-20 10:05:21', '0000-00-00 00:00:00'), (234, 'Show', 'تبين', 'show', '2020-05-21 05:05:42', '0000-00-00 00:00:00'), (235, 'Users', 'المستعمل', 'users', '2020-05-21 05:05:01', '0000-00-00 00:00:00'), (236, 'End Date', 'تاريخ الانتهاء', 'end-date', '2020-05-21 07:05:02', '0000-00-00 00:00:00'), (237, 'Student', 'طالب علم', 'student', '2020-05-22 05:05:03', '0000-00-00 00:00:00'), (238, 'Name', 'اسم', 'name', '2020-05-22 05:05:45', '0000-00-00 00:00:00'), (239, 'Hi', 'مرحبا', 'hi', '2020-05-28 08:05:01', '0000-00-00 00:00:00'), (240, 'Sign Up', 'سجل', 'sign-up', '2020-05-28 03:05:13', '0000-00-00 00:00:00'), (241, 'Attendance', 'الحضور', 'attendance', '2020-05-30 00:05:53', '0000-00-00 00:00:00'), (242, 'Home', 'الصفحة الرئيسية', 'home', '2020-05-30 02:05:57', '0000-00-00 00:00:00'), (243, 'Present', 'حاضر', 'present', '2020-05-30 02:05:09', '0000-00-00 00:00:00'), (244, 'Absent', 'غائب', 'absent', '2020-05-30 02:05:29', '0000-00-00 00:00:00'), (245, 'Late', 'متأخر', 'late', '2020-05-30 02:05:57', '0000-00-00 00:00:00'), (246, 'Date', 'تاريخ', 'date', '2020-05-30 03:05:23', '0000-00-00 00:00:00'), (247, 'MultiOrders', 'متعدد الحدود', 'multiorders', '2020-06-02 03:06:52', '0000-00-00 00:00:00'), (248, 'Add Attendance', 'إضافة الحضور', 'add-attendance', '2020-06-04 03:06:56', '0000-00-00 00:00:00'), (249, 'Cannot be used', 'لايمكن الاستخدام', 'cannot-be-used', '2020-06-06 02:06:27', '0000-00-00 00:00:00'), (250, 'Can be Modified', 'ايمكن التعديل عليه', 'can-be-modified', '2020-06-06 02:06:40', '0000-00-00 00:00:00'), (251, 'Cache export', 'تصدير الكاش', 'cache-export', '2020-06-06 02:06:18', '0000-00-00 00:00:00'), (252, 'Clear', 'مسح', 'clear', '2020-08-06 15:20:51', '0000-00-00 00:00:00'), (253, 'Categories', 'الفئات', 'categories', '2020-07-02 23:12:23', '0000-00-00 00:00:00'), (254, 'Add Category', 'اضافة فئة', 'add-a-category', '2020-07-02 22:45:29', '0000-00-00 00:00:00'), (255, 'Category', 'الفئة', 'category', '2020-07-02 23:44:29', '0000-00-00 00:00:00'), (256, 'Status', 'الحالة', 'status', '2020-07-03 18:56:38', '0000-00-00 00:00:00'), (257, 'Membership', 'اشتراك', 'subscription', '2020-07-04 22:49:57', '0000-00-00 00:00:00'), (258, 'Product', 'منتج', 'product', '2020-07-03 19:06:23', '0000-00-00 00:00:00'), (259, 'Total Days', 'اجمالى عدد الايام', 'total_days', '2020-07-03 21:52:12', '0000-00-00 00:00:00'), (260, 'Attend Status', 'حالة الحضور', 'attend_status', '2020-07-04 14:20:34', '0000-00-00 00:00:00'), (261, 'Absent Summary', 'ملخص الغياب', 'absent_summary', '2020-07-04 20:01:00', '0000-00-00 00:00:00'), (262, 'Num. of invoices', 'عدد الفواتير', 'num_of_invoices', '2020-07-07 16:59:21', '0000-00-00 00:00:00'), (263, 'Delete Products under this category first', 'قم بحذف المنتجات تحت هذة الفئة اولا', 'delete_product_first', '2020-07-08 17:42:29', '0000-00-00 00:00:00'), (264, 'Products Count', 'عدد المنتجات', 'products_count', '2020-07-08 18:13:38', '0000-00-00 00:00:00'), (265, 'Conflict Repeated names', 'عفوا الاسماء مكررة', 'repeated_names', '2020-07-09 17:19:44', '0000-00-00 00:00:00'), (266, 'Operation Performed Successfully', 'تمت العملية بنجاح', 'op_success', '2020-07-09 17:56:55', '0000-00-00 00:00:00'), (267, 'Show Attendance', 'عرض الغياب', 'show_attendance', '2020-07-10 19:47:42', '0000-00-00 00:00:00'), (268, 'Delete All Selected', 'حذف كل المحدد', 'delete_all_selected', '2020-07-10 21:55:13', '0000-00-00 00:00:00'), (269, 'Student Sign In', 'تسجيل دخول الطلاب', 'student_signin', '2020-07-19 14:24:21', '0000-00-00 00:00:00'), (270, 'Email/Phone Num.', 'البريد الالكترونى/رقم الهاتف', 'email/phone', '2020-07-19 15:53:20', '0000-00-00 00:00:00'), (271, 'Registered Successfully, Please wait the admin approval.', ' تم التسجيل بنجاح.من فضلك انتظر موافقة المسؤل', 'success_wait_admin_approval', '2020-07-19 17:27:08', '0000-00-00 00:00:00'), (272, 'Inbox', 'الصندوق الوارد', 'inbox', '2020-07-20 16:41:29', '0000-00-00 00:00:00'), (273, 'Announcement', 'الاعلانات', 'announcement', '2020-07-21 14:32:39', '0000-00-00 00:00:00'), (274, 'Add Announcement', 'اضافة اعلان', 'add-a-announcement', '2020-07-21 16:13:27', '0000-00-00 00:00:00'), (275, 'Content', 'المحتوي', 'content', '2020-07-21 16:16:33', '0000-00-00 00:00:00'), (276, 'General', 'عام', 'general', '2020-07-21 16:22:11', '0000-00-00 00:00:00'), (277, 'Private', 'خاص', 'private', '2020-07-21 16:23:04', '0000-00-00 00:00:00'), (278, 'Address', 'العنوان', 'address', '2020-07-22 18:39:14', '0000-00-00 00:00:00'), (279, 'Change Password', 'تغيير كلمة المرور', 'change_password', '2020-07-25 15:16:50', '0000-00-00 00:00:00'), (280, 'New Password', ' كلمة المرور الجديدة', 'new_password', '2020-07-25 15:23:22', '0000-00-00 00:00:00'), (281, 'Inbox', 'الصندوق الوارد', 'inbox', '2020-07-27 14:15:26', '0000-00-00 00:00:00'), (282, 'There is no new messages', 'لا يوجد رسائل جديدة', 'no_msgs', '2020-07-27 15:06:24', '0000-00-00 00:00:00'), (283, 'Advertisements', 'الاعلانات', 'advs', '2020-07-27 15:19:28', '0000-00-00 00:00:00'), (284, 'Error', 'خطأ', 'error', '2020-08-06 14:45:22', '0000-00-00 00:00:00'), (285, 'Personal Information', 'معلومات شخصية', 'personal_info', '2020-08-06 14:50:10', '0000-00-00 00:00:00'), (286, 'Update your personal informaiton', 'تعديل معلوماتك شخصية', 'update_personal_info', '2020-08-06 14:52:22', '0000-00-00 00:00:00'), (287, 'Student Info', 'معلومات الطالب', 'customer_info', '2020-08-06 14:57:26', '0000-00-00 00:00:00'), (288, 'Avatar', 'الصورة الشخصية', 'avatar', '2020-08-06 14:59:08', '0000-00-00 00:00:00'), (289, 'Allowed file types', 'الملفات المسموح بها', 'allowed_types', '2020-08-06 15:03:30', '0000-00-00 00:00:00'), (290, 'We\'ll never share your data with anyone else.', 'لم نشارك بياناتك الخاصة مع اى احد', 'never_share_ur_data', '2020-08-06 15:08:39', '0000-00-00 00:00:00'), (291, 'Filters', 'تصفية', 'filters', '2020-08-06 15:19:14', '0000-00-00 00:00:00'), (292, 'Check your', 'راجع', 'check_your', '2020-08-06 15:25:00', '0000-00-00 00:00:00'), (293, 'Students', 'الطلاب', 'students', '2020-08-14 16:02:17', '0000-00-00 00:00:00'), (294, 'ِAccountant', 'الحسابات', 'accountant', '2020-08-14 16:08:32', '0000-00-00 00:00:00'), (295, 'Added By', 'اضيف بواسطة', 'added_by', '2020-08-14 17:17:49', '0000-00-00 00:00:00'), (296, 'Messages', 'الرسائل', 'messages', '2020-08-15 14:38:32', '0000-00-00 00:00:00'), (298, '-God Almighty strengthens and monitors it\r\n-Commitment to ethics with colleagues', 'اﻻلتزام باﻵداب مع الزملاء والمدربين.\r\nالالتزام بالأخلاقيات مع الزملاء', 'student-terms-and-conditions', '2020-08-26 15:12:06', '0000-00-00 00:00:00'), (299, 'I agree to the terms and conditions', 'اوافق على الشروط و الحكام', 'agree_terms_conditions', '2020-08-26 15:33:39', '0000-00-00 00:00:00'), (300, 'Block Student', 'حظر الطالب', 'block_student', '2020-08-26 16:43:24', '0000-00-00 00:00:00'), (301, 'Block Reason', 'سبب الحظر', 'block_reason', '2020-08-26 16:52:11', '0000-00-00 00:00:00'), (302, 'Blocked', 'محظور', 'blocked', '2020-08-26 17:34:51', '0000-00-00 00:00:00'), (303, 'Block', 'حظر', 'block', '2020-08-26 17:45:37', '0000-00-00 00:00:00'), (304, 'Unblock', 'ازالة حظر', 'unblock', '2020-08-26 17:47:13', '0000-00-00 00:00:00'), (305, 'Father Job', 'عمل الاب', 'father_work', '2020-08-28 15:33:40', '0000-00-00 00:00:00'), (306, 'Mother Job', 'عمل الام', 'mother_work', '2020-08-28 15:35:09', '0000-00-00 00:00:00'), (307, 'Social status', 'الحالة الاجتماعية', 'social_status', '2020-08-28 15:37:11', '0000-00-00 00:00:00'), (308, 'Other attachments', 'مرفقات اخرى', 'other_attachments', '2020-08-28 16:44:16', '0000-00-00 00:00:00'), (309, 'Required Fields', 'البيانات المطلوبة', 'required_fields', '2020-08-30 09:49:21', '0000-00-00 00:00:00'), (310, 'Student fields', 'بيانات الطالب', 'student_fields', '2020-08-31 14:53:16', '0000-00-00 00:00:00'), (311, 'Notes', 'ملاحظات', 'notes', '2020-09-02 14:57:24', '0000-00-00 00:00:00'), (312, 'Attachments', 'المرفقات', 'attachments', '2020-09-02 17:26:10', '0000-00-00 00:00:00'), (313, 'Activities', 'الانشطة', 'activities', '2020-09-03 18:35:51', '0000-00-00 00:00:00'), (314, 'Browser tab logo', 'شعار التبويب', 'browser_tab_logo', '2020-09-03 18:58:32', '0000-00-00 00:00:00'), (315, 'INVOICE NO.', 'رقم الفاتورة', 'invoice_num', '2020-09-08 14:13:04', '0000-00-00 00:00:00'), (316, 'INVOICE TO.', 'الفاتورة ل', 'invoice_to', '2020-09-08 14:14:42', '0000-00-00 00:00:00'), (317, 'TOTAL AMOUNT', 'المبلغ الكلى', 'total_amount', '2020-09-08 14:24:38', '0000-00-00 00:00:00'), (318, 'Teachers', 'المعلمون', 'teachers', '2020-09-15 13:35:43', '0000-00-00 00:00:00'), (319, 'Add a Teacher', 'اضافة معلم', 'add-a-teacher', '2020-09-15 13:38:40', '0000-00-00 00:00:00'), (320, 'Job Title', 'المسمى الوظيفى', 'job_title', '2020-09-15 13:40:56', '0000-00-00 00:00:00'), (321, 'Username', 'اسم المستخدم', 'username', '2020-09-15 14:44:16', '0000-00-00 00:00:00'), (322, 'Teacher', 'معلم', 'teacher', '2020-09-15 15:33:52', '0000-00-00 00:00:00'), (323, 'Quran Sessions', 'حلقات قران', 'quraan_sessions', '2020-09-26 00:07:47', '0000-00-00 00:00:00'), (324, 'Add a session', 'اضافة حلقة', 'add-a-session', '2020-09-25 16:49:18', '0000-00-00 00:00:00'), (325, 'Students Count', 'عدد الطلاب', 'students_count', '2020-09-25 16:53:20', '0000-00-00 00:00:00'), (326, 'Pages Count', 'عدد الصفحات', 'pages_count', '2020-09-25 18:27:52', '0000-00-00 00:00:00'), (327, 'Quran Session', 'حلقة قران', 'quraan_session', '2020-09-26 00:13:37', '0000-00-00 00:00:00'), (328, 'Summary', 'الملخص', 'summary', '2020-09-26 00:17:05', '0000-00-00 00:00:00'), (329, 'Add a Recite', 'اضافة تسميع', 'add-a-recite', '2020-09-26 15:50:54', '0000-00-00 00:00:00'), (330, 'From Surah', 'من السورة', 'from_surah', '2020-09-26 16:09:27', '0000-00-00 00:00:00'), (331, 'To Surah', 'الى السورة', 'to_surah', '2020-09-26 16:09:27', '0000-00-00 00:00:00'), (332, 'From Ayah', 'من الاية', 'from_ayah', '2020-09-26 16:12:56', '0000-00-00 00:00:00'), (333, 'To Ayah', 'الى الاية', 'to_ayah', '2020-09-26 16:12:56', '0000-00-00 00:00:00'), (334, 'Evaluation', 'التقييم', 'evaluation', '2020-09-27 00:29:59', '0000-00-00 00:00:00'), (335, 'Records', 'السجلات', 'records', '2020-09-27 19:34:48', '0000-00-00 00:00:00'), (336, 'Show Details', 'عرض التفاصيل', 'show_details', '2020-09-27 19:52:52', '0000-00-00 00:00:00'), (337, 'From surah/ayah', 'من سورة/اية', 'from_surah_ayah', '2020-09-27 23:49:19', '0000-00-00 00:00:00'), (338, 'To surah/ayah', 'الى سورة/اية', 'to_surah_ayah', '2020-09-27 23:49:48', '0000-00-00 00:00:00'), (339, 'Teacher Name', 'اسم المعلم', 'teacher_name', '2020-09-28 00:33:09', '0000-00-00 00:00:00'), (340, 'Expired Membership', 'الاشتراكات منتهية الصلاحية', 'expired_membership', '2020-10-26 15:54:31', '0000-00-00 00:00:00'), (341, 'Lines Count', 'عدد الاسطر', 'lines_count', '2020-11-03 19:10:19', '0000-00-00 00:00:00'), (342, 'Tables Export', 'استيراد الجداول', 'tables_export', '2020-11-03 19:28:37', '0000-00-00 00:00:00'), (343, 'Make sure you have enter from/to surah and from/to ayah in a right format.', 'تأكد من ادخال من\\الى السورة و من\\الى الاية بشكل صحيح', 'make_sure_ayah_surah', '2020-11-04 10:39:21', '0000-00-00 00:00:00'), (344, 'Registration Date', 'تاريخ التسجيل', 'register_date', '2020-11-16 15:44:01', '0000-00-00 00:00:00'), (345, 'Update', 'تحديث', 'update', '2021-02-16 19:22:17', '0000-00-00 00:00:00'), (346, 'There is an update available', 'يوجد تحديث جديد', 'update_available', '2021-02-16 19:32:45', '0000-00-00 00:00:00'), (347, 'There is no available updates', 'لا يوجد تحديثات حاليا', 'no_update_available', '2021-02-16 19:32:45', '0000-00-00 00:00:00'), (348, 'Update Now', 'تحديث الان', 'update_now', '2021-02-16 19:32:45', '0000-00-00 00:00:00'), (349, 'Admin Panel default language', 'اللغة الافتراضية للادمن', 'admin_default_lang', '2021-02-17 00:02:55', '0000-00-00 00:00:00'), (350, 'students/Teachers Panel default language', 'اللغة الافتراضية للطالب\\المعلم', 'student_default_lang', '2021-02-17 00:02:55', '0000-00-00 00:00:00'), (351, 'Points', 'النقاط', 'points', '2021-02-25 18:28:00', '0000-00-00 00:00:00'), (352, 'Student Tags', 'الفصل', 'student_tag', '2021-02-25 19:47:54', '0000-00-00 00:00:00'), (353, 'Total Points', 'النقاط', 'total_points', '2021-02-25 20:33:42', '0000-00-00 00:00:00'), (354, 'Total Balance', 'الرصيد', 'total_balance', '2021-02-25 20:33:42', '0000-00-00 00:00:00'), (355, 'Points Deduct', 'خصم نقاط', 'points_deduct', '2021-02-25 21:32:30', '0000-00-00 00:00:00'), (356, 'Awards', 'منح مكافأة', 'awards', '2021-02-25 21:33:31', '0000-00-00 00:00:00'), (357, 'Season Points', 'نقاط الموسم', 'season_points', '2021-02-25 22:36:23', '0000-00-00 00:00:00'), (358, 'Add points', 'اضافة نقاط', 'add_points', '2021-02-27 19:39:45', '0000-00-00 00:00:00'), (359, 'Deduct Reason', 'سبب الخصم', 'deduct_reason', '2021-02-27 20:10:20', '0000-00-00 00:00:00'), (360, 'Award', 'المكافئة', 'award', '2021-02-27 20:56:43', '0000-00-00 00:00:00'), (361, 'Tags', 'الفصول', 'tags', '2021-02-27 22:24:43', '0000-00-00 00:00:00'), (362, 'The Type', 'النوع', 'the_type', '2021-02-27 22:48:20', '0000-00-00 00:00:00'), (363, 'Add Tag', 'اضافة فصل', 'add_tag', '2021-02-27 23:08:40', '0000-00-00 00:00:00'), (364, 'Tag', 'فصل', 'tag', '2021-03-02 15:17:29', '0000-00-00 00:00:00'), (365, 'Edit Tag', 'تعديل الوسم', 'edit_tag', '2021-03-03 20:54:04', '0000-00-00 00:00:00'), (366, 'Credit Date', 'تاريخ الائتمان', 'credit_date', '2021-03-05 16:04:59', '0000-00-00 00:00:00'), (367, 'Used student count', 'الطلاب المستخدمون', 'used_student', '2021-03-05 16:10:58', '0000-00-00 00:00:00'), (368, 'Created Date', 'تاريخ الانشاء', 'created_date', '2021-03-05 16:12:10', '0000-00-00 00:00:00'), (369, 'used', 'مستخدم', 'used', '2021-03-05 16:16:30', '0000-00-00 00:00:00'), (370, 'Not Used', 'غير مستخدم', 'not_used', '2021-03-05 16:16:30', '0000-00-00 00:00:00'), (371, 'Awards', 'المكافئات', 'awards_p', '2021-03-05 16:38:51', '0000-00-00 00:00:00'), (372, 'Credit', 'اضافة', 'credit', '2021-03-05 16:49:30', '0000-00-00 00:00:00'), (373, 'Debit', 'خصم', 'debit', '2021-03-05 16:49:30', '0000-00-00 00:00:00'), (374, 'Cancel', 'الغاء', 'cancel', '2021-03-05 17:28:01', '0000-00-00 00:00:00'), (375, 'Points deduct from', 'خصم النقاط من', 'points_discount_for', '2021-03-05 17:53:29', '0000-00-00 00:00:00'), (376, 'Balance', 'الرصيد', 'balance', '2021-03-05 17:54:41', '0000-00-00 00:00:00'), (377, 'Balance and Points', 'الرصيد و النقاط', 'balance_and_points', '2021-03-05 17:54:41', '0000-00-00 00:00:00'), (378, 'Barcode count', 'عدد الباركود', 'number_of_barcode', '2021-03-05 18:26:42', '0000-00-00 00:00:00'), (379, 'Transactions', 'العمليات', 'transactions', '2021-03-09 23:03:18', '0000-00-00 00:00:00'), (380, 'Approved by', 'تمت الموافقة بواسطة', 'approved_by', '2021-03-11 22:25:15', '0000-00-00 00:00:00'), (381, 'Award History', 'الطلبات', 'award_history', '2021-03-11 22:56:30', '0000-00-00 00:00:00'), (382, 'Accepted', 'تم القبول', 'accepted', '2021-03-13 17:57:12', '0000-00-00 00:00:00'), (383, 'Rejected', 'تم الرفض', 'rejected', '2021-03-13 17:57:12', '0000-00-00 00:00:00'), (384, 'Pending', 'بأنتظار الموافقة', 'pending', '2021-03-13 17:58:37', '0000-00-00 00:00:00'), (385, 'Request Award', 'طلب مكافأة', 'request_award', '2021-03-13 18:04:20', '0000-00-00 00:00:00'), (386, 'My points balance', 'رصيد نقاطى الحالي', 'my_points', '2021-03-13 18:52:48', '0000-00-00 00:00:00'), (387, 'Student Profile', 'صفحة الطالب الشخصية', 'student_profile', '2021-03-14 18:08:14', '0000-00-00 00:00:00'), (388, 'Add Students', 'اضافة طلاب', 'add_students', '2021-03-19 16:44:59', '0000-00-00 00:00:00'), (389, 'Global Settings', 'الاعدادات العامة', 'global_settings', '2021-03-19 22:33:07', '0000-00-00 00:00:00'), (390, 'Invoice Footer', 'خاتمة الفاتورة', 'invoice_footer', '2021-06-10 18:02:34', '0000-00-00 00:00:00'), (391, 'Social Links', 'لينكات التواصل الاجتماعى', 'social_links', '2021-03-23 16:48:39', '0000-00-00 00:00:00'), (392, 'Attendance in products page', 'الغياب بصفحة المنتجات', 'attendance_in_products', '2021-03-23 17:37:56', '0000-00-00 00:00:00'), (393, 'Show Attendance Details', 'عرض تفاصيل الحضور', 'show_attendance_details', '2021-03-24 17:44:45', '0000-00-00 00:00:00'), (394, 'Field', 'الحقل', 'field', '2021-03-26 16:56:44', '0000-00-00 00:00:00'), (395, 'Sales', 'المبيعات', 'sales', '2021-03-26 21:33:40', '0000-00-00 00:00:00'), (396, 'Sessions Plans', 'مخطط الجلسات', 'sessions_plans', '2021-03-27 18:02:32', '0000-00-00 00:00:00'), (397, 'Add a Plan', 'اضافة خطة', 'add-a-plan', '2021-03-27 18:26:09', '0000-00-00 00:00:00'), (398, 'Data not found', 'لم يتم العثور على بيانات', 'data_not_found', '2021-03-27 18:51:00', '0000-00-00 00:00:00'), (399, 'Lines Count Per Session', 'عدد الاسطر فالجلسة الواحدة', 'lines_count_per_session', '2021-03-27 19:09:16', '0000-00-00 00:00:00'), (400, 'Sessions Count Per Week', 'عدد الجلسلت فالاسبوع', 'sessions_count_per_week', '2021-03-27 19:10:00', '0000-00-00 00:00:00'), (401, 'you reach the end of quraan and the sessions not finished', 'لقد وصلت لنهاية القران ولم تنتهى الجلسات', 'reach_end_quraan', '2021-03-27 20:09:26', '0000-00-00 00:00:00'), (402, 'Sessions Count', 'عدد الجلسات', 'sessions_count', '2021-03-27 20:13:31', '0000-00-00 00:00:00'), (403, 'Lines Count', 'عدد الاسطر', 'lines_count', '2021-03-27 20:13:31', '0000-00-00 00:00:00'), (404, 'Pages Count', 'عدد الصفحات', 'pages_count', '2021-03-27 20:13:31', '0000-00-00 00:00:00'), (405, 'Edit a Plan', 'تعديل الخطة', 'edit-a-plan', '2021-03-27 20:42:49', '0000-00-00 00:00:00'), (406, 'plan', 'الخطة', 'plan', '2021-03-28 16:30:52', '0000-00-00 00:00:00'), (407, 'Achievement Percentage', 'معدل التحقيق', 'achievement_percentage', '2021-03-28 17:40:39', '0000-00-00 00:00:00'), (408, 'Invoice Currency', 'عملة الفاتورة', 'invoice_currency', '2021-04-01 22:37:58', '0000-00-00 00:00:00'), (409, 'Show', 'اظهار', 'show_fields', '2021-04-01 23:06:05', '0000-00-00 00:00:00'), (410, 'Student Can Edit', 'الطالب يمكنة التعديل', 'student_can_edit', '2021-04-01 23:19:31', '0000-00-00 00:00:00'), (411, 'Call Center', 'خدمة العملاء', 'call_center', '2021-04-03 00:42:16', '0000-00-00 00:00:00'), (412, 'Add Order', 'اضافة طلب', 'add_order', '2021-04-03 00:45:46', '0000-00-00 00:00:00'), (413, 'Show Orders', 'عرض الطلبات', 'show_orders', '2021-04-03 00:48:22', '0000-00-00 00:00:00'), (414, 'Edit Order', 'تعديل طلب', 'edit_order', '2021-04-03 00:49:39', '0000-00-00 00:00:00'), (415, 'Waiting', 'قيد الانتظار', 'waiting', '2021-04-03 02:12:00', '0000-00-00 00:00:00'), (416, 'Preparing', 'قيد التحضير', 'preparing', '2021-04-03 02:12:00', '0000-00-00 00:00:00'), (417, 'Delivering', 'قيد التوصيل', 'delivering', '2021-04-03 02:12:00', '0000-00-00 00:00:00'), (418, 'Delivered', 'تم التسليم', 'delivered', '2021-04-03 02:12:00', '0000-00-00 00:00:00'), (419, 'Canceled', 'الغيت', 'canceled', '2021-04-03 02:12:00', '0000-00-00 00:00:00'), (420, 'Order Status', 'حالة الطلب', 'order_status', '2021-04-03 02:13:16', '0000-00-00 00:00:00'), (421, 'Delete Order', 'حذف الطلب', 'delete_order', '2021-04-03 19:21:01', '0000-00-00 00:00:00'), (422, 'Support', 'الدعم', 'support', '2021-04-03 20:44:58', '0000-00-00 00:00:00'), (423, 'Add a ticket', 'اضافة تذكرة', 'add-a-ticket', '2021-04-03 21:28:19', '0000-00-00 00:00:00'), (424, 'Edit Ticket', 'تعديل التذكرة', 'edit_ticket', '2021-04-03 21:32:43', '0000-00-00 00:00:00'), (425, 'Delete Ticket', 'حذف التذكرة', 'delete_ticket', '2021-04-03 21:32:43', '0000-00-00 00:00:00'), (426, 'Department', 'القسم', 'department', '2021-04-03 21:39:45', '0000-00-00 00:00:00'), (427, 'High', 'عالى', 'high', '2021-04-03 21:46:54', '0000-00-00 00:00:00'), (428, 'Medium', 'متوسط', 'medium', '2021-04-03 21:46:54', '0000-00-00 00:00:00'), (429, 'Low', 'منخفض', 'low', '2021-04-03 21:46:54', '0000-00-00 00:00:00'), (430, 'Open', 'مفتوحة', 'ticket_open', '2021-04-03 21:53:21', '0000-00-00 00:00:00'), (431, 'In Progress', 'قيد المعالجة', 'in_progress', '2021-04-03 21:53:21', '0000-00-00 00:00:00'), (432, 'On Hold', 'قيد الانتظار', 'on_hold', '2021-04-03 21:53:21', '0000-00-00 00:00:00'), (433, 'Answered', 'تم الاجابة', 'answered', '2021-04-03 21:53:21', '0000-00-00 00:00:00'), (434, 'Inquiry', 'استفسار', 'inquiry', '2021-04-03 21:56:23', '0000-00-00 00:00:00'), (435, 'Complaint', 'شكوى', 'complaint', '2021-04-03 21:56:23', '0000-00-00 00:00:00'), (436, 'Suggestion', 'اقتراح', 'suggestion', '2021-04-03 21:56:23', '0000-00-00 00:00:00'), (437, 'Tickets', 'التذاكر', 'tickets', '2021-04-03 22:01:54', '0000-00-00 00:00:00'), (438, 'Priority', 'الاهمية', 'priority', '2021-04-03 22:43:32', '0000-00-00 00:00:00'), (439, 'Other', 'اخرى', 'other', '2021-04-07 23:28:00', '0000-00-00 00:00:00'), (440, 'Add Reply', 'اضافة رد', 'add_reply', '2021-04-08 00:13:46', '0000-00-00 00:00:00'), (441, 'Payment Method', 'طريقة الدفع', 'payment_method', '2021-04-09 01:05:47', '0000-00-00 00:00:00'), (442, 'Cash', 'نقدى', 'cash', '2021-04-09 01:11:21', '0000-00-00 00:00:00'), (443, 'Link', 'رابط', 'link', '2021-04-09 01:11:21', '0000-00-00 00:00:00'), (444, 'Delivery Status', 'حالة التوصيل', 'delivery_status', '2021-04-09 01:24:03', '0000-00-00 00:00:00'), (445, 'Not Shipped yet', 'لم يتم الشحن بعد', 'not_shipped', '2021-04-09 01:30:30', '0000-00-00 00:00:00'), (446, 'Out to be delivered', 'خرج للتوصيل', 'in_the_way', '2021-04-09 01:30:30', '0000-00-00 00:00:00'), (447, 'Expected Delivery Time', 'وقت التوصيل المتوقع', 'expected_delivery_time', '2021-04-09 01:37:49', '0000-00-00 00:00:00'), (448, 'Delivery Details', 'تفاصيل التوصيل', 'delivery_details', '2021-04-09 02:20:30', '0000-00-00 00:00:00'), (449, 'Edit Order Status', 'تعديل حالة الطلب', 'edit_order_status', '2021-04-09 17:01:10', '0000-00-00 00:00:00'), (450, 'Unable Edit when order is delivered', 'تعطيل تعديل الطلب اذا تم التسليم', 'unable_edit_if_delivered', '2021-04-09 18:26:55', '0000-00-00 00:00:00'), (451, 'can\'t edit the order if paid', 'لا يمكن التعديل على الطلب فقط فى حالة تم الدفع', 'can-t_edit_if_paid', '2021-04-14 20:54:01', '0000-00-00 00:00:00'), (452, 'SMS Settings', 'اعدادات الرسائل القصيرة', 'sms_settings', '2021-04-14 21:30:15', '0000-00-00 00:00:00'), (453, 'Wrong Token, Please contact the vendor', 'خطأ بال token من فضلك تواصل مع موفر الخدمة', 'wrong_token', '2021-04-14 22:50:46', '0000-00-00 00:00:00'), (454, 'Sender Name', 'اسم المرسل', 'sender_name', '2021-04-14 23:12:13', '0000-00-00 00:00:00'), (455, 'Choose when to send SMS', 'اختر الحالات التى يتم ارسال رسائل فيها', 'send_sms_when', '2021-04-15 20:04:55', '0000-00-00 00:00:00'), (456, 'New Order', 'طلب جديد', 'new_order', '2021-04-15 20:08:46', '0000-00-00 00:00:00'), (457, 'In Delivery', 'فى التوصيل', 'in_delivery', '2021-04-15 20:19:03', '0000-00-00 00:00:00'), (458, 'Order Canceled', 'الغاء الطلب', 'order_canceled', '2021-04-15 20:21:18', '0000-00-00 00:00:00'), (459, 'SMS Template', 'نص الرسائل', 'sms_template', '2021-04-15 21:19:42', '0000-00-00 00:00:00'), (460, 'Message Content', 'محتوى الرسالة', 'msg_content', '2021-04-15 21:28:24', '0000-00-00 00:00:00'), (461, 'You can use the following symbols in the message content to be replaced by its actual value', 'يمكن استخدام الرموز التالية فى نص الرسالة ليتم استبدالها بقيمتها الحقيقية', 'you_can_use_this_to_be_replaced', '2021-04-15 21:45:41', '0000-00-00 00:00:00'), (462, 'Order number', 'رقم الطلب', 'order_num', '2021-04-15 21:49:15', '0000-00-00 00:00:00'), (463, 'Store Name', 'اسم المتجر', 'store_name', '2021-04-15 21:51:22', '0000-00-00 00:00:00'), (464, 'Order URL', 'رابط الطلب', 'order_url', '2021-04-15 21:51:22', '0000-00-00 00:00:00'), (465, 'Characters Count', 'عدد الاحرف', 'char_count', '2021-04-17 20:46:01', '0000-00-00 00:00:00'), (466, 'Messages Count', 'عدد الرسائل', 'msgs_count', '2021-04-17 20:46:01', '0000-00-00 00:00:00'), (467, 'Drivers', 'السائقون', 'drivers', '2021-04-20 20:23:27', '0000-00-00 00:00:00'), (468, 'Add a Driver', 'اضافة سائق', 'add-a-driver', '2021-04-20 20:38:01', '0000-00-00 00:00:00'), (469, 'Edit Driver', 'تعديل سائق', 'edit_driver', '2021-04-20 20:40:02', '0000-00-00 00:00:00'), (470, 'Delete Driver', 'حذف سائق', 'delete_driver', '2021-04-20 20:40:02', '0000-00-00 00:00:00'), (471, 'Driver', 'سائق', 'driver', '2021-07-24 22:30:17', '0000-00-00 00:00:00'), (472, 'Building num', 'رقم العمارة', 'building_num', '2021-05-18 17:34:06', '0000-00-00 00:00:00'), (473, 'Points Module', 'موديول النقاط', 'points_module', '2021-05-18 18:11:20', '0000-00-00 00:00:00'), (474, 'Quran Sessions Module', 'موديول حلقات القران', 'quraan_sessions_module', '2021-05-18 18:18:16', '0000-00-00 00:00:00'), (475, 'Call Center Module', 'موديول خدمة العملاء', 'call_center_module', '2021-05-18 18:27:47', '0000-00-00 00:00:00'), (476, 'Support Module', 'موديول الدعم', 'supp_module', '2021-05-18 18:33:46', '0000-00-00 00:00:00'), (477, 'Drivers Module', 'موديول السائقين', 'drivers_module', '2021-05-18 18:36:14', '0000-00-00 00:00:00'), (478, 'Attendance Module', 'موديول الحضور', 'attendance_module', '2021-05-25 21:50:00', '0000-00-00 00:00:00'), (479, 'Total Price', 'المبلغ الكلى', 'total_price', '2021-05-26 17:06:36', '0000-00-00 00:00:00'), (480, 'Edit Price in Invoice', 'تعديل السعر داخل الفاتورة', 'edit_price_in_inv', '2021-05-26 17:34:59', '0000-00-00 00:00:00'), (481, 'Save & go to edit status', 'حفظ والذهاب الى تعديل الحالة', 'save_and_edit_order', '2021-05-26 19:27:10', '0000-00-00 00:00:00'), (482, 'Ready For Deliver', 'جاهز للتوصيل', 'ready_for_deliver', '2021-05-27 00:16:25', '0000-00-00 00:00:00'), (483, 'Reservation', 'حجز', 'reservation', '2021-05-27 00:51:28', '0000-00-00 00:00:00'), (484, 'Order', 'طلب', 'order', '2021-05-27 00:52:40', '0000-00-00 00:00:00'), (485, 'Reservations', 'الحجوزات', 'reservations', '2021-05-27 01:10:59', '0000-00-00 00:00:00'), (486, 'Drivers Report', 'تقرير السائقين', 'drivers_report', '2021-05-27 17:39:07', '0000-00-00 00:00:00'), (487, 'Orders Count', 'عدد الطلبات', 'orders_count', '2021-05-27 17:44:53', '0000-00-00 00:00:00'), (488, 'Drivers Sign In', 'تسجيل دخول السائقين', 'drivers_signin', '2021-05-27 18:56:13', '0000-00-00 00:00:00'), (489, 'Check your Orders Details', 'راجع بيانات الطلبات الخاصة بك', 'check_ur_order_details', '2021-05-27 21:06:53', '0000-00-00 00:00:00'), (490, 'Orders', 'الطلبات', 'orders', '2021-05-27 21:09:06', '0000-00-00 00:00:00'), (491, 'Show/Hide Filter', 'اظهار/اخفاء الفلتر', 'show_hide_filter', '2021-06-01 23:52:40', '0000-00-00 00:00:00'), (492, 'Database Update', 'تحديث قاعدة البيانات', 'database_update', '2021-06-02 00:19:29', '0000-00-00 00:00:00'), (493, 'Driver\'s Data Control', 'التحكم فى بيانات السائقين', 'drivers_data_control', '2021-06-02 17:22:01', '0000-00-00 00:00:00'), (494, 'Data Managment', 'ادارة البيانات', 'data_managment', '2021-06-02 18:44:06', '0000-00-00 00:00:00'), (495, 'Drivers Fields', 'بيانات السائقين', 'drivers_fields', '2021-06-02 18:48:29', '0000-00-00 00:00:00'), (496, 'Menus', 'القوائم', 'menus', '2021-06-02 18:57:48', '0000-00-00 00:00:00'), (497, 'block', 'قطعة', 'block_address', '2021-06-07 19:07:12', '0000-00-00 00:00:00'), (498, 'Add Another Address', 'اضافة عنوان اخر', 'add_another_address', '2021-06-07 19:13:42', '0000-00-00 00:00:00'), (499, 'No Addresses for this Client', 'لا يوجد عناوين لهذا العميل', 'no_addresses', '2021-06-08 17:25:12', '0000-00-00 00:00:00'), (500, 'Select Addresses', 'اختر العناوين', 'select_addresses', '2021-06-08 17:36:29', '0000-00-00 00:00:00'), (501, 'Add Address', 'اضافة عنوان', 'add_address', '2021-06-08 17:41:06', '0000-00-00 00:00:00'), (502, 'English Name', 'الاسم بالانجليزية', 'english_name', '2021-06-10 16:00:46', '0000-00-00 00:00:00'), (503, 'Arabic Name', 'الاسم بالعربية', 'arabic_name', '2021-06-10 16:00:46', '0000-00-00 00:00:00'), (504, 'Product Details English', 'تفاصيل المنتج بالانجليزية', 'details_eng', '2021-06-10 16:19:32', '0000-00-00 00:00:00'), (505, 'Product Details Arabic', 'تفاصيل المنتج بالعربية', 'details_ar', '2021-06-10 16:19:32', '0000-00-00 00:00:00'), (506, 'Comment', 'تعليق', 'comment', '2021-06-10 16:51:41', '0000-00-00 00:00:00'), (507, 'Invoice', 'الفاتورة', 'invoice', '2021-06-10 18:02:55', '0000-00-00 00:00:00'), (508, 'Invoice Language', 'لغة الفاتورة', 'invoice_lang', '2021-06-10 18:05:42', '0000-00-00 00:00:00'), (509, 'Normal Billing', 'فاتورة عادية', 'normal', '2021-06-10 18:16:34', '0000-00-00 00:00:00'), (510, 'Thermal Billing', 'فاتورة حرارية', 'thermal_billing', '2021-06-10 18:15:39', '0000-00-00 00:00:00'), (511, 'Invoice Type', 'نوع الفاتورة', 'inv_type', '2021-06-10 18:18:09', '0000-00-00 00:00:00'), (512, 'Discount Type', 'نوع الخصم', 'discount_type', '2021-06-11 17:29:01', '0000-00-00 00:00:00'), (513, 'Amount', 'مبلغ مالى', 'amount', '2021-06-11 17:30:38', '0000-00-00 00:00:00'), (514, 'Percentage', 'نسبة مئوية', 'percentage', '2021-06-11 17:30:38', '0000-00-00 00:00:00'), (515, 'Brand', 'الماركة', 'brand', '2021-06-11 18:48:29', '0000-00-00 00:00:00'), (516, 'Not Assign', 'لا يحدد', 'not_assign', '2021-06-15 00:34:44', '0000-00-00 00:00:00'), (517, 'Version', 'اصدار', 'version', '2021-06-15 20:34:06', '0000-00-00 00:00:00'), (518, 'advertisement and messages', 'الرسائل و الاعلانات', 'advs_msgs', '2021-06-15 22:45:57', '0000-00-00 00:00:00'), (519, 'Knowledge Base', 'قاعدة المعرفة', 'knowledge_base', '2021-06-18 16:37:42', '0000-00-00 00:00:00'), (520, 'Guides', 'الادلة', 'guides', '2021-06-18 16:44:19', '0000-00-00 00:00:00'), (521, 'Add Guide', 'اضافة دليل', 'add-a-guide', '2021-06-18 17:32:47', '0000-00-00 00:00:00'), (522, 'Link Title', 'عنوان الرابط', 'link_title', '2021-06-18 23:48:55', '0000-00-00 00:00:00'), (523, 'Guide Title', 'عنوان الدليل', 'guide_title', '2021-06-18 23:48:55', '0000-00-00 00:00:00'), (524, 'Protection Type', 'نوع الحماية', 'protection_type', '2021-06-18 23:48:55', '0000-00-00 00:00:00'), (525, 'All Users', 'جميع المستخدمين', 'all_users', '2021-06-18 23:53:35', '0000-00-00 00:00:00'), (526, 'Selected Users', 'المستخدمين المختارين', 'selected_users', '2021-06-18 23:55:50', '0000-00-00 00:00:00'); INSERT INTO `language` (`id`, `english`, `arabic`, `label`, `create_on`, `last_update`) VALUES (527, 'Selected Groups', 'المجموعات المختارة', 'selected_groups', '2021-06-18 23:58:45', '0000-00-00 00:00:00'), (528, 'Guide', 'دليل', 'guide', '2021-06-19 01:04:49', '0000-00-00 00:00:00'), (529, 'Guide Page', 'صفحة الدليل', 'guide_page', '2021-06-19 01:56:11', '0000-00-00 00:00:00'), (530, 'Guide Categories', 'تصنيفات الدليل', 'guide_categories', '2021-06-19 02:06:39', '0000-00-00 00:00:00'), (531, 'Guide Article', 'مقالات الدليل', 'guide_article', '2021-06-19 02:06:39', '0000-00-00 00:00:00'), (532, 'Parent Category', 'التصنيف الرئيسى', 'parent_category', '2021-06-19 02:45:29', '0000-00-00 00:00:00'), (533, 'Articles', 'المقالات', 'articles', '2021-06-19 19:00:55', '0000-00-00 00:00:00'), (534, 'Comments', 'التعليقات', 'comments', '2021-06-19 19:50:11', '0000-00-00 00:00:00'), (535, 'Rating', 'التقييمات', 'rating', '2021-06-19 19:51:45', '0000-00-00 00:00:00'), (536, 'Yes Rating Count', 'عدد التقييمات بنعم', 'yes_rating_count', '2021-06-19 19:53:03', '0000-00-00 00:00:00'), (537, 'No Rating Count', 'عدد التقييمات بلا', 'no_rating_count', '2021-06-19 19:53:54', '0000-00-00 00:00:00'), (538, 'Article Text', 'نص المقالة', 'article_text', '2021-06-19 19:56:26', '0000-00-00 00:00:00'), (539, 'Article', 'مقال', 'article', '2021-06-19 20:25:35', '0000-00-00 00:00:00'), (540, 'Author', 'المؤلف', 'author', '2021-06-19 20:55:43', '0000-00-00 00:00:00'), (541, 'Save Order', 'حفظ الترتيب', 'save_order', '2021-06-19 21:56:02', '0000-00-00 00:00:00'), (542, 'Replies', 'الردود', 'replies', '2021-06-21 16:17:58', '0000-00-00 00:00:00'), (543, 'Author Type', 'نوع المؤلف', 'author_type', '2021-06-21 16:38:51', '0000-00-00 00:00:00'), (544, 'Hide', 'اخفاء', 'hide', '2021-06-21 17:02:07', '0000-00-00 00:00:00'), (545, 'Show', 'اظهار', 'show', '2021-06-21 17:02:07', '0000-00-00 00:00:00'), (546, 'Shown', 'ظاهر', 'shown', '2021-06-21 17:04:27', '0000-00-00 00:00:00'), (547, 'Hidden', 'مختفى', 'hidden', '2021-06-21 17:04:27', '0000-00-00 00:00:00'), (548, 'Reply', 'رد', 'reply', '2021-06-21 17:32:26', '0000-00-00 00:00:00'), (549, 'Order must have items', 'يجب ان يحتوى الطلب على منتجات', 'order_must_have_items', '2021-06-23 15:56:03', '0000-00-00 00:00:00'), (550, 'Home Delivery', 'توصيل منزلى', 'home_delivery', '2021-06-23 16:49:25', '0000-00-00 00:00:00'), (551, 'Direct Receive', 'استلام فورى', 'direct_recieve', '2021-06-23 16:49:25', '0000-00-00 00:00:00'), (552, 'Delivery Type', 'نوع التوصيل', 'delivery_type', '2021-06-23 17:00:56', '0000-00-00 00:00:00'), (553, 'Sales Report', 'تقرير المبيعات', 'sales_report', '2021-06-26 17:16:46', '0000-00-00 00:00:00'), (554, 'Total Sales', 'اجمالى المبيعات', 'total_sales', '2021-06-26 17:58:29', '0000-00-00 00:00:00'), (555, 'Average Order Amount', 'متوسط قيمة الطلب', 'average_order_amount', '2021-06-26 18:31:52', '0000-00-00 00:00:00'), (556, 'Best Selling Products', 'المنتجات الاكثر مبيعا', 'best_selling_products', '2021-06-26 19:15:55', '0000-00-00 00:00:00'), (557, 'Total Sales Amount', 'الكمية المباعة', 'total_sales_amount', '2021-06-26 19:17:45', '0000-00-00 00:00:00'), (558, 'Shop Clients', 'عملاء المتجر', 'shop_clients', '2021-06-26 19:49:07', '0000-00-00 00:00:00'), (559, 'Can\'t Edit Delivered Orders', 'لا يمكن تسليم الطلبات المسلمة', 'cannot_edit_delivered_orders', '2021-06-29 23:16:50', '0000-00-00 00:00:00'), (560, 'Edit Personal Info.', 'تعديل البيانات الشخصية', 'edit_personal_info', '2021-06-30 00:36:25', '0000-00-00 00:00:00'), (561, 'Payment Link', 'رابط الدفع', 'payment_link', '2021-07-01 00:59:19', '0000-00-00 00:00:00'), (562, 'Invoice Payment Message', 'رسالة دفع فاتورة', 'payment_msg', '2021-07-05 20:48:09', '0000-00-00 00:00:00'), (563, 'Choose Payment Method', 'اختر طريقة الدفع', 'choose_payment_method', '2021-07-02 00:13:17', '0000-00-00 00:00:00'), (564, 'PAY', 'ادفع', 'pay', '2021-07-02 01:45:36', '0000-00-00 00:00:00'), (565, 'Payment Page', 'صفحة الدفع', 'payment_page', '2021-07-02 01:53:51', '0000-00-00 00:00:00'), (566, 'Pay Order', 'امر دفع', 'pay_order', '2021-07-02 16:58:30', '0000-00-00 00:00:00'), (567, 'Client Name', 'اسم العميل', 'client_name', '2021-07-02 17:14:02', '0000-00-00 00:00:00'), (568, 'Payment Time', 'وقت الدفع', 'payment_time', '2021-07-02 18:18:56', '0000-00-00 00:00:00'), (569, 'Pay Orders', 'اوامر الدفع', 'pay_orders', '2021-07-02 18:47:16', '0000-00-00 00:00:00'), (570, 'Module', 'موديول', 'module', '2021-07-02 20:50:31', '0000-00-00 00:00:00'), (571, 'Payment Link', 'رابط الدفع', 'payment_link', '2021-07-05 19:56:03', '0000-00-00 00:00:00'), (572, 'Copy', 'نسخ', 'copy', '2021-07-05 20:06:39', '0000-00-00 00:00:00'), (573, 'Transaction ID', 'رقم العملية', 'transaction_id', '2021-07-08 01:35:08', '0000-00-00 00:00:00'), (574, 'Ticket', 'تذكرة', 'ticket', '2021-07-11 17:13:07', '0000-00-00 00:00:00'), (575, 'Payment Settings not set or Disabled, Please contact the system administrator.', 'الدفع معطل او لم يتم ادخال بيانات الدفع من فضلك تواصل مع مدير النظام', 'payment_sett_not_set', '2021-07-14 19:57:35', '0000-00-00 00:00:00'), (576, 'Logs', 'السجلات', 'logs', '2021-07-15 17:59:41', '0000-00-00 00:00:00'), (577, 'Reference num.', 'الرقم المرجعى', 'reference_num', '2021-07-18 20:44:09', '0000-00-00 00:00:00'), (578, 'Admin', 'ادمن', 'admin', '2021-07-24 22:31:13', '0000-00-00 00:00:00'), (579, 'Last Reply Time', 'توقيت اخر رد', 'last_reply_time', '2021-08-17 22:59:33', '0000-00-00 00:00:00'), (580, 'Order Price', 'سعر الطلب', 'order_price', '2021-09-11 16:26:01', '0000-00-00 00:00:00'), (581, 'Payment Details', 'تفاصيل عملية الدفع', 'payment_details', '2021-09-23 22:11:50', '0000-00-00 00:00:00'), (582, 'No data', 'لا توجد بيانات', 'no_data', '2021-09-23 22:16:41', '0000-00-00 00:00:00'), (583, 'Payment Report', 'تقرير المدفوعات', 'payment_report', '2021-10-10 14:41:07', '2021-10-10 14:41:07'), (584, 'Payment Receipt', 'فاتورة الدفع', 'payment_receipt', '2021-10-10 17:02:26', '0000-00-00 00:00:00'), (585, 'Success', 'ناجحة', 'success', '2021-10-17 17:27:03', '0000-00-00 00:00:00'), (586, 'Failed', 'فاشلة', 'failed', '2021-10-17 17:27:03', '0000-00-00 00:00:00'), (587, 'Group Name', 'اسم المجموعة', 'group_name', '2021-10-21 18:01:55', '0000-00-00 00:00:00'), (588, 'Product additions', 'اضافات المنتج', 'product_additions', '2021-10-21 19:00:52', '0000-00-00 00:00:00'), (589, 'English title', 'العنوان انجليزى', 'eng_title', '2021-10-21 20:07:26', '0000-00-00 00:00:00'), (590, 'Arabic title', 'العنوان عربى', 'ar_title', '2021-10-21 20:07:26', '0000-00-00 00:00:00'), (591, 'Choice Type', 'نوع الاختيار', 'choice_type', '2021-10-21 20:09:23', '0000-00-00 00:00:00'), (592, 'Single Choice', 'اختيار احادى', 'single_choice', '2021-10-21 20:11:59', '0000-00-00 00:00:00'), (593, 'Multiple Choice', 'اختيار متعدد', 'multiple_choice', '2021-10-21 20:11:59', '0000-00-00 00:00:00'), (594, 'Mandatory', 'اجبارى', 'required', '2021-10-21 20:13:54', '0000-00-00 00:00:00'), (595, 'Filter by', 'تصفية ب', 'filter_by', '2021-10-21 20:30:52', '0000-00-00 00:00:00'), (596, 'Options', 'الاختيارات', 'options', '2021-10-21 21:36:51', '0000-00-00 00:00:00'), (597, 'You have to choose ', 'يجب عليك اختيار', 'have_to_choose', '2021-10-25 13:52:54', '0000-00-00 00:00:00'), (598, 'For Product', 'لمنتج', 'for_product', '2021-10-25 17:17:20', '0000-00-00 00:00:00'), (599, 'Product Code', 'كود المنتج', 'product_code', '2021-11-06 20:23:34', '0000-00-00 00:00:00'), (600, 'Generate', 'انشاء', 'generate', '2021-11-06 20:35:07', '0000-00-00 00:00:00'), (601, 'Barcode Symbology', 'نوع الباركود', 'barcode_symbology', '2021-11-06 21:17:01', '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `logs` -- CREATE TABLE `logs` ( `id` int(11) NOT NULL, `action` text NOT NULL, `user_id` int(11) NOT NULL, `user_type` int(11) NOT NULL COMMENT '0-> admin, 1-> driver', `order_id` int(11) NOT NULL, `new_status` int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `model_billshawly` -- CREATE TABLE `model_billshawly` ( `id` int(11) NOT NULL, `counter` int(11) DEFAULT 0, `catid` int(11) DEFAULT 0, `catid2` int(11) DEFAULT 0, `name` varchar(255) DEFAULT NULL, `dateadd` varchar(255) DEFAULT NULL, `text1` varchar(255) DEFAULT NULL, `text2` varchar(255) DEFAULT NULL, `text3` varchar(255) DEFAULT NULL, `text4` varchar(255) DEFAULT NULL, `text5` varchar(255) DEFAULT NULL, `text6` varchar(255) DEFAULT NULL, `text7` varchar(255) DEFAULT NULL, `text8` varchar(255) DEFAULT NULL, `text9` varchar(255) DEFAULT NULL, `text10` varchar(255) DEFAULT NULL, `text11` varchar(255) DEFAULT NULL, `text12` varchar(255) DEFAULT NULL, `text13` varchar(255) DEFAULT NULL, `text14` varchar(255) DEFAULT NULL, `text15` varchar(255) DEFAULT NULL, `text16` varchar(255) DEFAULT NULL, `text17` varchar(255) DEFAULT NULL, `text18` varchar(255) DEFAULT NULL, `text19` varchar(255) DEFAULT NULL, `text20` varchar(255) DEFAULT NULL, `text21` varchar(255) DEFAULT NULL, `text22` varchar(255) DEFAULT NULL, `text23` varchar(255) DEFAULT NULL, `text24` varchar(255) DEFAULT NULL, `text25` varchar(255) DEFAULT NULL, `text26` varchar(255) DEFAULT NULL, `text27` varchar(255) DEFAULT NULL, `text28` varchar(255) DEFAULT NULL, `text29` varchar(255) DEFAULT NULL, `text30` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `multi_orders` -- CREATE TABLE `multi_orders` ( `id` int(11) NOT NULL, `id_orders` int(11) DEFAULT 0, `id_producer` varchar(200) DEFAULT '0' COMMENT 'this products tb ids', `id_user` int(11) DEFAULT 0, `name` varchar(225) DEFAULT NULL, `sex` int(11) DEFAULT 0, `start_date` varchar(30) DEFAULT NULL, `expiry_date` varchar(30) DEFAULT NULL, `attention_date` varchar(30) DEFAULT NULL, `date_now` varchar(30) DEFAULT NULL, `payment` varchar(250) DEFAULT '0', `discount` varchar(250) DEFAULT NULL, `discount_remainder` varchar(250) DEFAULT '0', `discount_why` varchar(5000) DEFAULT NULL, `name_order` varchar(250) DEFAULT NULL, `note` text DEFAULT NULL, `since_time_register` int(11) DEFAULT 0, `payment_method` int(11) DEFAULT 0, `outlet_user` int(11) DEFAULT 0, `paid` int(11) DEFAULT 0, `send_notice` int(11) DEFAULT 0, `created` int(11) DEFAULT 0, `start_date_t` varchar(20) DEFAULT NULL, `expiry_date_t` varchar(20) DEFAULT NULL, `date_now_t` varchar(20) DEFAULT NULL, `active` varchar(1) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `m_user` -- CREATE TABLE `m_user` ( `id` int(11) NOT NULL, `username` varchar(150) NOT NULL, `password` varchar(250) NOT NULL, `level` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` int(11) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp(), `type` tinyint(1) NOT NULL COMMENT '0 -> order , 1->reservation', `order_status` int(11) NOT NULL COMMENT '0-> waiting,1->preparing,2->delivering,3->delivered,4->canceled', `call_center` tinyint(1) NOT NULL, `payment_method` int(11) NOT NULL COMMENT '0->cash,1->knet,2->visa/master,3->link ', `payment_time` timestamp NULL DEFAULT NULL, `delivery_status` int(11) NOT NULL, `expected_delivery_time` timestamp NULL DEFAULT NULL, `delivery_details` text NOT NULL, `driver` int(11) NOT NULL, `address_id` int(11) NOT NULL, `discount_type` tinyint(1) NOT NULL, `created_by` int(11) NOT NULL, `delivery_type` tinyint(1) NOT NULL, `TRACKING_ID` varchar(100) NOT NULL, `payment_details` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `order_products_additions` -- CREATE TABLE `order_products_additions` ( `id` int(11) NOT NULL, `order_product_id` int(11) NOT NULL, `product_addition_id` int(11) NOT NULL, `choice_id` varchar(300) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `payment_orders` -- CREATE TABLE `payment_orders` ( `id` int(11) NOT NULL, `client_name` varchar(100) NOT NULL, `phone_code` varchar(5) NOT NULL, `phone` varchar(30) NOT NULL, `amount` float NOT NULL, `desc` text NOT NULL, `payment_time` timestamp NULL DEFAULT NULL, `payment_method` varchar(100) NOT NULL, `TRACKING_ID` varchar(100) NOT NULL, `payment_details` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `payment_settings` -- CREATE TABLE `payment_settings` ( `id` int(11) NOT NULL, `status` int(11) NOT NULL, `type` int(11) NOT NULL, `tap_public_key` varchar(200) NOT NULL, `tap_merchant_id` varchar(100) NOT NULL, `knet_transportal_id` varchar(20) NOT NULL, `knet_transportal_password` varchar(20) NOT NULL, `knet_terminal_resource_key` varchar(30) NOT NULL, `knet_testing_env` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `payment_settings` -- INSERT INTO `payment_settings` (`id`, `status`, `type`, `tap_public_key`, `tap_merchant_id`, `knet_transportal_id`, `knet_transportal_password`, `knet_terminal_resource_key`, `knet_testing_env`) VALUES (1, 1, 2, 'pk_test_mbGNt2a9yPMxLl0V4Sdwkocr', '9703125', '291301', '291301pg', '57XQG0252G2QXZP2', 1); -- -------------------------------------------------------- -- -- Table structure for table `permission` -- CREATE TABLE `permission` ( `id` int(11) NOT NULL, `operator_id` int(11) NOT NULL, `permission_name` varchar(256) NOT NULL, `permission_status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `permission` -- INSERT INTO `permission` (`id`, `operator_id`, `permission_name`, `permission_status`) VALUES (748, 2, 'dashboard', 1), (749, 2, 'product', 0), (750, 2, 'product_list', 0), (751, 2, 'product_add', 0), (752, 2, 'product_edit', 0), (753, 2, 'product_del', 0), (754, 2, 'bill', 0), (755, 2, 'bill_list', 0), (756, 2, 'bill_add', 0), (757, 2, 'bill_edit', 0), (758, 2, 'bill_del', 0), (759, 2, 'student', 0), (760, 2, 'student_list', 0), (761, 2, 'student_add', 0), (762, 2, 'student_edit', 0), (763, 2, 'student_del', 0), (764, 2, 'invoices', 0), (765, 2, 'invoice_list', 0), (766, 2, 'invoice_add', 0), (767, 2, 'invoice_edit', 0), (768, 2, 'invoice_del', 0), (769, 2, 'member', 0), (770, 2, 'member_list', 0), (771, 2, 'member_add', 0), (772, 2, 'member_edit', 0), (773, 2, 'member_del', 0), (774, 2, 'language', 0), (775, 2, 'lang_list', 0), (776, 2, 'lang_add', 0), (777, 2, 'lang_edit', 0), (778, 2, 'lang_del', 0), (779, 2, 'group', 0), (780, 2, 'group_list', 0), (781, 2, 'group_add', 0), (782, 2, 'group_edit', 0), (783, 2, 'group_del', 0), (784, 2, 'accountant', 0), (785, 2, 'account_list', 0), (786, 2, 'account_add', 0), (787, 2, 'account_edit', 0), (788, 2, 'account_del', 0), (18685, 1, 'product', 1), (18686, 1, 'product_add', 1), (18687, 1, 'product_edit', 1), (18688, 1, 'product_del', 1), (18689, 1, 'categories', 1), (18690, 1, 'product_additions', 1), (18691, 1, 'categories_add', 1), (18692, 1, 'categories_edit', 1), (18693, 1, 'categories_del', 1), (18694, 1, 'bill', 1), (18695, 1, 'bill_add', 1), (18696, 1, 'bill_report', 1), (18697, 1, 'bill_invoices', 1), (18698, 1, 'additions', 1), (18699, 1, 'additions_add', 1), (18700, 1, 'additions_edit', 1), (18701, 1, 'additions_del', 1), (18702, 1, 'student', 1), (18703, 1, 'student_add', 1), (18704, 1, 'student_edit', 1), (18705, 1, 'student_del', 1), (18706, 1, 'student_block', 1), (18707, 1, 'student_profile', 1), (18708, 1, 'spro_invoices', 1), (18709, 1, 'spro_subscription', 1), (18710, 1, 'spro_attendance', 1), (18711, 1, 'spro_attachments', 1), (18712, 1, 'spro_points', 1), (18713, 1, 'inbox', 1), (18714, 1, 'student_approve', 1), (18715, 1, 'inbox_delete_user', 1), (18716, 1, 'member', 1), (18717, 1, 'member_add', 1), (18718, 1, 'member_edit', 1), (18719, 1, 'member_del', 1), (18720, 1, 'member_rep', 1), (18721, 1, 'member_active', 1), (18722, 1, 'logs', 1), (18723, 1, 'group', 1), (18724, 1, 'group_add', 1), (18725, 1, 'group_edit', 1), (18726, 1, 'group_del', 1), (18727, 1, 'group_permission', 1), (18728, 1, 'invoices', 1), (18729, 1, 'invoice_print', 1), (18730, 1, 'edit_price_in_inv', 0), (18731, 1, 'invoice_add', 1), (18732, 1, 'invoice_edit', 2), (18733, 1, 'invoice_del', 1), (18734, 1, 'edit_order_status', 1), (18735, 1, 'subscription', 1), (18736, 1, 'subs_print', 1), (18737, 1, 'expense', 1), (18738, 1, 'ex_add', 1), (18739, 1, 'ex_cat', 1), (18740, 1, 'ex_cat_add', 1), (18741, 1, 'ex_cat_edit', 1), (18742, 1, 'ex_cat_del', 1), (18743, 1, 'accountant', 1), (18744, 1, 'account_list', 1), (18745, 1, 'account_add', 1), (18746, 1, 'account_edit', 1), (18747, 1, 'account_del', 1), (18748, 1, 'attendance_module', 1), (18749, 1, 'product_attendance_add', 1), (18750, 1, 'product_attendance_list', 1), (18751, 1, 'attendance_add', 1), (18752, 1, 'show_attendance', 1), (18753, 1, 'attendance_del', 1), (18754, 1, 'announcement', 1), (18755, 1, 'announcement_add', 1), (18756, 1, 'announcement_edit', 1), (18757, 1, 'announcement_del', 1), (18758, 1, 'messages', 1), (18759, 1, 'messages_add', 1), (18760, 1, 'messages_edit', 1), (18761, 1, 'messages_del', 1), (18762, 1, 'data', 1), (18763, 1, 'data_add', 1), (18764, 1, 'data_edit', 1), (18765, 1, 'data_del', 1), (18766, 1, 'quraan_sessions_module', 1), (18767, 1, 'quraan_sessions', 1), (18768, 1, 'qs_add', 1), (18769, 1, 'qs_edit', 1), (18770, 1, 'qs_del', 1), (18771, 1, 'qs_show', 1), (18772, 1, 'session_add_recite', 1), (18773, 1, 'add_students', 1), (18774, 1, 'session_summary', 1), (18775, 1, 'session_delete_student', 1), (18776, 1, 'session_students', 1), (18777, 1, 'session_attendance', 1), (18778, 1, 'session_messages', 1), (18779, 1, 'teachers', 1), (18780, 1, 'teacher_add', 1), (18781, 1, 'teacher_edit', 1), (18782, 1, 'teacher_del', 1), (18783, 1, 'teacher_approve', 1), (18784, 1, 'sessions_plans', 1), (18785, 1, 'qs_plans_add', 1), (18786, 1, 'qs_plans_edit', 1), (18787, 1, 'qs_plans_del', 1), (18788, 1, 'call_center_module', 1), (18789, 1, 'call_add_order', 1), (18790, 1, 'call_show_orders', 1), (18791, 1, 'call_edit_order', 2), (18792, 1, 'call_delete_order', 1), (18793, 1, 'call_edit_order_status', 1), (18794, 1, 'supp_module', 1), (18795, 1, 'supp_add_ticket', 1), (18796, 1, 'supp_edit_ticket', 1), (18797, 1, 'supp_del_ticket', 1), (18798, 1, 'supp_add_reply', 1), (18799, 1, 'drivers_module', 1), (18800, 1, 'add_driver', 1), (18801, 1, 'edit_driver', 1), (18802, 1, 'delete_driver', 1), (18803, 1, 'drivers_data_control', 1), (18804, 1, 'knowledge_base_module', 1), (18805, 1, 'kw_add_guide', 1), (18806, 1, 'kw_edit_guide', 1), (18807, 1, 'kw_delete_guide', 1), (18808, 1, 'guide_categories', 1), (18809, 1, 'kw_add_category', 1), (18810, 1, 'kw_edit_category', 1), (18811, 1, 'kw_delete_category', 1), (18812, 1, 'kw_articles', 1), (18813, 1, 'kw_add_article', 1), (18814, 1, 'kw_edit_article', 1), (18815, 1, 'kw_delete_article', 1), (18816, 1, 'kw_comments', 1), (18817, 1, 'kw_delete_comment', 1), (18818, 1, 'pay_orders_module', 1), (18819, 1, 'add_pay_order', 1), (18820, 1, 'edit_pay_order', 1), (18821, 1, 'delete_pay_order', 1), (18822, 1, 'student_fields', 1), (18823, 1, 'accountant_report', 1), (18824, 1, 'sales_report', 1), (18825, 1, 'payment_report', 1), (18826, 1, 'drivers_report', 1), (18827, 1, 'setting', 1), (18828, 1, 'setting_edit', 1), (18829, 1, 'language', 1), (18830, 1, 'update', 1), (18831, 1, 'tables_export', 1), (18832, 1, 'points_module', 1), (18833, 1, 'points', 1), (18834, 1, 'points_add', 1), (18835, 1, 'points_deduct', 1), (18836, 1, 'awards', 1), (18837, 1, 'tags', 1), (18838, 1, 'tags_add', 1), (18839, 1, 'tags_edit', 1), (18840, 1, 'tags_del', 1), (18841, 1, 'points_ac', 1), (18842, 1, 'points_ac_add', 1), (18843, 1, 'points_ac_delete', 1), (18844, 1, 'points_ac_remove', 1), (18845, 1, 'category_ac', 1), (18846, 1, 'notes', 1), (18847, 1, 'discount', 1), (18848, 1, 'points_print', 1), (18849, 1, 'points_export', 1), (18850, 1, 'transaction', 1), (18851, 1, 'award', 1), (18852, 1, 'award_history', 1); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `p_id` int(11) NOT NULL, `name` text CHARACTER SET utf32 NOT NULL, `quantity` int(11) NOT NULL, `price` int(11) NOT NULL, `create_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `update_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `product_additions` -- CREATE TABLE `product_additions` ( `id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `title_en` varchar(100) NOT NULL, `title_ar` varchar(100) NOT NULL, `choice_type` int(11) NOT NULL COMMENT '0-->single,1-->multi', `required` tinyint(1) NOT NULL, `options` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `product_categories` -- CREATE TABLE `product_categories` ( `id` int(11) NOT NULL, `name` varchar(45) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `product_new` -- CREATE TABLE `product_new` ( `id` int(11) NOT NULL, `product` text CHARACTER SET utf32 NOT NULL, `quantity` int(11) NOT NULL, `price` int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `pts_award` -- CREATE TABLE `pts_award` ( `id` int(11) NOT NULL, `award_name` varchar(256) CHARACTER SET utf8 NOT NULL, `award_point` int(11) NOT NULL, `award_point_type` int(11) DEFAULT NULL, `award_status` int(11) NOT NULL DEFAULT 1, `aupdated_on` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pts_award` -- INSERT INTO `pts_award` (`id`, `award_name`, `award_point`, `award_point_type`, `award_status`, `aupdated_on`) VALUES (1, 'المشاركة في رحلة | 50', 50, 1, 1, '2020-02-09 08:08:46'), (2, 'يوم راحة | 150', 150, 1, 1, '2020-02-09 08:08:58'), (3, 'رفع تأخير | 50', 50, 1, 1, '2020-02-09 08:09:06'), (4, 'حرية لبس الزي | 50', 50, 1, 1, '2020-02-09 08:09:19'), (5, 'كوبون مشتريات | 50', 50, 1, 1, '2020-02-09 08:10:10'); -- -------------------------------------------------------- -- -- Table structure for table `pts_award_history` -- CREATE TABLE `pts_award_history` ( `id` int(11) NOT NULL, `member_id` int(11) DEFAULT NULL, `user_id` int(11) NOT NULL, `award_id` int(11) NOT NULL, `award_history_point` int(11) NOT NULL, `memo` text CHARACTER SET utf8 DEFAULT NULL, `award_status` int(11) NOT NULL DEFAULT 0, `h_update_on` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `pts_barcode` -- CREATE TABLE `pts_barcode` ( `id` mediumint(11) NOT NULL, `student_point` bigint(20) NOT NULL, `scan_code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `notes_id` int(11) NOT NULL, `student_code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `category_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `discount_reason` varchar(256) CHARACTER SET utf8 NOT NULL, `barcode` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `student_id` int(11) DEFAULT NULL, `member_id` int(11) DEFAULT NULL, `barcode_status` int(11) NOT NULL, `credit_date` date NOT NULL, `time` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pts_category` -- CREATE TABLE `pts_category` ( `id` int(11) NOT NULL, `category_name` varchar(256) CHARACTER SET utf8 NOT NULL, `category_type` varchar(256) NOT NULL, `points` int(11) DEFAULT NULL, `points_for` int(11) DEFAULT NULL, `category_slug` varchar(256) NOT NULL, `category_status` int(11) NOT NULL DEFAULT 1, `category_update` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `pts_student_history` -- CREATE TABLE `pts_student_history` ( `history_id` int(11) NOT NULL, `stud_id` int(11) NOT NULL, `type` int(11) NOT NULL, `points` int(11) NOT NULL, `balance` int(11) NOT NULL, `category` varchar(100) DEFAULT NULL, `notes` varchar(100) DEFAULT NULL, `discount` varchar(100) DEFAULT NULL, `award_id` int(11) DEFAULT NULL, `barcode_id` int(11) DEFAULT NULL, `member_id` int(11) DEFAULT NULL, `memo_notes` text CHARACTER SET utf8 DEFAULT NULL, `upload_filename` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `update_on` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `pts_tags` -- CREATE TABLE `pts_tags` ( `tag_id` int(11) NOT NULL, `user_type` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `tag_name` varchar(256) CHARACTER SET utf8 NOT NULL, `tagupdated_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `quraan_sessions` -- CREATE TABLE `quraan_sessions` ( `id` int(11) NOT NULL, `title` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `quraan_sessions_plans` -- CREATE TABLE `quraan_sessions_plans` ( `id` int(11) NOT NULL, `quraan_session_students_id` int(11) NOT NULL, `type` int(11) NOT NULL, `date_from` date NOT NULL, `date_to` date NOT NULL, `sessions_count_per_week` int(11) NOT NULL, `lines_count_per_session` float NOT NULL, `expected_lines_count` int(11) NOT NULL, `expected_page_count` float NOT NULL, `sessions_count` int(11) NOT NULL, `from_surah` int(11) NOT NULL, `from_ayah` int(11) NOT NULL, `to_surah` int(11) NOT NULL, `to_ayah` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `quraan_session_students` -- CREATE TABLE `quraan_session_students` ( `id` int(11) NOT NULL, `session_id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `quraan_session_teachers` -- CREATE TABLE `quraan_session_teachers` ( `id` int(11) NOT NULL, `session_id` int(11) NOT NULL, `teacher_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `quran_ayah` -- CREATE TABLE `quran_ayah` ( `id` int(11) NOT NULL, `surah_id` int(11) NOT NULL, `ayah_id` int(11) NOT NULL, `ayah_num` int(11) NOT NULL, `ayah_percentage` float NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `quran_ayah` -- -- -------------------------------------------------------- -- -- Table structure for table `quran_surah` -- CREATE TABLE `quran_surah` ( `id` int(3) NOT NULL, `arabic` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `localtion` varchar(1) COLLATE utf8_unicode_ci NOT NULL, `sajda` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `ayah` int(3) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `quran_surah` -- -- -------------------------------------------------------- -- -- Table structure for table `quran_tsme3` -- CREATE TABLE `quran_tsme3` ( `id` int(11) NOT NULL, `student` int(11) NOT NULL, `type` int(11) NOT NULL COMMENT '0 -> hfz,1->mrg3a,2->srd,3->tlawa,4->tlken', `from_surah` int(11) NOT NULL, `to_surah` int(11) NOT NULL, `from_ayah` int(11) NOT NULL, `to_ayah` int(11) NOT NULL, `evaluation` int(11) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp(), `pages_count` float DEFAULT NULL, `product_id` int(11) NOT NULL, `lines_count` float NOT NULL, `notes` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `rep` -- CREATE TABLE `rep` ( `id` int(12) UNSIGNED NOT NULL, `comment` text DEFAULT NULL, `user` int(11) DEFAULT 0, `date` varchar(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `setting` -- CREATE TABLE `setting` ( `setting_id` int(11) NOT NULL, `logo` varchar(256) NOT NULL, `company_title` varchar(256) NOT NULL, `company_address` varchar(256) NOT NULL, `company_email` varchar(200) NOT NULL, `company_mobile` varchar(100) DEFAULT NULL, `currency` int(100) NOT NULL, `facbook` varchar(256) DEFAULT NULL, `twitter` varchar(256) DEFAULT NULL, `google_plus` varchar(256) DEFAULT NULL, `instrgram` varchar(256) DEFAULT NULL, `meta_title` varchar(256) DEFAULT '0', `meta_keyword` text DEFAULT NULL, `meta_description` text CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `update_on` timestamp NOT NULL DEFAULT current_timestamp(), `customer_fields` text NOT NULL, `student_profile_customer_fields` text NOT NULL, `show_customer_fields` text NOT NULL, `student_can_edit_customer_fields` text NOT NULL, `tab_logo` varchar(300) NOT NULL, `invoice_logo` varchar(300) NOT NULL, `new_version` varchar(50) NOT NULL, `current_version` varchar(50) NOT NULL, `desc_version` text NOT NULL, `admin_default_lang` varchar(10) NOT NULL, `student_default_lang` varchar(10) NOT NULL, `inv_footer` text NOT NULL, `inv_footer_ar` text NOT NULL, `inv_footer_thermal` text NOT NULL, `inv_footer_thermal_ar` text NOT NULL, `inv_currency` varchar(45) NOT NULL, `sms_token` varchar(20) NOT NULL, `sms_on_new_order` tinyint(1) NOT NULL, `sms_on_in_delivery` tinyint(1) NOT NULL, `sms_on_order_canceled` tinyint(1) NOT NULL, `sms_on_preparing` tinyint(1) NOT NULL, `sms_on_delivered` tinyint(1) NOT NULL, `sms_on_payment_msg` tinyint(1) NOT NULL, `sms_on_pay_orders` tinyint(1) NOT NULL, `new_order_sms_content` text NOT NULL, `in_delivery_sms_content` text NOT NULL, `order_canceled_sms_content` text NOT NULL, `preparing_sms_content` text NOT NULL, `delivered_sms_content` text NOT NULL, `payment_msg_sms_content` text NOT NULL, `pay_orders_sms_content` text NOT NULL, `driver_fields_show` text NOT NULL, `driver_fields_edit` text NOT NULL, `expire_date` date DEFAULT NULL, `inv_type` tinyint(1) NOT NULL COMMENT '0->normal,1->thermal', `inv_lang` tinyint(1) NOT NULL COMMENT '0->eng,1->ar', `system_status` tinyint(1) NOT NULL, `terms_conditions_payment_page` text NOT NULL, `terms_conditions_payment_page_ar` text NOT NULL, `timezone` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `setting` -- INSERT INTO `setting` (`setting_id`, `logo`, `company_title`, `company_address`, `company_email`, `company_mobile`, `currency`, `facbook`, `twitter`, `google_plus`, `instrgram`, `meta_title`, `meta_keyword`, `meta_description`, `update_on`, `customer_fields`, `student_profile_customer_fields`, `show_customer_fields`, `student_can_edit_customer_fields`, `tab_logo`, `invoice_logo`, `new_version`, `current_version`, `desc_version`, `admin_default_lang`, `student_default_lang`, `inv_footer`, `inv_footer_ar`, `inv_footer_thermal`, `inv_footer_thermal_ar`, `inv_currency`, `sms_token`, `sms_on_new_order`, `sms_on_in_delivery`, `sms_on_order_canceled`, `sms_on_preparing`, `sms_on_delivered`, `sms_on_payment_msg`, `sms_on_pay_orders`, `new_order_sms_content`, `in_delivery_sms_content`, `order_canceled_sms_content`, `preparing_sms_content`, `delivered_sms_content`, `payment_msg_sms_content`, `pay_orders_sms_content`, `driver_fields_show`, `driver_fields_edit`, `expire_date`, `inv_type`, `inv_lang`, `system_status`, `terms_conditions_payment_page`, `terms_conditions_payment_page_ar`, `timezone`) VALUES (1, '', 'bills', 'الفواتير', 'kalmukaimi@hotmail.com', '027645', 0, 'https://www.facebook.com/', 'twitter', 'googleplus', 'instagram', '', '', '', '2021-10-26 03:10:04', 'username,cid_user,email,profile,imageuser', 'username,email,city,profile,imageuser', 'username,cid_user,email,phone,phone_father,country,city,blocks,street,jadah,building_num,floor,door_no,address_link,sex,note,profile,imageuser', 'email,profile,imageuser', 'زبيدي_الكويت111.png', 'زبيدي_الكويت11.PNG', '0.0.38', '0.0.38', 'multiaddresses', 'arabic', 'arabic', '1 -الالتزام بالآداب مع الزملاء والمدربین.. 
\r\n2-الالتزام بالأخلاقیات مع الزملاء. والمدربین.
\r\n 3 -دفع الرسوم بشكل منتظم.
\r\n 4 -الالتزام باللباس الشرعي.. 
\r\n5 - الالتزام في الحضور.
\r\n 6 - الغیاب بعذر', '1 -الالتزام بالآداب مع الزملاء والمدربین.. 
\r\n2-الالتزام بالأخلاقیات مع الزملاء. والمدربین.
\r\n 3 -دفع الرسوم بشكل منتظم.
\r\n 4 -الالتزام باللباس الشرعي.. 
\r\n5 - الالتزام في الحضور.
\r\n 6 - الغیاب بعذر', '
hh
', '
kk
', 'KWD', '27934a8645', 0, 0, 0, 1, 0, 0, 1, 'ff gggg dd%0acc', 'Thank you for ur%0asupport', '', 'قيد التحضير ..............{order_price}', 'شكرا {customer_name}%0a تم التسليم', 'يرجى الدفع لطلبك على الرابط التالى : {payment_link}', 'يرجى الدفع لطلبك على الرابط التالى : {payment_link} مبلغ {order_price}', 'name,phone,country', 'name', NULL, 1, 1, 1, '
English
', '
إخلاء مسؤولية معاملة الدفع:
1 – أقر بأن لدي الأهلية القانونية للقيام بمعاملة الدفع هذه، وقد قمت بالتحقق من تفاصيل معاملة الدفع الخاصة بي قبل إرسالها في تطبيق و/أوالموقع الإلكتروني ل Og Business.

2 – أتعهد بأنني المالك الشرعي للأموال التى يتم سدادها للمستفيد (التاجر / العميل بـ Og Business) ولدي القدرة والصلاحية لتنفيذ معاملة الدفع هذه. أتعهد أيضاً أن لدي الدراية الكاملة النافيه للجهاله بالمستفيد (التاجر / العميل بـ Og Business) وأن الأموال تُدفع لأغراض مشروعة قانوناً.
', 'Asia/Kuwait'); -- -------------------------------------------------------- -- -- Table structure for table `setting_permission` -- CREATE TABLE `setting_permission` ( `id` int(11) NOT NULL, `permission_name` varchar(100) NOT NULL, `permission_status` tinyint(1) NOT NULL, `permission_limit` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `setting_permission` -- INSERT INTO `setting_permission` (`id`, `permission_name`, `permission_status`, `permission_limit`) VALUES (1, 'sales', 1, 0), (2, 'products', 1, 0), (3, 'call_center', 1, 0), (4, 'drivers', 1, 0), (5, 'support', 1, 0), (6, 'attendance', 1, 0), (7, 'points', 1, 0), (8, 'quraan_sessions', 1, 0), (9, 'accountant', 1, 0), (10, 'language', 1, 0), (11, 'data_managment', 1, 0), (12, 'advs_msgs', 1, 0), (13, 'knowledge_base', 1, 0), (14, 'order_status', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `teachers` -- CREATE TABLE `teachers` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `phone` varchar(20) NOT NULL, `nationality` varchar(70) NOT NULL, `date_of_birth` date DEFAULT NULL, `pass` varchar(100) NOT NULL, `files` text NOT NULL, `notes` text NOT NULL, `approve_status` tinyint(1) NOT NULL, `student_tags` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tickets` -- CREATE TABLE `tickets` ( `id` int(11) NOT NULL, `title` varchar(100) NOT NULL, `desc` text NOT NULL, `priority` int(11) NOT NULL COMMENT '0->high,1->medium,2->low', `client_id` int(11) NOT NULL, `dept_id` int(11) NOT NULL, `type` int(11) NOT NULL COMMENT '0->inquiry,1->complaint,2->suggestion', `status` int(11) NOT NULL COMMENT '0->open,1->in progress,2->answered,3->on hold,4->closed', `created_by` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `last_reply_time` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tickets_reply` -- CREATE TABLE `tickets_reply` ( `id` int(11) NOT NULL, `created_by` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `reply` text NOT NULL, `ticket_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `operator_id` varchar(200) CHARACTER SET utf32 NOT NULL, `name` varchar(200) DEFAULT NULL, `pass` varchar(150) DEFAULT NULL, `email` varchar(150) DEFAULT NULL, `cid_no` int(50) NOT NULL, `sex` varchar(50) NOT NULL, `comm` text DEFAULT NULL, `gruop` int(10) DEFAULT 0, `Country` varchar(100) DEFAULT NULL, `BirthDate` varchar(50) DEFAULT NULL, `userInfo` text DEFAULT NULL, `role` text NOT NULL, `regdata` varchar(50) DEFAULT NULL, `reglog` varchar(50) DEFAULT NULL, `gruopu` int(10) DEFAULT 0, `myfov` text DEFAULT NULL, `mosma` varchar(100) DEFAULT NULL, `styleid` int(10) DEFAULT NULL, `allplay` int(10) DEFAULT NULL, `newpass` varchar(50) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `timeout` varchar(15) DEFAULT NULL, `approve_status` int(11) NOT NULL COMMENT '1->active,0->deactive', `teacher` tinyint(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `operator_id`, `name`, `pass`, `email`, `cid_no`, `sex`, `comm`, `gruop`, `Country`, `BirthDate`, `userInfo`, `role`, `regdata`, `reglog`, `gruopu`, `myfov`, `mosma`, `styleid`, `allplay`, `newpass`, `phone`, `timeout`, `approve_status`, `teacher`) VALUES (1, '1', 'khaled', '06f87f3682d81e8abbe03ca572c369bc', 'admin@crackerworld.in', 0, '', '|||

', 1, 'المملكة العربية السعودية', '13 / 8 / 1970', 'khaledss', '1', '1501706404', '1584098717', 0, '', '', 16, 314, '', '345445445', '0000', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `user_image` -- CREATE TABLE `user_image` ( `image_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `image` varchar(256) CHARACTER SET utf16 NOT NULL, `create_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `profile_pic` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `user_register` -- CREATE TABLE `user_register` ( `id` int(11) NOT NULL, `name` text CHARACTER SET utf32 NOT NULL, `email` varchar(200) CHARACTER SET utf32 NOT NULL, `phone` int(11) NOT NULL, `cid_no` int(11) NOT NULL, `sex` text NOT NULL, `country` text CHARACTER SET utf32 NOT NULL, `BirthDate` datetime NOT NULL, `create_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `additions` -- ALTER TABLE `additions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `addresses` -- ALTER TABLE `addresses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `announcement` -- ALTER TABLE `announcement` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bills` -- ALTER TABLE `bills` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bills_date` -- ALTER TABLE `bills_date` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bills_gyab` -- ALTER TABLE `bills_gyab` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bills_orders` -- ALTER TABLE `bills_orders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bills_producer` -- ALTER TABLE `bills_producer` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bills_setting` -- ALTER TABLE `bills_setting` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bills_user` -- ALTER TABLE `bills_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bills_user_admin` -- ALTER TABLE `bills_user_admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `datas` -- ALTER TABLE `datas` ADD PRIMARY KEY (`id`); -- -- Indexes for table `drivers` -- ALTER TABLE `drivers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expense` -- ALTER TABLE `expense` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expense_category` -- ALTER TABLE `expense_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `groups` -- ALTER TABLE `groups` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gyab` -- ALTER TABLE `gyab` ADD PRIMARY KEY (`sno`); -- -- Indexes for table `kw_articles` -- ALTER TABLE `kw_articles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `kw_article_comments` -- ALTER TABLE `kw_article_comments` ADD PRIMARY KEY (`id`), ADD KEY `fk_article_id` (`article_id`); -- -- Indexes for table `kw_article_rate` -- ALTER TABLE `kw_article_rate` ADD PRIMARY KEY (`id`), ADD KEY `article_id` (`article_id`); -- -- Indexes for table `kw_article_reply` -- ALTER TABLE `kw_article_reply` ADD PRIMARY KEY (`id`), ADD KEY `fk_article_id1` (`article_id`); -- -- Indexes for table `kw_categories` -- ALTER TABLE `kw_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `kw_parent_categories` -- ALTER TABLE `kw_parent_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `language` -- ALTER TABLE `language` ADD PRIMARY KEY (`id`); -- -- Indexes for table `logs` -- ALTER TABLE `logs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `model_billshawly` -- ALTER TABLE `model_billshawly` ADD PRIMARY KEY (`id`); -- -- Indexes for table `multi_orders` -- ALTER TABLE `multi_orders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `m_user` -- ALTER TABLE `m_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_products_additions` -- ALTER TABLE `order_products_additions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payment_orders` -- ALTER TABLE `payment_orders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payment_settings` -- ALTER TABLE `payment_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `permission` -- ALTER TABLE `permission` ADD PRIMARY KEY (`id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`p_id`); -- -- Indexes for table `product_additions` -- ALTER TABLE `product_additions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_categories` -- ALTER TABLE `product_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pts_award` -- ALTER TABLE `pts_award` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pts_award_history` -- ALTER TABLE `pts_award_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pts_barcode` -- ALTER TABLE `pts_barcode` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pts_category` -- ALTER TABLE `pts_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pts_student_history` -- ALTER TABLE `pts_student_history` ADD PRIMARY KEY (`history_id`); -- -- Indexes for table `pts_tags` -- ALTER TABLE `pts_tags` ADD PRIMARY KEY (`tag_id`), ADD KEY `task_id` (`user_id`), ADD KEY `tag_name` (`tag_name`(255)); -- -- Indexes for table `quraan_sessions` -- ALTER TABLE `quraan_sessions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `quraan_sessions_plans` -- ALTER TABLE `quraan_sessions_plans` ADD PRIMARY KEY (`id`); -- -- Indexes for table `quraan_session_students` -- ALTER TABLE `quraan_session_students` ADD PRIMARY KEY (`id`); -- -- Indexes for table `quraan_session_teachers` -- ALTER TABLE `quraan_session_teachers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `quran_ayah` -- ALTER TABLE `quran_ayah` ADD PRIMARY KEY (`id`); -- -- Indexes for table `quran_surah` -- ALTER TABLE `quran_surah` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `quran_tsme3` -- ALTER TABLE `quran_tsme3` ADD PRIMARY KEY (`id`); -- -- Indexes for table `rep` -- ALTER TABLE `rep` ADD PRIMARY KEY (`id`); -- -- Indexes for table `setting` -- ALTER TABLE `setting` ADD PRIMARY KEY (`setting_id`); -- -- Indexes for table `setting_permission` -- ALTER TABLE `setting_permission` ADD PRIMARY KEY (`id`); -- -- Indexes for table `teachers` -- ALTER TABLE `teachers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tickets` -- ALTER TABLE `tickets` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tickets_reply` -- ALTER TABLE `tickets_reply` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_image` -- ALTER TABLE `user_image` ADD PRIMARY KEY (`image_id`); -- -- Indexes for table `user_register` -- ALTER TABLE `user_register` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `additions` -- ALTER TABLE `additions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `addresses` -- ALTER TABLE `addresses` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- AUTO_INCREMENT for table `announcement` -- ALTER TABLE `announcement` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `bills` -- ALTER TABLE `bills` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bills_date` -- ALTER TABLE `bills_date` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bills_gyab` -- ALTER TABLE `bills_gyab` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bills_orders` -- ALTER TABLE `bills_orders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=115; -- -- AUTO_INCREMENT for table `bills_producer` -- ALTER TABLE `bills_producer` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `bills_setting` -- ALTER TABLE `bills_setting` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `bills_user` -- ALTER TABLE `bills_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `bills_user_admin` -- ALTER TABLE `bills_user_admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `datas` -- ALTER TABLE `datas` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99; -- -- AUTO_INCREMENT for table `drivers` -- ALTER TABLE `drivers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `expense` -- ALTER TABLE `expense` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `expense_category` -- ALTER TABLE `expense_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `groups` -- ALTER TABLE `groups` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `gyab` -- ALTER TABLE `gyab` MODIFY `sno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `kw_articles` -- ALTER TABLE `kw_articles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `kw_article_comments` -- ALTER TABLE `kw_article_comments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `kw_article_rate` -- ALTER TABLE `kw_article_rate` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `kw_article_reply` -- ALTER TABLE `kw_article_reply` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `kw_categories` -- ALTER TABLE `kw_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `kw_parent_categories` -- ALTER TABLE `kw_parent_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `language` -- ALTER TABLE `language` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=602; -- -- AUTO_INCREMENT for table `logs` -- ALTER TABLE `logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65; -- -- AUTO_INCREMENT for table `model_billshawly` -- ALTER TABLE `model_billshawly` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `multi_orders` -- ALTER TABLE `multi_orders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `m_user` -- ALTER TABLE `m_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54; -- -- AUTO_INCREMENT for table `order_products_additions` -- ALTER TABLE `order_products_additions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `payment_orders` -- ALTER TABLE `payment_orders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `payment_settings` -- ALTER TABLE `payment_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `permission` -- ALTER TABLE `permission` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18853; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `p_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product_additions` -- ALTER TABLE `product_additions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `product_categories` -- ALTER TABLE `product_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `pts_award` -- ALTER TABLE `pts_award` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `pts_award_history` -- ALTER TABLE `pts_award_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `pts_barcode` -- ALTER TABLE `pts_barcode` MODIFY `id` mediumint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `pts_category` -- ALTER TABLE `pts_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `pts_student_history` -- ALTER TABLE `pts_student_history` MODIFY `history_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `pts_tags` -- ALTER TABLE `pts_tags` MODIFY `tag_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `quraan_sessions` -- ALTER TABLE `quraan_sessions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `quraan_sessions_plans` -- ALTER TABLE `quraan_sessions_plans` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `quraan_session_students` -- ALTER TABLE `quraan_session_students` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `quraan_session_teachers` -- ALTER TABLE `quraan_session_teachers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `quran_ayah` -- ALTER TABLE `quran_ayah` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6237; -- -- AUTO_INCREMENT for table `quran_surah` -- ALTER TABLE `quran_surah` MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=115; -- -- AUTO_INCREMENT for table `quran_tsme3` -- ALTER TABLE `quran_tsme3` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `rep` -- ALTER TABLE `rep` MODIFY `id` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110; -- -- AUTO_INCREMENT for table `setting` -- ALTER TABLE `setting` MODIFY `setting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `setting_permission` -- ALTER TABLE `setting_permission` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `teachers` -- ALTER TABLE `teachers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tickets` -- ALTER TABLE `tickets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `tickets_reply` -- ALTER TABLE `tickets_reply` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `user_image` -- ALTER TABLE `user_image` MODIFY `image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; ALTER TABLE `bills_orders` ADD INDEX `order_user_id_index` (`id_orders`, `id_user`); -- -- AUTO_INCREMENT for table `user_register` -- ALTER TABLE `user_register` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;