--
-- Host: localhost    Database: abcmed_edu
-- ------------------------------------------------------


--
-- Current Database: `abcmed_edu`
--


--
-- Table structure for table `addons`
--

CREATE TABLE `addons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `unique_identifier` varchar(255) NOT NULL,
  `version` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `purchase_code` varchar(255) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `about` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `addons`
--


--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `address` longtext COLLATE utf8_unicode_ci,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8_unicode_ci,
  `document` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `applications`
--


--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `parent` int(11) DEFAULT '0',
  `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `font_awesome_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `code`, `name`, `parent`, `slug`, `date_added`, `last_modified`, `font_awesome_class`, `thumbnail`) VALUES (2,'e7c6d24eca','قسم فرعي',1,'قسم-فرعي',1623024000,NULL,NULL,NULL),(3,'cacffa694b','المحاسبة والمالية',0,'المحاسبة-والمالية',1623024000,NULL,'fas fa-chess','e1e8fcdac759a5ae729356b33bf5df42.jpg'),(4,'efed7ccfb7','إدارة الأعمال ',0,'إدارة-الأعمال',1623024000,NULL,'fas fa-chess','622d7fdfac102a8231061cd2ec851165.jpg'),(5,'dd4ebf0f49','الموارد البشرية',0,'الموارد-البشرية',1623024000,NULL,'fas fa-chess','bc70066a97ae253b80394eeaf40bd036.jpg'),(6,'ff097ef5c5','التسويق',0,'التسويق',1623024000,NULL,'fas fa-chess','40651e4b859226bb7912b124b01b5cec.jpg'),(7,'71a02c0b39','المحاسبة و المالية',3,'المحاسبة-و-المالية',1623024000,NULL,NULL,NULL),(8,'e06f967fb0','ادارة الاعمال',4,'ادارة-الاعمال',1623024000,NULL,NULL,NULL);

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ci_sessions`
--

INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('ed2babce99dd3cea2ae0c4235bed5899f0991b80','41.235.45.235',1623093193,_binary '__ci_last_regenerate|i:1623093192;cart_items|a:0:{}language|s:7:\"english\";'),('5e53733afda6cb542049c2e2560d36ab31f2084b','41.235.45.235',1623093193,_binary '__ci_last_regenerate|i:1623093192;cart_items|a:0:{}language|s:7:\"english\";'),('fc522d34bba449bd72fa9bb48a5b56708a4d253e','41.235.45.235',1623093589,_binary '__ci_last_regenerate|i:1623093589;cart_items|a:0:{}language|s:7:\"english\";'),('8bf178f817705aa66e8908de998a8c22c31ea9ec','41.235.45.235',1623093903,_binary '__ci_last_regenerate|i:1623093903;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";'),('3e25d8e9e8d843a7cb841385453a779f2a4c9f2a','41.235.45.235',1623094252,_binary '__ci_last_regenerate|i:1623094252;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";'),('0b2cbf1063e209ac14683f840cf5f9b3a0c982e3','41.235.45.235',1623094590,_binary '__ci_last_regenerate|i:1623094590;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";flash_message|s:12:\"Logo updated\";__ci_vars|a:1:{s:13:\"flash_message\";s:3:\"old\";}'),('5dd532d899879f2dc76e452ce4781c829515327b','41.235.45.235',1623095117,_binary '__ci_last_regenerate|i:1623095117;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";'),('f6d98fb022f395830fdccf01d3d7fee59e367c29','41.235.45.235',1623095441,_binary '__ci_last_regenerate|i:1623095441;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";'),('27c571c8750186a818ac8d9c152889715d66554d','41.235.45.235',1623095743,_binary '__ci_last_regenerate|i:1623095743;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";'),('614e889925484576cdeb262223ae6c930ebc7f6e','41.235.45.235',1623096056,_binary '__ci_last_regenerate|i:1623096056;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";'),('3de8c58adfb7d3c118e62ef9f21b19f9133999a4','41.235.45.235',1623096422,_binary '__ci_last_regenerate|i:1623096422;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";'),('a521fb0f0dfa03636377bc1928734c0eb558de3d','41.235.45.235',1623096755,_binary '__ci_last_regenerate|i:1623096755;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";'),('1e3d28a6e2d69502a89fa3dff28289066ca33c0a','41.235.45.235',1623097131,_binary '__ci_last_regenerate|i:1623097131;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;flash_message|s:40:\"Student has been enrolled to that course\";__ci_vars|a:1:{s:13:\"flash_message\";s:3:\"old\";}'),('d92495083e7935a68d9a9b13efc7a0d0dfd75d91','41.235.45.235',1623097354,_binary '__ci_last_regenerate|i:1623097354;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"2\";role_id|s:1:\"2\";role|s:4:\"User\";name|s:27:\"test@test.com test@test.com\";is_instructor|s:1:\"0\";user_login|s:1:\"1\";layout|s:4:\"list\";'),('8a6e37e06ef05ba2750dec124a797050a2f0e6c3','41.235.45.235',1623097479,_binary '__ci_last_regenerate|i:1623097479;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;'),('a24f3ec54619dcfaef8bdc24679938e50824164f','41.235.45.235',1623097678,_binary '__ci_last_regenerate|i:1623097678;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"2\";role_id|s:1:\"2\";role|s:4:\"User\";name|s:27:\"test@test.com test@test.com\";is_instructor|s:1:\"0\";user_login|s:1:\"1\";layout|s:4:\"list\";'),('84242946a0e5129b82e6245365b60cb60bc09fd5','41.235.45.235',1623097794,_binary '__ci_last_regenerate|i:1623097794;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;'),('8f01bc44c6d14b90076a48909bd202b03f201fff','41.235.45.235',1623097720,_binary '__ci_last_regenerate|i:1623097678;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"2\";role_id|s:1:\"2\";role|s:4:\"User\";name|s:27:\"test@test.com test@test.com\";is_instructor|s:1:\"0\";user_login|s:1:\"1\";layout|s:4:\"list\";'),('0cde80e15b2874a2274aa939166709a72e2212c8','41.235.45.235',1623098106,_binary '__ci_last_regenerate|i:1623098106;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;'),('0da90d352fa1a9d6e2737eb9a33fae506b09940b','41.235.45.235',1623097935,_binary '__ci_last_regenerate|i:1623097935;cart_items|a:0:{}language|s:7:\"english\";'),('3db56bd2d7b388e69f69d6804cf4df40a26bf954','41.235.45.235',1623097936,_binary '__ci_last_regenerate|i:1623097936;cart_items|a:0:{}language|s:7:\"english\";'),('0dade4ff13ced50ae5fd04b3bc4eceb48faa7aa5','196.132.113.14',1623099114,_binary '__ci_last_regenerate|i:1623099114;cart_items|a:0:{}language|s:7:\"english\";'),('b41e6f501df9af32003eee3dc752a81b59691516','41.235.45.235',1623098457,_binary '__ci_last_regenerate|i:1623098457;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;'),('00f2e487042afc6cf563e6a6862f625a79775c6d','41.235.45.235',1623098786,_binary '__ci_last_regenerate|i:1623098781;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;flash_message|s:34:\"Course has been added successfully\";__ci_vars|a:1:{s:13:\"flash_message\";s:3:\"new\";}'),('3a1cbd167fb14837d778236e5650dbb0d6d3cec3','41.235.45.235',1623099307,_binary '__ci_last_regenerate|i:1623099307;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;'),('58175bb6bdf8f7d9ee58f7c6d93fddabcb6a0fc6','41.235.45.235',1623098884,_binary '__ci_last_regenerate|i:1623098846;cart_items|a:0:{}language|s:7:\"english\";layout|s:4:\"list\";'),('1f48ac1b885a8f40fc981b042d2e4d58755e8ecd','196.132.113.14',1623099553,_binary '__ci_last_regenerate|i:1623099553;cart_items|a:0:{}language|s:7:\"english\";layout|s:4:\"list\";'),('8195cfdb6f9a6b75b4341f37e35960744a0c57ac','41.235.45.235',1623099651,_binary '__ci_last_regenerate|i:1623099651;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;'),('3bd89568d47c643fa80b4f2b4ce1c7cde7d334b0','196.132.113.14',1623099586,_binary '__ci_last_regenerate|i:1623099553;cart_items|a:0:{}language|s:7:\"english\";layout|s:4:\"list\";'),('95e6275c05321a1bcd8cb7e23ead99580d246f0c','41.235.45.235',1623100096,_binary '__ci_last_regenerate|i:1623100096;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;'),('906ba831d2016c76a3ee665c8bb07f3aa9bf90fc','41.235.45.235',1623100158,_binary '__ci_last_regenerate|i:1623100096;cart_items|a:1:{i:0;s:1:\"1\";}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";total_price_of_checking_out|i:1;'),('43b0da4c8c468a9a566c036c8583283a71a65928','197.60.191.189',1623107129,_binary '__ci_last_regenerate|i:1623107106;cart_items|a:0:{}language|s:7:\"english\";'),('24a70b0c80305bfe01a6917b387e85dfd122295a','197.60.191.189',1623108798,_binary '__ci_last_regenerate|i:1623108798;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";'),('667209ba438655f77c20dbdaa2b343990de8245c','41.187.114.4',1623108492,_binary '__ci_last_regenerate|i:1623108482;cart_items|a:0:{}language|s:7:\"english\";'),('4e84d870d88180c6e7325ae39757ecd09ba63852','41.187.114.4',1623108493,_binary '__ci_last_regenerate|i:1623108483;cart_items|a:0:{}language|s:7:\"english\";'),('7bd7b65120b95e7ad33bff09ba06820c52541253','197.60.191.189',1623108995,_binary '__ci_last_regenerate|i:1623108798;cart_items|a:0:{}language|s:7:\"english\";user_id|s:1:\"1\";role_id|s:1:\"1\";role|s:5:\"Admin\";name|s:9:\"Edu Admin\";is_instructor|s:1:\"0\";admin_login|s:1:\"1\";layout|s:4:\"list\";'),('f2188a07231df2002dea648cd59581f3e00708b6','197.60.191.189',1623136859,_binary '__ci_last_regenerate|i:1623136859;cart_items|a:0:{}language|s:7:\"english\";'),('4a6f8bb6ec6a04c1cab9139e627676fc22d77130','197.60.191.189',1623143768,_binary '__ci_last_regenerate|i:1623143768;cart_items|a:0:{}language|s:7:\"english\";'),('b2cfebabfc42f79e6227433deb0788faae480da5','197.60.191.189',1623143768,_binary '__ci_last_regenerate|i:1623143768;cart_items|a:0:{}language|s:7:\"english\";'),('4ff3c10e63aab3811da977518b60feb0b17ca7b4','41.235.45.235',1623239802,_binary '__ci_last_regenerate|i:1623239800;cart_items|a:0:{}language|s:7:\"english\";'),('f949209b700ff6024f7b14b66b85577b973f90e0','41.235.45.235',1623239804,_binary '__ci_last_regenerate|i:1623239804;cart_items|a:0:{}language|s:7:\"english\";'),('31ad0b1901570def5381a8a694ff4a5b858c43e2','41.235.45.235',1623239804,_binary '__ci_last_regenerate|i:1623239804;cart_items|a:0:{}language|s:7:\"english\";'),('0b777f227996511f4ef93e0780a29dcd372ac722','66.249.70.36',1653803102,_binary '__ci_last_regenerate|i:1653803087;cart_items|a:0:{}language|s:7:\"english\";'),('8a048a019d2ce07a1b218d6325c41fde32fe3c03','149.255.192.4',1655766025,_binary '__ci_last_regenerate|i:1655766001;cart_items|a:0:{}language|s:7:\"english\";');

