mysqldump.exe : mysqldump: [Warning] Using a password on the command line interface can be insecure. En línea: 1 Carácter: 61 + ... ldump.exe"; & $dump --no-tablespaces -u root --password="" paginaweb_ ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (mysqldump: [War...an be insecure.:String) [], RemoteException + FullyQualifiedErrorId : NativeCommandError -- MySQL dump 10.13 Distrib 8.4.7, for Win64 (x86_64) -- -- Host: localhost Database: paginaweb_db -- ------------------------------------------------------ -- Server version 8.4.7 /*!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 */; /*!50503 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 `admins` -- DROP TABLE IF EXISTS `admins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `admins` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `activo` tinyint(1) NOT NULL DEFAULT '1', `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `admins_email_unique` (`email`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admins` -- LOCK TABLES `admins` WRITE; /*!40000 ALTER TABLE `admins` DISABLE KEYS */; INSERT INTO `admins` VALUES (1,'Administrador','admin@websoftsolutions.pe','$2y$12$iZC.RSofGPTNeT20BP88SOtc4dazA6uDWtZidzTi5UI9XDMa7qCVi',NULL,1,NULL,'2026-07-13 01:54:01','2026-07-13 01:54:01'); /*!40000 ALTER TABLE `admins` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cache` ( `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=MyISAM 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 */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cache_locks` ( `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=MyISAM 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 `concurso_participantes` -- DROP TABLE IF EXISTS `concurso_participantes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `concurso_participantes` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `concurso_id` bigint unsigned NOT NULL, `apellidos` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `nombres` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `nivel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `grado` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `seccion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `genero` enum('M','F') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tiempo` time DEFAULT NULL, `observacion` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `concurso_participantes_concurso_id_foreign` (`concurso_id`) ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `concurso_participantes` -- LOCK TABLES `concurso_participantes` WRITE; /*!40000 ALTER TABLE `concurso_participantes` DISABLE KEYS */; INSERT INTO `concurso_participantes` VALUES (1,1,'AGUIRRE LANDEO','Liseth Ashley','Secundaria','2┬░','\"B\"','F','11:42:00',NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(2,1,'HUAMANI GOMEZ','Deissy Rosmery','Secundaria','2┬░','\"B\"','M','11:41:00',NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(3,1,'SOTO CARRERA','Abigail','Secundaria','2┬░','\"A\"','F','12:00:00',NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(4,1,'OREJON MACHUCA','Enma Luz','Secundaria','2┬░','\"B\"','F','11:43:00',NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(5,1,'PALACIOS GONZALES','Jheferson','Secundaria','2┬░','\"B\"','F','11:47:00',NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(6,1,'TORRE TAYPE','Nahely Yandi','Secundaria','2┬░','\"B\"','M','11:49:00',NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(7,1,'ARMAS ECHAVARRIA','Deysi','Secundaria','2┬░','\"B\"','M',NULL,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(8,1,'LANDEO ALVAREZ','Karina','Secundaria','2┬░','\"B\"','M',NULL,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(9,1,'VELASQUE ROJAS','Jhon Angel','Secundaria','2┬░','\"B\"','M',NULL,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(10,1,'MU├æOZ ANCCASI','Rosmery','Secundaria','2┬░','\"B\"','M',NULL,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(11,1,'QUISPE LANDEO','Yurfa Luz','Secundaria','2┬░','\"B\"','M',NULL,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(12,1,'PINO MU├æOZ','Jhossimar Raul','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(13,1,'SOTO FLORES','Jack','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(14,1,'SOTO OMONTE','Melisa','Secundaria','2┬░','\"B\"','M',NULL,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(15,1,'ARECHE LANDEO','Yorny Neymar','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(16,1,'CAPCHA ECHEVARRIA','Maribel Severina','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(17,1,'CISNEROS OTERO','Xiomara','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(18,1,'CISNEROS OTERO','Yhamelinda','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(19,1,'GUTIERREZ ARMAS','Sebastian','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(20,1,'HUAMANI GOMEZ','Wilfredo','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(21,1,'HUAMANI LANDEO','Yarita Lizeth','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(22,1,'LANDEO FLORES','Jhon Cristian','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(23,1,'LANDEO MU├æOZ','Ruth','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(24,1,'QUISPE CISNEROS','Adriana','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(25,1,'QUISPE PEREZ','Javier','Secundaria','2┬░','\"A\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(26,1,'ARMAS ECHAVARRIA','Dina','Secundaria','2┬░','\"B\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(27,1,'LANDEO ANTEZANA','Moris Soomer','Secundaria','2┬░','\"B\"','M',NULL,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(28,1,'LANDEO BRUNO','Nayeli Jhasmin','Secundaria','2┬░','\"B\"','M',NULL,'estudiante no registro','2026-07-13 03:03:05','2026-07-13 03:03:05'); /*!40000 ALTER TABLE `concurso_participantes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `concurso_preguntas` -- DROP TABLE IF EXISTS `concurso_preguntas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `concurso_preguntas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `concurso_id` bigint unsigned NOT NULL, `numero` tinyint unsigned NOT NULL, `respuesta_correcta` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `puntos` decimal(8,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `concurso_preguntas_concurso_id_numero_unique` (`concurso_id`,`numero`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `concurso_preguntas` -- LOCK TABLES `concurso_preguntas` WRITE; /*!40000 ALTER TABLE `concurso_preguntas` DISABLE KEYS */; INSERT INTO `concurso_preguntas` VALUES (18,1,8,'B',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'),(17,1,7,'A',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'),(16,1,6,'HG',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'),(15,1,5,'HO',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'),(14,1,4,'15',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'),(13,1,3,'12',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'),(12,1,2,'12kg',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'),(11,1,1,'S',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'),(19,1,9,'D',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'),(20,1,10,'C',NULL,'2026-07-13 04:51:22','2026-07-13 04:51:22'); /*!40000 ALTER TABLE `concurso_preguntas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `concurso_respuestas` -- DROP TABLE IF EXISTS `concurso_respuestas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `concurso_respuestas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `participante_id` bigint unsigned NOT NULL, `pregunta_numero` tinyint unsigned NOT NULL, `respuesta_alumno` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `concurso_respuestas_participante_id_pregunta_numero_unique` (`participante_id`,`pregunta_numero`) ) ENGINE=MyISAM AUTO_INCREMENT=281 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `concurso_respuestas` -- LOCK TABLES `concurso_respuestas` WRITE; /*!40000 ALTER TABLE `concurso_respuestas` DISABLE KEYS */; INSERT INTO `concurso_respuestas` VALUES (1,1,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(2,1,2,'153','2026-07-13 03:03:04','2026-07-13 03:03:04'),(3,1,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(4,1,4,'225','2026-07-13 03:03:04','2026-07-13 03:03:04'),(5,1,5,'0','2026-07-13 03:03:04','2026-07-13 03:03:04'),(6,1,6,'585','2026-07-13 03:03:04','2026-07-13 03:03:04'),(7,1,7,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(8,1,8,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(9,1,9,'960','2026-07-13 03:03:04','2026-07-13 03:03:04'),(10,1,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(11,2,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(12,2,2,'153','2026-07-13 03:03:04','2026-07-13 03:03:04'),(13,2,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(14,2,4,'225','2026-07-13 03:03:04','2026-07-13 03:03:04'),(15,2,5,'0','2026-07-13 03:03:04','2026-07-13 03:03:04'),(16,2,6,'585','2026-07-13 03:03:04','2026-07-13 03:03:04'),(17,2,7,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(18,2,8,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(19,2,9,'960','2026-07-13 03:03:04','2026-07-13 03:03:04'),(20,2,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(21,3,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(22,3,2,'153','2026-07-13 03:03:04','2026-07-13 03:03:04'),(23,3,3,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(24,3,4,'225','2026-07-13 03:03:04','2026-07-13 03:03:04'),(25,3,5,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(26,3,6,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(27,3,7,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(28,3,8,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(29,3,9,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(30,3,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(31,4,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(32,4,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(33,4,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(34,4,4,'225','2026-07-13 03:03:04','2026-07-13 03:03:04'),(35,4,5,'0','2026-07-13 03:03:04','2026-07-13 03:03:04'),(36,4,6,'585','2026-07-13 03:03:04','2026-07-13 03:03:04'),(37,4,7,'2','2026-07-13 03:03:04','2026-07-13 03:03:04'),(38,4,8,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(39,4,9,'960','2026-07-13 03:03:04','2026-07-13 03:03:04'),(40,4,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(41,5,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(42,5,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(43,5,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(44,5,4,'225','2026-07-13 03:03:04','2026-07-13 03:03:04'),(45,5,5,'0.9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(46,5,6,'585','2026-07-13 03:03:04','2026-07-13 03:03:04'),(47,5,7,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(48,5,8,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(49,5,9,'960','2026-07-13 03:03:04','2026-07-13 03:03:04'),(50,5,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(51,6,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(52,6,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(53,6,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(54,6,4,'225','2026-07-13 03:03:04','2026-07-13 03:03:04'),(55,6,5,'0.09','2026-07-13 03:03:04','2026-07-13 03:03:04'),(56,6,6,'585','2026-07-13 03:03:04','2026-07-13 03:03:04'),(57,6,7,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(58,6,8,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(59,6,9,'960','2026-07-13 03:03:04','2026-07-13 03:03:04'),(60,6,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(61,7,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(62,7,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(63,7,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(64,7,4,'225','2026-07-13 03:03:04','2026-07-13 03:03:04'),(65,7,5,'0','2026-07-13 03:03:04','2026-07-13 03:03:04'),(66,7,6,'2','2026-07-13 03:03:04','2026-07-13 03:03:04'),(67,7,7,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(68,7,8,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(69,7,9,'960','2026-07-13 03:03:04','2026-07-13 03:03:04'),(70,7,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(71,8,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(72,8,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(73,8,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(74,8,4,'0','2026-07-13 03:03:04','2026-07-13 03:03:04'),(75,8,5,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(76,8,6,'585','2026-07-13 03:03:04','2026-07-13 03:03:04'),(77,8,7,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(78,8,8,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(79,8,9,'60','2026-07-13 03:03:04','2026-07-13 03:03:04'),(80,8,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(81,9,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(82,9,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(83,9,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(84,9,4,'0','2026-07-13 03:03:04','2026-07-13 03:03:04'),(85,9,5,'0.09','2026-07-13 03:03:04','2026-07-13 03:03:04'),(86,9,6,'585','2026-07-13 03:03:04','2026-07-13 03:03:04'),(87,9,7,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(88,9,8,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(89,9,9,'960','2026-07-13 03:03:04','2026-07-13 03:03:04'),(90,9,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(91,10,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(92,10,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(93,10,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(94,10,4,'0','2026-07-13 03:03:04','2026-07-13 03:03:04'),(95,10,5,'0.09','2026-07-13 03:03:04','2026-07-13 03:03:04'),(96,10,6,'500','2026-07-13 03:03:04','2026-07-13 03:03:04'),(97,10,7,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(98,10,8,'4','2026-07-13 03:03:04','2026-07-13 03:03:04'),(99,10,9,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(100,10,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(101,11,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(102,11,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(103,11,3,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(104,11,4,'0','2026-07-13 03:03:04','2026-07-13 03:03:04'),(105,11,5,'0.9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(106,11,6,'500','2026-07-13 03:03:04','2026-07-13 03:03:04'),(107,11,7,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(108,11,8,'8','2026-07-13 03:03:04','2026-07-13 03:03:04'),(109,11,9,'92','2026-07-13 03:03:04','2026-07-13 03:03:04'),(110,11,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(111,12,1,'3','2026-07-13 03:03:04','2026-07-13 03:03:04'),(112,12,2,'7','2026-07-13 03:03:04','2026-07-13 03:03:04'),(113,12,3,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(114,12,4,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(115,12,5,'26','2026-07-13 03:03:04','2026-07-13 03:03:04'),(116,12,6,'26','2026-07-13 03:03:04','2026-07-13 03:03:04'),(117,12,7,'7','2026-07-13 03:03:04','2026-07-13 03:03:04'),(118,12,8,'197','2026-07-13 03:03:04','2026-07-13 03:03:04'),(119,12,9,'13','2026-07-13 03:03:04','2026-07-13 03:03:04'),(120,12,10,'23','2026-07-13 03:03:04','2026-07-13 03:03:04'),(121,13,1,'2','2026-07-13 03:03:04','2026-07-13 03:03:04'),(122,13,2,'60','2026-07-13 03:03:04','2026-07-13 03:03:04'),(123,13,3,'2','2026-07-13 03:03:04','2026-07-13 03:03:04'),(124,13,4,'8','2026-07-13 03:03:04','2026-07-13 03:03:04'),(125,13,5,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(126,13,6,'8','2026-07-13 03:03:04','2026-07-13 03:03:04'),(127,13,7,'6','2026-07-13 03:03:04','2026-07-13 03:03:04'),(128,13,8,'197','2026-07-13 03:03:04','2026-07-13 03:03:04'),(129,13,9,'28','2026-07-13 03:03:04','2026-07-13 03:03:04'),(130,13,10,'15','2026-07-13 03:03:04','2026-07-13 03:03:04'),(131,14,1,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(132,14,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(133,14,3,'23','2026-07-13 03:03:04','2026-07-13 03:03:04'),(134,14,4,'0','2026-07-13 03:03:04','2026-07-13 03:03:04'),(135,14,5,'19','2026-07-13 03:03:04','2026-07-13 03:03:04'),(136,14,6,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(137,14,7,'5','2026-07-13 03:03:04','2026-07-13 03:03:04'),(138,14,8,'9','2026-07-13 03:03:04','2026-07-13 03:03:04'),(139,14,9,NULL,'2026-07-13 03:03:04','2026-07-13 03:03:04'),(140,14,10,'35','2026-07-13 03:03:04','2026-07-13 03:03:04'),(141,15,1,'10','2026-07-13 03:03:04','2026-07-13 03:03:04'),(142,15,2,'152','2026-07-13 03:03:04','2026-07-13 03:03:04'),(143,15,3,'12','2026-07-13 03:03:04','2026-07-13 03:03:04'),(144,15,4,'10','2026-07-13 03:03:04','2026-07-13 03:03:04'),(145,15,5,'39','2026-07-13 03:03:04','2026-07-13 03:03:04'),(146,15,6,'2','2026-07-13 03:03:04','2026-07-13 03:03:04'),(147,15,7,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(148,15,8,'200','2026-07-13 03:03:05','2026-07-13 03:03:05'),(149,15,9,'20','2026-07-13 03:03:05','2026-07-13 03:03:05'),(150,15,10,'12','2026-07-13 03:03:05','2026-07-13 03:03:05'),(151,16,1,'1','2026-07-13 03:03:05','2026-07-13 03:03:05'),(152,16,2,'55','2026-07-13 03:03:05','2026-07-13 03:03:05'),(153,16,3,'12','2026-07-13 03:03:05','2026-07-13 03:03:05'),(154,16,4,'9','2026-07-13 03:03:05','2026-07-13 03:03:05'),(155,16,5,'11','2026-07-13 03:03:05','2026-07-13 03:03:05'),(156,16,6,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(157,16,7,'17','2026-07-13 03:03:05','2026-07-13 03:03:05'),(158,16,8,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(159,16,9,'14','2026-07-13 03:03:05','2026-07-13 03:03:05'),(160,16,10,'54','2026-07-13 03:03:05','2026-07-13 03:03:05'),(161,17,1,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(162,17,2,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(163,17,3,'24','2026-07-13 03:03:05','2026-07-13 03:03:05'),(164,17,4,'10','2026-07-13 03:03:05','2026-07-13 03:03:05'),(165,17,5,'39','2026-07-13 03:03:05','2026-07-13 03:03:05'),(166,17,6,'14','2026-07-13 03:03:05','2026-07-13 03:03:05'),(167,17,7,'13','2026-07-13 03:03:05','2026-07-13 03:03:05'),(168,17,8,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(169,17,9,'14','2026-07-13 03:03:05','2026-07-13 03:03:05'),(170,17,10,'54','2026-07-13 03:03:05','2026-07-13 03:03:05'),(171,18,1,'150','2026-07-13 03:03:05','2026-07-13 03:03:05'),(172,18,2,'150','2026-07-13 03:03:05','2026-07-13 03:03:05'),(173,18,3,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(174,18,4,'10','2026-07-13 03:03:05','2026-07-13 03:03:05'),(175,18,5,'2','2026-07-13 03:03:05','2026-07-13 03:03:05'),(176,18,6,'14','2026-07-13 03:03:05','2026-07-13 03:03:05'),(177,18,7,'21','2026-07-13 03:03:05','2026-07-13 03:03:05'),(178,18,8,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(179,18,9,'16','2026-07-13 03:03:05','2026-07-13 03:03:05'),(180,18,10,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(181,19,1,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(182,19,2,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(183,19,3,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(184,19,4,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(185,19,5,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(186,19,6,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(187,19,7,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(188,19,8,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(189,19,9,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(190,19,10,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(191,20,1,'50','2026-07-13 03:03:05','2026-07-13 03:03:05'),(192,20,2,'148','2026-07-13 03:03:05','2026-07-13 03:03:05'),(193,20,3,'39','2026-07-13 03:03:05','2026-07-13 03:03:05'),(194,20,4,'23','2026-07-13 03:03:05','2026-07-13 03:03:05'),(195,20,5,'2','2026-07-13 03:03:05','2026-07-13 03:03:05'),(196,20,6,'90','2026-07-13 03:03:05','2026-07-13 03:03:05'),(197,20,7,'40','2026-07-13 03:03:05','2026-07-13 03:03:05'),(198,20,8,'199','2026-07-13 03:03:05','2026-07-13 03:03:05'),(199,20,9,'12','2026-07-13 03:03:05','2026-07-13 03:03:05'),(200,20,10,'140','2026-07-13 03:03:05','2026-07-13 03:03:05'),(201,21,1,'4','2026-07-13 03:03:05','2026-07-13 03:03:05'),(202,21,2,'55','2026-07-13 03:03:05','2026-07-13 03:03:05'),(203,21,3,'39','2026-07-13 03:03:05','2026-07-13 03:03:05'),(204,21,4,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(205,21,5,'21','2026-07-13 03:03:05','2026-07-13 03:03:05'),(206,21,6,'24','2026-07-13 03:03:05','2026-07-13 03:03:05'),(207,21,7,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(208,21,8,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(209,21,9,'12','2026-07-13 03:03:05','2026-07-13 03:03:05'),(210,21,10,'160','2026-07-13 03:03:05','2026-07-13 03:03:05'),(211,22,1,'4','2026-07-13 03:03:05','2026-07-13 03:03:05'),(212,22,2,'35','2026-07-13 03:03:05','2026-07-13 03:03:05'),(213,22,3,'16','2026-07-13 03:03:05','2026-07-13 03:03:05'),(214,22,4,'12','2026-07-13 03:03:05','2026-07-13 03:03:05'),(215,22,5,'25','2026-07-13 03:03:05','2026-07-13 03:03:05'),(216,22,6,'14','2026-07-13 03:03:05','2026-07-13 03:03:05'),(217,22,7,'13','2026-07-13 03:03:05','2026-07-13 03:03:05'),(218,22,8,'200','2026-07-13 03:03:05','2026-07-13 03:03:05'),(219,22,9,'24','2026-07-13 03:03:05','2026-07-13 03:03:05'),(220,22,10,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(221,23,1,'10','2026-07-13 03:03:05','2026-07-13 03:03:05'),(222,23,2,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(223,23,3,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(224,23,4,'21','2026-07-13 03:03:05','2026-07-13 03:03:05'),(225,23,5,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(226,23,6,'9','2026-07-13 03:03:05','2026-07-13 03:03:05'),(227,23,7,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(228,23,8,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(229,23,9,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(230,23,10,'14','2026-07-13 03:03:05','2026-07-13 03:03:05'),(231,24,1,'4','2026-07-13 03:03:05','2026-07-13 03:03:05'),(232,24,2,'158','2026-07-13 03:03:05','2026-07-13 03:03:05'),(233,24,3,'81','2026-07-13 03:03:05','2026-07-13 03:03:05'),(234,24,4,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(235,24,5,'10','2026-07-13 03:03:05','2026-07-13 03:03:05'),(236,24,6,'80','2026-07-13 03:03:05','2026-07-13 03:03:05'),(237,24,7,'2','2026-07-13 03:03:05','2026-07-13 03:03:05'),(238,24,8,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(239,24,9,'14','2026-07-13 03:03:05','2026-07-13 03:03:05'),(240,24,10,'14','2026-07-13 03:03:05','2026-07-13 03:03:05'),(241,25,1,'7404251','2026-07-13 03:03:05','2026-07-13 03:03:05'),(242,25,2,'155','2026-07-13 03:03:05','2026-07-13 03:03:05'),(243,25,3,'12','2026-07-13 03:03:05','2026-07-13 03:03:05'),(244,25,4,'ABCD','2026-07-13 03:03:05','2026-07-13 03:03:05'),(245,25,5,'183','2026-07-13 03:03:05','2026-07-13 03:03:05'),(246,25,6,'9','2026-07-13 03:03:05','2026-07-13 03:03:05'),(247,25,7,'13','2026-07-13 03:03:05','2026-07-13 03:03:05'),(248,25,8,'113','2026-07-13 03:03:05','2026-07-13 03:03:05'),(249,25,9,'4','2026-07-13 03:03:05','2026-07-13 03:03:05'),(250,25,10,'6','2026-07-13 03:03:05','2026-07-13 03:03:05'),(251,26,1,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(252,26,2,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(253,26,3,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(254,26,4,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(255,26,5,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(256,26,6,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(257,26,7,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(258,26,8,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(259,26,9,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(260,26,10,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(261,27,1,'2','2026-07-13 03:03:05','2026-07-13 03:03:05'),(262,27,2,'9','2026-07-13 03:03:05','2026-07-13 03:03:05'),(263,27,3,'15','2026-07-13 03:03:05','2026-07-13 03:03:05'),(264,27,4,'7','2026-07-13 03:03:05','2026-07-13 03:03:05'),(265,27,5,'6','2026-07-13 03:03:05','2026-07-13 03:03:05'),(266,27,6,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(267,27,7,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(268,27,8,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(269,27,9,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(270,27,10,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(271,28,1,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(272,28,2,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(273,28,3,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(274,28,4,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(275,28,5,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(276,28,6,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(277,28,7,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(278,28,8,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(279,28,9,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'),(280,28,10,NULL,'2026-07-13 03:03:05','2026-07-13 03:03:05'); /*!40000 ALTER TABLE `concurso_respuestas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `concursos` -- DROP TABLE IF EXISTS `concursos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `concursos` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `sigla` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `patrocinador` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `anio` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `etapa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nivel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `categoria` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nivel_educativo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `grado` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `num_preguntas` tinyint unsigned NOT NULL DEFAULT '10', `puntos_por_pregunta` decimal(8,2) NOT NULL DEFAULT '10.00', `puntos_variable` tinyint(1) NOT NULL DEFAULT '0', `modo_clasificacion` enum('general','genero','ambos') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general', `num_clasificados_general` tinyint unsigned NOT NULL DEFAULT '3', `num_clasificados_mujer` tinyint unsigned NOT NULL DEFAULT '2', `num_clasificados_varon` tinyint unsigned NOT NULL DEFAULT '2', `fecha_concurso` date DEFAULT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci, `imagen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `estado` enum('borrador','publicado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'borrador', `noticia_id` bigint unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `concursos_slug_unique` (`slug`), KEY `concursos_noticia_id_foreign` (`noticia_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `concursos` -- LOCK TABLES `concursos` WRITE; /*!40000 ALTER TABLE `concursos` DISABLE KEYS */; INSERT INTO `concursos` VALUES (1,'ONEM - 206','ONEM PERU','onem-206-2026','Studios Per├║','2026','1 ETAPA','NIVEL I','ALFA','Secundaria','2',10,10.00,0,'general',3,2,2,'2026-07-12','Esxamen de estudiantes de 2┬░ A',NULL,'publicado',7,'2026-07-13 02:17:40','2026-07-13 03:03:41'); /*!40000 ALTER TABLE `concursos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `configuraciones` -- DROP TABLE IF EXISTS `configuraciones`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `configuraciones` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `clave` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `valor` text COLLATE utf8mb4_unicode_ci, `tipo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text', `descripcion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `configuraciones_clave_unique` (`clave`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `configuraciones` -- LOCK TABLES `configuraciones` WRITE; /*!40000 ALTER TABLE `configuraciones` DISABLE KEYS */; INSERT INTO `configuraciones` VALUES (1,'empresa_nombre','WebSoft Solutions','text','Nombre de la empresa','2026-07-13 01:54:01','2026-07-13 01:54:01'),(2,'empresa_ruc','20612345678','text','RUC de la empresa','2026-07-13 01:54:01','2026-07-13 01:54:01'),(3,'empresa_telefono','+51 984 123 456','text','Tel├®fono principal','2026-07-13 01:54:01','2026-07-13 01:54:01'),(4,'empresa_email','info@websoftsolutions.pe','text','Email de contacto','2026-07-13 01:54:01','2026-07-13 01:54:01'),(5,'empresa_direccion','Jr. Tecnolog├¡a 123, Lima - Per├║','text','Direcci├│n','2026-07-13 01:54:01','2026-07-13 01:54:01'),(6,'empresa_horario','Lun - Vie: 8:00 AM - 6:00 PM','text','Horario de atenci├│n','2026-07-13 01:54:01','2026-07-13 01:54:01'),(7,'social_facebook','https://facebook.com/websoftsolutions','text','Facebook','2026-07-13 01:54:01','2026-07-13 01:54:01'),(8,'social_instagram','https://instagram.com/websoftsolutions','text','Instagram','2026-07-13 01:54:01','2026-07-13 01:54:01'),(9,'social_youtube','https://youtube.com/websoftsolutions','text','YouTube','2026-07-13 01:54:01','2026-07-13 01:54:01'),(10,'social_whatsapp','51984123456','text','WhatsApp (solo n├║meros)','2026-07-13 01:54:01','2026-07-13 01:54:01'),(11,'hero_titulo','Soluciones Digitales para tu Instituci├│n','text','T├¡tulo del hero','2026-07-13 01:54:01','2026-07-13 01:54:01'),(12,'hero_subtitulo','Sistemas web acad├®micos, de asistencia y gesti├│n institucional','text','Subt├¡tulo del hero','2026-07-13 01:54:01','2026-07-13 01:54:01'),(13,'footer_descripcion','Empresa peruana especializada en desarrollo y alquiler de sistemas web para instituciones educativas y empresas.','textarea','Descripci├│n en el footer','2026-07-13 01:54:01','2026-07-13 01:54:01'),(14,'meta_descripcion','WebSoft Solutions - Sistemas web acad├®micos, de asistencia y gesti├│n para instituciones educativas en Per├║.','textarea','Meta descripci├│n SEO','2026-07-13 01:54:01','2026-07-13 01:54:01'); /*!40000 ALTER TABLE `configuraciones` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `estadisticas` -- DROP TABLE IF EXISTS `estadisticas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `estadisticas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `etiqueta` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `valor` int NOT NULL, `sufijo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `icono` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `orden` int NOT NULL DEFAULT '0', `activo` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `estadisticas` -- LOCK TABLES `estadisticas` WRITE; /*!40000 ALTER TABLE `estadisticas` DISABLE KEYS */; INSERT INTO `estadisticas` VALUES (1,'Clientes Activos',500,'+','bi-people-fill','#3b82f6',1,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(2,'Instituciones Atendidas',250,'+','bi-building-fill','#10b981',2,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(3,'A├▒os de Experiencia',8,'+','bi-award-fill','#f59e0b',3,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(4,'Satisfacci├│n del Cliente',98,'%','bi-star-fill','#8b5cf6',4,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'); /*!40000 ALTER TABLE `estadisticas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=MyISAM 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 `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_batches` ( `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `total_jobs` int NOT NULL, `pending_jobs` int NOT NULL, `failed_jobs` int NOT NULL, `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext COLLATE utf8mb4_unicode_ci, `cancelled_at` int DEFAULT NULL, `created_at` int NOT NULL, `finished_at` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM 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 */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` smallint unsigned NOT NULL, `reserved_at` int unsigned DEFAULT NULL, `available_at` int unsigned NOT NULL, `created_at` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=MyISAM 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 `menu_items` -- DROP TABLE IF EXISTS `menu_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `menu_items` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL, `icono` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `orden` int NOT NULL DEFAULT '0', `activo` tinyint(1) NOT NULL DEFAULT '1', `target` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_items` -- LOCK TABLES `menu_items` WRITE; /*!40000 ALTER TABLE `menu_items` DISABLE KEYS */; INSERT INTO `menu_items` VALUES (1,'nosotros','/p/nosotros',NULL,5,1,'_self','2026-07-13 05:09:24','2026-07-13 05:28:11'),(2,'Inicio','/','bi bi-house-fill',1,1,'_self','2026-07-13 05:24:13','2026-07-13 05:24:13'),(3,'Servicios','/servicios','bi bi-grid-fill',2,1,'_self','2026-07-13 05:24:13','2026-07-13 05:24:13'),(4,'Noticias','/noticias','bi bi-newspaper',3,1,'_self','2026-07-13 05:24:13','2026-07-13 05:24:13'),(5,'Premios','/premios','bi bi-trophy-fill',4,1,'_self','2026-07-13 05:24:13','2026-07-13 05:24:13'),(6,'Comunidad','/comunidad','bi bi-people-fill',5,1,'_self','2026-07-13 05:24:13','2026-07-13 05:24:13'),(7,'Contacto','/contacto','bi bi-envelope-fill',6,1,'_self','2026-07-13 05:24:13','2026-07-13 05:24:13'); /*!40000 ALTER TABLE `menu_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=20 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_05_171019_create_configuraciones_table',1),(5,'2026_07_05_171020_create_servicios_table',1),(6,'2026_07_05_171020_create_sliders_table',1),(7,'2026_07_05_171021_create_noticias_table',1),(8,'2026_07_05_171021_create_premios_table',1),(9,'2026_07_05_171022_create_testimonios_table',1),(10,'2026_07_05_171023_create_estadisticas_table',1),(11,'2026_07_05_171023_create_ticker_items_table',1),(12,'2026_07_05_171024_create_admins_table',1),(13,'2026_07_05_200000_create_menu_items_table',1),(14,'2026_07_05_200001_create_paginas_table',1),(15,'2026_07_11_180000_create_concursos_table',1),(16,'2026_07_11_180001_create_concurso_preguntas_table',1),(17,'2026_07_11_180002_create_concurso_participantes_table',1),(18,'2026_07_11_180003_create_concurso_respuestas_table',1),(19,'2026_07_11_180004_add_concurso_id_to_noticias_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `noticias` -- DROP TABLE IF EXISTS `noticias`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `noticias` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `titulo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `resumen` text COLLATE utf8mb4_unicode_ci, `contenido` longtext COLLATE utf8mb4_unicode_ci, `imagen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tipo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'noticia', `categoria` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `fecha_publicacion` date NOT NULL, `destacado` tinyint(1) NOT NULL DEFAULT '0', `activo` tinyint(1) NOT NULL DEFAULT '1', `concurso_id` bigint unsigned DEFAULT NULL, `botones` json DEFAULT NULL, `mostrar_popup` tinyint(1) NOT NULL DEFAULT '0', `popup_orden` tinyint unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `noticias_slug_unique` (`slug`), KEY `noticias_concurso_id_foreign` (`concurso_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `noticias` -- LOCK TABLES `noticias` WRITE; /*!40000 ALTER TABLE `noticias` DISABLE KEYS */; INSERT INTO `noticias` VALUES (1,'WebSoft Solutions lanza nueva versi├│n del Sistema Acad├®mico','websoft-lanza-nueva-version-sistema-academico','La nueva versi├│n incluye m├│dulo de videoconferencias integrado y aplicaci├│n m├│vil para padres de familia.','

