--
-- Host: localhost    Database: aigurue5n4f3_LMS
-- ------------------------------------------------------


--
-- 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,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `about` longtext DEFAULT NULL,
  `purchase_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 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 DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `document` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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


--
-- Table structure for table `badges`
--

CREATE TABLE `badges` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `condition_from` int(11) DEFAULT NULL,
  `condition_to` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` varchar(100) NOT NULL,
  `updated_at` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `badges`
--


--
-- Table structure for table `bbb_meetings`
--

CREATE TABLE `bbb_meetings` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL,
  `meeting_id` varchar(255) DEFAULT NULL,
  `moderator_pw` varchar(255) DEFAULT NULL,
  `viewer_pw` varchar(255) DEFAULT NULL,
  `instructions` longtext DEFAULT NULL,
  `created_at` varchar(100) DEFAULT NULL,
  `updated_at` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `bbb_meetings`
--


--
-- Table structure for table `blog_category`
--

CREATE TABLE `blog_category` (
  `blog_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `added_date` varchar(100) NOT NULL,
  PRIMARY KEY (`blog_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `blog_category`
--


--
-- Table structure for table `blog_comments`
--

CREATE TABLE `blog_comments` (
  `blog_comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `comment` longtext NOT NULL,
  `likes` longtext NOT NULL,
  `added_date` varchar(100) NOT NULL,
  `updated_date` varchar(100) NOT NULL,
  PRIMARY KEY (`blog_comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `blog_comments`
--


--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `blog_id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_category_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `keywords` text NOT NULL,
  `description` longtext NOT NULL,
  `thumbnail` varchar(100) NOT NULL,
  `banner` varchar(100) NOT NULL,
  `is_popular` int(11) NOT NULL,
  `likes` longtext NOT NULL,
  `added_date` varchar(100) NOT NULL,
  `updated_date` varchar(100) NOT NULL,
  `status` varchar(50) NOT NULL,
  PRIMARY KEY (`blog_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `blogs`
--


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

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

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


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

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

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

INSERT INTO `ci_sessions` VALUES
('1ead04741fde1f749f9fe2a4253c443b540e7ebd','103.4.251.35',1771249490,'__ci_last_regenerate|i:1771249490;countCall|i:1;__ci_vars|a:1:{s:9:\"countCall\";s:3:\"new\";}cart_items|a:0:{}language|s:7:\"english\";'),
('e721d7380ff3f663278c606700d7f340d3a8f811','107.172.195.218',1771252114,'__ci_last_regenerate|i:1771252114;countCall|i:1;__ci_vars|a:1:{s:9:\"countCall\";s:3:\"new\";}cart_items|a:0:{}language|s:7:\"english\";'),
('251c71f12f47b4343c425e2623ce2bb1e15a67da','102.182.46.51',1772020578,'__ci_last_regenerate|i:1771277985;cart_items|a:0:{}language|s:7:\"english\";countCall|i:1;__ci_vars|a:1:{s:9:\"countCall\";s:3:\"old\";}'),
('145a7d5c4ecc05f69a61485b8b3113f0fb48480a','102.182.46.51',1772061158,'__ci_last_regenerate|i:1771882170;cart_items|a:0:{}language|s:7:\"english\";countCall|i:1;__ci_vars|a:1:{s:9:\"countCall\";s:3:\"old\";}');

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

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

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


--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(21) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `has_read` int(11) DEFAULT NULL,
  `replied` int(11) DEFAULT NULL,
  `created_at` varchar(100) DEFAULT NULL,
  `updated_at` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `contact`
--


--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `discount_percentage` varchar(255) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `expiry_date` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `coupons`
--


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

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `short_description` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `outcomes` longtext DEFAULT NULL,
  `faqs` text NOT NULL,
  `language` varchar(255) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `sub_category_id` int(11) DEFAULT NULL,
  `section` longtext DEFAULT NULL,
  `requirements` longtext DEFAULT NULL,
  `price` double DEFAULT NULL,
  `discount_flag` int(11) DEFAULT 0,
  `discounted_price` double DEFAULT NULL,
  `level` varchar(50) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `course_type` varchar(255) DEFAULT NULL,
  `is_top_course` int(11) DEFAULT 0,
  `is_admin` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `course_overview_provider` varchar(255) DEFAULT NULL,
  `meta_keywords` longtext DEFAULT NULL,
  `meta_description` longtext DEFAULT NULL,
  `is_free_course` int(11) DEFAULT NULL,
  `multi_instructor` int(11) NOT NULL DEFAULT 0,
  `enable_drip_content` int(11) NOT NULL,
  `creator` int(11) DEFAULT NULL,
  `expiry_period` int(11) DEFAULT NULL,
  `upcoming_image_thumbnail` varchar(255) DEFAULT NULL,
  `publish_date` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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


--
-- 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,
  `ccavenue_supported` int(11) DEFAULT 0,
  `iyzico_supported` int(11) DEFAULT 0,
  `paystack_supported` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `currency` VALUES
(1,'US Dollar','USD','$',1,1,0,0,0),
(2,'Albanian Lek','ALL','Lek',0,1,0,0,0),
(3,'Algerian Dinar','DZD','دج',1,1,0,0,0),
(4,'Angolan Kwanza','AOA','Kz',1,1,0,0,0),
(5,'Argentine Peso','ARS','$',1,1,0,0,0),
(6,'Armenian Dram','AMD','֏',1,1,0,0,0),
(7,'Aruban Florin','AWG','ƒ',1,1,0,0,0),
(8,'Australian Dollar','AUD','$',1,1,0,0,0),
(9,'Azerbaijani Manat','AZN','m',1,1,0,0,0),
(10,'Bahamian Dollar','BSD','B$',1,1,0,0,0),
(11,'Bahraini Dinar','BHD','.د.ب',1,1,0,0,0),
(12,'Bangladeshi Taka','BDT','৳',1,1,0,0,0),
(13,'Barbadian Dollar','BBD','Bds$',1,1,0,0,0),
(14,'Belarusian Ruble','BYR','Br',0,0,0,0,0),
(15,'Belgian Franc','BEF','fr',1,1,0,0,0),
(16,'Belize Dollar','BZD','$',1,1,0,0,0),
(17,'Bermudan Dollar','BMD','$',1,1,0,0,0),
(18,'Bhutanese Ngultrum','BTN','Nu.',1,1,0,0,0),
(19,'Bitcoin','BTC','฿',1,1,0,0,0),
(20,'Bolivian Boliviano','BOB','Bs.',1,1,0,0,0),
(21,'Bosnia','BAM','KM',1,1,0,0,0),
(22,'Botswanan Pula','BWP','P',1,1,0,0,0),
(23,'Brazilian Real','BRL','R$',1,1,0,0,0),
(24,'British Pound Sterling','GBP','£',1,1,0,0,0),
(25,'Brunei Dollar','BND','B$',1,1,0,0,0),
(26,'Bulgarian Lev','BGN','Лв.',1,1,0,0,0),
(27,'Burundian Franc','BIF','FBu',1,1,0,0,0),
(28,'Cambodian Riel','KHR','KHR',1,1,0,0,0),
(29,'Canadian Dollar','CAD','$',1,1,0,0,0),
(30,'Cape Verdean Escudo','CVE','$',1,1,0,0,0),
(31,'Cayman Islands Dollar','KYD','$',1,1,0,0,0),
(32,'CFA Franc BCEAO','XOF','CFA',1,1,0,0,0),
(33,'CFA Franc BEAC','XAF','FCFA',1,1,0,0,0),
(34,'CFP Franc','XPF','₣',1,1,0,0,0),
(35,'Chilean Peso','CLP','$',1,1,0,0,0),
(36,'Chinese Yuan','CNY','¥',1,1,0,0,0),
(37,'Colombian Peso','COP','$',1,1,0,0,0),
(38,'Comorian Franc','KMF','CF',1,1,0,0,0),
(39,'Congolese Franc','CDF','FC',1,1,0,0,0),
(40,'Costa Rican ColÃ³n','CRC','₡',1,1,0,0,0),
(41,'Croatian Kuna','HRK','kn',1,1,0,0,0),
(42,'Cuban Convertible Peso','CUC','$, CUC',1,1,0,0,0),
(43,'Czech Republic Koruna','CZK','Kč',1,1,0,0,0),
(44,'Danish Krone','DKK','Kr.',1,1,0,0,0),
(45,'Djiboutian Franc','DJF','Fdj',1,1,0,0,0),
(46,'Dominican Peso','DOP','$',1,1,0,0,0),
(47,'East Caribbean Dollar','XCD','$',1,1,0,0,0),
(48,'Egyptian Pound','EGP','ج.م',1,1,0,0,0),
(49,'Eritrean Nakfa','ERN','Nfk',1,1,0,0,0),
(50,'Estonian Kroon','EEK','kr',1,1,0,0,0),
(51,'Ethiopian Birr','ETB','Nkf',1,1,0,0,0),
(52,'Euro','EUR','€',1,1,0,0,0),
(53,'Falkland Islands Pound','FKP','£',1,1,0,0,0),
(54,'Fijian Dollar','FJD','FJ$',1,1,0,0,0),
(55,'Gambian Dalasi','GMD','D',1,1,0,0,0),
(56,'Georgian Lari','GEL','ლ',1,1,0,0,0),
(57,'German Mark','DEM','DM',1,1,0,0,0),
(58,'Ghanaian Cedi','GHS','GH₵',1,1,0,0,0),
(59,'Gibraltar Pound','GIP','£',1,1,0,0,0),
(60,'Greek Drachma','GRD','₯, Δρχ, Δρ',1,1,0,0,0),
(61,'Guatemalan Quetzal','GTQ','Q',1,1,0,0,0),
(62,'Guinean Franc','GNF','FG',1,1,0,0,0),
(63,'Guyanaese Dollar','GYD','$',1,1,0,0,0),
(64,'Haitian Gourde','HTG','G',1,1,0,0,0),
(65,'Honduran Lempira','HNL','L',1,1,0,0,0),
(66,'Hong Kong Dollar','HKD','$',1,1,0,0,0),
(67,'Hungarian Forint','HUF','Ft',1,1,0,0,0),
(68,'Icelandic KrÃ³na','ISK','kr',1,1,0,0,0),
(69,'Indian Rupee','INR','₹',1,1,1,0,0),
(70,'Indonesian Rupiah','IDR','Rp',1,1,0,0,0),
(71,'Iranian Rial','IRR','﷼',1,1,0,0,0),
(72,'Iraqi Dinar','IQD','د.ع',1,1,0,0,0),
(73,'Israeli New Sheqel','ILS','₪',1,1,0,0,0),
(74,'Italian Lira','ITL','L,£',1,1,0,0,0),
(75,'Jamaican Dollar','JMD','J$',1,1,0,0,0),
(76,'Japanese Yen','JPY','¥',1,1,0,0,0),
(77,'Jordanian Dinar','JOD','ا.د',1,1,0,0,0),
(78,'Kazakhstani Tenge','KZT','лв',1,1,0,0,0),
(79,'Kenyan Shilling','KES','KSh',1,1,0,0,0),
(80,'Kuwaiti Dinar','KWD','ك.د',1,1,0,0,0),
(81,'Kyrgystani Som','KGS','лв',1,1,0,0,0),
(82,'Laotian Kip','LAK','₭',1,1,0,0,0),
(83,'Latvian Lats','LVL','Ls',0,0,0,0,0),
(84,'Lebanese Pound','LBP','£',1,1,0,0,0),
(85,'Lesotho Loti','LSL','L',1,1,0,0,0),
(86,'Liberian Dollar','LRD','$',1,1,0,0,0),
(87,'Libyan Dinar','LYD','د.ل',1,1,0,0,0),
(88,'Lithuanian Litas','LTL','Lt',0,0,0,0,0),
(89,'Macanese Pataca','MOP','$',1,1,0,0,0),
(90,'Macedonian Denar','MKD','ден',1,1,0,0,0),
(91,'Malagasy Ariary','MGA','Ar',1,1,0,0,0),
(92,'Malawian Kwacha','MWK','MK',1,1,0,0,0),
(93,'Malaysian Ringgit','MYR','RM',1,1,0,0,0),
(94,'Maldivian Rufiyaa','MVR','Rf',1,1,0,0,0),
(95,'Mauritanian Ouguiya','MRO','MRU',1,1,0,0,0),
(96,'Mauritian Rupee','MUR','₨',1,1,0,0,0),
(97,'Mexican Peso','MXN','$',1,1,0,0,0),
(98,'Moldovan Leu','MDL','L',1,1,0,0,0),
(99,'Mongolian Tugrik','MNT','₮',1,1,0,0,0),
(100,'Moroccan Dirham','MAD','MAD',1,1,0,0,0),
(101,'Mozambican Metical','MZM','MT',1,1,0,0,0),
(102,'Myanmar Kyat','MMK','K',1,1,0,0,0),
(103,'Namibian Dollar','NAD','$',1,1,0,0,0),
(104,'Nepalese Rupee','NPR','₨',1,1,0,0,0),
(105,'Netherlands Antillean Guilder','ANG','ƒ',1,1,0,0,0),
(106,'New Taiwan Dollar','TWD','$',1,1,0,0,0),
(107,'New Zealand Dollar','NZD','$',1,1,0,0,0),
(108,'Nicaraguan CÃ³rdoba','NIO','C$',1,1,0,0,0),
(109,'Nigerian Naira','NGN','₦',1,1,0,0,1),
(110,'North Korean Won','KPW','₩',0,0,0,0,0),
(111,'Norwegian Krone','NOK','kr',1,1,0,0,0),
(112,'Omani Rial','OMR','.ع.ر',0,0,0,0,0),
(113,'Pakistani Rupee','PKR','₨',1,1,0,0,0),
(114,'Panamanian Balboa','PAB','B/.',1,1,0,0,0),
(115,'Papua New Guinean Kina','PGK','K',1,1,0,0,0),
(116,'Paraguayan Guarani','PYG','₲',1,1,0,0,0),
(117,'Peruvian Nuevo Sol','PEN','S/.',1,1,0,0,0),
(118,'Philippine Peso','PHP','₱',1,1,0,0,0),
(119,'Polish Zloty','PLN','zł',1,1,0,0,0),
(120,'Qatari Rial','QAR','ق.ر',1,1,0,0,0),
(121,'Romanian Leu','RON','lei',1,1,0,0,0),
(122,'Russian Ruble','RUB','₽',1,1,0,0,0),
(123,'Rwandan Franc','RWF','FRw',1,1,0,0,0),
(124,'Salvadoran ColÃ³n','SVC','₡',0,0,0,0,0),
(125,'Samoan Tala','WST','SAT',1,1,0,0,0),
(126,'Saudi Riyal','SAR','﷼',1,1,0,0,0),
(127,'Serbian Dinar','RSD','din',1,1,0,0,0),
(128,'Seychellois Rupee','SCR','SRe',1,1,0,0,0),
(129,'Sierra Leonean Leone','SLL','Le',1,1,0,0,0),
(130,'Singapore Dollar','SGD','$',1,1,0,0,0),
(131,'Slovak Koruna','SKK','Sk',1,1,0,0,0),
(132,'Solomon Islands Dollar','SBD','Si$',1,1,0,0,0),
(133,'Somali Shilling','SOS','Sh.so.',1,1,0,0,0),
(134,'South African Rand','ZAR','R',1,1,0,0,0),
(135,'South Korean Won','KRW','₩',1,1,0,0,0),
(136,'Special Drawing Rights','XDR','SDR',1,1,0,0,0),
(137,'Sri Lankan Rupee','LKR','Rs',1,1,0,0,0),
(138,'St. Helena Pound','SHP','£',1,1,0,0,0),
(139,'Sudanese Pound','SDG','.س.ج',1,1,0,0,0),
(140,'Surinamese Dollar','SRD','$',1,1,0,0,0),
(141,'Swazi Lilangeni','SZL','E',1,1,0,0,0),
(142,'Swedish Krona','SEK','kr',1,1,0,0,0),
(143,'Swiss Franc','CHF','CHf',1,1,0,0,0),
(144,'Syrian Pound','SYP','LS',0,0,0,0,0),
(145,'São Tomé and Príncipe Dobra','STD','Db',1,1,0,0,0),
(146,'Tajikistani Somoni','TJS','SM',1,1,0,0,0),
(147,'Tanzanian Shilling','TZS','TSh',1,1,0,0,0),
(148,'Thai Baht','THB','฿',1,1,0,0,0),
(149,'Tongan pa\'anga','TOP','$',1,1,0,0,0),
(150,'Trinidad & Tobago Dollar','TTD','$',1,1,0,0,0),
(151,'Tunisian Dinar','TND','ت.د',1,1,0,0,0),
(152,'Turkish Lira','TRY','₺',1,1,0,1,0),
(153,'Turkmenistani Manat','TMT','T',1,1,0,0,0),
(154,'Ugandan Shilling','UGX','USh',1,1,0,0,0),
(155,'Ukrainian Hryvnia','UAH','₴',1,1,0,0,0),
(156,'United Arab Emirates Dirham','AED','إ.د',1,1,0,0,0),
(157,'Uruguayan Peso','UYU','$',1,1,0,0,0),
(158,'Afghan Afghani','AFA','؋',1,1,0,0,0),
(159,'Uzbekistan Som','UZS','лв',1,1,0,0,0),
(160,'Vanuatu Vatu','VUV','VT',1,1,0,0,0),
(161,'Venezuelan BolÃvar','VEF','Bs',0,0,0,0,0),
(162,'Vietnamese Dong','VND','₫',1,1,0,0,0),
(163,'Yemeni Rial','YER','﷼',1,1,0,0,0),
(164,'Zambian Kwacha','ZMK','ZK',1,1,0,0,0);

--
-- Table structure for table `custom_page`
--

CREATE TABLE `custom_page` (
  `custom_page_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_title` varchar(255) NOT NULL,
  `page_content` longtext NOT NULL,
  `page_url` varchar(255) NOT NULL,
  `button_title` varchar(255) NOT NULL,
  `button_position` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`custom_page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `custom_page`
--


--
-- 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,
  `gifted_by` int(11) NOT NULL DEFAULT 0,
  `expiry_date` varchar(255) DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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


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

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

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

INSERT INTO `frontend_settings` VALUES
(1,'banner_title','Start learning from best Platform'),
(2,'banner_sub_title','Study any topic, anytime. Explore thousands of courses for the lowest price ever!'),
(4,'about_us','<p></p><h2><span xss=\"removed\">About us</span></h2>'),
(10,'terms_and_condition','<h2>Terms and Condition</h2>'),
(11,'privacy_policy','<p></p><p></p><h2><span xss=\"removed\">Privacy Policy</span></h2>'),
(13,'theme','default-new'),
(14,'cookie_note','This website uses cookies to personalize content and analyse traffic in order to offer you a better experience.'),
(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_1\":\"home-1.png\"}'),
(18,'light_logo','06f9e96bd9cfa3a22ca321a53dece2f8.png'),
(19,'dark_logo','5361418db9123e67aebc5a9bfee3ccb3.png'),
(20,'small_logo','34ff028fc02b773b8885b59aee142e60.png'),
(21,'favicon','1a534df4ec7023f89613a24be21a149f.png'),
(22,'recaptcha_status','0'),
(23,'recaptcha_secretkey','Valid-secret-key'),
(24,'recaptcha_sitekey','Valid-site-key'),
(25,'refund_policy','<h2><span xss=\"removed\">Refund Policy</span></h2>'),
(26,'facebook','https://facebook.com'),
(27,'twitter','https://twitter.com'),
(28,'linkedin',''),
(31,'blog_page_title','Where possibilities begin'),
(32,'blog_page_subtitle','We’re a leading marketplace platform for learning and teaching online. Explore some of our most popular content and learn something new.'),
(33,'blog_page_banner','blog-page.png'),
(34,'instructors_blog_permission','0'),
(35,'blog_visibility_on_the_home_page','1'),
(37,'website_faqs','[]'),
(38,'motivational_speech','[]'),
(39,'home_page','home_1'),
(40,'contact_info','{\"email\":\"admin@example.com,\\r\\nsystem@example.com\",\"phone\":\"609-502-5899\\r\\n345-444-2122\",\"address\":\"455 Wolff Streets Suite 674\",\"office_hours\":\"10:00 AM - 6:00 PM\"}'),
(41,'custom_css',''),
(42,'embed_code',''),
(43,'top_course_section','1'),
(44,'latest_course_section','1'),
(45,'top_category_section','1'),
(46,'upcoming_course_section','1'),
(47,'faq_section','1'),
(48,'top_instructor_section','1'),
(49,'motivational_speech_section','1'),
(50,'promotional_section','1'),
(51,'water_mark',''),
(52,'water_mark_status','inactive'),
(53,'recaptcha_status_v3','0'),
(54,'recaptcha_secretkey_v3','Valid-secret-key-v3'),
(55,'recaptcha_sitekey_v3','Valid-site-key-v3'),
(56,'review_section','1'),
(57,'water_mark_speed','2000'),
(58,'water_mark_opacity','1'),
(59,'water_mark_color','#ffffff');

--
-- Table structure for table `instructor_followings`
--

CREATE TABLE `instructor_followings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `instructor_id` int(11) DEFAULT NULL,
  `is_following` int(11) DEFAULT NULL,
  `created_at` varchar(100) NOT NULL,
  `updated_at` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `instructor_followings`
--


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

CREATE TABLE `language` (
  `phrase_id` int(11) NOT NULL AUTO_INCREMENT,
  `phrase` longtext DEFAULT NULL,
  `english` longtext DEFAULT NULL,
  PRIMARY KEY (`phrase_id`)
) ENGINE=MyISAM AUTO_INCREMENT=676 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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) DEFAULT NULL,
  `duration` varchar(255) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `video_type` varchar(255) DEFAULT NULL,
  `cloud_video_id` int(20) DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `audio_url` varchar(400) DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `lesson_type` varchar(255) DEFAULT NULL,
  `attachment` longtext DEFAULT NULL,
  `attachment_type` varchar(255) DEFAULT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `summary` longtext DEFAULT NULL,
  `is_free` int(11) NOT NULL DEFAULT 0,
  `order` int(11) NOT NULL DEFAULT 0,
  `quiz_attempt` int(11) NOT NULL DEFAULT 0,
  `video_type_for_mobile_application` varchar(255) DEFAULT NULL,
  `video_url_for_mobile_application` varchar(255) DEFAULT NULL,
  `duration_for_mobile_application` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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


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

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

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


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

CREATE TABLE `message` (
  `message_id` int(20) NOT NULL AUTO_INCREMENT,
  `message_thread_code` varchar(255) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `sender` int(20) DEFAULT NULL,
  `receiver` int(20) DEFAULT NULL,
  `timestamp` varchar(255) DEFAULT NULL,
  `read_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- 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` varchar(255) DEFAULT NULL,
  `sender` varchar(255) DEFAULT '',
  `receiver` varchar(255) DEFAULT '',
  `last_message_timestamp` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`message_thread_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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


--
-- Table structure for table `newsletter_histories`
--

CREATE TABLE `newsletter_histories` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `tried_times` int(11) DEFAULT NULL,
  `sent_at` varchar(100) DEFAULT NULL,
  `created_at` varchar(100) DEFAULT NULL,
  `updated_at` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `newsletter_histories`
--


--
-- Table structure for table `newsletter_subscriber`
--

CREATE TABLE `newsletter_subscriber` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `newsletter_subscriber`
--


--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `newsletters`
--


--
-- Table structure for table `notification_settings`
--

CREATE TABLE `notification_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) DEFAULT NULL,
  `is_editable` int(11) DEFAULT NULL,
  `addon_identifier` varchar(255) DEFAULT NULL,
  `user_types` varchar(400) DEFAULT NULL,
  `system_notification` varchar(400) DEFAULT NULL,
  `email_notification` varchar(400) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `template` longtext DEFAULT NULL,
  `setting_title` varchar(255) DEFAULT NULL,
  `setting_sub_title` varchar(255) DEFAULT NULL,
  `date_updated` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `notification_settings`
--



--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `from_user` int(11) DEFAULT NULL,
  `to_user` int(11) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `payment_type` varchar(50) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `admin_revenue` varchar(255) DEFAULT NULL,
  `instructor_revenue` varchar(255) DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `instructor_payment_status` int(11) DEFAULT 0,
  `transaction_id` varchar(255) DEFAULT NULL,
  `session_id` varchar(255) DEFAULT NULL,
  `coupon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `payment`
--


--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(255) DEFAULT NULL,
  `currency` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `keys` text NOT NULL,
  `model_name` varchar(255) DEFAULT NULL,
  `enabled_test_mode` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `is_addon` int(11) NOT NULL,
  `created_at` varchar(100) NOT NULL,
  `updated_at` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `payment_gateways`
--

INSERT INTO `payment_gateways` VALUES
(1,'paypal','USD','Paypal','','{\"sandbox_client_id\":\"AfGaziKslex-scLAyYdDYXNFaz2aL5qGau-SbDgE_D2E80D3AFauLagP8e0kCq9au7W4IasmFbirUUYc\",\"sandbox_secret_key\":\"EMa5pCTuOpmHkhHaCGibGhVUcKg0yt5-C3CzJw-OWJCzaXXzTlyD17SICob_BkfM_0Nlk7TWnN42cbGz\",\"production_client_id\":\"1234\",\"production_secret_key\":\"12345\"}','Payment_model',1,1,0,'','1673263724'),
(2,'stripe','USD','Stripe','','{\"public_key\":\"pk_test_CAC3cB1mhgkJqXtypYBTGb4f\",\"secret_key\":\"sk_test_iatnshcHhQVRXdygXw3L2Pp2\",\"public_live_key\":\"pk_live_xxxxxxxxxxxxxxxxxxxxxxxx\",\"secret_live_key\":\"sk_live_xxxxxxxxxxxxxxxxxxxxxxxx\"}','Payment_model',1,1,0,'','1673263724'),
(3,'razorpay','INR','Razorpay','','{\"key_id\":\"rzp_test_J60bqBOi1z1aF5\",\"secret_key\":\"uk935K7p4j96UCJgHK8kAU4q\",\"theme_color\":\"#23d792\"}','Payment_model',1,1,0,'','1708580304'),
(4,'xendit','USD','Xendit','','{\"api_key\":\"xnd_development_44KVee2PG4HeeZxG69R5eXOJHVD7t84FZUIH8dMxa37ZU3bZ8KDKV9ugPfy5fRK\",\"secret_key\":\"your_xendit_secret_key\",\"other_parameter\":\"value\"}','Payment_model',1,1,0,'','1700647736'),
(5,'payu','PLN','Payu','','{\"pos_id\":\"PKf789971N2ig5hbF71y1BX46k\",\"second_key\":\"vaWDmIqbwiVUOVitXet9ZlC9mQ\",\"client_id\":\"PKf789971N2ig5hbF71y1BX46k\",\"client_secret\":\"vaWDmIqbwiVUOVitXet9ZlC9mQ\"}','Payment_model',1,1,0,'','1707980726'),
(6,'pagseguro','BRL','Pagseguro','','{\"api_key\":\"BAE981AF77CA4768A93849AFF5BF2331\",\"secret_key\":\"8045696DBFBF765FF4189FBAE1E02AB5\",\"other_parameter\":\"value\"}','Payment_model',1,1,0,'','1705559611'),
(7,'sslcommerz','USD','SSL Commerz','','{\"store_id\":\"sslcommerz_store_id\",\"store_password\":\"sslcommerz_store_password\"}','Payment_model',1,1,0,'','1673264610'),
(8,'skrill','USD','Skrill','','{\"skrill_merchant_email\":\"urwatech@gmail.com\",\"secret_passphrase\":\"your_skrill_secret_key\"}','Payment_model',1,1,0,'','1700647745'),
(10,'doku','USD','Doku','','{\"client_id\":\"BRN-0271-1700996849302\",\"shared_key\":\"SK-BxOS4PfUdIEMHLccyMI3\"}','Payment_model',1,1,0,'','1708603994'),
(11,'bkash','BDT','Bkash','','{\"app_key\":\"app-key\",\"app_secret\":\"app-secret\",\"username\":\"username\",\"password\":\"passwoed\"}','Payment_model',1,1,0,'1700997440','1701596645'),
(12,'cashfree','INR','CashFree','','{\"client_id\":\"TEST100748308df0665cabda6c2f38b903847001\",\"client_secret\":\"cfsk_ma_test_71065d7cadf8695e7845e86244bd7011_fff5714b\"}','Payment_model',1,1,0,'1700997440','1701688995'),
(13,'maxicash','USD','Maxicash','','{\"merchant_id\":\"TEST100748308df0665cabda6c2f38b903847001\",\"merchant_password\":\"cfsk_ma_test_71065d7cadf8695e7845e86244bd7011_fff5714b\"}','Payment_model',1,1,0,'1700997440','1701688995'),
(14,'aamarpay','BDT','Aamarpay','','{\"store_id\":\"aamarpaytest\",\"signature_key\":\"dbb74894e82415a2f7ff0ec3a97e4183\"}','Payment_model',1,1,0,'1700997440','1711366991'),
(15,'flutterwave','NGN','Flutterwave','','{\"public_key\":\"FLWPUBK_TEST-b6fbee21fd2d9f13be74bf4d87fe6197-X\",\"secret_key\":\"FLWSECK_TEST-70c3f071a83a1d14bb8a0061e53845a7-X\"}','Payment_model',1,1,0,'1700997440','1711366991'),
(16,'tazapay','USD','Tazapay','','{\"public_key\":\"pk_test_audpDpZGmHmYT46kmHvA\",\"api_key\":\"ak_test_CRXTUMNGV4MVPO7RDGT2\",\"api_secret\":\"sk_test_0OfyPSFUX4YqcQGkeyOWCVkEQ7WAWeZ6SmsNNpfFQ989qm15f8mu2gqmYhiXkZ87iF26Ej1Ex9pgNuTq9YoxksPmQjDEbyATBoWw0bNH12mQPIJQ4VGqEPIB5FEizarZ\"}','Payment_model',1,1,0,'1700997440','1711366991');

--
-- 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(255) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT NULL,
  `permissions` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `permissions`
--


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

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

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


--
-- Table structure for table `quiz_results`
--

CREATE TABLE `quiz_results` (
  `quiz_result_id` int(11) NOT NULL AUTO_INCREMENT,
  `quiz_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_answers` longtext NOT NULL,
  `correct_answers` longtext NOT NULL COMMENT 'question_id',
  `total_obtained_marks` double NOT NULL,
  `date_added` varchar(100) NOT NULL,
  `date_updated` varchar(100) NOT NULL,
  `is_submitted` int(11) NOT NULL,
  PRIMARY KEY (`quiz_result_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `quiz_results`
--


--
-- 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) DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  `review` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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


--
-- Table structure for table `resource_files`
--

CREATE TABLE `resource_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lesson_id` int(20) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `resource_files`
--


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

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

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

INSERT INTO `role` 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) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `start_date` varchar(255) DEFAULT NULL,
  `end_date` varchar(255) DEFAULT NULL,
  `restricted_by` varchar(255) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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


