2026-04-07 13:34:58 +00:00

199 lines
17 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/*M!999999\- enable the sandbox mode */
-- MariaDB dump 10.19 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: 127.0.0.1 Database: app_39496
-- ------------------------------------------------------
-- Server version 10.11.14-MariaDB-0+deb12u2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `classes`
--
LOCK TABLES `classes` WRITE;
/*!40000 ALTER TABLE `classes` DISABLE KEYS */;
INSERT IGNORE INTO `classes` (`id`, `name_en`, `name_ar`, `description_en`, `description_ar`, `created_at`, `status`) VALUES (2,'Grade 11','الصف الحادي عشر','','','2026-04-06 04:07:29','active'),
(3,'Grade 10','الصف العاشر','','','2026-04-06 04:17:59','active'),
(4,'Grade 12','الصف الثاني عشر','','','2026-04-06 04:29:58','active');
/*!40000 ALTER TABLE `classes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `course_activities`
--
LOCK TABLES `course_activities` WRITE;
/*!40000 ALTER TABLE `course_activities` DISABLE KEYS */;
INSERT IGNORE INTO `course_activities` (`id`, `course_id`, `title_en`, `title_ar`, `description_en`, `description_ar`, `created_at`) VALUES (1,1,'Quiz1','Quiz1','test','test','2026-04-06 12:44:52');
/*!40000 ALTER TABLE `course_activities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `course_live_lessons`
--
LOCK TABLES `course_live_lessons` WRITE;
/*!40000 ALTER TABLE `course_live_lessons` DISABLE KEYS */;
INSERT IGNORE INTO `course_live_lessons` (`id`, `course_id`, `title`, `scheduled_at`, `status`, `room_name`, `meet_url`, `created_at`) VALUES (1,1,'test1','2026-04-06 17:52:00','live','room_fa6f9f9238',NULL,'2026-04-06 13:53:01');
/*!40000 ALTER TABLE `course_live_lessons` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `course_students`
--
LOCK TABLES `course_students` WRITE;
/*!40000 ALTER TABLE `course_students` DISABLE KEYS */;
/*!40000 ALTER TABLE `course_students` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `courses`
--
LOCK TABLES `courses` WRITE;
/*!40000 ALTER TABLE `courses` DISABLE KEYS */;
INSERT IGNORE INTO `courses` (`id`, `name_en`, `name_ar`, `description_en`, `description_ar`, `price`, `picture`, `status`, `created_at`, `teacher_id`, `max_students`, `registration_open`) VALUES (1,'Biology Grade 12','أحياء الثاني عشر','Learn the basics of HTML, CSS, and JavaScript to build modern websites.','تعلم أساسيات HTML و CSS و JavaScript لبناء مواقع حديثة.',20.00,'assets/images/uploads/1775471381_أحياء 12.jfif','active','2026-04-06 10:15:06',1,NULL,1),
(2,'Physics Grade 12','فيزياء الثاني عشر','Deep dive into Python architecture, data structures, and algorithms.','تعمق في بنية بايثون وهياكل البيانات والخوارزميات.',20.00,'assets/images/uploads/1775471335_فيزياء 12.jfif','active','2026-04-06 10:15:06',1,NULL,1),
(3,'Chemistry Grade 12','الكيمياء الثاني عشر','Master SEO, social media marketing, and online ad strategies.','إتقان تحسين محركات البحث وتسويق وسائل التواصل الاجتماعي.',20.00,'assets/images/uploads/1775471215_كيماء 12.webp','active','2026-04-06 10:15:06',1,NULL,1);
/*!40000 ALTER TABLE `courses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `landing_settings`
--
LOCK TABLES `landing_settings` WRITE;
/*!40000 ALTER TABLE `landing_settings` DISABLE KEYS */;
INSERT IGNORE INTO `landing_settings` (`setting_key`, `value_en`, `value_ar`) VALUES ('courses_eyebrow','Featured Courses','الدورات المميزة'),
('courses_title','Enroll in specialized short courses designed to accelerate your skills.','سجل في دورات قصيرة متخصصة لتسريع تطوير مهاراتك.'),
('flow_eyebrow','Delivery flow','مسار التسليم'),
('flow_title','One thin slice from discovery to live access.','شريحة رشيقة من الاكتشاف حتى الوصول المباشر.'),
('hero_desc','Launch a polished e-learning experience for students, teachers, and admins with English/Arabic support, Thawani billing flows, and Wablas-ready WhatsApp notifications.','أطلق تجربة تعليم إلكتروني مصقولة للطلاب والمعلمين والإدارة مع دعم الإنجليزية والعربية وتدفقات دفع ثواني وإشعارات واتساب جاهزة عبر وابلاس.'),
('hero_eyebrow','Single platform LMS','منصة تعليم موحدة'),
('hero_title','Subscriptions, multilingual classrooms, and live Google Meet learning in one precise workspace.','الاشتراكات والفصول متعددة اللغات والتعلم المباشر عبر Google Meet في مساحة واحدة دقيقة.'),
('plans_eyebrow','Plans','الخطط'),
('plans_title','Plan-based access for a shared marketplace.','وصول قائم على الخطط لمنصة مشتركة.'),
('subjects_eyebrow','Featured subjects','المواد المميزة'),
('subjects_title','Separate pages for catalog, detail, checkout, and dashboards.','صفحات منفصلة للكتالوج والتفاصيل والدفع ولوحات التحكم.');
/*!40000 ALTER TABLE `landing_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `module_progress`
--
LOCK TABLES `module_progress` WRITE;
/*!40000 ALTER TABLE `module_progress` DISABLE KEYS */;
/*!40000 ALTER TABLE `module_progress` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `plans`
--
LOCK TABLES `plans` WRITE;
/*!40000 ALTER TABLE `plans` DISABLE KEYS */;
INSERT IGNORE INTO `plans` (`id`, `plan_key`, `name_en`, `name_ar`, `price_monthly`, `price_yearly`, `subjects_limit`, `features_en`, `features_ar`) VALUES (1,'core','Core Plan','الخطة الأساسية',29.000,290.000,2,'[\"Access to 2 subjects\",\"Weekly live classroom\",\"Student dashboard\",\"Thawani-ready billing\"]','[\"\\u0627\\u0644\\u0648\\u0635\\u0648\\u0644 \\u0625\\u0644\\u0649 \\u0645\\u0627\\u062f\\u062a\\u064a\\u0646\",\"\\u0641\\u0635\\u0644 \\u0645\\u0628\\u0627\\u0634\\u0631 \\u0623\\u0633\\u0628\\u0648\\u0639\\u064a\",\"\\u0644\\u0648\\u062d\\u0629 \\u0627\\u0644\\u0637\\u0627\\u0644\\u0628\",\"\\u062f\\u0641\\u0639 \\u062c\\u0627\\u0647\\u0632 \\u0644\\u062b\\u0648\\u0627\\u0646\\u064a\"]'),
(2,'plus','Plus Plan','الخطة المتقدمة',59.000,590.000,4,'[\"All subjects\",\"Unlimited live rooms\",\"Teacher Q&A\",\"Wablas reminders\"]','[\"\\u062c\\u0645\\u064a\\u0639 \\u0627\\u0644\\u0645\\u0648\\u0627\\u062f\",\"\\u063a\\u0631\\u0641 \\u0645\\u0628\\u0627\\u0634\\u0631\\u0629 \\u063a\\u064a\\u0631 \\u0645\\u062d\\u062f\\u0648\\u062f\\u0629\",\"\\u0623\\u0633\\u0626\\u0644\\u0629 \\u0648\\u0623\\u062c\\u0648\\u0628\\u0629 \\u0645\\u0639 \\u0627\\u0644\\u0645\\u0639\\u0644\\u0645\",\"\\u062a\\u0630\\u0643\\u064a\\u0631\\u0627\\u062a \\u0639\\u0628\\u0631 \\u0648\\u0627\\u0628\\u0644\\u0627\\u0633\"]'),
(3,'pro','Pro Campus','الخطة الاحترافية',89.000,890.000,999,'[\"Priority support\",\"Arabic + English tracks\",\"Admin reporting\",\"Live classroom operations\"]','[\"\\u062f\\u0639\\u0645 \\u0623\\u0648\\u0644\\u0648\\u064a\\u0629\",\"\\u0645\\u0633\\u0627\\u0631\\u0627\\u062a \\u0639\\u0631\\u0628\\u064a\\u0629 \\u0648\\u0625\\u0646\\u062c\\u0644\\u064a\\u0632\\u064a\\u0629\",\"\\u062a\\u0642\\u0627\\u0631\\u064a\\u0631 \\u0625\\u062f\\u0627\\u0631\\u064a\\u0629\",\"\\u062a\\u0634\\u063a\\u064a\\u0644 \\u0627\\u0644\\u0641\\u0635\\u0648\\u0644 \\u0627\\u0644\\u0645\\u0628\\u0627\\u0634\\u0631\\u0629\"]');
/*!40000 ALTER TABLE `plans` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `platform_profile`
--
LOCK TABLES `platform_profile` WRITE;
/*!40000 ALTER TABLE `platform_profile` DISABLE KEYS */;
INSERT IGNORE INTO `platform_profile` (`id`, `name`, `description`, `logo_path`, `favicon_path`, `ctr_no`, `telephone_no`, `email_id`, `wablas_domain`, `wablas_token`, `thawani_secret_key`, `thawani_publishable_key`, `thawani_mode`, `wablas_security_key`, `smtp_host`, `smtp_port`, `smtp_secure`, `smtp_user`, `smtp_pass`, `smtp_from_email`, `smtp_from_name`) VALUES (1,' منصة سمو التعليمية ','منصة تعليمية إلكترونية مرخصة من قبل الجهات المعنية','','','45434','6584','',NULL,NULL,'3333','3333','live',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `platform_profile` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `student_assessments`
--
LOCK TABLES `student_assessments` WRITE;
/*!40000 ALTER TABLE `student_assessments` DISABLE KEYS */;
INSERT IGNORE INTO `student_assessments` (`id`, `activity_id`, `student_id`, `score`, `feedback`, `created_at`) VALUES (1,1,1,85.50,'Good job','2026-04-06 12:45:29');
/*!40000 ALTER TABLE `student_assessments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `student_subscriptions`
--
LOCK TABLES `student_subscriptions` WRITE;
/*!40000 ALTER TABLE `student_subscriptions` DISABLE KEYS */;
INSERT IGNORE INTO `student_subscriptions` (`id`, `full_name`, `email`, `password`, `reset_token`, `reset_expires`, `whatsapp`, `preferred_language`, `plan_key`, `billing_cycle`, `payment_status`, `payment_gateway`, `thawani_reference`, `wablas_opt_in`, `created_at`, `status`, `picture`, `civil_id`) VALUES (1,'Test Student','test.student@example.com',NULL,NULL,NULL,'+96890000000','en','plus','monthly','active','Thawani','THW-20260406033249-179',1,'2026-04-06 03:32:49','active',NULL,NULL),
(2,'Demo Student','demo.student@example.com',NULL,NULL,NULL,'+96891111111','en','plus','monthly','active','Thawani','THW-20260406033255-559',1,'2026-04-06 03:32:55','active',NULL,NULL),
(3,'Mohammed','aalabry@gmail.com',NULL,NULL,NULL,'96899359472','ar','plus','monthly','active','Thawani','THW-20260406123732-241',0,'2026-04-06 12:37:32','active',NULL,NULL),
(4,'Mohammed','aa@aa.aa',NULL,NULL,NULL,'99359472','ar','plus','monthly','active','Thawani','THW-20260406164246-388',0,'2026-04-06 16:42:46','active',NULL,NULL),
(5,'Ahmed Ali','aq@aa.aa',NULL,NULL,NULL,'66643211','ar','plus','monthly','active','Thawani','THW-20260406170007-801',0,'2026-04-06 17:00:07','active',NULL,NULL);
/*!40000 ALTER TABLE `student_subscriptions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `subjects`
--
LOCK TABLES `subjects` WRITE;
/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
INSERT IGNORE INTO `subjects` (`id`, `slug`, `title_en`, `title_ar`, `summary_en`, `summary_ar`, `teacher_en`, `teacher_ar`, `level_en`, `level_ar`, `duration_en`, `duration_ar`, `next_live_en`, `next_live_ar`, `meet_url`, `modules_en`, `modules_ar`, `created_at`, `class_id`, `status`) VALUES (1,'english-fluency','English Fluency Studio','استوديو الطلاقة في الإنجليزية','Speaking-first classrooms for teens and adults with weekly live workshops.','فصول تركّز على المحادثة للمراهقين والبالغين مع ورش مباشرة أسبوعية.','Sarah Coleman','سارة كولمان','Intermediate','متوسط','12 weeks','12 أسبوعاً','Wednesday, April 8, 2026 · 6:00 PM UTC','الأربعاء 8 أبريل 2026 · 6:00 مساءً UTC','https://meet.google.com/','[\"Live speaking labs\",\"Pronunciation clinic\",\"Writing feedback\",\"Weekly vocabulary sprints\"]','[\"\\u0645\\u062e\\u062a\\u0628\\u0631\\u0627\\u062a \\u0645\\u062d\\u0627\\u062f\\u062b\\u0629 \\u0645\\u0628\\u0627\\u0634\\u0631\\u0629\",\"\\u0639\\u064a\\u0627\\u062f\\u0629 \\u0627\\u0644\\u0646\\u0637\\u0642\",\"\\u0645\\u0644\\u0627\\u062d\\u0638\\u0627\\u062a \\u0639\\u0644\\u0649 \\u0627\\u0644\\u0643\\u062a\\u0627\\u0628\\u0629\",\"\\u062f\\u0641\\u0639\\u0627\\u062a \\u0645\\u0641\\u0631\\u062f\\u0627\\u062a \\u0623\\u0633\\u0628\\u0648\\u0639\\u064a\\u0629\"]','2026-04-06 03:37:49',NULL,'active'),
(2,'stem-lab','STEM Lab Foundations','أساسيات مختبر STEM','Math and science pathways with assignments, quizzes, and teacher office hours.','مسارات في الرياضيات والعلوم مع واجبات واختبارات وساعات مكتبية للمعلم.','Omar Al-Harthy','عمر الحارثي','Beginner to Advanced','من مبتدئ إلى متقدم','16 weeks','16 أسبوعاً','Thursday, April 9, 2026 · 5:00 PM UTC','الخميس 9 أبريل 2026 · 5:00 مساءً UTC','https://meet.google.com/','[\"Algebra tracks\",\"Physics demos\",\"Guided worksheets\",\"Lab challenge reviews\"]','[\"\\u0645\\u0633\\u0627\\u0631\\u0627\\u062a \\u0627\\u0644\\u062c\\u0628\\u0631\",\"\\u0639\\u0631\\u0648\\u0636 \\u0641\\u064a\\u0632\\u064a\\u0627\\u0621\",\"\\u0623\\u0648\\u0631\\u0627\\u0642 \\u0639\\u0645\\u0644 \\u0645\\u0648\\u062c\\u0647\\u0629\",\"\\u0645\\u0631\\u0627\\u062c\\u0639\\u0627\\u062a \\u062a\\u062d\\u062f\\u064a\\u0627\\u062a \\u0627\\u0644\\u0645\\u062e\\u062a\\u0628\\u0631\"]','2026-04-06 03:37:49',NULL,'active'),
(3,'arabic-academy','Arabic Language Academy','أكاديمية اللغة العربية','Modern Standard Arabic with reading circles and live grammar sessions.','العربية الفصحى مع حلقات قراءة وجلسات قواعد مباشرة.','Maha Al-Rashdi','مها الراشدي','All levels','جميع المستويات','10 weeks','10 أسابيع','Saturday, April 11, 2026 · 4:00 PM UTC','السبت 11 أبريل 2026 · 4:00 مساءً UTC','https://meet.google.com/','[\"Reading comprehension\",\"Live grammar board\",\"Listening practice\",\"Culture sessions\"]','[\"\\u0641\\u0647\\u0645 \\u0627\\u0644\\u0645\\u0642\\u0631\\u0648\\u0621\",\"\\u0633\\u0628\\u0648\\u0631\\u0629 \\u0642\\u0648\\u0627\\u0639\\u062f \\u0645\\u0628\\u0627\\u0634\\u0631\\u0629\",\"\\u062a\\u062f\\u0631\\u064a\\u0628 \\u0627\\u0644\\u0627\\u0633\\u062a\\u0645\\u0627\\u0639\",\"\\u062c\\u0644\\u0633\\u0627\\u062a \\u062b\\u0642\\u0627\\u0641\\u064a\\u0629\"]','2026-04-06 03:37:49',NULL,'active'),
(4,'design-systems','English','اللغة الإنجليزية','UI foundations, product thinking, and portfolio reviews in live cohorts.','أساسيات الواجهات والتفكير المنتج ومراجعات المحافظ ضمن مجموعات مباشرة.','Lina Mercer','لينا ميرسر','Professional','احترافي','8 weeks','8 أسابيع','Monday, April 13, 2026 · 7:00 PM UTC','الإثنين 13 أبريل 2026 · 7:00 مساءً UTC','https://meet.google.com/','[\"UI critique rooms\",\"Systems thinking\",\"Component audits\",\"Portfolio feedback\"]','[\"\\u063a\\u0631\\u0641 \\u0646\\u0642\\u062f \\u0627\\u0644\\u0648\\u0627\\u062c\\u0647\\u0627\\u062a\",\"\\u062a\\u0641\\u0643\\u064a\\u0631 \\u0627\\u0644\\u0623\\u0646\\u0638\\u0645\\u0629\",\"\\u062a\\u062f\\u0642\\u064a\\u0642 \\u0627\\u0644\\u0645\\u0643\\u0648\\u0646\\u0627\\u062a\",\"\\u0645\\u0644\\u0627\\u062d\\u0638\\u0627\\u062a \\u0639\\u0644\\u0649 \\u0627\\u0644\\u0645\\u062d\\u0641\\u0638\\u0629\"]','2026-04-06 03:37:49',4,'active'),
(5,'english-1b1cc','English','اللغة الإنجليزية','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-04-06 04:43:35',3,'active');
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `teacher_assignments`
--
LOCK TABLES `teacher_assignments` WRITE;
/*!40000 ALTER TABLE `teacher_assignments` DISABLE KEYS */;
INSERT IGNORE INTO `teacher_assignments` (`id`, `teacher_id`, `class_id`, `subject_id`, `created_at`) VALUES (1,1,3,5,'2026-04-06 05:46:28');
/*!40000 ALTER TABLE `teacher_assignments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `teachers`
--
LOCK TABLES `teachers` WRITE;
/*!40000 ALTER TABLE `teachers` DISABLE KEYS */;
INSERT IGNORE INTO `teachers` (`id`, `name`, `email`, `bio`, `photo_path`, `created_at`, `phone`, `password`, `status`) VALUES (1,'Moosa Ali Al-Abri','aalabry@gmail.com','','assets/images/uploads/teacher_1775489347_men.webp','2026-04-06 05:07:32','99359472','$2y$10$Uvj7/WOix7t9Z59YDqP4MuOKhlm.X23QSoVW5TiQ7noBWa9aRE1zS','active');
/*!40000 ALTER TABLE `teachers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT IGNORE INTO `users` (`id`, `name`, `email`, `password`, `reset_token`, `reset_expires`, `role`, `created_at`, `phone`, `profile_picture`) VALUES (1,'Admin','admin@example.com','$2y$10$jpNfKXoZdT8yhnnK/95cGOQ./14fzBrKQmCkq4jR8mIqqFGNAQedm',NULL,NULL,'admin','2026-04-07 04:13:06',NULL,NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2026-04-07 13:32:18