SET FOREIGN_KEY_CHECKS=0; SET UNIQUE_CHECKS=0; /*M!999999\- enable the sandbox mode */ /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `assignments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `lesson_id` bigint(20) unsigned DEFAULT NULL, `course_id` bigint(20) unsigned NOT NULL, `title` varchar(255) NOT NULL, `instructions` longtext NOT NULL, `max_score` decimal(8,2) NOT NULL DEFAULT 100.00, `due_at` timestamp NULL DEFAULT NULL, `allowed_mimes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`allowed_mimes`)), `max_file_mb` int(10) unsigned NOT NULL DEFAULT 10, `rubric` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`rubric`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `assignments_lesson_id_foreign` (`lesson_id`), KEY `assignments_course_id_foreign` (`course_id`), CONSTRAINT `assignments_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE, CONSTRAINT `assignments_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `audit_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT NULL, `action` varchar(255) NOT NULL, `subject_type` varchar(255) DEFAULT NULL, `subject_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)), `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `audit_logs_user_id_foreign` (`user_id`), KEY `audit_logs_subject_type_subject_id_index` (`subject_type`,`subject_id`), CONSTRAINT `audit_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` bigint(20) NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` bigint(20) NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `description` text DEFAULT NULL, `icon` varchar(255) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `position` int(10) unsigned NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `categories_slug_unique` (`slug`), KEY `categories_parent_id_foreign` (`parent_id`), KEY `categories_is_active_index` (`is_active`), CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `certificates` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `number` char(36) NOT NULL, `serial_number` varchar(32) DEFAULT NULL, `integrity_hash` char(64) DEFAULT NULL, `enrollment_id` bigint(20) unsigned NOT NULL, `issued_at` timestamp NOT NULL, `revoked_at` timestamp NULL DEFAULT NULL, `revocation_reason` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `certificates_number_unique` (`number`), UNIQUE KEY `certificates_serial_number_unique` (`serial_number`), KEY `certificates_enrollment_id_foreign` (`enrollment_id`), CONSTRAINT `certificates_enrollment_id_foreign` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollments` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `coupon_course` ( `coupon_id` bigint(20) unsigned NOT NULL, `course_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`coupon_id`,`course_id`), KEY `coupon_course_course_id_foreign` (`course_id`), CONSTRAINT `coupon_course_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE, CONSTRAINT `coupon_course_course_id_foreign` 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 */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `coupons` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(255) NOT NULL, `type` varchar(20) NOT NULL, `value` decimal(12,2) NOT NULL, `minimum_amount` decimal(12,2) NOT NULL DEFAULT 0.00, `usage_limit` int(10) unsigned DEFAULT NULL, `uses` int(10) unsigned NOT NULL DEFAULT 0, `per_user_limit` int(10) unsigned NOT NULL DEFAULT 1, `starts_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `coupons_code_unique` (`code`), KEY `coupons_is_active_index` (`is_active`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `course_prerequisites` ( `course_id` bigint(20) unsigned NOT NULL, `prerequisite_course_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`course_id`,`prerequisite_course_id`), KEY `course_prerequisites_prerequisite_course_id_foreign` (`prerequisite_course_id`), CONSTRAINT `course_prerequisites_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE, CONSTRAINT `course_prerequisites_prerequisite_course_id_foreign` FOREIGN KEY (`prerequisite_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 */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `course_tag` ( `course_id` bigint(20) unsigned NOT NULL, `tag_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`course_id`,`tag_id`), KEY `course_tag_tag_id_foreign` (`tag_id`), CONSTRAINT `course_tag_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE, CONSTRAINT `course_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `course_user` ( `course_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `role` varchar(30) NOT NULL DEFAULT 'collaborator', PRIMARY KEY (`course_id`,`user_id`), KEY `course_user_user_id_foreign` (`user_id`), CONSTRAINT `course_user_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE, CONSTRAINT `course_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `courses` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `instructor_id` bigint(20) unsigned NOT NULL, `category_id` bigint(20) unsigned DEFAULT NULL, `title` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `subtitle` varchar(255) DEFAULT NULL, `description` longtext NOT NULL, `cover_path` varchar(255) DEFAULT NULL, `promo_video_url` varchar(255) DEFAULT NULL, `language` varchar(10) NOT NULL DEFAULT 'es', `level` varchar(30) NOT NULL DEFAULT 'beginner', `duration_minutes` int(10) unsigned NOT NULL DEFAULT 0, `objectives` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`objectives`)), `requirements` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`requirements`)), `audience` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`audience`)), `is_free` tinyint(1) NOT NULL DEFAULT 1, `price` decimal(12,2) NOT NULL DEFAULT 0.00, `sale_price` decimal(12,2) DEFAULT NULL, `currency` varchar(3) NOT NULL DEFAULT 'MXN', `status` varchar(30) NOT NULL DEFAULT 'draft', `is_featured` tinyint(1) NOT NULL DEFAULT 0, `capacity` int(10) unsigned DEFAULT NULL, `access_days` int(10) unsigned DEFAULT NULL, `drip_enabled` tinyint(1) NOT NULL DEFAULT 0, `seo_title` varchar(255) DEFAULT NULL, `seo_description` text DEFAULT NULL, `seo_image_path` varchar(255) DEFAULT NULL, `review_notes` text DEFAULT NULL, `published_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `courses_slug_unique` (`slug`), KEY `courses_instructor_id_foreign` (`instructor_id`), KEY `courses_category_id_status_published_at_index` (`category_id`,`status`,`published_at`), KEY `courses_is_free_index` (`is_free`), KEY `courses_status_index` (`status`), KEY `courses_is_featured_index` (`is_featured`), KEY `courses_published_at_index` (`published_at`), CONSTRAINT `courses_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL, CONSTRAINT `courses_instructor_id_foreign` FOREIGN KEY (`instructor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `discussions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `course_id` bigint(20) unsigned NOT NULL, `lesson_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned NOT NULL, `parent_id` bigint(20) unsigned DEFAULT NULL, `body` text NOT NULL, `is_answer` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `discussions_course_id_foreign` (`course_id`), KEY `discussions_lesson_id_foreign` (`lesson_id`), KEY `discussions_user_id_foreign` (`user_id`), KEY `discussions_parent_id_foreign` (`parent_id`), CONSTRAINT `discussions_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE, CONSTRAINT `discussions_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE, CONSTRAINT `discussions_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `discussions` (`id`) ON DELETE CASCADE, CONSTRAINT `discussions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `enrollments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `course_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `enrolled_by` bigint(20) unsigned DEFAULT NULL, `status` varchar(20) NOT NULL DEFAULT 'active', `progress_percent` decimal(5,2) NOT NULL DEFAULT 0.00, `started_at` timestamp NULL DEFAULT NULL, `completed_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `enrollments_course_id_user_id_unique` (`course_id`,`user_id`), KEY `enrollments_user_id_foreign` (`user_id`), KEY `enrollments_enrolled_by_foreign` (`enrolled_by`), KEY `enrollments_status_index` (`status`), CONSTRAINT `enrollments_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE, CONSTRAINT `enrollments_enrolled_by_foreign` FOREIGN KEY (`enrolled_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `enrollments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` varchar(255) NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`), KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `faqs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `question` varchar(255) NOT NULL, `answer` text NOT NULL, `category` varchar(100) DEFAULT NULL, `audience` varchar(30) NOT NULL DEFAULT 'all', `position` int(10) unsigned NOT NULL DEFAULT 0, `is_published` tinyint(1) NOT NULL DEFAULT 1, `is_featured` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `favorites` ( `user_id` bigint(20) unsigned NOT NULL, `course_id` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`user_id`,`course_id`), KEY `favorites_course_id_foreign` (`course_id`), CONSTRAINT `favorites_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE, CONSTRAINT `favorites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` smallint(5) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `lesson_notes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `lesson_id` bigint(20) unsigned NOT NULL, `content` text NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `lesson_notes_user_id_lesson_id_unique` (`user_id`,`lesson_id`), KEY `lesson_notes_lesson_id_foreign` (`lesson_id`), CONSTRAINT `lesson_notes_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE, CONSTRAINT `lesson_notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `lesson_progress` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `enrollment_id` bigint(20) unsigned NOT NULL, `lesson_id` bigint(20) unsigned NOT NULL, `seconds_watched` int(10) unsigned NOT NULL DEFAULT 0, `last_viewed_at` timestamp NULL DEFAULT NULL, `completed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `lesson_progress_enrollment_id_lesson_id_unique` (`enrollment_id`,`lesson_id`), KEY `lesson_progress_lesson_id_foreign` (`lesson_id`), CONSTRAINT `lesson_progress_enrollment_id_foreign` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollments` (`id`) ON DELETE CASCADE, CONSTRAINT `lesson_progress_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `lessons` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `section_id` bigint(20) unsigned NOT NULL, `title` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `type` varchar(30) NOT NULL DEFAULT 'text', `content` longtext DEFAULT NULL, `media_url` varchar(255) DEFAULT NULL, `file_path` varchar(255) DEFAULT NULL, `file_name` varchar(255) DEFAULT NULL, `duration_minutes` int(10) unsigned NOT NULL DEFAULT 0, `position` int(10) unsigned NOT NULL DEFAULT 0, `is_preview` tinyint(1) NOT NULL DEFAULT 0, `is_published` tinyint(1) NOT NULL DEFAULT 0, `completion_required` tinyint(1) NOT NULL DEFAULT 1, `drip_days` int(10) unsigned NOT NULL DEFAULT 0, `live_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `lessons_section_id_slug_unique` (`section_id`,`slug`), KEY `lessons_section_id_position_index` (`section_id`,`position`), CONSTRAINT `lessons_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; INSERT INTO `migrations` 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,'2026_08_22_000100_create_lms_core_tables',1), (5,'2026_08_22_000200_add_prerequisites_and_question_bank',1), (6,'2026_08_23_180000_add_authentication_fields_to_certificates_table',1), (7,'2026_08_26_120000_expand_public_content_management',1), (8,'2026_08_27_090000_create_module_packages_table',1), (9,'2026_08_27_170000_add_system_update_fields_to_module_packages_table',1); /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `model_has_permissions` ( `permission_id` bigint(20) unsigned NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) 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; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `model_has_roles` ( `role_id` bigint(20) unsigned NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) 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; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `module_packages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `installed_by` bigint(20) unsigned DEFAULT NULL, `package_type` varchar(30) NOT NULL DEFAULT 'module', `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `version` varchar(80) NOT NULL, `author` varchar(160) DEFAULT NULL, `description` text DEFAULT NULL, `status` varchar(30) NOT NULL DEFAULT 'uploaded', `package_path` varchar(255) NOT NULL, `extraction_path` varchar(255) NOT NULL, `file_size` bigint(20) unsigned NOT NULL DEFAULT 0, `checksum` varchar(64) DEFAULT NULL, `manifest` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manifest`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `module_packages_slug_unique` (`slug`), KEY `module_packages_installed_by_foreign` (`installed_by`), KEY `module_packages_status_index` (`status`), KEY `module_packages_package_type_index` (`package_type`), CONSTRAINT `module_packages_installed_by_foreign` FOREIGN KEY (`installed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications` ( `id` char(36) NOT NULL, `type` varchar(255) NOT NULL, `notifiable_type` varchar(255) NOT NULL, `notifiable_id` bigint(20) unsigned NOT NULL, `data` text NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `order_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `course_id` bigint(20) unsigned NOT NULL, `title` varchar(255) NOT NULL, `unit_price` decimal(12,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_items_order_id_foreign` (`order_id`), KEY `order_items_course_id_foreign` (`course_id`), CONSTRAINT `order_items_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`), CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `orders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `number` char(36) NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `coupon_id` bigint(20) unsigned DEFAULT NULL, `status` varchar(20) NOT NULL DEFAULT 'pending', `currency` varchar(3) NOT NULL DEFAULT 'MXN', `subtotal` decimal(12,2) NOT NULL, `discount` decimal(12,2) NOT NULL DEFAULT 0.00, `tax` decimal(12,2) NOT NULL DEFAULT 0.00, `total` decimal(12,2) NOT NULL, `paid_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `orders_number_unique` (`number`), KEY `orders_user_id_foreign` (`user_id`), KEY `orders_coupon_id_foreign` (`coupon_id`), KEY `orders_status_index` (`status`), CONSTRAINT `orders_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE SET NULL, CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `pages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `excerpt` text DEFAULT NULL, `slug` varchar(255) NOT NULL, `content` longtext NOT NULL, `template` varchar(30) NOT NULL DEFAULT 'standard', `is_published` tinyint(1) NOT NULL DEFAULT 0, `show_in_navigation` tinyint(1) NOT NULL DEFAULT 0, `show_in_footer` tinyint(1) NOT NULL DEFAULT 0, `seo_title` varchar(255) DEFAULT NULL, `seo_description` text DEFAULT NULL, `seo_robots` varchar(30) NOT NULL DEFAULT 'index_follow', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pages_slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `payments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `provider` varchar(30) NOT NULL, `provider_reference` varchar(255) DEFAULT NULL, `status` varchar(20) NOT NULL DEFAULT 'pending', `amount` decimal(12,2) NOT NULL, `currency` varchar(3) NOT NULL DEFAULT 'MXN', `proof_path` varchar(255) DEFAULT NULL, `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)), `processed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `payments_order_id_foreign` (`order_id`), KEY `payments_provider_reference_index` (`provider_reference`), KEY `payments_status_index` (`status`), CONSTRAINT `payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `guard_name` varchar(255) 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=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; INSERT INTO `permissions` VALUES (1,'users.view','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (2,'users.manage','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (3,'roles.manage','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (4,'courses.create','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (5,'courses.manage-own','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (6,'courses.moderate','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (7,'enrollments.manage','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (8,'orders.view','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (9,'orders.manage','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (10,'coupons.manage','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (11,'reviews.moderate','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (12,'settings.manage','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (13,'reports.export','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (14,'audit.view','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (15,'certificates.manage','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (16,'modules.manage','web','2026-08-28 06:17:05','2026-08-28 06:17:05'); /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `question_options` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `question_id` bigint(20) unsigned NOT NULL, `text` text NOT NULL, `is_correct` tinyint(1) NOT NULL DEFAULT 0, `position` int(10) unsigned NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `question_options_question_id_foreign` (`question_id`), CONSTRAINT `question_options_question_id_foreign` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `questions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `quiz_id` bigint(20) unsigned NOT NULL, `type` varchar(30) NOT NULL, `prompt` text NOT NULL, `explanation` text DEFAULT NULL, `points` decimal(8,2) NOT NULL DEFAULT 1.00, `position` int(10) unsigned NOT NULL DEFAULT 0, `accepted_answers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`accepted_answers`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `is_bank` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `questions_quiz_id_foreign` (`quiz_id`), KEY `questions_is_bank_index` (`is_bank`), CONSTRAINT `questions_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quizzes` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `quiz_answers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `quiz_attempt_id` bigint(20) unsigned NOT NULL, `question_id` bigint(20) unsigned NOT NULL, `selected_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`selected_options`)), `answer_text` text DEFAULT NULL, `awarded_points` decimal(8,2) DEFAULT NULL, `feedback` text DEFAULT NULL, `needs_review` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `quiz_answers_quiz_attempt_id_question_id_unique` (`quiz_attempt_id`,`question_id`), KEY `quiz_answers_question_id_foreign` (`question_id`), CONSTRAINT `quiz_answers_question_id_foreign` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`) ON DELETE CASCADE, CONSTRAINT `quiz_answers_quiz_attempt_id_foreign` FOREIGN KEY (`quiz_attempt_id`) REFERENCES `quiz_attempts` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `quiz_attempts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `quiz_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `attempt_number` int(10) unsigned NOT NULL, `score` decimal(6,2) DEFAULT NULL, `max_score` decimal(6,2) DEFAULT NULL, `passed` tinyint(1) NOT NULL DEFAULT 0, `started_at` timestamp NOT NULL, `submitted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `quiz_attempts_quiz_id_user_id_attempt_number_unique` (`quiz_id`,`user_id`,`attempt_number`), KEY `quiz_attempts_user_id_foreign` (`user_id`), CONSTRAINT `quiz_attempts_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quizzes` (`id`) ON DELETE CASCADE, CONSTRAINT `quiz_attempts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `quizzes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `lesson_id` bigint(20) unsigned DEFAULT NULL, `course_id` bigint(20) unsigned NOT NULL, `title` varchar(255) NOT NULL, `instructions` text DEFAULT NULL, `time_limit_minutes` int(10) unsigned DEFAULT NULL, `max_attempts` int(10) unsigned NOT NULL DEFAULT 1, `passing_score` decimal(5,2) NOT NULL DEFAULT 70.00, `shuffle_questions` tinyint(1) NOT NULL DEFAULT 0, `shuffle_answers` tinyint(1) NOT NULL DEFAULT 0, `show_results` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `quizzes_lesson_id_foreign` (`lesson_id`), KEY `quizzes_course_id_foreign` (`course_id`), CONSTRAINT `quizzes_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE, CONSTRAINT `quizzes_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `reviews` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `course_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `rating` tinyint(3) unsigned NOT NULL, `comment` text DEFAULT NULL, `status` varchar(20) NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `reviews_course_id_user_id_unique` (`course_id`,`user_id`), KEY `reviews_user_id_foreign` (`user_id`), KEY `reviews_status_index` (`status`), CONSTRAINT `reviews_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE, CONSTRAINT `reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `role_has_permissions` ( `permission_id` bigint(20) unsigned NOT NULL, `role_id` bigint(20) 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; /*!40101 SET character_set_client = @saved_cs_client */; INSERT INTO `role_has_permissions` 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), (1,2), (2,2), (4,2), (5,2), (6,2), (7,2), (8,2), (9,2), (10,2), (11,2), (12,2), (13,2), (14,2), (15,2), (4,3), (5,3), (13,3); /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `guard_name` varchar(255) 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; INSERT INTO `roles` VALUES (1,'superadministrador','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (2,'administrador','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (3,'instructor','web','2026-08-28 06:17:05','2026-08-28 06:17:05'), (4,'estudiante','web','2026-08-28 06:17:05','2026-08-28 06:17:05'); /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `sections` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `course_id` bigint(20) unsigned NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `position` int(10) unsigned NOT NULL DEFAULT 0, `is_published` 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_position_index` (`course_id`,`position`), CONSTRAINT `sections_course_id_foreign` 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 */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) 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; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `group` varchar(60) NOT NULL DEFAULT 'general', `key` varchar(255) NOT NULL, `value` longtext DEFAULT NULL, `type` varchar(30) NOT NULL DEFAULT 'string', `is_public` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settings_key_unique` (`key`), KEY `settings_group_index` (`group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `submissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `assignment_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `comment` text DEFAULT NULL, `file_path` varchar(255) DEFAULT NULL, `original_name` varchar(255) DEFAULT NULL, `score` decimal(8,2) DEFAULT NULL, `feedback` text DEFAULT NULL, `graded_by` bigint(20) unsigned DEFAULT NULL, `submitted_at` timestamp NOT NULL, `graded_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `submissions_assignment_id_user_id_unique` (`assignment_id`,`user_id`), KEY `submissions_user_id_foreign` (`user_id`), KEY `submissions_graded_by_foreign` (`graded_by`), CONSTRAINT `submissions_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE, CONSTRAINT `submissions_graded_by_foreign` FOREIGN KEY (`graded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `submissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `system_installations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `version` varchar(255) NOT NULL, `installed_at` timestamp NOT NULL, `installed_by_ip` varchar(45) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tags` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tags_slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `avatar_path` varchar(255) DEFAULT NULL, `phone` varchar(30) DEFAULT NULL, `bio` text DEFAULT NULL, `status` varchar(20) NOT NULL DEFAULT 'active', `locale` varchar(10) NOT NULL DEFAULT 'es_MX', `notification_preferences` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`notification_preferences`)), `last_login_at` timestamp NULL DEFAULT NULL, `last_login_ip` varchar(45) DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), KEY `users_status_index` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhook_calls` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `provider` varchar(30) NOT NULL, `event_id` varchar(255) NOT NULL, `event_type` varchar(255) DEFAULT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`payload`)), `processed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `webhook_calls_event_id_unique` (`event_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; SET UNIQUE_CHECKS=1; SET FOREIGN_KEY_CHECKS=1;