--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `body` longtext COLLATE utf8_unicode_ci,
  `user_id` int(11) DEFAULT NULL,
  `commentable_id` int(11) DEFAULT NULL,
  `commentable_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `comment`
--


--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `short_description` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `outcomes` longtext COLLATE utf8_unicode_ci,
  `language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `sub_category_id` int(11) DEFAULT NULL,
  `section` longtext COLLATE utf8_unicode_ci,
  `requirements` longtext COLLATE utf8_unicode_ci,
  `price` double DEFAULT NULL,
  `discount_flag` int(11) DEFAULT '0',
  `discounted_price` int(11) DEFAULT NULL,
  `level` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `video_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `course_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_top_course` int(11) DEFAULT '0',
  `is_admin` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `course_overview_provider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_keywords` longtext COLLATE utf8_unicode_ci,
  `meta_description` longtext COLLATE utf8_unicode_ci,
  `is_free_course` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `course`
--

INSERT INTO `course` (`id`, `title`, `short_description`, `description`, `outcomes`, `language`, `category_id`, `sub_category_id`, `section`, `requirements`, `price`, `discount_flag`, `discounted_price`, `level`, `user_id`, `thumbnail`, `video_url`, `date_added`, `last_modified`, `course_type`, `is_top_course`, `is_admin`, `status`, `course_overview_provider`, `meta_keywords`, `meta_description`, `is_free_course`) VALUES (2,'الدورة التحضيرية لاختبار الزمالة للسعوديين للمحاسبين القانونيين سوكبا - مادة المحاسبة','الدورة التحضيرية لاختبار الزمالة السعودية للمحاسبين القانونين -م','<p><div class=\"price-course-single\" xss=removed></div></p><div class=\"description-single text clearfix\" xss=removed><p xss=removed>الدورة التحضيرية لاختبار الزمالة السعودية للمحاسبين القانونين -مادة المحاسبة - اونلاين قاعة الكترونية</p></div>','[\"1\",\"2\",\"3\"]','english',3,7,'[3,5]','[\"1\",\"2\",\"3\"]',5250,NULL,0,'beginner',1,NULL,'',1623024000,1623024000,'general',1,1,'active','','','',NULL),(3,'الدورة التحضيرية لاختبار الزمالة للسعوديين للمحاسبين القانونيين سوكبا - مادة المحاسبة','الدورة التحضيرية لاختبار الزمالة السعودية للمحاسبين القانونين -مادة المحاسبة - اونلاين قاعة الكترونية\r\n\r\n','<p>الدورة التحضيرية لاختبار الزمالة السعودية للمحاسبين القانونين -مادة المحاسبة - اونلاين قاعة الكترونية</p>','[\"1\",\"1\",\"1\"]','english',3,7,'[4]','[\"1\",\"1\",\"1\"]',0,NULL,0,'advanced',1,NULL,'',1623024000,1623024000,'general',1,1,'active','','','',1);

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `paypal_supported` int(11) DEFAULT NULL,
  `stripe_supported` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`id`, `name`, `code`, `symbol`, `paypal_supported`, `stripe_supported`) VALUES (1,'Leke','ALL','Lek',0,1),(2,'Dollars','USD','$',1,1),(3,'Afghanis','AFN','؋',0,1),(4,'Pesos','ARS','$',0,1),(5,'Guilders','AWG','ƒ',0,1),(6,'Dollars','AUD','$',1,1),(7,'New Manats','AZN','ман',0,1),(8,'Dollars','BSD','$',0,1),(9,'Dollars','BBD','$',0,1),(10,'Rubles','BYR','p.',0,0),(11,'Euro','EUR','€',1,1),(12,'Dollars','BZD','BZ$',0,1),(13,'Dollars','BMD','$',0,1),(14,'Bolivianos','BOB','$b',0,1),(15,'Convertible Marka','BAM','KM',0,1),(16,'Pula','BWP','P',0,1),(17,'Leva','BGN','лв',0,1),(18,'Reais','BRL','R$',1,1),(19,'Pounds','GBP','£',1,1),(20,'Dollars','BND','$',0,1),(21,'Riels','KHR','៛',0,1),(22,'Dollars','CAD','$',1,1),(23,'Dollars','KYD','$',0,1),(24,'Pesos','CLP','$',0,1),(25,'Yuan Renminbi','CNY','¥',0,1),(26,'Pesos','COP','$',0,1),(27,'Colón','CRC','₡',0,1),(28,'Kuna','HRK','kn',0,1),(29,'Pesos','CUP','₱',0,0),(30,'Koruny','CZK','Kč',1,1),(31,'Kroner','DKK','kr',1,1),(32,'Pesos','DOP ','RD$',0,1),(33,'Dollars','XCD','$',0,1),(34,'Pounds','EGP','£',0,1),(35,'Colones','SVC','$',0,0),(36,'Pounds','FKP','£',0,1),(37,'Dollars','FJD','$',0,1),(38,'Cedis','GHC','¢',0,0),(39,'Pounds','GIP','£',0,1),(40,'Quetzales','GTQ','Q',0,1),(41,'Pounds','GGP','£',0,0),(42,'Dollars','GYD','$',0,1),(43,'Lempiras','HNL','L',0,1),(44,'Dollars','HKD','$',1,1),(45,'Forint','HUF','Ft',1,1),(46,'Kronur','ISK','kr',0,1),(47,'Rupees','INR','₹',1,1),(48,'Rupiahs','IDR','Rp',0,1),(49,'Rials','IRR','﷼',0,0),(50,'Pounds','IMP','£',0,0),(51,'New Shekels','ILS','₪',1,1),(52,'Dollars','JMD','J$',0,1),(53,'Yen','JPY','¥',1,1),(54,'Pounds','JEP','£',0,0),(55,'Tenge','KZT','лв',0,1),(56,'Won','KPW','₩',0,0),(57,'Won','KRW','₩',0,1),(58,'Soms','KGS','лв',0,1),(59,'Kips','LAK','₭',0,1),(60,'Lati','LVL','Ls',0,0),(61,'Pounds','LBP','£',0,1),(62,'Dollars','LRD','$',0,1),(63,'Switzerland Francs','CHF','CHF',1,1),(64,'Litai','LTL','Lt',0,0),(65,'Denars','MKD','ден',0,1),(66,'Ringgits','MYR','RM',1,1),(67,'Rupees','MUR','₨',0,1),(68,'Pesos','MXN','$',1,1),(69,'Tugriks','MNT','₮',0,1),(70,'Meticais','MZN','MT',0,1),(71,'Dollars','NAD','$',0,1),(72,'Rupees','NPR','₨',0,1),(73,'Guilders','ANG','ƒ',0,1),(74,'Dollars','NZD','$',1,1),(75,'Cordobas','NIO','C$',0,1),(76,'Nairas','NGN','₦',0,1),(77,'Krone','NOK','kr',1,1),(78,'Rials','OMR','﷼',0,0),(79,'Rupees','PKR','₨',0,1),(80,'Balboa','PAB','B/.',0,1),(81,'Guarani','PYG','Gs',0,1),(82,'Nuevos Soles','PEN','S/.',0,1),(83,'Pesos','PHP','Php',1,1),(84,'Zlotych','PLN','zł',1,1),(85,'Rials','QAR','﷼',0,1),(86,'New Lei','RON','lei',0,1),(87,'Rubles','RUB','руб',1,1),(88,'Pounds','SHP','£',0,1),(89,'Riyals','SAR','﷼',0,1),(90,'Dinars','RSD','Дин.',0,1),(91,'Rupees','SCR','₨',0,1),(92,'Dollars','SGD','$',1,1),(93,'Dollars','SBD','$',0,1),(94,'Shillings','SOS','S',0,1),(95,'Rand','ZAR','R',0,1),(96,'Rupees','LKR','₨',0,1),(97,'Kronor','SEK','kr',1,1),(98,'Dollars','SRD','$',0,1),(99,'Pounds','SYP','£',0,0),(100,'New Dollars','TWD','NT$',1,1),(101,'Baht','THB','฿',1,1),(102,'Dollars','TTD','TT$',0,1),(103,'Lira','TRY','TL',0,1),(104,'Liras','TRL','£',0,0),(105,'Dollars','TVD','$',0,0),(106,'Hryvnia','UAH','₴',0,1),(107,'Pesos','UYU','$U',0,1),(108,'Sums','UZS','лв',0,1),(109,'Bolivares Fuertes','VEF','Bs',0,0),(110,'Dong','VND','₫',0,1),(111,'Rials','YER','﷼',0,1),(112,'Zimbabwe Dollars','ZWD','Z$',0,0);

--
-- Table structure for table `enrol`
--

CREATE TABLE `enrol` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `enrol`
--

INSERT INTO `enrol` (`id`, `user_id`, `course_id`, `date_added`, `last_modified`) VALUES (1,2,1,1623024000,NULL);

--
-- Table structure for table `frontend_settings`
--

CREATE TABLE `frontend_settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `frontend_settings`
--

