-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- 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 `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 `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 `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 `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 `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 `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 `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;



-- ---f######################################################################################
