409 lines
16 KiB
SQL
409 lines
16 KiB
SQL
/*M!999999\- enable the sandbox mode */
|
|
-- MariaDB dump 10.19 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)
|
|
--
|
|
-- Host: localhost 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_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!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 */;
|
|
|
|
--
|
|
-- Table structure for table `classes`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `classes`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `classes` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`name_en` varchar(255) NOT NULL,
|
|
`name_ar` varchar(255) NOT NULL,
|
|
`description_en` text DEFAULT NULL,
|
|
`description_ar` text DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
`status` enum('active','inactive') NOT NULL DEFAULT 'active',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `course_activities`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `course_activities`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `course_activities` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`course_id` int(10) unsigned NOT NULL,
|
|
`title_en` varchar(255) NOT NULL,
|
|
`title_ar` varchar(255) NOT NULL,
|
|
`description_en` text DEFAULT NULL,
|
|
`description_ar` text DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`id`),
|
|
KEY `course_id` (`course_id`),
|
|
CONSTRAINT `course_activities_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `course_live_lessons`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `course_live_lessons`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `course_live_lessons` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`course_id` int(11) NOT NULL,
|
|
`title` varchar(255) NOT NULL,
|
|
`scheduled_at` datetime NOT NULL,
|
|
`status` enum('scheduled','live','ended') DEFAULT 'scheduled',
|
|
`room_name` varchar(255) NOT NULL,
|
|
`meet_url` varchar(500) DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `course_students`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `course_students`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `course_students` (
|
|
`course_id` int(10) unsigned NOT NULL,
|
|
`student_id` int(10) unsigned NOT NULL,
|
|
`assigned_at` timestamp NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`course_id`,`student_id`),
|
|
KEY `student_id` (`student_id`),
|
|
CONSTRAINT `course_students_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `course_students_ibfk_2` FOREIGN KEY (`student_id`) REFERENCES `student_subscriptions` (`id`) ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `courses`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `courses`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `courses` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`name_en` varchar(255) NOT NULL,
|
|
`name_ar` varchar(255) NOT NULL,
|
|
`description_en` text DEFAULT NULL,
|
|
`description_ar` text DEFAULT NULL,
|
|
`price` decimal(10,2) DEFAULT 0.00,
|
|
`picture` varchar(255) DEFAULT NULL,
|
|
`status` enum('active','inactive') DEFAULT 'active',
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
`teacher_id` int(11) DEFAULT NULL,
|
|
`max_students` int(11) DEFAULT NULL,
|
|
`registration_open` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `landing_settings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `landing_settings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `landing_settings` (
|
|
`setting_key` varchar(100) NOT NULL,
|
|
`value_en` text DEFAULT NULL,
|
|
`value_ar` text DEFAULT NULL,
|
|
PRIMARY KEY (`setting_key`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `module_progress`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `module_progress`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `module_progress` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`subscription_id` int(10) unsigned NOT NULL,
|
|
`subject_slug` varchar(100) NOT NULL,
|
|
`module_index` int(10) unsigned NOT NULL,
|
|
`completed_at` timestamp NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `subscription_id` (`subscription_id`,`subject_slug`,`module_index`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `plans`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `plans`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `plans` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`plan_key` varchar(50) NOT NULL,
|
|
`name_en` varchar(120) NOT NULL,
|
|
`name_ar` varchar(120) NOT NULL,
|
|
`price_monthly` decimal(10,3) NOT NULL,
|
|
`price_yearly` decimal(10,3) NOT NULL,
|
|
`subjects_limit` int(11) DEFAULT 1,
|
|
`features_en` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`features_en`)),
|
|
`features_ar` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`features_ar`)),
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `plan_key` (`plan_key`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `platform_profile`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `platform_profile`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `platform_profile` (
|
|
`id` int(11) NOT NULL DEFAULT 1,
|
|
`name` varchar(255) DEFAULT NULL,
|
|
`description` text DEFAULT NULL,
|
|
`logo_path` varchar(255) DEFAULT NULL,
|
|
`favicon_path` varchar(255) DEFAULT NULL,
|
|
`ctr_no` varchar(255) DEFAULT NULL,
|
|
`telephone_no` varchar(255) DEFAULT NULL,
|
|
`email_id` varchar(255) DEFAULT NULL,
|
|
`wablas_domain` varchar(255) DEFAULT NULL,
|
|
`wablas_token` varchar(255) DEFAULT NULL,
|
|
`thawani_secret_key` varchar(255) DEFAULT NULL,
|
|
`thawani_publishable_key` varchar(255) DEFAULT NULL,
|
|
`thawani_mode` varchar(50) DEFAULT 'test',
|
|
`wablas_security_key` varchar(255) DEFAULT NULL,
|
|
`smtp_host` varchar(255) DEFAULT NULL,
|
|
`smtp_port` varchar(50) DEFAULT NULL,
|
|
`smtp_secure` varchar(50) DEFAULT NULL,
|
|
`smtp_user` varchar(255) DEFAULT NULL,
|
|
`smtp_pass` varchar(255) DEFAULT NULL,
|
|
`smtp_from_email` varchar(255) DEFAULT NULL,
|
|
`smtp_from_name` varchar(255) DEFAULT NULL,
|
|
`terms` text DEFAULT NULL,
|
|
`privacy_policy` text DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `role_permissions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `role_permissions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `role_permissions` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`role_id` int(11) NOT NULL,
|
|
`page` varchar(50) NOT NULL,
|
|
`can_view` tinyint(1) DEFAULT 0,
|
|
`can_add` tinyint(1) DEFAULT 0,
|
|
`can_edit` tinyint(1) DEFAULT 0,
|
|
`can_delete` tinyint(1) DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `role_page` (`role_id`,`page`),
|
|
CONSTRAINT `role_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `roles`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `roles`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `roles` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`description` text DEFAULT NULL,
|
|
`is_system` tinyint(1) DEFAULT 0,
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `student_assessments`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `student_assessments`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `student_assessments` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`activity_id` int(10) unsigned NOT NULL,
|
|
`student_id` int(10) unsigned NOT NULL,
|
|
`score` decimal(5,2) DEFAULT NULL,
|
|
`feedback` text DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `activity_id` (`activity_id`,`student_id`),
|
|
KEY `student_id` (`student_id`),
|
|
CONSTRAINT `student_assessments_ibfk_1` FOREIGN KEY (`activity_id`) REFERENCES `course_activities` (`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `student_assessments_ibfk_2` FOREIGN KEY (`student_id`) REFERENCES `student_subscriptions` (`id`) ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `student_subscriptions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `student_subscriptions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `student_subscriptions` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`full_name` varchar(120) NOT NULL,
|
|
`email` varchar(190) NOT NULL,
|
|
`password` varchar(255) DEFAULT NULL,
|
|
`reset_token` varchar(255) DEFAULT NULL,
|
|
`reset_expires` datetime DEFAULT NULL,
|
|
`whatsapp` varchar(40) NOT NULL,
|
|
`preferred_language` varchar(5) NOT NULL DEFAULT 'en',
|
|
`plan_key` varchar(20) NOT NULL,
|
|
`billing_cycle` varchar(20) NOT NULL DEFAULT 'monthly',
|
|
`payment_status` varchar(20) NOT NULL DEFAULT 'active',
|
|
`payment_gateway` varchar(30) NOT NULL DEFAULT 'Thawani',
|
|
`thawani_reference` varchar(80) NOT NULL,
|
|
`wablas_opt_in` tinyint(1) NOT NULL DEFAULT 0,
|
|
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
|
|
`status` enum('active','inactive') NOT NULL DEFAULT 'active',
|
|
`picture` varchar(255) DEFAULT NULL,
|
|
`civil_id` varchar(50) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `subjects`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `subjects`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `subjects` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`slug` varchar(100) NOT NULL,
|
|
`title_en` varchar(255) NOT NULL,
|
|
`title_ar` varchar(255) NOT NULL,
|
|
`summary_en` text DEFAULT NULL,
|
|
`summary_ar` text DEFAULT NULL,
|
|
`teacher_en` varchar(120) DEFAULT NULL,
|
|
`teacher_ar` varchar(120) DEFAULT NULL,
|
|
`level_en` varchar(50) DEFAULT NULL,
|
|
`level_ar` varchar(50) DEFAULT NULL,
|
|
`duration_en` varchar(50) DEFAULT NULL,
|
|
`duration_ar` varchar(50) DEFAULT NULL,
|
|
`next_live_en` varchar(120) DEFAULT NULL,
|
|
`next_live_ar` varchar(120) DEFAULT NULL,
|
|
`meet_url` varchar(255) DEFAULT NULL,
|
|
`modules_en` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`modules_en`)),
|
|
`modules_ar` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`modules_ar`)),
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
`class_id` int(10) unsigned DEFAULT NULL,
|
|
`status` enum('active','inactive') NOT NULL DEFAULT 'active',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `slug` (`slug`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `teacher_assignments`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `teacher_assignments`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `teacher_assignments` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`teacher_id` int(11) NOT NULL,
|
|
`class_id` int(11) NOT NULL,
|
|
`subject_id` int(11) NOT NULL DEFAULT 0,
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `unique_assignment` (`teacher_id`,`class_id`,`subject_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `teachers`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `teachers`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `teachers` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`email` varchar(255) DEFAULT NULL,
|
|
`bio` text DEFAULT NULL,
|
|
`photo_path` varchar(255) DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
`phone` varchar(50) DEFAULT NULL,
|
|
`password` varchar(255) DEFAULT NULL,
|
|
`status` enum('active','inactive') NOT NULL DEFAULT 'active',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `users`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `users`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `users` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`email` varchar(255) NOT NULL,
|
|
`password` varchar(255) NOT NULL,
|
|
`reset_token` varchar(255) DEFAULT NULL,
|
|
`reset_expires` datetime DEFAULT NULL,
|
|
`role` enum('admin','user') DEFAULT 'admin',
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
`phone` varchar(50) DEFAULT NULL,
|
|
`profile_picture` varchar(255) DEFAULT NULL,
|
|
`role_id` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `email` (`email`),
|
|
KEY `fk_user_role` (`role_id`),
|
|
CONSTRAINT `fk_user_role` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE SET NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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-11 15:49:39
|