INSERT INTO `frontend_settings` (`id`, `key`, `value`) VALUES (1,'banner_title','Professional Road Training Center'),(2,'banner_sub_title','Professional Road Training Center'),(4,'about_us','<p></p><h2><span xss=removed>This is about us</span></h2><p><span xss=\"removed\">Welcome to Academy. It will help you to learn in a new ways</span></p>'),(10,'terms_and_condition','<h2>Terms and Condition</h2>This is the Terms and condition page for your companys'),(11,'privacy_policy','<p></p><p></p><h2><span xss=\"removed\">Privacy Policy</span><br></h2>This is the Privacy Policy page for your companys<p></p><p><b>This is another</b> <u><a href=\"https://youtube.com/watch?v=PHgc8Q6qTjc\" target=\"_blank\">thing you will</a></u> <span xss=\"removed\">not understand</span>.</p>'),(13,'theme','firdaus'),(14,'cookie_note','Professional Road Training Center'),(15,'cookie_status','active'),(16,'cookie_policy','<h1>Cookie policy</h1><ol><li>Cookies are small text files that can be used by websites to make a user\'s experience more efficient.</li><li>The law states that we can store cookies on your device if they are strictly necessary for the operation of this site. For all other types of cookies we need your permission.</li><li>This site uses different types of cookies. Some cookies are placed by third party services that appear on our pages.</li></ol>'),(17,'banner_image','home-banner.jpg'),(18,'light_logo','cfa31d8130bef0e6643e5de9d0a0cac9.png'),(19,'dark_logo','114fcbf3577ccfa2149da446c5227564.png'),(20,'small_logo','594b8b3aac1df65638a4cdcd8f627666.png'),(21,'favicon','5fc29776ab1f0b19e4e78a154adcda53.png'),(22,'recaptcha_status','0'),(23,'recaptcha_secretkey','recaptcha-secretkey'),(24,'recaptcha_sitekey','recaptcha-sitekey');

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `phrase_id` int(11) NOT NULL AUTO_INCREMENT,
  `phrase` longtext COLLATE utf8_unicode_ci,
  `english` longtext COLLATE utf8_unicode_ci,
  `Bengali` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`phrase_id`)
) ENGINE=MyISAM AUTO_INCREMENT=594 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `language`
--



