-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------


-- Dumping structure for table academy.activity_log
CREATE TABLE IF NOT EXISTS `activity_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject_id` bigint unsigned DEFAULT NULL,
  `causer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `causer_id` bigint unsigned DEFAULT NULL,
  `properties` json DEFAULT NULL,
  `batch_uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject` (`subject_type`,`subject_id`),
  KEY `causer` (`causer_type`,`causer_id`),
  KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.activity_log: ~11 rows (approximately)
INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `event`, `subject_id`, `causer_type`, `causer_id`, `properties`, `batch_uuid`, `created_at`, `updated_at`) VALUES
	(1, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-04 06:44:40', '2025-11-04 06:44:40'),
	(2, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-04 14:36:17', '2025-11-04 14:36:17'),
	(3, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-05 07:09:45', '2025-11-05 07:09:45'),
	(4, 'Resource', 'Enrollment Created by Academy Admin', 'App\\Models\\Enrollment', 'Created', 4, 'App\\Models\\User', 1, '{"id": 4, "status": "active", "user_id": 1, "course_id": 6, "created_at": "2025-11-05 10:10:24", "updated_at": "2025-11-05 10:10:24", "enrolled_at": "2025-11-05 10:10:11", "paid_amount": 0, "payment_status": "paid"}', NULL, '2025-11-05 07:10:24', '2025-11-05 07:10:24'),
	(5, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-05 08:31:48', '2025-11-05 08:31:48'),
	(6, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-05 08:33:02', '2025-11-05 08:33:02'),
	(7, 'Resource', 'Enrollment Created by Academy Admin', 'App\\Models\\Enrollment', 'Created', 5, 'App\\Models\\User', 1, '{"id": 5, "status": "pending", "user_id": 1, "course_id": 1, "created_at": "2025-11-05 11:50:30", "updated_at": "2025-11-05 11:50:30", "enrolled_at": "2025-11-05 11:50:30", "paid_amount": "99.99", "payment_status": "pending"}', NULL, '2025-11-05 08:50:30', '2025-11-05 08:50:30'),
	(8, 'Resource', 'Payment Created by Academy Admin', 'App\\Models\\Payment', 'Created', 3, 'App\\Models\\User', 1, '{"id": 3, "amount": "99.99", "status": "pending", "user_id": 1, "currency": "USD", "course_id": 1, "created_at": "2025-11-05 11:50:30", "updated_at": "2025-11-05 11:50:30", "enrollment_id": 5, "payment_method": "manual", "transaction_id": "manual_690b3a0672be5", "gateway_response": "\\"{\\\\\\"status\\\\\\":\\\\\\"pending_admin_approval\\\\\\",\\\\\\"notes\\\\\\":\\\\\\"Manual payment - pending admin approval\\\\\\"}\\""}', NULL, '2025-11-05 08:50:30', '2025-11-05 08:50:30'),
	(9, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"status": "active", "payment_status": "paid"}', NULL, '2025-11-05 08:50:30', '2025-11-05 08:50:30'),
	(10, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"total_lessons": 5}', NULL, '2025-11-05 08:50:30', '2025-11-05 08:50:30'),
	(11, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"total_lessons": 5}', NULL, '2025-11-05 08:50:30', '2025-11-05 08:50:30'),
	(12, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-05 12:43:38', '2025-11-05 12:43:38'),
	(13, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-07 02:04:53', '2025-11-07 02:04:53'),
	(14, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-07 02:10:09', '2025-11-07 02:10:09'),
	(15, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-07 12:29:40', '2025-11-07 12:29:40'),
	(16, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-07 18:27:28", "progress_percentage": 10}', NULL, '2025-11-07 15:27:28', '2025-11-07 15:27:28'),
	(17, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-07 18:27:28", "progress_percentage": 10}', NULL, '2025-11-07 15:27:28', '2025-11-07 15:27:28'),
	(18, 'Resource', 'Course Updated by Academy Admin', 'App\\Models\\Course', 'Updated', 6, 'App\\Models\\User', 1, '{"updated_at": "2025-11-07 18:48:18", "short_description": "{\\"ar\\":\\"ابدأ رحلتك في البرمجة من هنا.\\",\\"en\\":\\"Learn the fundamentals of programming with practical examples and exercises.\\"}"}', NULL, '2025-11-07 15:48:18', '2025-11-07 15:48:18'),
	(19, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-08 02:27:06', '2025-11-08 02:27:06'),
	(20, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-08 07:04:10', '2025-11-08 07:04:10'),
	(21, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-08 07:05:52', '2025-11-08 07:05:52'),
	(22, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-08 10:43:30', '2025-11-08 10:43:30'),
	(23, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-08 10:43:30', '2025-11-08 10:43:30'),
	(24, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 2, 'App\\Models\\User', 1, '{"title": "{\\"en\\":\\"HTML Document Structure\\",\\"ar\\":\\"HTML Document Structure\\"}", "updated_at": "2025-11-08 14:31:05", "description": "{\\"en\\":\\"Understanding the basic structure of an HTML document\\",\\"ar\\":\\"Understanding the basic structure of an HTML document\\"}", "content_data": "{\\"path\\":\\"lessons\\\\/documents\\\\/01K9HY1GDJ62QNDTAB48ENY3Q0.pdf\\",\\"content\\":\\"<h1>HTML Document Structure<\\\\/h1><p>Every HTML document follows a standard structure...<\\\\/p>\\"}"}', NULL, '2025-11-08 11:31:05', '2025-11-08 11:31:05'),
	(25, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 2, 'App\\Models\\User', 1, '{"title": "{\\"en\\":\\"HTML Document Structure\\",\\"ar\\":\\"HTML Document Structure\\"}", "updated_at": "2025-11-08 14:31:05", "description": "{\\"en\\":\\"Understanding the basic structure of an HTML document\\",\\"ar\\":\\"Understanding the basic structure of an HTML document\\"}", "content_data": "{\\"path\\":\\"lessons\\\\/documents\\\\/01K9HY1GDJ62QNDTAB48ENY3Q0.pdf\\",\\"content\\":\\"<h1>HTML Document Structure<\\\\/h1><p>Every HTML document follows a standard structure...<\\\\/p>\\"}"}', NULL, '2025-11-08 11:31:05', '2025-11-08 11:31:05'),
	(26, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 2, 'App\\Models\\User', 1, '{"updated_at": "2025-11-08 14:33:14", "content_data": "{\\"path\\":\\"lessons\\\\/documents\\\\/01K9HY5E0CTJVPG8D31VE0EHM9.pdf\\",\\"content\\":\\"<h1>HTML Document Structure<\\\\/h1><p>Every HTML document follows a standard structure...<\\\\/p>\\"}"}', NULL, '2025-11-08 11:33:14', '2025-11-08 11:33:14'),
	(27, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 2, 'App\\Models\\User', 1, '{"updated_at": "2025-11-08 14:33:14", "content_data": "{\\"path\\":\\"lessons\\\\/documents\\\\/01K9HY5E0CTJVPG8D31VE0EHM9.pdf\\",\\"content\\":\\"<h1>HTML Document Structure<\\\\/h1><p>Every HTML document follows a standard structure...<\\\\/p>\\"}"}', NULL, '2025-11-08 11:33:14', '2025-11-08 11:33:14'),
	(28, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 2, 'App\\Models\\User', 1, '{"updated_at": "2025-11-08 14:41:13", "content_data": "{\\"path\\":null,\\"content\\":\\"<h1>HTML Document Structure<\\\\/h1><p>Every HTML document follows a standard structure...<\\\\/p>\\"}"}', NULL, '2025-11-08 11:41:13', '2025-11-08 11:41:13'),
	(29, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 2, 'App\\Models\\User', 1, '{"updated_at": "2025-11-08 14:41:13", "content_data": "{\\"path\\":null,\\"content\\":\\"<h1>HTML Document Structure<\\\\/h1><p>Every HTML document follows a standard structure...<\\\\/p>\\"}"}', NULL, '2025-11-08 11:41:13', '2025-11-08 11:41:13'),
	(30, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 2, 'App\\Models\\User', 1, '{"updated_at": "2025-11-08 14:46:07", "content_data": "{\\"path\\":\\"lessons\\\\/documents\\\\/01K9HYX1263CR52YH4KRZB7J3J.pdf\\",\\"content\\":\\"<h1>HTML Document Structure<\\\\/h1><p>Every HTML document follows a standard structure...<\\\\/p>\\"}"}', NULL, '2025-11-08 11:46:07', '2025-11-08 11:46:07'),
	(31, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 2, 'App\\Models\\User', 1, '{"updated_at": "2025-11-08 14:46:07", "content_data": "{\\"path\\":\\"lessons\\\\/documents\\\\/01K9HYX1263CR52YH4KRZB7J3J.pdf\\",\\"content\\":\\"<h1>HTML Document Structure<\\\\/h1><p>Every HTML document follows a standard structure...<\\\\/p>\\"}"}', NULL, '2025-11-08 11:46:07', '2025-11-08 11:46:07'),
	(32, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-09 02:14:02', '2025-11-09 02:14:02'),
	(33, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 5, 'App\\Models\\User', 1, '{"title": "{\\"en\\":\\"Build a Calculator\\",\\"ar\\":\\"Build a Calculator\\"}", "updated_at": "2025-11-09 05:34:34", "description": "{\\"en\\":\\"Create a functional calculator using JavaScript\\",\\"ar\\":\\"Create a functional calculator using JavaScript\\"}", "content_data": "{\\"details\\":{\\"en\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\",\\"ar\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\"},\\"max_points\\":100,\\"due_days\\":7,\\"allow_file_upload\\":true,\\"allow_text_submission\\":true,\\"rubric\\":{\\"en\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\",\\"ar\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\"}}"}', NULL, '2025-11-09 02:34:34', '2025-11-09 02:34:34'),
	(34, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 5, 'App\\Models\\User', 1, '{"title": "{\\"en\\":\\"Build a Calculator\\",\\"ar\\":\\"Build a Calculator\\"}", "updated_at": "2025-11-09 05:34:34", "description": "{\\"en\\":\\"Create a functional calculator using JavaScript\\",\\"ar\\":\\"Create a functional calculator using JavaScript\\"}", "content_data": "{\\"details\\":{\\"en\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\",\\"ar\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\"},\\"max_points\\":100,\\"due_days\\":7,\\"allow_file_upload\\":true,\\"allow_text_submission\\":true,\\"rubric\\":{\\"en\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\",\\"ar\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\"}}"}', NULL, '2025-11-09 02:34:34', '2025-11-09 02:34:34'),
	(35, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 06:02:46", "completed_lessons": 1, "progress_percentage": 20}', NULL, '2025-11-09 03:02:46', '2025-11-09 03:02:46'),
	(36, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 06:07:57", "content_data": "{\\"details\\":{\\"en\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\",\\"ar\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\"},\\"max_points\\":100,\\"due_days\\":7,\\"allow_file_upload\\":true,\\"allow_text_submission\\":false,\\"rubric\\":{\\"en\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\",\\"ar\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\"}}"}', NULL, '2025-11-09 03:07:57', '2025-11-09 03:07:57'),
	(37, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 06:07:57", "content_data": "{\\"details\\":{\\"en\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\",\\"ar\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\"},\\"max_points\\":100,\\"due_days\\":7,\\"allow_file_upload\\":true,\\"allow_text_submission\\":false,\\"rubric\\":{\\"en\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\",\\"ar\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\"}}"}', NULL, '2025-11-09 03:07:57', '2025-11-09 03:07:57'),
	(38, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 06:19:06", "content_data": "{\\"details\\":{\\"en\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\",\\"ar\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\"},\\"max_points\\":100,\\"due_days\\":7,\\"allow_file_upload\\":true,\\"allow_text_submission\\":true,\\"allow_multiple_attempts\\":true,\\"rubric\\":{\\"en\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\",\\"ar\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\"}}"}', NULL, '2025-11-09 03:19:06', '2025-11-09 03:19:06'),
	(39, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 06:19:06", "content_data": "{\\"details\\":{\\"en\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\",\\"ar\\":\\"<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.<\\\\/p><p><br><\\\\/p>\\"},\\"max_points\\":100,\\"due_days\\":7,\\"allow_file_upload\\":true,\\"allow_text_submission\\":true,\\"allow_multiple_attempts\\":true,\\"rubric\\":{\\"en\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\",\\"ar\\":\\"Functionality (40%), Code quality (30%), UI\\\\/UX (20%), Documentation (10%)\\\\n\\\\n\\"}}"}', NULL, '2025-11-09 03:19:06', '2025-11-09 03:19:06'),
	(40, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 4, 'App\\Models\\User', 1, '{"title": "{\\"en\\":\\"JavaScript Fundamentals Quiz\\",\\"ar\\":\\"JavaScript Fundamentals Quiz\\"}", "updated_at": "2025-11-09 06:45:59", "description": "{\\"en\\":\\"Test your knowledge of JavaScript basics\\",\\"ar\\":\\"Test your knowledge of JavaScript basics\\"}", "content_data": "{\\"questions\\":[{\\"question\\":{\\"en\\":\\"What is JavaScript?\\",\\"ar\\":\\"What is JavaScript?\\"},\\"options\\":{\\"en\\":[{\\"option\\":\\"A programming language\\"},{\\"option\\":\\"A markup language\\"},{\\"option\\":\\"A styling language\\"},{\\"option\\":\\"A database\\"}],\\"ar\\":[{\\"option\\":\\"A programming language\\"},{\\"option\\":\\"A markup language\\"},{\\"option\\":\\"A styling language\\"},{\\"option\\":\\"A database\\"}]},\\"explanation\\":{\\"en\\":null,\\"ar\\":null},\\"correct_answer\\":0,\\"points\\":1}],\\"passing_score\\":70,\\"randomize_questions\\":false}"}', NULL, '2025-11-09 03:45:59', '2025-11-09 03:45:59'),
	(41, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 4, 'App\\Models\\User', 1, '{"title": "{\\"en\\":\\"JavaScript Fundamentals Quiz\\",\\"ar\\":\\"JavaScript Fundamentals Quiz\\"}", "updated_at": "2025-11-09 06:45:59", "description": "{\\"en\\":\\"Test your knowledge of JavaScript basics\\",\\"ar\\":\\"Test your knowledge of JavaScript basics\\"}", "content_data": "{\\"questions\\":[{\\"question\\":{\\"en\\":\\"What is JavaScript?\\",\\"ar\\":\\"What is JavaScript?\\"},\\"options\\":{\\"en\\":[{\\"option\\":\\"A programming language\\"},{\\"option\\":\\"A markup language\\"},{\\"option\\":\\"A styling language\\"},{\\"option\\":\\"A database\\"}],\\"ar\\":[{\\"option\\":\\"A programming language\\"},{\\"option\\":\\"A markup language\\"},{\\"option\\":\\"A styling language\\"},{\\"option\\":\\"A database\\"}]},\\"explanation\\":{\\"en\\":null,\\"ar\\":null},\\"correct_answer\\":0,\\"points\\":1}],\\"passing_score\\":70,\\"randomize_questions\\":false}"}', NULL, '2025-11-09 03:45:59', '2025-11-09 03:45:59'),
	(42, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 4, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 06:48:13", "content_data": "{\\"questions\\":[{\\"question\\":{\\"en\\":\\"What is JavaScript?\\",\\"ar\\":\\"What is JavaScript?\\"},\\"options\\":{\\"en\\":[\\"A programming language\\",\\"A markup language\\",\\"A styling language\\",\\"A database\\"],\\"ar\\":[\\"A programming language\\",\\"A markup language\\",\\"A styling language\\",\\"A database\\"]},\\"explanation\\":{\\"en\\":null,\\"ar\\":null},\\"correct_answer\\":{\\"en\\":0,\\"ar\\":0},\\"points\\":1}],\\"passing_score\\":70,\\"randomize_questions\\":false}"}', NULL, '2025-11-09 03:48:13', '2025-11-09 03:48:13'),
	(43, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 4, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 06:48:13", "content_data": "{\\"questions\\":[{\\"question\\":{\\"en\\":\\"What is JavaScript?\\",\\"ar\\":\\"What is JavaScript?\\"},\\"options\\":{\\"en\\":[\\"A programming language\\",\\"A markup language\\",\\"A styling language\\",\\"A database\\"],\\"ar\\":[\\"A programming language\\",\\"A markup language\\",\\"A styling language\\",\\"A database\\"]},\\"explanation\\":{\\"en\\":null,\\"ar\\":null},\\"correct_answer\\":{\\"en\\":0,\\"ar\\":0},\\"points\\":1}],\\"passing_score\\":70,\\"randomize_questions\\":false}"}', NULL, '2025-11-09 03:48:13', '2025-11-09 03:48:13'),
	(44, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 07:34:51", "completed_lessons": 2, "progress_percentage": 40}', NULL, '2025-11-09 04:34:51', '2025-11-09 04:34:51'),
	(45, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 1, 'App\\Models\\User', 1, '{"title": "{\\"en\\":\\"Introduction to HTML\\",\\"ar\\":\\"Introduction to HTML\\"}", "updated_at": "2025-11-09 07:52:10", "description": "{\\"en\\":\\"Learn what HTML is and why it\'s important\\",\\"ar\\":\\"Learn what HTML is and why it\'s important\\"}", "content_data": "{\\"url\\":\\"https:\\\\/\\\\/www.youtube.com\\\\/watch?v=cNLG7n9OlGM\\"}"}', NULL, '2025-11-09 04:52:10', '2025-11-09 04:52:10'),
	(46, 'Resource', 'Lesson Updated by Academy Admin', 'App\\Models\\Lesson', 'Updated', 1, 'App\\Models\\User', 1, '{"title": "{\\"en\\":\\"Introduction to HTML\\",\\"ar\\":\\"Introduction to HTML\\"}", "updated_at": "2025-11-09 07:52:10", "description": "{\\"en\\":\\"Learn what HTML is and why it\'s important\\",\\"ar\\":\\"Learn what HTML is and why it\'s important\\"}", "content_data": "{\\"url\\":\\"https:\\\\/\\\\/www.youtube.com\\\\/watch?v=cNLG7n9OlGM\\"}"}', NULL, '2025-11-09 04:52:10', '2025-11-09 04:52:10'),
	(47, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 08:00:15", "completed_lessons": 3, "progress_percentage": 60}', NULL, '2025-11-09 05:00:15', '2025-11-09 05:00:15'),
	(48, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 08:00:31", "completed_lessons": 4, "progress_percentage": 80}', NULL, '2025-11-09 05:00:31', '2025-11-09 05:00:31'),
	(49, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"status": "completed", "updated_at": "2025-11-09 08:00:46", "completed_at": "2025-11-09 08:00:46", "completed_lessons": 5, "progress_percentage": 100}', NULL, '2025-11-09 05:00:46', '2025-11-09 05:00:46'),
	(50, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-09 07:19:01', '2025-11-09 07:19:01'),
	(51, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 4, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 10:45:23", "total_lessons": 2}', NULL, '2025-11-09 07:45:23', '2025-11-09 07:45:23'),
	(52, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 4, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 10:45:38", "completed_lessons": 1, "progress_percentage": 50}', NULL, '2025-11-09 07:45:38', '2025-11-09 07:45:38'),
	(53, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 12:53:38", "completed_at": "2025-11-09 12:53:38"}', NULL, '2025-11-09 09:53:38', '2025-11-09 09:53:38'),
	(54, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 12:53:44", "completed_at": "2025-11-09 12:53:44"}', NULL, '2025-11-09 09:53:44', '2025-11-09 09:53:44'),
	(55, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 12:53:47", "completed_at": "2025-11-09 12:53:47"}', NULL, '2025-11-09 09:53:47', '2025-11-09 09:53:47'),
	(56, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 12:54:24", "completed_at": "2025-11-09 12:54:24"}', NULL, '2025-11-09 09:54:24', '2025-11-09 09:54:24'),
	(57, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 12:59:07", "completed_at": "2025-11-09 12:59:07"}', NULL, '2025-11-09 09:59:07', '2025-11-09 09:59:07'),
	(58, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"status": "active", "updated_at": "2025-11-09 13:27:21", "completed_at": null, "completed_lessons": 4, "progress_percentage": 80}', NULL, '2025-11-09 10:27:21', '2025-11-09 10:27:21'),
	(59, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"completed_lessons": 3, "progress_percentage": 60}', NULL, '2025-11-09 10:27:21', '2025-11-09 10:27:21'),
	(60, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"completed_lessons": 2, "progress_percentage": 40}', NULL, '2025-11-09 10:27:21', '2025-11-09 10:27:21'),
	(61, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"completed_lessons": 1, "progress_percentage": 20}', NULL, '2025-11-09 10:27:21', '2025-11-09 10:27:21'),
	(62, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 13:27:22", "completed_lessons": 0, "progress_percentage": 0}', NULL, '2025-11-09 10:27:22', '2025-11-09 10:27:22'),
	(63, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"status": "active", "updated_at": "2025-11-09 13:27:22", "completed_at": null, "completed_lessons": 0, "progress_percentage": 0}', NULL, '2025-11-09 10:27:22', '2025-11-09 10:27:22'),
	(64, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 13:27:54", "completed_lessons": 1, "progress_percentage": 20}', NULL, '2025-11-09 10:27:54', '2025-11-09 10:27:54'),
	(65, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 4, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 13:31:51", "completed_lessons": 0, "progress_percentage": 0}', NULL, '2025-11-09 10:31:51', '2025-11-09 10:31:51'),
	(66, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 4, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 13:31:51", "completed_lessons": 0, "progress_percentage": 0}', NULL, '2025-11-09 10:31:51', '2025-11-09 10:31:51'),
	(67, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-09 13:53:54', '2025-11-09 13:53:54'),
	(68, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 17:46:49", "completed_lessons": 2, "progress_percentage": 40}', NULL, '2025-11-09 14:46:49', '2025-11-09 14:46:49'),
	(69, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 17:47:20", "completed_lessons": 3, "progress_percentage": 60}', NULL, '2025-11-09 14:47:20', '2025-11-09 14:47:20'),
	(70, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"updated_at": "2025-11-09 17:48:42", "completed_lessons": 4, "progress_percentage": 80}', NULL, '2025-11-09 14:48:42', '2025-11-09 14:48:42'),
	(71, 'Resource', 'Enrollment Updated by Academy Admin', 'App\\Models\\Enrollment', 'Updated', 5, 'App\\Models\\User', 1, '{"status": "completed", "updated_at": "2025-11-09 17:48:59", "completed_at": "2025-11-09 17:48:59", "completed_lessons": 5, "progress_percentage": 100}', NULL, '2025-11-09 14:48:59', '2025-11-09 14:48:59'),
	(72, 'Resource', 'Lesson Created by Academy Admin', 'App\\Models\\Lesson', 'Created', 12, 'App\\Models\\User', 1, '{"id": 12, "order": 0, "title": "{\\"en\\":\\"Import & Export Solutions\\",\\"ar\\":\\"مرحبا بك في Vision360\\"}", "is_free": false, "created_at": "2025-11-09 18:54:22", "section_id": 12, "updated_at": "2025-11-09 18:54:22", "description": "{\\"ar\\":null}", "content_data": "{\\"url\\":\\"https:\\\\/\\\\/www.youtube.com\\\\/watch?v=cNLG7n9OlGM\\"}", "content_type": "video", "is_published": true, "duration_minutes": null}', NULL, '2025-11-09 15:54:22', '2025-11-09 15:54:22'),
	(73, 'Resource', 'Lesson Created by Academy Admin', 'App\\Models\\Lesson', 'Created', 12, 'App\\Models\\User', 1, '{"id": 12, "order": 0, "title": "{\\"en\\":\\"Import & Export Solutions\\",\\"ar\\":\\"مرحبا بك في Vision360\\"}", "is_free": false, "created_at": "2025-11-09 18:54:22", "section_id": 12, "updated_at": "2025-11-09 18:54:22", "description": "{\\"ar\\":null}", "content_data": "{\\"url\\":\\"https:\\\\/\\\\/www.youtube.com\\\\/watch?v=cNLG7n9OlGM\\"}", "content_type": "video", "is_published": true, "duration_minutes": null}', NULL, '2025-11-09 15:54:22', '2025-11-09 15:54:22'),
	(74, 'Resource', 'Lesson Created by Academy Admin', 'App\\Models\\Lesson', 'Created', 12, 'App\\Models\\User', 1, '{"id": 12, "order": 0, "title": "{\\"en\\":\\"Import & Export Solutions\\",\\"ar\\":\\"مرحبا بك في Vision360\\"}", "is_free": false, "created_at": "2025-11-09 18:54:22", "section_id": 12, "updated_at": "2025-11-09 18:54:22", "description": "{\\"ar\\":null}", "content_data": "{\\"url\\":\\"https:\\\\/\\\\/www.youtube.com\\\\/watch?v=cNLG7n9OlGM\\"}", "content_type": "video", "is_published": true, "duration_minutes": null}', NULL, '2025-11-09 15:54:22', '2025-11-09 15:54:22'),
	(75, 'Access', 'Academy Admin logged in', 'App\\Models\\User', 'Login', 1, 'App\\Models\\User', 1, '{"ip": "127.0.0.1", "user_agent": "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"}', NULL, '2025-11-10 01:40:59', '2025-11-10 01:40:59');

-- Dumping structure for table academy.assignments
CREATE TABLE IF NOT EXISTS `assignments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lesson_progress_id` bigint unsigned NOT NULL,
  `lesson_id` bigint unsigned NOT NULL,
  `submission_text` text COLLATE utf8mb4_unicode_ci,
  `file_attachments` json DEFAULT NULL,
  `status` enum('draft','submitted','graded','returned') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `grade_percentage` decimal(5,2) DEFAULT NULL,
  `grade` text COLLATE utf8mb4_unicode_ci,
  `feedback` text COLLATE utf8mb4_unicode_ci,
  `submitted_at` timestamp NULL DEFAULT NULL,
  `graded_at` timestamp NULL DEFAULT NULL,
  `attempt_number` int NOT NULL DEFAULT '1',
  `meta_data` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignments_lesson_progress_id_status_index` (`lesson_progress_id`,`status`),
  KEY `assignments_lesson_id_status_index` (`lesson_id`,`status`),
  KEY `assignments_status_graded_at_index` (`status`,`graded_at`),
  CONSTRAINT `assignments_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignments_lesson_progress_id_foreign` FOREIGN KEY (`lesson_progress_id`) REFERENCES `lesson_progresses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.assignments: ~2 rows (approximately)
INSERT INTO `assignments` (`id`, `lesson_progress_id`, `lesson_id`, `submission_text`, `file_attachments`, `status`, `grade_percentage`, `grade`, `feedback`, `submitted_at`, `graded_at`, `attempt_number`, `meta_data`, `created_at`, `updated_at`) VALUES
	(4, 6, 5, 'erreererererer', '[]', 'submitted', NULL, NULL, NULL, '2025-11-09 14:48:59', NULL, 1, NULL, '2025-11-09 14:48:59', '2025-11-09 14:48:59');

-- Dumping data for table academy.cache_locks: ~0 rows (approximately)

-- Dumping structure for table academy.courses
CREATE TABLE IF NOT EXISTS `courses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` json NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` json DEFAULT NULL,
  `short_description` json DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `is_free` tinyint(1) NOT NULL DEFAULT '1',
  `instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category` json DEFAULT NULL,
  `status` enum('draft','published','archived') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `thumbnail_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_data` json DEFAULT NULL,
  `duration_hours` int DEFAULT NULL,
  `enrollment_count` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `courses_slug_unique` (`slug`),
  KEY `courses_status_is_free_index` (`status`,`is_free`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.courses: ~6 rows (approximately)
INSERT INTO `courses` (`id`, `title`, `slug`, `description`, `short_description`, `price`, `is_free`, `instructor_name`, `instructor_email`, `category`, `status`, `thumbnail_path`, `meta_data`, `duration_hours`, `enrollment_count`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, '{"en": "Complete Web Development Bootcamp"}', 'complete-web-development-bootcamp', '{"en": "Learn full-stack web development from scratch. This comprehensive course covers HTML, CSS, JavaScript, PHP, Laravel, and modern web development practices."}', '{"en": "Master full-stack web development with hands-on projects and real-world applications."}', 99.99, 0, 'John Instructor', 'instructor@academy.com', '{"en": "Programming"}', 'published', NULL, NULL, 40, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58', NULL),
	(2, '{"en": "Data Science with Python"}', 'data-science-with-python', '{"en": "Master data science fundamentals using Python. Learn data analysis, visualization, machine learning, and statistical modeling."}', '{"en": "Comprehensive data science course covering Python, pandas, NumPy, and scikit-learn."}', 149.99, 0, 'John Instructor', 'instructor@academy.com', '{"en": "Data Science"}', 'published', NULL, NULL, 35, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58', NULL),
	(3, '{"en": "UI/UX Design Fundamentals"}', 'ui-ux-design-fundamentals', '{"en": "Learn the principles of user interface and user experience design. Master design thinking, prototyping, and user research."}', '{"en": "Complete guide to UI/UX design principles and practices."}', 79.99, 1, 'John Instructor', 'instructor@academy.com', '{"en": "Design"}', 'published', NULL, NULL, 25, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58', NULL),
	(4, '{"ar": "أساسيات لارافيل", "en": "Laravel Fundamentals"}', 'laravel-fundamentals', '{"ar": "تعلم أساسيات إطار عمل لارافيل بما في ذلك التوجيه والمتحكمات والنماذج والعروض.", "en": "Learn the basics of Laravel framework including routing, controllers, models, and views."}', '{"ar": "أتقن أساسيات لارافيل في هذه الدورة الشاملة.", "en": "Master Laravel basics in this comprehensive course."}', 99.99, 0, 'John Doe', 'john@example.com', '{"ar": "تطوير الويب", "en": "Web Development"}', 'published', NULL, NULL, 20, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58', NULL),
	(5, '{"ar": "تطوير React المتقدم", "en": "Advanced React Development"}', 'react-advanced', '{"ar": "ارتقِ بمهارات React إلى المستوى التالي مع مفاهيم متقدمة مثل الخطافات والسياق وتحسين الأداء.", "en": "Take your React skills to the next level with advanced concepts like hooks, context, and performance optimization."}', '{"ar": "مفاهيم React المتقدمة وأفضل الممارسات.", "en": "Advanced React concepts and best practices."}', 149.99, 0, 'Jane Smith', 'jane@example.com', '{"ar": "تطوير الواجهة الأمامية", "en": "Frontend Development"}', 'published', NULL, NULL, 25, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58', NULL),
	(6, '{"ar": "مقدمة في البرمجة", "en": "Introduction to Programming"}', 'introduction-to-programming', '{"ar": "تعلم أساسيات البرمجة مع أمثلة عملية وتمارين.", "en": "Learn the fundamentals of programming with practical examples and exercises."}', '{"ar": "ابدأ رحلتك في البرمجة من هنا.", "en": "Learn the fundamentals of programming with practical examples and exercises."}', 0.00, 1, 'Bob Johnson', 'bob@example.com', '{"ar": "أساسيات البرمجة", "en": "Programming Basics"}', 'published', NULL, NULL, 15, 0, '2025-11-04 06:43:58', '2025-11-07 15:48:18', NULL);

-- Dumping structure for table academy.enrollments
CREATE TABLE IF NOT EXISTS `enrollments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `status` enum('pending','active','completed','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `payment_status` enum('pending','paid','refunded','failed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `paid_amount` decimal(10,2) DEFAULT NULL,
  `enrolled_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `progress_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',
  `completed_lessons` int NOT NULL DEFAULT '0',
  `total_lessons` int NOT NULL DEFAULT '0',
  `meta_data` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `enrollments_user_id_course_id_unique` (`user_id`,`course_id`),
  KEY `enrollments_user_id_status_index` (`user_id`,`status`),
  KEY `enrollments_course_id_status_index` (`course_id`,`status`),
  KEY `enrollments_payment_status_status_index` (`payment_status`,`status`),
  CONSTRAINT `enrollments_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `enrollments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.enrollments: ~5 rows (approximately)
INSERT INTO `enrollments` (`id`, `user_id`, `course_id`, `status`, `payment_status`, `paid_amount`, `enrolled_at`, `completed_at`, `progress_percentage`, `completed_lessons`, `total_lessons`, `meta_data`, `created_at`, `updated_at`) VALUES
	(1, 3, 1, 'pending', 'pending', 99.99, '2025-10-14 06:43:58', NULL, 0.00, 0, 0, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(2, 3, 2, 'pending', 'pending', 149.99, '2025-10-28 06:43:58', NULL, 0.00, 0, 0, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(3, 3, 3, 'completed', 'paid', 0.00, '2025-11-02 06:43:58', '2025-11-04 06:43:58', 100.00, 1, 1, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(4, 1, 6, 'active', 'paid', 0.00, '2025-11-05 07:10:11', NULL, 0.00, 0, 2, NULL, '2025-11-05 07:10:24', '2025-11-09 10:31:51'),
	(5, 1, 1, 'completed', 'paid', 99.99, '2025-11-05 08:50:30', '2025-11-09 14:48:59', 100.00, 5, 5, NULL, '2025-11-05 08:50:30', '2025-11-09 14:48:59');

-- Dumping structure for table academy.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table academy.jobs
CREATE TABLE IF NOT EXISTS `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.jobs: ~0 rows (approximately)

-- Dumping structure for table academy.job_batches
CREATE TABLE IF NOT EXISTS `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.job_batches: ~0 rows (approximately)

-- Dumping structure for table academy.lessons
CREATE TABLE IF NOT EXISTS `lessons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `section_id` bigint unsigned NOT NULL,
  `title` json NOT NULL,
  `description` json DEFAULT NULL,
  `content_type` enum('video','document','quiz','assignment') COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_data` json NOT NULL,
  `order` int NOT NULL DEFAULT '0',
  `duration_minutes` int DEFAULT NULL,
  `is_free` tinyint(1) NOT NULL DEFAULT '0',
  `is_published` tinyint(1) NOT NULL DEFAULT '1',
  `meta_data` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lessons_section_id_order_index` (`section_id`,`order`),
  KEY `lessons_content_type_is_published_index` (`content_type`,`is_published`),
  CONSTRAINT `lessons_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.lessons: ~11 rows (approximately)
INSERT INTO `lessons` (`id`, `section_id`, `title`, `description`, `content_type`, `content_data`, `order`, `duration_minutes`, `is_free`, `is_published`, `meta_data`, `created_at`, `updated_at`) VALUES
	(1, 1, '{"ar": "Introduction to HTML", "en": "Introduction to HTML"}', '{"ar": "Learn what HTML is and why it\'s important", "en": "Learn what HTML is and why it\'s important"}', 'video', '{"url": "https://www.youtube.com/watch?v=cNLG7n9OlGM"}', 1, 15, 1, 1, NULL, '2025-11-04 06:43:58', '2025-11-09 04:52:10'),
	(2, 1, '{"ar": "HTML Document Structure", "en": "HTML Document Structure"}', '{"ar": "Understanding the basic structure of an HTML document", "en": "Understanding the basic structure of an HTML document"}', 'document', '{"path": "lessons/documents/01K9HYX1263CR52YH4KRZB7J3J.pdf", "content": "<h1>HTML Document Structure</h1><p>Every HTML document follows a standard structure...</p>"}', 2, 20, 0, 1, NULL, '2025-11-04 06:43:58', '2025-11-08 11:46:07'),
	(3, 2, '{"en": "CSS Selectors and Properties"}', '{"en": "Learn how to select and style HTML elements"}', 'video', '{"url": "https://www.youtube.com/watch?v=example2", "description": "Comprehensive guide to CSS selectors and styling properties"}', 1, 25, 0, 1, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(4, 3, '{"ar": "JavaScript Fundamentals Quiz", "en": "JavaScript Fundamentals Quiz"}', '{"ar": "Test your knowledge of JavaScript basics", "en": "Test your knowledge of JavaScript basics"}', 'quiz', '{"questions": [{"points": 1, "options": {"ar": ["A programming language", "A markup language", "A styling language", "A database"], "en": ["A programming language", "A markup language", "A styling language", "A database"]}, "question": {"ar": "What is JavaScript?", "en": "What is JavaScript?"}, "explanation": {"ar": null, "en": null}, "correct_answer": {"ar": 0, "en": 0}}], "passing_score": 70, "randomize_questions": false}', 1, 30, 0, 1, NULL, '2025-11-04 06:43:58', '2025-11-09 03:48:13'),
	(5, 3, '{"ar": "Build a Calculator", "en": "Build a Calculator"}', '{"ar": "Create a functional calculator using JavaScript", "en": "Create a functional calculator using JavaScript"}', 'assignment', '{"rubric": {"ar": "Functionality (40%), Code quality (30%), UI/UX (20%), Documentation (10%)\\n\\n", "en": "Functionality (40%), Code quality (30%), UI/UX (20%), Documentation (10%)\\n\\n"}, "details": {"ar": "<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.</p><p><br></p>", "en": "<p>Build a calculator application with the following features: addition, subtraction, multiplication, division, and clear functionality. Use HTML for the UI and JavaScript for the logic.</p><p><br></p>"}, "due_days": 7, "max_points": 100, "allow_file_upload": true, "allow_text_submission": true, "allow_multiple_attempts": true}', 2, 60, 0, 1, NULL, '2025-11-04 06:43:58', '2025-11-09 03:19:06'),
	(6, 4, '{"en": "Python Basics for Data Science"}', '{"en": "Introduction to Python programming for data analysis"}', 'video', '{"url": "https://www.youtube.com/watch?v=example3", "description": "Learn Python fundamentals specifically for data science applications"}', 1, 45, 1, 1, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(7, 5, '{"en": "Introduction to UI/UX Design"}', '{"en": "What is UI/UX design and why it matters"}', 'video', '{"url": "https://www.youtube.com/watch?v=example4", "description": "Overview of UI/UX design and its importance in product development"}', 1, 20, 1, 1, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(8, 6, '{"ar": "تثبيت لارافيل", "en": "Installing Laravel"}', '{"ar": "تعلم كيفية تثبيت لارافيل باستخدام Composer وإعداد مشروعك.", "en": "Learn how to install Laravel using Composer and set up your project."}', 'video', '{"url": "https://www.youtube.com/watch?v=example1", "video_type": "youtube", "description": "Step-by-step installation guide"}', 1, 15, 1, 1, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(9, 6, '{"ar": "هيكل مجلدات لارافيل", "en": "Laravel Directory Structure"}', '{"ar": "فهم هيكل مجلدات لارافيل وتنظيم الملفات.", "en": "Understanding Laravel\'s folder structure and file organization."}', 'document', '{"content": "<h2>Laravel Directory Structure</h2><p>Laravel follows the MVC pattern...</p>"}', 2, 10, 1, 1, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(10, 11, '{"ar": "ما هي البرمجة؟", "en": "What is Programming?"}', '{"ar": "مقدمة عن مفاهيم البرمجة ولماذا تهم.", "en": "An introduction to programming concepts and why it matters."}', 'video', '{"url": "https://www.youtube.com/watch?v=example2", "video_type": "youtube"}', 1, 20, 1, 1, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(11, 11, '{"ar": "اختبار البرمجة", "en": "Programming Quiz"}', '{"ar": "اختبر فهمك لمفاهيم البرمجة الأساسية.", "en": "Test your understanding of basic programming concepts."}', 'quiz', '{"questions": [{"points": 1, "options": ["Writing code", "Designing websites", "Using computers", "Playing games"], "question": "What is programming?", "explanation": "Programming is the process of writing code to instruct computers.", "correct_answer": 0}], "passing_score": 70, "randomize_questions": false}', 2, 15, 1, 1, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(12, 12, '{"ar": "مرحبا بك في Vision360", "en": "Import & Export Solutions"}', '{"ar": null}', 'video', '{"url": "https://www.youtube.com/watch?v=cNLG7n9OlGM"}', 0, NULL, 0, 1, NULL, '2025-11-09 15:54:22', '2025-11-09 15:54:22');

-- Dumping structure for table academy.lesson_progresses
CREATE TABLE IF NOT EXISTS `lesson_progresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `enrollment_id` bigint unsigned NOT NULL,
  `lesson_id` bigint unsigned NOT NULL,
  `status` enum('not_started','in_progress','completed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'not_started',
  `time_spent_seconds` int NOT NULL DEFAULT '0',
  `started_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `last_accessed_at` timestamp NULL DEFAULT NULL,
  `attempts_count` int NOT NULL DEFAULT '0',
  `progress_data` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lesson_progresses_enrollment_id_lesson_id_unique` (`enrollment_id`,`lesson_id`),
  KEY `lesson_progresses_enrollment_id_status_index` (`enrollment_id`,`status`),
  KEY `lesson_progresses_lesson_id_status_index` (`lesson_id`,`status`),
  CONSTRAINT `lesson_progresses_enrollment_id_foreign` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lesson_progresses_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.lesson_progresses: ~7 rows (approximately)
INSERT INTO `lesson_progresses` (`id`, `enrollment_id`, `lesson_id`, `status`, `time_spent_seconds`, `started_at`, `completed_at`, `last_accessed_at`, `attempts_count`, `progress_data`, `created_at`, `updated_at`) VALUES
	(1, 3, 7, 'completed', 1984, '2025-11-01 06:43:58', '2025-10-31 06:43:58', '2025-11-03 06:43:58', 1, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(2, 5, 1, 'completed', 0, '2025-11-09 10:27:40', '2025-11-09 10:27:54', '2025-11-09 14:46:40', 1, NULL, '2025-11-05 08:50:30', '2025-11-09 14:46:40'),
	(3, 5, 2, 'completed', 0, '2025-11-09 14:46:45', '2025-11-09 14:46:49', '2025-11-09 14:46:49', 1, NULL, '2025-11-05 08:50:30', '2025-11-09 14:46:49'),
	(4, 5, 3, 'completed', 0, '2025-11-09 14:48:37', '2025-11-09 14:48:42', '2025-11-09 14:48:43', 1, NULL, '2025-11-05 08:50:30', '2025-11-09 14:48:43'),
	(5, 5, 4, 'completed', 0, '2025-11-09 14:47:20', '2025-11-09 14:47:20', '2025-11-09 14:47:20', 1, NULL, '2025-11-05 08:50:30', '2025-11-09 14:47:20'),
	(6, 5, 5, 'completed', 0, '2025-11-09 14:48:59', '2025-11-09 14:48:59', '2025-11-09 14:48:59', 0, NULL, '2025-11-05 08:50:30', '2025-11-09 14:48:59'),
	(7, 4, 10, 'not_started', 0, NULL, NULL, '2025-11-09 10:31:51', 0, NULL, '2025-11-09 07:45:23', '2025-11-09 10:31:51');

-- Dumping structure for table academy.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.migrations: ~15 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '0001_01_01_000000_create_users_table', 1),
	(2, '0001_01_01_000001_create_cache_table', 1),
	(3, '0001_01_01_000002_create_jobs_table', 1),
	(4, '2025_11_03_132658_create_activity_log_table', 1),
	(5, '2025_11_03_132659_add_event_column_to_activity_log_table', 1),
	(6, '2025_11_03_132700_add_batch_uuid_column_to_activity_log_table', 1),
	(7, '2025_11_03_133541_create_permission_tables', 1),
	(8, '2025_11_04_052559_create_courses_table', 1),
	(9, '2025_11_04_052635_create_sections_table', 1),
	(10, '2025_11_04_052650_create_lessons_table', 1),
	(11, '2025_11_04_052725_create_enrollments_table', 1),
	(12, '2025_11_04_052800_create_lesson_progress_table', 1),
	(13, '2025_11_04_052825_create_quiz_attempts_table', 1),
	(14, '2025_11_04_052907_create_assignments_table', 1),
	(15, '2025_11_04_052923_create_payments_table', 1);

-- Dumping structure for table academy.model_has_permissions
CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.model_has_permissions: ~0 rows (approximately)

-- Dumping structure for table academy.model_has_roles
CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.model_has_roles: ~3 rows (approximately)
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
	(1, 'App\\Models\\User', 1),
	(2, 'App\\Models\\User', 2),
	(2, 'App\\Models\\User', 3);

-- Dumping data for table academy.password_reset_tokens: ~0 rows (approximately)

-- Dumping structure for table academy.payments
CREATE TABLE IF NOT EXISTS `payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `enrollment_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_method` enum('stripe','paypal','bank_transfer','manual') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'stripe',
  `status` enum('pending','completed','failed','refunded','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `amount` decimal(10,2) NOT NULL,
  `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'USD',
  `gateway_response` text COLLATE utf8mb4_unicode_ci,
  `metadata` json DEFAULT NULL,
  `paid_at` timestamp NULL DEFAULT NULL,
  `refunded_at` timestamp NULL DEFAULT NULL,
  `refund_amount` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payments_transaction_id_unique` (`transaction_id`),
  KEY `payments_course_id_foreign` (`course_id`),
  KEY `payments_enrollment_id_status_index` (`enrollment_id`,`status`),
  KEY `payments_user_id_status_index` (`user_id`,`status`),
  KEY `payments_payment_method_status_index` (`payment_method`,`status`),
  KEY `payments_status_paid_at_index` (`status`,`paid_at`),
  CONSTRAINT `payments_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payments_enrollment_id_foreign` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.payments: ~2 rows (approximately)
INSERT INTO `payments` (`id`, `enrollment_id`, `user_id`, `course_id`, `transaction_id`, `payment_method`, `status`, `amount`, `currency`, `gateway_response`, `metadata`, `paid_at`, `refunded_at`, `refund_amount`, `created_at`, `updated_at`) VALUES
	(1, 1, 3, 1, NULL, 'manual', 'pending', 99.99, 'USD', NULL, NULL, NULL, NULL, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(2, 2, 3, 2, NULL, 'manual', 'pending', 149.99, 'USD', NULL, NULL, NULL, NULL, NULL, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(3, 5, 1, 1, 'manual_690b3a0672be5', 'manual', 'pending', 99.99, 'USD', '"{\\"status\\":\\"pending_admin_approval\\",\\"notes\\":\\"Manual payment - pending admin approval\\"}"', NULL, NULL, NULL, NULL, '2025-11-05 08:50:30', '2025-11-05 08:50:30');

-- Dumping structure for table academy.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.permissions: ~83 rows (approximately)
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'ViewAny:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(2, 'View:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(3, 'Create:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(4, 'Update:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(5, 'Delete:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(6, 'Restore:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(7, 'ForceDelete:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(8, 'ForceDeleteAny:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(9, 'RestoreAny:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(10, 'Replicate:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(11, 'Reorder:Course', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(12, 'ViewAny:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(13, 'View:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(14, 'Create:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(15, 'Update:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(16, 'Delete:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(17, 'Restore:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(18, 'ForceDelete:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(19, 'ForceDeleteAny:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(20, 'RestoreAny:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(21, 'Replicate:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(22, 'Reorder:Enrollment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(23, 'ViewAny:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(24, 'View:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(25, 'Create:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(26, 'Update:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(27, 'Delete:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(28, 'Restore:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(29, 'ForceDelete:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(30, 'ForceDeleteAny:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(31, 'RestoreAny:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(32, 'Replicate:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(33, 'Reorder:Lesson', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(34, 'ViewAny:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(35, 'View:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(36, 'Create:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(37, 'Update:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(38, 'Delete:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(39, 'Restore:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(40, 'ForceDelete:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(41, 'ForceDeleteAny:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(42, 'RestoreAny:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(43, 'Replicate:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(44, 'Reorder:Payment', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(45, 'ViewAny:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(46, 'View:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(47, 'Create:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(48, 'Update:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(49, 'Delete:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(50, 'Restore:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(51, 'ForceDelete:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(52, 'ForceDeleteAny:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(53, 'RestoreAny:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(54, 'Replicate:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(55, 'Reorder:User', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(56, 'ViewAny:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(57, 'View:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(58, 'Create:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(59, 'Update:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(60, 'Delete:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(61, 'Restore:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(62, 'ForceDelete:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(63, 'ForceDeleteAny:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(64, 'RestoreAny:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(65, 'Replicate:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(66, 'Reorder:Role', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(67, 'ViewAny:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(68, 'View:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(69, 'Create:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(70, 'Update:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(71, 'Delete:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(72, 'Restore:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(73, 'ForceDelete:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(74, 'ForceDeleteAny:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(75, 'RestoreAny:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(76, 'Replicate:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(77, 'Reorder:Activity', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(78, 'View:CourseView', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(79, 'View:LessonView', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(80, 'View:MyCourses', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(81, 'View:CourseStatsWidget', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(82, 'View:StudentProgressWidget', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(83, 'View:EnrollmentChartWidget', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58');

-- Dumping structure for table academy.quiz_attempts
CREATE TABLE IF NOT EXISTS `quiz_attempts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lesson_progress_id` bigint unsigned NOT NULL,
  `lesson_id` bigint unsigned NOT NULL,
  `answers` json NOT NULL,
  `score_percentage` decimal(5,2) DEFAULT NULL,
  `correct_answers` int NOT NULL DEFAULT '0',
  `total_questions` int NOT NULL DEFAULT '0',
  `is_passed` tinyint(1) NOT NULL DEFAULT '0',
  `submitted_at` timestamp NOT NULL,
  `feedback` text COLLATE utf8mb4_unicode_ci,
  `attempt_number` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quiz_attempts_lesson_progress_id_attempt_number_index` (`lesson_progress_id`,`attempt_number`),
  KEY `quiz_attempts_lesson_id_is_passed_index` (`lesson_id`,`is_passed`),
  CONSTRAINT `quiz_attempts_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quiz_attempts_lesson_progress_id_foreign` FOREIGN KEY (`lesson_progress_id`) REFERENCES `lesson_progresses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.quiz_attempts: ~4 rows (approximately)
INSERT INTO `quiz_attempts` (`id`, `lesson_progress_id`, `lesson_id`, `answers`, `score_percentage`, `correct_answers`, `total_questions`, `is_passed`, `submitted_at`, `feedback`, `attempt_number`, `created_at`, `updated_at`) VALUES
	(8, 5, 4, '[0]', 100.00, 1, 1, 1, '2025-11-09 14:47:20', NULL, 1, '2025-11-09 14:47:20', '2025-11-09 14:47:20');

-- Dumping structure for table academy.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.roles: ~2 rows (approximately)
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'super_admin', 'web', '2025-11-04 06:43:57', '2025-11-04 06:43:57'),
	(2, 'panel_user', 'web', '2025-11-04 06:43:58', '2025-11-04 06:43:58');

-- Dumping structure for table academy.role_has_permissions
CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.role_has_permissions: ~83 rows (approximately)
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(1, 1),
	(2, 1),
	(3, 1),
	(4, 1),
	(5, 1),
	(6, 1),
	(7, 1),
	(8, 1),
	(9, 1),
	(10, 1),
	(11, 1),
	(12, 1),
	(13, 1),
	(14, 1),
	(15, 1),
	(16, 1),
	(17, 1),
	(18, 1),
	(19, 1),
	(20, 1),
	(21, 1),
	(22, 1),
	(23, 1),
	(24, 1),
	(25, 1),
	(26, 1),
	(27, 1),
	(28, 1),
	(29, 1),
	(30, 1),
	(31, 1),
	(32, 1),
	(33, 1),
	(34, 1),
	(35, 1),
	(36, 1),
	(37, 1),
	(38, 1),
	(39, 1),
	(40, 1),
	(41, 1),
	(42, 1),
	(43, 1),
	(44, 1),
	(45, 1),
	(46, 1),
	(47, 1),
	(48, 1),
	(49, 1),
	(50, 1),
	(51, 1),
	(52, 1),
	(53, 1),
	(54, 1),
	(55, 1),
	(56, 1),
	(57, 1),
	(58, 1),
	(59, 1),
	(60, 1),
	(61, 1),
	(62, 1),
	(63, 1),
	(64, 1),
	(65, 1),
	(66, 1),
	(67, 1),
	(68, 1),
	(69, 1),
	(70, 1),
	(71, 1),
	(72, 1),
	(73, 1),
	(74, 1),
	(75, 1),
	(76, 1),
	(77, 1),
	(78, 1),
	(79, 1),
	(80, 1),
	(81, 1),
	(82, 1),
	(83, 1);

-- Dumping structure for table academy.sections
CREATE TABLE IF NOT EXISTS `sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `course_id` bigint unsigned NOT NULL,
  `title` json NOT NULL,
  `description` json DEFAULT NULL,
  `order` int NOT NULL DEFAULT '0',
  `duration_minutes` int DEFAULT NULL,
  `lesson_count` int NOT NULL DEFAULT '0',
  `is_free` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sections_course_id_order_index` (`course_id`,`order`),
  CONSTRAINT `sections_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.sections: ~12 rows (approximately)
INSERT INTO `sections` (`id`, `course_id`, `title`, `description`, `order`, `duration_minutes`, `lesson_count`, `is_free`, `created_at`, `updated_at`) VALUES
	(1, 1, '{"en": "HTML Fundamentals"}', '{"en": "Learn the building blocks of the web"}', 1, 180, 2, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(2, 1, '{"en": "CSS Styling & Layout"}', '{"en": "Master modern CSS techniques and responsive design"}', 2, 240, 1, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(3, 1, '{"en": "JavaScript Programming"}', '{"en": "Learn JavaScript from basics to advanced concepts"}', 3, 300, 2, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(4, 2, '{"en": "Python for Data Science"}', '{"en": "Learn Python programming fundamentals for data analysis"}', 1, 240, 1, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(5, 3, '{"en": "Design Principles"}', '{"en": "Learn the fundamental principles of good design"}', 1, 120, 1, 1, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(6, 4, '{"ar": "البدء مع لارافيل", "en": "Getting Started with Laravel"}', '{"ar": "مقدمة عن لارافيل وإعداد بيئة التطوير.", "en": "Introduction to Laravel and setting up your development environment."}', 1, 120, 2, 1, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(7, 4, '{"ar": "التوجيه والمتحكمات", "en": "Routing and Controllers"}', '{"ar": "تعلم كيفية التعامل مع طلبات HTTP باستخدام التوجيه والمتحكمات.", "en": "Learn how to handle HTTP requests with routes and controllers."}', 2, 180, 0, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(8, 4, '{"ar": "العمل مع قواعد البيانات", "en": "Working with Databases"}', '{"ar": "عمليات قاعدة البيانات والترحيلات وEloquent ORM.", "en": "Database operations, migrations, and Eloquent ORM."}', 3, 240, 0, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(9, 5, '{"ar": "غوص عميق في React Hooks", "en": "React Hooks Deep Dive"}', '{"ar": "أتقن جميع React hooks وأنماط استخدامها المتقدمة.", "en": "Master all React hooks and their advanced usage patterns."}', 1, 150, 0, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(10, 5, '{"ar": "تحسين الأداء", "en": "Performance Optimization"}', '{"ar": "تقنيات لتحسين أداء تطبيقات React.", "en": "Techniques to optimize React application performance."}', 2, 120, 0, 0, '2025-11-04 06:43:58', '2025-11-04 06:43:58'),
	(11, 6, '{"ar": "ما هي البرمجة؟", "en": "What is Programming?"}', '{"ar": "فهم أساسيات البرمجة وعلم الحاسوب.", "en": "Understanding the basics of programming and computer science."}', 2, 90, 2, 1, '2025-11-04 06:43:58', '2025-11-09 15:52:12'),
	(12, 6, '{"ar": "برنامجك الأول", "en": "Your First Program"}', '{"ar": "اكتب وشغل برنامجك الحاسوبي الأول.", "en": "Write and run your very first computer program."}', 1, 60, 0, 1, '2025-11-04 06:43:58', '2025-11-09 15:52:12');

-- Dumping structure for table academy.sessions
CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table academy.sessions: ~1 rows (approximately)
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('BZONhT2jzfKaWqscSrS1khWk1zkeKX2nnOmwFOih', 1, '127.0.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', '[BLOB]', 1762714535),
	('c8cjvT430NrwSJ7gfmmEy5gAZTTLaqo2b61NbVbX', 1, '127.0.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', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiamVBUXB6YnJrZG15WVJxS0RoVGtzWFhCVVpBckd5ZTZid0dLeGpmNyI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEyJHAvcmZBS1JsT3V2cWh1SEdPZVY4aU80SXRUcXczeGRNUU1wMGExQXVuMUpzZnAvMGNabk55IjtzOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czo0MDoiaHR0cDovL2FjYWRlbXkudGVzdC9hZG1pbi9jb3Vyc2VzLzYvZWRpdCI7czo1OiJyb3V0ZSI7czozNzoiZmlsYW1lbnQuYWRtaW4ucmVzb3VyY2VzLmNvdXJzZXMuZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NjoidGFibGVzIjthOjE6e3M6NDA6IjE3ZmQzNzE3MTZjMjU5ZTNkZDRjNzIwMTI3MzExOGY5X2NvbHVtbnMiO2E6NDp7aTowO2E6Nzp7czo0OiJ0eXBlIjtzOjY6ImNvbHVtbiI7czo0OiJuYW1lIjtzOjU6InRpdGxlIjtzOjU6ImxhYmVsIjtzOjU6IlRpdGxlIjtzOjg6ImlzSGlkZGVuIjtiOjA7czo5OiJpc1RvZ2dsZWQiO2I6MTtzOjEyOiJpc1RvZ2dsZWFibGUiO2I6MDtzOjI0OiJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiO047fWk6MTthOjc6e3M6NDoidHlwZSI7czo2OiJjb2x1bW4iO3M6NDoibmFtZSI7czoxMToiZGVzY3JpcHRpb24iO3M6NToibGFiZWwiO3M6MTE6IkRlc2NyaXB0aW9uIjtzOjg6ImlzSGlkZGVuIjtiOjA7czo5OiJpc1RvZ2dsZWQiO2I6MTtzOjEyOiJpc1RvZ2dsZWFibGUiO2I6MDtzOjI0OiJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiO047fWk6MjthOjc6e3M6NDoidHlwZSI7czo2OiJjb2x1bW4iO3M6NDoibmFtZSI7czoxMjoibGVzc29uX2NvdW50IjtzOjU6ImxhYmVsIjtzOjc6Ikxlc3NvbnMiO3M6ODoiaXNIaWRkZW4iO2I6MDtzOjk6ImlzVG9nZ2xlZCI7YjoxO3M6MTI6ImlzVG9nZ2xlYWJsZSI7YjowO3M6MjQ6ImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI7Tjt9aTozO2E6Nzp7czo0OiJ0eXBlIjtzOjY6ImNvbHVtbiI7czo0OiJuYW1lIjtzOjEwOiJjcmVhdGVkX2F0IjtzOjU6ImxhYmVsIjtzOjEwOiJDcmVhdGVkIGF0IjtzOjg6ImlzSGlkZGVuIjtiOjA7czo5OiJpc1RvZ2dsZWQiO2I6MDtzOjEyOiJpc1RvZ2dsZWFibGUiO2I6MTtzOjI0OiJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiO2I6MTt9fX19', 1762750636);

