-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Dec 01, 2025 at 07:43 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `ictslides` -- -- -------------------------------------------------------- -- -- Table structure for table `assessment_questions` -- CREATE TABLE `assessment_questions` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `assessment_uuid` varchar(110) DEFAULT NULL, `question` text NOT NULL, `question_type` enum('multiple','open') DEFAULT 'multiple', `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`options`)), `correct_answer` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `assessment_questions` -- INSERT INTO `assessment_questions` (`id`, `uuid`, `assessment_uuid`, `question`, `question_type`, `options`, `correct_answer`, `created_at`) VALUES (6, '59f67eba-50a6-47e4-a11b-326616289641', '36cb69dd-3a58-472a-b173-5c5fc66e9ebf', 'what is Man of God for short', 'multiple', '[\"Mof\",\"Mbd\",\"MOG\",\"Mov\"]', 'C', '2025-11-28 14:52:49'), (7, '5a606727-5d6d-4701-a949-7f6688972fa2', 'acd8da14-fa99-4013-8e47-5f780a6b14e7', 'how old are you?', 'open', NULL, NULL, '2025-11-30 15:22:06'), (8, 'e68b7716-3262-4bb9-aee0-377fcad2c515', 'f62aba08-1a75-4c9c-86b4-de3948a806c6', 'Your dad age today', 'multiple', '[\"10\",\"50\",\"38\",\"29\"]', 'B', '2025-11-30 15:22:51'); -- -------------------------------------------------------- -- -- Table structure for table `assessment_quiz_results` -- CREATE TABLE `assessment_quiz_results` ( `id` int(10) NOT NULL, `uuid` varchar(110) DEFAULT NULL, `user_uuid` varchar(10) DEFAULT NULL, `quiz_uuid` varchar(100) DEFAULT NULL, `score` int(11) NOT NULL DEFAULT 0, `taken_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `badges` -- CREATE TABLE `badges` ( `id` int(11) NOT NULL, `uuid` varchar(110) DEFAULT NULL, `slug` varchar(150) NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `icon` varchar(512) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `is_active` tinyint(1) DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `badges` -- INSERT INTO `badges` (`id`, `uuid`, `slug`, `title`, `description`, `icon`, `created_at`, `updated_at`, `is_active`) VALUES (1, '21b0c1c4-a894-44f5-a706-0fb4e6e4a625', 'first-course', 'First Course Completed', 'Complete your first course', '🏅', '2025-11-14 17:05:41', '2025-11-30 07:36:57', 1), (2, '21b0c1c4-a894-44f5-a706-0fb4e6e4a628', 'course-complete-100', 'Course Master', 'Finish a course 100%', '🎓', '2025-11-14 17:05:41', '2025-11-30 07:37:02', 1), (3, '21b0c1c4-a894-44f5-a706-0fb4e6e4a62j', 'seven-day-streak', '7 Day Streak', 'Login and study 7 days in a row', '🔥', '2025-11-14 17:05:41', '2025-11-30 07:37:10', 1); -- -------------------------------------------------------- -- -- Table structure for table `badge_enrollments` -- CREATE TABLE `badge_enrollments` ( `id` int(10) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `user_uuid` varchar(100) DEFAULT NULL, `course_uuid` varchar(60) DEFAULT NULL, `progress_percent` int(11) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `badge_enrollments` -- INSERT INTO `badge_enrollments` (`id`, `uuid`, `user_uuid`, `course_uuid`, `progress_percent`, `created_at`, `updated_at`) VALUES (6, '445af3f0-410a-49d0-bd18-1e1a27252d33', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 0, '2025-11-29 09:48:57', '2025-11-29 09:48:57'), (7, '26156a12-1175-4553-bd64-9e06a69d6880', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 0, '2025-12-01 16:01:24', '2025-12-01 16:01:24'), (8, 'f2d17b5f-673b-4c56-b776-84de90ebf9c5', '5c4b53e5-de2f-4088-89e5-c03777f331b6', 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 0, '2025-12-01 17:01:34', '2025-12-01 17:01:34'); -- -------------------------------------------------------- -- -- Table structure for table `badge_requirements` -- CREATE TABLE `badge_requirements` ( `id` int(10) UNSIGNED NOT NULL, `uuid` varchar(110) DEFAULT NULL, `badge_uuid` varchar(110) DEFAULT NULL, `type` enum('course_progress','streak','quiz_passed') NOT NULL, `target_value` int(11) NOT NULL DEFAULT 100, `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Optional metadata like course_id, quiz_id etc.' CHECK (json_valid(`meta`)), `description` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `badge_requirements` -- INSERT INTO `badge_requirements` (`id`, `uuid`, `badge_uuid`, `type`, `target_value`, `meta`, `description`, `created_at`, `updated_at`) VALUES (16, '21b0c1c4-a894-44f5-a706-0fb4e6e4a62y', NULL, 'course_progress', 100, '{\"course_id\": 16}', 'Complete your first course 100%', '2025-11-14 19:46:07', '2025-11-30 07:37:33'), (17, '21b0c1c4-a894-44f5-a706-0fb4e6e4a62m', NULL, 'streak', 7, '{\"assessment_id\": 25}', 'Login and study 7 days in a row', '2025-11-14 19:46:07', '2025-11-30 07:37:41'); -- -------------------------------------------------------- -- -- Table structure for table `badge_user_points` -- CREATE TABLE `badge_user_points` ( `id` int(10) UNSIGNED NOT NULL, `uuid` varchar(110) DEFAULT NULL, `user_uuid` varchar(100) DEFAULT NULL, `points` int(11) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `banks` -- CREATE TABLE `banks` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `user_uuid` varchar(110) DEFAULT NULL, `name` varchar(100) NOT NULL, `account` varchar(50) NOT NULL, `holder` varchar(100) NOT NULL, `swift` varchar(100) DEFAULT NULL, `sort_code` varchar(100) DEFAULT NULL, `iban` varchar(100) DEFAULT NULL, `routing_number` varchar(100) DEFAULT NULL, `country` varchar(100) DEFAULT NULL, `country_code` varchar(100) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `banks` -- INSERT INTO `banks` (`id`, `uuid`, `user_uuid`, `name`, `account`, `holder`, `swift`, `sort_code`, `iban`, `routing_number`, `country`, `country_code`, `created_at`) VALUES (8, '21b0c1c4-a894-44f5-a706-0fb4e6e4a621', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Access Bank', '0802833956', 'Nweke Emmanuel Somtochi', '', '', '', '', 'Nigeria', 'NG', '2025-11-28 20:52:30'); -- -------------------------------------------------------- -- -- Table structure for table `certificates` -- CREATE TABLE `certificates` ( `id` int(11) NOT NULL, `uuid` varchar(110) DEFAULT NULL, `student_uuid` varchar(110) DEFAULT NULL, `course_uuid` varchar(110) DEFAULT NULL, `certificate_code` varchar(50) NOT NULL, `certificate_url` varchar(255) DEFAULT NULL, `issued_by` varchar(100) DEFAULT 'ICTSlides Academy', `chairman` varchar(100) DEFAULT 'Course Director', `issued_date` datetime DEFAULT current_timestamp(), `status` enum('issued','revoked') DEFAULT 'issued' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `certificates` -- INSERT INTO `certificates` (`id`, `uuid`, `student_uuid`, `course_uuid`, `certificate_code`, `certificate_url`, `issued_by`, `chairman`, `issued_date`, `status`) VALUES (4, '8d12d8ac-7387-4e11-ac30-a9dd6c1ff172', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 'CD-680-735-ICTS', 'certificate/CD-680-735-ICTS', 'Henry Ofoleta', 'Ezeribe George C', '2025-11-30 00:29:21', 'issued'), (5, '0744df34-8ebf-445a-8cff-fb5125ab2cf2', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 'CD-227-615-ICTS', 'certificate/CD-227-615-ICTS', 'Henry Ofoleta', 'Ezeribe George C', '2025-12-01 13:50:20', 'issued'); -- -------------------------------------------------------- -- -- Table structure for table `chat_messages` -- CREATE TABLE `chat_messages` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `sender_uuid` varchar(110) DEFAULT NULL, `receiver_uuid` varchar(110) DEFAULT NULL, `message` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `chat_messages` -- INSERT INTO `chat_messages` (`id`, `uuid`, `sender_uuid`, `receiver_uuid`, `message`, `created_at`) VALUES (15, 'f38187bb-c393-4aea-b02d-7e151d3abf84', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'hello', '2025-11-29 17:03:21'), (16, '15e60a17-4eec-4f06-ac6c-12eba7b8e8ce', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'how are you doing', '2025-12-01 17:15:11'), (17, 'b4dbaf77-afc3-4094-8f76-040dbd7fd886', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'am doing great', '2025-12-01 17:16:37'), (18, '82cbcfd4-5444-4102-9ccf-1195f9a3db4c', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'hi', '2025-12-01 17:28:31'), (19, 'ce1de424-f87b-4fbe-9bd2-c2d4fb1dab78', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Hello sir', '2025-12-01 18:30:29'), (20, 'ec1b4607-7315-451e-9105-9e3ab89ba32e', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'how are you doing', '2025-12-01 18:31:17'), (21, 'cf8c2a95-13ee-452e-aebb-94fbb206efff', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'am doing good!! thanks', '2025-12-01 18:31:47'); -- -------------------------------------------------------- -- -- Table structure for table `contact` -- CREATE TABLE `contact` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `user_id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `subject` varchar(100) NOT NULL, `message` text NOT NULL, `status` enum('failed','pending','verified') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `contact` -- INSERT INTO `contact` (`id`, `uuid`, `user_id`, `name`, `email`, `subject`, `message`, `status`, `created_at`) VALUES (0, '8d6b464b-6974-40b6-a5b0-e8ea6931e873', 40, 'Manuel', 'emmanuelbigboss@gmail.com', 'test', 'just testing the contact form', 'pending', '2025-11-27 22:25:55'); -- -------------------------------------------------------- -- -- Table structure for table `courses` -- CREATE TABLE `courses` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `tutor_uuid` varchar(100) DEFAULT NULL, `tutor_user_uuid` varchar(110) DEFAULT NULL, `template_uuid` varchar(110) DEFAULT NULL, `category_uuid` varchar(110) DEFAULT NULL, `created_by_role` enum('tutor','admin') NOT NULL DEFAULT 'tutor', `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `imageUrl` varchar(100) NOT NULL, `slug` varchar(200) NOT NULL, `price` decimal(10,2) DEFAULT 0.00, `duration` varchar(100) NOT NULL DEFAULT '0', `curriculum` longtext DEFAULT NULL, `is_free` tinyint(11) NOT NULL DEFAULT 0, `course_type` enum('paid','free','subscription','limited') NOT NULL DEFAULT 'paid', `availability` tinyint(100) DEFAULT 0, `status` enum('inactive','draft','pending','approved','active') NOT NULL DEFAULT 'inactive', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `courses` -- INSERT INTO `courses` (`id`, `uuid`, `tutor_uuid`, `tutor_user_uuid`, `template_uuid`, `category_uuid`, `created_by_role`, `title`, `description`, `imageUrl`, `slug`, `price`, `duration`, `curriculum`, `is_free`, `course_type`, `availability`, `status`, `created_at`, `updated_at`) VALUES (27, 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', NULL, NULL, '5902e42b-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd5s', 'admin', 'UI/UX Design Masterclass', 'Design beautiful mobile and web interfaces', 'uploads/course/ict5.jpg', 'ui-ux-design-masterclass-839291', 0.00, '6', NULL, 1, 'free', 1, 'active', '2025-11-28 00:25:31', '2025-11-29 13:39:06'), (28, 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '7cb369ac-624b-4992-a476-f4159fa05755', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '5902e42b-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ffwa2da2c1fd4g', 'tutor', 'UI/UX Design Masterclass', 'Design beautiful mobile and web interfaces', 'uploads/course/ict2.jpg', 'ui-ux-design-masterclass-25c8bc', 180.00, '3', NULL, 0, 'paid', 1, 'active', '2025-11-28 00:28:37', '2025-11-30 15:23:49'), (29, '0824690f-ee02-4399-85b4-4d9e7cc841b7', 'be92e183-2837-410b-86f7-c68ab282c283', 'ceb692f7-055d-473e-bb16-b4917cb9427e', '5902e824-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd5s', 'tutor', 'Digital Marketing Pro', 'SEO, SEM, social media ads and brand strategy', 'uploads/course/ict4.jpg', 'digital-marketing-pro-92d62d', 150.00, '4', NULL, 0, 'paid', 0, 'draft', '2025-12-01 17:04:46', '2025-12-01 17:04:46'); -- -------------------------------------------------------- -- -- Table structure for table `course_activity_logs` -- CREATE TABLE `course_activity_logs` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `user_uuid` varchar(110) DEFAULT NULL, `course_uuid` varchar(110) DEFAULT NULL, `module_uuid` varchar(110) DEFAULT NULL, `video_uuid` varchar(110) DEFAULT NULL, `activity_type` varchar(200) NOT NULL DEFAULT 'upload', `details` text DEFAULT NULL, `progress` decimal(5,2) DEFAULT NULL, `ip_address` varchar(50) DEFAULT NULL, `device` varchar(200) DEFAULT NULL, `location` varchar(200) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_activity_logs` -- INSERT INTO `course_activity_logs` (`id`, `uuid`, `user_uuid`, `course_uuid`, `module_uuid`, `video_uuid`, `activity_type`, `details`, `progress`, `ip_address`, `device`, `location`, `created_at`) VALUES (16, '371a23a6-e371-4775-aa4e-ac9943c5b552', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', NULL, 'video_uploaded', 'Uploaded video uploaded: test 1', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-11-28 13:31:32'), (17, 'b675ba1c-5efd-4c63-938a-cac21753e94e', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 'd3a219cb-c59b-4235-8d86-8bc84c77a648', NULL, 'video_uploaded', 'Uploaded video uploaded: test 2', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-11-28 13:32:51'), (18, 'a4a661de-3769-45a8-be6d-5ded66d07dfc', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', NULL, 'podcast_uploaded', 'Uploaded podcast uploaded: podcast to 1', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-11-28 14:21:27'), (19, '0a95f13f-4eae-4f5e-a960-42f5627a7d4d', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', NULL, 'pdf_uploaded', 'Uploaded pdf uploaded: PDFs test to upload', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-11-28 14:30:24'), (20, '381d3601-a65a-4c83-b8e0-b19bae83b4f0', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', NULL, 'note_uploaded', 'Uploaded note uploaded: test for note to see', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-11-28 14:42:48'), (21, '9ab809d3-4872-4fd6-bab7-b6df8e75099d', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', NULL, 'assessment_uploaded', 'Uploaded assessment uploaded: Module 46988c08-77d8-4e18-89c1-ce34950aedd9', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-11-28 14:52:49'), (22, 'c4b23662-f3d3-40ec-a68c-aa0749f2d26e', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', NULL, 'assessment_uploaded', 'Uploaded assessment uploaded: Module 46988c08-77d8-4e18-89c1-ce34950aedd9', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-11-30 15:22:06'), (23, '90e3bb4b-4f1c-4a4d-919b-c6d49509e62b', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 'd3a219cb-c59b-4235-8d86-8bc84c77a648', NULL, 'assessment_uploaded', 'Uploaded assessment uploaded: Module d3a219cb-c59b-4235-8d86-8bc84c77a648', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-11-30 15:22:51'), (24, '8919ce99-426a-4cc5-b1a2-f3110bda689a', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', NULL, 'video_uploaded', 'Uploaded video uploaded: another test for module 1', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-11-30 21:23:17'), (26, 'b7b8481b-b053-4c99-aa4a-e48ef10a9a33', 'ceb692f7-055d-473e-bb16-b4917cb9427e', '0824690f-ee02-4399-85b4-4d9e7cc841b7', 'e4680ef9-d55c-43eb-9069-bbe8ca18834d', NULL, 'note_uploaded', 'Uploaded note uploaded: defwcdwa', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', '2025-12-01 17:05:41'); -- -------------------------------------------------------- -- -- Table structure for table `course_assessments` -- CREATE TABLE `course_assessments` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `module_uuid` varchar(110) DEFAULT NULL, `title` varchar(255) NOT NULL, `status` enum('pending','failed','approved') NOT NULL DEFAULT 'pending', `created_by` varchar(110) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_assessments` -- INSERT INTO `course_assessments` (`id`, `uuid`, `module_uuid`, `title`, `status`, `created_by`, `created_at`) VALUES (15, '36cb69dd-3a58-472a-b173-5c5fc66e9ebf', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'Assessment for module 46988c08-77d8-4e18-89c1-ce34950aedd9', 'pending', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '2025-11-28 14:52:49'), (16, 'acd8da14-fa99-4013-8e47-5f780a6b14e7', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'Assessment for module 46988c08-77d8-4e18-89c1-ce34950aedd9', 'pending', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '2025-11-30 15:22:06'), (17, 'f62aba08-1a75-4c9c-86b4-de3948a806c6', 'd3a219cb-c59b-4235-8d86-8bc84c77a648', 'Assessment for module d3a219cb-c59b-4235-8d86-8bc84c77a648', 'pending', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '2025-11-30 15:22:51'); -- -------------------------------------------------------- -- -- Table structure for table `course_categories` -- CREATE TABLE `course_categories` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_categories` -- INSERT INTO `course_categories` (`id`, `uuid`, `name`, `description`, `created_at`, `updated_at`) VALUES (1, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd5s', 'Web development', 'Course for web development', '2025-11-22 20:53:24', '2025-11-26 07:23:31'), (2, '5e2f9b8d-67ea-4f72-a70e-ffwa2da2c1fd4g', 'Data Science', 'Course for data science', '2025-11-22 20:53:24', '2025-11-26 07:23:39'), (3, '5e2f9b8d-67ea-4f72-a70e-ff322da2c1fd4g', 'Mobile Application', 'Course to build mobile application', '2025-11-22 20:54:35', '2025-11-26 07:23:47'), (4, '5e2f9b8d-67ea-4f72-a70e-ff2d82c1fd4g', 'Cyber Security', 'Course to take to become a cyber security', '2025-11-22 20:54:35', '2025-11-26 07:23:58'); -- -------------------------------------------------------- -- -- Table structure for table `course_comments` -- CREATE TABLE `course_comments` ( `id` int(11) NOT NULL, `uuid` varchar(40) DEFAULT NULL, `course_uuid` varchar(60) DEFAULT NULL, `student_uuid` varchar(60) DEFAULT NULL, `rating` decimal(2,1) DEFAULT NULL, `country` varchar(255) DEFAULT 'UN', `country_flag_url` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comment` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_comments` -- INSERT INTO `course_comments` (`id`, `uuid`, `course_uuid`, `student_uuid`, `rating`, `country`, `country_flag_url`, `comment`, `created_at`) VALUES (10, '5350f7a2-91a9-47ad-a241-e29d10e310fb', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 2.0, 'US', 'https://flagsapi.com/US/flat/64.png', 'i love this course', '2025-11-29 13:18:39'), (11, '14d4d097-27cb-422d-855a-d0c2f9309f7b', 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 4.0, 'UN', 'https://flagsapi.com/NG/flat/64.png', 'i love this beginner course', '2025-11-29 16:49:57'); -- -------------------------------------------------------- -- -- Table structure for table `course_comments_replies` -- CREATE TABLE `course_comments_replies` ( `id` int(11) NOT NULL, `uuid` char(36) NOT NULL, `comment_uuid` char(36) NOT NULL, `tutor_uuid` varchar(60) DEFAULT NULL, `replied_by` varchar(255) NOT NULL, `reply` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_comments_replies` -- INSERT INTO `course_comments_replies` (`id`, `uuid`, `comment_uuid`, `tutor_uuid`, `replied_by`, `reply`, `created_at`) VALUES (2, '886afe0d-c2ec-4038-9675-74251e2e882f', '5350f7a2-91a9-47ad-a241-e29d10e310fb', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'tutor', 'thanks for loving it', '2025-12-01 17:09:20'), (3, '8f71a4ff-147d-4d83-a392-0a141a358b96', '5350f7a2-91a9-47ad-a241-e29d10e310fb', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'tutor', 'i will drop new one soon', '2025-12-01 17:09:47'); -- -------------------------------------------------------- -- -- Table structure for table `course_modules` -- CREATE TABLE `course_modules` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `course_uuid` varchar(60) DEFAULT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_modules` -- INSERT INTO `course_modules` (`id`, `uuid`, `course_uuid`, `title`, `description`, `created_at`) VALUES (9, '46988c08-77d8-4e18-89c1-ce34950aedd9', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 'UI/UX master class first material', 'this course will help and teach anyone who is ready to learn UI/UX, this will take you from beginner to advanced so get ready to be a master in UI/UX.', '2025-11-28 00:40:32'), (10, 'd3a219cb-c59b-4235-8d86-8bc84c77a648', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 'Become a UI/UX master second material', 'this will elevate your UI/UX skill from beginner to advanced', '2025-11-28 00:46:09'), (11, '1087dd2d-ce39-11f0-afab-107d1a1291f6', 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 'Free Course first module', 'this for testing purpose only', '2025-11-30 22:08:13'), (12, 'e4680ef9-d55c-43eb-9069-bbe8ca18834d', '0824690f-ee02-4399-85b4-4d9e7cc841b7', 'tutor test', 'jndkndv', '2025-12-01 17:05:28'); -- -------------------------------------------------------- -- -- Table structure for table `course_notes` -- CREATE TABLE `course_notes` ( `id` int(11) NOT NULL, `uuid` varchar(110) DEFAULT NULL, `module_uuid` varchar(110) DEFAULT NULL, `title` varchar(255) NOT NULL, `note_text` text NOT NULL, `status` enum('pending','failed','approved') NOT NULL DEFAULT 'pending', `uploaded_by` varchar(110) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_notes` -- INSERT INTO `course_notes` (`id`, `uuid`, `module_uuid`, `title`, `note_text`, `status`, `uploaded_by`, `created_at`) VALUES (14, '56ce17ad-5f8f-48f4-abee-54dd84850eb8', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'test for note to see', 'i hope this work for this course', 'pending', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '2025-11-28 14:42:48'), (15, 'acab2786-3ef0-49e3-b129-08abee0ed8ce', 'e4680ef9-d55c-43eb-9069-bbe8ca18834d', 'defwcdwa', 'ewWfedw', 'pending', 'ceb692f7-055d-473e-bb16-b4917cb9427e', '2025-12-01 17:05:40'); -- -------------------------------------------------------- -- -- Table structure for table `course_pdfs` -- CREATE TABLE `course_pdfs` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `module_uuid` varchar(110) DEFAULT NULL, `title` varchar(255) NOT NULL, `file_path` varchar(255) NOT NULL, `status` enum('pending','failed','approved') NOT NULL DEFAULT 'pending', `uploaded_by` varchar(110) DEFAULT NULL, `created_at` datetime DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_pdfs` -- INSERT INTO `course_pdfs` (`id`, `uuid`, `module_uuid`, `title`, `file_path`, `status`, `uploaded_by`, `created_at`) VALUES (12, '2eb3035e-d6ef-4d37-b7ab-855c8e5240ed', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'PDFs test to upload', 'uploads/pdfs/pdf_6929b200240443.09293254_sample-pdf.pdf', 'pending', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '2025-11-28 15:30:24'); -- -------------------------------------------------------- -- -- Table structure for table `course_podcasts` -- CREATE TABLE `course_podcasts` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `module_uuid` varchar(110) DEFAULT NULL, `title` varchar(255) NOT NULL, `file_path` varchar(255) NOT NULL, `description` text DEFAULT NULL, `status` enum('pending','failed','approved') NOT NULL DEFAULT 'pending', `uploaded_by` int(50) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_podcasts` -- INSERT INTO `course_podcasts` (`id`, `uuid`, `module_uuid`, `title`, `file_path`, `description`, `status`, `uploaded_by`, `created_at`, `updated_at`) VALUES (11, 'c1d27dfa-aa4b-4045-99d9-90a95076e6b2', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'podcast to 1', 'uploads/podcasts/podcast_6929afe6648378.99315583_you are the reason i live.mp3', NULL, 'pending', 0, '2025-11-28 14:21:26', '2025-11-28 14:21:26'); -- -------------------------------------------------------- -- -- Table structure for table `course_progress` -- CREATE TABLE `course_progress` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `tutor_user_uuid` varchar(60) DEFAULT NULL, `student_uuid` varchar(36) DEFAULT NULL, `course_uuid` varchar(36) DEFAULT NULL, `progress_percentage` int(100) NOT NULL DEFAULT 0, `completion_status` enum('not_started','in_progress','completed') DEFAULT 'not_started', `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_progress` -- INSERT INTO `course_progress` (`id`, `uuid`, `tutor_user_uuid`, `student_uuid`, `course_uuid`, `progress_percentage`, `completion_status`, `updated_at`) VALUES (19, '481e44f0-d720-48c3-a737-3fa43d14df74', NULL, 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 100, 'completed', '2025-12-01 12:50:20'), (48, 'b4a24d1a-ed29-4fe5-9131-12af81580168', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 33, 'in_progress', '2025-12-01 16:54:05'); -- -------------------------------------------------------- -- -- Table structure for table `course_progress_tracking` -- CREATE TABLE `course_progress_tracking` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `student_uuid` varchar(110) DEFAULT NULL, `course_uuid` varchar(110) DEFAULT NULL, `module_uuid` varchar(110) DEFAULT NULL, `item_type` enum('video','podcast','pdf','note') NOT NULL, `item_id` varchar(110) DEFAULT NULL, `status` tinyint(1) DEFAULT 0, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_progress_tracking` -- INSERT INTO `course_progress_tracking` (`id`, `uuid`, `student_uuid`, `course_uuid`, `module_uuid`, `item_type`, `item_id`, `status`, `updated_at`) VALUES (65, '69cc98ef-0441-4c4e-a044-439bf4565460', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'video', '19bc04ae-01df-469d-a8c0-ca0c910d2aa5', 1, '2025-11-29 23:26:50'), (66, '00e3247f-c85e-494d-9bac-21a7df819c58', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 'd3a219cb-c59b-4235-8d86-8bc84c77a648', 'video', '174ac8c7-ece0-48f6-89f7-a899be0b5fee', 1, '2025-11-29 23:29:20'), (67, '1f4e4d2d-e213-4b1c-bdb3-059e7fde4bea', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'podcast', 'c1d27dfa-aa4b-4045-99d9-90a95076e6b2', 1, '2025-11-29 23:31:01'), (68, 'e8d7a6d8-7c51-4700-ab93-8617557139d6', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'note', '56ce17ad-5f8f-48f4-abee-54dd84850eb8', 1, '2025-11-29 23:31:09'), (69, '73b69e4d-8f91-4554-8051-17d8fc2be7a1', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'pdf', '2eb3035e-d6ef-4d37-b7ab-855c8e5240ed', 1, '2025-11-29 23:31:23'), (72, 'ea5038f9-453d-4db6-b50a-d1cd971fb8c6', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', '1087dd2d-ce39-11f0-afab-107d1a1291f6', 'video', '689d239e-ce39-11f0-afab-107d1a1291f6', 1, '2025-12-01 12:50:20'), (75, '646e061f-5619-41bf-af27-2cb515762806', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'video', '19bc04ae-01df-469d-a8c0-ca0c910d2aa5', 1, '2025-12-01 16:54:05'); -- -------------------------------------------------------- -- -- Table structure for table `course_templates` -- CREATE TABLE `course_templates` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `category_uuid` varchar(110) DEFAULT NULL, `skill_uuid` varchar(50) DEFAULT NULL, `name` varchar(150) NOT NULL, `description` text DEFAULT NULL, `image_url` varchar(255) DEFAULT NULL, `price` decimal(10,2) DEFAULT 0.00, `duration` varchar(100) NOT NULL DEFAULT '0', `status` enum('active','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_templates` -- INSERT INTO `course_templates` (`id`, `uuid`, `category_uuid`, `skill_uuid`, `name`, `description`, `image_url`, `price`, `duration`, `status`, `created_at`, `updated_at`) VALUES (4, '58fb58c4-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff2d82c1fd4g', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd47', 'Full Stack Web Development', 'Learn HTML, CSS, JavaScript, React & PHP', 'uploads/course/ict1.jpg', 250.00, '6', 'active', '2025-11-27 14:35:40', '2025-11-27 14:38:27'), (5, '5902e42b-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd5s', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4o', 'UI/UX Design Masterclass', 'Design beautiful mobile and web interfaces', 'uploads/course/ict2.jpg', 180.00, '3', 'active', '2025-11-27 14:35:40', '2025-11-27 14:38:33'), (6, '5902e6f3-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ffwa2da2c1fd4g', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4gss', 'Cyber Security & Ethical Hacking', 'Protect systems & learn penetration testing', 'uploads/course/ict3.jpg', 300.00, '5', 'active', '2025-11-27 14:35:40', '2025-11-27 14:38:38'), (7, '5902e824-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd5s', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4g11', 'Digital Marketing Pro', 'SEO, SEM, social media ads and brand strategy', 'uploads/course/ict4.jpg', 150.00, '4', 'active', '2025-11-27 14:35:40', '2025-11-27 14:38:42'), (8, '5902e8a0-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff322da2c1fd4g', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4g11', 'Mobile App Development With Flutter', 'Build cross-platform apps for Android & iOS', 'uploads/course/ict5.jpg', 220.00, '5', 'active', '2025-11-27 14:35:40', '2025-11-27 14:38:47'), (9, '5902e9a2-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff322da2c1fd4g', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4g11', 'Data Science & Machine Learning', 'Python, Pandas, ML models & real projects', 'uploads/course/ict1.jpg', 350.00, '6', 'active', '2025-11-27 14:35:40', '2025-11-27 14:38:53'), (10, '5902ea87-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd5s', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4dk', 'Project Management & Agile Scrum', 'Team leadership, planning & Agile methodology', 'uploads/course/ict3.jpg', 120.00, '2', 'active', '2025-11-27 14:35:40', '2025-11-27 14:38:57'), (11, '5902eaf8-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ffwa2da2c1fd4g', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4dk', 'Graphics Design With Adobe Suite', 'Photoshop, Illustrator, CorelDraw workflows', 'uploads/course/ict5.jpg', 140.00, '3', 'active', '2025-11-27 14:35:40', '2025-11-27 14:39:03'), (12, '5902ebaa-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd5s', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4gjs', 'Cloud Computing With AWS', 'Learn cloud concepts & deploy real systems', 'uploads/course/ict2.jpg', 280.00, '4', 'active', '2025-11-27 14:35:40', '2025-11-27 14:39:08'), (13, '5902ec5b-cb9e-11f0-a575-107d1a1291f6', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd5s', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4o', 'Entrepreneurship & Business Strategy', 'Start a business, branding, and sales process', 'uploads/course/ict4.jpg', 100.00, '2', 'active', '2025-11-27 14:35:40', '2025-11-27 14:39:12'); -- -------------------------------------------------------- -- -- Table structure for table `course_videos` -- CREATE TABLE `course_videos` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `module_uuid` varchar(110) DEFAULT NULL, `title` varchar(255) NOT NULL, `video_path` varchar(500) NOT NULL, `status` enum('pending','failed','approved') NOT NULL DEFAULT 'pending', `uploaded_by` varchar(110) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `course_videos` -- INSERT INTO `course_videos` (`id`, `uuid`, `module_uuid`, `title`, `video_path`, `status`, `uploaded_by`, `created_at`) VALUES (9, '19bc04ae-01df-469d-a8c0-ca0c910d2aa5', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'test 1', 'uploads/videos/video_6929a43302bf1.mp4', 'approved', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '2025-11-28 13:31:31'), (10, '174ac8c7-ece0-48f6-89f7-a899be0b5fee', 'd3a219cb-c59b-4235-8d86-8bc84c77a648', 'test 2', 'uploads/videos/video_6929a482c19b7.mp4', 'approved', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '2025-11-28 13:32:50'), (11, '4559bca2-b753-460f-80c0-a89ffbe588bf', '46988c08-77d8-4e18-89c1-ce34950aedd9', 'another test for module 1', 'uploads/videos/video_692cb5bea2303.mp4', 'approved', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '2025-11-30 21:23:11'), (12, '689d239e-ce39-11f0-afab-107d1a1291f6', '1087dd2d-ce39-11f0-afab-107d1a1291f6', 'free first video for test', 'uploads/videos/video_6929a43302bf1.mp4', 'approved', NULL, '2025-11-30 22:10:41'); -- -------------------------------------------------------- -- -- Table structure for table `currency_rates_cache` -- CREATE TABLE `currency_rates_cache` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `base_currency` varchar(10) NOT NULL, `rates` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`rates`)), `last_updated` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `currency_rates_cache` -- INSERT INTO `currency_rates_cache` (`id`, `uuid`, `base_currency`, `rates`, `last_updated`) VALUES (18, 'b9726228-8fa0-4629-8c58-98bde46a0d7e', 'USD', '{\"USD\":1,\"AED\":3.6725,\"AFN\":66.491429,\"ALL\":83.55179,\"AMD\":381.218284,\"ANG\":1.79,\"AOA\":916.665333,\"ARS\":1448.5,\"AUD\":1.535993,\"AWG\":1.79,\"AZN\":1.69981,\"BAM\":1.687602,\"BBD\":2,\"BDT\":122.345819,\"BGN\":1.687798,\"BHD\":0.376,\"BIF\":2953.115589,\"BMD\":1,\"BND\":1.297585,\"BOB\":6.919412,\"BRL\":5.379439,\"BSD\":1,\"BTN\":89.23778,\"BWP\":13.736368,\"BYN\":3.282281,\"BZD\":2,\"CAD\":1.405469,\"CDF\":2235.653431,\"CHF\":0.805246,\"CLF\":0.023666,\"CLP\":935.437606,\"CNH\":7.07223,\"CNY\":7.083601,\"COP\":3813.570611,\"CRC\":499.668883,\"CUP\":24,\"CVE\":95.142937,\"CZK\":20.853771,\"DJF\":177.721,\"DKK\":6.440996,\"DOP\":62.605707,\"DZD\":130.423582,\"EGP\":47.712883,\"ERN\":15,\"ETB\":152.856662,\"EUR\":0.862858,\"FJD\":2.281897,\"FKP\":0.756556,\"FOK\":6.441516,\"GBP\":0.756559,\"GEL\":2.70334,\"GGP\":0.756556,\"GHS\":11.197305,\"GIP\":0.756556,\"GMD\":74.189956,\"GNF\":8701.611795,\"GTQ\":7.656628,\"GYD\":209.185922,\"HKD\":7.777224,\"HNL\":26.317179,\"HRK\":6.501197,\"HTG\":131.000806,\"HUF\":329.62744,\"IDR\":16671.352579,\"ILS\":3.274017,\"IMP\":0.756556,\"INR\":89.237832,\"IQD\":1309.239945,\"IRR\":42333.705038,\"ISK\":126.673414,\"JEP\":0.756556,\"JMD\":160.296917,\"JOD\":0.709,\"JPY\":156.383614,\"KES\":129.679469,\"KGS\":87.419506,\"KHR\":4010.919682,\"KID\":1.535396,\"KMF\":424.497861,\"KRW\":1470.151055,\"KWD\":0.306955,\"KYD\":0.833333,\"KZT\":518.522631,\"LAK\":21768.557565,\"LBP\":89500,\"LKR\":307.70271,\"LRD\":177.773776,\"LSL\":17.141047,\"LYD\":5.469375,\"MAD\":9.262087,\"MDL\":17.062638,\"MGA\":4483.82033,\"MKD\":53.25136,\"MMK\":2098.836409,\"MNT\":3580.007519,\"MOP\":8.010541,\"MRU\":39.990205,\"MUR\":46.125549,\"MVR\":15.444443,\"MWK\":1740.490843,\"MXN\":18.353998,\"MYR\":4.135536,\"MZN\":63.718826,\"NAD\":17.141047,\"NGN\":1445.279449,\"NIO\":36.79138,\"NOK\":10.206929,\"NPR\":142.780448,\"NZD\":1.755942,\"OMR\":0.384497,\"PAB\":1,\"PEN\":3.36836,\"PGK\":4.242134,\"PHP\":58.812845,\"PKR\":282.631697,\"PLN\":3.651708,\"PYG\":6977.174816,\"QAR\":3.64,\"RON\":4.396138,\"RSD\":101.308905,\"RUB\":78.550223,\"RWF\":1458.203992,\"SAR\":3.75,\"SBD\":8.13825,\"SCR\":14.355555,\"SDG\":544.22218,\"SEK\":9.502285,\"SGD\":1.297572,\"SHP\":0.756556,\"SLE\":21.378633,\"SLL\":21378.632775,\"SOS\":570.628424,\"SRD\":38.376355,\"SSP\":4630.869955,\"STN\":21.139999,\"SYP\":11025.096776,\"SZL\":17.141047,\"THB\":32.231717,\"TJS\":9.275406,\"TMT\":3.499869,\"TND\":2.94824,\"TOP\":2.404882,\"TRY\":42.471118,\"TTD\":6.775714,\"TVD\":1.535396,\"TWD\":31.2779,\"TZS\":2461.732069,\"UAH\":42.280993,\"UGX\":3626.366202,\"UYU\":39.663106,\"UZS\":11890.509118,\"VES\":244.6504,\"VND\":26280.671328,\"VUV\":122.184047,\"WST\":2.79381,\"XAF\":565.997147,\"XCD\":2.7,\"XCG\":1.79,\"XDR\":0.735912,\"XOF\":565.997147,\"XPF\":102.966462,\"YER\":238.370461,\"ZAR\":17.142768,\"ZMW\":22.771786,\"ZWG\":26.1954,\"ZWL\":26.1954}', '2025-11-27 22:52:19'), (19, 'a1925d9b-a9f2-469d-bf40-1a16b5cf326b', 'USD', '{\"USD\":1,\"AED\":3.6725,\"AFN\":66.391529,\"ALL\":83.430248,\"AMD\":381.244644,\"ANG\":1.79,\"AOA\":921.166739,\"ARS\":1450.75,\"AUD\":1.528367,\"AWG\":1.79,\"AZN\":1.699942,\"BAM\":1.687555,\"BBD\":2,\"BDT\":122.224243,\"BGN\":1.687931,\"BHD\":0.376,\"BIF\":2957.431687,\"BMD\":1,\"BND\":1.296682,\"BOB\":6.92472,\"BRL\":5.345969,\"BSD\":1,\"BTN\":89.440061,\"BWP\":13.959256,\"BYN\":3.074984,\"BZD\":2,\"CAD\":1.398495,\"CDF\":2206.425026,\"CHF\":0.804195,\"CLF\":0.02348,\"CLP\":928.065516,\"CNH\":7.071757,\"CNY\":7.083189,\"COP\":3755.398883,\"CRC\":498.716682,\"CUP\":24,\"CVE\":95.140276,\"CZK\":20.851332,\"DJF\":177.721,\"DKK\":6.442519,\"DOP\":62.566994,\"DZD\":130.360854,\"EGP\":47.641457,\"ERN\":15,\"ETB\":153.398127,\"EUR\":0.862834,\"FJD\":2.277321,\"FKP\":0.755703,\"FOK\":6.442511,\"GBP\":0.755703,\"GEL\":2.702621,\"GGP\":0.755703,\"GHS\":11.253037,\"GIP\":0.755703,\"GMD\":74.186636,\"GNF\":8699.466891,\"GTQ\":7.659189,\"GYD\":209.220298,\"HKD\":7.784397,\"HNL\":26.31538,\"HRK\":6.501015,\"HTG\":130.907495,\"HUF\":329.155418,\"IDR\":16651.344456,\"ILS\":3.261502,\"IMP\":0.755703,\"INR\":89.440116,\"IQD\":1308.460506,\"IRR\":42218.364351,\"ISK\":127.971301,\"JEP\":0.755703,\"JMD\":160.232921,\"JOD\":0.709,\"JPY\":156.177017,\"KES\":129.577235,\"KGS\":87.334226,\"KHR\":4015.429289,\"KID\":1.528363,\"KMF\":424.485986,\"KRW\":1467.672742,\"KWD\":0.306986,\"KYD\":0.833333,\"KZT\":514.36472,\"LAK\":21759.072137,\"LBP\":89500,\"LKR\":307.855883,\"LRD\":177.601146,\"LSL\":17.122193,\"LYD\":5.45939,\"MAD\":9.247587,\"MDL\":16.997958,\"MGA\":4478.334759,\"MKD\":53.235298,\"MMK\":2097.727929,\"MNT\":3580.111505,\"MOP\":8.017929,\"MRU\":39.949313,\"MUR\":46.127154,\"MVR\":15.442475,\"MWK\":1745.750656,\"MXN\":18.313315,\"MYR\":4.132306,\"MZN\":63.777874,\"NAD\":17.122193,\"NGN\":1446.128999,\"NIO\":36.77751,\"NOK\":10.141412,\"NPR\":143.104097,\"NZD\":1.744657,\"OMR\":0.384497,\"PAB\":1,\"PEN\":3.362976,\"PGK\":4.259193,\"PHP\":58.648572,\"PKR\":282.463705,\"PLN\":3.655817,\"PYG\":6973.858555,\"QAR\":3.64,\"RON\":4.395992,\"RSD\":101.21873,\"RUB\":77.905492,\"RWF\":1461.33249,\"SAR\":3.75,\"SBD\":8.133295,\"SCR\":14.039763,\"SDG\":510.944171,\"SEK\":9.463464,\"SGD\":1.296589,\"SHP\":0.755703,\"SLE\":21.378633,\"SLL\":21378.632775,\"SOS\":570.611236,\"SRD\":38.36519,\"SSP\":4692.701968,\"STN\":21.139407,\"SYP\":11000.107884,\"SZL\":17.122193,\"THB\":32.164994,\"TJS\":9.277349,\"TMT\":3.499961,\"TND\":2.945622,\"TOP\":2.403156,\"TRY\":42.501917,\"TTD\":6.742321,\"TVD\":1.528363,\"TWD\":31.409839,\"TZS\":2459.056703,\"UAH\":42.280642,\"UGX\":3632.460343,\"UYU\":39.735352,\"UZS\":11913.736572,\"VES\":247.3003,\"VND\":26298.594903,\"VUV\":122.143629,\"WST\":2.788506,\"XAF\":565.981315,\"XCD\":2.7,\"XCG\":1.79,\"XDR\":0.735553,\"XOF\":565.981315,\"XPF\":102.963582,\"YER\":238.401515,\"ZAR\":17.122212,\"ZMW\":22.924072,\"ZWG\":26.1901,\"ZWL\":26.1901}', '2025-11-29 13:49:21'), (20, 'b07e5888-5e8e-4e99-8599-c8ede11f4bf6', 'USD', '{\"USD\":1,\"AED\":3.6725,\"AFN\":66.386564,\"ALL\":83.428464,\"AMD\":381.238423,\"ANG\":1.79,\"AOA\":919.794794,\"ARS\":1450.75,\"AUD\":1.530284,\"AWG\":1.79,\"AZN\":1.699916,\"BAM\":1.687807,\"BBD\":2,\"BDT\":122.232453,\"BGN\":1.68791,\"BHD\":0.376,\"BIF\":2957.663148,\"BMD\":1,\"BND\":1.296809,\"BOB\":6.92459,\"BRL\":5.347676,\"BSD\":1,\"BTN\":89.433674,\"BWP\":13.942859,\"BYN\":3.0942,\"BZD\":2,\"CAD\":1.398568,\"CDF\":2213.741973,\"CHF\":0.804388,\"CLF\":0.02348,\"CLP\":928.097013,\"CNH\":7.07154,\"CNY\":7.086153,\"COP\":3754.530189,\"CRC\":498.698997,\"CUP\":24,\"CVE\":95.154521,\"CZK\":20.850415,\"DJF\":177.721,\"DKK\":6.43978,\"DOP\":62.56683,\"DZD\":130.361906,\"EGP\":47.642545,\"ERN\":15,\"ETB\":153.558823,\"EUR\":0.862964,\"FJD\":2.277145,\"FKP\":0.755819,\"FOK\":6.439777,\"GBP\":0.75582,\"GEL\":2.702646,\"GGP\":0.755819,\"GHS\":11.250455,\"GIP\":0.755819,\"GMD\":74.186424,\"GNF\":8700.744847,\"GTQ\":7.659155,\"GYD\":209.220612,\"HKD\":7.783288,\"HNL\":26.314854,\"HRK\":6.501988,\"HTG\":130.810254,\"HUF\":329.184735,\"IDR\":16652.144491,\"ILS\":3.262037,\"IMP\":0.755819,\"INR\":89.433726,\"IQD\":1308.43293,\"IRR\":42250.738175,\"ISK\":127.945225,\"JEP\":0.755819,\"JMD\":160.20348,\"JOD\":0.709,\"JPY\":156.174722,\"KES\":129.571213,\"KGS\":87.339731,\"KHR\":4015.65005,\"KID\":1.529129,\"KMF\":424.549547,\"KRW\":1467.799571,\"KWD\":0.306958,\"KYD\":0.833333,\"KZT\":514.283616,\"LAK\":21757.715332,\"LBP\":89500,\"LKR\":307.853233,\"LRD\":177.602553,\"LSL\":17.120868,\"LYD\":5.459226,\"MAD\":9.261175,\"MDL\":16.998236,\"MGA\":4478.925791,\"MKD\":53.327619,\"MMK\":2097.716512,\"MNT\":3578.455546,\"MOP\":8.016785,\"MRU\":39.948135,\"MUR\":46.092825,\"MVR\":15.442102,\"MWK\":1745.223871,\"MXN\":18.314102,\"MYR\":4.132238,\"MZN\":63.755915,\"NAD\":17.120868,\"NGN\":1445.960466,\"NIO\":36.77678,\"NOK\":10.144983,\"NPR\":143.093879,\"NZD\":1.745031,\"OMR\":0.384497,\"PAB\":1,\"PEN\":3.363879,\"PGK\":4.259207,\"PHP\":58.647611,\"PKR\":282.446405,\"PLN\":3.655708,\"PYG\":6973.715517,\"QAR\":3.64,\"RON\":4.396077,\"RSD\":101.220635,\"RUB\":77.956335,\"RWF\":1460.872692,\"SAR\":3.75,\"SBD\":8.132978,\"SCR\":14.065447,\"SDG\":509.474346,\"SEK\":9.467247,\"SGD\":1.296676,\"SHP\":0.755819,\"SLE\":21.378633,\"SLL\":21378.632775,\"SOS\":570.61349,\"SRD\":38.364898,\"SSP\":4689.277416,\"STN\":21.142573,\"SYP\":10999.992435,\"SZL\":17.120868,\"THB\":32.169449,\"TJS\":9.277133,\"TMT\":3.499972,\"TND\":2.945923,\"TOP\":2.402803,\"TRY\":42.505437,\"TTD\":6.750296,\"TVD\":1.529129,\"TWD\":31.398118,\"TZS\":2456.023348,\"UAH\":42.280814,\"UGX\":3631.255653,\"UYU\":39.735515,\"UZS\":11910.783857,\"VES\":247.3003,\"VND\":26263.038809,\"VUV\":122.158464,\"WST\":2.788286,\"XAF\":566.066063,\"XCD\":2.7,\"XCG\":1.79,\"XDR\":0.73551,\"XOF\":566.066063,\"XPF\":102.978999,\"YER\":238.401422,\"ZAR\":17.120892,\"ZMW\":22.917144,\"ZWG\":26.1901,\"ZWL\":26.1901}', '2025-11-30 14:25:01'), (21, 'd9e78e3c-f298-4434-8b51-93c6251cc3dc', 'USD', '{\"USD\":1,\"AED\":3.6725,\"AFN\":66.386564,\"ALL\":83.428464,\"AMD\":381.238423,\"ANG\":1.79,\"AOA\":919.794794,\"ARS\":1450.75,\"AUD\":1.530284,\"AWG\":1.79,\"AZN\":1.699916,\"BAM\":1.687807,\"BBD\":2,\"BDT\":122.232453,\"BGN\":1.68791,\"BHD\":0.376,\"BIF\":2957.663148,\"BMD\":1,\"BND\":1.296809,\"BOB\":6.92459,\"BRL\":5.347676,\"BSD\":1,\"BTN\":89.433674,\"BWP\":13.942859,\"BYN\":3.0942,\"BZD\":2,\"CAD\":1.398568,\"CDF\":2213.741973,\"CHF\":0.804388,\"CLF\":0.02348,\"CLP\":928.097013,\"CNH\":7.07154,\"CNY\":7.086153,\"COP\":3754.530189,\"CRC\":498.698997,\"CUP\":24,\"CVE\":95.154521,\"CZK\":20.850415,\"DJF\":177.721,\"DKK\":6.43978,\"DOP\":62.56683,\"DZD\":130.361906,\"EGP\":47.642545,\"ERN\":15,\"ETB\":153.558823,\"EUR\":0.862964,\"FJD\":2.277145,\"FKP\":0.755819,\"FOK\":6.439777,\"GBP\":0.75582,\"GEL\":2.702646,\"GGP\":0.755819,\"GHS\":11.250455,\"GIP\":0.755819,\"GMD\":74.186424,\"GNF\":8700.744847,\"GTQ\":7.659155,\"GYD\":209.220612,\"HKD\":7.783288,\"HNL\":26.314854,\"HRK\":6.501988,\"HTG\":130.810254,\"HUF\":329.184735,\"IDR\":16652.144491,\"ILS\":3.262037,\"IMP\":0.755819,\"INR\":89.433726,\"IQD\":1308.43293,\"IRR\":42250.738175,\"ISK\":127.945225,\"JEP\":0.755819,\"JMD\":160.20348,\"JOD\":0.709,\"JPY\":156.174722,\"KES\":129.571213,\"KGS\":87.339731,\"KHR\":4015.65005,\"KID\":1.529129,\"KMF\":424.549547,\"KRW\":1467.799571,\"KWD\":0.306958,\"KYD\":0.833333,\"KZT\":514.283616,\"LAK\":21757.715332,\"LBP\":89500,\"LKR\":307.853233,\"LRD\":177.602553,\"LSL\":17.120868,\"LYD\":5.459226,\"MAD\":9.261175,\"MDL\":16.998236,\"MGA\":4478.925791,\"MKD\":53.327619,\"MMK\":2097.716512,\"MNT\":3578.455546,\"MOP\":8.016785,\"MRU\":39.948135,\"MUR\":46.092825,\"MVR\":15.442102,\"MWK\":1745.223871,\"MXN\":18.314102,\"MYR\":4.132238,\"MZN\":63.755915,\"NAD\":17.120868,\"NGN\":1445.960466,\"NIO\":36.77678,\"NOK\":10.144983,\"NPR\":143.093879,\"NZD\":1.745031,\"OMR\":0.384497,\"PAB\":1,\"PEN\":3.363879,\"PGK\":4.259207,\"PHP\":58.647611,\"PKR\":282.446405,\"PLN\":3.655708,\"PYG\":6973.715517,\"QAR\":3.64,\"RON\":4.396077,\"RSD\":101.220635,\"RUB\":77.956335,\"RWF\":1460.872692,\"SAR\":3.75,\"SBD\":8.132978,\"SCR\":14.065447,\"SDG\":509.474346,\"SEK\":9.467247,\"SGD\":1.296676,\"SHP\":0.755819,\"SLE\":21.378633,\"SLL\":21378.632775,\"SOS\":570.61349,\"SRD\":38.364898,\"SSP\":4689.277416,\"STN\":21.142573,\"SYP\":10999.992435,\"SZL\":17.120868,\"THB\":32.169449,\"TJS\":9.277133,\"TMT\":3.499972,\"TND\":2.945923,\"TOP\":2.402803,\"TRY\":42.505437,\"TTD\":6.750296,\"TVD\":1.529129,\"TWD\":31.398118,\"TZS\":2456.023348,\"UAH\":42.280814,\"UGX\":3631.255653,\"UYU\":39.735515,\"UZS\":11910.783857,\"VES\":247.3003,\"VND\":26263.038809,\"VUV\":122.158464,\"WST\":2.788286,\"XAF\":566.066063,\"XCD\":2.7,\"XCG\":1.79,\"XDR\":0.73551,\"XOF\":566.066063,\"XPF\":102.978999,\"YER\":238.401422,\"ZAR\":17.120892,\"ZMW\":22.917144,\"ZWG\":26.1901,\"ZWL\":26.1901}', '2025-11-30 14:25:02'), (22, '571daeda-6c22-4574-b0a4-88b8fabb7591', 'USD', '{\"USD\":1,\"AED\":3.6725,\"AFN\":66.26614,\"ALL\":83.447532,\"AMD\":381.38056,\"ANG\":1.79,\"AOA\":918.880573,\"ARS\":1450.75,\"AUD\":1.527619,\"AWG\":1.79,\"AZN\":1.700411,\"BAM\":1.686949,\"BBD\":2,\"BDT\":121.828992,\"BGN\":1.687004,\"BHD\":0.376,\"BIF\":2945.429755,\"BMD\":1,\"BND\":1.29664,\"BOB\":6.919146,\"BRL\":5.337155,\"BSD\":1,\"BTN\":89.452021,\"BWP\":13.862502,\"BYN\":3.372508,\"BZD\":2,\"CAD\":1.397883,\"CDF\":2262.549758,\"CHF\":0.804045,\"CLF\":0.023481,\"CLP\":928.113274,\"CNH\":7.071793,\"CNY\":7.080457,\"COP\":3743.94312,\"CRC\":497.094004,\"CUP\":24,\"CVE\":95.106128,\"CZK\":20.856726,\"DJF\":177.721,\"DKK\":6.435642,\"DOP\":62.649263,\"DZD\":130.488046,\"EGP\":47.655426,\"ERN\":15,\"ETB\":153.335149,\"EUR\":0.862524,\"FJD\":2.275341,\"FKP\":0.755767,\"FOK\":6.434958,\"GBP\":0.755787,\"GEL\":2.700838,\"GGP\":0.755767,\"GHS\":11.269092,\"GIP\":0.755767,\"GMD\":74.178727,\"GNF\":8729.215944,\"GTQ\":7.663162,\"GYD\":209.231421,\"HKD\":7.784233,\"HNL\":26.330635,\"HRK\":6.498682,\"HTG\":130.797346,\"HUF\":329.111596,\"IDR\":16651.751268,\"ILS\":3.257619,\"IMP\":0.755767,\"INR\":89.452059,\"IQD\":1307.48476,\"IRR\":43177.684183,\"ISK\":128.028204,\"JEP\":0.755767,\"JMD\":160.287324,\"JOD\":0.709,\"JPY\":156.087353,\"KES\":129.57776,\"KGS\":87.430841,\"KHR\":4023.240418,\"KID\":1.527656,\"KMF\":424.33363,\"KRW\":1467.894465,\"KWD\":0.306818,\"KYD\":0.833333,\"KZT\":512.401568,\"LAK\":21728.112959,\"LBP\":89500,\"LKR\":308.075695,\"LRD\":177.492794,\"LSL\":17.122267,\"LYD\":5.451611,\"MAD\":9.26747,\"MDL\":17.026611,\"MGA\":4491.734661,\"MKD\":53.31945,\"MMK\":2098.870077,\"MNT\":3580.931454,\"MOP\":8.018458,\"MRU\":39.90765,\"MUR\":46.162723,\"MVR\":15.437665,\"MWK\":1739.649368,\"MXN\":18.296123,\"MYR\":4.132397,\"MZN\":63.667718,\"NAD\":17.122267,\"NGN\":1444.860237,\"NIO\":36.804075,\"NOK\":10.126662,\"NPR\":143.123233,\"NZD\":1.744735,\"OMR\":0.384497,\"PAB\":1,\"PEN\":3.366262,\"PGK\":4.292998,\"PHP\":58.643616,\"PKR\":282.610774,\"PLN\":3.653259,\"PYG\":6972.882096,\"QAR\":3.64,\"RON\":4.397214,\"RSD\":101.373925,\"RUB\":77.67471,\"RWF\":1457.670543,\"SAR\":3.75,\"SBD\":8.209777,\"SCR\":14.461742,\"SDG\":458.937546,\"SEK\":9.452424,\"SGD\":1.296616,\"SHP\":0.755767,\"SLE\":21.378633,\"SLL\":21378.632775,\"SOS\":570.690989,\"SRD\":38.408236,\"SSP\":4672.406558,\"STN\":21.13182,\"SYP\":11014.460258,\"SZL\":17.122267,\"THB\":32.141407,\"TJS\":9.276002,\"TMT\":3.499951,\"TND\":2.947267,\"TOP\":2.394274,\"TRY\":42.508545,\"TTD\":6.791566,\"TVD\":1.527656,\"TWD\":31.420285,\"TZS\":2462.718747,\"UAH\":42.285817,\"UGX\":3638.925466,\"UYU\":39.675269,\"UZS\":11818.33389,\"VES\":247.3003,\"VND\":26246.414606,\"VUV\":122.026817,\"WST\":2.783586,\"XAF\":565.778174,\"XCD\":2.7,\"XCG\":1.79,\"XDR\":0.73551,\"XOF\":565.778174,\"XPF\":102.926626,\"YER\":238.538054,\"ZAR\":17.122273,\"ZMW\":22.956343,\"ZWG\":26.1901,\"ZWL\":26.1901}', '2025-12-01 17:07:19'), (23, 'bc32db57-542f-4a98-91bd-c6813edcdb02', 'USD', '{\"USD\":1,\"AED\":3.6725,\"AFN\":66.26614,\"ALL\":83.447532,\"AMD\":381.38056,\"ANG\":1.79,\"AOA\":918.880573,\"ARS\":1450.75,\"AUD\":1.527619,\"AWG\":1.79,\"AZN\":1.700411,\"BAM\":1.686949,\"BBD\":2,\"BDT\":121.828992,\"BGN\":1.687004,\"BHD\":0.376,\"BIF\":2945.429755,\"BMD\":1,\"BND\":1.29664,\"BOB\":6.919146,\"BRL\":5.337155,\"BSD\":1,\"BTN\":89.452021,\"BWP\":13.862502,\"BYN\":3.372508,\"BZD\":2,\"CAD\":1.397883,\"CDF\":2262.549758,\"CHF\":0.804045,\"CLF\":0.023481,\"CLP\":928.113274,\"CNH\":7.071793,\"CNY\":7.080457,\"COP\":3743.94312,\"CRC\":497.094004,\"CUP\":24,\"CVE\":95.106128,\"CZK\":20.856726,\"DJF\":177.721,\"DKK\":6.435642,\"DOP\":62.649263,\"DZD\":130.488046,\"EGP\":47.655426,\"ERN\":15,\"ETB\":153.335149,\"EUR\":0.862524,\"FJD\":2.275341,\"FKP\":0.755767,\"FOK\":6.434958,\"GBP\":0.755787,\"GEL\":2.700838,\"GGP\":0.755767,\"GHS\":11.269092,\"GIP\":0.755767,\"GMD\":74.178727,\"GNF\":8729.215944,\"GTQ\":7.663162,\"GYD\":209.231421,\"HKD\":7.784233,\"HNL\":26.330635,\"HRK\":6.498682,\"HTG\":130.797346,\"HUF\":329.111596,\"IDR\":16651.751268,\"ILS\":3.257619,\"IMP\":0.755767,\"INR\":89.452059,\"IQD\":1307.48476,\"IRR\":43177.684183,\"ISK\":128.028204,\"JEP\":0.755767,\"JMD\":160.287324,\"JOD\":0.709,\"JPY\":156.087353,\"KES\":129.57776,\"KGS\":87.430841,\"KHR\":4023.240418,\"KID\":1.527656,\"KMF\":424.33363,\"KRW\":1467.894465,\"KWD\":0.306818,\"KYD\":0.833333,\"KZT\":512.401568,\"LAK\":21728.112959,\"LBP\":89500,\"LKR\":308.075695,\"LRD\":177.492794,\"LSL\":17.122267,\"LYD\":5.451611,\"MAD\":9.26747,\"MDL\":17.026611,\"MGA\":4491.734661,\"MKD\":53.31945,\"MMK\":2098.870077,\"MNT\":3580.931454,\"MOP\":8.018458,\"MRU\":39.90765,\"MUR\":46.162723,\"MVR\":15.437665,\"MWK\":1739.649368,\"MXN\":18.296123,\"MYR\":4.132397,\"MZN\":63.667718,\"NAD\":17.122267,\"NGN\":1444.860237,\"NIO\":36.804075,\"NOK\":10.126662,\"NPR\":143.123233,\"NZD\":1.744735,\"OMR\":0.384497,\"PAB\":1,\"PEN\":3.366262,\"PGK\":4.292998,\"PHP\":58.643616,\"PKR\":282.610774,\"PLN\":3.653259,\"PYG\":6972.882096,\"QAR\":3.64,\"RON\":4.397214,\"RSD\":101.373925,\"RUB\":77.67471,\"RWF\":1457.670543,\"SAR\":3.75,\"SBD\":8.209777,\"SCR\":14.461742,\"SDG\":458.937546,\"SEK\":9.452424,\"SGD\":1.296616,\"SHP\":0.755767,\"SLE\":21.378633,\"SLL\":21378.632775,\"SOS\":570.690989,\"SRD\":38.408236,\"SSP\":4672.406558,\"STN\":21.13182,\"SYP\":11014.460258,\"SZL\":17.122267,\"THB\":32.141407,\"TJS\":9.276002,\"TMT\":3.499951,\"TND\":2.947267,\"TOP\":2.394274,\"TRY\":42.508545,\"TTD\":6.791566,\"TVD\":1.527656,\"TWD\":31.420285,\"TZS\":2462.718747,\"UAH\":42.285817,\"UGX\":3638.925466,\"UYU\":39.675269,\"UZS\":11818.33389,\"VES\":247.3003,\"VND\":26246.414606,\"VUV\":122.026817,\"WST\":2.783586,\"XAF\":565.778174,\"XCD\":2.7,\"XCG\":1.79,\"XDR\":0.73551,\"XOF\":565.778174,\"XPF\":102.926626,\"YER\":238.538054,\"ZAR\":17.122273,\"ZMW\":22.956343,\"ZWG\":26.1901,\"ZWL\":26.1901}', '2025-12-01 17:07:19'); -- -------------------------------------------------------- -- -- Table structure for table `earnings` -- CREATE TABLE `earnings` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `user_uuid` varchar(110) DEFAULT NULL, `course_uuid` varchar(110) DEFAULT NULL, `amount` decimal(10,2) NOT NULL, `status` enum('available','withdrawn') DEFAULT 'available', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `earnings` -- INSERT INTO `earnings` (`id`, `uuid`, `user_uuid`, `course_uuid`, `amount`, `status`, `created_at`) VALUES (10, 'ac358ab1-cdfc-11f0-a501-107d1a1291f6', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 180.00, 'available', '2025-11-30 14:54:14'), (11, '5fed3db7-06d6-471c-a1f7-17efb820537a', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 180.00, 'available', '2025-12-01 15:18:31'); -- -------------------------------------------------------- -- -- Table structure for table `edit_course_approval_requests` -- CREATE TABLE `edit_course_approval_requests` ( `id` int(11) NOT NULL, `tutor_user_uuid` varchar(110) DEFAULT NULL, `course_uuid` varchar(110) DEFAULT NULL, `status` enum('pending','approved','declined') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `faq_categories` -- CREATE TABLE `faq_categories` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `category_name` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `faq_categories` -- INSERT INTO `faq_categories` (`id`, `uuid`, `category_name`) VALUES (1, 'fc1d78a0-1791-4032-9dcd-8aa4jf0b8281', 'Account & Billing'), (2, 'fc1d78a0-1791-4032-9dcd-8aa2ef0bf8281', 'Course Content'), (3, 'fc1d78a0-1791-4032-9dcd-8aa2ejpb8281', 'Technical Support'); -- -------------------------------------------------------- -- -- Table structure for table `faq_items` -- CREATE TABLE `faq_items` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `category_uuid` varchar(110) DEFAULT NULL, `question` text NOT NULL, `answer` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `faq_items` -- INSERT INTO `faq_items` (`id`, `uuid`, `category_uuid`, `question`, `answer`) VALUES (1, NULL, 'fc1d78a0-1791-4032-9dcd-8aa2ef0bf8281', 'How do I access my course materials?', 'Once you enroll in a course, you can find all the materials, including videos, quizzes, and assignments, in your dashboard under the \"My Courses\" section. Click on the course title to begin.'), (2, NULL, 'fc1d78a0-1791-4032-9dcd-8aa2ejpb8281', 'What is your refund policy?', 'We offer a full refund for any course purchased within 14 days, as long as you have not completed more than 50% of the course content. For more details, please see our full Terms of Service.'), (3, NULL, 'fc1d78a0-1791-4032-9dcd-8aa4jf0b8281', 'What if I forget my password?', 'If you forget your password, simply click the \"Forgot Password\" link on the login page. We\'ll send a password reset link to the email address associated with your account.'); -- -------------------------------------------------------- -- -- Table structure for table `giftcards` -- CREATE TABLE `giftcards` ( `id` int(11) NOT NULL, `uuid` varchar(110) DEFAULT NULL, `user_uuid` varchar(110) DEFAULT NULL, `amount` decimal(10,2) NOT NULL, `code` varchar(50) NOT NULL, `status` enum('active','redeemed') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `notifications` -- CREATE TABLE `notifications` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `user_uuid` varchar(110) DEFAULT NULL, `title` varchar(255) NOT NULL, `message` text NOT NULL, `link` varchar(255) DEFAULT NULL, `is_read` tinyint(1) DEFAULT 0, `created_at` datetime DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `notifications` -- INSERT INTO `notifications` (`id`, `uuid`, `user_uuid`, `title`, `message`, `link`, `is_read`, `created_at`) VALUES (72, '43de2683-1430-491b-a9a2-2daff17836ee', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Email verified successfully', 'Welcome on board, we are pleased to have you here. Enjoy the experience!', NULL, 1, '2025-11-27 20:22:45'), (73, '3e68a0be-121d-49da-af4a-d650a541c4df', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Complaint was submitted successfully', 'this how to play this game for this project', '/support', 0, '2025-11-27 22:40:43'), (74, '72e1870f-1f82-4b10-a8ad-90596ae83fae', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Thank you for Contacting us, We get back to you as fast as possible', 'just testing the contact form', '/contact', 0, '2025-11-27 23:25:56'), (75, '6c855a17-b0d2-4ada-bdde-9bf6c70d620a', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Course Materials Submitted For Review', 'You have successfully submitted your course materials for review, please await our response as soon as possible.', NULL, 0, '2025-11-28 15:53:38'), (79, 'd25caa1c-12a8-4ec6-ba12-ac0e634f5666', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'Your email was successfully verified', 'Welcome on board , we are pleased to have you here. Enjoy the expirience!', NULL, 0, '2025-11-29 10:33:21'), (80, 'e4b6ab99-3600-4bc3-a28f-0e57ae9a8cc5', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'Your email was successfully verified', 'Welcome on board , we are pleased to have you here. Enjoy the expirience!', NULL, 0, '2025-11-29 10:36:37'), (81, 'e92fb86c-34fd-4b29-b391-d93770be1c49', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'Message Sent', 'Your message has been sent successfully.', '/messages', 0, '2025-11-29 18:03:23'), (82, 'ba247b1d-c4bf-4b0e-9eca-c4744808ec9d', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'New Message', 'You have received a new message from your student.', '/messages', 1, '2025-11-29 18:03:24'), (83, '242426ce-a71d-4657-93d0-914b88a93986', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'Complaint was submitted successfully', 'i want check if my payment is gooing', '/support', 0, '2025-11-29 18:22:44'), (84, 'ffc48511-688a-43f5-920c-81f0b03cf9e7', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'Complaint was submitted successfully', 'test afauab', '/support', 0, '2025-11-29 18:23:50'), (89, '8add7d48-ad50-4b83-a161-188a5e854913', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'Your email was successfully verified', 'Welcome on board , we are pleased to have you here. Enjoy the expirience!', NULL, 0, '2025-12-01 15:29:21'), (90, 'b1948030-b130-4c28-8729-0713e91e2426', '5c4b53e5-de2f-4088-89e5-c03777f331b6', 'Your email was successfully verified', 'Welcome on board , we are pleased to have you here. Enjoy the expirience!', NULL, 0, '2025-12-01 17:57:46'), (91, '8f852626-e140-444a-b0d9-e4acab2a922c', 'ceb692f7-055d-473e-bb16-b4917cb9427e', 'Email verified successfully', 'Welcome on board, we are pleased to have you here. Enjoy the experience!', NULL, 0, '2025-12-01 18:03:25'), (92, 'a126461e-dbeb-4f66-b053-b80e23677185', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Message Sent', 'Your message has been sent successfully.', '/messages', 0, '2025-12-01 18:15:11'), (93, '31073c5f-8a51-4734-b04b-e4b34b0cafe0', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'New Message', 'You have received a new message from your tutor.', '/messages', 0, '2025-12-01 18:15:11'), (94, 'b640874a-2bd7-46b9-9d8d-f065df8ca1f9', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'Message Sent', 'Your message has been sent successfully.', '/messages', 0, '2025-12-01 18:16:37'), (95, 'c039011c-570d-475a-a2cf-0a381a0bf13e', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'New Message', 'You have received a new message from your student.', '/messages', 0, '2025-12-01 18:16:37'), (96, 'bec4342b-4d12-4422-bfac-2646dbfe8b3b', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Message Sent', 'Your message has been sent successfully.', '/messages', 0, '2025-12-01 18:28:31'), (97, '9eebf2d2-7545-45d5-8ed8-24d057d8f265', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'New Message', 'You have received a new message from your tutor.', '/messages', 0, '2025-12-01 18:28:31'), (98, 'ae56d04d-4c56-4839-b1fe-4f8fcbadec2b', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'Message Sent', 'Your message has been sent successfully.', '/messages', 0, '2025-12-01 19:30:30'), (99, 'fd28ba07-e8a2-4d5b-bb80-4fcaec98d17d', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'New Message', 'You have received a new message from your student.', '/messages', 0, '2025-12-01 19:30:31'), (100, 'a60b2b98-6c23-4a41-ac87-ec50ecaeeb59', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Message Sent', 'Your message has been sent successfully.', '/messages', 0, '2025-12-01 19:31:17'), (101, 'cf02d5f6-e23a-4d13-9e32-957a72b34b39', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'New Message', 'You have received a new message from your tutor.', '/messages', 0, '2025-12-01 19:31:17'), (102, 'a04896bf-0e46-43ba-80d8-87788e6a34bb', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'Message Sent', 'Your message has been sent successfully.', '/messages', 0, '2025-12-01 19:31:47'), (103, '8f776a6b-6317-492a-b24b-ae3441bc9ede', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'New Message', 'You have received a new message from your student.', '/messages', 0, '2025-12-01 19:31:47'); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `student_uuid` varchar(60) DEFAULT NULL, `tutor_uuid` varchar(60) DEFAULT NULL, `course_uuid` varchar(60) DEFAULT NULL, `payment_status` enum('pending','paid','failed','refunded') DEFAULT 'pending', `amount` decimal(10,2) NOT NULL, `currency` varchar(10) DEFAULT 'NGN', `access_expires_at` datetime DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `uuid`, `student_uuid`, `tutor_uuid`, `course_uuid`, `payment_status`, `amount`, `currency`, `access_expires_at`, `created_at`, `updated_at`) VALUES (16, '94d59ec8-3068-4630-bc93-65dadd4eefd0', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', NULL, 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 'paid', 0.00, 'USD', '2025-11-29 10:48:57', '2025-11-29 09:48:57', '2025-11-29 09:48:57'), (17, 'ba2b8c10-cd2c-11f0-a501-107d1a1291f6', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 'paid', 180.00, 'USD', '2025-11-29 15:04:52', '2025-11-29 14:06:21', '2025-11-29 14:07:26'), (20, '7dbb5595-6f33-4ad0-b899-326247fa19f5', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 'paid', 180.00, 'USD', '2025-12-01 16:18:31', '2025-12-01 15:18:31', '2025-12-01 16:45:59'), (23, '45c95837-373a-4414-9cdc-edf39ae9fa44', '5c4b53e5-de2f-4088-89e5-c03777f331b6', NULL, 'c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 'paid', 0.00, 'USD', '2025-12-01 18:01:34', '2025-12-01 17:01:34', '2025-12-01 17:01:34'); -- -------------------------------------------------------- -- -- Table structure for table `skills` -- CREATE TABLE `skills` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `skills` -- INSERT INTO `skills` (`id`, `uuid`, `name`) VALUES (1, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4o', 'Web Development'), (2, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4dd', 'App Development'), (3, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4g11', 'Data Science'), (4, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd47', 'Data Analysis'), (5, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4dk', 'Financial Analysis'), (6, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fdhd', 'Graphics Design'), (7, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4gjs', 'UI/UX Design'), (8, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4gss', '3D Animation'), (9, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fdet', '2D anaimation'), (10, '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4geo', 'Others'); -- -------------------------------------------------------- -- -- Table structure for table `social_handles` -- CREATE TABLE `social_handles` ( `id` int(11) NOT NULL, `uuid` varchar(110) DEFAULT NULL, `user_uuid` varchar(110) DEFAULT NULL, `platform` varchar(100) NOT NULL, `url` varchar(255) NOT NULL, `handle` varchar(150) DEFAULT NULL, `is_active` tinyint(1) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `social_handles` -- INSERT INTO `social_handles` (`id`, `uuid`, `user_uuid`, `platform`, `url`, `handle`, `is_active`, `created_at`, `updated_at`) VALUES (90, 'cf6345f6-56a4-4248-9b9b-db53cd88a06d', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'facebook', 'https://facebook.com.ng/hackman', NULL, 1, '2025-11-27 22:33:52', '2025-11-27 22:33:52'), (91, 'cf6345f6-56a4-4248-9b9b-db53cd88a06d', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'tiktok', 'https://tiktok.com/hackman', NULL, 1, '2025-11-27 22:33:52', '2025-11-27 22:33:52'), (92, 'cf6345f6-56a4-4248-9b9b-db53cd88a06d', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'twitter', 'https://x.com/manuel', NULL, 1, '2025-11-27 22:33:52', '2025-11-27 22:33:52'), (93, NULL, 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'facebook', 'https://facebook.com', NULL, 1, '2025-11-30 00:00:06', '2025-11-30 00:00:06'), (94, NULL, 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'snapchat', 'https://snapchat.com', NULL, 1, '2025-11-30 00:00:06', '2025-11-30 00:00:06'), (95, NULL, '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'facebook', 'https://facebook.com/me', NULL, 1, '2025-12-01 16:46:56', '2025-12-01 16:46:56'), (96, NULL, '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'tiktok', 'https://tiktok.com/me', NULL, 1, '2025-12-01 16:46:56', '2025-12-01 16:46:56'); -- -------------------------------------------------------- -- -- Table structure for table `students` -- CREATE TABLE `students` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `user_uuid` varchar(60) DEFAULT NULL, `title` varchar(200) NOT NULL, `gender` enum('male','female','other') DEFAULT NULL, `bio` text DEFAULT NULL, `date_of_birth` date DEFAULT NULL, `enrolled_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `students` -- INSERT INTO `students` (`id`, `uuid`, `user_uuid`, `title`, `gender`, `bio`, `date_of_birth`, `enrolled_at`) VALUES (11, '6e971e1a-8d6e-4f7d-b3a7-1389a0e77daa', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', '', NULL, 'this is my story of my live and i love it that way.', NULL, '2025-11-29 09:48:57'), (23, '29e3c262-f717-4d7c-8c44-22e11fe326dc', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', '', NULL, 'this my bio for real', NULL, '2025-12-01 16:01:24'), (25, '5389269e-66d1-4017-be31-60986e019f9d', '5c4b53e5-de2f-4088-89e5-c03777f331b6', '', NULL, NULL, NULL, '2025-12-01 17:01:34'); -- -------------------------------------------------------- -- -- Table structure for table `student_answers` -- CREATE TABLE `student_answers` ( `id` bigint(20) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `student_uuid` char(36) NOT NULL, `course_uuid` char(36) NOT NULL, `module_uuid` char(36) NOT NULL, `assessment_uuid` char(36) NOT NULL, `question_uuid` char(36) NOT NULL, `answer_text` text DEFAULT NULL, `answer_choice` char(1) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `study_logs` -- CREATE TABLE `study_logs` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `student_uuid` varchar(110) DEFAULT NULL, `course_uuid` varchar(110) DEFAULT NULL, `hours` decimal(10,6) DEFAULT NULL, `date` date NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `study_logs` -- INSERT INTO `study_logs` (`id`, `uuid`, `student_uuid`, `course_uuid`, `hours`, `date`, `created_at`, `updated_at`) VALUES (27, '3c6968f7-8030-43e6-abb3-30ab9248ecf0', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'a25da3dc-30a8-46a9-ae70-8acb750e7811', 0.022502, '2025-11-30', '2025-11-29 23:26:51', '2025-12-01 16:54:05'); -- -------------------------------------------------------- -- -- Table structure for table `support_replies` -- CREATE TABLE `support_replies` ( `id` int(10) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `ticket_uuid` varchar(100) DEFAULT NULL, `sender_uuid` varchar(100) DEFAULT NULL, `message` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `support_replies` -- INSERT INTO `support_replies` (`id`, `uuid`, `ticket_uuid`, `sender_uuid`, `message`, `created_at`) VALUES (9, 'e2d0bf27-8f8b-40a4-9803-218310221145', 'ba51e5ec-e1b9-40d3-bdcb-5aba2c9252b6', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'you can help me right now..', '2025-11-27 21:58:55'), (11, '940303e1-9966-4f9d-b9a4-b7e7d07fade0', 'b3f1be27-95f0-40ae-9d92-551a09a99634', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'i think its good now', '2025-11-29 17:30:50'); -- -------------------------------------------------------- -- -- Table structure for table `support_tickets` -- CREATE TABLE `support_tickets` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `user_uuid` varchar(110) DEFAULT NULL, `priority` varchar(100) NOT NULL, `department` varchar(100) NOT NULL, `subject` varchar(150) NOT NULL, `message` text NOT NULL, `status` enum('open','resolved','closed') DEFAULT 'open', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `support_tickets` -- INSERT INTO `support_tickets` (`id`, `uuid`, `user_uuid`, `priority`, `department`, `subject`, `message`, `status`, `created_at`) VALUES (11, 'ba51e5ec-e1b9-40d3-bdcb-5aba2c9252b6', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Medium', 'Sales Team', 'i need help for my project', 'this how to play this game for this project', 'closed', '2025-11-27 21:40:43'), (12, '00db6419-d5a4-4bfa-addd-994e0eb18ef1', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'Medium', 'Sales Team', 'paymenyt failed', 'i want check if my payment is gooing', 'open', '2025-11-29 17:22:43'), (13, 'b3f1be27-95f0-40ae-9d92-551a09a99634', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'Medium', 'Sales Team', 'test', 'test afauab', 'open', '2025-11-29 17:23:50'); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `order_uuid` varchar(110) DEFAULT NULL, `student_uuid` varchar(110) DEFAULT NULL, `transaction_ref` varchar(100) NOT NULL, `amount` decimal(10,2) NOT NULL, `currency` varchar(10) DEFAULT 'NGN', `status` enum('pending','success','failed','refunded') DEFAULT 'pending', `payment_gateway` varchar(50) DEFAULT 'paypal', `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)), `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `uuid`, `order_uuid`, `student_uuid`, `transaction_ref`, `amount`, `currency`, `status`, `payment_gateway`, `metadata`, `created_at`, `updated_at`) VALUES (5, '77b00d20-0fc9-48eb-ae38-c5b900cf3d03', '94d59ec8-3068-4630-bc93-65dadd4eefd0', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'FREE-d9a6c781-84e2-423c-ad71-4f9b1b170b3c-c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 0.00, 'USD', 'success', 'FREE', NULL, '2025-11-29 09:48:57', '2025-11-29 09:48:57'), (6, '13a3b589-cd2d-11f0-a501-107d1a1291f6', 'ba2b8c10-cd2c-11f0-a501-107d1a1291f6', 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'payment-shnsm4634bdksdbse434f', 180.00, 'USD', 'success', 'paypal', NULL, '2025-11-29 14:08:51', '2025-11-29 14:08:51'), (7, '2981dd36-61f2-427e-be77-4115a9b272fe', '7dbb5595-6f33-4ad0-b899-326247fa19f5', '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'transaction-7dbb5595-6f33-4ad0-b899-326247fa19f5', 180.00, 'USD', 'success', 'paypal', NULL, '2025-12-01 15:18:31', '2025-12-01 15:18:31'), (10, 'c50f8241-f2f4-4277-8269-481c0c10d49b', '45c95837-373a-4414-9cdc-edf39ae9fa44', '5c4b53e5-de2f-4088-89e5-c03777f331b6', 'FREE-5c4b53e5-de2f-4088-89e5-c03777f331b6-c2e8e0a7-3ec9-4607-9e45-6012c65c5f7f', 0.00, 'USD', 'success', 'FREE', NULL, '2025-12-01 17:01:34', '2025-12-01 17:01:34'); -- -------------------------------------------------------- -- -- Table structure for table `tutors` -- CREATE TABLE `tutors` ( `id` int(11) NOT NULL, `uuid` varchar(60) DEFAULT NULL, `user_uuid` varchar(60) DEFAULT NULL, `title` varchar(150) NOT NULL, `bio` text DEFAULT NULL, `education` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`education`)), `experience` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`experience`)), `expertise` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`expertise`)), `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tutors` -- INSERT INTO `tutors` (`id`, `uuid`, `user_uuid`, `title`, `bio`, `education`, `experience`, `expertise`, `created_at`) VALUES (6, '7cb369ac-624b-4992-a476-f4159fa05755', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'Frontend Engineer', 'i love to play video games and VR and am a tech enthusiast and passionate about my work as a software engineer', '[\"BS.c in Computer Science\",\"Certified Frontend developer \"]', '[\"3yrs working with Google\",\"2 years with facebook\"]', '[\"php\",\"JavaScript\",\"React.js\",\"Next.js\",\"React Native\"]', '2025-11-27 15:29:44'), (7, 'be92e183-2837-410b-86f7-c68ab282c283', 'ceb692f7-055d-473e-bb16-b4917cb9427e', '0jdjkkdj', 'asswdsa', '[\"asc\"]', '[\"asc\"]', '[\"aS\"]', '2025-12-01 17:02:54'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(100) NOT NULL, `uuid` varchar(60) NOT NULL, `username` varchar(200) DEFAULT NULL, `firstname` varchar(200) DEFAULT NULL, `lastname` varchar(200) DEFAULT NULL, `password` varchar(200) DEFAULT NULL, `pin` varchar(100) DEFAULT NULL, `email` varchar(200) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `country` varchar(100) DEFAULT NULL, `state` varchar(100) DEFAULT NULL, `city` varchar(200) DEFAULT NULL, `zip_code` varchar(200) DEFAULT NULL, `profile_stage` int(50) NOT NULL DEFAULT 0, `studentId` varchar(200) NOT NULL DEFAULT 'ICT-SLIDES-', `profilePic` varchar(200) DEFAULT NULL, `temp_code` varchar(100) DEFAULT NULL, `temp_validation` datetime DEFAULT NULL, `token` text DEFAULT NULL, `suspension_reason` text DEFAULT NULL, `status` enum('verified','pending','failed','suspended') NOT NULL DEFAULT 'pending', `online` tinyint(11) NOT NULL DEFAULT 0, `roles` enum('tutor','student','admin') DEFAULT 'student', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `last_active` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `uuid`, `username`, `firstname`, `lastname`, `password`, `pin`, `email`, `phone`, `country`, `state`, `city`, `zip_code`, `profile_stage`, `studentId`, `profilePic`, `temp_code`, `temp_validation`, `token`, `suspension_reason`, `status`, `online`, `roles`, `created_at`, `last_active`) VALUES (40, 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', 'TechyTutor', 'Somtochi', 'Nweke', '$2y$10$OY4/NbOQ/zBdd36X3tO90ew0g4WgfbLXNBUDjqTV7f4XTlQ/4Elm2', '$2y$10$sS.uFbD.GQlqIQHam4xET./XiTg/Y5KoIbvNw.UPnxbcC7ABQEUfK', 'emmanuelbigboss26@gmail.com', '+2346975860', 'NG', 'AN', 'Awka', '10001', 1, 'SLIDES-ljlOGa', 'uploads/profile/profile_692a129b2f3ee0.58700473.jpg', NULL, NULL, NULL, NULL, 'verified', 0, 'tutor', '2025-11-27 15:29:40', NULL), (46, 'd9a6c781-84e2-423c-ad71-4f9b1b170b3c', 'kenny', 'Munachi', 'Nweke', '$2y$10$JCMaWsRgvi0KsMGa4Ubyg.f00.aJHeEQHG8AcgsMJCn9ctHyxqQ5S', '$2y$10$OqNIGIoxowytFLTprfB6A.y0yg4tlv8BgEnJvWARwSueHPbi9BchC', 'test.hackdevelopers@gmail.com', '+08136482736', 'NG', 'AN', 'Awka', '11001', 1, 'SLIDES-SPz37E', 'uploads/profile/student_692abd06dd8848.81883149.jpg', NULL, NULL, NULL, NULL, 'verified', 0, 'student', '2025-11-29 09:29:43', NULL), (51, '97d6cc3a-03e7-44d0-bfb2-699e9c164577', 'jenny', 'Mary', 'Uche', '$2y$10$il8i04VheTs7Jnzgzey5weEdw.LkGNm6bg6hevlvEhQAlmYlFsGNu', '$2y$10$uBAyhfFEZbILHrmNqoqOFef3SsY7pz0l0kRKG6O7KEgMAaz0XM/iK', 'jennyme@gmail.com', NULL, NULL, NULL, NULL, NULL, 0, 'SLIDES-WUp2hX', 'uploads/profile/student_692da61375c115.31549128.jpg', NULL, NULL, NULL, NULL, 'verified', 0, 'student', '2025-12-01 14:28:35', NULL), (52, '5c4b53e5-de2f-4088-89e5-c03777f331b6', 'menny', 'Mary', 'Uche', '$2y$10$yhQU.PWh4G8lcWFWWH6foeGc6iazlV3RROlXo0KuXL7DOpJxrHlW6', '$2y$10$c7syTIro2rZQvj921NO/DO32w4ID3TFxG/YekUQvVtFRnBsnkCQDK', 'mennymary@outlook.com', NULL, NULL, NULL, NULL, NULL, 0, 'SLIDES-jzr6Ch', 'uploads/profile/student_692dc8e8d52d51.56869154.jpg', NULL, NULL, NULL, NULL, 'verified', 1, 'student', '2025-12-01 16:57:13', NULL), (53, 'ceb692f7-055d-473e-bb16-b4917cb9427e', 'admins', 'John', 'Doe', '$2y$10$208ZFG1uytwqc1gFZ0roHedBbPNiQGiFPUxDWMrElZtI7Zbj5XOPq', '$2y$10$v7MiRXqjCzOXnDviJooOtelxOqNn2hC4VnNqigVy8eYOSyHlI3TbC', 'manuel@gmail.com', NULL, NULL, NULL, NULL, NULL, 1, 'SLIDES-AIOhKU', 'uploads/profile/tutor_692dca32acdf28.74533740.jpg', NULL, NULL, NULL, NULL, 'verified', 0, 'tutor', '2025-12-01 17:02:42', NULL); -- -------------------------------------------------------- -- -- Table structure for table `user_badges` -- CREATE TABLE `user_badges` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `badge_id` int(11) NOT NULL, `progress` int(11) DEFAULT 0, `status` enum('locked','wip','completed') DEFAULT 'locked', `completed_at` datetime DEFAULT NULL, `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `user_logs` -- CREATE TABLE `user_logs` ( `id` int(10) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `activity` varchar(255) NOT NULL, `ip_address` varchar(45) NOT NULL, `device` varchar(255) NOT NULL, `location` varchar(255) DEFAULT 'Unknown', `status` enum('Success','Failed','Info') DEFAULT 'Success', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `user_logs` -- INSERT INTO `user_logs` (`id`, `uuid`, `user_id`, `activity`, `ip_address`, `device`, `location`, `status`, `created_at`) VALUES (504, 'f291fdcc-b8a6-4b2a-b484-3554697aaa80', 40, 'User reguested new verification code', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 19:16:33'), (505, '1d51e2c7-6b78-4228-8348-a0556265ba28', 40, 'User email verified successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 19:17:28'), (506, 'ae91c59f-9a70-43ea-b908-ccb1a531d446', 40, 'User reguested new verification code', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 19:21:13'), (507, '906746e1-b0f1-42f8-b823-dc325abf0a0e', 40, 'User email verified successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 19:22:45'), (510, 'f4c1b41b-39eb-4066-b10c-442c5b25d4b5', 40, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 19:52:17'), (511, '5bd3586f-88b3-4092-bdfd-19caa15b1253', 40, 'User Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 19:52:36'), (514, '60d59fa1-a641-46e3-aacd-71379bfcd4bc', 40, 'Profile updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 20:24:31'), (515, '4cd616b9-b37f-4d17-a08d-b8ee6e4065e2', 40, 'Password changed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 20:35:06'), (516, '476d3446-2fc7-4215-badf-d410c05aa51d', 40, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 23:17:23'), (517, '08702e5d-5b26-4b1e-9001-9c1685d3f97f', 40, 'User Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 23:17:46'), (518, 'ef21d04b-57f1-4b6c-b897-f5c0e0935b74', 40, 'Password changed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 23:19:35'), (519, '61bb0ffa-fa03-4e88-863d-07f1a4e367e2', 40, 'User Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-27 23:28:29'), (521, 'd3c84a24-9cff-4ad2-9323-9ba388a90d17', 40, 'User created template successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-28 00:28:37'), (523, '5234dc03-88cd-41d2-842c-32a28ab24b19', 40, 'Uploaded 1 module(s) to course [ui-ux-design-masterclass-25c8bc]', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-28 00:46:09'), (524, '371c920f-860c-44ed-8346-c16fc745d912', 40, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-28 00:59:28'), (525, '87d9a724-337d-4bd9-89bc-ff9639c57bde', 40, 'User Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-28 11:21:54'), (526, '14e73655-7b66-4b24-9311-de9ec10c6a0c', 40, 'User Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-28 12:10:00'), (527, '5b24bd79-0ba8-4224-b0d4-257850221bbc', 40, 'Uploaded 46988 module videos(s) to course module video [test 1]', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location::1', 'Success', '2025-11-28 13:31:31'), (528, '31f2582f-3deb-451b-b89e-742aaf12b6dd', 40, 'Uploaded 0 module videos(s) to course module video [test 2]', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location::1', 'Success', '2025-11-28 13:32:51'), (529, 'cab35535-4202-48cf-ac96-3d2f759e97a8', 40, 'Uploaded 46988 podcast(s) to module [podcast to 1]', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-28 14:21:27'), (530, 'fcd292d9-f58f-4a1c-930a-695238aa5306', 40, 'Uploaded 46988 pdf(s) to module [PDFs test to upload]', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-28 14:30:24'), (531, '6c42e981-a1e9-41df-b77d-948ffa63511a', 40, 'Uploaded a note [test for note to see] to module ID 46988', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-28 14:42:48'), (532, 'cef414a0-e29b-4f3e-8c2f-8267197ab2d4', 40, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-28 21:26:30'), (547, 'b82a4c39-4823-42a1-b7fb-39915cb0a990', 46, 'Munachi successfully created an account, Email verification process', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 09:29:47'), (548, 'dcffc674-28ff-4b32-9ba6-8cb8edfcc241', 46, 'Your email verified successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 09:33:21'), (549, 'eda67078-e8b0-402d-917e-9cab3bd4b1f4', 46, 'User reguested new verification code', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 09:35:45'), (550, 'e2d4fb73-8ee5-4979-8c55-4b69b2b063f0', 46, 'Your email verified successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 09:36:37'), (551, '126862dd-5160-49e7-b061-1b803636250d', 46, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 10:11:15'), (552, 'e42f41f5-cb52-4cbb-8f9e-d5e981fd5049', 46, 'student Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 10:11:30'), (553, 'a57e81c5-c92a-4b01-bb92-b25114754af2', 46, 'Profile updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 10:48:26'), (554, 'c6d61bc0-c72c-47e7-9774-72e061e6083e', 46, 'Password changed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 10:51:42'), (555, 'ffde7a4b-8a5f-4881-9570-cc558143f5b6', 46, 'student Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 23:42:12'), (556, '9b08d2c8-940b-464b-b9c4-bc29a6027f04', 46, 'Password changed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 23:49:17'), (557, 'cd7b684b-f8d8-4bea-a55a-e8b582cff1b5', 46, 'Password changed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 23:49:41'), (558, '14d9f3d9-0ba7-42f5-8afb-21f2fb90812d', 46, 'Password changed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-29 23:50:12'), (559, 'b8aed0be-4b8c-4dd6-a4e0-de6a763dee38', 40, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-30 14:43:53'), (560, '1b411328-a002-4d8c-888d-cba6fd113f31', 40, 'User Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-30 14:44:30'), (561, '776139d2-bb6b-457b-986c-ff26be60cce1', 40, 'Uploaded 46988 module videos(s) to course module video [another test for module 1]', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location::1', 'Success', '2025-11-30 21:23:13'), (562, 'a162be4f-a05a-4a4d-9b68-b584104c7af1', 40, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-30 21:56:33'), (563, '030fd019-29f2-46ef-9714-0f5209690688', 46, 'student Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-30 21:57:55'), (564, '8a4b566b-a42b-44ca-a875-3fd0819da4dc', 40, 'User Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-11-30 21:58:54'), (565, '3ae1cead-a76e-4e27-b32b-c0f7046864dd', 46, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 12:47:05'), (566, '089d7fa5-baa6-429b-b698-b5b2383b22d1', 46, 'student Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 12:47:47'), (567, 'efaa9378-6015-47bc-8348-e3a7a7121257', 40, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 13:02:42'), (568, 'e5f70055-e711-4062-9360-af8cf0bfb537', 46, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 13:04:57'), (578, '09d89bd0-16b4-4e00-8641-92c61093ea21', 51, 'Mary successfully created an account, Email verification process', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 14:28:44'), (579, '9193545d-c587-4327-a895-51ada4b46725', 51, 'Your email verified successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 14:29:21'), (580, 'df30f4b2-8136-47d7-b2f7-d5b08d917d7e', 51, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 16:07:23'), (581, 'dbc8146c-38c6-43d6-9e33-c9f091cbb15a', 51, 'student Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 16:07:36'), (582, 'f254ca0e-4a43-4363-9a81-8784def61f32', 51, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 16:55:37'), (583, '5bd2d46e-11ca-491c-8b07-b1bb99563af9', 52, 'Mary successfully created an account, Email verification process', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 16:57:19'), (584, '18c5141c-4b68-4c00-afda-fba8c8456de2', 52, 'Your email verified successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 16:57:46'), (585, '6ab06156-d0b6-4fbb-abd2-c8d78f598ad5', 52, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:02:30'), (586, '2b824345-3620-48ca-8883-a4a63a1da844', 53, 'User successfully created an account, Email verification process', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:02:53'), (587, '5cc9241c-5d0b-453f-89ba-d4a744acbe1b', 53, 'User email verified successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:03:24'), (588, '6bc9a90b-3a84-4812-bfb1-36b72789af56', 53, 'Profile updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:04:11'), (589, 'c2cb8ccb-2d0a-4bf0-83aa-fad9bfe0e5cb', 53, 'User created template successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:04:46'), (590, '656659fe-3d07-490a-9824-1a4a779affdd', 53, 'Uploaded 1 module(s) to course [digital-marketing-pro-92d62d]', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:05:28'), (591, '820f46f2-8626-4f50-bcc9-49fc584ead72', 53, 'Uploaded a note [defwcdwa] to module ID 0', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:05:41'), (592, 'ab2a9609-ced2-4cfe-a60b-6f0d7e989021', 53, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:07:14'), (593, '3abb5ed3-9689-41a3-abbd-67d38a8ded8d', 40, 'User Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:07:17'), (594, 'bba1fcaf-c45f-4b7f-806e-f9afa1c5b19f', 46, 'student Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 17:13:08'), (595, '60444037-b411-4248-b1bb-5666c4d97469', 46, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 18:29:35'), (596, 'c820c884-237e-4e27-af36-5bc75489b0de', 51, 'student Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 18:30:02'), (597, '1404776c-4958-406b-98d0-cd0a7a597525', 51, 'User requested to logout, user Logged Out successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 18:32:24'), (598, 'd61487b3-b477-43d8-ac93-a90f8ba30cd6', 52, 'student Logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', 'Unknown Location', 'Success', '2025-12-01 18:33:20'); -- -------------------------------------------------------- -- -- Table structure for table `user_skills` -- CREATE TABLE `user_skills` ( `id` int(11) NOT NULL, `uuid` varchar(100) DEFAULT NULL, `user_uuid` varchar(110) DEFAULT NULL, `skill_uuid` varchar(110) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `user_skills` -- INSERT INTO `user_skills` (`id`, `uuid`, `user_uuid`, `skill_uuid`) VALUES (47, 'a4f20fa3-2a0f-41f0-8582-ea9704de76a1', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4o'), (48, '0b52fac9-edff-4e0b-a779-e941742670f3', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4g11'), (49, '3222265c-d071-4ae9-aca3-5148f99271e1', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4dk'), (50, '6850fdb0-2703-4fb8-9f12-9b8f06c89288', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4gjs'), (51, 'c08429a9-fbdc-4405-aa5b-2c36cfb4e30a', 'a0416b54-53ff-4511-ad0c-fcc2e45f9db4', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fdet'), (52, 'ae3f011d-a4fc-4279-bb6d-dc263a90fc2b', 'ceb692f7-055d-473e-bb16-b4917cb9427e', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4o'), (53, 'f96ac72e-d40d-4944-a254-7711086f8c50', 'ceb692f7-055d-473e-bb16-b4917cb9427e', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4g11'), (54, 'd7983cda-2de2-458a-a30f-3f2a990ddc9d', 'ceb692f7-055d-473e-bb16-b4917cb9427e', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4dd'), (55, '18f81ba7-6290-4d85-b4ce-e15772260c7a', 'ceb692f7-055d-473e-bb16-b4917cb9427e', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fdhd'), (56, 'b21f1c12-aa0f-43bb-a10f-83138dcdb163', 'ceb692f7-055d-473e-bb16-b4917cb9427e', '5e2f9b8d-67ea-4f72-a70e-ff2da2c1fd4gjs'); -- -------------------------------------------------------- -- -- Table structure for table `withdrawals` -- CREATE TABLE `withdrawals` ( `id` int(11) NOT NULL, `uuid` varchar(110) DEFAULT NULL, `user_uuid` varchar(110) DEFAULT NULL, `amount` decimal(10,2) NOT NULL, `status` enum('pending','approved','rejected') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `assessment_questions` -- ALTER TABLE `assessment_questions` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `assessment_dd_ibfk_1` (`assessment_uuid`); -- -- Indexes for table `assessment_quiz_results` -- ALTER TABLE `assessment_quiz_results` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `assessment_badge_ibfk_1` (`quiz_uuid`), ADD KEY `userpa_ibfk_2v` (`user_uuid`); -- -- Indexes for table `badges` -- ALTER TABLE `badges` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `badge_enrollments` -- ALTER TABLE `badge_enrollments` ADD PRIMARY KEY (`id`), ADD KEY `user_uuid` (`user_uuid`), ADD KEY `course_uuid_igtjb` (`course_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `badge_requirements` -- ALTER TABLE `badge_requirements` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `badge_user_idv` (`badge_uuid`); -- -- Indexes for table `badge_user_points` -- ALTER TABLE `badge_user_points` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `badge_user_id` (`user_uuid`); -- -- Indexes for table `banks` -- ALTER TABLE `banks` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `user_id` (`user_uuid`), ADD KEY `idx_uuid` (`uuid`); -- -- Indexes for table `certificates` -- ALTER TABLE `certificates` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `certificate_code` (`certificate_code`), ADD KEY `certificates_student_ibfk_2` (`student_uuid`), ADD KEY `uuid` (`uuid`), ADD KEY `certificates_course_ibfk_2` (`course_uuid`); -- -- Indexes for table `chat_messages` -- ALTER TABLE `chat_messages` ADD PRIMARY KEY (`id`), ADD KEY `idx_uuid` (`uuid`), ADD KEY `sender_index_jsd` (`sender_uuid`), ADD KEY `receievef_wenrws` (`receiver_uuid`); -- -- Indexes for table `contact` -- ALTER TABLE `contact` ADD KEY `user_id_jdf` (`user_id`), ADD KEY `idx_uuid` (`uuid`); -- -- Indexes for table `courses` -- ALTER TABLE `courses` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `course_cat_rhr` (`category_uuid`), ADD KEY `user_ment_idndj` (`tutor_user_uuid`), ADD KEY `tutor_dis` (`tutor_uuid`), ADD KEY `template_id_me` (`template_uuid`); -- -- Indexes for table `course_activity_logs` -- ALTER TABLE `course_activity_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_uuid` (`uuid`), ADD KEY `course_activity_log_user_1` (`user_uuid`), ADD KEY `course_activity_logs_ibfkr_2` (`module_uuid`), ADD KEY `course_activity_logs_ibfdk_3` (`course_uuid`), ADD KEY `course_activity_logs_ibfdtk_4` (`video_uuid`); -- -- Indexes for table `course_assessments` -- ALTER TABLE `course_assessments` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `modules_idsdvb` (`module_uuid`); -- -- Indexes for table `course_categories` -- ALTER TABLE `course_categories` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `course_comments` -- ALTER TABLE `course_comments` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uuid` (`uuid`), ADD KEY `course_uuid` (`course_uuid`), ADD KEY `students_ibfk_22` (`student_uuid`); -- -- Indexes for table `course_comments_replies` -- ALTER TABLE `course_comments_replies` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uuid` (`uuid`), ADD KEY `comment_uuid` (`comment_uuid`), ADD KEY `tutor_user_id_ifjrg` (`tutor_uuid`); -- -- Indexes for table `course_modules` -- ALTER TABLE `course_modules` ADD PRIMARY KEY (`id`), ADD KEY `course_idhed` (`course_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `course_notes` -- ALTER TABLE `course_notes` ADD PRIMARY KEY (`id`), ADD KEY `course_notes_ibfk_1` (`module_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `course_pdfs` -- ALTER TABLE `course_pdfs` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `module_uuid` (`module_uuid`); -- -- Indexes for table `course_podcasts` -- ALTER TABLE `course_podcasts` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `modules_idsd` (`module_uuid`); -- -- Indexes for table `course_progress` -- ALTER TABLE `course_progress` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `course_id` (`course_uuid`), ADD KEY `tutor_hsjddhesb` (`tutor_user_uuid`), ADD KEY `student_uuid` (`student_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `course_progress_tracking` -- ALTER TABLE `course_progress_tracking` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `student_id` (`student_uuid`,`item_type`,`item_id`), ADD KEY `fk_progress_course` (`course_uuid`), ADD KEY `fk_progress_module` (`module_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `course_templates` -- ALTER TABLE `course_templates` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `skill_uuid_shzb` (`skill_uuid`), ADD KEY `category_uuid` (`category_uuid`); -- -- Indexes for table `course_videos` -- ALTER TABLE `course_videos` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `modules_idsdvb_video` (`module_uuid`), ADD KEY `user_side_huj` (`uploaded_by`); -- -- Indexes for table `currency_rates_cache` -- ALTER TABLE `currency_rates_cache` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `earnings` -- ALTER TABLE `earnings` ADD PRIMARY KEY (`id`), ADD KEY `idx_uuid` (`uuid`), ADD KEY `user_uuid` (`user_uuid`), ADD KEY `course_uuid` (`course_uuid`); -- -- Indexes for table `edit_course_approval_requests` -- ALTER TABLE `edit_course_approval_requests` ADD PRIMARY KEY (`id`), ADD KEY `tutor_user_odi` (`tutor_user_uuid`), ADD KEY `course_approval_ibfk_2` (`course_uuid`); -- -- Indexes for table `faq_categories` -- ALTER TABLE `faq_categories` ADD PRIMARY KEY (`id`), ADD KEY `idx_uuid` (`uuid`); -- -- Indexes for table `faq_items` -- ALTER TABLE `faq_items` ADD PRIMARY KEY (`id`), ADD KEY `idx_uuid` (`uuid`), ADD KEY `faq_items_ibfk_1` (`category_uuid`); -- -- Indexes for table `giftcards` -- ALTER TABLE `giftcards` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `code` (`code`), ADD KEY `giftcards_ibfk_1` (`user_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`), ADD KEY `notifications_ibfk_1` (`user_uuid`), ADD KEY `idx_uuid` (`uuid`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `students_ibfk_11ed` (`student_uuid`), ADD KEY `tutor_hsjdd` (`tutor_uuid`), ADD KEY `course_jhpsfg` (`course_uuid`); -- -- Indexes for table `skills` -- ALTER TABLE `skills` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `social_handles` -- ALTER TABLE `social_handles` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `social_handles_ibfk_1` (`user_uuid`); -- -- Indexes for table `students` -- ALTER TABLE `students` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `user_ibfk_2g` (`user_uuid`); -- -- Indexes for table `student_answers` -- ALTER TABLE `student_answers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_answer` (`student_uuid`,`question_uuid`), ADD KEY `fk_course` (`course_uuid`), ADD KEY `fk_module` (`module_uuid`), ADD KEY `fk_assessment` (`assessment_uuid`), ADD KEY `fk_question` (`question_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `study_logs` -- ALTER TABLE `study_logs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `student_id` (`student_uuid`), ADD UNIQUE KEY `course_id` (`course_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `support_replies` -- ALTER TABLE `support_replies` ADD PRIMARY KEY (`id`), ADD KEY `fk_sender_uuid` (`sender_uuid`), ADD KEY `support_ticket` (`ticket_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `support_tickets` -- ALTER TABLE `support_tickets` ADD PRIMARY KEY (`id`), ADD KEY `user_iduu` (`user_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `transaction_ref` (`transaction_ref`), ADD KEY `student_uuid` (`student_uuid`), ADD KEY `order_uuid_kjb` (`order_uuid`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `tutors` -- ALTER TABLE `tutors` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `user_id_jdfse` (`user_uuid`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`); -- -- Indexes for table `user_badges` -- ALTER TABLE `user_badges` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `user_badge_unique` (`user_id`,`badge_id`), ADD KEY `user_badges_ibfk_1` (`badge_id`); -- -- Indexes for table `user_logs` -- ALTER TABLE `user_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_uuid` (`uuid`), ADD KEY `user_log_ibfcg` (`user_id`); -- -- Indexes for table `user_skills` -- ALTER TABLE `user_skills` ADD PRIMARY KEY (`id`), ADD KEY `user_uuid_jdfs` (`user_uuid`), ADD KEY `skill_by_user` (`skill_uuid`), ADD KEY `idx_uuid` (`uuid`); -- -- Indexes for table `withdrawals` -- ALTER TABLE `withdrawals` ADD PRIMARY KEY (`id`), ADD KEY `user_id_withdraw` (`user_uuid`), ADD KEY `uuid` (`uuid`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `assessment_questions` -- ALTER TABLE `assessment_questions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `assessment_quiz_results` -- ALTER TABLE `assessment_quiz_results` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `badges` -- ALTER TABLE `badges` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `badge_enrollments` -- ALTER TABLE `badge_enrollments` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `badge_requirements` -- ALTER TABLE `badge_requirements` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `badge_user_points` -- ALTER TABLE `badge_user_points` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `banks` -- ALTER TABLE `banks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `certificates` -- ALTER TABLE `certificates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `chat_messages` -- ALTER TABLE `chat_messages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `courses` -- ALTER TABLE `courses` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT for table `course_activity_logs` -- ALTER TABLE `course_activity_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `course_assessments` -- ALTER TABLE `course_assessments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `course_categories` -- ALTER TABLE `course_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `course_comments` -- ALTER TABLE `course_comments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `course_comments_replies` -- ALTER TABLE `course_comments_replies` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `course_modules` -- ALTER TABLE `course_modules` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `course_notes` -- ALTER TABLE `course_notes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `course_pdfs` -- ALTER TABLE `course_pdfs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `course_podcasts` -- ALTER TABLE `course_podcasts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `course_progress` -- ALTER TABLE `course_progress` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49; -- -- AUTO_INCREMENT for table `course_progress_tracking` -- ALTER TABLE `course_progress_tracking` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76; -- -- AUTO_INCREMENT for table `course_templates` -- ALTER TABLE `course_templates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `course_videos` -- ALTER TABLE `course_videos` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `currency_rates_cache` -- ALTER TABLE `currency_rates_cache` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `earnings` -- ALTER TABLE `earnings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `edit_course_approval_requests` -- ALTER TABLE `edit_course_approval_requests` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `faq_categories` -- ALTER TABLE `faq_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `faq_items` -- ALTER TABLE `faq_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `giftcards` -- ALTER TABLE `giftcards` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `notifications` -- ALTER TABLE `notifications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `skills` -- ALTER TABLE `skills` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `social_handles` -- ALTER TABLE `social_handles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97; -- -- AUTO_INCREMENT for table `students` -- ALTER TABLE `students` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `student_answers` -- ALTER TABLE `student_answers` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `study_logs` -- ALTER TABLE `study_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `support_replies` -- ALTER TABLE `support_replies` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `support_tickets` -- ALTER TABLE `support_tickets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `tutors` -- ALTER TABLE `tutors` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54; -- -- AUTO_INCREMENT for table `user_badges` -- ALTER TABLE `user_badges` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100; -- -- AUTO_INCREMENT for table `user_logs` -- ALTER TABLE `user_logs` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=599; -- -- AUTO_INCREMENT for table `user_skills` -- ALTER TABLE `user_skills` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57; -- -- AUTO_INCREMENT for table `withdrawals` -- ALTER TABLE `withdrawals` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- Constraints for dumped tables -- -- -- Constraints for table `assessment_questions` -- ALTER TABLE `assessment_questions` ADD CONSTRAINT `assessment_dd_ibfk_1` FOREIGN KEY (`assessment_uuid`) REFERENCES `course_assessments` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `assessment_quiz_results` -- ALTER TABLE `assessment_quiz_results` ADD CONSTRAINT `assessment_badge_ibfk_1` FOREIGN KEY (`quiz_uuid`) REFERENCES `course_assessments` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `userpa_ibfk_2v` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `badge_enrollments` -- ALTER TABLE `badge_enrollments` ADD CONSTRAINT `course_uuid_igtjb` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `user_uuid` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`); -- -- Constraints for table `badge_requirements` -- ALTER TABLE `badge_requirements` ADD CONSTRAINT `badge_user_idv` FOREIGN KEY (`badge_uuid`) REFERENCES `badges` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `badge_user_points` -- ALTER TABLE `badge_user_points` ADD CONSTRAINT `badge_user_id` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `banks` -- ALTER TABLE `banks` ADD CONSTRAINT `user_idebd` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `certificates` -- ALTER TABLE `certificates` ADD CONSTRAINT `certificates_course_ibfk_2` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `certificates_student_ibfk_2` FOREIGN KEY (`student_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `chat_messages` -- ALTER TABLE `chat_messages` ADD CONSTRAINT `receievef_wenrws` FOREIGN KEY (`receiver_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `sender_index_jsd` FOREIGN KEY (`sender_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `contact` -- ALTER TABLE `contact` ADD CONSTRAINT `user_id_jdf` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `courses` -- ALTER TABLE `courses` ADD CONSTRAINT `course_cat_rhr` FOREIGN KEY (`category_uuid`) REFERENCES `course_categories` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `template_id_me` FOREIGN KEY (`template_uuid`) REFERENCES `course_templates` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `tutor_dis` FOREIGN KEY (`tutor_uuid`) REFERENCES `tutors` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `user_ment_idndj` FOREIGN KEY (`tutor_user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_activity_logs` -- ALTER TABLE `course_activity_logs` ADD CONSTRAINT `course_activity_log_user_1` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `course_activity_logs_ibfdk_3` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `course_activity_logs_ibfdtk_4` FOREIGN KEY (`video_uuid`) REFERENCES `course_videos` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `course_activity_logs_ibfkr_2` FOREIGN KEY (`module_uuid`) REFERENCES `course_modules` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_assessments` -- ALTER TABLE `course_assessments` ADD CONSTRAINT `modules_idsdvb` FOREIGN KEY (`module_uuid`) REFERENCES `course_modules` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_comments` -- ALTER TABLE `course_comments` ADD CONSTRAINT `course_uuid` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `students_ibfk_22` FOREIGN KEY (`student_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_comments_replies` -- ALTER TABLE `course_comments_replies` ADD CONSTRAINT `course_comments_replies_ibfk_1` FOREIGN KEY (`comment_uuid`) REFERENCES `course_comments` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `tutor_user_id_ifjrg` FOREIGN KEY (`tutor_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_modules` -- ALTER TABLE `course_modules` ADD CONSTRAINT `course_idhed` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_notes` -- ALTER TABLE `course_notes` ADD CONSTRAINT `course_notes_ibfk_1` FOREIGN KEY (`module_uuid`) REFERENCES `course_modules` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_pdfs` -- ALTER TABLE `course_pdfs` ADD CONSTRAINT `modules_idsdv` FOREIGN KEY (`module_uuid`) REFERENCES `course_modules` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_podcasts` -- ALTER TABLE `course_podcasts` ADD CONSTRAINT `modules_idsd` FOREIGN KEY (`module_uuid`) REFERENCES `course_modules` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_progress` -- ALTER TABLE `course_progress` ADD CONSTRAINT `course_unfjna` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `student_heefjhr4` FOREIGN KEY (`student_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `tutor_hsjddhesb` FOREIGN KEY (`tutor_user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_progress_tracking` -- ALTER TABLE `course_progress_tracking` ADD CONSTRAINT `fk_progress_course` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `fk_progress_module` FOREIGN KEY (`module_uuid`) REFERENCES `course_modules` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `student_id` FOREIGN KEY (`student_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_templates` -- ALTER TABLE `course_templates` ADD CONSTRAINT `category_uuid` FOREIGN KEY (`category_uuid`) REFERENCES `course_categories` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `skill_uuid_shzb` FOREIGN KEY (`skill_uuid`) REFERENCES `skills` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `course_videos` -- ALTER TABLE `course_videos` ADD CONSTRAINT `modules_idsdvb_video` FOREIGN KEY (`module_uuid`) REFERENCES `course_modules` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `user_side_huj` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `earnings` -- ALTER TABLE `earnings` ADD CONSTRAINT `earning_course_jhu` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `earnings_ibfk_2h` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `edit_course_approval_requests` -- ALTER TABLE `edit_course_approval_requests` ADD CONSTRAINT `course_approval_ibfk_2` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `tutor_user_odi` FOREIGN KEY (`tutor_user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `faq_items` -- ALTER TABLE `faq_items` ADD CONSTRAINT `faq_items_ibfk_1` FOREIGN KEY (`category_uuid`) REFERENCES `faq_categories` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `giftcards` -- ALTER TABLE `giftcards` ADD CONSTRAINT `giftcards_ibfk_1` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `notifications` -- ALTER TABLE `notifications` ADD CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `orders` -- ALTER TABLE `orders` ADD CONSTRAINT `course_jhpsfg` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `students_ibfk_11ed` FOREIGN KEY (`student_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `tutor_hsjdd` FOREIGN KEY (`tutor_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `social_handles` -- ALTER TABLE `social_handles` ADD CONSTRAINT `social_handles_ibfk_1` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`); -- -- Constraints for table `students` -- ALTER TABLE `students` ADD CONSTRAINT `user_ibfk_2g` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `student_answers` -- ALTER TABLE `student_answers` ADD CONSTRAINT `fk_assessment` FOREIGN KEY (`assessment_uuid`) REFERENCES `course_assessments` (`uuid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_course` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_module` FOREIGN KEY (`module_uuid`) REFERENCES `course_modules` (`uuid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_question` FOREIGN KEY (`question_uuid`) REFERENCES `assessment_questions` (`uuid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_student` FOREIGN KEY (`student_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE; -- -- Constraints for table `study_logs` -- ALTER TABLE `study_logs` ADD CONSTRAINT `course_id` FOREIGN KEY (`course_uuid`) REFERENCES `courses` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `students_ibfk_2g` FOREIGN KEY (`student_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `support_replies` -- ALTER TABLE `support_replies` ADD CONSTRAINT `fk_sender_uuid` FOREIGN KEY (`sender_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `support_ticket` FOREIGN KEY (`ticket_uuid`) REFERENCES `support_tickets` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `support_tickets` -- ALTER TABLE `support_tickets` ADD CONSTRAINT `user_iduu` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `transactions` -- ALTER TABLE `transactions` ADD CONSTRAINT `order_uuid_kjb` FOREIGN KEY (`order_uuid`) REFERENCES `orders` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `student_user_jhbo` FOREIGN KEY (`student_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `tutors` -- ALTER TABLE `tutors` ADD CONSTRAINT `user_id_jdfse` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `user_badges` -- ALTER TABLE `user_badges` ADD CONSTRAINT `user_badges_ibfk_1` FOREIGN KEY (`badge_id`) REFERENCES `badges` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `user_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `user_logs` -- ALTER TABLE `user_logs` ADD CONSTRAINT `user_log_ibfcg` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `user_skills` -- ALTER TABLE `user_skills` ADD CONSTRAINT `skill_by_user` FOREIGN KEY (`skill_uuid`) REFERENCES `skills` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `user_uuid_jdfs` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `withdrawals` -- ALTER TABLE `withdrawals` ADD CONSTRAINT `user_id_withdraw` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; -- ---f######################################################################################