-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Oct 13, 2026 at 02:46 PM -- Server version: 10.11.19-MariaDB -- PHP Version: 8.4.26 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: `samratitinstitut_samrat` -- -- -------------------------------------------------------- -- -- Table structure for table `about_pages` -- CREATE TABLE `about_pages` ( `id` bigint(20) UNSIGNED NOT NULL, `who_we_are` longtext DEFAULT NULL, `banner_title` longtext DEFAULT NULL, `story_title` longtext DEFAULT NULL, `story_description` longtext DEFAULT NULL, `teacher_title` longtext DEFAULT NULL, `teacher_details` longtext DEFAULT NULL, `course_title` longtext DEFAULT NULL, `course_details` longtext DEFAULT NULL, `student_title` longtext DEFAULT NULL, `student_details` longtext DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `image1` varchar(191) NOT NULL DEFAULT 'public/frontend/infixlmstheme/img/about/1.jpg', `image2` varchar(191) NOT NULL DEFAULT 'public/frontend/infixlmstheme/img/about/2.jpg', `image3` varchar(191) NOT NULL DEFAULT 'public/frontend/infixlmstheme/img/about/3.jpg', `image4` varchar(191) NOT NULL DEFAULT 'public/frontend/infixlmstheme/img/about/counter_bg.png', `show_testimonial` tinyint(1) NOT NULL DEFAULT 1, `show_brand` tinyint(1) NOT NULL DEFAULT 1, `show_become_instructor` tinyint(1) NOT NULL DEFAULT 1, `total_teacher` longtext DEFAULT NULL, `total_student` longtext DEFAULT NULL, `total_courses` longtext DEFAULT NULL, `about_page_content_title` longtext DEFAULT NULL, `about_page_content_details` longtext DEFAULT NULL, `live_class_title` longtext DEFAULT NULL, `live_class_details` longtext DEFAULT NULL, `live_class_image` varchar(191) NOT NULL DEFAULT 'public/frontend/edume/img/lms_udemy/become_ins2.png', `counter_bg` varchar(191) NOT NULL DEFAULT 'public/frontend/edume/img/about/counter_bg.png', `sponsor_title` longtext DEFAULT NULL, `sponsor_sub_title` longtext DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1, `registered_students` text DEFAULT NULL, `questions_answers` text DEFAULT NULL, `quality_content` text DEFAULT NULL, `our_mission` text DEFAULT NULL, `our_vision` text DEFAULT NULL, `about_page_content_details2` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `about_pages` -- INSERT INTO `about_pages` (`id`, `who_we_are`, `banner_title`, `story_title`, `story_description`, `teacher_title`, `teacher_details`, `course_title`, `course_details`, `student_title`, `student_details`, `created_at`, `updated_at`, `image1`, `image2`, `image3`, `image4`, `show_testimonial`, `show_brand`, `show_become_instructor`, `total_teacher`, `total_student`, `total_courses`, `about_page_content_title`, `about_page_content_details`, `live_class_title`, `live_class_details`, `live_class_image`, `counter_bg`, `sponsor_title`, `sponsor_sub_title`, `lms_id`, `registered_students`, `questions_answers`, `quality_content`, `our_mission`, `our_vision`, `about_page_content_details2`) VALUES (1, '{\"en\":\"Improving lives through Learning. We are always Inspired by the world and people us. Celebrating e-Learning excellence in Personal.\"}', '{\"en\":\"We are here to meet your demand and teach the most beneficial way for you in Personal.\"}', '{\"en\":\"Build your own library for your career and personal growth.\"}', '{\"en\":\"Our goal is to learn the next generation of creative professionals for a future in any industry. We offer course in most demanded industries. Whether begin to your journey on our courses website or choose the flexibility of video learning our courses are designed to help you along your path.\"}', '{\"en\":\"Most Involved Teachers\"}', '{\"en\":\"Key features are the ability to develop relationships with their students, patient, caring and kind knowledge offer learner engaging students of their.\"}', '{\"en\":\"High-Quality Course\"}', '{\"en\":\"Key features are the ability to develop relationships with their students, patient, caring and kind knowledge offer learner engaging students of their.\"}', '{\"en\":\"Large Selection of Courses\"}', '{\"en\":\"Key features are the ability to develop relationships with their students, patient, caring and kind knowledge offer learner engaging students of their.\"}', NULL, '2026-04-09 21:34:39', 'public/frontend/infixlmstheme/img/about/1.jpg', 'public/frontend/infixlmstheme/img/about/2.jpg', 'public/frontend/infixlmstheme/img/about/3.jpg', 'public/frontend/infixlmstheme/img/about/counter_bg.png', 1, 1, 1, '{\"en\":\"100+\"}', '{\"en\":\"200+\"}', '{\"en\":\"150+\"}', '{\"en\":\"Online Learning Platform\"}', '{\"en\":\"Areana ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.\"}', '{\"en\":\"Get Personal Learning Recommendations\"}', '{\"en\":\"Unlimited access to world-class learning from your laptop tablet, or phone. Join over 15,000+ students\"}', 'public/frontend/edume/img/lms_udemy/become_ins2.png', 'public/frontend/edume/img/about/counter_bg.png', '{\"en\":\"Trusted By\"}', '{\"en\":\"Thousands of students already add more focus to their work with InfixLMS.\"}', 1, NULL, NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `activity_log` -- CREATE TABLE `activity_log` ( `id` bigint(20) UNSIGNED NOT NULL, `log_name` varchar(191) DEFAULT NULL, `description` text NOT NULL, `subject_id` bigint(20) UNSIGNED DEFAULT NULL, `subject_type` varchar(191) DEFAULT NULL, `causer_id` bigint(20) UNSIGNED DEFAULT NULL, `causer_type` varchar(191) DEFAULT NULL, `properties` longtext DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `badges` -- CREATE TABLE `badges` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) DEFAULT NULL, `type` varchar(191) DEFAULT NULL, `image` varchar(191) DEFAULT NULL, `point` int(11) NOT NULL DEFAULT 0, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `badges` -- INSERT INTO `badges` (`id`, `title`, `type`, `image`, `point`, `status`, `created_at`, `updated_at`) VALUES (1, 'Newbie', 'activity', 'public/badges/activity/1.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (2, 'Grower', 'activity', 'public/badges/activity/2.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (3, 'Adventurer', 'activity', 'public/badges/activity/3.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (4, 'Explorer', 'activity', 'public/badges/activity/4.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (5, 'Star', 'activity', 'public/badges/activity/5.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (6, 'Superstar', 'activity', 'public/badges/activity/6.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (7, 'Master', 'activity', 'public/badges/activity/7.png', 256, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (8, 'Grandmaster', 'activity', 'public/badges/activity/8.png', 512, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (9, 'Newbie', 'registration', 'public/badges/registration/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (10, 'Grower', 'registration', 'public/badges/registration/2.png', 7, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (11, 'Adventurer', 'registration', 'public/badges/registration/3.png', 30, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (12, 'Explorer', 'registration', 'public/badges/registration/4.png', 60, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (13, 'Star', 'registration', 'public/badges/registration/5.png', 90, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (14, 'Superstar', 'registration', 'public/badges/registration/6.png', 120, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (15, 'Master', 'registration', 'public/badges/registration/7.png', 150, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (16, 'Grandmaster', 'registration', 'public/badges/registration/8.png', 365, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (17, 'Newbie', 'learning', 'public/badges/learning/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (18, 'Grower', 'learning', 'public/badges/learning/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (19, 'Adventurer', 'learning', 'public/badges/learning/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (20, 'Explorer', 'learning', 'public/badges/learning/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (21, 'Star', 'learning', 'public/badges/learning/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (22, 'Superstar', 'learning', 'public/badges/learning/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (23, 'Master', 'learning', 'public/badges/learning/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (24, 'Grandmaster', 'learning', 'public/badges/learning/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (25, 'Newbie', 'test', 'public/badges/test/1.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (26, 'Grower', 'test', 'public/badges/test/2.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (27, 'Adventurer', 'test', 'public/badges/test/3.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (28, 'Explorer', 'test', 'public/badges/test/4.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (29, 'Star', 'test', 'public/badges/test/5.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (30, 'Superstar', 'test', 'public/badges/test/6.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (31, 'Master', 'test', 'public/badges/test/7.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (32, 'Grandmaster', 'test', 'public/badges/test/8.png', 256, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (33, 'Newbie', 'perfectionism', 'public/badges/perfectionism/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (34, 'Grower', 'perfectionism', 'public/badges/perfectionism/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (35, 'Adventurer', 'perfectionism', 'public/badges/perfectionism/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (36, 'Explorer', 'perfectionism', 'public/badges/perfectionism/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (37, 'Star', 'perfectionism', 'public/badges/perfectionism/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (38, 'Superstar', 'perfectionism', 'public/badges/perfectionism/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (39, 'Master', 'perfectionism', 'public/badges/perfectionism/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (40, 'Grandmaster', 'perfectionism', 'public/badges/perfectionism/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (41, 'Newbie', 'communication', 'public/badges/communication/1.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (42, 'Grower', 'communication', 'public/badges/communication/2.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (43, 'Adventurer', 'communication', 'public/badges/communication/3.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (44, 'Explorer', 'communication', 'public/badges/communication/4.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (45, 'Star', 'communication', 'public/badges/communication/5.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (46, 'Superstar', 'communication', 'public/badges/communication/6.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (47, 'Master', 'communication', 'public/badges/communication/7.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (48, 'Grandmaster', 'communication', 'public/badges/communication/8.png', 256, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (49, 'Newbie', 'certification', 'public/badges/certification/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (50, 'Grower', 'certification', 'public/badges/certification/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (51, 'Adventurer', 'certification', 'public/badges/certification/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (52, 'Explorer', 'certification', 'public/badges/certification/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (53, 'Star', 'certification', 'public/badges/certification/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (54, 'Superstar', 'certification', 'public/badges/certification/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (55, 'Master', 'certification', 'public/badges/certification/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (56, 'Grandmaster', 'certification', 'public/badges/certification/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (57, 'Newbie', 'assignment', 'public/badges/assignment/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (58, 'Grower', 'assignment', 'public/badges/assignment/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (59, 'Adventurer', 'assignment', 'public/badges/assignment/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (60, 'Explorer', 'assignment', 'public/badges/assignment/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (61, 'Star', 'assignment', 'public/badges/assignment/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (62, 'Superstar', 'assignment', 'public/badges/assignment/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (63, 'Master', 'assignment', 'public/badges/assignment/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (64, 'Grandmaster', 'assignment', 'public/badges/assignment/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (65, 'Newbie', 'survey', 'public/badges/survey/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (66, 'Grower', 'survey', 'public/badges/survey/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (67, 'Adventurer', 'survey', 'public/badges/survey/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (68, 'Explorer', 'survey', 'public/badges/survey/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (69, 'Star', 'survey', 'public/badges/survey/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (70, 'Superstar', 'survey', 'public/badges/survey/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (71, 'Master', 'survey', 'public/badges/survey/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (72, 'Grandmaster', 'survey', 'public/badges/survey/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (73, 'Newbie', 'forum', 'public/badges/forum/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (74, 'Grower', 'forum', 'public/badges/forum/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (75, 'Adventurer', 'forum', 'public/badges/forum/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (76, 'Explorer', 'forum', 'public/badges/forum/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (77, 'Star', 'forum', 'public/badges/forum/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (78, 'Superstar', 'forum', 'public/badges/forum/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (79, 'Master', 'forum', 'public/badges/forum/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (80, 'Grandmaster', 'forum', 'public/badges/forum/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (81, 'Newbie', 'courses', 'public/badges/courses/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (82, 'Grower', 'courses', 'public/badges/courses/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (83, 'Adventurer', 'courses', 'public/badges/courses/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (84, 'Explorer', 'courses', 'public/badges/courses/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (85, 'Star', 'courses', 'public/badges/courses/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (86, 'Superstar', 'courses', 'public/badges/courses/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (87, 'Master', 'courses', 'public/badges/courses/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (88, 'Grandmaster', 'courses', 'public/badges/courses/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (89, 'Newbie', 'rating', 'public/badges/rating/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (90, 'Grower', 'rating', 'public/badges/rating/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (91, 'Adventurer', 'rating', 'public/badges/rating/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (92, 'Explorer', 'rating', 'public/badges/rating/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (93, 'Star', 'rating', 'public/badges/rating/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (94, 'Superstar', 'rating', 'public/badges/rating/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (95, 'Master', 'rating', 'public/badges/rating/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (96, 'Grandmaster', 'rating', 'public/badges/rating/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (97, 'Newbie', 'sales', 'public/badges/sales/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (98, 'Grower', 'sales', 'public/badges/sales/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (99, 'Adventurer', 'sales', 'public/badges/sales/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (100, 'Explorer', 'sales', 'public/badges/sales/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (101, 'Star', 'sales', 'public/badges/sales/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (102, 'Superstar', 'sales', 'public/badges/sales/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (103, 'Master', 'sales', 'public/badges/sales/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (104, 'Grandmaster', 'sales', 'public/badges/sales/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (105, 'Newbie', 'blogs', 'public/badges/blog/1.png', 1, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (106, 'Grower', 'blogs', 'public/badges/blog/2.png', 2, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (107, 'Adventurer', 'blogs', 'public/badges/blog/3.png', 4, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (108, 'Explorer', 'blogs', 'public/badges/blog/4.png', 8, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (109, 'Star', 'blogs', 'public/badges/blog/5.png', 16, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (110, 'Superstar', 'blogs', 'public/badges/blog/6.png', 32, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (111, 'Master', 'blogs', 'public/badges/blog/7.png', 64, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'), (112, 'Grandmaster', 'blogs', 'public/badges/blog/8.png', 128, 1, '2026-04-09 21:35:03', '2026-04-09 21:35:03'); -- -------------------------------------------------------- -- -- Table structure for table `bank_payment_requests` -- CREATE TABLE `bank_payment_requests` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(11) NOT NULL, `bank_name` text DEFAULT NULL, `account_holder` text DEFAULT NULL, `branch_name` text DEFAULT NULL, `amount` text DEFAULT NULL, `account_number` text DEFAULT NULL, `image` text DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `account_type` varchar(191) NOT NULL DEFAULT 'Current Account', `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `become_instructors` -- CREATE TABLE `become_instructors` ( `id` int(10) UNSIGNED NOT NULL, `section` longtext DEFAULT NULL, `title` longtext DEFAULT NULL, `description` longtext DEFAULT NULL, `btn_name` longtext DEFAULT NULL, `btn_link` varchar(191) DEFAULT NULL, `icon` varchar(191) DEFAULT NULL, `image` varchar(191) DEFAULT NULL, `video` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `bg_image` varchar(191) NOT NULL DEFAULT 'public/frontend/infixlmstheme/img/instractor_bg.png', `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `become_instructors` -- INSERT INTO `become_instructors` (`id`, `section`, `title`, `description`, `btn_name`, `btn_link`, `icon`, `image`, `video`, `created_at`, `updated_at`, `bg_image`, `lms_id`) VALUES (1, '{\"en\":\"icon_left\"}', '{\"en\":\"Join our Community\"}', '{\"en\":\"When you sign up, you’ll immediately have unlimited viewing of thousands of expert courses.\"}', '{\"en\":\"\"}', NULL, 'fas fa-book-open', NULL, NULL, '2026-04-09 21:34:30', '2026-04-09 21:34:30', 'public/frontend/infixlmstheme/img/instractor_bg.png', 1), (2, '{\"en\":\"icon_mid\"}', '{\"en\":\"Share your Knowledge\"}', '{\"en\":\"If you sign up, you’ll immediately have unlimited viewing of thousands of expert courses.\"}', '{\"en\":\"\"}', NULL, 'fas fa-chalkboard-teacher', NULL, NULL, '2026-04-09 21:34:30', '2026-04-09 21:34:30', 'public/frontend/infixlmstheme/img/instractor_bg.png', 1), (3, '{\"en\":\"icon_right\"}', '{\"en\":\"Earn Money\"}', '{\"en\":\"Let you sign up, you’ll immediately have unlimited viewing of thousands of expert courses.\"}', '{\"en\":\"\"}', NULL, 'fas fa-universal-access', NULL, NULL, '2026-04-09 21:34:30', '2026-04-09 21:34:30', 'public/frontend/infixlmstheme/img/instractor_bg.png', 1), (4, '{\"en\":\"joining_part\"}', '{\"en\":\"We are now 5983+ Community around the world and growing up\"}', '{\"en\":\"Operating system, and statistical information about how you use our products and services. We only collect, track and analyze such information in an aggregate manner that does not personally identify you. Read the section on Use on Cookies to know how we collect aggregate data.\"}', '{\"en\":\"\"}', NULL, NULL, NULL, NULL, '2026-04-09 21:34:30', '2026-04-09 21:34:30', 'public/frontend/infixlmstheme/img/instractor_bg.png', 1), (5, '{\"en\":\"cta_part\"}', '{\"en\":\"Ready to become an instructor?\"}', '{\"en\":\"Top instructors from around the world teach millions of students on Infix about peripherals that add functionality to a system.\"}', '{\"en\":\"\"}', NULL, NULL, NULL, NULL, '2026-04-09 21:34:30', '2026-04-09 21:34:30', 'public/frontend/infixlmstheme/img/instractor_bg.png', 1), (6, '{\"en\":\"How it Works\"}', '{\"en\":\"When you sign up, you’ll immediately have unlimited viewing of thousands of expert courses.\"}', '{\"en\":\"\"}', '{\"en\":\"\"}', NULL, NULL, 'public/demo/become_instructor/1.png', 'https://www.youtube.com/watch?v=mlqWUqVZrHA', '2026-04-09 21:34:30', '2026-04-09 21:34:30', 'public/frontend/infixlmstheme/img/instractor_bg.png', 1); -- -------------------------------------------------------- -- -- Table structure for table `billing_details` -- CREATE TABLE `billing_details` ( `id` bigint(20) UNSIGNED NOT NULL, `tracking_id` varchar(191) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `first_name` varchar(191) DEFAULT NULL, `last_name` varchar(191) DEFAULT NULL, `company_name` varchar(191) DEFAULT NULL, `country` varchar(191) DEFAULT NULL, `address1` varchar(191) DEFAULT NULL, `address2` varchar(191) DEFAULT NULL, `city` varchar(191) DEFAULT NULL, `zip_code` varchar(191) DEFAULT NULL, `phone` varchar(191) DEFAULT NULL, `email` varchar(191) DEFAULT NULL, `details` text DEFAULT NULL, `payment_method` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1, `state` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `billing_details` -- INSERT INTO `billing_details` (`id`, `tracking_id`, `user_id`, `first_name`, `last_name`, `company_name`, `country`, `address1`, `address2`, `city`, `zip_code`, `phone`, `email`, `details`, `payment_method`, `created_at`, `updated_at`, `lms_id`, `state`) VALUES (1, '6X5TZ726NVVP', 3, 'Amirul', 'Islam', NULL, '19', 'N/A', NULL, NULL, NULL, '01315515586', 'hostsamrat@gmail.com', NULL, NULL, '2026-04-10 07:27:20', '2026-04-15 17:01:45', 1, 0), (2, 'Y5GMG6T7BOYJ', 4, 'Amirul', 'Islam', NULL, '19', 'N/A', NULL, NULL, NULL, '01315515578', 'amirulislam8787796@gmail.com', NULL, NULL, '2026-04-10 21:03:06', '2026-06-02 12:13:16', 1, 0), (3, 'SC4NM1QYSP38', 2, 'test', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, '01315515587', 'test@gmail.com', NULL, NULL, '2026-04-15 17:03:25', '2026-04-15 17:03:25', 1, 0), (4, '3C7A3P1YUSX3', 11, 'Xamrat', 'Islam', NULL, '19', 'N/A', NULL, NULL, NULL, '01245874584', 'xamratislam@gmail.com', NULL, NULL, '2026-04-17 16:49:14', '2026-04-17 16:49:14', 1, 0), (5, 'VJB41HD716QF', 14, 'Md', 'Abu', NULL, '19', 'N/A', NULL, NULL, NULL, '01811695958', 'mdabuhanif607@gmail.com', NULL, NULL, '2026-04-30 20:36:25', '2026-07-18 14:03:22', 1, 0), (6, 'J75MMNPT6DE5', 16, 'ANIYA', 'ISLAM', NULL, '19', 'N/A', NULL, NULL, NULL, '+8801835350996', 'jaakhiakhtar1409@gmail.com', NULL, NULL, '2026-05-01 17:42:21', '2026-05-09 09:19:50', 1, 0), (7, 'H3MKYR1ECS8W', 19, 'MD', 'Nurul', NULL, '19', 'N/A', NULL, NULL, NULL, '+8801714318309', 'mdnurulislam8585757@gmail.com', NULL, NULL, '2026-05-09 14:23:27', '2026-05-09 14:23:27', 1, 0), (8, 'AQ5DTBF25EYZ', 21, 'Salauddin', 'Iqbal', NULL, '19', 'N/A', NULL, NULL, NULL, '+880184911555', 'salauddiniqbal9@gmail.com', NULL, NULL, '2026-05-09 14:25:47', '2026-05-09 14:25:47', 1, 0), (9, '6AP55TOUS3EZ', 38, 'Tarikul', 'Islam', 'Mm maltimain lt', '19', 'Shapur', NULL, NULL, '1234', '01619682573', 'tarikulrac70@gmail.com', NULL, NULL, '2026-05-10 19:10:42', '2026-05-10 19:10:42', 1, 0), (10, '61EHT6H431WD', 39, 'Nazma', 'Akter', NULL, '19', 'N/A', NULL, NULL, NULL, '01729478789', 'nazmadig202@gmail.com', NULL, NULL, '2026-05-11 18:28:22', '2026-05-11 18:28:22', 1, 0), (11, '53CBVSEW7B1U', 44, 'Md Younus', 'Ali', 'It Agency Bd', '19', 'DHAKA', 'Dhaka', '7291', '9400', '+8801338990235', 'mdyounus1613@gmail.com', NULL, NULL, '2026-05-29 12:37:18', '2026-05-29 12:37:18', 1, 348), (12, 'W2A8KAE9Q1WC', 73, 'Meskat', 'Al', NULL, '19', 'N/A', NULL, NULL, NULL, '+966542480456', 'meskatarmani@gmail.com', NULL, NULL, '2026-07-12 12:30:51', '2026-07-12 12:30:51', 1, 0), (13, 'S4VFM7DTCPOJ', 102, 'Md', 'rakibuzzman', NULL, '19', 'N/A', NULL, NULL, NULL, '01724710671', 'rakibuzzman71@gmail.com', NULL, NULL, '2026-10-08 20:40:05', '2026-10-08 20:40:05', 1, 0), (14, '9FFSHU45VSR8', 103, 'Md Rakib', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, '01724710671', 'rakibuzzman71@gmail.com', NULL, NULL, '2026-10-08 20:57:54', '2026-10-08 20:57:54', 1, NULL), (15, 'SQCX9G7UYJQQ', 103, 'Md Rakib', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, '01724710671', 'rakibuzzman71@gmail.com', NULL, NULL, '2026-10-08 21:08:04', '2026-10-08 21:08:04', 1, NULL), (16, '87XXOCCGQHJB', 104, 'Md Rakibuzzman', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, '01724710671', 'rakibuzzman71@gmail.com', NULL, NULL, '2026-10-08 21:36:42', '2026-10-08 21:36:42', 1, NULL), (17, 'Y83G8WM1YNVS', 104, 'Md Rakibuzzman', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, '01724710671', 'rakibuzzman71@gmail.com', NULL, NULL, '2026-10-08 21:38:55', '2026-10-08 21:38:55', 1, NULL), (18, 'ZKV9NY8ZNAK7', 105, 'Amirul Islam', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, '01357313257', 'xamratitbd@gmail.com', NULL, NULL, '2026-10-09 08:29:37', '2026-10-09 11:26:41', 1, NULL), (19, 'TN2PHMMHY4Y9', 106, 'AHMED SAMRAT', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, '01315515589', 'bdsamratshop@gmail.com', NULL, NULL, '2026-10-09 10:34:22', '2026-10-09 10:34:22', 1, NULL), (20, '3FUCVX8RFMP7', 106, 'AHMED SAMRAT', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, '01315515589', 'bdsamratshop@gmail.com', NULL, NULL, '2026-10-09 10:36:42', '2026-10-09 10:36:42', 1, NULL), (21, 'VUDPZRU5DXPO', 106, 'AHMED SAMRAT', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, '01315515589', 'bdsamratshop@gmail.com', NULL, NULL, '2026-10-09 10:36:53', '2026-10-09 11:19:39', 1, NULL), (22, 'AMBFHN7B4QDH', 107, 'Ahmed samrat', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, NULL, 'nishadalam221@gmail.com', NULL, NULL, '2026-10-09 14:47:13', '2026-10-09 14:47:13', 1, NULL), (23, '4Y2CSS4TU67P', 107, 'Ahmed samrat', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, NULL, 'nishadalam221@gmail.com', NULL, NULL, '2026-10-09 14:52:29', '2026-10-09 14:52:29', 1, NULL), (24, 'Z3N23K8MSKZ1', 108, 'SMM SAMRAT', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, NULL, 'xamratislamr@gmail.com', NULL, NULL, '2026-10-09 15:20:56', '2026-10-09 15:20:56', 1, NULL), (25, 'Z9326JMPJSSH', 109, 'Japani Sakura 3x Whitening Booster Soap', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, NULL, 'amirulislam878gg7796@gmail.com', NULL, NULL, '2026-10-09 15:31:40', '2026-10-09 15:31:40', 1, NULL), (26, 'FH2RPGQP3TC7', 110, 'Japani Sakura 3x Whitening Booster Soap', ' ', NULL, '19', 'N/A', NULL, NULL, NULL, NULL, 'amirulislamvajs8787796@gmail.com', NULL, NULL, '2026-10-09 15:33:11', '2026-10-09 15:33:11', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `bkash_payment_orders` -- CREATE TABLE `bkash_payment_orders` ( `id` bigint(20) UNSIGNED NOT NULL, `paymentID` varchar(191) NOT NULL, `type` varchar(191) NOT NULL DEFAULT 'Test', `amount` float NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bkash_payment_orders` -- INSERT INTO `bkash_payment_orders` (`id`, `paymentID`, `type`, `amount`, `status`, `created_at`, `updated_at`) VALUES (1, 'TR0011HxoHtPH1775810574797', 'Test', 10, 0, '2026-04-10 08:42:54', '2026-04-10 08:42:54'), (2, 'TR0011uH0OnD21775844670612', 'Test', 10, 0, '2026-04-10 18:11:10', '2026-04-10 18:11:10'), (3, 'TR00114slvWOC1775845773656', 'Payment', 999, 1, '2026-04-10 18:29:33', '2026-04-10 18:30:26'), (4, 'TR0011L0ur00A1775847368448', 'Test', 10, 0, '2026-04-10 18:56:08', '2026-04-10 18:56:08'), (5, 'TR0011gu08Vx71775854993860', 'Payment', 999, 0, '2026-04-10 21:03:13', '2026-04-10 21:03:13'), (6, 'TR00115f8qL1D1775855022297', 'Payment', 999, 0, '2026-04-10 21:03:42', '2026-04-10 21:03:42'), (7, 'TR0011Qpr0WTC1775940960448', 'Payment', 1, 0, '2026-04-11 20:56:00', '2026-04-11 20:56:00'), (8, 'TR0011L25OFMh1776274358738', 'Payment', 999, 0, '2026-04-15 17:32:38', '2026-04-15 17:32:38'), (9, 'TR0011OHZ2p901776274477464', 'Payment', 999, 0, '2026-04-15 17:34:37', '2026-04-15 17:34:37'), (10, 'TR0011XABaBrr1776444560774', 'Payment', 999, 1, '2026-04-17 16:49:20', '2026-04-17 16:50:05'), (11, 'TR0011ARKGBQ91776522313050', 'Payment', 999, 0, '2026-04-18 14:25:13', '2026-04-18 14:25:13'), (12, 'TR0011ZCwl5PN1776522420048', 'Payment', 999, 0, '2026-04-18 14:27:00', '2026-04-18 14:27:00'), (13, 'TR00114Mn2f481776522420319', 'Payment', 999, 0, '2026-04-18 14:27:00', '2026-04-18 14:27:00'), (14, 'TR0011uAdaAyu1776522907933', 'Payment', 999, 0, '2026-04-18 14:35:08', '2026-04-18 14:35:08'), (15, 'TR0011Lx9IGf81777581394050', 'Payment', 999, 1, '2026-04-30 20:36:34', '2026-04-30 20:37:09'), (16, 'TR0011Ld4rUAZ1777657348109', 'Payment', 999, 1, '2026-05-01 17:42:28', '2026-05-01 17:43:15'), (17, 'TR0011hbMnkQt1778318396847', 'Payment', 1, 1, '2026-05-09 09:19:56', '2026-05-09 09:20:32'), (18, 'TR0011JeoedQp1778319269211', 'Payment', 1, 1, '2026-05-09 09:34:29', '2026-05-09 09:34:58'), (19, 'TR0011f0HL8xz1778336614665', 'Payment', 1, 1, '2026-05-09 14:23:34', '2026-05-09 14:24:05'), (20, 'TR0011UHeDrgL1778336754037', 'Payment', 1, 1, '2026-05-09 14:25:54', '2026-05-09 14:26:21'), (21, 'TR0011an5da3m1778440251981', 'Payment', 1, 0, '2026-05-10 19:10:52', '2026-05-10 19:10:52'), (22, 'TR0011Kb4KsLk1778440254480', 'Payment', 1, 1, '2026-05-10 19:10:54', '2026-05-10 19:11:49'), (23, 'TR0011srRGnZH1778524107983', 'Payment', 1, 1, '2026-05-11 18:28:28', '2026-05-11 18:29:03'), (24, 'TR0011LSBqOeN1780058258716', 'Payment', 999, 0, '2026-05-29 12:37:38', '2026-05-29 12:37:38'), (25, 'TR0011IXDyngj1780079208741', 'Deposit', 500, 0, '2026-05-29 18:26:48', '2026-05-29 18:26:48'), (26, 'TR0011fkpum2l1780402402627', 'Payment', 999, 0, '2026-06-02 12:13:22', '2026-06-02 12:13:22'), (27, 'TR00112KveaGB1784383407863', 'Payment', 5000, 0, '2026-07-18 14:03:27', '2026-07-18 14:03:27'), (28, 'TR0011BWyIJJt1791492015540', 'Payment', 999, 0, '2026-10-08 20:40:15', '2026-10-08 20:40:15'), (29, 'TR0011Z2TU7rh1791493076089', 'Payment', 5000, 0, '2026-10-08 20:57:56', '2026-10-08 20:57:56'), (30, 'TR0011sADXpb71791493685726', 'Payment', 1, 1, '2026-10-08 21:08:05', '2026-10-08 21:08:39'), (31, 'TR0011WB22NNY1791495403895', 'Payment', 1, 0, '2026-10-08 21:36:43', '2026-10-08 21:36:43'), (32, 'TR0011uhBA6mE1791495536483', 'Payment', 1, 0, '2026-10-08 21:38:56', '2026-10-08 21:38:56'), (33, 'TR0011sacmqp61791534579158', 'Payment', 999, 1, '2026-10-09 08:29:39', '2026-10-09 08:30:23'), (34, 'TR0011UA3k3fo1791542063584', 'Payment', 999, 1, '2026-10-09 10:34:23', '2026-10-09 10:34:56'), (35, 'TR0011xAmtXhQ1791542203320', 'Payment', 999, 0, '2026-10-09 10:36:43', '2026-10-09 10:36:43'), (36, 'TR0011gVG1EnU1791542214686', 'Payment', 999, 1, '2026-10-09 10:36:54', '2026-10-09 10:37:19'), (37, 'TR001121ORMiY1791557235672', 'Payment', 999, 0, '2026-10-09 14:47:15', '2026-10-09 14:47:15'), (38, 'TR0011Vwlz3Y01791557552029', 'Payment', 999, 1, '2026-10-09 14:52:32', '2026-10-09 14:52:58'), (39, 'TR0011ro1ok1j1791559258283', 'Payment', 1, 1, '2026-10-09 15:20:58', '2026-10-09 15:21:35'), (40, 'TR0011MpMtucq1791559902165', 'Payment', 1, 0, '2026-10-09 15:31:42', '2026-10-09 15:31:42'), (41, 'TR0011J7Pk2yB1791559992830', 'Payment', 1, 1, '2026-10-09 15:33:12', '2026-10-09 15:33:51'); -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `title` longtext DEFAULT NULL, `slug` varchar(191) NOT NULL, `description` longtext DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `image` varchar(191) NOT NULL, `thumbnail` varchar(191) NOT NULL, `viewed` int(11) NOT NULL DEFAULT 0, `authored_date` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1, `tags` text DEFAULT NULL, `category_id` int(11) NOT NULL DEFAULT 0, `authored_time` text DEFAULT NULL, `audience` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1=public,2=Specify', `authored_date_time` timestamp NULL DEFAULT NULL, `position_audience` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1=public,2=Specify', `institute_id` int(11) DEFAULT NULL, `minutes` int(11) DEFAULT 0, `words_count` int(11) DEFAULT 0, `get_bonus` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `blog_categories` -- CREATE TABLE `blog_categories` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `title` longtext DEFAULT NULL, `position_order` int(11) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `parent_id` int(11) NOT NULL DEFAULT 0, `lms_id` int(11) NOT NULL DEFAULT 1, `tags` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `blog_categories` -- INSERT INTO `blog_categories` (`id`, `user_id`, `title`, `position_order`, `status`, `parent_id`, `lms_id`, `tags`, `created_at`, `updated_at`) VALUES (1, 1, '{\"en\":\"Technology\",\"bn\":\"প্রযুক্তি\"}', 1, 1, 0, 1, NULL, '2026-04-12 16:30:17', '2026-04-12 16:32:59'), (2, 1, '{\"en\":\"Programming & Development\",\"bn\":\"প্রোগ্রামিং ও ডেভেলপমেন্ট\"}', 2, 1, 0, 1, NULL, '2026-04-12 16:30:25', '2026-04-12 16:32:52'), (3, 1, '{\"en\":\"Digital Marketing\",\"bn\":\"ডিজিটাল মার্কেটিং\"}', 3, 1, 0, 1, NULL, '2026-04-12 16:30:33', '2026-04-12 16:32:43'), (4, 1, '{\"en\":\"Freelancing Tips\",\"bn\":\"ফ্রিল্যান্সিং টিপস\"}', 4, 1, 0, 1, NULL, '2026-04-12 16:30:37', '2026-04-12 16:32:33'), (5, 1, '{\"en\":\"Online Earning\",\"bn\":\"অনলাইন ইনকাম\"}', 5, 1, 0, 1, NULL, '2026-04-12 16:30:47', '2026-04-12 16:32:15'), (6, 1, '{\"en\":\"Graphic Design\",\"bn\":\"গ্রাফিক ডিজাইন\"}', 6, 1, 0, 1, NULL, '2026-04-12 16:30:52', '2026-04-12 16:32:03'), (7, 1, '{\"en\":\"Success Stories\",\"bn\":\"সফলতার গল্প\"}', 7, 1, 0, 1, NULL, '2026-04-12 16:31:04', '2026-04-12 16:31:49'), (8, 1, '{\"en\":\"Motivation\",\"bn\":\"অনুপ্রেরণা\"}', 8, 1, 0, 1, NULL, '2026-04-12 16:31:15', '2026-04-12 16:31:34'); -- -------------------------------------------------------- -- -- Table structure for table `blog_comments` -- CREATE TABLE `blog_comments` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(11) DEFAULT NULL, `name` text DEFAULT NULL, `email` text DEFAULT NULL, `comment` text DEFAULT NULL, `comment_id` int(11) DEFAULT NULL, `blog_id` int(11) NOT NULL, `type` tinyint(4) NOT NULL DEFAULT 1, `lms_id` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `blog_comment_replies_replies` -- CREATE TABLE `blog_comment_replies_replies` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `name` text DEFAULT NULL, `email` text DEFAULT NULL, `blog_id` int(10) UNSIGNED NOT NULL, `comment_id` int(10) UNSIGNED NOT NULL, `reply_id` int(10) UNSIGNED NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `reply` text NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bookmark_courses` -- CREATE TABLE `bookmark_courses` ( `id` int(10) UNSIGNED NOT NULL, `course_id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `lesson_id` int(10) UNSIGNED DEFAULT NULL, `chapter_id` int(10) UNSIGNED DEFAULT NULL, `date` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `business_settings` -- CREATE TABLE `business_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `type` varchar(200) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `business_settings` -- INSERT INTO `business_settings` (`id`, `type`, `status`, `created_at`, `updated_at`, `lms_id`) VALUES (1, 'email_verification', 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1), (2, 'language_translation', 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1), (3, 'frontend_language_translation', 1, NULL, '2026-04-10 08:31:35', 1), (4, 'student_registration_auto_approval', 1, NULL, '2026-04-10 08:31:54', 1), (5, 'instructor_registration_auto_approval', 0, NULL, NULL, 1), (6, 'topic_comment_auto_approval', 0, NULL, '2026-04-18 18:38:36', 1), (7, 'topic_review_auto_approval', 0, NULL, '2026-04-18 18:38:36', 1), (8, 'blog_comment_auto_approval', 0, NULL, '2026-04-18 18:38:35', 1), (9, 'show_coupon_input', 0, '2026-10-10 07:17:23', '2026-10-10 07:25:05', 1); -- -------------------------------------------------------- -- -- Table structure for table `carts` -- CREATE TABLE `carts` ( `id` int(10) UNSIGNED NOT NULL, `course_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `instructor_id` int(11) NOT NULL, `tracking` varchar(191) NOT NULL, `price` float DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `qty` int(11) NOT NULL DEFAULT 1, `is_store` tinyint(1) NOT NULL DEFAULT 0, `lms_id` int(11) NOT NULL DEFAULT 1, `coupon_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `carts` -- INSERT INTO `carts` (`id`, `course_id`, `user_id`, `instructor_id`, `tracking`, `price`, `created_at`, `updated_at`, `qty`, `is_store`, `lms_id`, `coupon_id`) VALUES (4, 1, 3, 1, '6X5TZ726NVVP', 999, '2026-04-15 17:01:36', '2026-07-18 14:01:00', 1, 0, 1, NULL), (5, 1, 2, 1, 'SC4NM1QYSP38', 999, '2026-04-15 17:03:16', '2026-04-15 17:03:17', 1, 0, 1, NULL), (10, 1, 27, 1, '14RFUXVNZM5X', 999, '2026-05-01 18:14:37', '2026-05-01 18:14:38', 1, 0, 1, NULL), (17, 4, 44, 7, '53CBVSEW7B1U', 99, '2026-05-29 12:32:03', '2026-05-29 12:36:01', 1, 0, 1, NULL), (18, 4, 4, 7, 'Y5GMG6T7BOYJ', 99, '2026-06-02 12:13:09', '2026-06-02 12:13:10', 1, 0, 1, NULL), (19, 4, 62, 7, '78MB3JNW4PV7', 99, '2026-06-10 17:17:08', '2026-06-10 17:17:08', 1, 0, 1, NULL), (22, 3, 14, 7, 'VJB41HD716QF', 5000, '2026-07-18 14:03:08', '2026-07-18 14:03:09', 1, 0, 1, NULL), (23, 1, 102, 7, 'S4VFM7DTCPOJ', 999, '2026-10-08 20:39:33', '2026-10-08 20:39:34', 1, 0, 1, NULL), (33, 5, 106, 7, 'VUDPZRU5DXPO', 3000, '2026-10-09 11:17:12', '2026-10-09 11:17:13', 1, 0, 1, NULL), (34, 5, 105, 7, 'ZKV9NY8ZNAK7', 3000, '2026-10-09 11:26:24', '2026-10-09 11:26:25', 1, 0, 1, NULL), (35, 1, 12, 7, 'XZV6RJ78TSJM', 999, '2026-10-09 14:44:15', '2026-10-09 14:44:33', 1, 0, 1, NULL), (39, 4, 109, 7, 'Z9326JMPJSSH', 99, '2026-10-09 15:31:40', '2026-10-09 15:31:40', 1, 0, 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(10) UNSIGNED NOT NULL, `name` longtext DEFAULT NULL, `user_id` int(11) NOT NULL DEFAULT 1, `status` tinyint(1) NOT NULL DEFAULT 1, `title` varchar(191) DEFAULT NULL, `description` longtext DEFAULT NULL, `url` varchar(191) DEFAULT NULL, `show_home` tinyint(1) NOT NULL DEFAULT 0, `position_order` int(11) NOT NULL, `image` varchar(191) DEFAULT NULL, `thumbnail` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1, `total_courses` int(11) DEFAULT 0, `total_quizzes` int(11) DEFAULT 0, `color` varchar(191) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `user_id`, `status`, `title`, `description`, `url`, `show_home`, `position_order`, `image`, `thumbnail`, `created_at`, `updated_at`, `parent_id`, `lms_id`, `total_courses`, `total_quizzes`, `color`) VALUES (1, '{\"en\":\"SMM BUSINESS\",\"bn\":\"এসএমএম ব্যবসা\"}', 1, 1, NULL, '{\"bn\":\" \",\"en\":\" \"}', NULL, 0, 9, 'https://samratitinstitute.com/public/uploads/main/files/17-04-2026/13089687-20260417092652-c9fb0b.png', NULL, '2026-04-10 07:13:44', '2026-06-12 17:11:45', NULL, 1, 2, NULL, NULL), (2, '{\"en\":\"E-Commerce Business\",\"bn\":\"ই-কমার্স ব্যবসা\"}', 1, 1, NULL, '{\"bn\":\" \",\"en\":\" \"}', NULL, 0, 7, 'https://samratitinstitute.com/public/uploads/main/files/17-04-2026/13089687-20260417092652-c9fb0b.png', NULL, '2026-04-18 18:16:26', '2026-06-12 17:11:45', NULL, 1, 0, 0, NULL), (3, '{\"en\":\"Digital Marketing\",\"bn\":\"ডিজিটাল মার্কেটিং\"}', 1, 1, NULL, '{\"bn\":\" \",\"en\":\" \"}', NULL, 0, 5, 'https://samratitinstitute.com/public/uploads/main/files/17-04-2026/13089687-20260417092652-c9fb0b.png', NULL, '2026-04-18 20:36:52', '2026-06-12 17:11:45', NULL, 1, 0, NULL, NULL), (4, '{\"bn\":\"ডোমেইন হোস্টিং ব্যবসা\",\"en\":\"Domain Hosting Business\"}', 1, 1, NULL, '{\"bn\":\" \",\"en\":\" \"}', NULL, 0, 3, 'https://samratitinstitute.com/public/uploads/main/files/17-04-2026/13089687-20260417092652-c9fb0b.png', NULL, '2026-04-18 20:39:41', '2026-06-12 17:11:45', NULL, 1, 0, 0, NULL), (5, '{\"en\":\"3-in-1 Digital Business Mastery\"}', 1, 1, NULL, '{\"en\":null}', NULL, 0, 2, 'https://samratitinstitute.com/public/uploads/main/files/26-05-2026/chatgpt-image-may-26-2026-04-40-26-am-20260526054608-09a0d4.png', NULL, '2026-05-25 23:48:05', '2026-06-12 17:11:45', NULL, 1, 1, NULL, NULL), (6, '{\"en\":\"🕌 Quran Learning Mastery Course\"}', 1, 1, NULL, '{\"en\":null}', NULL, 0, 1, 'https://samratitinstitute.com/public/uploads/main/files/12-06-2026/chatgpt-image-jun-12-2026-11-10-24-pm-20260612231044-40e4bb.png', 'https://samratitinstitute.com/public/uploads/main/files/12-06-2026/chatgpt-image-jun-12-2026-10-59-25-pm-20260612230709-d1219e.png', '2026-06-12 17:11:45', '2026-06-12 17:34:44', NULL, 1, 1, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `certificates` -- CREATE TABLE `certificates` ( `id` bigint(20) UNSIGNED NOT NULL, `image` varchar(191) DEFAULT NULL, `title` varchar(191) DEFAULT NULL, `title_position_x` int(11) NOT NULL DEFAULT 0, `title_position_y` int(11) NOT NULL DEFAULT 0, `title_font_family` varchar(191) DEFAULT NULL, `title_font_size` int(11) NOT NULL DEFAULT 30, `title_font_color` varchar(191) DEFAULT NULL, `body` text DEFAULT NULL, `body_position_x` int(11) NOT NULL DEFAULT 0, `body_position_y` int(11) NOT NULL DEFAULT 0, `body_font_family` varchar(191) DEFAULT NULL, `body_font_size` int(11) NOT NULL DEFAULT 10, `body_font_color` varchar(191) DEFAULT NULL, `body_max_len` varchar(191) DEFAULT NULL, `profile` tinyint(4) NOT NULL DEFAULT 1, `profile_x` int(11) NOT NULL DEFAULT 0, `profile_y` int(11) NOT NULL DEFAULT 0, `profile_height` int(11) DEFAULT NULL, `profile_weight` int(11) NOT NULL DEFAULT 10, `name` int(11) NOT NULL DEFAULT 1, `name_position_x` int(11) NOT NULL DEFAULT 0, `name_position_y` int(11) NOT NULL DEFAULT 0, `name_font_family` varchar(191) DEFAULT NULL, `name_font_size` int(11) NOT NULL DEFAULT 50, `name_font_color` varchar(191) DEFAULT NULL, `date` tinyint(4) NOT NULL DEFAULT 1, `date_position_x` int(11) NOT NULL DEFAULT 0, `date_position_y` int(11) NOT NULL DEFAULT 0, `date_font_family` varchar(191) DEFAULT NULL, `date_font_size` int(11) NOT NULL DEFAULT 30, `date_font_color` varchar(191) DEFAULT NULL, `date_format` int(11) NOT NULL DEFAULT 1, `signature` varchar(191) DEFAULT NULL, `signature_position_x` int(11) NOT NULL DEFAULT 0, `signature_position_y` int(11) NOT NULL DEFAULT 0, `signature_height` int(11) DEFAULT NULL, `signature_weight` int(11) NOT NULL DEFAULT 10, `signature_text` varchar(191) DEFAULT NULL, `signature_text_position_x` int(11) NOT NULL DEFAULT 0, `signature_text_position_y` int(11) NOT NULL DEFAULT 0, `signature_text_font_family` varchar(191) DEFAULT NULL, `signature_text_font_size` int(11) NOT NULL DEFAULT 30, `signature_text_font_color` varchar(191) DEFAULT NULL, `for_course` tinyint(4) NOT NULL DEFAULT 0, `for_quiz` tinyint(4) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `certificate_no` int(11) DEFAULT NULL, `certificate_no_position_x` int(11) DEFAULT NULL, `certificate_no_position_y` int(11) DEFAULT NULL, `certificate_no_font_family` varchar(191) DEFAULT NULL, `certificate_no_font_size` varchar(191) DEFAULT NULL, `certificate_no_font_color` varchar(191) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `for_class` int(11) DEFAULT NULL, `qr` tinyint(4) NOT NULL DEFAULT 0, `qr_x` int(11) NOT NULL DEFAULT 0, `qr_y` int(11) NOT NULL DEFAULT 0, `qr_height` int(11) DEFAULT NULL, `qr_weight` int(11) NOT NULL DEFAULT 10, `lms_id` int(11) NOT NULL DEFAULT 1, `show_title` int(11) NOT NULL DEFAULT 1, `certificate_number_prefix` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `certificates` -- INSERT INTO `certificates` (`id`, `image`, `title`, `title_position_x`, `title_position_y`, `title_font_family`, `title_font_size`, `title_font_color`, `body`, `body_position_x`, `body_position_y`, `body_font_family`, `body_font_size`, `body_font_color`, `body_max_len`, `profile`, `profile_x`, `profile_y`, `profile_height`, `profile_weight`, `name`, `name_position_x`, `name_position_y`, `name_font_family`, `name_font_size`, `name_font_color`, `date`, `date_position_x`, `date_position_y`, `date_font_family`, `date_font_size`, `date_font_color`, `date_format`, `signature`, `signature_position_x`, `signature_position_y`, `signature_height`, `signature_weight`, `signature_text`, `signature_text_position_x`, `signature_text_position_y`, `signature_text_font_family`, `signature_text_font_size`, `signature_text_font_color`, `for_course`, `for_quiz`, `created_at`, `updated_at`, `certificate_no`, `certificate_no_position_x`, `certificate_no_position_y`, `certificate_no_font_family`, `certificate_no_font_size`, `certificate_no_font_color`, `created_by`, `for_class`, `qr`, `qr_x`, `qr_y`, `qr_height`, `qr_weight`, `lms_id`, `show_title`, `certificate_number_prefix`) VALUES (2, 'public/uploads/certificate/e72d9ccc966cc2d423dc778c4896f82d.png', 'Certificate Of Achievement', 0, -10, 'Arial', 50, '#d1af67', 'This is to certify that [name] has successfully completed the course [course].The participant has demonstrated dedication and achieved the required competencies during the program.We congratulate [name] and wish them continued success in their future endeavors.', 0, 40, 'Arial', 20, '#d1af67', '80', 0, 0, 0, 120, 120, 1, 0, 20, 'Arial', 35, '#d1af67', 1, -350, 420, 'Arial', 20, '#d1af67', 1, 'public/uploads/certificate/04a4737a708e1e5ee8f5128bb99c3ea7.png', -30, -310, 100, 170, 'Signature', 250, 10, 'Arial', 20, '#d1af67', 1, 0, '2026-04-12 15:52:03', '2026-04-18 16:55:48', 1, -350, 50, 'Arial', '15', '#5d5b5b', 1, 0, 1, -200, 150, 120, 120, 1, 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `certificate_fonts` -- CREATE TABLE `certificate_fonts` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `title` varchar(191) NOT NULL, `font` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1, `rtl` tinyint(4) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `certificate_fonts` -- INSERT INTO `certificate_fonts` (`id`, `name`, `title`, `font`, `created_at`, `updated_at`, `lms_id`, `rtl`) VALUES (1, 'Rengkox', 'Rengkox', 'https://samratitinstitute.com/public/uploads/main/files/12-04-2026/rengkoxpersonal-20260412215730-a966dd.otf', '2026-04-12 15:57:45', '2026-04-12 15:57:45', 1, 0), (2, 'Silentha', 'Silentha', 'https://samratitinstitute.com/public/uploads/main/files/12-04-2026/silentha-ot-20260412215951-791993.ttf', '2026-04-12 16:00:00', '2026-04-12 16:00:00', 1, 0), (3, 'Times New Roman', 'Times New Roman', 'https://samratitinstitute.com/public/uploads/main/files/12-04-2026/times-20260412220314-27bd38.ttf', '2026-04-12 16:03:21', '2026-04-12 16:03:21', 1, 0), (4, 'Arial', 'Arial', 'https://samratitinstitute.com/public/uploads/main/files/12-04-2026/arial-20260412220400-0f16ba.ttf', '2026-04-12 16:04:13', '2026-04-12 16:04:13', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `certificate_records` -- CREATE TABLE `certificate_records` ( `id` bigint(20) UNSIGNED NOT NULL, `certificate_id` varchar(191) DEFAULT NULL, `student_id` int(11) DEFAULT NULL, `course_id` int(11) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `certificate_records` -- INSERT INTO `certificate_records` (`id`, `certificate_id`, `student_id`, `course_id`, `created_by`, `created_at`, `updated_at`, `lms_id`) VALUES (1, '159265', 11, 1, 11, '2026-04-17 16:56:30', '2026-04-17 16:56:30', 1), (2, '821704', 14, 1, 14, '2026-04-30 20:39:38', '2026-04-30 20:39:38', 1), (3, '648010', 16, 1, 16, '2026-05-01 17:45:21', '2026-05-01 17:45:21', 1), (4, '304404', 4, 3, 4, '2026-05-09 09:40:42', '2026-05-09 09:40:42', 1), (5, '118400', 38, 3, 38, '2026-05-10 19:24:18', '2026-05-10 19:24:18', 1), (6, '491818', 39, 3, 39, '2026-05-17 18:19:32', '2026-05-17 18:19:32', 1), (7, '257565', 46, 4, 46, '2026-06-06 08:10:40', '2026-06-06 08:10:40', 1), (8, '505905', 55, 4, 55, '2026-06-07 18:03:47', '2026-06-07 18:03:47', 1), (9, '220091', 49, 4, 49, '2026-06-08 19:49:06', '2026-06-08 19:49:06', 1), (10, '778977', 28, 4, 28, '2026-06-09 08:46:21', '2026-06-09 08:46:21', 1), (11, '346851', 24, 4, 24, '2026-06-09 21:02:15', '2026-06-09 21:02:15', 1), (12, '223413', 19, 4, 19, '2026-06-10 20:38:12', '2026-06-10 20:38:12', 1), (13, '690819', 64, 4, 64, '2026-06-11 13:28:27', '2026-06-11 13:28:27', 1), (14, '576980', 63, 4, 63, '2026-06-12 05:31:35', '2026-06-12 05:31:35', 1), (15, '527300', 61, 4, 61, '2026-06-16 19:06:39', '2026-06-16 19:06:39', 1), (16, '378243', 43, 4, 43, '2026-06-17 11:10:52', '2026-06-17 11:10:52', 1), (17, '582700', 60, 4, 60, '2026-06-25 21:09:56', '2026-06-25 21:09:56', 1), (18, '947078', 22, 4, 22, '2026-07-07 08:32:39', '2026-07-07 08:32:39', 1), (19, '300223', 72, 4, 72, '2026-07-11 04:08:53', '2026-07-11 04:08:53', 1), (20, '537360', 73, 4, 73, '2026-07-21 13:37:24', '2026-07-21 13:37:24', 1); -- -------------------------------------------------------- -- -- Table structure for table `chapters` -- CREATE TABLE `chapters` ( `id` int(10) UNSIGNED NOT NULL, `course_id` int(11) NOT NULL, `name` varchar(191) NOT NULL, `chapter_no` int(11) NOT NULL, `is_lock` tinyint(1) NOT NULL DEFAULT 1, `unlock_date` date DEFAULT NULL, `unlock_days` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `position` int(11) NOT NULL DEFAULT 999999, `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `chapters` -- INSERT INTO `chapters` (`id`, `course_id`, `name`, `chapter_no`, `is_lock`, `unlock_date`, `unlock_days`, `created_at`, `updated_at`, `position`, `lms_id`) VALUES (1, 1, 'SMM Business Mastery Course', 1, 1, NULL, NULL, '2026-04-10 18:19:25', '2026-04-17 16:31:56', 999999, 1), (5, 3, 'SMM PANNEL ADMIN MANAGE COURSE', 1, 1, NULL, NULL, '2026-05-08 22:13:35', '2026-05-08 22:14:14', 999999, 1), (6, 4, '3-in-1 Digital Business Mastery', 1, 1, NULL, NULL, '2026-05-25 23:51:45', '2026-05-25 23:51:45', 999999, 1), (7, 5, 'Quran Learning Mastery Course', 1, 1, NULL, NULL, '2026-06-12 17:24:55', '2026-06-12 17:24:55', 999999, 1); -- -------------------------------------------------------- -- -- Table structure for table `chat_notifications` -- CREATE TABLE `chat_notifications` ( `id` char(36) NOT NULL, `type` varchar(191) NOT NULL, `notifiable_type` varchar(191) NOT NULL, `notifiable_id` bigint(20) UNSIGNED NOT NULL, `data` text NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `checkouts` -- CREATE TABLE `checkouts` ( `id` int(10) UNSIGNED NOT NULL, `tracking` varchar(191) NOT NULL, `user_id` int(11) NOT NULL, `billing_detail_id` bigint(20) UNSIGNED DEFAULT NULL, `package_id` int(11) DEFAULT NULL, `coupon_id` int(11) DEFAULT NULL, `discount` float DEFAULT 0, `purchase_price` float DEFAULT 0, `price` float DEFAULT 0, `status` tinyint(1) NOT NULL DEFAULT 0, `payment_method` varchar(191) DEFAULT NULL, `response` longtext DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1, `cart_count` int(11) DEFAULT 0, `has_gift` int(11) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `checkouts` -- INSERT INTO `checkouts` (`id`, `tracking`, `user_id`, `billing_detail_id`, `package_id`, `coupon_id`, `discount`, `purchase_price`, `price`, `status`, `payment_method`, `response`, `created_at`, `updated_at`, `lms_id`, `cart_count`, `has_gift`) VALUES (1, 'KW63D2Z4OHKO', 3, 1, NULL, NULL, 0, 999, 999, 1, 'Bkash', '{\"paymentID\":\"TR00114slvWOC1775845773656\",\"status\":\"success\",\"signature\":\"04NfVccQk4\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-04-10 07:26:51', '2026-04-10 18:30:26', 1, 1, 0), (2, 'Y1F59CBJ93BX', 4, 2, NULL, NULL, 0, 1, 1, 1, 'Bkash', '{\"paymentID\":\"TR0011JeoedQp1778319269211\",\"status\":\"success\",\"signature\":\"knunhqrH9K\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-04-10 21:02:50', '2026-05-09 09:34:58', 1, 1, 0), (3, '9SQO7WXW9MW1', 3, 1, NULL, NULL, 0, 1, 1, 0, NULL, NULL, '2026-04-11 20:55:39', '2026-04-11 20:55:50', 1, 1, 0), (4, '6X5TZ726NVVP', 3, 1, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-04-15 17:01:39', '2026-04-15 17:01:45', 1, 1, 0), (5, 'SC4NM1QYSP38', 2, 3, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-04-15 17:03:17', '2026-04-15 17:03:25', 1, 1, 0), (6, '3C7A3P1YUSX3', 11, 4, NULL, NULL, 0, 999, 999, 1, 'Bkash', '{\"paymentID\":\"TR0011XABaBrr1776444560774\",\"status\":\"success\",\"signature\":\"T00u5gW3UH\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-04-17 16:48:30', '2026-04-17 16:50:05', 1, 1, 0), (7, '6RAE9P2HVVRK', 12, NULL, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-04-18 20:41:36', '2026-04-18 20:41:36', 1, 1, 0), (8, 'VCJEB6ZW67VO', 14, 5, NULL, NULL, 0, 999, 999, 1, 'Bkash', '{\"paymentID\":\"TR0011Lx9IGf81777581394050\",\"status\":\"success\",\"signature\":\"u0ASsOmMFr\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-04-30 20:34:19', '2026-04-30 20:37:09', 1, 1, 0), (9, 'M1VQ2DGCMYWB', 16, 6, NULL, NULL, 0, 999, 999, 1, 'Bkash', '{\"paymentID\":\"TR0011Ld4rUAZ1777657348109\",\"status\":\"success\",\"signature\":\"e0pnUi3mIw\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-05-01 17:42:15', '2026-05-01 17:43:15', 1, 1, 0), (10, '14RFUXVNZM5X', 27, NULL, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-05-01 18:14:38', '2026-05-01 18:14:38', 1, 1, 0), (11, 'J75MMNPT6DE5', 16, 6, NULL, NULL, 0, 1, 1, 1, 'Bkash', '{\"paymentID\":\"TR0011hbMnkQt1778318396847\",\"status\":\"success\",\"signature\":\"bIEuP3LXiF\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-05-09 09:19:42', '2026-05-09 09:20:32', 1, 1, 0), (12, 'H3MKYR1ECS8W', 19, 7, NULL, NULL, 0, 1, 1, 1, 'Bkash', '{\"paymentID\":\"TR0011f0HL8xz1778336614665\",\"status\":\"success\",\"signature\":\"o2CWQMCjfd\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-05-09 14:23:07', '2026-05-09 14:24:05', 1, 1, 0), (13, 'AQ5DTBF25EYZ', 21, 8, NULL, NULL, 0, 1, 1, 1, 'Bkash', '{\"paymentID\":\"TR0011UHeDrgL1778336754037\",\"status\":\"success\",\"signature\":\"Y0Ti8gDG43\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-05-09 14:25:41', '2026-05-09 14:26:21', 1, 1, 0), (14, '6AP55TOUS3EZ', 38, 9, NULL, NULL, 0, 1, 1, 1, 'Bkash', '{\"paymentID\":\"TR0011Kb4KsLk1778440254480\",\"status\":\"success\",\"signature\":\"LQq231lqkd\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-05-10 19:09:43', '2026-05-10 19:11:49', 1, 1, 0), (15, '61EHT6H431WD', 39, 10, NULL, NULL, 0, 1, 1, 1, 'Bkash', '{\"paymentID\":\"TR0011srRGnZH1778524107983\",\"status\":\"success\",\"signature\":\"l8OXviYEfI\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-05-11 18:27:46', '2026-05-11 18:29:03', 1, 1, 0), (16, '53CBVSEW7B1U', 44, 11, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-05-29 12:36:01', '2026-05-29 12:37:18', 1, 1, 0), (17, 'Y5GMG6T7BOYJ', 4, 2, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-06-02 12:13:10', '2026-06-02 12:13:16', 1, 1, 0), (18, 'W2A8KAE9Q1WC', 73, 12, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-07-12 12:29:11', '2026-07-12 12:30:51', 1, 1, 0), (19, 'VJB41HD716QF', 14, 5, NULL, NULL, 0, 5000, 5000, 0, NULL, NULL, '2026-07-18 14:03:09', '2026-07-18 14:03:22', 1, 1, 0), (20, 'S4VFM7DTCPOJ', 102, 13, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-10-08 20:39:34', '2026-10-08 20:40:05', 1, 1, 0), (21, '9FFSHU45VSR8', 103, 14, NULL, NULL, 0, 5000, 5000, 0, NULL, NULL, '2026-10-08 20:57:54', '2026-10-08 20:57:54', 0, 1, 0), (22, 'SQCX9G7UYJQQ', 103, 15, NULL, NULL, 0, 1, 1, 1, 'Bkash', '{\"paymentID\":\"TR0011sADXpb71791493685726\",\"status\":\"success\",\"signature\":\"DRxzv4JMzO\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-10-08 21:08:04', '2026-10-08 21:08:39', 1, 1, 0), (23, 'YKXENNM8YFO7', 103, NULL, NULL, NULL, 0, 5000, 5000, 0, NULL, NULL, '2026-10-08 21:20:24', '2026-10-08 21:20:24', 1, 1, 0), (24, '87XXOCCGQHJB', 104, 16, NULL, NULL, 0, 1, 1, 0, NULL, NULL, '2026-10-08 21:36:42', '2026-10-08 21:37:12', 1, 1, 0), (25, 'Y83G8WM1YNVS', 104, 17, NULL, NULL, 0, 1, 1, 0, NULL, NULL, '2026-10-08 21:38:55', '2026-10-08 21:38:55', 1, 1, 0), (26, '1AHBCBJQUYYJ', 105, 18, NULL, NULL, 0, 999, 999, 1, 'Bkash', '{\"paymentID\":\"TR0011sacmqp61791534579158\",\"status\":\"success\",\"signature\":\"6moZmraaxI\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-10-09 08:29:37', '2026-10-09 08:30:23', 0, 1, 0), (27, 'TN2PHMMHY4Y9', 106, 19, NULL, NULL, 0, 999, 999, 1, 'Bkash', '{\"paymentID\":\"TR0011UA3k3fo1791542063584\",\"status\":\"success\",\"signature\":\"YU02oaFtit\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-10-09 10:34:22', '2026-10-09 10:34:56', 0, 1, 0), (28, '3FUCVX8RFMP7', 106, 20, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-10-09 10:36:42', '2026-10-09 10:36:42', 1, 1, 0), (29, 'TBAMMRBKKNHT', 106, 21, NULL, NULL, 0, 999, 999, 1, 'Bkash', '{\"paymentID\":\"TR0011gVG1EnU1791542214686\",\"status\":\"success\",\"signature\":\"zuzBzyxB0H\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-10-09 10:36:53', '2026-10-09 10:37:19', 1, 1, 0), (30, 'VUDPZRU5DXPO', 106, 21, NULL, NULL, 0, 3000, 3000, 0, NULL, NULL, '2026-10-09 11:17:13', '2026-10-09 11:19:39', 1, 1, 0), (31, 'ZKV9NY8ZNAK7', 105, 18, NULL, NULL, 0, 3000, 3000, 0, NULL, NULL, '2026-10-09 11:26:25', '2026-10-09 11:26:41', 1, 1, 0), (32, 'XZV6RJ78TSJM', 12, NULL, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-10-09 14:44:16', '2026-10-09 14:44:16', 1, 1, 0), (33, 'AMBFHN7B4QDH', 107, 22, NULL, NULL, 0, 999, 999, 0, NULL, NULL, '2026-10-09 14:47:13', '2026-10-09 14:49:32', 1, 1, 0), (34, '4Y2CSS4TU67P', 107, 23, NULL, NULL, 0, 999, 999, 1, 'Bkash', '{\"paymentID\":\"TR0011Vwlz3Y01791557552029\",\"status\":\"success\",\"signature\":\"OXvLJ5soNt\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-10-09 14:52:29', '2026-10-09 14:52:58', 1, 1, 0), (35, 'Z3N23K8MSKZ1', 108, 24, NULL, NULL, 0, 1, 1, 1, 'Bkash', '{\"paymentID\":\"TR0011ro1ok1j1791559258283\",\"status\":\"success\",\"signature\":\"7iOsMJHqTa\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-10-09 15:20:56', '2026-10-09 15:21:35', 0, 1, 0), (36, 'Z9326JMPJSSH', 109, 25, NULL, NULL, 0, 1, 1, 0, NULL, NULL, '2026-10-09 15:31:40', '2026-10-09 15:31:40', 0, 1, 0), (37, 'FH2RPGQP3TC7', 110, 26, NULL, NULL, 0, 1, 1, 1, 'Bkash', '{\"paymentID\":\"TR0011J7Pk2yB1791559992830\",\"status\":\"success\",\"signature\":\"foRoBsfuQI\",\"apiVersion\":\"1.2.0-beta\\/\"}', '2026-10-09 15:33:11', '2026-10-09 15:33:50', 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `class_completes` -- CREATE TABLE `class_completes` ( `id` bigint(20) UNSIGNED NOT NULL, `course_id` bigint(20) UNSIGNED NOT NULL, `class_id` bigint(20) UNSIGNED NOT NULL, `host` varchar(191) NOT NULL, `meeting_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `status` int(11) NOT NULL DEFAULT 1 COMMENT '1 => complete 0 => incomplete', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `enroll_id` int(11) DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `class_records` -- CREATE TABLE `class_records` ( `id` bigint(20) UNSIGNED NOT NULL, `class_id` int(11) NOT NULL, `meeting_id` int(11) NOT NULL, `title` varchar(191) DEFAULT NULL, `url` text DEFAULT NULL, `host` varchar(191) NOT NULL DEFAULT 'self', `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `class_settings` -- CREATE TABLE `class_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `default_class` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 => Zoom 1 => BBB', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `class_settings` -- INSERT INTO `class_settings` (`id`, `default_class`, `created_at`, `updated_at`, `lms_id`) VALUES (1, 0, '2026-04-09 21:34:27', '2026-04-09 21:34:27', 1); -- -------------------------------------------------------- -- -- Table structure for table `cookie_settings` -- CREATE TABLE `cookie_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) DEFAULT NULL, `details` text DEFAULT NULL, `btn_text` varchar(191) NOT NULL DEFAULT 'Accept', `text_color` varchar(191) NOT NULL DEFAULT '#fff', `bg_color` varchar(191) NOT NULL DEFAULT '#FB1159', `allow` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `image` varchar(191) NOT NULL DEFAULT 'public/frontend/infixlmstheme/img/icon/cookies_icon.svg', `lms_id` int(11) NOT NULL DEFAULT 1, `customize_btn_text` varchar(191) DEFAULT NULL, `gdpr_details` text DEFAULT NULL, `gdpr_strictly` text DEFAULT NULL, `gdpr_performance` text DEFAULT NULL, `gdpr_functional` text DEFAULT NULL, `gdpr_targeting` text DEFAULT NULL, `gdpr_confirm_choice_btn_text` varchar(191) DEFAULT NULL, `gdpr_accept_all_btn_text` varchar(191) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cookie_settings` -- INSERT INTO `cookie_settings` (`id`, `title`, `details`, `btn_text`, `text_color`, `bg_color`, `allow`, `created_at`, `updated_at`, `image`, `lms_id`, `customize_btn_text`, `gdpr_details`, `gdpr_strictly`, `gdpr_performance`, `gdpr_functional`, `gdpr_targeting`, `gdpr_confirm_choice_btn_text`, `gdpr_accept_all_btn_text`) VALUES (1, 'Cookies', 'We collect and use cookies to give you the best and most relevant website experience. Kindly accept the cookies. Privacy Policy', 'I Accept', '#f8d4be', '#ffede2', 1, '2026-04-09 21:34:30', '2026-04-12 16:45:28', '', 1, 'Customize Setting', 'When you visit any of our websites, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and manage your preferences. Please note, that blocking some types of cookies may impact your experience of the site and the services we are able to offer', 'These cookies are necessary for our website to function properly and cannot be switched off in our systems. They are usually only set in response to actions made by you that amount to a request for services, such as setting your privacy preferences, logging in or filling in forms, or where they’re essential to providing you with a service you have requested. You cannot opt out of these cookies. You can set your browser to block or alert you about these cookies, but if you do, some parts of the site will not then work. These cookies do not store any personally identifiable information', 'These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site, which helps us optimize your experience. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not be able to use your data in this way.', 'These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third-party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.', 'These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.', 'Confirm My Choices', 'Accept All'); -- -------------------------------------------------------- -- -- Table structure for table `countries` -- CREATE TABLE `countries` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) DEFAULT NULL, `iso3` varchar(10) DEFAULT NULL, `iso2` varchar(10) DEFAULT NULL, `phonecode` varchar(30) DEFAULT NULL, `currency` varchar(30) DEFAULT NULL, `capital` varchar(50) DEFAULT NULL, `active_status` tinyint(4) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `countries` -- INSERT INTO `countries` (`id`, `name`, `iso3`, `iso2`, `phonecode`, `currency`, `capital`, `active_status`, `created_at`, `updated_at`, `lms_id`) VALUES (1, 'Afghanistan', 'AFG', 'AF', '93', 'AFN', 'Kabul', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (2, 'Aland Islands', 'ALA', 'AX', '+358-18', 'EUR', 'Mariehamn', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (3, 'Albania', 'ALB', 'AL', '355', 'ALL', 'Tirana', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (4, 'Algeria', 'DZA', 'DZ', '213', 'DZD', 'Algiers', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (5, 'American Samoa', 'ASM', 'AS', '+1-684', 'USD', 'Pago Pago', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (6, 'Andorra', 'AND', 'AD', '376', 'EUR', 'Andorra la Vella', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (7, 'Angola', 'AGO', 'AO', '244', 'AOA', 'Luanda', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (8, 'Anguilla', 'AIA', 'AI', '+1-264', 'XCD', 'The Valley', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (9, 'Antarctica', 'ATA', 'AQ', '', '', '', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (10, 'Antigua And Barbuda', 'ATG', 'AG', '+1-268', 'XCD', 'St. Johns', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (11, 'Argentina', 'ARG', 'AR', '54', 'ARS', 'Buenos Aires', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (12, 'Armenia', 'ARM', 'AM', '374', 'AMD', 'Yerevan', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (13, 'Aruba', 'ABW', 'AW', '297', 'AWG', 'Oranjestad', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (14, 'Australia', 'AUS', 'AU', '61', 'AUD', 'Canberra', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (15, 'Austria', 'AUT', 'AT', '43', 'EUR', 'Vienna', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (16, 'Azerbaijan', 'AZE', 'AZ', '994', 'AZN', 'Baku', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (17, 'Bahamas The', 'BHS', 'BS', '+1-242', 'BSD', 'Nassau', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (18, 'Bahrain', 'BHR', 'BH', '973', 'BHD', 'Manama', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (19, 'Bangladesh', 'BGD', 'BD', '880', 'BDT', 'Dhaka', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (20, 'Barbados', 'BRB', 'BB', '+1-246', 'BBD', 'Bridgetown', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (21, 'Belarus', 'BLR', 'BY', '375', 'BYR', 'Minsk', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (22, 'Belgium', 'BEL', 'BE', '32', 'EUR', 'Brussels', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (23, 'Belize', 'BLZ', 'BZ', '501', 'BZD', 'Belmopan', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (24, 'Benin', 'BEN', 'BJ', '229', 'XOF', 'Porto-Novo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (25, 'Bermuda', 'BMU', 'BM', '+1-441', 'BMD', 'Hamilton', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (26, 'Bhutan', 'BTN', 'BT', '975', 'BTN', 'Thimphu', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (27, 'Bolivia', 'BOL', 'BO', '591', 'BOB', 'Sucre', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (28, 'Bosnia and Herzegovina', 'BIH', 'BA', '387', 'BAM', 'Sarajevo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (29, 'Botswana', 'BWA', 'BW', '267', 'BWP', 'Gaborone', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (30, 'Bouvet Island', 'BVT', 'BV', '', 'NOK', '', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (31, 'Brazil', 'BRA', 'BR', '55', 'BRL', 'Brasilia', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (32, 'British Indian Ocean Territory', 'IOT', 'IO', '246', 'USD', 'Diego Garcia', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (33, 'Brunei', 'BRN', 'BN', '673', 'BND', 'Bandar Seri Begawan', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (34, 'Bulgaria', 'BGR', 'BG', '359', 'BGN', 'Sofia', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (35, 'Burkina Faso', 'BFA', 'BF', '226', 'XOF', 'Ouagadougou', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (36, 'Burundi', 'BDI', 'BI', '257', 'BIF', 'Bujumbura', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (37, 'Cambodia', 'KHM', 'KH', '855', 'KHR', 'Phnom Penh', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (38, 'Cameroon', 'CMR', 'CM', '237', 'XAF', 'Yaounde', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (39, 'Canada', 'CAN', 'CA', '1', 'CAD', 'Ottawa', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (40, 'Cape Verde', 'CPV', 'CV', '238', 'CVE', 'Praia', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (41, 'Cayman Islands', 'CYM', 'KY', '+1-345', 'KYD', 'George Town', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (42, 'Central African Republic', 'CAF', 'CF', '236', 'XAF', 'Bangui', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (43, 'Chad', 'TCD', 'TD', '235', 'XAF', 'NDjamena', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (44, 'Chile', 'CHL', 'CL', '56', 'CLP', 'Santiago', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (45, 'China', 'CHN', 'CN', '86', 'CNY', 'Beijing', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (46, 'Christmas Island', 'CXR', 'CX', '61', 'AUD', 'Flying Fish Cove', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (47, 'Cocos (Keeling) Islands', 'CCK', 'CC', '61', 'AUD', 'West Island', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (48, 'Colombia', 'COL', 'CO', '57', 'COP', 'Bogota', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (49, 'Comoros', 'COM', 'KM', '269', 'KMF', 'Moroni', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (50, 'Congo', 'COG', 'CG', '242', 'XAF', 'Brazzaville', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (51, 'Congo The Democratic Republic Of The', 'COD', 'CD', '243', 'CDF', 'Kinshasa', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (52, 'Cook Islands', 'COK', 'CK', '682', 'NZD', 'Avarua', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (53, 'Costa Rica', 'CRI', 'CR', '506', 'CRC', 'San Jose', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (54, 'Cote DIvoire (Ivory Coast)', 'CIV', 'CI', '225', 'XOF', 'Yamoussoukro', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (55, 'Croatia (Hrvatska)', 'HRV', 'HR', '385', 'HRK', 'Zagreb', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (56, 'Cuba', 'CUB', 'CU', '53', 'CUP', 'Havana', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (57, 'Cyprus', 'CYP', 'CY', '357', 'EUR', 'Nicosia', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (58, 'Czech Republic', 'CZE', 'CZ', '420', 'CZK', 'Prague', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (59, 'Denmark', 'DNK', 'DK', '45', 'DKK', 'Copenhagen', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (60, 'Djibouti', 'DJI', 'DJ', '253', 'DJF', 'Djibouti', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (61, 'Dominica', 'DMA', 'DM', '+1-767', 'XCD', 'Roseau', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (62, 'Dominican Republic', 'DOM', 'DO', '+1-809 and 1-829', 'DOP', 'Santo Domingo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (63, 'East Timor', 'TLS', 'TL', '670', 'USD', 'Dili', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (64, 'Ecuador', 'ECU', 'EC', '593', 'USD', 'Quito', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (65, 'Egypt', 'EGY', 'EG', '20', 'EGP', 'Cairo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (66, 'El Salvador', 'SLV', 'SV', '503', 'USD', 'San Salvador', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (67, 'Equatorial Guinea', 'GNQ', 'GQ', '240', 'XAF', 'Malabo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (68, 'Eritrea', 'ERI', 'ER', '291', 'ERN', 'Asmara', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (69, 'Estonia', 'EST', 'EE', '372', 'EUR', 'Tallinn', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (70, 'Ethiopia', 'ETH', 'ET', '251', 'ETB', 'Addis Ababa', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (71, 'Falkland Islands', 'FLK', 'FK', '500', 'FKP', 'Stanley', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (72, 'Faroe Islands', 'FRO', 'FO', '298', 'DKK', 'Torshavn', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (73, 'Fiji Islands', 'FJI', 'FJ', '679', 'FJD', 'Suva', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (74, 'Finland', 'FIN', 'FI', '358', 'EUR', 'Helsinki', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (75, 'France', 'FRA', 'FR', '33', 'EUR', 'Paris', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (76, 'French Guiana', 'GUF', 'GF', '594', 'EUR', 'Cayenne', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (77, 'French Polynesia', 'PYF', 'PF', '689', 'XPF', 'Papeete', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (78, 'French Southern Territories', 'ATF', 'TF', '', 'EUR', 'Port-aux-Francais', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (79, 'Gabon', 'GAB', 'GA', '241', 'XAF', 'Libreville', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (80, 'Gambia The', 'GMB', 'GM', '220', 'GMD', 'Banjul', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (81, 'Georgia', 'GEO', 'GE', '995', 'GEL', 'Tbilisi', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (82, 'Germany', 'DEU', 'DE', '49', 'EUR', 'Berlin', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (83, 'Ghana', 'GHA', 'GH', '233', 'GHS', 'Accra', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (84, 'Gibraltar', 'GIB', 'GI', '350', 'GIP', 'Gibraltar', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (85, 'Greece', 'GRC', 'GR', '30', 'EUR', 'Athens', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (86, 'Greenland', 'GRL', 'GL', '299', 'DKK', 'Nuuk', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (87, 'Grenada', 'GRD', 'GD', '+1-473', 'XCD', 'St. Georges', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (88, 'Guadeloupe', 'GLP', 'GP', '590', 'EUR', 'Basse-Terre', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (89, 'Guam', 'GUM', 'GU', '+1-671', 'USD', 'Hagatna', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (90, 'Guatemala', 'GTM', 'GT', '502', 'GTQ', 'Guatemala City', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (91, 'Guernsey and Alderney', 'GGY', 'GG', '+44-1481', 'GBP', 'St Peter Port', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (92, 'Guinea', 'GIN', 'GN', '224', 'GNF', 'Conakry', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (93, 'Guinea-Bissau', 'GNB', 'GW', '245', 'XOF', 'Bissau', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (94, 'Guyana', 'GUY', 'GY', '592', 'GYD', 'Georgetown', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (95, 'Haiti', 'HTI', 'HT', '509', 'HTG', 'Port-au-Prince', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (96, 'Heard and McDonald Islands', 'HMD', 'HM', ' ', 'AUD', '', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (97, 'Honduras', 'HND', 'HN', '504', 'HNL', 'Tegucigalpa', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (98, 'Hong Kong S.A.R.', 'HKG', 'HK', '852', 'HKD', 'Hong Kong', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (99, 'Hungary', 'HUN', 'HU', '36', 'HUF', 'Budapest', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (100, 'Iceland', 'ISL', 'IS', '354', 'ISK', 'Reykjavik', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (101, 'India', 'IND', 'IN', '91', 'INR', 'New Delhi', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (102, 'Indonesia', 'IDN', 'ID', '62', 'IDR', 'Jakarta', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (103, 'Iran', 'IRN', 'IR', '98', 'IRR', 'Tehran', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (104, 'Iraq', 'IRQ', 'IQ', '964', 'IQD', 'Baghdad', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (105, 'Ireland', 'IRL', 'IE', '353', 'EUR', 'Dublin', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (106, 'Israel', 'ISR', 'IL', '972', 'ILS', 'Jerusalem', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (107, 'Italy', 'ITA', 'IT', '39', 'EUR', 'Rome', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (108, 'Jamaica', 'JAM', 'JM', '+1-876', 'JMD', 'Kingston', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (109, 'Japan', 'JPN', 'JP', '81', 'JPY', 'Tokyo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (110, 'Jersey', 'JEY', 'JE', '+44-1534', 'GBP', 'Saint Helier', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (111, 'Jordan', 'JOR', 'JO', '962', 'JOD', 'Amman', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (112, 'Kazakhstan', 'KAZ', 'KZ', '7', 'KZT', 'Astana', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (113, 'Kenya', 'KEN', 'KE', '254', 'KES', 'Nairobi', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (114, 'Kiribati', 'KIR', 'KI', '686', 'AUD', 'Tarawa', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (115, 'Korea North\n', 'PRK', 'KP', '850', 'KPW', 'Pyongyang', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (116, 'Korea South', 'KOR', 'KR', '82', 'KRW', 'Seoul', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (117, 'Kuwait', 'KWT', 'KW', '965', 'KWD', 'Kuwait City', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (118, 'Kyrgyzstan', 'KGZ', 'KG', '996', 'KGS', 'Bishkek', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (119, 'Laos', 'LAO', 'LA', '856', 'LAK', 'Vientiane', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (120, 'Latvia', 'LVA', 'LV', '371', 'EUR', 'Riga', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (121, 'Lebanon', 'LBN', 'LB', '961', 'LBP', 'Beirut', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (122, 'Lesotho', 'LSO', 'LS', '266', 'LSL', 'Maseru', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (123, 'Liberia', 'LBR', 'LR', '231', 'LRD', 'Monrovia', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (124, 'Libya', 'LBY', 'LY', '218', 'LYD', 'Tripolis', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (125, 'Liechtenstein', 'LIE', 'LI', '423', 'CHF', 'Vaduz', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (126, 'Lithuania', 'LTU', 'LT', '370', 'LTL', 'Vilnius', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (127, 'Luxembourg', 'LUX', 'LU', '352', 'EUR', 'Luxembourg', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (128, 'Macau S.A.R.', 'MAC', 'MO', '853', 'MOP', 'Macao', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (129, 'Macedonia', 'MKD', 'MK', '389', 'MKD', 'Skopje', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (130, 'Madagascar', 'MDG', 'MG', '261', 'MGA', 'Antananarivo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (131, 'Malawi', 'MWI', 'MW', '265', 'MWK', 'Lilongwe', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (132, 'Malaysia', 'MYS', 'MY', '60', 'MYR', 'Kuala Lumpur', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (133, 'Maldives', 'MDV', 'MV', '960', 'MVR', 'Male', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (134, 'Mali', 'MLI', 'ML', '223', 'XOF', 'Bamako', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (135, 'Malta', 'MLT', 'MT', '356', 'EUR', 'Valletta', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (136, 'Man (Isle of)', 'IMN', 'IM', '+44-1624', 'GBP', 'Douglas, Isle of Man', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (137, 'Marshall Islands', 'MHL', 'MH', '692', 'USD', 'Majuro', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (138, 'Martinique', 'MTQ', 'MQ', '596', 'EUR', 'Fort-de-France', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (139, 'Mauritania', 'MRT', 'MR', '222', 'MRO', 'Nouakchott', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (140, 'Mauritius', 'MUS', 'MU', '230', 'MUR', 'Port Louis', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (141, 'Mayotte', 'MYT', 'YT', '262', 'EUR', 'Mamoudzou', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (142, 'Mexico', 'MEX', 'MX', '52', 'MXN', 'Mexico City', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (143, 'Micronesia', 'FSM', 'FM', '691', 'USD', 'Palikir', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (144, 'Moldova', 'MDA', 'MD', '373', 'MDL', 'Chisinau', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (145, 'Monaco', 'MCO', 'MC', '377', 'EUR', 'Monaco', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (146, 'Mongolia', 'MNG', 'MN', '976', 'MNT', 'Ulan Bator', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (147, 'Montenegro', 'MNE', 'ME', '382', 'EUR', 'Podgorica', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (148, 'Montserrat', 'MSR', 'MS', '+1-664', 'XCD', 'Plymouth', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (149, 'Morocco', 'MAR', 'MA', '212', 'MAD', 'Rabat', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (150, 'Mozambique', 'MOZ', 'MZ', '258', 'MZN', 'Maputo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (151, 'Myanmar', 'MMR', 'MM', '95', 'MMK', 'Nay Pyi Taw', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (152, 'Namibia', 'NAM', 'NA', '264', 'NAD', 'Windhoek', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (153, 'Nauru', 'NRU', 'NR', '674', 'AUD', 'Yaren', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (154, 'Nepal', 'NPL', 'NP', '977', 'NPR', 'Kathmandu', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (155, 'Netherlands Antilles', 'ANT', 'AN', '', '', '', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (156, 'Netherlands The', 'NLD', 'NL', '31', 'EUR', 'Amsterdam', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (157, 'New Caledonia', 'NCL', 'NC', '687', 'XPF', 'Noumea', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (158, 'New Zealand', 'NZL', 'NZ', '64', 'NZD', 'Wellington', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (159, 'Nicaragua', 'NIC', 'NI', '505', 'NIO', 'Managua', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (160, 'Niger', 'NER', 'NE', '227', 'XOF', 'Niamey', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (161, 'Nigeria', 'NGA', 'NG', '234', 'NGN', 'Abuja', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (162, 'Niue', 'NIU', 'NU', '683', 'NZD', 'Alofi', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (163, 'Norfolk Island', 'NFK', 'NF', '672', 'AUD', 'Kingston', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (164, 'Northern Mariana Islands', 'MNP', 'MP', '+1-670', 'USD', 'Saipan', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (165, 'Norway', 'NOR', 'NO', '47', 'NOK', 'Oslo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (166, 'Oman', 'OMN', 'OM', '968', 'OMR', 'Muscat', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (167, 'Pakistan', 'PAK', 'PK', '92', 'PKR', 'Islamabad', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (168, 'Palau', 'PLW', 'PW', '680', 'USD', 'Melekeok', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (169, 'Palestinian Territory Occupied', 'PSE', 'PS', '970', 'ILS', 'East Jerusalem', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (170, 'Panama', 'PAN', 'PA', '507', 'PAB', 'Panama City', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (171, 'Papua new Guinea', 'PNG', 'PG', '675', 'PGK', 'Port Moresby', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (172, 'Paraguay', 'PRY', 'PY', '595', 'PYG', 'Asuncion', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (173, 'Peru', 'PER', 'PE', '51', 'PEN', 'Lima', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (174, 'Philippines', 'PHL', 'PH', '63', 'PHP', 'Manila', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (175, 'Pitcairn Island', 'PCN', 'PN', '870', 'NZD', 'Adamstown', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (176, 'Poland', 'POL', 'PL', '48', 'PLN', 'Warsaw', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (177, 'Portugal', 'PRT', 'PT', '351', 'EUR', 'Lisbon', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (178, 'Puerto Rico', 'PRI', 'PR', '+1-787 and 1-939', 'USD', 'San Juan', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (179, 'Qatar', 'QAT', 'QA', '974', 'QAR', 'Doha', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (180, 'Reunion', 'REU', 'RE', '262', 'EUR', 'Saint-Denis', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (181, 'Romania', 'ROU', 'RO', '40', 'RON', 'Bucharest', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (182, 'Russia', 'RUS', 'RU', '7', 'RUB', 'Moscow', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (183, 'Rwanda', 'RWA', 'RW', '250', 'RWF', 'Kigali', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (184, 'Saint Helena', 'SHN', 'SH', '290', 'SHP', 'Jamestown', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (185, 'Saint Kitts And Nevis', 'KNA', 'KN', '+1-869', 'XCD', 'Basseterre', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (186, 'Saint Lucia', 'LCA', 'LC', '+1-758', 'XCD', 'Castries', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (187, 'Saint Pierre and Miquelon', 'SPM', 'PM', '508', 'EUR', 'Saint-Pierre', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (188, 'Saint Vincent And The Grenadines', 'VCT', 'VC', '+1-784', 'XCD', 'Kingstown', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (189, 'Saint-Barthelemy', 'BLM', 'BL', '590', 'EUR', 'Gustavia', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (190, 'Saint-Martin (French part)', 'MAF', 'MF', '590', 'EUR', 'Marigot', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (191, 'Samoa', 'WSM', 'WS', '685', 'WST', 'Apia', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (192, 'San Marino', 'SMR', 'SM', '378', 'EUR', 'San Marino', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (193, 'Sao Tome and Principe', 'STP', 'ST', '239', 'STD', 'Sao Tome', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (194, 'Saudi Arabia', 'SAU', 'SA', '966', 'SAR', 'Riyadh', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (195, 'Senegal', 'SEN', 'SN', '221', 'XOF', 'Dakar', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (196, 'Serbia', 'SRB', 'RS', '381', 'RSD', 'Belgrade', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (197, 'Seychelles', 'SYC', 'SC', '248', 'SCR', 'Victoria', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (198, 'Sierra Leone', 'SLE', 'SL', '232', 'SLL', 'Freetown', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (199, 'Singapore', 'SGP', 'SG', '65', 'SGD', 'Singapur', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (200, 'Slovakia', 'SVK', 'SK', '421', 'EUR', 'Bratislava', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (201, 'Slovenia', 'SVN', 'SI', '386', 'EUR', 'Ljubljana', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (202, 'Solomon Islands', 'SLB', 'SB', '677', 'SBD', 'Honiara', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (203, 'Somalia', 'SOM', 'SO', '252', 'SOS', 'Mogadishu', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (204, 'South Africa', 'ZAF', 'ZA', '27', 'ZAR', 'Pretoria', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (205, 'South Georgia', 'SGS', 'GS', '', 'GBP', 'Grytviken', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (206, 'South Sudan', 'SSD', 'SS', '211', 'SSP', 'Juba', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (207, 'Spain', 'ESP', 'ES', '34', 'EUR', 'Madrid', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (208, 'Sri Lanka', 'LKA', 'LK', '94', 'LKR', 'Colombo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (209, 'Sudan', 'SDN', 'SD', '249', 'SDG', 'Khartoum', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (210, 'Suriname', 'SUR', 'SR', '597', 'SRD', 'Paramaribo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (211, 'Svalbard And Jan Mayen Islands', 'SJM', 'SJ', '47', 'NOK', 'Longyearbyen', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (212, 'Swaziland', 'SWZ', 'SZ', '268', 'SZL', 'Mbabane', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (213, 'Sweden', 'SWE', 'SE', '46', 'SEK', 'Stockholm', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (214, 'Switzerland', 'CHE', 'CH', '41', 'CHF', 'Berne', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (215, 'Syria', 'SYR', 'SY', '963', 'SYP', 'Damascus', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (216, 'Taiwan', 'TWN', 'TW', '886', 'TWD', 'Taipei', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (217, 'Tajikistan', 'TJK', 'TJ', '992', 'TJS', 'Dushanbe', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (218, 'Tanzania', 'TZA', 'TZ', '255', 'TZS', 'Dodoma', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (219, 'Thailand', 'THA', 'TH', '66', 'THB', 'Bangkok', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (220, 'Togo', 'TGO', 'TG', '228', 'XOF', 'Lome', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (221, 'Tokelau', 'TKL', 'TK', '690', 'NZD', '', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (222, 'Tonga', 'TON', 'TO', '676', 'TOP', 'Nukualofa', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (223, 'Trinidad And Tobago', 'TTO', 'TT', '+1-868', 'TTD', 'Port of Spain', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (224, 'Tunisia', 'TUN', 'TN', '216', 'TND', 'Tunis', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (225, 'Turkey', 'TUR', 'TR', '90', 'TRY', 'Ankara', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (226, 'Turkmenistan', 'TKM', 'TM', '993', 'TMT', 'Ashgabat', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (227, 'Turks And Caicos Islands', 'TCA', 'TC', '+1-649', 'USD', 'Cockburn Town', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (228, 'Tuvalu', 'TUV', 'TV', '688', 'AUD', 'Funafuti', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (229, 'Uganda', 'UGA', 'UG', '256', 'UGX', 'Kampala', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (230, 'Ukraine', 'UKR', 'UA', '380', 'UAH', 'Kiev', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (231, 'United Arab Emirates', 'ARE', 'AE', '971', 'AED', 'Abu Dhabi', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (232, 'United Kingdom', 'GBR', 'GB', '44', 'GBP', 'London', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (233, 'United States', 'USA', 'US', '1', 'USD', 'Washington', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (234, 'United States Minor Outlying Islands', 'UMI', 'UM', '1', 'USD', '', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (235, 'Uruguay', 'URY', 'UY', '598', 'UYU', 'Montevideo', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (236, 'Uzbekistan', 'UZB', 'UZ', '998', 'UZS', 'Tashkent', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (237, 'Vanuatu', 'VUT', 'VU', '678', 'VUV', 'Port Vila', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (238, 'Vatican City State (Holy See)', 'VAT', 'VA', '379', 'EUR', 'Vatican City', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (239, 'Venezuela', 'VEN', 'VE', '58', 'VEF', 'Caracas', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (240, 'Vietnam', 'VNM', 'VN', '84', 'VND', 'Hanoi', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (241, 'Virgin Islands (British)', 'VGB', 'VG', '+1-284', 'USD', 'Road Town', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (242, 'Virgin Islands (US)', 'VIR', 'VI', '+1-340', 'USD', 'Charlotte Amalie', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (243, 'Wallis And Futuna Islands', 'WLF', 'WF', '681', 'XPF', 'Mata Utu', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (244, 'Western Sahara', 'ESH', 'EH', '212', 'MAD', 'El-Aaiun', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (245, 'Yemen', 'YEM', 'YE', '967', 'YER', 'Sanaa', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (246, 'Zambia', 'ZMB', 'ZM', '260', 'ZMK', 'Lusaka', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1), (247, 'Zimbabwe', 'ZWE', 'ZW', '263', 'ZWL', 'Harare', 1, '2018-07-20 08:41:03', '2018-07-20 08:41:03', 1); -- -------------------------------------------------------- -- -- Table structure for table `coupons` -- CREATE TABLE `coupons` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(11) DEFAULT 1, `title` varchar(191) DEFAULT NULL, `code` varchar(191) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `value` float DEFAULT 0, `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Fixed Amount, 0=Percentage', `min_purchase` float DEFAULT 0, `max_discount` float DEFAULT 0, `start_date` date NOT NULL, `end_date` date NOT NULL, `category` int(11) NOT NULL DEFAULT 1 COMMENT '1=Common, 2=Single, 3=Personalized', `category_id` int(10) UNSIGNED DEFAULT NULL, `subcategory_id` int(10) UNSIGNED DEFAULT NULL, `course_id` int(10) UNSIGNED DEFAULT NULL, `coupon_user_id` int(10) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lms_id` int(11) NOT NULL DEFAULT 1, `limit` int(11) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `courses` -- CREATE TABLE `courses` ( `id` int(10) UNSIGNED NOT NULL, `category_id` int(10) UNSIGNED DEFAULT NULL, `subcategory_id` int(11) DEFAULT NULL, `quiz_id` int(11) DEFAULT NULL, `class_id` int(11) DEFAULT NULL, `user_id` int(10) UNSIGNED NOT NULL, `lang_id` int(10) UNSIGNED NOT NULL, `title` longtext DEFAULT NULL, `slug` varchar(191) DEFAULT NULL, `duration` varchar(191) DEFAULT NULL, `image` varchar(191) DEFAULT NULL, `thumbnail` varchar(191) DEFAULT NULL, `price` decimal(20,2) DEFAULT 0.00, `discount_price` decimal(20,2) DEFAULT 0.00, `publish` tinyint(1) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `level` int(10) UNSIGNED DEFAULT 4, `trailer_link` varchar(191) DEFAULT NULL, `host` varchar(191) DEFAULT NULL, `meta_keywords` varchar(191) DEFAULT NULL, `meta_description` varchar(191) DEFAULT NULL, `about` longtext DEFAULT NULL, `special_commission` double DEFAULT NULL, `total_enrolled` int(11) NOT NULL DEFAULT 0, `reveune` float DEFAULT 0, `reveiw` double NOT NULL DEFAULT 0, `type` int(11) NOT NULL DEFAULT 1 COMMENT '1=Course, 2=Quiz', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `drip` tinyint(1) NOT NULL DEFAULT 0, `subscription` varchar(191) NOT NULL DEFAULT '0' COMMENT '0= no subscription; 1=subscription', `requirements` longtext DEFAULT NULL, `outcomes` longtext DEFAULT NULL, `subscription_list` varchar(191) DEFAULT NULL, `total_rating` int(11) NOT NULL DEFAULT 0, `scope` tinyint(4) NOT NULL DEFAULT 1, `complete_order` tinyint(4) NOT NULL DEFAULT 0, `certificate_id` int(11) DEFAULT NULL, `show_overview_media` int(11) DEFAULT 0, `show_mode_of_delivery` int(11) DEFAULT 1, `mode_of_delivery` int(11) DEFAULT 1 COMMENT '1=Online, 2= Distance Learning, 3= Face to Face', `what_learn1` text DEFAULT NULL, `what_learn2` text DEFAULT NULL, `view` int(11) NOT NULL DEFAULT 0, `feature` tinyint(1) NOT NULL DEFAULT 0, `lms_id` int(11) NOT NULL DEFAULT 1, `assistant_instructors` text DEFAULT NULL, `required_type` tinyint(4) NOT NULL DEFAULT 0, `iap_product_id` text DEFAULT NULL, `school_subject_id` int(11) NOT NULL DEFAULT 0, `access_limit` int(11) NOT NULL DEFAULT 0, `total_chapters` int(11) DEFAULT 0, `total_lessons` int(11) DEFAULT 0, `total_quiz_lessons` int(11) DEFAULT 0, `total_comments` int(11) DEFAULT 0, `total_reviews` int(11) DEFAULT 0, `has_badge` tinyint(1) NOT NULL DEFAULT 0, `course_badge` text DEFAULT NULL, `price_text` varchar(191) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `courses` -- INSERT INTO `courses` (`id`, `category_id`, `subcategory_id`, `quiz_id`, `class_id`, `user_id`, `lang_id`, `title`, `slug`, `duration`, `image`, `thumbnail`, `price`, `discount_price`, `publish`, `status`, `level`, `trailer_link`, `host`, `meta_keywords`, `meta_description`, `about`, `special_commission`, `total_enrolled`, `reveune`, `reveiw`, `type`, `created_at`, `updated_at`, `drip`, `subscription`, `requirements`, `outcomes`, `subscription_list`, `total_rating`, `scope`, `complete_order`, `certificate_id`, `show_overview_media`, `show_mode_of_delivery`, `mode_of_delivery`, `what_learn1`, `what_learn2`, `view`, `feature`, `lms_id`, `assistant_instructors`, `required_type`, `iap_product_id`, `school_subject_id`, `access_limit`, `total_chapters`, `total_lessons`, `total_quiz_lessons`, `total_comments`, `total_reviews`, `has_badge`, `course_badge`, `price_text`) VALUES (1, 1, NULL, NULL, NULL, 7, 9, '{\"en\":\"SMM MATERY COURSE\",\"bn\":\"SMM MATERY COURSE\"}', 'smm-matery-course', '90', 'https://samratitinstitute.com/public/uploads/main/files/17-04-2026/chatgpt-image-apr-17-2026-02-44-07-am-20260417142944-8a622b.png', 'https://samratitinstitute.com/public/uploads/main/files/17-04-2026/chatgpt-image-apr-17-2026-02-44-07-am-20260417142944-8a622b.png', 2000.00, 999.00, 1, 1, 1, 'https://www.youtube.com/watch?v=XF2XtD7nvCA', 'Youtube', NULL, NULL, '{\"en\":\"
🔥 One course, 3 Business skills! 🔥<\\/span><\\/pre>
\\r\\nLearn skills that will help you start earning money for just <\\/span><\\/pre>
999 taka 💸<\\/span><\\/pre>
\\r\\n🎯 In this course you will learn:<\\/span><\\/pre>
\\r\\n✅ SMM Business – Social Media Service Sale, Ads & Client Management<\\/span><\\/pre>
\\r\\n✅ E-commerce Business – Full Guide from Product Selection to Sale<\\/span><\\/pre>
\\r\\n✅ Domain & Hosting Business – Website Setup + Client Service<\\/span><\\/pre>
\\r\\n🚀 Why is this course perfect for you?<\\/span><\\/pre>
\\r\\n✔ Absolutely Beginner Friendly<\\/span><\\/pre>
\\r\\n✔ Real Practical Knowledge<\\/span><\\/pre>

<\\/span><\\/pre>
✔ Income opportunity from home<\\/span><\\/pre>
\\r\\n✔ Student + Job + Freelancer for everyone<\\/span><\\/pre>
\\r\\n✔ Lifetime support & updates<\\/span><\\/pre>
\\r\\n💰 Course fee: Only 999 taka (Limited Offer)<\\/span><\\/pre>
\\r\\n📱 You can learn from your mobile or laptop<\\/span><\\/pre>
\\r\\n👉 Enroll now, if you delay you will miss the opportunity!<\\/span><\\/pre>
\\r\\n✨ Start learning today, your business journey starts tomorrow! ✨<\\/span><\\/pre><\\/span><\\/pre>\",\"bn\":\"
🔥 একটা কোর্স, ৩টা বিজনেস স্কিল! 🔥<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
মাত্র ৯৯৯ টাকায় শিখে নিন এমন স্কিল, যেগুলো দিয়ে আপনি নিজেই ইনকাম শুরু করতে পারবেন 💸<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
🎯 এই কোর্সে আপনি শিখবেন:<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
✅ SMM Business – Social Media Service Sale, Ads & Client Management<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
✅ E-commerce Business – Product Selection থেকে Sale পর্যন্ত ফুল গাইড<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
✅ Domain & Hosting Business – Website Setup + Client Service<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
🚀 কেন এই কোর্স আপনার জন্য পারফেক্ট?<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
✔ একদম Beginner Friendly<\\/b><\\/span><\\/font><\\/div>
✔ Real Practical Knowledge<\\/b><\\/span><\\/font><\\/div>
✔ ঘরে বসে ইনকামের সুযোগ<\\/b><\\/span><\\/font><\\/div>
✔ স্টুডেন্ট + জব + ফ্রিল্যান্সার সবার জন্য<\\/b><\\/span><\\/font><\\/div>
✔ লাইফটাইম সাপোর্ট & আপডেট<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
💰 কোর্স ফি: মাত্র ৯৯৯ টাকা (Limited Offer)<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
📱 মোবাইল বা ল্যাপটপ থেকেই শিখতে পারবেন<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
👉 এখনই ভর্তি হন, দেরি করলে সুযোগ মিস করবেন!<\\/b><\\/span><\\/font><\\/div>

<\\/b><\\/span><\\/font><\\/div>
✨ আজ শেখা শুরু করুন, কাল থেকেই আপনার বিজনেস জার্নি! ✨<\\/b><\\/span><\\/font><\\/div>\"}', NULL, 40, 21618.4, 0, 1, '2026-04-10 07:16:30', '2026-10-10 07:22:32', 0, '0', '{\"bn\":\"
🔰 প্রশ্ন: এই কাজ শিখতে কি কি যোগ্যতা লাগবে?<\\/b><\\/p>
✅ উত্তর : আপনার একটা মোবাইল থাকলে ই কাজ করতে পারবেন এবং আমরা আপনাকে সব কাজ শিখিয়ে দিব ।<\\/b><\\/p>

<\\/b><\\/p>
🔰 প্রশ্ন: এই কাজ করতে দিনে কত ঘন্টা সময় দিতে হবে?<\\/b><\\/p>
✅ উত্তর : আপনার থেকে সার্ভিস নেয়ার জন্য কাস্টমার মেসেজ করবে।  আপনার হাতে যদি কাস্টমার এর মেসেজ এর Reply দেয়ার মত সময় থাকে তাহলে কাজটি করতে পারবেন।<\\/b><\\/p>

<\\/b><\\/p>
🔰 প্রশ্ন: ইনকাম হবে কত দিন পর থেকে?<\\/b><\\/p>
✅ উত্তর : আপনি Website নেয়ার ২য় দিন থেকে আপনার ইনকাম শুরু হবে।<\\/b><\\/p>

<\\/b><\\/p>
🔰 প্রশ্ন: মোবাইল দিয়ে কি  কাজ করা যাবে?<\\/b><\\/p>
✅ উত্তর: হ্যা আপনার একটি মোবাইল থাকলে ই কাজ করতে পারবেন এবং প্রতি মাসে ভাল একটা ইনকাম জেনারেট হবে।<\\/b><\\/p>

<\\/b><\\/p>
🔰 প্রশ্ন: এই সার্ভিস নিবে কে বা  কাস্টমার কারা?<\\/b><\\/p>
✅ উত্তর: যারা অনলাইন ভিত্তিক Business করে বা করতে চায়  এবং সকল ফ্রিল্যান্সারা আপনার থেকে সার্ভিস নিবে। বর্তামানে বাংলাদেশের সকল ব্যাবসা অনলাইন ভিত্তিক হচ্ছে এবং অনেক মানুষ ফ্রিল্যান্সিং করে এবং ফ্রিল্যান্সিং শিখছে। <\\/b><\\/p>

<\\/b><\\/p>
♻ সুতরাং সকল অনালাইন ব্যাবসায়ী এবং সকল ফ্রিল্যান্সার আপনার থেকে সার্ভিস টি নিবে।<\\/b><\\/p>

<\\/b><\\/p>

<\\/b><\\/p>
 🔰 প্রশ্ন: এত প্রতিষ্ঠান থাকতে আমাদের থেকে কেনো কোর্স করবেন?<\\/b><\\/p>
✅ উত্তর 👇<\\/b><\\/p>
১। বাংলাদেশে আমরা ই ১ম Social Media Marketing Business (SMM PANEL) কোর্স করাচ্ছি।<\\/b><\\/p>
২। ১০ বছরের অভিজ্ঞতা সম্পুর্ন মেন্টর আপনাদের ক্লাস নিবে এবং আপনাকে ভাল ভাবে সব কাজ বুঝিয়ে দিবে, যতক্ষন আপনি না বুজবেন ততক্ষণ পর্যন্ত আপনাকে বিভিন্ন টেকনিক এর সাহায্যে বোঝাবে।<\\/b><\\/p>
৩। আমাদের থেকে কোর্স করলে আপনি ২য় দিন থেকে ইনকাম করবেন ১০০% গ্যারান্টি।  <\\/b><\\/p>
৪। আপনার হাতে থাকা মোবাইল দিয়ে ই সব কাজ করতে পারবেন।<\\/b><\\/p>
৫। ২৪ ঘন্টা লাইভ সাপোর্ট। যেকোনো সমস্যা হলে আমাদের কল দেয়ার সাথে সাথে সমাধান করে দিব।<\\/b><\\/p>
৬। এই  কাজ শেখার পর একটা সময় আপনার ইনকাম হবে   Automatic,  আপনি যদি ১ সপ্তাহ Online না আসেন এর পর ও আপনার ইনকাম হতে ই থাকবে। <\\/b><\\/p>
৭।  আমাদের সকল Students নিয়ে একটা গ্রুপ আছে। সে খানে যারা বেশি ইনকাম করে বা ভাল কাজ করে তাদের থেকে ও সাহায্য নিতে পারবেন। <\\/b><\\/p>
৮। আমাদের রয়েছে ফেজবুক এর বাংলাদেশি নিজেস্য সার্ভার। তাই সকল সার্ভিস ফাস্ট প্রভাইড করে আপনার কাস্টোমার কে সহজেই খুশি করতে পারবেন।<\\/b><\\/p>

<\\/b><\\/p>
 🗣😍  আমরা মাত্র ১০০ জন নিব এই কোর্সে। ১০০ জন ফিলাপ হয়ে গেলে  কোর্স ফি ২০ হাজার টাকা করা হবে।<\\/b><\\/p>

<\\/b><\\/p>
আমাদের কোর্সে ভর্তি হয়ে  ২য় দিন থেকে ইনকাম এর প্রমান । ভিডিও টা দেখলে আমাদের সম্পর্কে বিস্তারিত অনেক কিছু জানতে পারবেন। <\\/b><\\/p>

<\\/b><\\/p>
Video Link: https:\\/\\/www.facebook.com\\/Freelancersamrat0\\/videos\\/1035589321810176<\\/a><\\/b><\\/p>

<\\/b><\\/p>
Youtube video link: https:\\/\\/www.youtube.com\\/watch?v=ef13Q7RCjzo <\\/a><\\/b><\\/p>\",\"en\":\"
🔰 Question: What qualifications are required to learn this job?<\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: You can work if you have a mobile phone and we will teach you all the tasks.\\r\\n\\r\\n🔰 Question: How many hours a day do you have to spend to do this job?<\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: Customers will message you to get service from you. If you have time to reply to the customer\'s message, then you can do the job.\\r\\n\\r\\n🔰 Question: After how many days will you start earning?<\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: Your income will start from the 2nd day of getting the website.<\\/span><\\/font>
<\\/span><\\/font><\\/pre>

<\\/span><\\/font><\\/pre>
🔰 Question: Can you work with a mobile?<\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: Yes, if you have a mobile, you can work and generate a good income every month.\\r\\n\\r\\n🔰 Question: Who or who are the customers who will take this service?<\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: Those who do or want to do online-based business and all freelancers will take service from you. Currently, all businesses in Bangladesh are becoming online-based and many people are doing freelancing and learning freelancing. \\r\\n\\r\\n♻ So all online businessmen and all freelancers will take service from you.<\\/span><\\/font><\\/pre>

<\\/span><\\/font><\\/pre>
🔰 Question: Why take a course from us when there are so many institutions?<\\/span><\\/pre>
\\r\\n✅ Answer 👇\\r\\n1. We are conducting the 1st Social Media Marketing Business (SMM PANEL) course in Bangladesh.<\\/span><\\/pre>
\\r\\n2. A mentor with 10 years of experience will take your class and explain everything to you well, using various techniques until you understand.<\\/span><\\/pre>
\\r\\n3. If you take a course from us, you will earn 100% guarantee from the 2nd day.<\\/span><\\/pre>
\\r\\n4. You can do all this work with the mobile phone in your hand.<\\/span><\\/pre>

<\\/span><\\/pre>
 <\\/span>5. 24 hour live support. If there is any problem, we will solve it as soon as you call us.<\\/pre>

<\\/p>
6. After learning this job, your income will be automatic for a while, if you do not come online for 1 week, your income will continue to be there. <\\/span><\\/pre>
\\r\\n7. We have a group with all our students. You can also get help from those who earn more or do good work there. <\\/span><\\/pre>
\\r\\n8. We have our own Bangladeshi Facebook server. So you can easily make your customers happy by providing all the services fast.<\\/span><\\/pre>

<\\/span><\\/pre>
🗣😍 We will only take 100 people in this course. If 100 people fill up, the course fee will be 20 thousand taka.\\r\\n\\r\\nProof of income from the 2nd day of enrolling in our course. You can learn a lot about us in detail by watching the video.<\\/span><\\/pre>

<\\/span><\\/pre>
Video Link: https:\\/\\/www.facebook.com\\/Freelancersamrat0\\/videos\\/1035589321810176<\\/span><\\/font><\\/pre>
\\r\\nYoutube video link: https:\\/\\/www.youtube.com\\/watch?v=ef13Q7RCjzo <\\/span><\\/font><\\/pre><\\/pre><\\/pre><\\/pre>\"}', '{\"en\":\"

<\\/p>\",\"bn\":\"

<\\/p>\"}', NULL, 0, 1, 0, 2, 1, 1, 1, NULL, NULL, 2145, 0, 1, '[\"9\",\"13\"]', 0, NULL, 0, 0, 1, 14, 0, 0, 0, 0, NULL, NULL);
INSERT INTO `courses` (`id`, `category_id`, `subcategory_id`, `quiz_id`, `class_id`, `user_id`, `lang_id`, `title`, `slug`, `duration`, `image`, `thumbnail`, `price`, `discount_price`, `publish`, `status`, `level`, `trailer_link`, `host`, `meta_keywords`, `meta_description`, `about`, `special_commission`, `total_enrolled`, `reveune`, `reveiw`, `type`, `created_at`, `updated_at`, `drip`, `subscription`, `requirements`, `outcomes`, `subscription_list`, `total_rating`, `scope`, `complete_order`, `certificate_id`, `show_overview_media`, `show_mode_of_delivery`, `mode_of_delivery`, `what_learn1`, `what_learn2`, `view`, `feature`, `lms_id`, `assistant_instructors`, `required_type`, `iap_product_id`, `school_subject_id`, `access_limit`, `total_chapters`, `total_lessons`, `total_quiz_lessons`, `total_comments`, `total_reviews`, `has_badge`, `course_badge`, `price_text`) VALUES
(3, 1, NULL, NULL, NULL, 7, 9, '{\"en\":\"SMM PANNEL ADMIN MANAGE COURSE\",\"bn\":\"SMM PANNEL ADMIN MANAGE COURSE\"}', 'smm-pannel-admin-manage-course', NULL, 'https://samratitinstitute.com/public/uploads/main/files/09-05-2026/chatgpt-image-may-9-2026-04-07-20-am-20260509040804-41fafe.png', 'https://samratitinstitute.com/public/uploads/main/files/09-05-2026/chatgpt-image-may-9-2026-04-07-20-am-20260509040804-41fafe.png', 5000.00, NULL, 1, 1, 4, NULL, NULL, NULL, NULL, '{\"en\":\"
<\\/p><\\/p>
🔥 One course, 3 Business skills! 🔥<\\/b><\\/span><\\/pre>
\\r\\nLearn skills that will help you start earning money for just <\\/b><\\/span><\\/pre>
999 taka 💸<\\/b><\\/span><\\/pre>
\\r\\n🎯 In this course you will learn:<\\/b><\\/span><\\/pre>
\\r\\n✅ SMM Business – Social Media Service Sale, Ads & Client Management<\\/b><\\/span><\\/pre>
\\r\\n✅ E-commerce Business – Full Guide from Product Selection to Sale<\\/b><\\/span><\\/pre>
\\r\\n✅ Domain & Hosting Business – Website Setup + Client Service<\\/b><\\/span><\\/pre>
\\r\\n🚀 Why is this course perfect for you?<\\/b><\\/span><\\/pre>
\\r\\n✔ Absolutely Beginner Friendly<\\/b><\\/span><\\/pre>
\\r\\n✔ Real Practical Knowledge<\\/b><\\/span><\\/pre>

<\\/b><\\/span><\\/pre>
✔ Income opportunity from home<\\/span><\\/pre>
\\r\\n✔ Student + Job + Freelancer for everyone<\\/span><\\/pre>
\\r\\n✔ Lifetime support & updates<\\/span><\\/pre>
\\r\\n💰 Course fee: Only 999 taka (Limited Offer)<\\/span><\\/pre>
\\r\\n📱 You can learn from your mobile or laptop<\\/span><\\/pre>
\\r\\n👉 Enroll now, if you delay you will miss the opportunity!<\\/span><\\/pre>
\\r\\n✨ Start learning today, your business journey starts tomorrow! ✨<\\/span><\\/pre><\\/b><\\/span><\\/pre><\\/div><\\/div><\\/div>\",\"bn\":\"
🔥 একটা কোর্স, ৩টা বিজনেস স্কিল! 🔥<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
মাত্র ৯৯৯ টাকায় শিখে নিন এমন স্কিল, যেগুলো দিয়ে আপনি নিজেই ইনকাম শুরু করতে পারবেন 💸<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
🎯 এই কোর্সে আপনি শিখবেন:<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
✅ SMM Business – Social Media Service Sale, Ads & Client Management<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
✅ E-commerce Business – Product Selection থেকে Sale পর্যন্ত ফুল গাইড<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
✅ Domain & Hosting Business – Website Setup + Client Service<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
🚀 কেন এই কোর্স আপনার জন্য পারফেক্ট?<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
✔ একদম Beginner Friendly<\\/span><\\/span><\\/font><\\/div>
✔ Real Practical Knowledge<\\/span><\\/span><\\/font><\\/div>
✔ ঘরে বসে ইনকামের সুযোগ<\\/span><\\/span><\\/font><\\/div>
✔ স্টুডেন্ট + জব + ফ্রিল্যান্সার সবার জন্য<\\/span><\\/span><\\/font><\\/div>
✔ লাইফটাইম সাপোর্ট & আপডেট<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
💰 কোর্স ফি: মাত্র ৯৯৯ টাকা (Limited Offer)<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
📱 মোবাইল বা ল্যাপটপ থেকেই শিখতে পারবেন<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
👉 এখনই ভর্তি হন, দেরি করলে সুযোগ মিস করবেন!<\\/span><\\/span><\\/font><\\/div>

<\\/span><\\/span><\\/font><\\/div>
✨ আজ শেখা শুরু করুন, কাল থেকেই আপনার বিজনেস জার্নি! ✨<\\/span><\\/span><\\/font><\\/div>\"}', NULL, 41, 12022.2, 0, 1, '2026-05-08 21:50:08', '2026-10-13 04:50:28', 0, '0', '{\"en\":\"
🔰 Question: What qualifications are required to learn this job?<\\/b><\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: You can work if you have a mobile phone and we will teach you all the tasks.\\r\\n\\r\\n🔰 Question: How many hours a day do you have to spend to do this job?<\\/b><\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: Customers will message you to get service from you. If you have time to reply to the customer\'s message, then you can do the job.\\r\\n\\r\\n🔰 Question: After how many days will you start earning?<\\/b><\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: Your income will start from the 2nd day of getting the website.<\\/span><\\/font>
<\\/span><\\/font><\\/b><\\/pre>

<\\/b><\\/span><\\/font><\\/pre>
🔰 Question: Can you work with a mobile?<\\/b><\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: Yes, if you have a mobile, you can work and generate a good income every month.\\r\\n\\r\\n🔰 Question: Who or who are the customers who will take this service?<\\/b><\\/span><\\/font><\\/pre>
\\r\\n✅ Answer: Those who do or want to do online-based business and all freelancers will take service from you. Currently, all businesses in Bangladesh are becoming online-based and many people are doing freelancing and learning freelancing. \\r\\n\\r\\n♻ So all online businessmen and all freelancers will take service from you.<\\/b><\\/span><\\/font><\\/pre>

<\\/b><\\/span><\\/font><\\/pre>
🔰 Question: Why take a course from us when there are so many institutions?<\\/b><\\/span><\\/pre>
\\r\\n✅ Answer 👇\\r\\n1. We are conducting the 1st Social Media Marketing Business (SMM PANEL) course in Bangladesh.<\\/b><\\/span><\\/pre>
\\r\\n2. A mentor with 10 years of experience will take your class and explain everything to you well, using various techniques until you understand.<\\/b><\\/span><\\/pre>
\\r\\n3. If you take a course from us, you will earn 100% guarantee from the 2nd day.<\\/b><\\/span><\\/pre>
\\r\\n4. You can do all this work with the mobile phone in your hand.<\\/b><\\/span><\\/pre>

<\\/b><\\/span><\\/pre>
 <\\/span>5. 24 hour live support. If there is any problem, we will solve it as soon as you call us.<\\/b><\\/pre>

<\\/b><\\/p>
6. After learning this job, your income will be automatic for a while, if you do not come online for 1 week, your income will continue to be there. <\\/b><\\/span><\\/pre>
\\r\\n7. We have a group with all our students. You can also get help from those who earn more or do good work there. <\\/b><\\/span><\\/pre>
\\r\\n8. We have our own Bangladeshi Facebook server. So you can easily make your customers happy by providing all the services fast.<\\/b><\\/span><\\/pre>

<\\/b><\\/span><\\/pre>
🗣😍 We will only take 100 people in this course. If 100 people fill up, the course fee will be 20 thousand taka.\\r\\n\\r\\nProof of income from the 2nd day of enrolling in our course. You can learn a lot about us in detail by watching the video.<\\/b><\\/span><\\/pre>

<\\/b><\\/span><\\/pre>
Video Link: https:\\/\\/www.facebook.com\\/Freelancersamrat0\\/videos\\/1035589321810176<\\/a><\\/b><\\/span><\\/font><\\/pre>
\\r\\nYoutube video link: https:\\/\\/www.youtube.com\\/watch?v=ef13Q7RCjzo<\\/a> <\\/b><\\/span><\\/font><\\/pre><\\/pre><\\/pre><\\/pre><\\/h4>\",\"bn\":\"
🔰 প্রশ্ন: এই কাজ শিখতে কি কি যোগ্যতা লাগবে?<\\/b><\\/p>
✅ উত্তর : আপনার একটা মোবাইল থাকলে ই কাজ করতে পারবেন এবং আমরা আপনাকে সব কাজ শিখিয়ে দিব ।<\\/b><\\/p>

<\\/b><\\/p>
🔰 প্রশ্ন: এই কাজ করতে দিনে কত ঘন্টা সময় দিতে হবে?<\\/b><\\/p>
✅ উত্তর : আপনার থেকে সার্ভিস নেয়ার জন্য কাস্টমার মেসেজ করবে।  আপনার হাতে যদি কাস্টমার এর মেসেজ এর Reply দেয়ার মত সময় থাকে তাহলে কাজটি করতে পারবেন।<\\/b><\\/p>

<\\/b><\\/p>
🔰 প্রশ্ন: ইনকাম হবে কত দিন পর থেকে?<\\/b><\\/p>
✅ উত্তর : আপনি Website নেয়ার ২য় দিন থেকে আপনার ইনকাম শুরু হবে।<\\/b><\\/p>

<\\/b><\\/p>
🔰 প্রশ্ন: মোবাইল দিয়ে কি  কাজ করা যাবে?<\\/b><\\/p>
✅ উত্তর: হ্যা আপনার একটি মোবাইল থাকলে ই কাজ করতে পারবেন এবং প্রতি মাসে ভাল একটা ইনকাম জেনারেট হবে।<\\/b><\\/p>

<\\/b><\\/p>
🔰 প্রশ্ন: এই সার্ভিস নিবে কে বা  কাস্টমার কারা?<\\/b><\\/p>
✅ উত্তর: যারা অনলাইন ভিত্তিক Business করে বা করতে চায়  এবং সকল ফ্রিল্যান্সারা আপনার থেকে সার্ভিস নিবে। বর্তামানে বাংলাদেশের সকল ব্যাবসা অনলাইন ভিত্তিক হচ্ছে এবং অনেক মানুষ ফ্রিল্যান্সিং করে এবং ফ্রিল্যান্সিং শিখছে। <\\/b><\\/p>

<\\/b><\\/p>
♻ সুতরাং সকল অনালাইন ব্যাবসায়ী এবং সকল ফ্রিল্যান্সার আপনার থেকে সার্ভিস টি নিবে।<\\/b><\\/p>

<\\/b><\\/p>

<\\/b><\\/p>
 🔰 প্রশ্ন: এত প্রতিষ্ঠান থাকতে আমাদের থেকে কেনো কোর্স করবেন?<\\/b><\\/p>
✅ উত্তর 👇<\\/b><\\/p>
১। বাংলাদেশে আমরা ই ১ম Social Media Marketing Business (SMM PANEL) কোর্স করাচ্ছি।<\\/b><\\/p>
২। ১০ বছরের অভিজ্ঞতা সম্পুর্ন মেন্টর আপনাদের ক্লাস নিবে এবং আপনাকে ভাল ভাবে সব কাজ বুঝিয়ে দিবে, যতক্ষন আপনি না বুজবেন ততক্ষণ পর্যন্ত আপনাকে বিভিন্ন টেকনিক এর সাহায্যে বোঝাবে।<\\/b><\\/p>
৩। আমাদের থেকে কোর্স করলে আপনি ২য় দিন থেকে ইনকাম করবেন ১০০% গ্যারান্টি।  <\\/b><\\/p>
৪। আপনার হাতে থাকা মোবাইল দিয়ে ই সব কাজ করতে পারবেন।<\\/b><\\/p>
৫। ২৪ ঘন্টা লাইভ সাপোর্ট। যেকোনো সমস্যা হলে আমাদের কল দেয়ার সাথে সাথে সমাধান করে দিব।<\\/b><\\/p>
৬। এই  কাজ শেখার পর একটা সময় আপনার ইনকাম হবে   Automatic,  আপনি যদি ১ সপ্তাহ Online না আসেন এর পর ও আপনার ইনকাম হতে ই থাকবে। <\\/b><\\/p>
৭।  আমাদের সকল Students নিয়ে একটা গ্রুপ আছে। সে খানে যারা বেশি ইনকাম করে বা ভাল কাজ করে তাদের থেকে ও সাহায্য নিতে পারবেন। <\\/b><\\/p>
৮। আমাদের রয়েছে ফেজবুক এর বাংলাদেশি নিজেস্য সার্ভার। তাই সকল সার্ভিস ফাস্ট প্রভাইড করে আপনার কাস্টোমার কে সহজেই খুশি করতে পারবেন।<\\/b><\\/p>

<\\/b><\\/p>
 🗣😍  আমরা মাত্র ১০০ জন নিব এই কোর্সে। ১০০ জন ফিলাপ হয়ে গেলে  কোর্স ফি ২০ হাজার টাকা করা হবে।<\\/b><\\/p>

<\\/b><\\/p>
আমাদের কোর্সে ভর্তি হয়ে  ২য় দিন থেকে ইনকাম এর প্রমান । ভিডিও টা দেখলে আমাদের সম্পর্কে বিস্তারিত অনেক কিছু জানতে পারবেন। <\\/b><\\/p>

<\\/b><\\/p>
Video Link: https:\\/\\/www.facebook.com\\/Freelancersamrat0\\/videos\\/1035589321810176<\\/a><\\/b><\\/p>

<\\/b><\\/p>
Youtube video link: https:\\/\\/www.youtube.com\\/watch?v=ef13Q7RCjzo <\\/a><\\/b><\\/p><\\/pre><\\/pre><\\/h4>\"}', '{\"en\":null}', NULL, 0, 1, 0, 2, 0, 1, 1, NULL, NULL, 679, 0, 1, '[\"9\"]', 0, NULL, 0, 0, 1, 20, 0, 0, 0, 0, NULL, NULL);
INSERT INTO `courses` (`id`, `category_id`, `subcategory_id`, `quiz_id`, `class_id`, `user_id`, `lang_id`, `title`, `slug`, `duration`, `image`, `thumbnail`, `price`, `discount_price`, `publish`, `status`, `level`, `trailer_link`, `host`, `meta_keywords`, `meta_description`, `about`, `special_commission`, `total_enrolled`, `reveune`, `reveiw`, `type`, `created_at`, `updated_at`, `drip`, `subscription`, `requirements`, `outcomes`, `subscription_list`, `total_rating`, `scope`, `complete_order`, `certificate_id`, `show_overview_media`, `show_mode_of_delivery`, `mode_of_delivery`, `what_learn1`, `what_learn2`, `view`, `feature`, `lms_id`, `assistant_instructors`, `required_type`, `iap_product_id`, `school_subject_id`, `access_limit`, `total_chapters`, `total_lessons`, `total_quiz_lessons`, `total_comments`, `total_reviews`, `has_badge`, `course_badge`, `price_text`) VALUES
(4, 5, NULL, NULL, NULL, 7, 9, '{\"en\":\"3-in-1 Digital Business Mastery\",\"bn\":\"3-in-1 Digital Business Mastery\"}', '3-in-1-digital-business-mastery', NULL, 'https://samratitinstitute.com/public/uploads/main/files/26-05-2026/chatgpt-image-may-26-2026-06-16-12-am-20260526061717-d707d8.png', 'https://samratitinstitute.com/public/uploads/main/files/26-05-2026/chatgpt-image-may-26-2026-06-16-12-am-20260526061717-d707d8.png', 99.00, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, '{\"en\":\"
🔥 Start your successful online career today!\\r\\nThis course will teach you the 3 most profitable businesses today —\\r\\n💻 Digital Marketing\\r\\n🛒 E-commerce Business\\r\\n🌐 Domain Hosting Business\\r\\n🎯 This course is for:\\r\\n✔️ Students\\r\\n✔️ Job Seekers\\r\\n✔️ Freelancers\\r\\n✔️ Entrepreneurs\\r\\n✔️ Those who want to earn money online\\r\\n💡 Why take this course?\\r\\n⭐ Classes completely in Bengali\\r\\n⭐ Live + Recorded Support\\r\\n⭐ Real Business Strategy\\r\\n⭐ Beginner to Advanced Guide\\r\\n⭐ Lifetime Support<\\/b><\\/span><\\/pre>\",\"bn\":\"
💡 যাদের কোনো পূর্ব অভিজ্ঞতা নেই তারাও Step-by-Step Guideline অনুসরণ করে সহজেই শিখতে পারবেন।<\\/span><\\/b><\\/div>

<\\/b><\\/div>
🔥 আপনার সফল অনলাইন ক্যারিয়ার শুরু হোক আজ থেকেই!<\\/span><\\/b><\\/div>
বর্তমানে সবচেয়ে লাভজনক ৩টি ব্যবসা একসাথে শেখানো হবে এই কোর্সে —<\\/span><\\/b><\\/div>
💻 Digital Marketing<\\/span><\\/b><\\/div>
🛒 E-commerce Business<\\/span><\\/b><\\/div>
🌐 Domain Hosting Business<\\/span><\\/b><\\/div>
🎯 এই কোর্সটি যাদের জন্য:<\\/span><\\/b><\\/div>
✔️ Students<\\/span><\\/b><\\/div>
✔️ Job Seekers<\\/span><\\/b><\\/div>
✔️ Freelancers<\\/span><\\/b><\\/div>
✔️ উদ্যোক্তা হতে আগ্রহীরা<\\/span><\\/b><\\/div>
✔️ যারা অনলাইন থেকে ইনকাম করতে চান<\\/span><\\/b><\\/div>
💡 কেন এই কোর্স করবেন?<\\/span><\\/b><\\/div>
⭐ সম্পূর্ণ বাংলা ভাষায় ক্লাস<\\/span><\\/b><\\/div>
⭐ লাইভ + রেকর্ডেড সাপোর্ট<\\/span><\\/b><\\/div>
⭐ Real Business Strategy<\\/span><\\/b><\\/div>
⭐ Beginner থেকে Advanced Guide<\\/span><\\/b><\\/div>
⭐ Lifetime Support<\\/span><\\/b><\\/div>

<\\/div>\"}', NULL, 105, 61739.4, 0, 1, '2026-05-25 23:47:21', '2026-10-13 07:06:30', 0, '0', '{\"en\":\"
No prior experience is required to take this course. Beginners can easily start 💯\\r\\n\\r\\n✅ A Smartphone \\/ Laptop \\/ Computer\\r\\n✅ Internet connection\\r\\n✅ Interest in learning and Consistency\\r\\n✅ A mindset to practice at least 1–2 hours a day\\r\\n\\r\\n💡 Those who have no prior experience can also learn easily by following the Step-by-Step Guideline.<\\/b><\\/span><\\/pre><\\/pre>\",\"bn\":\"
এই কোর্সটি করার জন্য পূর্বে কোনো<\\/b><\\/span><\\/pre>
 Experience থাকা বাধ্যতামূলক নয়।<\\/b><\\/span><\\/pre>
 Beginner থেকেও সহজে শুরু করতে পারবেন 💯\\r\\n\\r\\n✅ একটি Smartphone \\/ Laptop \\/ <\\/b><\\/span><\\/pre>
Computer\\r\\n✅ ইন্টারনেট সংযোগ\\r\\n✅ শেখার আগ্রহ এবং Consistency\\r\\n✅ প্রতিদিন কমপক্ষে ১–২ ঘণ্টা Practice করার মানসিকতা<\\/b><\\/span><\\/pre><\\/pre>\"}', '{\"en\":null}', NULL, 0, 1, 0, 2, 0, 1, 1, NULL, NULL, 1530, 0, 1, NULL, 0, NULL, 0, 0, 1, 26, 1, 0, 0, 0, NULL, NULL),
(5, 6, NULL, NULL, NULL, 7, 9, '{\"en\":\"Quran Learning Mastery Course\",\"bn\":\"Quran Learning Mastery Course\"}', 'quran-learning-mastery-course', NULL, 'https://samratitinstitute.com/public/uploads/main/files/12-06-2026/chatgpt-image-jun-12-2026-11-45-08-pm-20260612234537-1ab43d.png', 'https://samratitinstitute.com/public/uploads/main/files/12-06-2026/chatgpt-image-jun-12-2026-11-45-08-pm-20260612234537-1ab43d.png', 3000.00, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, '{\"en\":\"
Complete Online Quran Learning Course<\\/b><\\/span><\\/p>
This course is designed for students of all ages who want to learn the Holy Quran correctly and confidently from the comfort of their homes. Starting from Noorani Qaida, students will gradually learn proper Quran recitation with Tajweed, improve pronunciation, understand essential Islamic teachings, and develop a strong connection with the Quran.<\\/b><\\/p>
The course includes step-by-step guidance, live online classes, practical exercises, and personalized support from experienced instructors. Whether you are a beginner or looking to improve your recitation skills, this course will help you achieve your learning goals effectively.<\\/b><\\/p>
What You Will Learn:<\\/b><\\/h3>
\\r\\n\\r\\n\\r\\n\\r\\n<\\/p>
    \\r\\n
  • \\r\\nNoorani Qaida\\r\\n<\\/b><\\/li>\\r\\n
  • \\r\\nCorrect Arabic Pronunciation\\r\\n<\\/b><\\/li>\\r\\n
  • \\r\\nQuran Recitation with Tajweed\\r\\n<\\/b><\\/li>\\r\\n
  • \\r\\nBasic Islamic Knowledge\\r\\n<\\/b><\\/li>\\r\\n
  • \\r\\nQuran Memorization (Hifz) Techniques\\r\\n<\\/b><\\/li>\\r\\n
  • \\r\\nUnderstanding Selected Surahs and Duas\\r\\n<\\/b><\\/li>\\r\\n
  • \\r\\nDaily Practice and Revision Methods<\\/b><\\/li><\\/ul>\",\"bn\":\"
    সম্পূর্ণ অনলাইন কুরআন শিক্ষা কোর্স<\\/b><\\/h3>
    এই কোর্সটি এমনভাবে তৈরি করা হয়েছে যাতে সকল বয়সের শিক্ষার্থী ঘরে বসেই সহজ ও সঠিক পদ্ধতিতে পবিত্র কুরআন শিক্ষা লাভ করতে পারে। নূরানী কায়েদা থেকে শুরু করে তাজবীদসহ শুদ্ধ কুরআন তিলাওয়াত, আরবি উচ্চারণ, গুরুত্বপূর্ণ ইসলামিক জ্ঞান এবং কুরআনের সাথে গভীর সম্পর্ক গড়ে তোলার জন্য প্রয়োজনীয় বিষয়গুলো ধাপে ধাপে শেখানো হবে।<\\/b><\\/p>
    অভিজ্ঞ শিক্ষকের সরাসরি তত্ত্বাবধানে লাইভ অনলাইন ক্লাস, নিয়মিত অনুশীলন, মূল্যায়ন এবং ব্যক্তিগত সহায়তার মাধ্যমে শিক্ষার্থীদের দক্ষ করে তোলা হবে। আপনি যদি একেবারে নতুন শিক্ষার্থী হন অথবা আপনার তিলাওয়াত আরও সুন্দর করতে চান, তাহলে এই কোর্সটি আপনার জন্য উপযুক্ত।<\\/b><\\/p>
    এই কোর্সে যা শিখবেন:<\\/b><\\/h3>
      \\r\\n
    • \\r\\nনূরানী কায়েদা\\r\\n<\\/b><\\/li>\\r\\n
    • \\r\\nশুদ্ধ আরবি উচ্চারণ\\r\\n<\\/b><\\/li>\\r\\n
    • \\r\\nতাজবীদসহ কুরআন তিলাওয়াত\\r\\n<\\/b><\\/li>\\r\\n
    • \\r\\nমৌলিক ইসলামিক জ্ঞান\\r\\n<\\/b><\\/li>\\r\\n
    • \\r\\nহিফজুল কুরআনের প্রাথমিক কৌশল\\r\\n<\\/b><\\/li>\\r\\n
    • \\r\\nগুরুত্বপূর্ণ সূরা ও দোয়া\\r\\n<\\/b><\\/li>\\r\\n
    • \\r\\nনিয়মিত অনুশীলন ও রিভিশন পদ্ধতি\\r\\n<\\/b><\\/li>\\r\\n<\\/ul>
      \\r\\n\\r\\n\\r\\n\\r\\n\\r\\n<\\/p>
      Samrat IT Institute-এর এই কোর্সের লক্ষ্য হলো প্রতিটি শিক্ষার্থীকে শুদ্ধভাবে কুরআন পড়তে সক্ষম করা এবং ইসলামের মৌলিক জ্ঞান অর্জনে সহায়তা করা।<\\/span> 🕌📖✨<\\/b><\\/p>\"}', NULL, 0, 0, 0, 1, '2026-06-12 17:21:55', '2026-10-13 03:50:34', 0, '0', '{\"en\":\"
      • Internet-connected device (Mobile\\/PC)\\r\\n<\\/b><\\/li>\\r\\n
      • \\r\\nNo previous experience required\\r\\n<\\/b><\\/li>\\r\\n
      • \\r\\nSuitable for all ages\\r\\n<\\/b><\\/li>\\r\\n
      • \\r\\nInterest in learning Quran\\r\\n<\\/b><\\/li>\\r\\n
      • \\r\\nRegular practice commitment<\\/b><\\/li><\\/ul>\",\"bn\":\"
        • ইন্টারনেট সংযোগসহ মোবাইল বা কম্পিউটার\\r\\n<\\/b><\\/li>\\r\\n
        • \\r\\nপূর্ব অভিজ্ঞতা প্রয়োজন নেই\\r\\n<\\/b><\\/li>\\r\\n
        • \\r\\nসকল বয়সের জন্য উপযোগী\\r\\n<\\/b><\\/li>\\r\\n
        • \\r\\nকুরআন শেখার আগ্রহ\\r\\n<\\/b><\\/li>\\r\\n
        • \\r\\nনিয়মিত অনুশীলনের মানসিকতা<\\/b><\\/li><\\/ul>\"}', '{\"en\":\"
          After successfully completing this course, students will be able to:<\\/b><\\/p>
          \\r\\n<\\/p>
            \\r\\n
          • \\r\\nRead the Holy Quran correctly and confidently.\\r\\n<\\/b><\\/li>\\r\\n
          • \\r\\nApply Tajweed rules during Quran recitation.\\r\\n<\\/b><\\/li>\\r\\n
          • \\r\\nImprove Arabic pronunciation and fluency.\\r\\n<\\/b><\\/li>\\r\\n
          • \\r\\nRecite Quranic verses with proper articulation.\\r\\n<\\/b><\\/li>\\r\\n
          • \\r\\nMemorize selected Surahs and daily Duas.\\r\\n<\\/b><\\/li>\\r\\n
          • \\r\\nUnderstand the importance and virtues of Quran learning.\\r\\n<\\/b><\\/li>\\r\\n
          • \\r\\nDevelop a regular Quran study habit.\\r\\n<\\/b><\\/li>\\r\\n
          • \\r\\nStrengthen their connection with the Holy Quran and Islamic values.\\r\\n<\\/b><\\/li>\\r\\n
          • \\r\\nContinue advanced Quran studies independently.\\r\\n<\\/b><\\/li>\\r\\n
          • \\r\\nGain confidence in leading personal Quran recitation and practice.<\\/b><\\/li><\\/ul>\",\"bn\":\"
            এই কোর্স সফলভাবে সম্পন্ন করার পর শিক্ষার্থীরা—<\\/b><\\/p>
            \\r\\n<\\/p>
              \\r\\n
            • \\r\\nশুদ্ধভাবে ও আত্মবিশ্বাসের সাথে পবিত্র কুরআন তিলাওয়াত করতে পারবেন।\\r\\n<\\/b><\\/li>\\r\\n
            • \\r\\nতাজবীদের নিয়ম সঠিকভাবে প্রয়োগ করতে পারবেন।\\r\\n<\\/b><\\/li>\\r\\n
            • \\r\\nআরবি উচ্চারণ ও তিলাওয়াতের দক্ষতা বৃদ্ধি পাবে।\\r\\n<\\/b><\\/li>\\r\\n
            • \\r\\nমাখরাজ ও উচ্চারণের ভুল সংশোধন করতে পারবেন।\\r\\n<\\/b><\\/li>\\r\\n
            • \\r\\nগুরুত্বপূর্ণ সূরা ও দৈনন্দিন দোয়া মুখস্থ করতে পারবেন।\\r\\n<\\/b><\\/li>\\r\\n
            • \\r\\nকুরআন শিক্ষার গুরুত্ব ও ফজিলত সম্পর্কে সুস্পষ্ট ধারণা অর্জন করবেন।\\r\\n<\\/b><\\/li>\\r\\n
            • \\r\\nনিয়মিত কুরআন অধ্যয়নের অভ্যাস গড়ে তুলতে পারবেন।\\r\\n<\\/b><\\/li>\\r\\n
            • \\r\\nকুরআন ও ইসলামী মূল্যবোধের সাথে আরও দৃঢ় সম্পর্ক তৈরি হবে।\\r\\n<\\/b><\\/li>\\r\\n
            • \\r\\nভবিষ্যতে উচ্চতর কুরআন শিক্ষা গ্রহণের জন্য প্রস্তুত হতে পারবেন।\\r\\n<\\/b><\\/li>\\r\\n
            • \\r\\nদৈনন্দিন জীবনে কুরআনের শিক্ষা বাস্তবায়নে আত্মবিশ্বাস অর্জন করবেন।<\\/b><\\/li><\\/ul>\"}', NULL, 0, 1, 0, 2, 0, 1, 1, NULL, NULL, 536, 0, 1, NULL, 0, NULL, 0, 0, 1, 12, 0, 0, 0, 0, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `course_badges`
--

CREATE TABLE `course_badges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `course_canceleds`
--

CREATE TABLE `course_canceleds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `purchase_price` float NOT NULL,
  `refund` tinyint(1) NOT NULL DEFAULT 0,
  `cancel_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `request_by` bigint(20) UNSIGNED DEFAULT NULL,
  `request_from` varchar(191) NOT NULL DEFAULT 'admin',
  `enroll_id` bigint(20) UNSIGNED DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `cancel_reason` text DEFAULT NULL,
  `approved_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_canceleds`
--

INSERT INTO `course_canceleds` (`id`, `user_id`, `course_id`, `purchase_price`, `refund`, `cancel_by`, `created_at`, `updated_at`, `status`, `request_by`, `request_from`, `enroll_id`, `reason`, `cancel_reason`, `approved_date`) VALUES
(1, 3, 1, 999, 0, 1, '2026-04-12 16:08:36', '2026-04-12 16:08:36', 1, NULL, 'admin', NULL, 'as', NULL, '2026-04-12'),
(2, 43, 4, 999, 0, 1, '2026-05-28 19:57:49', '2026-05-28 19:57:49', 1, NULL, 'admin', NULL, 'gggg', NULL, '2026-05-29'),
(3, 12, 1, 999, 0, 1, '2026-05-31 13:53:10', '2026-05-31 13:53:10', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(4, 12, 3, 1, 0, 1, '2026-05-31 13:53:11', '2026-05-31 13:53:11', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(5, 12, 4, 999, 0, 1, '2026-05-31 13:53:11', '2026-05-31 13:53:11', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(6, 23, 1, 999, 0, 1, '2026-05-31 13:53:11', '2026-05-31 13:53:11', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(7, 23, 3, 1, 0, 1, '2026-05-31 13:53:12', '2026-05-31 13:53:12', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(8, 23, 4, 999, 0, 1, '2026-05-31 13:53:12', '2026-05-31 13:53:12', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(9, 32, 1, 999, 0, 1, '2026-05-31 13:53:14', '2026-05-31 13:53:14', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(10, 32, 3, 1, 0, 1, '2026-05-31 13:53:14', '2026-05-31 13:53:14', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(11, 32, 4, 999, 0, 1, '2026-05-31 13:53:15', '2026-05-31 13:53:15', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(12, 14, 1, 999, 0, 1, '2026-05-31 13:53:15', '2026-05-31 13:53:15', 1, NULL, 'admin', NULL, 'cansel', NULL, '2026-05-31'),
(13, 14, 3, 1, 0, 1, '2026-06-02 12:10:35', '2026-06-02 12:10:35', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(14, 14, 4, 999, 0, 1, '2026-06-02 12:10:36', '2026-06-02 12:10:36', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(15, 10, 1, 999, 0, 1, '2026-06-02 12:10:36', '2026-06-02 12:10:36', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(16, 10, 3, 1, 0, 1, '2026-06-02 12:10:36', '2026-06-02 12:10:36', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(17, 10, 4, 999, 0, 1, '2026-06-02 12:10:37', '2026-06-02 12:10:37', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(18, 5, 1, 999, 0, 1, '2026-06-02 12:10:37', '2026-06-02 12:10:37', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(19, 5, 3, 1, 0, 1, '2026-06-02 12:10:38', '2026-06-02 12:10:38', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(20, 5, 4, 999, 0, 1, '2026-06-02 12:10:38', '2026-06-02 12:10:38', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(21, 42, 4, 999, 0, 1, '2026-06-02 12:10:39', '2026-06-02 12:10:39', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(22, 50, 4, 999, 0, 1, '2026-06-02 12:10:39', '2026-06-02 12:10:39', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(23, 11, 1, 999, 0, 1, '2026-06-02 12:11:07', '2026-06-02 12:11:07', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(24, 16, 1, 999, 0, 1, '2026-06-02 12:11:07', '2026-06-02 12:11:07', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(25, 16, 3, 1, 0, 1, '2026-06-02 12:11:08', '2026-06-02 12:11:08', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(26, 4, 3, 1, 0, 1, '2026-06-02 12:11:08', '2026-06-02 12:11:08', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(27, 19, 3, 1, 0, 1, '2026-06-02 12:11:08', '2026-06-02 12:11:08', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(28, 21, 3, 1, 0, 1, '2026-06-02 12:11:09', '2026-06-02 12:11:09', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(29, 38, 3, 1, 0, 1, '2026-06-02 12:11:09', '2026-06-02 12:11:09', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(30, 39, 3, 1, 0, 1, '2026-06-02 12:11:10', '2026-06-02 12:11:10', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(31, 28, 3, 1, 0, 1, '2026-06-02 12:11:10', '2026-06-02 12:11:10', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(32, 15, 1, 999, 0, 1, '2026-06-02 12:11:10', '2026-06-02 12:11:10', 1, NULL, 'admin', NULL, 'vvv', NULL, '2026-06-02'),
(33, 17, 1, 999, 0, 1, '2026-06-02 12:11:23', '2026-06-02 12:11:23', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(34, 18, 1, 999, 0, 1, '2026-06-02 12:11:24', '2026-06-02 12:11:24', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(35, 19, 1, 999, 0, 1, '2026-06-02 12:11:24', '2026-06-02 12:11:24', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(36, 20, 1, 999, 0, 1, '2026-06-02 12:11:25', '2026-06-02 12:11:25', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(37, 21, 1, 999, 0, 1, '2026-06-02 12:11:25', '2026-06-02 12:11:25', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(38, 22, 1, 999, 0, 1, '2026-06-02 12:11:25', '2026-06-02 12:11:25', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(39, 2, 1, 999, 0, 1, '2026-06-02 12:11:26', '2026-06-02 12:11:26', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(40, 2, 3, 1, 0, 1, '2026-06-02 12:11:26', '2026-06-02 12:11:26', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(41, 3, 1, 999, 0, 1, '2026-06-02 12:11:27', '2026-06-02 12:11:27', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(42, 3, 3, 1, 0, 1, '2026-06-02 12:11:27', '2026-06-02 12:11:27', 1, NULL, 'admin', NULL, 'hghh', NULL, '2026-06-02'),
(43, 4, 1, 999, 0, 1, '2026-06-02 12:11:35', '2026-06-02 12:11:35', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(44, 6, 1, 999, 0, 1, '2026-06-02 12:11:36', '2026-06-02 12:11:36', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(45, 6, 3, 1, 0, 1, '2026-06-02 12:11:36', '2026-06-02 12:11:36', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(46, 11, 3, 1, 0, 1, '2026-06-02 12:11:37', '2026-06-02 12:11:37', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(47, 15, 3, 1, 0, 1, '2026-06-02 12:11:37', '2026-06-02 12:11:37', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(48, 17, 3, 1, 0, 1, '2026-06-02 12:11:37', '2026-06-02 12:11:37', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(49, 18, 3, 1, 0, 1, '2026-06-02 12:11:38', '2026-06-02 12:11:38', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(50, 20, 3, 1, 0, 1, '2026-06-02 12:11:38', '2026-06-02 12:11:38', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(51, 22, 3, 1, 0, 1, '2026-06-02 12:11:39', '2026-06-02 12:11:39', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(52, 24, 1, 999, 0, 1, '2026-06-02 12:11:39', '2026-06-02 12:11:39', 1, NULL, 'admin', NULL, 'fff', NULL, '2026-06-02'),
(53, 24, 3, 1, 0, 1, '2026-06-02 12:11:47', '2026-06-02 12:11:47', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(54, 25, 1, 999, 0, 1, '2026-06-02 12:11:47', '2026-06-02 12:11:47', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(55, 25, 3, 1, 0, 1, '2026-06-02 12:11:48', '2026-06-02 12:11:48', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(56, 26, 1, 999, 0, 1, '2026-06-02 12:11:48', '2026-06-02 12:11:48', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(57, 26, 3, 1, 0, 1, '2026-06-02 12:11:48', '2026-06-02 12:11:48', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(58, 27, 1, 999, 0, 1, '2026-06-02 12:11:49', '2026-06-02 12:11:49', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(59, 27, 3, 1, 0, 1, '2026-06-02 12:11:49', '2026-06-02 12:11:49', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(60, 28, 1, 999, 0, 1, '2026-06-02 12:11:49', '2026-06-02 12:11:49', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(61, 29, 1, 999, 0, 1, '2026-06-02 12:11:50', '2026-06-02 12:11:50', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(62, 29, 3, 1, 0, 1, '2026-06-02 12:11:50', '2026-06-02 12:11:50', 1, NULL, 'admin', NULL, 'yhhhj', NULL, '2026-06-02'),
(63, 30, 1, 999, 0, 1, '2026-06-02 12:12:00', '2026-06-02 12:12:00', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(64, 30, 3, 1, 0, 1, '2026-06-02 12:12:01', '2026-06-02 12:12:01', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(65, 31, 1, 999, 0, 1, '2026-06-02 12:12:01', '2026-06-02 12:12:01', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(66, 31, 3, 1, 0, 1, '2026-06-02 12:12:02', '2026-06-02 12:12:02', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(67, 33, 1, 999, 0, 1, '2026-06-02 12:12:02', '2026-06-02 12:12:02', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(68, 33, 3, 1, 0, 1, '2026-06-02 12:12:03', '2026-06-02 12:12:03', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(69, 34, 1, 999, 0, 1, '2026-06-02 12:12:03', '2026-06-02 12:12:03', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(70, 34, 3, 1, 0, 1, '2026-06-02 12:12:04', '2026-06-02 12:12:04', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(71, 35, 1, 999, 0, 1, '2026-06-02 12:12:04', '2026-06-02 12:12:04', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(72, 35, 3, 1, 0, 1, '2026-06-02 12:12:04', '2026-06-02 12:12:04', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(73, 36, 1, 999, 0, 1, '2026-06-02 12:12:15', '2026-06-02 12:12:15', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(74, 36, 3, 1, 0, 1, '2026-06-02 12:12:16', '2026-06-02 12:12:16', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(75, 37, 1, 999, 0, 1, '2026-06-02 12:12:16', '2026-06-02 12:12:16', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(76, 37, 3, 1, 0, 1, '2026-06-02 12:12:16', '2026-06-02 12:12:16', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(77, 38, 1, 999, 0, 1, '2026-06-02 12:12:17', '2026-06-02 12:12:17', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(78, 39, 1, 999, 0, 1, '2026-06-02 12:12:17', '2026-06-02 12:12:17', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(79, 40, 1, 999, 0, 1, '2026-06-02 12:12:18', '2026-06-02 12:12:18', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(80, 40, 3, 1, 0, 1, '2026-06-02 12:12:18', '2026-06-02 12:12:18', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(81, 41, 1, 999, 0, 1, '2026-06-02 12:12:18', '2026-06-02 12:12:18', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(82, 41, 3, 1, 0, 1, '2026-06-02 12:12:19', '2026-06-02 12:12:19', 1, NULL, 'admin', NULL, 'fgg', NULL, '2026-06-02'),
(83, 2, 4, 999, 0, 1, '2026-06-02 12:12:29', '2026-06-02 12:12:29', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(84, 3, 4, 999, 0, 1, '2026-06-02 12:12:29', '2026-06-02 12:12:29', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(85, 4, 4, 999, 0, 1, '2026-06-02 12:12:29', '2026-06-02 12:12:29', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(86, 6, 4, 999, 0, 1, '2026-06-02 12:12:30', '2026-06-02 12:12:30', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(87, 11, 4, 999, 0, 1, '2026-06-02 12:12:30', '2026-06-02 12:12:30', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(88, 15, 4, 999, 0, 1, '2026-06-02 12:12:31', '2026-06-02 12:12:31', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(89, 16, 4, 999, 0, 1, '2026-06-02 12:12:31', '2026-06-02 12:12:31', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(90, 17, 4, 999, 0, 1, '2026-06-02 12:12:31', '2026-06-02 12:12:31', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(91, 18, 4, 999, 0, 1, '2026-06-02 12:12:32', '2026-06-02 12:12:32', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(92, 19, 4, 999, 0, 1, '2026-06-02 12:12:32', '2026-06-02 12:12:32', 1, NULL, 'admin', NULL, 'ggg', NULL, '2026-06-02'),
(93, 20, 4, 999, 0, 1, '2026-06-02 12:12:39', '2026-06-02 12:12:39', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(94, 21, 4, 999, 0, 1, '2026-06-02 12:12:40', '2026-06-02 12:12:40', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(95, 22, 4, 999, 0, 1, '2026-06-02 12:12:40', '2026-06-02 12:12:40', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(96, 24, 4, 999, 0, 1, '2026-06-02 12:12:40', '2026-06-02 12:12:40', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(97, 25, 4, 999, 0, 1, '2026-06-02 12:12:41', '2026-06-02 12:12:41', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(98, 26, 4, 999, 0, 1, '2026-06-02 12:12:41', '2026-06-02 12:12:41', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(99, 27, 4, 999, 0, 1, '2026-06-02 12:12:41', '2026-06-02 12:12:41', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(100, 28, 4, 999, 0, 1, '2026-06-02 12:12:42', '2026-06-02 12:12:42', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(101, 29, 4, 999, 0, 1, '2026-06-02 12:12:42', '2026-06-02 12:12:42', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(102, 30, 4, 999, 0, 1, '2026-06-02 12:12:43', '2026-06-02 12:12:43', 1, NULL, 'admin', NULL, 'dfdfgf', NULL, '2026-06-02'),
(103, 31, 4, 999, 0, 1, '2026-06-02 12:12:50', '2026-06-02 12:12:50', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(104, 33, 4, 999, 0, 1, '2026-06-02 12:12:50', '2026-06-02 12:12:50', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(105, 34, 4, 999, 0, 1, '2026-06-02 12:12:50', '2026-06-02 12:12:50', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(106, 35, 4, 999, 0, 1, '2026-06-02 12:12:51', '2026-06-02 12:12:51', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(107, 36, 4, 999, 0, 1, '2026-06-02 12:12:51', '2026-06-02 12:12:51', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(108, 37, 4, 999, 0, 1, '2026-06-02 12:12:51', '2026-06-02 12:12:51', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(109, 38, 4, 999, 0, 1, '2026-06-02 12:12:52', '2026-06-02 12:12:52', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(110, 39, 4, 999, 0, 1, '2026-06-02 12:12:52', '2026-06-02 12:12:52', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(111, 40, 4, 999, 0, 1, '2026-06-02 12:12:53', '2026-06-02 12:12:53', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(112, 41, 4, 999, 0, 1, '2026-06-02 12:12:53', '2026-06-02 12:12:53', 1, NULL, 'admin', NULL, 'hyhh', NULL, '2026-06-02'),
(113, 103, 3, 1, 1, 1, '2026-10-08 21:12:07', '2026-10-08 21:12:07', 1, NULL, 'admin', NULL, 'cancle', NULL, '2026-10-09');

-- --------------------------------------------------------

--
-- Table structure for table `course_comments`
--

CREATE TABLE `course_comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `instructor_id` int(10) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `comment` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `course_comment_replies`
--

CREATE TABLE `course_comment_replies` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `course_id` int(10) UNSIGNED NOT NULL,
  `comment_id` int(10) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `reply` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `reply_id` int(11) DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `course_enrolleds`
--

CREATE TABLE `course_enrolleds` (
  `id` int(10) UNSIGNED NOT NULL,
  `tracking` varchar(191) DEFAULT '1',
  `user_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `purchase_price` float DEFAULT 0,
  `coupon` varchar(191) DEFAULT NULL,
  `discount_amount` float DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `reveune` float DEFAULT 0,
  `reason` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `subscription` varchar(191) NOT NULL DEFAULT '0',
  `subscription_validity_date` date DEFAULT NULL,
  `last_view_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1,
  `send_expire_notification` tinyint(4) NOT NULL DEFAULT 0,
  `feedback` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_enrolleds`
--

INSERT INTO `course_enrolleds` (`id`, `tracking`, `user_id`, `course_id`, `purchase_price`, `coupon`, `discount_amount`, `status`, `reveune`, `reason`, `created_at`, `updated_at`, `subscription`, `subscription_validity_date`, `last_view_at`, `lms_id`, `send_expire_notification`, `feedback`) VALUES
(113, '1', 2, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:33', '2026-06-02 12:14:33', '0', NULL, NULL, 1, 0, NULL),
(114, '1', 3, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:33', '2026-10-10 09:37:38', '0', NULL, '2026-10-10 09:37:38', 1, 0, NULL),
(115, '1', 4, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:33', '2026-06-02 12:14:34', '0', NULL, NULL, 1, 0, NULL),
(116, '1', 5, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:34', '2026-06-02 12:14:34', '0', NULL, NULL, 1, 0, NULL),
(117, '1', 6, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:34', '2026-06-02 12:14:35', '0', NULL, NULL, 1, 0, NULL),
(118, '1', 10, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:35', '2026-06-02 12:14:35', '0', NULL, NULL, 1, 0, NULL),
(119, '1', 11, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:35', '2026-06-02 12:14:35', '0', NULL, NULL, 1, 0, NULL),
(120, '1', 12, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:35', '2026-06-02 12:14:36', '0', NULL, NULL, 1, 0, NULL),
(121, '1', 14, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:36', '2026-06-02 12:14:36', '0', NULL, NULL, 1, 0, NULL),
(122, '1', 15, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:36', '2026-06-02 12:14:37', '0', NULL, NULL, 1, 0, NULL),
(123, '1', 16, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:37', '2026-07-12 11:01:07', '0', NULL, '2026-07-12 11:01:07', 1, 0, NULL),
(124, '1', 17, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:37', '2026-06-02 12:14:37', '0', NULL, NULL, 1, 0, NULL),
(125, '1', 18, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:37', '2026-06-02 12:14:38', '0', NULL, NULL, 1, 0, NULL),
(126, '1', 19, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:38', '2026-06-10 20:38:13', '0', NULL, '2026-06-10 20:38:13', 1, 0, NULL),
(127, '1', 20, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:38', '2026-06-02 12:14:39', '0', NULL, NULL, 1, 0, NULL),
(128, '1', 21, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:39', '2026-06-02 12:14:39', '0', NULL, NULL, 1, 0, NULL),
(129, '1', 22, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:39', '2026-07-07 08:35:50', '0', NULL, '2026-07-07 08:35:50', 1, 0, NULL),
(130, '1', 23, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:39', '2026-06-02 12:14:40', '0', NULL, NULL, 1, 0, NULL),
(131, '1', 24, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:40', '2026-09-27 18:17:38', '0', NULL, '2026-09-27 18:17:38', 1, 0, NULL),
(132, '1', 25, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:40', '2026-06-02 12:14:41', '0', NULL, NULL, 1, 0, NULL),
(133, '1', 26, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:41', '2026-06-02 12:14:41', '0', NULL, NULL, 1, 0, NULL),
(134, '1', 27, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:41', '2026-06-02 12:14:41', '0', NULL, NULL, 1, 0, NULL),
(135, '1', 28, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:41', '2026-07-14 11:01:45', '0', NULL, '2026-07-14 11:01:45', 1, 0, NULL),
(136, '1', 29, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:42', '2026-06-02 12:14:42', '0', NULL, NULL, 1, 0, NULL),
(137, '1', 30, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:42', '2026-10-11 07:25:10', '0', NULL, '2026-10-11 07:25:10', 1, 0, NULL),
(138, '1', 31, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:43', '2026-06-02 12:14:43', '0', NULL, NULL, 1, 0, NULL),
(139, '1', 32, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:43', '2026-06-02 12:14:43', '0', NULL, NULL, 1, 0, NULL),
(140, '1', 33, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:43', '2026-06-02 12:14:44', '0', NULL, NULL, 1, 0, NULL),
(141, '1', 34, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:44', '2026-06-02 12:14:44', '0', NULL, NULL, 1, 0, NULL),
(142, '1', 35, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:44', '2026-06-02 12:14:45', '0', NULL, NULL, 1, 0, NULL),
(143, '1', 36, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:45', '2026-06-29 12:29:01', '0', NULL, '2026-06-29 12:29:01', 1, 0, NULL),
(144, '1', 37, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:45', '2026-06-02 12:14:46', '0', NULL, NULL, 1, 0, NULL),
(145, '1', 38, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:46', '2026-06-02 12:14:46', '0', NULL, NULL, 1, 0, NULL),
(146, '1', 39, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:46', '2026-06-02 12:14:47', '0', NULL, NULL, 1, 0, NULL),
(147, '1', 40, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:47', '2026-06-02 12:14:48', '0', NULL, NULL, 1, 0, NULL),
(148, '1', 41, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:48', '2026-06-02 12:14:48', '0', NULL, NULL, 1, 0, NULL),
(149, '1', 42, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:48', '2026-06-02 12:14:49', '0', NULL, NULL, 1, 0, NULL),
(150, '1', 43, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:49', '2026-07-10 16:33:10', '0', NULL, '2026-07-10 16:33:10', 1, 0, NULL),
(151, '1', 44, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:49', '2026-06-02 12:14:50', '0', NULL, NULL, 1, 0, NULL),
(152, '1', 45, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:50', '2026-06-02 12:14:51', '0', NULL, NULL, 1, 0, NULL),
(153, '1', 46, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:51', '2026-06-21 09:44:31', '0', NULL, '2026-06-21 09:44:31', 1, 0, NULL),
(154, '1', 47, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:51', '2026-06-02 12:14:52', '0', NULL, NULL, 1, 0, NULL),
(155, '1', 48, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:52', '2026-09-28 03:14:04', '0', NULL, '2026-09-28 03:14:04', 1, 0, NULL),
(156, '1', 49, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:53', '2026-09-27 17:00:37', '0', NULL, '2026-09-27 17:00:37', 1, 0, NULL),
(157, '1', 50, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:53', '2026-06-28 13:05:38', '0', NULL, '2026-06-28 13:05:38', 1, 0, NULL),
(158, '1', 51, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:54', '2026-06-02 12:14:54', '0', NULL, NULL, 1, 0, NULL),
(159, '1', 52, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:14:54', '2026-06-02 12:14:55', '0', NULL, NULL, 1, 0, NULL),
(160, '1', 53, 3, 5000, NULL, 0, 1, 3000, NULL, '2026-06-02 12:24:32', '2026-06-02 14:12:26', '0', NULL, '2026-06-02 14:12:26', 1, 0, NULL),
(161, '1', 53, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 12:24:32', '2026-06-02 12:24:32', '0', NULL, NULL, 1, 0, NULL),
(162, '1', 55, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-02 16:28:35', '2026-06-10 04:26:47', '0', NULL, '2026-06-10 04:26:47', 1, 0, NULL),
(163, '1', 56, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-04 08:24:19', '2026-09-24 20:47:10', '0', NULL, '2026-09-24 20:47:10', 1, 0, NULL),
(164, '1', 60, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-10 10:05:09', '2026-07-07 21:27:20', '0', NULL, '2026-07-07 21:27:20', 1, 0, NULL),
(165, '1', 63, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-10 17:41:46', '2026-06-13 03:13:31', '0', NULL, '2026-06-13 03:13:31', 1, 0, NULL),
(166, '1', 54, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-10 18:41:02', '2026-09-27 16:40:12', '0', NULL, '2026-09-27 16:40:12', 1, 0, NULL),
(167, '1', 64, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-11 06:03:18', '2026-06-29 06:13:24', '0', NULL, '2026-06-29 06:13:24', 1, 0, NULL),
(168, '1', 38, 1, 999, NULL, 0, 1, 599.4, NULL, '2026-06-15 09:24:43', '2026-06-15 09:24:44', '0', NULL, NULL, 1, 0, NULL),
(169, '1', 38, 3, 5000, NULL, 0, 1, 3000, NULL, '2026-06-15 09:24:44', '2026-06-15 09:24:44', '0', NULL, NULL, 1, 0, NULL),
(170, '1', 67, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-15 13:37:10', '2026-06-15 13:37:10', '0', NULL, NULL, 1, 0, NULL),
(171, '1', 61, 3, 5000, NULL, 0, 1, 3000, NULL, '2026-06-16 19:03:32', '2026-06-16 19:03:33', '0', NULL, NULL, 1, 0, NULL),
(172, '1', 61, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-16 19:03:33', '2026-06-16 19:06:40', '0', NULL, '2026-06-16 19:06:40', 1, 0, NULL),
(173, '1', 69, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-20 06:53:21', '2026-06-20 06:53:21', '0', NULL, NULL, 1, 0, NULL),
(174, '1', 71, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-29 19:25:38', '2026-07-07 16:35:11', '0', NULL, '2026-07-07 16:35:11', 1, 0, NULL),
(175, '1', 72, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-06-30 17:55:19', '2026-07-19 14:39:21', '0', NULL, '2026-07-19 14:39:21', 1, 0, NULL),
(176, '1', 73, 3, 5000, NULL, 0, 1, 3000, NULL, '2026-07-12 16:42:05', '2026-07-21 14:27:16', '0', NULL, '2026-07-21 14:27:16', 1, 0, NULL),
(177, '1', 73, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-07-12 16:42:05', '2026-07-21 14:26:20', '0', NULL, '2026-07-21 14:26:20', 1, 0, NULL),
(178, '1', 86, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-09-27 16:56:25', '2026-10-11 12:41:44', '0', NULL, '2026-10-11 12:41:44', 1, 0, NULL),
(179, '1', 85, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-10-07 12:15:39', '2026-10-12 13:59:21', '0', NULL, '2026-10-12 13:59:21', 1, 0, NULL),
(181, '1AHBCBJQUYYJ', 105, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-10-09 08:30:23', '2026-10-09 08:48:26', '0', NULL, '2026-10-09 08:48:26', 1, 0, NULL),
(182, 'TN2PHMMHY4Y9', 106, 4, 999, NULL, 0, 1, 599.4, NULL, '2026-10-09 10:34:56', '2026-10-09 10:34:56', '0', NULL, NULL, 1, 0, NULL),
(183, 'TBAMMRBKKNHT', 106, 1, 999, NULL, 0, 1, 599.4, NULL, '2026-10-09 10:37:18', '2026-10-09 10:38:02', '0', NULL, '2026-10-09 10:38:02', 1, 0, NULL),
(184, '4Y2CSS4TU67P', 107, 1, 999, NULL, 0, 1, 599.4, NULL, '2026-10-09 14:52:57', '2026-10-09 14:52:57', '0', NULL, NULL, 1, 0, NULL),
(185, 'Z3N23K8MSKZ1', 108, 4, 1, NULL, 0, 1, 0.6, NULL, '2026-10-09 15:21:35', '2026-10-09 15:21:35', '0', NULL, NULL, 1, 0, NULL),
(186, 'FH2RPGQP3TC7', 110, 4, 1, NULL, 0, 1, 0.6, NULL, '2026-10-09 15:33:50', '2026-10-09 15:33:50', '0', NULL, NULL, 1, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `course_exercises`
--

CREATE TABLE `course_exercises` (
  `id` int(10) UNSIGNED NOT NULL,
  `course_id` int(11) NOT NULL,
  `fileName` varchar(191) NOT NULL,
  `file` varchar(191) NOT NULL,
  `lock` tinyint(1) NOT NULL DEFAULT 1,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1,
  `old_file_size` double DEFAULT NULL,
  `file_size` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `course_levels`
--

CREATE TABLE `course_levels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` longtext DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_levels`
--

INSERT INTO `course_levels` (`id`, `title`, `status`, `created_at`, `updated_at`, `lms_id`) VALUES
(1, '{\"en\":\"Beginner\"}', 1, NULL, NULL, 1),
(2, '{\"en\":\"Intermediate\"}', 1, NULL, NULL, 1),
(3, '{\"en\":\"Advance\"}', 1, NULL, NULL, 1),
(4, '{\"en\":\"Pro\"}', 1, NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `course_reveiws`
--

CREATE TABLE `course_reveiws` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `comment` text NOT NULL,
  `star` double NOT NULL DEFAULT 5,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `instructor_id` int(11) DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_reveiws`
--

INSERT INTO `course_reveiws` (`id`, `user_id`, `course_id`, `status`, `comment`, `star`, `created_at`, `updated_at`, `instructor_id`, `lms_id`) VALUES
(1, 48, 4, 0, '. shilpi Khatun', 4, '2026-06-18 04:25:52', '2026-06-18 04:25:52', NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `course_settings`
--

CREATE TABLE `course_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `show_mode_of_delivery` int(11) DEFAULT 1,
  `show_rating` int(11) DEFAULT 1,
  `show_cart` int(11) DEFAULT 1,
  `show_enrolled_or_level_section` int(11) DEFAULT 1,
  `enrolled_or_level` int(11) DEFAULT 1 COMMENT '1 for enrolled and 2 fro course level',
  `show_cql_left_sidebar` int(11) DEFAULT 0,
  `size_of_grid` int(11) DEFAULT 4,
  `show_review_option` int(11) DEFAULT 0,
  `show_rating_option` int(11) DEFAULT 0,
  `show_search_in_category` int(11) DEFAULT 1,
  `show_instructor_rating` int(11) DEFAULT 0,
  `show_instructor_review` int(11) DEFAULT 0,
  `show_instructor_enrolled` int(11) DEFAULT 0,
  `show_instructor_courses` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_settings`
--

INSERT INTO `course_settings` (`id`, `show_mode_of_delivery`, `show_rating`, `show_cart`, `show_enrolled_or_level_section`, `enrolled_or_level`, `show_cql_left_sidebar`, `size_of_grid`, `show_review_option`, `show_rating_option`, `show_search_in_category`, `show_instructor_rating`, `show_instructor_review`, `show_instructor_enrolled`, `show_instructor_courses`, `created_at`, `updated_at`, `lms_id`) VALUES
(1, 1, 1, 1, 1, 1, 1, 4, 0, 0, 1, 0, 0, 0, 1, NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `code` varchar(191) DEFAULT NULL,
  `symbol` varchar(191) DEFAULT NULL,
  `conversion_rate` double NOT NULL DEFAULT 1,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `custom_class_messages`
--

CREATE TABLE `custom_class_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `class_id` int(11) DEFAULT NULL,
  `msg` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `custom_meetings`
--

CREATE TABLE `custom_meetings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_by` int(11) DEFAULT 1,
  `instructor_id` int(11) DEFAULT 1,
  `class_id` int(11) DEFAULT NULL,
  `topic` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `duration` double DEFAULT 0,
  `date` text DEFAULT NULL,
  `host` text DEFAULT NULL,
  `link` text DEFAULT NULL,
  `time` text DEFAULT NULL,
  `datetime` text DEFAULT NULL,
  `datetime_utc` text DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `data_table_management`
--

CREATE TABLE `data_table_management` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `table_name` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `column_label` varchar(191) DEFAULT NULL,
  `column_name` varchar(191) DEFAULT NULL,
  `is_visible` tinyint(1) DEFAULT 1,
  `is_default` tinyint(1) DEFAULT 0,
  `order` int(11) DEFAULT NULL,
  `original_order` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `date_formats`
--

CREATE TABLE `date_formats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `format` varchar(191) DEFAULT NULL,
  `normal_view` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(10) UNSIGNED DEFAULT 1,
  `updated_by` int(10) UNSIGNED DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `date_formats`
--

INSERT INTO `date_formats` (`id`, `format`, `normal_view`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `lms_id`) VALUES
(1, 'jS M, Y', '17th May, 2019', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(2, 'Y-m-d', '2019-05-17', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(3, 'Y-d-m', '2019-17-05', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(4, 'd-m-Y', '17-05-2019', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(5, 'm-d-Y', '05-17-2019', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(6, 'Y/m/d', '2019/05/17', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(7, 'Y/d/m', '2019/17/05', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(8, 'd/m/Y', '17/05/2019', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(9, 'm/d/Y', '05/17/2019', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(10, 'l jS \\of F Y', 'Monday 17th of May 2019', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(11, 'jS \\of F Y', '17th of May 2019', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(12, 'g:ia \\o\\n l jS F Y', '12:00am on Monday 17th May 2019', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(13, 'F j, Y, g:i a', 'May 7, 2019, 6:20 pm', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(14, 'F j, Y', 'May 17, 2019', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1),
(15, '\\i\\t \\i\\s \\t\\h\\e jS \\d\\a\\y', 'it is the 17th day', 1, 1, 1, '2026-04-09 21:34:25', '2026-04-09 21:34:25', 1);

-- --------------------------------------------------------

--
-- Table structure for table `delete_account_requests`
--

CREATE TABLE `delete_account_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `deposit_records`
--

CREATE TABLE `deposit_records` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `method` varchar(191) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `response` longtext DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1,
  `session_id` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email_settings`
--

CREATE TABLE `email_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `email_engine_type` varchar(191) DEFAULT NULL,
  `from_name` varchar(191) DEFAULT NULL,
  `from_email` varchar(191) DEFAULT NULL,
  `mail_driver` varchar(191) DEFAULT NULL,
  `mail_host` varchar(191) DEFAULT NULL,
  `mail_port` varchar(191) DEFAULT NULL,
  `mail_username` varchar(191) DEFAULT NULL,
  `mail_password` varchar(191) DEFAULT NULL,
  `mail_encryption` varchar(191) DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT 1,
  `api_key` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_settings`
--

INSERT INTO `email_settings` (`id`, `email_engine_type`, `from_name`, `from_email`, `mail_driver`, `mail_host`, `mail_port`, `mail_username`, `mail_password`, `mail_encryption`, `active_status`, `api_key`, `created_at`, `updated_at`, `lms_id`) VALUES
(1, 'php', 'System Admin', 'norepaly@samratitinstitute.com', 'php', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2026-04-10 19:30:19', 1),
(2, 'smtp', 'System Admin', 'admin@lms.com', 'smtp', 'smtp.mailtrap.io', '2525', '7afbe3a03cb8ec', '5456df993a535c', 'tls', 0, NULL, NULL, NULL, 1),
(3, 'sendgrid', 'Admin', 'info@pangea-technology.com', NULL, NULL, NULL, NULL, NULL, NULL, 0, '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', NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` int(10) UNSIGNED NOT NULL,
  `act` varchar(191) NOT NULL,
  `name` longtext DEFAULT NULL,
  `subj` longtext DEFAULT NULL,
  `email_body` longtext DEFAULT NULL,
  `shortcodes` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `browser_message` longtext DEFAULT NULL,
  `is_system` int(11) NOT NULL DEFAULT 0,
  `lms_id` int(11) NOT NULL DEFAULT 1,
  `ecommerce` tinyint(4) NOT NULL DEFAULT 0,
  `sms_message` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`id`, `act`, `name`, `subj`, `email_body`, `shortcodes`, `status`, `created_at`, `updated_at`, `browser_message`, `is_system`, `lms_id`, `ecommerce`, `sms_message`) VALUES
(1, 'OffLine_Payment', 'OffLine Payment', 'Offline Payment Request Approved', '{\"en\":\"\\n\\n\n\n
              \n
              \nReset Password Notification\n\n
              \n

              \n
              You are receiving this email because we received a password reset request for your account. {{reset_link}}. 
               
              \n             If you did not request a password reset, no further action is required..\n             
              \n             
              \n             
              \n             
              \nRegards,\n             From {{app_name}}
              \n
              \n\n
              \n\n\n    
              \n          \n         \n          \n         \n    
              \n
              \n\n', '{\"reset_link\":\"Reset Link\",\"app_name\":\"App Name\"}', 1, '2026-04-09 21:34:30', '2026-04-09 21:34:38', NULL, 1, 1, 0, NULL),
(19, 'CONTACT_MESSAGE', '{\"en\":\"Contact Message\"}', '{\"en\":\"Contact Message\"}', '{\"en\":\"\\r\\n\\r\\n\n\n    
              \n    
              \n    Course Enroll Refund By Admin\n\n    
              \n    

              \n    
              You have enrolled {{course}} on this course . Admin refund your enrollment   at {{time}}
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"course\":\"Course Name\",\"time\":\"Refund Time\"}', 1, '2026-04-09 21:34:47', '2026-04-09 21:34:47', NULL, 0, 1, 1, NULL),
(29, 'ResetOTP', 'Send Reset OTP Notification', 'Send Reset OTP Notification', '\n    \n    \n\n    
              \n    
              \n    Send Reset OTP Notification\n\n    
              \n    

              \n    
              Hello {{name}}, Your otp Code is {{otp}} 
              {{footer}}
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"otp\":\"OTP Code\",\"email\":\"Email Address\",\"name\":\"Name\"}', 1, '2026-04-09 21:34:56', '2026-04-09 21:34:56', NULL, 0, 1, 0, NULL),
(30, 'BLOG_PUBLISH', '{\"en\":\"New Blog publish\"}', '{\"en\":\"New Blog publish\"}', '{\"en\":\"\\n    \\n    \n\n    
              \n    
              \n    New Course Created\n\n    
              \n    

              \n    
              Hello {{admin}}, A New Course ({{course}}) Created By {{instructor}}.  
              {{footer}}
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"admin\":\"Admin Name\",\"course\":\"Course Name\",\"instructor\":\"Instructor Name\"}', 1, '2026-04-09 21:35:09', '2026-04-09 21:35:09', NULL, 0, 1, 0, NULL),
(32, 'PayoutRequest', 'Payout Request', 'Payout Request', '\n    \n    \n\n    
              \n    
              \n    Payout Request\n\n    
              \n    

              \n    
              Hello {{admin}}, {{amount}} payout requested by {{instructor}} 
              {{footer}}
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"admin\":\"Admin Name\",\"amount\":\"Payout Requested amount\",\"instructor\":\"Instructor Name\"}', 1, '2026-04-09 21:35:09', '2026-04-09 21:35:09', NULL, 0, 1, 0, NULL),
(33, 'POSTED_NOTIFICATION', '{\"en\":\"Posted notification\"}', '{\"en\":\"Posted notification\"}', '{\"en\":\"\\n    \\n    \n\n    
              \n    
              \n    Course Expire Soon\n\n    
              \n    

              \n    
              Hello {{name}}, {{course}}  will be expire at {{date}} .
              Course Link: {{link}}
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"name\":\"Student Name\",\"course\":\"Course Name\",\"date\":\"Expire Date\",\"link\":\"Course Link\"}', 1, '2026-04-09 21:35:13', '2026-04-09 21:35:13', NULL, 0, 1, 0, NULL),
(36, 'Quiz_Publish_Successfully', '{\"en\":\"Quiz Publish Successfully\"}', '{\"en\":\"Quiz Publish Successfully\"}', '{\"en\":\"\\n    \\n    \n\n    
              \n    
              \n    Send Email Verification OTP Notification\n\n    
              \n    

              \n    
              Hello {{name}}, Your otp Code is {{otp}} 
              {{footer}}
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"otp\":\"OTP Code\",\"email\":\"Email Address\",\"name\":\"Name\"}', 1, '2026-04-09 21:35:16', '2026-04-09 21:35:16', NULL, 0, 1, 0, NULL),
(46, 'BlogPostApproval', 'New Blog Post Pending Approval', 'New Blog Post Pending Approval', '\n    \n    \n\n    
              \n    
              \n    New Blog Post Pending Approval\n\n    
              \n    

              \n    
              Hello {{name}},
               A new blog post titled {{blog_title}} has been submitted and is waiting for your approval 
              Post By: {{blog_author}}
              Post Date: {{blog_date}}
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"name\":\"Admin Name\",\"blog_title\":\"Blog Post Title\",\"blog_author\":\"Blog Post Author\",\"blog_date\":\"Blog Post Date\"}', 1, '2026-04-09 21:35:19', '2026-04-09 21:35:19', NULL, 0, 1, 0, NULL),
(47, 'BankDepositRequest', 'Bank Payment Request for Deposit', 'Bank Payment Request for Deposit', '\n    \n    \n\n    
              \n    
              \n    Bank Payment Request for Deposit\n\n    
              \n    

              \n    
              Hello {{name}},
              A request to add funds has been received with the following details: 
              Amount: {{amount}}
              Date: {{date}}
              Request By: {{request_by}}
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"name\":\"Admin Name\",\"amount\":\"Amount\",\"date\":\"Date\",\"request_by\":\"Request By\"}', 1, '2026-04-09 21:35:19', '2026-04-09 21:35:19', NULL, 0, 1, 0, NULL),
(48, 'Certificate_Received', 'Certificate Received Notification', 'Congratulations! You have received your certificate', '\n    \n    \n\n    
              \n    
              \n    Congratulations! You have received your certificate\n\n    
              \n    

              \n    
              Hello {{name}}, 

              Congratulations on successfully completing the course: {{course}}.
              You have been awarded a certificate on {{date}}.

              You can download your certificate from this link or your dashboard.

              Thank you for learning with us!
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"name\":\"User Name\",\"course\":\"Course Name\",\"date\":\"Date\",\"certificate_link\":\"Certificate Link\"}', 1, '2026-04-09 21:35:19', '2026-04-09 21:35:19', NULL, 0, 1, 0, NULL),
(49, 'Badge_Unlocked', 'Badge Unlocked Notification', 'Congratulations! You have unlocked a badge', '\n    \n    \n\n    
              \n    
              \n    Congratulations! You have unlocked a badge\n\n    
              \n    

              \n    
              Hello {{name}}, 

              You have unlocked the badge: {{badge}}.
              Date: {{date}}.

              Keep up the great work!
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"name\":\"User Name\",\"badge\":\"Badge Name\",\"date\":\"Date\"}', 1, '2026-04-09 21:35:19', '2026-04-09 21:35:19', NULL, 0, 1, 0, NULL);
INSERT INTO `email_templates` (`id`, `act`, `name`, `subj`, `email_body`, `shortcodes`, `status`, `created_at`, `updated_at`, `browser_message`, `is_system`, `lms_id`, `ecommerce`, `sms_message`) VALUES
(50, 'Point_Added', 'Point Added Notification', 'You have earned points!', '\n    \n    \n\n    
              \n    
              \n    You have earned points!\n\n    
              \n    

              \n    
              Hello {{name}}, 

              You have earned {{points}} points.
              Reason: {{reason}}.
              Date: {{date}}.

              Keep participating to earn more rewards!
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"name\":\"User Name\",\"points\":\"Points\",\"reason\":\"Reason\",\"date\":\"Date\"}', 1, '2026-04-09 21:35:19', '2026-04-09 21:35:19', NULL, 0, 1, 0, NULL),
(51, 'Daily_Weekly_Progress_Report', 'Daily/Weekly Progress Report', 'Your Progress Report', '\n    \n    \n\n    
              \n    
              \n    Your Progress Report\n\n    
              \n    

              \n    
              Hello {{name}}, 

              Here is your {{period}} progress report:
              {{progress}}

              Keep up the great work!
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"name\":\"User Name\",\"progress\":\"Progress Details\",\"period\":\"Period (Daily/Weekly)\"}', 1, '2026-04-09 21:35:20', '2026-04-09 21:35:20', NULL, 0, 1, 0, NULL),
(52, 'Streak_Encouragement_Reminder', 'Streak Encouragement Reminder', 'Don\'t Break Your Streak!', '\n    \n    \n\n    
              \n    
              \n    Don\'t Break Your Streak!\n\n    
              \n    

              \n    
              Hello {{name}}, 

              You have a learning streak of {{streak_days}} days in {{course}}!
              Keep going to maintain your streak and achieve your goals.

              We believe in you!
              \n    
              \n\n    
              \n\n\n        
              \n              \n             \n              \n             \n        
              \n    
              \n\n    ', '{\"name\":\"User Name\",\"streak_days\":\"Streak Days\",\"course\":\"Course Name\"}', 1, '2026-04-09 21:35:20', '2026-04-09 21:35:20', NULL, 0, 1, 0, NULL),
(53, 'QUIZ_FEEDBACK', '{\"en\":\"New Feedback for your quiz\"}', '{\"en\":\"New Feedback for your quiz\"}', '{\"en\":\"\\n    \\n    \n    
              \n        
              \n            \"\"\n        
              \n        
              \n            
              \n                
              \n                    
              \n                        
              \n                            
              100k+
              \n                            
              \n                                
              Most Involved Teachers
              \n                                
              Key features are the ability to develop relationships with their students, patient, caring and kind knowledge offer learner engaging students of their.
              \n                            
              \n                        
              \n                        
              \n                            
              200+
              \n                            
              \n                                
              Large Selection of Courses
              \n                                
              Key features are the ability to develop relationships with their students, patient, caring and kind knowledge offer learner engaging students of their.
              \n                            
              \n                        
              \n                        
              \n                            
              150k+
              \n                            
              \n                                
              Large Selection of Courses
              \n                                
              Key features are the ability to develop relationships with their students, patient, caring and kind knowledge offer learner engaging students of their.
              \n                            
              \n                        
              \n                    
              \n                
              \n            
              \n        
              \n    
              \n
\n        
\n    
\n    
\n        
\n            
\n\n    
\n        
\n            
\n                
\n                    
\n                        
Client Testimonial
\n                        
The world\'s largest selection of courses choose from 130,000 online video courses\n                            with new additions published every month.
\n                    
\n                
\n            
\n            
\n                
\n                    
\n                        
\n                            
\n                        
\n                    
\n\n                
\n            
\n        
\n    
\n
\n        
\n    
\n    
\n        
\n            
\n    
\n        
\n            
\n                
\n\n                    
\n                
\n            
\n        
\n    
\n
\n        
\n    
\n    
\n        
\n            
\n    
\n        
\n            \n            
\n                
\n                    
\n                        
\n                            
\n                                
\n                                    \"\"\n                                
\n                                
\n                                    
Become a Instructor.
\n                                    
Teach what you love. Corrector gives you the\n                                        tools to create a course.
\n                                    Start Teaching\n                                
\n                            
\n                        
\n                        
\n                            
\n                                
\n                                    \"\"\n                                
\n                                
\n                                    
Learn with InfixLMS.
\n                                    
Teach what you love. Corrector gives you the\n                                        tools to create a course.
\n                                    For your Learning\n                                
\n                            
\n                        
\n                    
\n                
\n            
\n        
\n    
\n
\n\n        
\n    
\n
', '2', '/about-us', 8, '2', 1, 1, NULL, '2026-04-17 03:30:00', 1, 0, NULL),
(10, 1, '{\"en\":\"Contact us\",\"bn\":\"যোগাযোগ করুন\"}', '/contact-us', '
 
\n     
\n        
\n            
\n                
\n                    
\n                        
\n                            We’re here with you every step way\n                        
\n                         
\n                            Home / Contact Us\n                        
\n                    
\n                
\n            
\n        
\n    
\n
\n
\n\n    
\n        
\n            \n        
\n    
\n    
\n        
\n            \n\n\n
\n    
\n        
\n            
\n                
\n                    
\n\n                        
\n                            
\n                                
\n                                    \"\"\n\n                                    
Contact Us
\n\n                                    
Mobile: \n                                    
\n                                    
Email: 
\n                                
\n                            
\n\n\n                            
\n                                
\n                                    \"\"\n\n                                    
Support Hour
\n                                    
\n                                        Monday - Friday: 09:00 - 17:00\n                                    
\n                                
\n                            
\n\n                            
\n                                
\n\n                                    \"\"\n\n                                    
Address
\n\n                                    
 Al Khuwair, Muscat, Oman
\n\n                                
\n                            
\n\n                        
\n\n                    
\n                
\n            
\n        
\n    
\n    
\n        
\n            
\n                
\n                    
\n                
\n            
\n        
\n    
\n
\n        
\n    
\n    
\n        
\n            
\n\n    
\n        
\n            
\n                
\n                    
\n                        
\n                            
\n                                
\n                                    
\n                                        
\n                                            
\n                                                
Send us Message
\n                                            
\n\n\n                                            
\n\n                                                
\n\n                                            
\n\n                                        
\n                                    
\n                                
\n                            
\n                        
\n                    
\n                
\n            
\n        
\n    
\n\n
\n        
\n    
\n\n
', '2', '/contact-us', 7, '2', 1, 1, NULL, '2026-04-17 03:30:08', 1, 0, NULL),
(11, 1, '{\"en\":\"Careers\",\"bn\":\"ক্যারিয়ার\"}', 'careers', '
\n\n\n\n\n    
\n        
\n            
\n                
\n                    
\n                        
\n                            
\n                                
Careers 
\n                                 
  Home / careers 
\n                            
\n                        
\n                    
\n                
\n            
\n        
\n        
\n        
\n\n            Go Beyond Traditional Careers and Build Your Dreams with Us\n\nAt LMS, we believe in working hard, failing fast and learning every second. We are constantly exploring ways of making our customers life simple and empowered.\n\nWe are a family of youthful and diverse risk-takers and challengers who are solving global problems through transformation and disruption.\n\nWe are what our teacher and students are- the number one in the industry; and the greatest way we reward them is through the opportunity to Go Beyond in developing a nation through education\n\n            
\n        
\n    
', '3', 'careers', 32, '3', 0, 1, NULL, '2026-04-17 03:30:30', 1, 0, NULL),
(12, 1, '{\"en\":\"Blog\",\"bn\":\"ব্লগ\"}', '/blog', '
 
\n     
\n        
\n            
\n                
\n                    
\n                        
\n                            Explore Our Blog Posts\n                        
\n                         
\n                            Home / Blogs\n                        
\n                    
\n                
\n            
\n        
\n    
\n
\n
\n    
\n        
\n            \n        
\n    
\n    
\n        
\n            
\n\n    
\n        
\n            
\n                
\n                    
\n\n                        
\n                            
\n                        
\n                    
\n                
\n\n                
\n\n                    
\n\n                        
\n                            \n                            
\n                                \n                                \n                                
\n\n                                    \n                                
\n                            
\n\n                            
\n                                
\n                                    Blog categories\n                                
\n                                
\n                                
    \n\n\n                                    
    \n                                        
    \n                                    
    \n\n                                
\n                            
\n                            
\n                                
\n                                    Recent Posts\n                                
\n                                
\n                                
\n\n                                    
\n                                        
\n                                    
\n                                
\n                            
\n\n                        
\n                    
\n\n\n                
\n\n            
\n        
\n    
\n\n
\n        
\n    
\n\n
', '3', '/blog', 10, '3', 1, 1, NULL, '2026-04-17 03:45:35', 1, 0, NULL),
(14, 1, '{\"en\":\"Terms\",\"bn\":\"শর্তাবলী\"}', 'terms', '
\n\n\n\n\n    
\n        
\n            
\n                
\n                    
\n                        
\n                            
\n                                
Terms 
\n                                 
  Home / Terms 
\n                            
\n                        
\n                    
\n                
\n            
\n        
\n        
\n        
\n\n            A terminologist intends to hone categorical organization by improving the accuracy and content of its terminology. Technical industries and standardization institutes compile their own glossaries. This provides the consistency needed in the various areas—fields and branches, movements and specialties—to work with core terminology to then offer material for the discipline\'s traditional and doctrinal literature.\n\nTerminology is also then key in boundary-crossing problems, such as in language translation and social epistemology. Terminology helps to build bridges and to extend one area into another. Translators research the terminology of the languages they translate. Terminology is taught alongside translation in universities and translation schools. Large translation departments and translation bureaus have a Terminology section\n\n            
\n        
\n    
', '1', 'terms', 31, '1', 0, 1, NULL, '2026-04-17 03:29:40', 1, 0, NULL),
(15, 1, '{\"en\":\"Certificate Verification\",\"bn\":\"সার্টিফিকেট যাচাই\"}', 'certificate-verification', '
 
\n     
\n        
\n            
\n                
\n                    
\n                        
\n                            Validate Your Achievements\n                        
\n                         
\n                            Home / Certificate Verification\n                        
\n                    
\n                
\n            
\n        
\n    
\n
\n
\n    
\n        
\n            \n        
\n    
\n    
\n        
\n            
\n\n\n\n    \n    
\n        
\n            
\n                \"verify\n                
Certificate Verification
\n                
\n                    \n                    \n                
\n            
\n\n            
\n                \"\"\n                
\n            
\n        
\n    
\n\n\n
\n        
\n    
\n\n
', '2', 'certificate-verification', 33, '2', 1, 1, '2026-04-09 21:34:37', '2026-04-17 03:30:16', 1, 0, NULL),
(16, 1, '{\"en\":\"Free Course\",\"bn\":\"ফ্রি কোর্সসমূহ\"}', 'free-course', '
 
\n     
\n        
\n            
\n                
\n                    
\n                        
\n                            Get free courses\n                        
\n                         
\n                            Home / Free\n                        
\n                    
\n                
\n            
\n        
\n    
\n
\n
\n\n    
\n        
\n            \n        
\n    
\n    
\n        
\n            
\n\n    \n    
\n        
\n            
\n                
\n                    
\n    
\n        \n        
\n    
\n\n    
\n        
\n            
\n                Category\n            
\n\n            
\n                
\n            
\n\n        
\n        
\n            
\n                Level\n            
\n            
\n                
\n            
\n\n\n        
\n        
\n            
\n                Price\n            
\n            
\n                
\n            
\n        
\n        
\n            
\n                Language\n            
\n            
\n                
\n            
\n        
\n\n        
\n            
\n                Instructors\n            
\n            
\n                
\n            
\n        
\n        
\n            
\n                Rating\n            
\n            
\n                
\n            
\n        
\n    
\n\n
\n                
\n                
\n                    
\n                        
\n                    
\n                
\n            
\n        
\n    
\n\n
\n        
\n    
\n
', '3', 'free-course', 34, '3', 1, 1, '2026-04-09 21:34:37', '2026-04-17 03:30:42', 1, 0, NULL),
(17, 1, '{\"en\":\"Unlock Your Potential\"}', 'unlock-your-potential', '', '4', '', 0, '4', 1, 1, '2026-04-09 21:34:56', '2026-04-09 21:34:56', 1, 0, NULL);

-- --------------------------------------------------------

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

CREATE TABLE `frontend_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `section` varchar(191) NOT NULL,
  `title` varchar(191) NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `btn_name` varchar(191) DEFAULT NULL,
  `btn_link` varchar(191) DEFAULT NULL,
  `url` varchar(191) DEFAULT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `frontend_settings` (`id`, `section`, `title`, `description`, `btn_name`, `btn_link`, `url`, `icon`, `status`, `created_at`, `updated_at`, `lms_id`) VALUES
(1, 'banner', 'Learn from the best in the world', 'Learn from industry experts who are passionate about teaching.', 'Browse Course', NULL, NULL, NULL, 1, '2026-04-09 21:34:24', '2026-04-09 21:34:24', 1),
(2, 'cta_part', 'Insights to lead skills to the believer', 'Top instructors from around the world teach millions of students on Infix about peripherals that add functionality to a system.', NULL, NULL, NULL, NULL, 1, '2026-04-09 21:34:24', '2026-04-09 21:34:24', 1),
(3, 'course_detail_left', 'Online courses', 'Explore a variety of fresh topics', NULL, NULL, 'courses', 'fas fa-book-open', 1, '2026-04-09 21:34:24', '2026-04-09 21:34:24', 1),
(4, 'course_detail_mid', 'Teacher directory', 'Learn from industry experts', NULL, NULL, 'pages/1/teacher-directory', 'fas fa-chalkboard-teacher', 1, '2026-04-09 21:34:24', '2026-04-09 21:34:24', 1),
(5, 'course_detail_right', 'Unlimited access', 'Learn on your schedule', NULL, NULL, 'pages/2/features', 'fas fa-universal-access', 1, '2026-04-09 21:34:24', '2026-04-09 21:34:24', 1);

-- --------------------------------------------------------

--
-- Table structure for table `front_pages`
--

CREATE TABLE `front_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `sub_title` longtext DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `slug` varchar(191) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `is_static` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `banner` varchar(191) DEFAULT NULL,
  `lms_id` int(11) NOT NULL DEFAULT 1,
  `homepage` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `front_pages`
--

INSERT INTO `front_pages` (`id`, `name`, `title`, `sub_title`, `details`, `slug`, `status`, `is_static`, `created_at`, `updated_at`, `banner`, `lms_id`, `homepage`) VALUES
(1, 'Teacher directory', '{\"en\":\"Teacher directory\"}', '{\"en\":\"Learn from industry experts\"}', '{\"en\":\"
\\n\\n\\n\\n\\n    
\\n        
\\n            
\\n                
\\n                    
\\n                        
\\n                            
\\n                                
Teacher directory <\\/h3>\\n                                 
  Home \\/ Learn from industry experts <\\/p>\\n                            <\\/div>\\n                        <\\/div>\\n                    <\\/div>\\n                <\\/div>\\n            <\\/div>\\n        <\\/div>\\n        
\\n        
\\n\\n            Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text\\n            ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book\\n\\n            <\\/div><\\/div><\\/div><\\/div>\\n        <\\/div>\\n    <\\/div><\\/div><\\/div><\\/div>\"}', 'teacher-directory', 1, 0, '2026-04-09 21:34:27', '2026-04-09 21:35:00', NULL, 1, 0);
INSERT INTO `front_pages` (`id`, `name`, `title`, `sub_title`, `details`, `slug`, `status`, `is_static`, `created_at`, `updated_at`, `banner`, `lms_id`, `homepage`) VALUES
(2, 'home0', '{\"en\":\"Homepage\"}', '{\"en\":\"\"}', '{\"en\":\"\\n       \\n        \\r\\n          \\r\\n            
\\r\\n              
\\r\\n                
\\r\\n                  
\\r\\n                    
\\r\\n                      
\\r\\n                        \\r\\n                          
\\r\\n                            \\r\\n                            
Contact Us
\\r\\n                            
Mobile: 
01315-515587
\\r\\n                            
Email: samratitinstitutebd@gmail.com
\\r\\n                          
\\r\\n                        
\\r\\n                        \\r\\n                          
\\r\\n                            \\r\\n                            
Support Hour
\\r\\n                            
24/7
\\r\\n                          
\\r\\n                        
\\r\\n                        \\r\\n                          
\\r\\n                            \\r\\n                            
Address
\\r\\n                            
Gozaria Bazar, Sain Board Road, Faridpur Sadar, Faridpur
\\r\\n                          
\\r\\n                        
\\r\\n                      
\\r\\n                    
\\r\\n                  
\\r\\n                
\\r\\n              
\\r\\n            
\\r\\n            
\\r\\n              
\\r\\n                
\\r\\n                  
\\r\\n                
\\r\\n              
\\r\\n            
\\r\\n          
\\r\\n        
\\r\\n      
\\r\\n      
\\r\\n        
\\r\\n          \\r\\n            
\\r\\n              
\\r\\n                
\\r\\n                  
\\r\\n                    
\\r\\n                      
\\r\\n                        
\\r\\n                          
\\r\\n                            
\\r\\n                              
\\r\\n                                
\\r\\n                                  
\\r\\n                                    Send us Message\\r\\n                                  
\\r\\n                                
\\r\\n                                \\r\\n                                  
\\r\\n                                
\\r\\n                              
\\r\\n                            
\\r\\n                          
\\r\\n                        
\\r\\n                      
\\r\\n                    
\\r\\n                  
\\r\\n                
\\r\\n              
\\r\\n            
\\r\\n          
\\r\\n        
\\r\\n      
\\r\\n    
\\r\\n  
\\r\\n
\",\n    \"bn\":\"
\\r\\n  
\\r\\n    
\\r\\n      
\\r\\n        \\r\\n          
\\r\\n            
\\r\\n              
\\r\\n                
\\r\\n                  
আমরা আপনার প্রতিটি পদক্ষেপে আপনার পাশে আছি।
\\r\\n                  
Home / Contact Us
\\r\\n                
\\r\\n              
\\r\\n            
\\r\\n          
\\r\\n        
\\r\\n      
\\r\\n    
\\r\\n    \\r\\n      
\\r\\n        
\\r\\n      
\\r\\n      
\\r\\n        
\\r\\n          \\r\\n          \\r\\n            
\\r\\n              
\\r\\n                
\\r\\n                  
\\r\\n                    
\\r\\n                      
\\r\\n                        \\r\\n                          
\\r\\n                            \\r\\n                            
যোগাযোগ করুন
\\r\\n                            
মোবাইল: 
০১৩১৫-৫১৫৫৮৭
\\r\\n                            
ইমেইল: samratitinstitutebd@gmail.com
\\r\\n                          
\\r\\n                        
\\r\\n                        \\r\\n                          
\\r\\n                            \\r\\n                            
সাপোর্ট ঘন্টা
\\r\\n                            
২৪/৭
\\r\\n                          
\\r\\n                        
\\r\\n                        \\r\\n                          
\\r\\n                            \\r\\n                            
ঠিকানা
\\r\\n                            
গজারিয়া বাজার, সাইন বোর্ড রোড, ফরিদপুর সদর, ফরিদপুর।
\\r\\n                          
\\r\\n                        
\\r\\n                      
\\r\\n                    
\\r\\n                  
\\r\\n                
\\r\\n              
\\r\\n            
\\r\\n            
\\r\\n              
\\r\\n                
\\r\\n                  
\\r\\n                
\\r\\n              
\\r\\n            
\\r\\n          
\\r\\n        
\\r\\n      
\\r\\n      
\\r\\n        
\\r\\n          \\r\\n            
\\r\\n              
\\r\\n                
\\r\\n                  
\\r\\n                    
\\r\\n                      
\\r\\n                        
\\r\\n                          
\\r\\n                            
\\r\\n                              
\\r\\n                                
\\r\\n                                  
\\r\\n                                    আমাদেরকে একটি বার্তা পাঠান\\r\\n                                  
\\r\\n                                
\\r\\n                                \\r\\n                                  
\\r\\n                                
\\r\\n                              
\\r\\n                            
\\r\\n                          
\\r\\n                        
\\r\\n                      
\\r\\n                    
\\r\\n                  
\\r\\n                
\\r\\n              
\\r\\n            
\\r\\n          
\\r\\n        
\\r\\n      
\\r\\n    
\\r\\n  
\\r\\n
\"\n}\n', '/contact-us', 1, 1, '2026-04-09 21:34:29', '2026-04-09 21:34:58', NULL, 1, 0);
INSERT INTO `front_pages` (`id`, `name`, `title`, `sub_title`, `details`, `slug`, `status`, `is_static`, `created_at`, `updated_at`, `banner`, `lms_id`, `homepage`) VALUES
(8, 'About Us', 'About Us', 'About Us', '{\n    \"en\":\"
 
\\n     
\\n        
\\n            
\\n                
\\n                    
\\n                        
\\n                            Learn More About Us\\n                        <\\/h3>\\n                         
\\n                            Home \\/ About US\\n                        <\\/p>\\n                    <\\/div>\\n                <\\/div>\\n            <\\/div>\\n        <\\/div>\\n    <\\/div>\\n<\\/div>\\n<\\/div>
\\n\\n    
\\n        
\\n            \\n        <\\/div>\\n    <\\/div>\\n    
\\n        
\\n            
\\n    
\\n        
\\n            
\\n                
\\n                    
\\n                        
\\n                            
\\n                                Who We Are<\\/span>\\n                                
We are a modern e-learning platform dedicated to empowering learners through practical, skill-based education. Our mission is to make high-quality education accessible to everyone, anywhere in the world. We focus on industry-relevant learning that helps students build real career value.<\\/p>\\n                            <\\/div>\\n                            
\\n                                
Our platform is designed to meet the evolving demands of today’s job market. We provide structured learning paths, expert-led courses, and hands-on training to help learners achieve personal and professional growth efficiently.<\\/p>\\n                            <\\/div>\\n                        <\\/div>\\n                    <\\/div>\\n                <\\/div>\\n            <\\/div>\\n        <\\/div>\\n    <\\/div>\\n<\\/div>\\n        <\\/div>\\n    <\\/div>\\n    
\\n        
\\n            
\\n    
\\n        
\\n            
\\n                
\\n                    
\\n                        
\\n                            
\\n                                \\\"\\\"\\n                            <\\/div>\\n                            
\\n                                \\\"\\\"\\n                            <\\/div>\\n                        <\\/div>\\n                        
\\n                            
\\n                                \\\"\\\"\\n                            <\\/div>\\n                        <\\/div>\\n                    <\\/div>\\n                <\\/div>\\n                
\\n                    
\\n                        
Build your own knowledge library for career success and lifelong personal growth.<\\/h3>\\n                        
Our mission is to prepare the next generation of skilled professionals by offering high-quality, industry-focused courses. We aim to bridge the gap between education and real-world requirements. Whether you are starting your journey or upgrading your skills, our platform provides flexible and practical learning experiences designed to support your growth at every stage.<\\/p>\\n                    <\\/div>\\n                <\\/div>\\n            <\\/div>\\n        <\\/div>\\n    <\\/div>\\n<\\/div>\\n        <\\/div>\\n    <\\/div>\\n    
\\n        
\\n            
\\n