--
-- Host: localhost    Database: webpanel
-- ------------------------------------------------------


--
-- Table structure for table `admissions`
--

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;

--
-- Dumping data for table `admissions`
--

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');

--
-- Table structure for table `contacts`
--

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;

--
-- Dumping data for table `contacts`
--

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');

--
-- Table structure for table `document_categories`
--

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;

--
-- Dumping data for table `document_categories`
--

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');

--
-- Table structure for table `documents`
--

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;

--
-- Dumping data for table `documents`
--

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');

--
-- Table structure for table `events`
--

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;

--
-- Dumping data for table `events`
--

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');

--
-- Table structure for table `failed_jobs`
--

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;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `gallery`
--

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;

--
-- Dumping data for table `gallery`
--

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');

--
-- Table structure for table `gallery_categories`
--

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;

--
-- Dumping data for table `gallery_categories`
--

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');

--
-- Table structure for table `hero_slides`
--

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;

--
-- Dumping data for table `hero_slides`
--

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');

--
-- Table structure for table `job_batches`
--

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;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

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;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `levels`
--

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;

--
-- Dumping data for table `levels`
--

INSERT INTO `levels` VALUES (1,'Inicial','inicial','bi-mortarboard','<div>Nivel inicial para ninos de 3 a 5 anos, con un enfoque ludico que estimula la curiosidad, la creatividad y la socializacion.<br><br></div><ul><li>Estimulacion temprana</li><li>Psicomotricidad</li><li>Arte y musica</li></ul>','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','<div>Primaria de 1ro a 6to grado, consolidando la lectoescritura, el razonamiento matematico y los valores en un ambiente seguro.<br><br></div><ul><li>Matematicas y ciencias</li><li>Talleres de lectura</li><li>Deportes y cultura</li></ul>','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','<div>Secundaria de 1ro a 5to, preparando a los estudiantes para la universidad y la vida con pensamiento critico y tecnologia.<br><br></div><ul><li>Preparacion preuniversitaria</li><li>Laboratorios</li><li>Proyectos de innovacion</li></ul>','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,'<div>ceba contenido</div>','levels/azE6rkO7GX5ZXwaGvIVFd306EslGAdsBKC674FHx.png',NULL,4,1,'2026-08-16 04:13:28','2026-08-16 04:19:23');

--
-- Table structure for table `migrations`
--

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;

--
-- Dumping data for table `migrations`
--

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);

--
-- Table structure for table `nav_items`
--

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;

--
-- Dumping data for table `nav_items`
--

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');

--
-- Table structure for table `news`
--

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;

--
-- Dumping data for table `news`
--

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.','<div>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.<br><br></div><div>El laboratorio cuenta con equipos modernos, insumos de calidad y estaciones de trabajo colaborativo que permitiran desarrollar proyectos de investigacion desde primaria hasta secundaria.<br><br></div>','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.','<p>La feria de ciencias de este ano supero todas las expectativas. Los estudiantes presentaron proyectos que van desde energia renovable hasta robotica educativa.</p><p>Felicitamos a todos los participantes y a las familias que acompanaron esta gran jornada.</p>','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.','<p>La seleccion de futbol del Colegio Horizontes se consagro campeona del torneo regional, demostrando disciplina, trabajo en equipo y espiritu deportivo.</p><p>Agradecemos a los entrenadores y a las familias por su apoyo incondicional.</p>','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.','<p>Comprometidos con la educacion, lanzamos nuestro programa de becas academicas 2026. Los estudiantes destacados podran acceder a descuentos en la pension mensual.</p><p>Las inscripciones estan abiertas en la oficina de admisiones.</p>','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');

--
-- Table structure for table `school_settings`
--

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;

