-- MariaDB dump 10.19 Distrib 10.4.28-MariaDB, for osx10.10 (x86_64) -- -- Host: localhost Database: webpanel -- ------------------------------------------------------ -- Server version 10.4.28-MariaDB /*!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 `admissions` -- DROP TABLE IF EXISTS `admissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `admissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `level_id` bigint(20) unsigned DEFAULT NULL, `guardian_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) DEFAULT NULL, `student_name` varchar(255) NOT NULL, `birth_date` date DEFAULT NULL, `message` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'pendiente', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `admissions_level_id_foreign` (`level_id`), CONSTRAINT `admissions_level_id_foreign` FOREIGN KEY (`level_id`) REFERENCES `levels` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admissions` -- LOCK TABLES `admissions` WRITE; /*!40000 ALTER TABLE `admissions` DISABLE KEYS */; INSERT INTO `admissions` VALUES (1,2,'Carmen Lopez','carmen.lopez@email.com','+51 955 123 456','Mateo Lopez','2015-04-12','Deseo inscribir a mi hijo para el proximo anio escolar en primaria.','pendiente','2026-08-14 21:28:54','2026-08-14 21:28:54'),(2,1,'Jose Diaz','jose.diaz@email.com','+51 944 789 123','Valeria Diaz','2019-09-03','Consulta sobre vacantes en el nivel inicial.','en_revision','2026-08-14 21:28:54','2026-08-14 21:28:54'); /*!40000 ALTER TABLE `admissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) 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 */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) 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 */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contacts` -- DROP TABLE IF EXISTS `contacts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contacts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `subject` varchar(255) DEFAULT NULL, `message` text NOT NULL, `is_read` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contacts` -- LOCK TABLES `contacts` WRITE; /*!40000 ALTER TABLE `contacts` DISABLE KEYS */; INSERT INTO `contacts` VALUES (1,'Andrea Suarez','andrea.suarez@email.com','Informacion sobre matricula','Hola, me gustaria recibir mas informacion sobre el proceso de matricula para secundaria.',1,'2026-08-14 21:28:54','2026-08-14 21:39:34'),(2,'Miguel Rojas','miguel.rojas@email.com','Consulta sobre becas','Buenas tardes, quisiera conocer los requisitos para postular a una beca academica.',1,'2026-08-14 21:28:54','2026-08-14 21:57:39'); /*!40000 ALTER TABLE `contacts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `document_categories` -- DROP TABLE IF EXISTS `document_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `document_categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `order` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `document_categories_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `document_categories` -- LOCK TABLES `document_categories` WRITE; /*!40000 ALTER TABLE `document_categories` DISABLE KEYS */; INSERT INTO `document_categories` VALUES (1,'Comunicados',1,'2026-08-16 01:42:25','2026-08-16 01:42:25'),(2,'Reglamentos',2,'2026-08-16 01:42:25','2026-08-16 01:42:25'),(3,'Matricula',3,'2026-08-16 01:42:25','2026-08-16 01:42:25'),(4,'Boletines',4,'2026-08-16 01:42:25','2026-08-16 01:42:25'); /*!40000 ALTER TABLE `document_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents` -- DROP TABLE IF EXISTS `documents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `file` varchar(255) NOT NULL, `file_type` varchar(255) DEFAULT NULL, `category` varchar(255) DEFAULT NULL, `published_at` date DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents` -- LOCK TABLES `documents` WRITE; /*!40000 ALTER TABLE `documents` DISABLE KEYS */; INSERT INTO `documents` VALUES (1,'titulo documentos','descripcion','documents/6KRzZ6CQFgEqjTT3MfERyPoioWXGVj2LZb6n6n6O.pdf','pdf','Comunicados','2026-08-15',0,1,'2026-08-16 01:32:31','2026-08-16 01:43:55'),(6,'Comunicado oficial N° 001','Documento de ejemplo para visualizar la seccion de publicaciones.','documents/demo-1.pdf','pdf','Comunicados','2026-08-12',1,1,'2026-08-16 03:33:19','2026-08-16 03:33:19'),(7,'Comunicado: inicio de clases','Documento de ejemplo para visualizar la seccion de publicaciones.','documents/demo-2.pdf','pdf','Comunicados','2026-08-10',2,1,'2026-08-16 03:33:19','2026-08-16 03:33:19'),(8,'Reglamento interno 2026','Documento de ejemplo para visualizar la seccion de publicaciones.','documents/demo-3.docx','docx','Reglamentos','2026-08-08',3,1,'2026-08-16 03:33:19','2026-08-16 03:33:19'),(9,'Cronograma de matricula','Documento de ejemplo para visualizar la seccion de publicaciones.','documents/demo-4.xlsx','xlsx','Matricula','2026-08-05',4,1,'2026-08-16 03:33:19','2026-08-16 03:33:19'),(10,'Ficha de inscripcion','Documento de ejemplo para visualizar la seccion de publicaciones.','documents/demo-5.pdf','pdf','Matricula','2026-08-03',5,1,'2026-08-16 03:33:19','2026-08-16 03:33:19'),(11,'Boletin informativo - Agosto','Documento de ejemplo para visualizar la seccion de publicaciones.','documents/demo-6.pdf','pdf','Boletines','2026-08-01',6,1,'2026-08-16 03:33:19','2026-08-16 03:33:19'),(12,'Presentacion institucional','Documento de ejemplo para visualizar la seccion de publicaciones.','documents/demo-7.pptx','pptx','Boletines','2026-07-28',7,1,'2026-08-16 03:33:19','2026-08-16 03:33:19'); /*!40000 ALTER TABLE `documents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `events` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `event_date` date NOT NULL, `event_time` time DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `events` -- LOCK TABLES `events` WRITE; /*!40000 ALTER TABLE `events` DISABLE KEYS */; INSERT INTO `events` VALUES (1,'Matriculas abiertas 2026','Proceso de matricula para el anio escolar 2026 en todos los niveles.','Oficina de admisiones','2026-08-29','09:00:00','https://picsum.photos/seed/event-matriculas-abiertas-2026/900/500',1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(2,'Dia de la familia','Jornada de integracion con actividades recreativas y deportivas para toda la comunidad educativa.','Patio principal','2026-09-08','10:00:00','https://picsum.photos/seed/event-dia-de-la-familia/900/500',1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(3,'Festival de danza y musica','Presentaciones artisticas de los estudiantes de todos los niveles.','Auditorio central','2026-09-23','16:00:00','https://picsum.photos/seed/event-festival-de-danza-y-musica/900/500',1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(4,'Ceremonia de clausura','Ceremonia de fin de anio y despedida de la promocion saliente.','Auditorio central','2026-11-12','18:00:00','https://picsum.photos/seed/event-ceremonia-de-clausura/900/500',1,'2026-08-14 21:28:54','2026-08-14 21:28:54'); /*!40000 ALTER TABLE `events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gallery` -- DROP TABLE IF EXISTS `gallery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gallery` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `image` varchar(255) NOT NULL, `category` varchar(255) DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gallery` -- LOCK TABLES `gallery` WRITE; /*!40000 ALTER TABLE `gallery` DISABLE KEYS */; INSERT INTO `gallery` VALUES (1,'Imagen 1','https://picsum.photos/seed/gallery-1/800/600','Instalaciones',1,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(2,'Imagen 2','https://picsum.photos/seed/gallery-2/800/600','Eventos',2,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(3,'Imagen 3','https://picsum.photos/seed/gallery-3/800/600','Actividades',3,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(4,'Imagen 4','https://picsum.photos/seed/gallery-4/800/600','Deportes',4,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(5,'Imagen 5','https://picsum.photos/seed/gallery-5/800/600','Instalaciones',5,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(8,'titulo imagen 01x','gallery/r7nlotmnYcKptNDjOdR6E4ZD7CER3oWhYNlw9UXg.jpg','Instalaciones',0,1,'2026-08-15 09:52:38','2026-08-15 20:39:13'); /*!40000 ALTER TABLE `gallery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gallery_categories` -- DROP TABLE IF EXISTS `gallery_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gallery_categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `order` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `gallery_categories_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gallery_categories` -- LOCK TABLES `gallery_categories` WRITE; /*!40000 ALTER TABLE `gallery_categories` DISABLE KEYS */; INSERT INTO `gallery_categories` VALUES (1,'Instalaciones',1,'2026-08-15 09:41:43','2026-08-15 09:41:43'),(2,'Eventos',2,'2026-08-15 09:41:43','2026-08-15 09:41:43'),(3,'Actividades',3,'2026-08-15 09:41:43','2026-08-15 09:41:43'),(4,'Deportes',4,'2026-08-15 09:41:43','2026-08-15 09:41:43'); /*!40000 ALTER TABLE `gallery_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `hero_slides` -- DROP TABLE IF EXISTS `hero_slides`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hero_slides` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `image` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `subtitle` varchar(255) DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `hero_slides` -- LOCK TABLES `hero_slides` WRITE; /*!40000 ALTER TABLE `hero_slides` DISABLE KEYS */; INSERT INTO `hero_slides` VALUES (1,'hero/A16D2olgBvs3312dkSNbpOepjCB72MBlDf0NRaf8.png','Educacion de excelencia para tus hijos','Mas de 25 anos formando estudiantes con valores, conocimiento y vision de futuro',0,1,'2026-08-16 21:55:18','2026-08-16 22:34:24'),(3,'hero/aL1iLUl4B5AOZq6rPfJv5iXh1wJhXXzBNve9venD.png',NULL,NULL,2,1,'2026-08-16 22:06:19','2026-08-17 06:33:10'); /*!40000 ALTER TABLE `hero_slides` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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 */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) 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 */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `levels` -- DROP TABLE IF EXISTS `levels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `levels` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `icon` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `image2` varchar(255) DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `levels_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `levels` -- LOCK TABLES `levels` WRITE; /*!40000 ALTER TABLE `levels` DISABLE KEYS */; INSERT INTO `levels` VALUES (1,'Inicial','inicial','bi-mortarboard','
Nivel inicial para ninos de 3 a 5 anos, con un enfoque ludico que estimula la curiosidad, la creatividad y la socializacion.

','https://picsum.photos/seed/inicial/800/500',NULL,1,1,'2026-08-14 21:28:54','2026-08-16 07:44:09'),(2,'Primaria','primaria','bi-book','
Primaria de 1ro a 6to grado, consolidando la lectoescritura, el razonamiento matematico y los valores en un ambiente seguro.

','https://picsum.photos/seed/primaria/800/500',NULL,2,1,'2026-08-14 21:28:54','2026-08-16 04:19:27'),(3,'Secundaria','secundaria','bi-pencil-square','
Secundaria de 1ro a 5to, preparando a los estudiantes para la universidad y la vida con pensamiento critico y tecnologia.

','https://picsum.photos/seed/secundaria/800/500',NULL,3,1,'2026-08-14 21:28:54','2026-08-16 07:44:21'),(5,'CEBA','ceba',NULL,'
ceba contenido
','levels/azE6rkO7GX5ZXwaGvIVFd306EslGAdsBKC674FHx.png',NULL,4,1,'2026-08-16 04:13:28','2026-08-16 04:19:23'); /*!40000 ALTER TABLE `levels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; 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_07_21_033709_create_sites_table',1),(5,'2026_08_14_100000_create_school_settings_table',1),(6,'2026_08_14_100100_create_levels_table',1),(7,'2026_08_14_100200_create_news_table',1),(8,'2026_08_14_100300_create_events_table',1),(9,'2026_08_14_100400_create_teachers_table',1),(10,'2026_08_14_100500_create_gallery_table',1),(11,'2026_08_14_100600_create_testimonials_table',1),(12,'2026_08_14_100700_create_admissions_table',1),(13,'2026_08_14_100800_create_contacts_table',1),(14,'2026_08_14_110000_add_colors_to_school_settings_table',2),(15,'2026_08_14_120000_create_gallery_categories_table',3),(16,'2026_08_15_010000_create_videos_table',4),(17,'2026_08_15_020000_add_show_sections_to_school_settings_table',5),(18,'2026_08_15_030000_add_section_titles_to_school_settings_table',6),(19,'2026_08_15_040000_add_admissions_section_to_school_settings_table',7),(20,'2026_08_15_050000_add_sections_order_to_school_settings_table',8),(21,'2026_08_15_060000_add_whatsapp_to_school_settings_table',9),(22,'2026_08_15_070000_create_documents_table',10),(23,'2026_08_15_080000_add_categories_to_documents_table',11),(24,'2026_08_15_090000_add_documents_section_to_school_settings_table',12),(25,'2026_08_15_100000_add_image2_to_levels_table',13),(26,'2026_08_15_110000_add_about_images_to_school_settings_table',14),(27,'2026_08_15_120000_add_about_content_to_school_settings_table',15),(28,'2026_08_16_010000_add_access_blocks_to_school_settings_table',16),(29,'2026_08_16_020000_add_show_access_to_school_settings_table',17),(30,'2026_08_16_030000_add_access_bg_to_school_settings_table',18),(31,'2026_08_16_040000_create_hero_slides_table',19),(32,'2026_08_16_050000_add_hero_effect_to_school_settings_table',20),(33,'2026_08_16_060000_add_logo_horizontal_to_school_settings_table',21),(34,'2026_08_16_070000_add_logo_mode_to_school_settings_table',22),(35,'2026_08_16_080000_create_nav_items_table',23),(36,'2026_08_16_090000_add_parent_id_to_nav_items_table',24),(37,'2026_08_17_010000_add_color_to_nav_items_table',25),(38,'2026_08_17_020000_add_account_fields_to_users_table',26),(39,'2026_08_17_030000_add_role_to_users_table',27); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nav_items` -- DROP TABLE IF EXISTS `nav_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nav_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` bigint(20) unsigned DEFAULT NULL, `label` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `icon` varchar(255) DEFAULT NULL, `type` varchar(255) NOT NULL DEFAULT 'link', `color` varchar(255) DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `nav_items_parent_id_foreign` (`parent_id`), CONSTRAINT `nav_items_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `nav_items` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nav_items` -- LOCK TABLES `nav_items` WRITE; /*!40000 ALTER TABLE `nav_items` DISABLE KEYS */; INSERT INTO `nav_items` VALUES (1,NULL,'Inicio','home','bi-house','link',NULL,1,1,'2026-08-17 12:11:38','2026-08-17 12:11:38'),(2,NULL,'Niveles','#niveles','bi-layers','link',NULL,2,1,'2026-08-17 12:11:38','2026-08-17 12:11:38'),(3,NULL,'Noticias','#noticias','bi-newspaper','link',NULL,3,1,'2026-08-17 12:11:38','2026-08-17 12:11:38'),(4,NULL,'Eventos','#eventos','bi-calendar-event','link',NULL,4,1,'2026-08-17 12:11:38','2026-08-17 12:11:38'),(5,NULL,'Documentos','documentos','bi-file-earmark-text','link',NULL,5,1,'2026-08-17 12:11:38','2026-08-17 12:11:38'),(6,NULL,'Admisiones','admisiones','bi-pencil-square','link',NULL,6,1,'2026-08-17 12:11:38','2026-08-17 12:11:38'),(7,NULL,'Contactenos','contacto','bi-headset','button',NULL,7,1,'2026-08-17 12:11:38','2026-08-17 12:11:38'); /*!40000 ALTER TABLE `nav_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `news` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `excerpt` varchar(255) DEFAULT NULL, `content` longtext DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `published_at` timestamp NULL DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `news_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `news` -- LOCK TABLES `news` WRITE; /*!40000 ALTER TABLE `news` DISABLE KEYS */; INSERT INTO `news` VALUES (1,'Inauguramos nuevo laboratorio de ciencias','inauguramos-nuevo-laboratorio-de-ciencias','Nuestros estudiantes ya cuentan con un moderno laboratorio equipado para sus practicas de quimica y biologia.','
Con gran entusiasmo anunciamos la apertura de nuestro nuevo laboratorio de ciencias, un espacio pensado para que los estudiantes vivan la ciencia de forma practica y segura.

El laboratorio cuenta con equipos modernos, insumos de calidad y estaciones de trabajo colaborativo que permitiran desarrollar proyectos de investigacion desde primaria hasta secundaria.

','https://picsum.photos/seed/news-inauguramos-nuevo-laboratorio-de-ciencias/900/500','2026-08-12 21:28:00',1,'2026-08-14 21:28:54','2026-08-15 21:54:05'),(2,'Feria de ciencias 2026: innovacion y creatividad','feria-de-ciencias-2026-innovacion-y-creatividad','Estudiantes de todos los niveles presentaron mas de 40 proyectos en la feria anual de ciencias.','

La feria de ciencias de este ano supero todas las expectativas. Los estudiantes presentaron proyectos que van desde energia renovable hasta robotica educativa.

Felicitamos a todos los participantes y a las familias que acompanaron esta gran jornada.

','https://picsum.photos/seed/news-feria-de-ciencias-2026-innovacion-y-creatividad/900/500','2026-08-04 21:28:54',1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(3,'Campeones regionales de futbol escolar','campeones-regionales-de-futbol-escolar','Nuestra seleccion sub-14 se corono campeona del torneo regional intercolegial.','

La seleccion de futbol del Colegio Horizontes se consagro campeona del torneo regional, demostrando disciplina, trabajo en equipo y espiritu deportivo.

Agradecemos a los entrenadores y a las familias por su apoyo incondicional.

','https://picsum.photos/seed/news-campeones-regionales-de-futbol-escolar/900/500','2026-07-25 21:28:54',1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(4,'Inicio del programa de becas academicas','inicio-del-programa-de-becas-academicas','Abrimos inscripciones para el programa de becas destinado a estudiantes con excelencia academica.','

Comprometidos con la educacion, lanzamos nuestro programa de becas academicas 2026. Los estudiantes destacados podran acceder a descuentos en la pension mensual.

Las inscripciones estan abiertas en la oficina de admisiones.

','https://picsum.photos/seed/news-inicio-del-programa-de-becas-academicas/900/500','2026-07-15 21:28:54',1,'2026-08-14 21:28:54','2026-08-14 21:28:54'); /*!40000 ALTER TABLE `news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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 */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `school_settings` -- DROP TABLE IF EXISTS `school_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `school_settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `slogan` varchar(255) DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `logo_horizontal` varchar(255) DEFAULT NULL, `logo_mode` varchar(255) NOT NULL DEFAULT 'shield', `hero_image` varchar(255) DEFAULT NULL, `hero_title` varchar(255) DEFAULT NULL, `hero_subtitle` varchar(255) DEFAULT NULL, `hero_effect` varchar(255) NOT NULL DEFAULT 'slide', `mission` text DEFAULT NULL, `vision` text DEFAULT NULL, `history` text DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `schedule` varchar(255) DEFAULT NULL, `facebook` varchar(255) DEFAULT NULL, `instagram` varchar(255) DEFAULT NULL, `twitter` varchar(255) DEFAULT NULL, `youtube` varchar(255) DEFAULT NULL, `tiktok` varchar(255) DEFAULT NULL, `primary_color` varchar(20) NOT NULL DEFAULT '#2563eb', `accent_color` varchar(20) NOT NULL DEFAULT '#facc15', `show_levels` tinyint(1) NOT NULL DEFAULT 1, `show_news` tinyint(1) NOT NULL DEFAULT 1, `show_events` tinyint(1) NOT NULL DEFAULT 1, `show_teachers` tinyint(1) NOT NULL DEFAULT 1, `show_gallery` tinyint(1) NOT NULL DEFAULT 1, `show_videos` tinyint(1) NOT NULL DEFAULT 1, `show_contact` tinyint(1) NOT NULL DEFAULT 1, `show_testimonials` tinyint(1) NOT NULL DEFAULT 1, `show_admissions` tinyint(1) NOT NULL DEFAULT 1, `admissions_title` text DEFAULT NULL, `admissions_subtitle` text DEFAULT NULL, `sections_order` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`sections_order`)), `show_whatsapp` tinyint(1) NOT NULL DEFAULT 1, `whatsapp_number` varchar(20) DEFAULT NULL, `show_documents` tinyint(1) NOT NULL DEFAULT 1, `show_access` tinyint(1) NOT NULL DEFAULT 1, `documents_title` text DEFAULT NULL, `documents_subtitle` text DEFAULT NULL, `about_image1` varchar(255) DEFAULT NULL, `about_image2` varchar(255) DEFAULT NULL, `about_content` longtext DEFAULT NULL, `access1_content` longtext DEFAULT NULL, `access1_bg` varchar(255) DEFAULT NULL, `access2_content` longtext DEFAULT NULL, `access2_bg` varchar(255) DEFAULT NULL, `access3_content` longtext DEFAULT NULL, `access3_bg` varchar(255) DEFAULT NULL, `access4_content` longtext DEFAULT NULL, `access4_bg` varchar(255) DEFAULT NULL, `levels_title` text DEFAULT NULL, `levels_subtitle` text DEFAULT NULL, `news_title` text DEFAULT NULL, `news_subtitle` text DEFAULT NULL, `events_title` text DEFAULT NULL, `events_subtitle` text DEFAULT NULL, `teachers_title` text DEFAULT NULL, `teachers_subtitle` text DEFAULT NULL, `gallery_title` text DEFAULT NULL, `gallery_subtitle` text DEFAULT NULL, `videos_title` text DEFAULT NULL, `videos_subtitle` text DEFAULT NULL, `testimonials_title` text DEFAULT NULL, `testimonials_subtitle` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `school_settings` -- LOCK TABLES `school_settings` WRITE; /*!40000 ALTER TABLE `school_settings` DISABLE KEYS */; INSERT INTO `school_settings` VALUES (1,'Colegio SIGEDU','Formando lideres para el manana','settings/kTknjZkReXCRcgSFM4QpX15qeX4cALtjbUOzkIgM.png','settings/0VN6H8oap7rup4MOysRVi2Cl5R5Q5w28wZ26ftGq.png','horizontal','settings/lYwdJZrVOlTW8EHygGRKsl8YHM5uXZxwkdGuJ8JJ.png','Educacion de excelencia para tus hijos','Mas de 25 anos formando estudiantes con valores, conocimiento y vision de futuro.','vertical','Brindar una educacion integral de calidad, basada en valores, que desarrolle las capacidades academicas, artisticas y deportivas de cada estudiante.','Ser una institucion lider en la region, reconocida por la excelencia academica y la formacion de ciudadanos comprometidos con la sociedad.','Fundado en 1998, el Colegio Horizontes ha crecido junto a la comunidad, consolidandose como un referente educativo por su enfoque humano e innovador.','Av. Los Maestros 123, San Isidro','+51 999 888 777','contacto@colegiohorizontes.edu.pe','Lunes a Viernes - 8:00 am a 3:30 pm','https://facebook.com/colegiohorizontes','https://instagram.com/colegiohorizontes','https://twitter.com/colegiohorizontes','https://youtube.com/colegiohorizontes','https://tiktok.com/@colegiohorizontes','#2563eb','#facc15',1,1,1,1,1,1,1,1,1,NULL,NULL,'[\"levels\",\"news\",\"events\",\"teachers\",\"gallery\",\"videos\",\"testimonials\"]',1,'+51 999 888 777',1,1,NULL,NULL,NULL,NULL,'

\"Cargando...\"\"imagen\"

¿Por qué estudiar en TúColegio?


Porque creemos en una educación que combina aprendizaje, valores e innovación, acompañando a cada estudiante para que descubra su potencial y construya su futuro.

Nuestro compromiso

Aprender sin límites. Crecer con propósito. Liderar el mañana.

\"Cargando...\"\"Cargando...\"\"Cargando...\"\"Cargando...\"\"imagen\"
','
Mesa de PartesTramites y documentos
','#fafafa','
PublicacionesDocumentos y recursos
','#fafafa','
SIGEDUPlataforma Educativa
',NULL,'
Admision 2027Inscripciones abiertas
',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-14 21:28:54','2026-08-17 12:16:50'); /*!40000 ALTER TABLE `school_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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 */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES ('RoHFHtpxu32iObMdoOT84RTnmWu0qH4st6oJS0TO',1,'::1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoibUtnQWR0c2I1Q0tESnBqbU00T0VWVWlzS0s1NUVGMEV1b3F2STVzcCI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjYwOiJodHRwOi8vbG9jYWxob3N0L1BST1lFQ1RPUy9MQVJBVkVML3dlYnBhbmVsL3B1YmxpYy9kYXNoYm9hcmQiO3M6NToicm91dGUiO3M6OToiZGFzaGJvYXJkIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1787025455); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sites` -- DROP TABLE IF EXISTS `sites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sites` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL, `description` text DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `sites_domain_unique` (`domain`), KEY `sites_user_id_foreign` (`user_id`), CONSTRAINT `sites_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 */; -- -- Dumping data for table `sites` -- LOCK TABLES `sites` WRITE; /*!40000 ALTER TABLE `sites` DISABLE KEYS */; /*!40000 ALTER TABLE `sites` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `teachers` -- DROP TABLE IF EXISTS `teachers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `teachers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `position` varchar(255) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `photo` varchar(255) DEFAULT NULL, `bio` text DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `teachers` -- LOCK TABLES `teachers` WRITE; /*!40000 ALTER TABLE `teachers` DISABLE KEYS */; INSERT INTO `teachers` VALUES (1,'Maria Fernandez','Directora General','Gestion Educativa','maria.fernandez@colegiohorizontes.edu.pe','https://i.pravatar.cc/300?img=69','

Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.

',1,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(2,'Carlos Rodriguez','Docente de Matematicas','Matematicas','carlos.rodriguez@colegiohorizontes.edu.pe','https://i.pravatar.cc/300?img=61','

Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.

',2,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(3,'Lucia Gomez','Docente de Comunicacion','Lengua y Literatura','lucia.gomez@colegiohorizontes.edu.pe','https://i.pravatar.cc/300?img=23','

Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.

',3,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(4,'Jorge Perez','Docente de Ciencias','Quimica y Biologia','jorge.perez@colegiohorizontes.edu.pe','https://i.pravatar.cc/300?img=34','

Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.

',4,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(5,'Ana Torres','Docente de Inicial','Educacion Inicial','ana.torres@colegiohorizontes.edu.pe','https://i.pravatar.cc/300?img=51','

Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.

',5,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(6,'Diego Sanchez','Docente de Educacion Fisica','Deportes','diego.sanchez@colegiohorizontes.edu.pe','https://i.pravatar.cc/300?img=51','

Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.

',6,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'); /*!40000 ALTER TABLE `teachers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testimonials` -- DROP TABLE IF EXISTS `testimonials`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `testimonials` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `role` varchar(255) DEFAULT NULL, `content` text NOT NULL, `photo` varchar(255) DEFAULT NULL, `rating` int(11) DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `testimonials` -- LOCK TABLES `testimonials` WRITE; /*!40000 ALTER TABLE `testimonials` DISABLE KEYS */; INSERT INTO `testimonials` VALUES (1,'Rosa Martinez','Madre de familia','El colegio brindo a mis hijos una educacion de calidad y un ambiente seguro. Estamos muy agradecidos con los docentes.','https://i.pravatar.cc/150?img=42',5,1,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(2,'Pedro Castillo','Padre de familia','Elegimos el Colegio Horizontes por su enfoque en valores y su excelencia academica. Sin duda la mejor decision.','https://i.pravatar.cc/150?img=2',5,2,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(3,'Sofia Ramirez','Exalumna - Promocion 2020','Guardo los mejores recuerdos de mi etapa escolar. Gracias al colegio ingrese a la universidad con una base solida.','https://i.pravatar.cc/150?img=14',5,3,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'),(4,'Luis Torres','Padre de familia','La comunicacion entre el colegio y las familias es excelente. Siempre estan pendientes del progreso de cada estudiante.','https://i.pravatar.cc/150?img=52',4,4,1,'2026-08-14 21:28:54','2026-08-14 21:28:54'); /*!40000 ALTER TABLE `testimonials` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `logo` varchar(255) DEFAULT NULL, `plan` varchar(255) NOT NULL DEFAULT 'basico', `storage_limit_mb` bigint(20) unsigned NOT NULL DEFAULT 500, `subscription_started_at` date DEFAULT NULL, `subscription_ends_at` date DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `role` varchar(255) NOT NULL DEFAULT 'admin', `is_active` tinyint(1) NOT NULL DEFAULT 1, `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)), `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Administrador','admin@webpanel.com',NULL,'basico',500,NULL,NULL,'2026-08-14 21:28:54','$2y$12$3aO2nzURQv2Y6jvE9RBho.y6wAUCLxYqWv.WnHBIoElvtvHZ7dEfa','admin',1,NULL,NULL,'2026-08-14 21:28:54','2026-08-17 13:40:20'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `videos` -- DROP TABLE IF EXISTS `videos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videos` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `category` varchar(255) DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videos` -- LOCK TABLES `videos` WRITE; /*!40000 ALTER TABLE `videos` DISABLE KEYS */; INSERT INTO `videos` VALUES (1,'Video Institucional','https://www.youtube.com/watch?v=dQw4w9WgXcQ','Institucional',1,1,'2026-08-15 20:27:03','2026-08-15 20:27:03'),(2,'Tour por el Colegio','https://www.youtube.com/watch?v=9bZkp7q19f0','Instalaciones',2,1,'2026-08-15 20:27:03','2026-08-15 20:27:03'),(3,'Feria de Ciencias 2026','https://www.youtube.com/watch?v=kJQP7kiw5Fk','Eventos',3,1,'2026-08-15 20:27:03','2026-08-15 20:27:03'),(4,'Dia de la Familia','https://www.youtube.com/watch?v=OPf0YbXqDm0','Eventos',4,1,'2026-08-15 20:27:03','2026-08-15 20:27:03'),(5,'prueba','https://www.youtube.com/watch?v=euCqAq6BRa4&list=RDTfkP5ubz1z4&index=2','Instalaciones',0,1,'2026-08-15 20:36:17','2026-08-15 20:36:17'); /*!40000 ALTER TABLE `videos` 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 */; /*!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-08-17 23:59:25