WebSoft Solutions ha lanzado la versión 3.0 de su Sistema Académico Integral, incorporando nuevas funcionalidades...

',NULL,'noticia',NULL,'2026-07-01',1,1,NULL,NULL,0,0,'2026-07-13 01:54:01','2026-07-13 05:02:32'),(2,'Comunicado: Actualizaci├│n de precios para el a├▒o 2026','comunicado-actualizacion-precios-2026','Informamos a nuestros clientes sobre los nuevos planes y precios vigentes desde agosto 2026.','

Estimados clientes, comunicamos que a partir del 1 de agosto de 2026...

',NULL,'comunicado',NULL,'2026-06-25',0,1,NULL,NULL,0,0,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(3,'Convocatoria: Buscamos desarrolladores PHP','convocatoria-desarrolladores-php','WebSoft Solutions busca desarrolladores PHP/Laravel para unirse a nuestro equipo de desarrollo.','

Convocamos a profesionales en desarrollo web con experiencia en PHP y Laravel...

',NULL,'convocatoria',NULL,'2026-06-20',0,1,NULL,NULL,0,0,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(4,'Logro: Superamos los 500 clientes activos','logro-500-clientes-activos','Con orgullo anunciamos que hemos superado los 500 clientes activos en todo el Per├║.','

Gracias al apoyo de nuestros clientes, hemos alcanzado un hito hist├│rico...