--
-- Table structure for table `seo_fields`
--

CREATE TABLE `seo_fields` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `route` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `is_addon` int(11) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_robot` text DEFAULT NULL,
  `canonical_url` varchar(255) DEFAULT NULL,
  `custom_url` varchar(255) DEFAULT NULL,
  `og_title` varchar(255) DEFAULT NULL,
  `og_description` text DEFAULT NULL,
  `og_image` varchar(255) DEFAULT NULL,
  `json_ld` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `seo_fields`
--

INSERT INTO `seo_fields` VALUES
(1,'home','home',NULL,'Home page',NULL,'Home page for academy Seo','Meta robot','https://demo.creativeitem.com/academy','https://demo.creativeitem.com/academy','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(2,'courses','home/courses',NULL,'Course page',NULL,'Course page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/home/courses','https://demo.creativeitem.com/academy/home/courses','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(3,'login','login',NULL,'Login page',NULL,'Login page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/login','https://demo.creativeitem.com/academy/login','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(4,'sign_up','sign_up',NULL,'Signup page',NULL,'Signup page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/sign_up','https://demo.creativeitem.com/academy/sign_up','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(5,'blog','blog',NULL,'Blog page',NULL,'Blog page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/blog','https://demo.creativeitem.com/academy/blog','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(6,'contact_us','home/contact_us',NULL,'Contact us page',NULL,'Contact us page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/home/contact_us','https://demo.creativeitem.com/academy/home/contact_us','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(7,'about_us','home/about_us',NULL,'About us page',NULL,'About us page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/home/about_us','https://demo.creativeitem.com/academy/home/about_us','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(8,'privacy_policy','home/privacy_policy',NULL,'Privacy policy page',NULL,'Privacy policy page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/home/privacy_policy','https://demo.creativeitem.com/academy/home/privacy_policy','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(9,'terms_and_condition','home/terms_and_condition',NULL,'Terms and condition page',NULL,'Terms and condition page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/home/terms_and_condition','https://demo.creativeitem.com/academy/home/terms_and_condition','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(10,'refund_policy','home/refund_policy',NULL,'Refund policy page',NULL,'Refund policy page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/home/refund_policy','https://demo.creativeitem.com/academy/home/refund_policy','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(11,'faq','home/faq',NULL,'Faq page',NULL,'Faq page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/home/faq','https://demo.creativeitem.com/academy/home/faq','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(12,'ebook','ebook',1,'Ebook page',NULL,'Ebook page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/ebook','https://demo.creativeitem.com/academy/ebook','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(13,'course_bundles','course_bundles',1,'Course bundle page',NULL,'Course bundle page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/course_bundles','https://demo.creativeitem.com/academy/course_bundles','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }'),
(14,'bootcamps','addons/bootcamp/bootcamp_list',1,'Bootcamps page',NULL,'Bootcamps page for academy Seo','Meta robot','https://demo.creativeitem.com/academy/addons/bootcamp/bootcamp_list','https://demo.creativeitem.com/academy/addons/bootcamp/bootcamp_list','Og title','Og description',NULL,'{ \"@context\": \"http://schema.org\", \"@type\": \"WebSite\", \"name\": \"CodeCanyon\", \"url\": \"https://codecanyon.net\" }');

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

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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) DEFAULT NULL,
  `tagable_id` int(11) DEFAULT NULL,
  `tagable_type` varchar(255) DEFAULT NULL,
  `date_added` int(11) DEFAULT NULL,
  `last_modified` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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


--
-- Table structure for table `watch_histories`
--

CREATE TABLE `watch_histories` (
  `watch_history_id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `completed_lesson` longtext NOT NULL,
  `course_progress` int(11) NOT NULL,
  `watching_lesson_id` int(11) NOT NULL,
  `quiz_result` longtext NOT NULL,
  `completed_date` varchar(255) DEFAULT NULL,
  `date_added` varchar(100) DEFAULT NULL,
  `date_updated` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`watch_history_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `watch_histories`
--


--
-- Table structure for table `watched_duration`
--

CREATE TABLE `watched_duration` (
  `watched_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `watched_student_id` int(11) DEFAULT NULL,
  `watched_course_id` int(11) DEFAULT NULL,
  `watched_lesson_id` int(11) DEFAULT NULL,
  `current_duration` int(20) DEFAULT NULL,
  `watched_counter` longtext DEFAULT NULL,
  PRIMARY KEY (`watched_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `watched_duration`
--