--
-- Table structure for table `lesson`
--

CREATE TABLE `lesson` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `duration` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `video_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `video_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `lesson_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attachment` longtext COLLATE utf8_unicode_ci,
  `attachment_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `summary` longtext COLLATE utf8_unicode_ci,
  `order` int(11) NOT NULL DEFAULT '0',
  `video_type_for_mobile_application` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `video_url_for_mobile_application` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `duration_for_mobile_application` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lesson`
--

INSERT INTO `lesson` (`id`, `title`, `duration`, `course_id`, `section_id`, `video_type`, `video_url`, `date_added`, `last_modified`, `lesson_type`, `attachment`, `attachment_type`, `summary`, `order`, `video_type_for_mobile_application`, `video_url_for_mobile_application`, `duration_for_mobile_application`) VALUES (3,'لا','00:00:00',2,5,NULL,NULL,1623024000,1623024000,'quiz',NULL,NULL,'1',0,NULL,NULL,NULL),(4,'نعم','00:00:00',2,5,NULL,NULL,1623024000,NULL,'quiz',NULL,NULL,'',0,NULL,NULL,NULL),(5,'غير متاكد','00:00:00',2,5,NULL,NULL,1623024000,NULL,'quiz',NULL,NULL,'',0,NULL,NULL,NULL);