--
-- Dumping data for table `school_settings`
--

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,'<div style=\"text-align:center; margin-bottom:6px;\"><div class=\"about-row\" data-cols=\"2\"><div class=\"about-col\"><p><img src=\"data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" alt=\"Cargando...\" style=\"max-width:200px;opacity:.5;\"><img src=\"storage/about/tjSkIk0l6Mdvm7D9Xau4SxODXWaG35QKq31MD0v0.png\" alt=\"imagen\"></p></div><div class=\"about-col\"><div style=\"text-align: left;\"><h2 class=\"font-heading text-3xl md:text-5xl font-extrabold text-foreground\" style=\"margin: 0px; font-weight: 800; line-height: 1; color: rgb(29, 40, 57); font-size: 3rem; --tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / .5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; --tw-contain-size: ; --tw-contain-layout: ; --tw-contain-paint: ; --tw-contain-style: ; border-width: 0px; border-style: solid; border-color: rgb(224, 229, 235); outline-color: rgba(1, 23, 75, 0.5); font-family: Poppins, sans-serif; background-color: rgba(240, 242, 245, 0.3);\">¿Por qué estudiar en <span class=\"text-primary\" style=\"color: rgb(1, 23, 75); --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / .5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; --tw-contain-size: ; --tw-contain-layout: ; --tw-contain-paint: ; --tw-contain-style: ; border-width: 0px; border-style: solid; border-color: rgb(224, 229, 235); outline-color: rgba(1, 23, 75, 0.5);\">TúColegio?</span></h2><div><span class=\"text-primary\" style=\"color: rgb(1, 23, 75); --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / .5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; --tw-contain-size: ; --tw-contain-layout: ; --tw-contain-paint: ; --tw-contain-style: ; border-width: 0px; border-style: solid; border-color: rgb(224, 229, 235); outline-color: rgba(1, 23, 75, 0.5);\"><br></span></div></div><div style=\"text-align: left;\"><span style=\"color: rgb(100, 116, 139); font-family: Arial, sans-serif; font-size: 18px;\">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.</span></div><div style=\"text-align: left;\"><span style=\"color: rgb(100, 116, 139); font-family: Arial, sans-serif; font-size: 18px;\"><br></span></div><div style=\"text-align: left;\"><div class=\"flex items-center gap-2 mb-5\" style=\"--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / 0.5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; --tw-contain-size: ; --tw-contain-layout: ; --tw-contain-paint: ; --tw-contain-style: ; border-width: 0px; border-style: solid; border-color: rgb(229, 231, 235); margin-bottom: 1.25rem; display: flex; align-items: center; font-family: ui-sans-serif, system-ui, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;; font-size: medium;\"><span class=\"text-red-400 font-bold tracking-[0.18em] text-xs uppercase\" style=\"--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / 0.5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; --tw-contain-size: ; --tw-contain-layout: ; --tw-contain-paint: ; --tw-contain-style: ; border-width: 0px; border-style: solid; border-color: rgb(229, 231, 235); font-size: 0.75rem; line-height: 1rem; font-weight: 700; text-transform: uppercase; letter-spacing: 0.18em; --tw-text-opacity: 1;\"><font color=\"#d70f0f\"><span style=\"font-size:24px;\"><span style=\"font-size:14px;\">Nuestro compromiso</span></span></font></span></div><h2 class=\"text-2xl md:text-4xl font-black tracking-tight leading-tight max-w-2xl\" style=\"--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / 0.5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; --tw-contain-size: ; --tw-contain-layout: ; --tw-contain-paint: ; --tw-contain-style: ; border-width: 0px; border-style: solid; border-color: rgb(229, 231, 235); font-size: 1.5rem; font-weight: 900; margin: 0px; max-width: 42rem; line-height: 1.25; letter-spacing: -0.025em; font-family: ui-sans-serif, system-ui, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;;\"><font color=\"#121111\">Aprender sin límites.</font> <span class=\"text-blue-300\" style=\"--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / 0.5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; --tw-contain-size: ; --tw-contain-layout: ; --tw-contain-paint: ; --tw-contain-style: ; border-width: 0px; border-style: solid; border-color: rgb(229, 231, 235); --tw-text-opacity: 1;\"><font color=\"#1b4cde\">Crecer con propósito</font></span><span class=\"text-blue-300\" style=\"color: rgb(147, 197, 253); --tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / 0.5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; --tw-contain-size: ; --tw-contain-layout: ; --tw-contain-paint: ; --tw-contain-style: ; border-width: 0px; border-style: solid; border-color: rgb(229, 231, 235); --tw-text-opacity: 1;\">.</span> <font color=\"#0d0c0c\">Liderar el mañana.</font></h2><div><img src=\"data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" alt=\"Cargando...\" style=\"max-width:200px;opacity:.5;\"><img src=\"data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" alt=\"Cargando...\" style=\"max-width: 200px; opacity: 0.5;\"><img src=\"data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" alt=\"Cargando...\" style=\"max-width: 200px; opacity: 0.5;\"><img src=\"data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" alt=\"Cargando...\" style=\"max-width: 200px; opacity: 0.5;\"><img src=\"storage/about/ARixo9weKib6D3at6nlZcvRTmBc8pVvJllZIs0aU.png\" alt=\"imagen\"><font color=\"#0d0c0c\"></font></div></div></div></div></div>','<div style=\"display:flex;align-items:stretch;\"><a href=\"#\" class=\"acc-card-btn acc-card-mesa\"><span class=\"acc-ico\"><i class=\"bi bi-inbox-fill\"></i></span><span class=\"acc-txt\"><span class=\"acc-titulo\">Mesa de Partes</span><span class=\"acc-sub\">Tramites y documentos</span></span></a></div>','#fafafa','<div style=\"display:flex;align-items:stretch;\"><a href=\"documentos\" class=\"acc-card-btn acc-card-doc\" style=\"background: linear-gradient(135deg, rgb(36, 99, 235) 0%, rgb(30, 81, 193) 100%); box-shadow: rgba(36, 99, 235, 0.4) 0px 12px 28px;\"><span class=\"acc-ico\"><i class=\"bi bi-folder2-open\"></i></span><span class=\"acc-txt\"><span class=\"acc-titulo\">Publicaciones</span><span class=\"acc-sub\">Documentos y recursos</span></span></a></div>','#fafafa','<div style=\"display:flex;align-items:stretch;\"><a href=\"#\" class=\"acc-card-btn acc-card-plataforma\"><span class=\"acc-ico\"><i class=\"bi bi-mortarboard-fill\"></i></span><span class=\"acc-txt\"><span class=\"acc-titulo\"><span style=\"font-size: 16px;\">SIGEDU</span></span><span class=\"acc-sub\">Plataforma Educativa</span></span></a></div>',NULL,'<div style=\"display:flex;align-items:stretch;\"><a href=\"#\" class=\"acc-card-btn acc-card-admision\"><span class=\"acc-ico\"><i class=\"bi bi-calendar2-check-fill\"></i></span><span class=\"acc-txt\"><span class=\"acc-titulo\">Admision 2027</span><span class=\"acc-sub\">Inscripciones abiertas</span></span></a></div>',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');

--
-- Table structure for table `sessions`
--

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;

--
-- Dumping data for table `sessions`
--

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);

--
-- Table structure for table `sites`
--

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;

--
-- Dumping data for table `sites`
--


--
-- Table structure for table `teachers`
--

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;

--
-- Dumping data for table `teachers`
--

INSERT INTO `teachers` VALUES (1,'Maria Fernandez','Directora General','Gestion Educativa','maria.fernandez@colegiohorizontes.edu.pe','https://i.pravatar.cc/300?img=69','<p>Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.</p>',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','<p>Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.</p>',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','<p>Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.</p>',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','<p>Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.</p>',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','<p>Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.</p>',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','<p>Profesional comprometido con la formacion integral de los estudiantes y con amplia experiencia en su area.</p>',6,1,'2026-08-14 21:28:54','2026-08-14 21:28:54');

--
-- Table structure for table `testimonials`
--

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;

--
-- Dumping data for table `testimonials`
--

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');

--
-- Table structure for table `videos`
--

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;

--
-- Dumping data for table `videos`
--

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');