',NULL,'logro',NULL,'2026-06-15',1,1,NULL,NULL,0,0,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(5,'Integraci├│n con plataformas de videoconferencia','integracion-videoconferencia','Nuestros sistemas ahora se integran con Zoom, Google Meet y Microsoft Teams.','

Anunciamos la integraci├│n nativa con las principales plataformas de videoconferencia...

',NULL,'noticia',NULL,'2026-06-10',0,1,NULL,NULL,0,0,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(6,'Reconocimiento como mejor startup tecnol├│gica de la regi├│n','reconocimiento-mejor-startup-tecnologica','WebSoft Solutions fue reconocida como la mejor startup tecnol├│gica del a├▒o en la regi├│n.','

La Cámara de Comercio de Lima otorgó el reconocimiento...

',NULL,'logro',NULL,'2026-05-30',0,1,NULL,NULL,0,0,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(7,'Resultados ONEM - 206','resultados-onem-206','Se publicaron los resultados oficiales de ONEM - 206 2026. 28 participantes, 3 clasificados.','

Se publicaron los resultados oficiales de ONEM - 206 2026. 28 participantes, 3 clasificados.

\r\n

Ver resultados completos →

',NULL,'logro','Olimpiadas','2026-07-12',1,1,1,'[{\"url\": \"http://localhost/paginaweb/public/resultado/onem-206-2026\", \"color\": \"#1a237e\", \"texto\": \"­ƒôè Ver Resultados\"}]',1,0,'2026-07-13 03:03:41','2026-07-13 05:01:01'); /*!40000 ALTER TABLE `noticias` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paginas` -- DROP TABLE IF EXISTS `paginas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `paginas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `titulo` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `contenido` longtext COLLATE utf8mb4_unicode_ci, `meta_descripcion` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `activo` tinyint(1) NOT NULL DEFAULT '1', `orden` int NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `paginas_slug_unique` (`slug`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `paginas` -- LOCK TABLES `paginas` WRITE; /*!40000 ALTER TABLE `paginas` DISABLE KEYS */; INSERT INTO `paginas` VALUES (1,'Nosotros','nosotros','

Qui├®nes somos

Somos una instituci├│n comprometida con la educaci├│n de calidad.

','Conoce nuestra instituci├│n, misi├│n, visi├│n y valores.',1,1,'2026-07-13 05:08:47','2026-07-13 05:24:13'),(2,'Contacto','contacto','

Contáctanos

Estamos disponibles para atenderte.

','Informaci├│n de contacto y ubicaci├│n de nuestra instituci├│n.',1,2,'2026-07-13 05:24:13','2026-07-13 05:24:13'); /*!40000 ALTER TABLE `paginas` 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 */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=MyISAM 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 `premios` -- DROP TABLE IF EXISTS `premios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `premios` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci, `imagen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `otorgado_por` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `anio` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `orden` int NOT NULL DEFAULT '0', `activo` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `premios` -- LOCK TABLES `premios` WRITE; /*!40000 ALTER TABLE `premios` DISABLE KEYS */; INSERT INTO `premios` VALUES (1,'Mejor Startup Tecnol├│gica 2025',NULL,NULL,'C├ímara de Comercio de Lima','2025',1,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(2,'Premio Innovaci├│n Digital',NULL,NULL,'Ministerio de Educaci├│n','2024',2,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(3,'Certificaci├│n ISO 9001:2015',NULL,NULL,'INACAL','2024',3,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(4,'Top 10 Empresas EdTech',NULL,NULL,'Forbes Per├║','2023',4,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'); /*!40000 ALTER TABLE `premios` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `servicios` -- DROP TABLE IF EXISTS `servicios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `servicios` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci, `caracteristicas` text COLLATE utf8mb4_unicode_ci, `icono` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `imagen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `precio_desde` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tipo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'venta', `badge` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `badge_color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `url_demo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `orden` int NOT NULL DEFAULT '0', `destacado` tinyint(1) NOT NULL DEFAULT '0', `activo` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `servicios` -- LOCK TABLES `servicios` WRITE; /*!40000 ALTER TABLE `servicios` DISABLE KEYS */; INSERT INTO `servicios` VALUES (1,'Sistema Acad├®mico (SIGAE)','Sistema integral de gesti├│n acad├®mica para colegios, institutos y universidades. Administra matr├¡culas, notas, horarios, documentos y comunicaci├│n con padres.','Gesti├│n de matr├¡culas y alumnos\nRegistro y emisi├│n de notas\nHorarios y asistencia de docentes\nComunicados a padres de familia\nReportes y estad├¡sticas\nAcceso web y m├│vil','bi-mortarboard-fill',NULL,'S/ 150','ambos','M├ís Popular','#10b981','#',1,1,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(2,'Sistema de Asistencia (AsisEdu)','Control de asistencia avanzado con m├║ltiples m├®todos de marcaci├│n: huella dactilar, QR, c├│digo de barras y reconocimiento facial.','Marcado por huella dactilar\nEscaneo de c├│digo QR\nLectura de c├│digo de barras\nReconocimiento facial\nReportes de tardanzas y faltas\nAlertas autom├íticas a padres','bi-fingerprint',NULL,'S/ 80','ambos','Tecnolog├¡a IA','#8b5cf6','#',2,1,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(3,'Sistema de Biblioteca','Gesti├│n completa de biblioteca escolar o universitaria. Cat├ílogo digital, pr├®stamos, devoluciones y control de inventario de libros.','Cat├ílogo digital de libros\nControl de pr├®stamos y devoluciones\nEscaneo de c├│digo de barras\nMultas autom├íticas\nReportes de uso\nB├║squeda avanzada','bi-book-fill',NULL,'S/ 60','ambos',NULL,NULL,'#',3,0,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(4,'Sistema de Facturaci├│n Electr├│nica','Emisi├│n de comprobantes electr├│nicos vinculado a SUNAT. Facturas, boletas, notas de cr├®dito y d├®bito con env├¡o autom├ítico.','Emisi├│n de facturas y boletas\nConexi├│n directa con SUNAT\nNotas de cr├®dito y d├®bito\nEnv├¡o autom├ítico por email\nControl de cuentas por cobrar\nReportes contables','bi-receipt',NULL,'S/ 90','ambos','Nuevo','#f59e0b','#',4,0,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(5,'Sistema CRM Empresarial','Gesti├│n de clientes, leads, ventas y seguimiento de oportunidades de negocio. Mejora la relaci├│n con tus clientes y aumenta tus ventas.','Gesti├│n de contactos y clientes\nSeguimiento de oportunidades\nPipeline de ventas\nCampa├▒as de email\nReportes de ventas\nIntegraci├│n con WhatsApp','bi-people-fill',NULL,'S/ 120','ambos',NULL,NULL,'#',5,0,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(6,'Portal Web Institucional','P├ígina web profesional para tu instituci├│n educativa o empresa. Dise├▒o moderno, panel administrativo y herramientas de comunicaci├│n.','Dise├▒o moderno y responsivo\nPanel administrativo\nGaler├¡a de fotos y videos\nPublicaci├│n de noticias\nFormulario de contacto\nOptimizado para buscadores','bi-globe',NULL,'S/ 50','alquiler',NULL,NULL,'#',6,0,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'); /*!40000 ALTER TABLE `servicios` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sessions` ( `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=MyISAM 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 */; /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sliders` -- DROP TABLE IF EXISTS `sliders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sliders` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `titulo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `subtitulo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `descripcion` text COLLATE utf8mb4_unicode_ci, `imagen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `boton_texto` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `boton_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `boton2_texto` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `boton2_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `orden` int NOT NULL DEFAULT '0', `activo` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sliders` -- LOCK TABLES `sliders` WRITE; /*!40000 ALTER TABLE `sliders` DISABLE KEYS */; INSERT INTO `sliders` VALUES (1,'Sistema Acad├®mico Integral','Gesti├│n completa de tu instituci├│n educativa','Matr├¡culas, notas, horarios, asistencia y m├ís en una sola plataforma.',NULL,'Ver Demo','#servicios','Cont├íctanos','#contacto',1,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(2,'Control de Asistencia Digital','Tecnolog├¡a de vanguardia para el registro de asistencia','Marcado por huella, c├│digo QR, c├│digo de barras y reconocimiento facial.',NULL,'Conocer M├ís','#servicios','Solicitar Cotizaci├│n','#contacto',2,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(3,'Plataforma de Gesti├│n Empresarial','Optimiza tus procesos con tecnolog├¡a moderna','CRM, facturaci├│n electr├│nica, inventario y reportes en tiempo real.',NULL,'Explorar Sistemas','#servicios','Agendar Demo','#contacto',3,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'); /*!40000 ALTER TABLE `sliders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testimonios` -- DROP TABLE IF EXISTS `testimonios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `testimonios` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `cargo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `empresa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mensaje` text COLLATE utf8mb4_unicode_ci NOT NULL, `estrellas` int NOT NULL DEFAULT '5', `orden` int NOT NULL DEFAULT '0', `activo` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `testimonios` -- LOCK TABLES `testimonios` WRITE; /*!40000 ALTER TABLE `testimonios` DISABLE KEYS */; INSERT INTO `testimonios` VALUES (1,'Lic. Mar├¡a Quispe','Directora','I.E. San Mart├¡n de Porres - Cusco',NULL,'El sistema acad├®mico ha transformado completamente la gesti├│n de nuestra instituci├│n. Los padres est├ín m├ís involucrados y los docentes trabajan de manera m├ís eficiente.',5,1,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(2,'Mg. Carlos Flores','Gerente Acad├®mico','Instituto Superior IDAT',NULL,'Llevamos 3 a├▒os usando los sistemas de WebSoft y la experiencia ha sido excelente. El soporte t├®cnico es muy r├ípido y el equipo siempre est├í disponible.',5,2,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(3,'Dr. Roberto Condori','Director General','UGEL Puno',NULL,'Implementamos el control de asistencia en 15 instituciones simult├íneamente y el resultado fue impresionante. La tecnolog├¡a de reconocimiento facial es muy precisa.',5,3,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(4,'Lic. Ana Mamani','Administradora','Colegio Particular Los ├üngeles',NULL,'El precio es muy accesible y la calidad del sistema supera a otros del mercado. Lo recomiendo ampliamente a cualquier instituci├│n educativa.',4,4,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'); /*!40000 ALTER TABLE `testimonios` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ticker_items` -- DROP TABLE IF EXISTS `ticker_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ticker_items` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `texto` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `icono` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `orden` int NOT NULL DEFAULT '0', `activo` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ticker_items` -- LOCK TABLES `ticker_items` WRITE; /*!40000 ALTER TABLE `ticker_items` DISABLE KEYS */; INSERT INTO `ticker_items` VALUES (1,'­ƒÄë WebSoft Solutions - M├ís de 500 instituciones conf├¡an en nosotros',NULL,NULL,1,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(2,'­ƒÜÇ Nueva versi├│n del Sistema Acad├®mico disponible - Desc├║brela hoy',NULL,NULL,2,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(3,'­ƒô▒ App m├│vil para padres y alumnos ya disponible en Play Store',NULL,NULL,3,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(4,'­ƒÅå Premio a la Mejor Startup Tecnol├│gica 2025',NULL,NULL,4,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(5,'­ƒÆ╝ Planes especiales para UGEL y DRE - Consulta sin compromiso',NULL,NULL,5,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'),(6,'­ƒô× Soporte t├®cnico 24/7 para todos nuestros clientes',NULL,NULL,6,1,'2026-07-13 01:54:01','2026-07-13 01:54:01'); /*!40000 ALTER TABLE `ticker_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=MyISAM 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 */; /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!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-07-14 10:54:10