--
-- Table structure for table `log`
--

CREATE TABLE `log` (
  `id` int(11) NOT NULL,
  `from` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `log`
--


--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_thread_code` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `message` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sender` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `read_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `message`
--


--
-- Table structure for table `message_thread`
--

CREATE TABLE `message_thread` (
  `message_thread_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_thread_code` longtext COLLATE utf8_unicode_ci,
  `sender` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `receiver` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `last_message_timestamp` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`message_thread_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `message_thread`
--


--
-- Table structure for table `payout`
--

CREATE TABLE `payout` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `payment_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payout`
--


--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `quiz_id` int(11) DEFAULT NULL,
  `title` longtext COLLATE utf8_unicode_ci,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `number_of_options` int(11) DEFAULT NULL,
  `options` longtext COLLATE utf8_unicode_ci,
  `correct_answers` longtext COLLATE utf8_unicode_ci,
  `order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `question`
--

INSERT INTO `question` (`id`, `quiz_id`, `title`, `type`, `number_of_options`, `options`, `correct_answers`, `order`) VALUES (1,2,'quiz ===== 3','multiple_choice',4,'[\"1\",\"2\",\"3\",\"4\"]','[\"3\"]',0),(2,2,'quiz ====== 1','multiple_choice',3,'[\"3\",\"1\",\"2\"]','[\"2\"]',0);

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `rating` double DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ratable_id` int(11) DEFAULT NULL,
  `ratable_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `review` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rating`
--


--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`id`, `name`, `date_added`, `last_modified`) VALUES (1,'Admin',1234567890,1234567890),(2,'User',1234567890,1234567890);

--
-- Table structure for table `section`
--

CREATE TABLE `section` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `section`
--

INSERT INTO `section` (`id`, `title`, `course_id`, `order`) VALUES (3,'section',2,0),(4,'section',3,0),(5,'اسئلة واحد',2,0);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `settings`
--



--
-- Table structure for table `tag`
--

CREATE TABLE `tag` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tagable_id` int(11) DEFAULT NULL,
  `tagable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tag`
--


--
-- Dumping events for database 'abcmed_edu'
--

--
-- Dumping routines for database 'abcmed_edu'
--


