--
-- Host: localhost    Database: mania_olt
-- ------------------------------------------------------


--
-- Current Database: `mania_olt`
--


--
-- Table structure for table `alarma_control`
--

CREATE TABLE `alarma_control` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `activo` tinyint(1) DEFAULT 1,
  `fecha` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `alarma_control`
--

INSERT INTO `alarma_control` (`id`, `activo`, `fecha`) VALUES (1,0,'2025-10-27 20:24:42');

--
-- Table structure for table `alarma_potencia`
--

CREATE TABLE `alarma_potencia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `warning` float DEFAULT -28,
  `critical` float DEFAULT -30,
  `fecha` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `alarma_potencia`
--


--
-- Table structure for table `cajas_nap`
--

CREATE TABLE `cajas_nap` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) NOT NULL,
  `zona_id` int(11) DEFAULT NULL,
  `olt_id` int(11) DEFAULT NULL,
  `comentarios` text DEFAULT NULL,
  `splitter` varchar(50) DEFAULT 'Default - 16 puertos',
  `imagen` varchar(255) DEFAULT NULL,
  `ubicacion` enum('Si','No') DEFAULT 'No',
  `latitud` varchar(50) DEFAULT NULL,
  `longitud` varchar(50) DEFAULT NULL,
  `fecha` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `zona_id` (`zona_id`),
  KEY `idx_cajas_nap_olt_id` (`olt_id`),
  CONSTRAINT `cajas_nap_ibfk_1` FOREIGN KEY (`zona_id`) REFERENCES `zonas` (`id`),
  CONSTRAINT `fk_cajas_nap_olt` FOREIGN KEY (`olt_id`) REFERENCES `olts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cajas_nap`
--

INSERT INTO `cajas_nap` (`id`, `nombre`, `zona_id`, `olt_id`, `comentarios`, `splitter`, `imagen`, `ubicacion`, `latitud`, `longitud`, `fecha`) VALUES (2,'NAP-T2-3',2,1,'','Default - 16 puertos','caja_68f8005a9f54c.png','No','','','2025-10-21 21:51:22'),(3,'NAP-T2-1',2,1,'','Default - 16 puertos','caja_68f801476916b.png','No','','','2025-10-21 21:55:19'),(4,'NAP-T2-2',2,1,'','Default - 16 puertos','caja_68f8015aacdb7.png','No','','','2025-10-21 21:55:38'),(5,'NAP-T2-4',2,1,'','Default - 16 puertos','caja_68f801a93b4dc.png','No','','','2025-10-21 21:56:57'),(6,'NAP-T2-5',2,1,'','Default - 16 puertos','caja_68f801ca27214.png','No','','','2025-10-21 21:57:30'),(7,'NAP-T2-6',2,1,'','Default - 16 puertos','caja_68f801f81b8f7.png','No','','','2025-10-21 21:58:16'),(8,'NAP-T2-7',2,1,'','Default - 16 puertos','caja_68f8021099d8e.png','No','','','2025-10-21 21:58:40'),(9,'NAP-T2-8',2,1,'','Default - 16 puertos','caja_68f80225338f7.png','No','','','2025-10-21 21:59:01'),(10,'NAP-T1-1',2,1,'','Default - 16 puertos','caja_68f802578c92e.png','No','','','2025-10-21 21:59:51'),(11,'NAP-T1-2',2,1,'','Default - 16 puertos','caja_68f80273df6ff.png','No','','','2025-10-21 22:00:19'),(12,'NAP-T1-3',2,1,'','Default - 16 puertos','caja_68f802845c559.png','No','','','2025-10-21 22:00:36'),(13,'NAP-T1-4',2,1,'','Default - 16 puertos','caja_68f8029753b11.png','No','','','2025-10-21 22:00:55'),(14,'NAP-T1-5',2,1,'','Default - 16 puertos','caja_68f802a60471a.png','No','','','2025-10-21 22:01:10'),(15,'NAP-T3-1',2,1,'','Default - 16 puertos','caja_68f802c643ae1.png','No','','','2025-10-21 22:01:42'),(16,'NAP-T3-2',2,1,'','Default - 16 puertos','caja_68f802d5a4544.png','No','','','2025-10-21 22:01:57'),(17,'NAP-T3-3',2,1,'','Default - 16 puertos','caja_68f802e17ee41.png','No','','','2025-10-21 22:02:09'),(18,'NAP-T3-4',2,1,'','Default - 16 puertos','caja_68f802f1414dd.png','No','','','2025-10-21 22:02:25'),(19,'NAP-T3-5',2,1,'','Default - 16 puertos','caja_68f80311edc6c.png','No','','','2025-10-21 22:02:57');

--
-- Table structure for table `cajas_puertos`
--

CREATE TABLE `cajas_puertos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `caja_id` int(11) NOT NULL,
  `puerto` int(11) NOT NULL,
  `estado` enum('Libre','Ocupado') DEFAULT 'Libre',
  `onu_id` int(11) DEFAULT NULL,
  `fecha` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `fk_caja_puertos` (`caja_id`),
  CONSTRAINT `fk_caja_puertos` FOREIGN KEY (`caja_id`) REFERENCES `cajas_nap` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=321 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cajas_puertos`
--

INSERT INTO `cajas_puertos` (`id`, `caja_id`, `puerto`, `estado`, `onu_id`, `fecha`) VALUES (17,2,1,'Ocupado',28,'2025-10-21 21:51:22'),(18,2,2,'Libre',NULL,'2025-10-21 21:51:22'),(19,2,3,'Libre',NULL,'2025-10-21 21:51:22'),(20,2,4,'Libre',NULL,'2025-10-21 21:51:22'),(21,2,5,'Libre',NULL,'2025-10-21 21:51:22'),(22,2,6,'Libre',NULL,'2025-10-21 21:51:22'),(23,2,7,'Libre',NULL,'2025-10-21 21:51:22'),(24,2,8,'Libre',NULL,'2025-10-21 21:51:22'),(25,2,9,'Libre',NULL,'2025-10-21 21:51:22'),(26,2,10,'Libre',NULL,'2025-10-21 21:51:22'),(27,2,11,'Libre',NULL,'2025-10-21 21:51:22'),(28,2,12,'Libre',NULL,'2025-10-21 21:51:22'),(29,2,13,'Libre',NULL,'2025-10-21 21:51:22'),(30,2,14,'Libre',NULL,'2025-10-21 21:51:22'),(31,2,15,'Libre',NULL,'2025-10-21 21:51:22'),(32,2,16,'Libre',NULL,'2025-10-21 21:51:22'),(33,3,1,'Libre',NULL,'2025-10-21 21:55:19'),(34,3,2,'Libre',NULL,'2025-10-21 21:55:19'),(35,3,3,'Libre',NULL,'2025-10-21 21:55:19'),(36,3,4,'Libre',NULL,'2025-10-21 21:55:19'),(37,3,5,'Libre',NULL,'2025-10-21 21:55:19'),(38,3,6,'Libre',NULL,'2025-10-21 21:55:19'),(39,3,7,'Libre',NULL,'2025-10-21 21:55:19'),(40,3,8,'Libre',NULL,'2025-10-21 21:55:19'),(41,3,9,'Libre',NULL,'2025-10-21 21:55:19'),(42,3,10,'Libre',NULL,'2025-10-21 21:55:19'),(43,3,11,'Libre',NULL,'2025-10-21 21:55:19'),(44,3,12,'Libre',NULL,'2025-10-21 21:55:19'),(45,3,13,'Libre',NULL,'2025-10-21 21:55:19'),(46,3,14,'Libre',NULL,'2025-10-21 21:55:19'),(47,3,15,'Libre',NULL,'2025-10-21 21:55:19'),(48,3,16,'Libre',NULL,'2025-10-21 21:55:19'),(49,4,1,'Libre',NULL,'2025-10-21 21:55:38'),(50,4,2,'Libre',NULL,'2025-10-21 21:55:38'),(51,4,3,'Libre',NULL,'2025-10-21 21:55:38'),(52,4,4,'Libre',NULL,'2025-10-21 21:55:38'),(53,4,5,'Libre',NULL,'2025-10-21 21:55:38'),(54,4,6,'Libre',NULL,'2025-10-21 21:55:38'),(55,4,7,'Libre',NULL,'2025-10-21 21:55:38'),(56,4,8,'Libre',NULL,'2025-10-21 21:55:38'),(57,4,9,'Libre',NULL,'2025-10-21 21:55:38'),(58,4,10,'Libre',NULL,'2025-10-21 21:55:38'),(59,4,11,'Libre',NULL,'2025-10-21 21:55:38'),(60,4,12,'Libre',NULL,'2025-10-21 21:55:38'),(61,4,13,'Libre',NULL,'2025-10-21 21:55:38'),(62,4,14,'Libre',NULL,'2025-10-21 21:55:38'),(63,4,15,'Libre',NULL,'2025-10-21 21:55:38'),(64,4,16,'Libre',NULL,'2025-10-21 21:55:38'),(65,5,1,'Libre',NULL,'2025-10-21 21:56:57'),(66,5,2,'Libre',NULL,'2025-10-21 21:56:57'),(67,5,3,'Libre',NULL,'2025-10-21 21:56:57'),(68,5,4,'Libre',NULL,'2025-10-21 21:56:57'),(69,5,5,'Libre',NULL,'2025-10-21 21:56:57'),(70,5,6,'Libre',NULL,'2025-10-21 21:56:57'),(71,5,7,'Libre',NULL,'2025-10-21 21:56:57'),(72,5,8,'Libre',NULL,'2025-10-21 21:56:57'),(73,5,9,'Libre',NULL,'2025-10-21 21:56:57'),(74,5,10,'Libre',NULL,'2025-10-21 21:56:57'),(75,5,11,'Libre',NULL,'2025-10-21 21:56:57'),(76,5,12,'Libre',NULL,'2025-10-21 21:56:57'),(77,5,13,'Libre',NULL,'2025-10-21 21:56:57'),(78,5,14,'Libre',NULL,'2025-10-21 21:56:57'),(79,5,15,'Libre',NULL,'2025-10-21 21:56:57'),(80,5,16,'Libre',NULL,'2025-10-21 21:56:57'),(81,6,1,'Libre',NULL,'2025-10-21 21:57:30'),(82,6,2,'Libre',NULL,'2025-10-21 21:57:30'),(83,6,3,'Libre',NULL,'2025-10-21 21:57:30'),(84,6,4,'Libre',NULL,'2025-10-21 21:57:30'),(85,6,5,'Libre',NULL,'2025-10-21 21:57:30'),(86,6,6,'Libre',NULL,'2025-10-21 21:57:30'),(87,6,7,'Libre',NULL,'2025-10-21 21:57:30'),(88,6,8,'Libre',NULL,'2025-10-21 21:57:30'),(89,6,9,'Libre',NULL,'2025-10-21 21:57:30'),(90,6,10,'Libre',NULL,'2025-10-21 21:57:30'),(91,6,11,'Libre',NULL,'2025-10-21 21:57:30'),(92,6,12,'Libre',NULL,'2025-10-21 21:57:30'),(93,6,13,'Libre',NULL,'2025-10-21 21:57:30'),(94,6,14,'Libre',NULL,'2025-10-21 21:57:30'),(95,6,15,'Libre',NULL,'2025-10-21 21:57:30'),(96,6,16,'Libre',NULL,'2025-10-21 21:57:30'),(97,7,1,'Libre',NULL,'2025-10-21 21:58:16'),(98,7,2,'Libre',NULL,'2025-10-21 21:58:16'),(99,7,3,'Libre',NULL,'2025-10-21 21:58:16'),(100,7,4,'Libre',NULL,'2025-10-21 21:58:16'),(101,7,5,'Libre',NULL,'2025-10-21 21:58:16'),(102,7,6,'Libre',NULL,'2025-10-21 21:58:16'),(103,7,7,'Libre',NULL,'2025-10-21 21:58:16'),(104,7,8,'Libre',NULL,'2025-10-21 21:58:16'),(105,7,9,'Libre',NULL,'2025-10-21 21:58:16'),(106,7,10,'Libre',NULL,'2025-10-21 21:58:16'),(107,7,11,'Libre',NULL,'2025-10-21 21:58:16'),(108,7,12,'Libre',NULL,'2025-10-21 21:58:16'),(109,7,13,'Libre',NULL,'2025-10-21 21:58:16'),(110,7,14,'Libre',NULL,'2025-10-21 21:58:16'),(111,7,15,'Libre',NULL,'2025-10-21 21:58:16'),(112,7,16,'Libre',NULL,'2025-10-21 21:58:16'),(113,8,1,'Libre',NULL,'2025-10-21 21:58:40'),(114,8,2,'Libre',NULL,'2025-10-21 21:58:40'),(115,8,3,'Libre',NULL,'2025-10-21 21:58:40'),(116,8,4,'Libre',NULL,'2025-10-21 21:58:40'),(117,8,5,'Libre',NULL,'2025-10-21 21:58:40'),(118,8,6,'Libre',NULL,'2025-10-21 21:58:40'),(119,8,7,'Libre',NULL,'2025-10-21 21:58:40'),(120,8,8,'Libre',NULL,'2025-10-21 21:58:40'),(121,8,9,'Libre',NULL,'2025-10-21 21:58:40'),(122,8,10,'Libre',NULL,'2025-10-21 21:58:40'),(123,8,11,'Libre',NULL,'2025-10-21 21:58:40'),(124,8,12,'Libre',NULL,'2025-10-21 21:58:40'),(125,8,13,'Libre',NULL,'2025-10-21 21:58:40'),(126,8,14,'Libre',NULL,'2025-10-21 21:58:40'),(127,8,15,'Libre',NULL,'2025-10-21 21:58:40'),(128,8,16,'Libre',NULL,'2025-10-21 21:58:40'),(129,9,1,'Libre',NULL,'2025-10-21 21:59:01'),(130,9,2,'Libre',NULL,'2025-10-21 21:59:01'),(131,9,3,'Libre',NULL,'2025-10-21 21:59:01'),(132,9,4,'Libre',NULL,'2025-10-21 21:59:01'),(133,9,5,'Libre',NULL,'2025-10-21 21:59:01'),(134,9,6,'Libre',NULL,'2025-10-21 21:59:01'),(135,9,7,'Libre',NULL,'2025-10-21 21:59:01'),(136,9,8,'Libre',NULL,'2025-10-21 21:59:01'),(137,9,9,'Libre',NULL,'2025-10-21 21:59:01'),(138,9,10,'Libre',NULL,'2025-10-21 21:59:01'),(139,9,11,'Libre',NULL,'2025-10-21 21:59:01'),(140,9,12,'Libre',NULL,'2025-10-21 21:59:01'),(141,9,13,'Libre',NULL,'2025-10-21 21:59:01'),(142,9,14,'Libre',NULL,'2025-10-21 21:59:01'),(143,9,15,'Libre',NULL,'2025-10-21 21:59:01'),(144,9,16,'Libre',NULL,'2025-10-21 21:59:01'),(145,10,1,'Libre',NULL,'2025-10-21 21:59:51'),(146,10,2,'Libre',NULL,'2025-10-21 21:59:51'),(147,10,3,'Libre',NULL,'2025-10-21 21:59:51'),(148,10,4,'Libre',NULL,'2025-10-21 21:59:51'),(149,10,5,'Libre',NULL,'2025-10-21 21:59:51'),(150,10,6,'Libre',NULL,'2025-10-21 21:59:51'),(151,10,7,'Libre',NULL,'2025-10-21 21:59:51'),(152,10,8,'Libre',NULL,'2025-10-21 21:59:51'),(153,10,9,'Libre',NULL,'2025-10-21 21:59:51'),(154,10,10,'Libre',NULL,'2025-10-21 21:59:51'),(155,10,11,'Libre',NULL,'2025-10-21 21:59:51'),(156,10,12,'Libre',NULL,'2025-10-21 21:59:51'),(157,10,13,'Libre',NULL,'2025-10-21 21:59:51'),(158,10,14,'Libre',NULL,'2025-10-21 21:59:51'),(159,10,15,'Libre',NULL,'2025-10-21 21:59:51'),(160,10,16,'Libre',NULL,'2025-10-21 21:59:51'),(161,11,1,'Libre',NULL,'2025-10-21 22:00:19'),(162,11,2,'Libre',NULL,'2025-10-21 22:00:19'),(163,11,3,'Libre',NULL,'2025-10-21 22:00:19'),(164,11,4,'Libre',NULL,'2025-10-21 22:00:19'),(165,11,5,'Libre',NULL,'2025-10-21 22:00:19'),(166,11,6,'Libre',NULL,'2025-10-21 22:00:19'),(167,11,7,'Libre',NULL,'2025-10-21 22:00:19'),(168,11,8,'Libre',NULL,'2025-10-21 22:00:19'),(169,11,9,'Libre',NULL,'2025-10-21 22:00:19'),(170,11,10,'Libre',NULL,'2025-10-21 22:00:19'),(171,11,11,'Libre',NULL,'2025-10-21 22:00:19'),(172,11,12,'Libre',NULL,'2025-10-21 22:00:19'),(173,11,13,'Libre',NULL,'2025-10-21 22:00:19'),(174,11,14,'Libre',NULL,'2025-10-21 22:00:19'),(175,11,15,'Libre',NULL,'2025-10-21 22:00:19'),(176,11,16,'Libre',NULL,'2025-10-21 22:00:19'),(177,12,1,'Libre',NULL,'2025-10-21 22:00:36'),(178,12,2,'Libre',NULL,'2025-10-21 22:00:36'),(179,12,3,'Libre',NULL,'2025-10-21 22:00:36'),(180,12,4,'Libre',NULL,'2025-10-21 22:00:36'),(181,12,5,'Libre',NULL,'2025-10-21 22:00:36'),(182,12,6,'Libre',NULL,'2025-10-21 22:00:36'),(183,12,7,'Libre',NULL,'2025-10-21 22:00:36'),(184,12,8,'Libre',NULL,'2025-10-21 22:00:36'),(185,12,9,'Libre',NULL,'2025-10-21 22:00:36'),(186,12,10,'Libre',NULL,'2025-10-21 22:00:36'),(187,12,11,'Libre',NULL,'2025-10-21 22:00:36'),(188,12,12,'Libre',NULL,'2025-10-21 22:00:36'),(189,12,13,'Libre',NULL,'2025-10-21 22:00:36'),(190,12,14,'Libre',NULL,'2025-10-21 22:00:36'),(191,12,15,'Libre',NULL,'2025-10-21 22:00:36'),(192,12,16,'Libre',NULL,'2025-10-21 22:00:36'),(193,13,1,'Libre',NULL,'2025-10-21 22:00:55'),(194,13,2,'Libre',NULL,'2025-10-21 22:00:55'),(195,13,3,'Libre',NULL,'2025-10-21 22:00:55'),(196,13,4,'Libre',NULL,'2025-10-21 22:00:55'),(197,13,5,'Libre',NULL,'2025-10-21 22:00:55'),(198,13,6,'Libre',NULL,'2025-10-21 22:00:55'),(199,13,7,'Libre',NULL,'2025-10-21 22:00:55'),(200,13,8,'Libre',NULL,'2025-10-21 22:00:55'),(201,13,9,'Libre',NULL,'2025-10-21 22:00:55'),(202,13,10,'Libre',NULL,'2025-10-21 22:00:55'),(203,13,11,'Libre',NULL,'2025-10-21 22:00:55'),(204,13,12,'Libre',NULL,'2025-10-21 22:00:55'),(205,13,13,'Libre',NULL,'2025-10-21 22:00:55'),(206,13,14,'Libre',NULL,'2025-10-21 22:00:55'),(207,13,15,'Libre',NULL,'2025-10-21 22:00:55'),(208,13,16,'Libre',NULL,'2025-10-21 22:00:55'),(209,14,1,'Libre',NULL,'2025-10-21 22:01:10'),(210,14,2,'Libre',NULL,'2025-10-21 22:01:10'),(211,14,3,'Libre',NULL,'2025-10-21 22:01:10'),(212,14,4,'Libre',NULL,'2025-10-21 22:01:10'),(213,14,5,'Libre',NULL,'2025-10-21 22:01:10'),(214,14,6,'Libre',NULL,'2025-10-21 22:01:10'),(215,14,7,'Libre',NULL,'2025-10-21 22:01:10'),(216,14,8,'Libre',NULL,'2025-10-21 22:01:10'),(217,14,9,'Libre',NULL,'2025-10-21 22:01:10'),(218,14,10,'Libre',NULL,'2025-10-21 22:01:10'),(219,14,11,'Libre',NULL,'2025-10-21 22:01:10'),(220,14,12,'Libre',NULL,'2025-10-21 22:01:10'),(221,14,13,'Libre',NULL,'2025-10-21 22:01:10'),(222,14,14,'Libre',NULL,'2025-10-21 22:01:10'),(223,14,15,'Libre',NULL,'2025-10-21 22:01:10'),(224,14,16,'Libre',NULL,'2025-10-21 22:01:10'),(225,15,1,'Libre',NULL,'2025-10-21 22:01:42'),(226,15,2,'Libre',NULL,'2025-10-21 22:01:42'),(227,15,3,'Libre',NULL,'2025-10-21 22:01:42'),(228,15,4,'Libre',NULL,'2025-10-21 22:01:42'),(229,15,5,'Libre',NULL,'2025-10-21 22:01:42'),(230,15,6,'Libre',NULL,'2025-10-21 22:01:42'),(231,15,7,'Libre',NULL,'2025-10-21 22:01:42'),(232,15,8,'Libre',NULL,'2025-10-21 22:01:42'),(233,15,9,'Libre',NULL,'2025-10-21 22:01:42'),(234,15,10,'Libre',NULL,'2025-10-21 22:01:42'),(235,15,11,'Libre',NULL,'2025-10-21 22:01:42'),(236,15,12,'Libre',NULL,'2025-10-21 22:01:42'),(237,15,13,'Libre',NULL,'2025-10-21 22:01:42'),(238,15,14,'Libre',NULL,'2025-10-21 22:01:42'),(239,15,15,'Libre',NULL,'2025-10-21 22:01:42'),(240,15,16,'Libre',NULL,'2025-10-21 22:01:42'),(241,16,1,'Libre',NULL,'2025-10-21 22:01:57'),(242,16,2,'Libre',NULL,'2025-10-21 22:01:57'),(243,16,3,'Libre',NULL,'2025-10-21 22:01:57'),(244,16,4,'Libre',NULL,'2025-10-21 22:01:57'),(245,16,5,'Libre',NULL,'2025-10-21 22:01:57'),(246,16,6,'Libre',NULL,'2025-10-21 22:01:57'),(247,16,7,'Libre',NULL,'2025-10-21 22:01:57'),(248,16,8,'Libre',NULL,'2025-10-21 22:01:57'),(249,16,9,'Libre',NULL,'2025-10-21 22:01:57'),(250,16,10,'Libre',NULL,'2025-10-21 22:01:57'),(251,16,11,'Libre',NULL,'2025-10-21 22:01:57'),(252,16,12,'Libre',NULL,'2025-10-21 22:01:57'),(253,16,13,'Libre',NULL,'2025-10-21 22:01:57'),(254,16,14,'Libre',NULL,'2025-10-21 22:01:57'),(255,16,15,'Libre',NULL,'2025-10-21 22:01:57'),(256,16,16,'Libre',NULL,'2025-10-21 22:01:57'),(257,17,1,'Libre',NULL,'2025-10-21 22:02:09'),(258,17,2,'Libre',NULL,'2025-10-21 22:02:09'),(259,17,3,'Libre',NULL,'2025-10-21 22:02:09'),(260,17,4,'Libre',NULL,'2025-10-21 22:02:09'),(261,17,5,'Libre',NULL,'2025-10-21 22:02:09'),(262,17,6,'Libre',NULL,'2025-10-21 22:02:09'),(263,17,7,'Libre',NULL,'2025-10-21 22:02:09'),(264,17,8,'Libre',NULL,'2025-10-21 22:02:09'),(265,17,9,'Libre',NULL,'2025-10-21 22:02:09'),(266,17,10,'Libre',NULL,'2025-10-21 22:02:09'),(267,17,11,'Libre',NULL,'2025-10-21 22:02:09'),(268,17,12,'Libre',NULL,'2025-10-21 22:02:09'),(269,17,13,'Libre',NULL,'2025-10-21 22:02:09'),(270,17,14,'Libre',NULL,'2025-10-21 22:02:09'),(271,17,15,'Libre',NULL,'2025-10-21 22:02:09'),(272,17,16,'Libre',NULL,'2025-10-21 22:02:09'),(273,18,1,'Libre',NULL,'2025-10-21 22:02:25'),(274,18,2,'Libre',NULL,'2025-10-21 22:02:25'),(275,18,3,'Libre',NULL,'2025-10-21 22:02:25'),(276,18,4,'Libre',NULL,'2025-10-21 22:02:25'),(277,18,5,'Libre',NULL,'2025-10-21 22:02:25'),(278,18,6,'Libre',NULL,'2025-10-21 22:02:25'),(279,18,7,'Libre',NULL,'2025-10-21 22:02:25'),(280,18,8,'Libre',NULL,'2025-10-21 22:02:25'),(281,18,9,'Libre',NULL,'2025-10-21 22:02:25'),(282,18,10,'Libre',NULL,'2025-10-21 22:02:25'),(283,18,11,'Libre',NULL,'2025-10-21 22:02:25'),(284,18,12,'Libre',NULL,'2025-10-21 22:02:25'),(285,18,13,'Libre',NULL,'2025-10-21 22:02:25'),(286,18,14,'Libre',NULL,'2025-10-21 22:02:25'),(287,18,15,'Libre',NULL,'2025-10-21 22:02:25'),(288,18,16,'Libre',NULL,'2025-10-21 22:02:25'),(289,19,1,'Libre',NULL,'2025-10-21 22:02:57'),(290,19,2,'Libre',NULL,'2025-10-21 22:02:57'),(291,19,3,'Libre',NULL,'2025-10-21 22:02:57'),(292,19,4,'Libre',NULL,'2025-10-21 22:02:57'),(293,19,5,'Libre',NULL,'2025-10-21 22:02:57'),(294,19,6,'Libre',NULL,'2025-10-21 22:02:57'),(295,19,7,'Libre',NULL,'2025-10-21 22:02:57'),(296,19,8,'Libre',NULL,'2025-10-21 22:02:57'),(297,19,9,'Libre',NULL,'2025-10-21 22:02:57'),(298,19,10,'Libre',NULL,'2025-10-21 22:02:57'),(299,19,11,'Libre',NULL,'2025-10-21 22:02:57'),(300,19,12,'Libre',NULL,'2025-10-21 22:02:57'),(301,19,13,'Libre',NULL,'2025-10-21 22:02:57'),(302,19,14,'Libre',NULL,'2025-10-21 22:02:57'),(303,19,15,'Libre',NULL,'2025-10-21 22:02:57'),(304,19,16,'Libre',NULL,'2025-10-21 22:02:57');

--
-- Table structure for table `config_empresa`
--

CREATE TABLE `config_empresa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre_empresa` varchar(100) DEFAULT 'Mi Empresa',
  `telefono` varchar(30) DEFAULT '',
  `correo` varchar(100) DEFAULT '',
  `direccion` varchar(255) DEFAULT '',
  `color_base` varchar(20) DEFAULT '#0d6efd',
  `logo` varchar(255) DEFAULT NULL,
  `pie_pagina` varchar(255) DEFAULT '© CRM-OLT',
  `fecha` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `config_empresa`
--

INSERT INTO `config_empresa` (`id`, `nombre_empresa`, `telefono`, `correo`, `direccion`, `color_base`, `logo`, `pie_pagina`, `fecha`) VALUES (1,'Mi Empresa','','','','#0d6efd',NULL,'© 2025 CRM-OLT','2025-10-21 04:03:43'),(2,'LinkMex Mexico S.A DE C.V','5585058348','juan.clp@hotmail.com','Los Heroes Tecamac Edo. de Mexico','#0d6efd','logo_1761046951.png','© 2025 CRM-OLT-WisNet','2025-10-21 11:42:31');

--
-- Table structure for table `empresa_config`
--

CREATE TABLE `empresa_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) DEFAULT NULL,
  `rfc` varchar(30) DEFAULT NULL,
  `direccion` text DEFAULT NULL,
  `telefono` varchar(30) DEFAULT NULL,
  `correo` varchar(100) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `fecha` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `empresa_config`
--

INSERT INTO `empresa_config` (`id`, `nombre`, `rfc`, `direccion`, `telefono`, `correo`, `logo`, `fecha`) VALUES (1,'LinkMex Mexico S.A de C.V.','RFC123456','Los Heroes Tecamac','5585058348','juan.clp@hotmail.com','empresa_logo_1761047796.png','2025-10-21 11:56:36'),(2,'LinkMex Mexico S.A de C.V.','RFC123456','Los Heroes Tecamac','5585058348','juan.clp@hotmail.com','empresa_logo_1761047796.png','2025-10-21 12:28:08');

--
-- Table structure for table `empresa_datos`
--

CREATE TABLE `empresa_datos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razon_social` varchar(255) NOT NULL,
  `rfc` varchar(50) DEFAULT NULL,
  `direccion` varchar(255) DEFAULT NULL,
  `telefono` varchar(50) DEFAULT NULL,
  `correo` varchar(100) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `fecha_actualizacion` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `empresa_datos`
--

INSERT INTO `empresa_datos` (`id`, `razon_social`, `rfc`, `direccion`, `telefono`, `correo`, `logo`, `fecha_actualizacion`) VALUES (1,'LinkMex Mexico S.A de C.V.','LMM123456XYZ','Av. Tecnológico #123, Tecamac, Edo. de México','555-123-4567','contacto@mexolt.com.mx','/olt_crm/uploads/empresa_logo_1762829989.png','2025-11-11 02:59:49');

--
-- Table structure for table `login_estilos`
--

CREATE TABLE `login_estilos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rol` varchar(50) DEFAULT 'admin',
  `logo` varchar(255) DEFAULT NULL,
  `fondo` varchar(255) DEFAULT NULL,
  `color_base` varchar(20) DEFAULT '#0d6efd',
  `activo` tinyint(1) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `login_estilos`
--

INSERT INTO `login_estilos` (`id`, `rol`, `logo`, `fondo`, `color_base`, `activo`) VALUES (1,'admin',NULL,NULL,'#0d6efd',1),(2,'admin','login_logo_1761047185.bmp','login_fondo_1761047185.jpg','#0d6efd',1),(3,'admin','login_logo_1761047185.bmp','login_fondo_1761047185.jpg','#4067a0',1),(4,'admin','login_logo_1762832762.png','login_fondo_1761047185.jpg','#4067a0',1);

--
-- Table structure for table `modelos_olt`
--

CREATE TABLE `modelos_olt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `marca` varchar(100) NOT NULL,
  `modelo` varchar(100) NOT NULL,
  `oid_descripcion` varchar(255) DEFAULT NULL,
  `oid_tiempo` varchar(255) DEFAULT NULL,
  `oid_temperatura` varchar(255) DEFAULT NULL,
  `oid_onus` varchar(255) DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `fecha` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `modelos_olt`
--

INSERT INTO `modelos_olt` (`id`, `marca`, `modelo`, `oid_descripcion`, `oid_tiempo`, `oid_temperatura`, `oid_onus`, `foto`, `fecha`) VALUES (1,'VSOL','V1600GS','1.3.6.1.4.1.37950.1.1.5.10.14.1.0','1.3.6.1.4.1.37950.1.1.5.10.12.5.8.0','1.3.6.1.4.1.37950.1.1.5.10.12.5.9.0','','olt_1761620637_5b6cb2.png','2025-10-28 03:03:57');

--
-- Table structure for table `modelos_onu`
--

CREATE TABLE `modelos_onu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modelo` varchar(100) DEFAULT NULL,
  `tipo_pon` varchar(50) DEFAULT NULL,
  `modo` varchar(50) DEFAULT NULL,
  `puertos_eth` int(11) DEFAULT NULL,
  `puertos_voip` int(11) DEFAULT NULL,
  `ssid_wifi` int(11) DEFAULT 0,
  `wifi_ssid` int(11) DEFAULT NULL,
  `catv` varchar(10) DEFAULT NULL,
  `imagen` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `modelos_onu`
--

INSERT INTO `modelos_onu` (`id`, `modelo`, `tipo_pon`, `modo`, `puertos_eth`, `puertos_voip`, `ssid_wifi`, `wifi_ssid`, `catv`, `imagen`) VALUES (1,'HG8145V5','GPON','Routing',4,1,2,NULL,'No','1761080062_HG8145V5.jpg'),(2,'F670L-TMX','GPON','Routing',4,1,2,NULL,'No','1761083542_ZTE-F670L.png'),(3,'F670L-TP','GPON','Routing',4,1,2,NULL,'No','1761083564_ZTE-F670L-TP.png'),(4,'HG8145V3','GPON','Routing',4,1,2,NULL,'No','1761084473_HG8145V3.jpg.png');

--
-- Table structure for table `onu_states`
--

CREATE TABLE `onu_states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `olt` varchar(100) DEFAULT NULL,
  `onu` varchar(100) DEFAULT NULL,
  `serial_alias` varchar(100) DEFAULT NULL,
  `estado` varchar(50) DEFAULT NULL,
  `rx` varchar(20) DEFAULT NULL,
  `tx` varchar(20) DEFAULT NULL,
  `onu_id` int(11) DEFAULT NULL,
  `fecha` timestamp NOT NULL DEFAULT current_timestamp(),
  `cliente_nombre` varchar(100) DEFAULT NULL,
  `zona_id` int(11) DEFAULT NULL,
  `caja_id` int(11) DEFAULT NULL,
  `puerto_caja` int(11) DEFAULT NULL,
  `modelo_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_onu` (`olt`,`onu`)
) ENGINE=InnoDB AUTO_INCREMENT=506021 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `onu_states`
--

INSERT INTO `onu_states` (`id`, `olt`, `onu`, `serial_alias`, `estado`, `rx`, `tx`, `onu_id`, `fecha`, `cliente_nombre`, `zona_id`, `caja_id`, `puerto_caja`, `modelo_id`) VALUES (1,'148.113.205.106:3161','HWTC1BE4CDA2','HWTC1BE4CDA2','Online','-16.162 dBm','GPON1/3/1',1,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(2,'148.113.205.106:3161','HWTCC2F010AE','HWTCC2F010AE','Online','-13.706 dBm','GPON1/3/1',2,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(3,'148.113.205.106:3161','HWTC55E2CFA7','HWTC55E2CFA7','Online','-25.688 dBm','GPON1/3/1',3,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(4,'148.113.205.106:3161','HWTC359E90B0','HWTC359E90B0','Online','-14.976 dBm','GPON1/3/1',4,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(5,'148.113.205.106:3161','HWTC35AAC7B0','HWTC35AAC7B0','Online','-21.872 dBm','GPON1/3/1',5,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(6,'148.113.205.106:3161','HWTCE869ECAF','HWTCE869ECAF','Online','-14.438 dBm','GPON1/3/1',6,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(7,'148.113.205.106:3161','HWTC2DCDA09E','HWTC2DCDA09E','Online','-13.676 dBm','GPON1/3/1',7,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(8,'148.113.205.106:3161','HWTCEC913AA6','HWTCEC913AA6','Online','-22.292 dBm','GPON1/3/1',8,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(9,'148.113.205.106:3161','HWTC1C55B0A3','HWTC1C55B0A3','Online','-15.046 dBm','GPON1/3/2',1,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(10,'148.113.205.106:3161','HWTC0B06B4AA','HWTC0B06B4AA','Online','-17.546 dBm','GPON1/3/2',2,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(11,'148.113.205.106:3161','HWTC1C2C18A3','HWTC1C2C18A3','Online','-15.130 dBm','GPON1/3/2',3,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(12,'148.113.205.106:3161','ZTEGCE4FD153','ZTEGCE4FD153','Online','-19.356 dBm','GPON1/3/2',4,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(13,'148.113.205.106:3161','ZTEGCEDD8D00','ZTEGCEDD8D00','Online','-16.402 dBm','GPON1/3/2',5,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(14,'148.113.205.106:3161','ZTEGCE4F7124','ZTEGCE4F7124','Online','-17.772 dBm','GPON1/3/2',6,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(15,'148.113.205.106:3161','ZTEGCEDE29E8','ZTEGCEDE29E8','Online','-15.258 dBm','GPON1/3/2',7,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(16,'148.113.205.106:3161','ZTEGCE446213','ZTEGCE446213','Online','-16.842 dBm','GPON1/3/2',8,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(17,'148.113.205.106:3161','HWTC35E2CEB0','HWTC35E2CEB0','Online','-14.090 dBm','GPON1/3/2',9,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(18,'148.113.205.106:3161','HWTC35C8A9B0','HWTC35C8A9B0','Online','-15.818 dBm','GPON1/3/2',10,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(19,'148.113.205.106:3161','ZTEG242444F1','ZTEG242444F1','Online','-16.536 dBm','GPON1/3/2',11,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(20,'148.113.205.106:3161','HWTC35F11DB0','HWTC35F11DB0','Online','-16.820 dBm','GPON1/3/2',13,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(21,'148.113.205.106:3161','HWTC289B4C9D','HWTC289B4C9D','Online','-16.738 dBm','GPON1/3/2',14,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(22,'148.113.205.106:3161','HWTCC1572366','HWTCC1572366','Online','-19.508 dBm','GPON1/3/2',15,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(23,'148.113.205.106:3161','HWTCB5A570A3','HWTCB5A570A3','Online','-17.960 dBm','GPON1/3/2',16,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(24,'148.113.205.106:3161','HWTCAF53619C','HWTCAF53619C','Online','-23.666 dBm','GPON1/3/2',17,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(25,'148.113.205.106:3161','ZTEG23418187','ZTEG23418187','Online','-14.560 dBm','GPON1/3/2',18,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(26,'148.113.205.106:3161','HWTC829BB5AA','HWTC829BB5AA','Online','-18.240 dBm','GPON1/3/2',19,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(27,'148.113.205.106:3161','HWTC8289C9AA','HWTC8289C9AA','Online','-15.172 dBm','GPON1/3/2',20,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(28,'148.113.205.106:3161','STRING: \"ZTEG$%\\\"	','ZTEG24252209','Online','-14.622 dBm','GPON1/3/2',21,'2025-10-30 02:55:08','GUADALUPE VERONICA VALERO MARROQUIN',2,2,1,2),(29,'148.113.205.106:3161','HWTC15B1C8A1','HWTC15B1C8A1','Online','-17.596 dBm','GPON1/3/3',1,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(30,'148.113.205.106:3161','HWTCB28209A3','HWTCB28209A3','Online','-16.676 dBm','GPON1/3/3',2,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(31,'148.113.205.106:3161','HWTC0C450CAA','HWTC0C450CAA','Online','-20.810 dBm','GPON1/3/3',3,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(32,'148.113.205.106:3161','HWTCB8CF02A0','HWTCB8CF02A0','Online','-15.802 dBm','GPON1/3/3',4,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(33,'148.113.205.106:3161','HWTC22E680A4','HWTC22E680A4','Online','-16.056 dBm','GPON1/3/3',5,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(34,'148.113.205.106:3161','HWTCDCF4409F','HWTCDCF4409F','Online','-16.004 dBm','GPON1/3/3',6,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(35,'148.113.205.106:3161','HWTCCC6899A8','HWTCCC6899A8','Online','-17.400 dBm','GPON1/3/3',7,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(36,'148.113.205.106:3161','ZTEGCEDDAC91','ZTEGCEDDAC91','Online','-18.962 dBm','GPON1/3/3',8,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(37,'148.113.205.106:3161','HWTCCB4DBEA3','HWTCCB4DBEA3','Online','-18.634 dBm','GPON1/3/3',9,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(38,'148.113.205.106:3161','HWTCF28733A2','HWTCF28733A2','Online','-17.696 dBm','GPON1/3/3',10,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(39,'148.113.205.106:3161','HWTC35C44BB0','HWTC35C44BB0','Online','-19.066 dBm','GPON1/3/3',11,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(40,'148.113.205.106:3161','HWTC8DA7049F','HWTC8DA7049F','Online','-16.128 dBm','GPON1/3/3',12,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(41,'148.113.205.106:3161','HWTC35CF83B0','HWTC35CF83B0','Online','-16.328 dBm','GPON1/3/3',14,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(42,'148.113.205.106:3161','HWTC7A85F49F','HWTC7A85F49F','Online','-17.570 dBm','GPON1/3/3',17,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(43,'148.113.205.106:3161','HWTCD7F1159F','HWTCD7F1159F','Online','-17.672 dBm','GPON1/3/3',18,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL),(138268,'148.113.205.106:3161','ALCLFC3B1E0A','ALCLFC3B1E0A','Online','-11.924 dBm','GPON1/3/8',1,'2025-10-30 02:55:08',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `rx_rangos`
--

CREATE TABLE `rx_rangos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rango_verde_min` float DEFAULT -19,
  `rango_verde_max` float DEFAULT -10.4,
  `rango_naranja_min` float DEFAULT -26,
  `rango_naranja_max` float DEFAULT -20.8,
  `rango_rojo_min` float DEFAULT -30,
  `rango_rojo_max` float DEFAULT -27.5,
  `fecha` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rx_rangos`
--

INSERT INTO `rx_rangos` (`id`, `rango_verde_min`, `rango_verde_max`, `rango_naranja_min`, `rango_naranja_max`, `rango_rojo_min`, `rango_rojo_max`, `fecha`) VALUES (12,-20.99,-10.4,-26,-21.8,-30,-27.5,'2025-10-21 22:10:28');

--
-- Table structure for table `ui_estilos`
--

CREATE TABLE `ui_estilos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `color_primario` varchar(20) DEFAULT '#4067a0',
  `color_secundario` varchar(20) DEFAULT '#0d6efd',
  `altura_header` int(11) DEFAULT 72,
  `color_fondo` varchar(20) DEFAULT '#ffffff',
  `color_menu` varchar(20) DEFAULT '#4067a0',
  `color_footer` varchar(20) DEFAULT '#f5f7fb',
  `color_text_footer` varchar(20) DEFAULT '#333333',
  `color_header` varchar(20) DEFAULT '#4067a0',
  `color_text_header` varchar(20) DEFAULT '#ffffff',
  `color_text_menu` varchar(20) DEFAULT '#ffffff',
  `fecha` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ui_estilos`
--

INSERT INTO `ui_estilos` (`id`, `color_primario`, `color_secundario`, `altura_header`, `color_fondo`, `color_menu`, `color_footer`, `color_text_footer`, `color_header`, `color_text_header`, `color_text_menu`, `fecha`) VALUES (1,'#3d66a4','#1ac7ea',79,'#ffffff','#1d2b53','#f5f7fb','#333333','#4067a0','#ffffff','#ffffff','2025-10-27 19:25:30'),(2,'#3d66a4','#1ac7ea',79,'#ffffff','#1d2b53','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-27 19:48:50'),(3,'#3d66a4','#1ac7ea',97,'#ffffff','#1d2b53','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-27 19:49:11'),(4,'#3d66a4','#1ac7ea',75,'#ffffff','#1d2b53','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-27 19:49:23'),(5,'#3d66a4','#1ac7ea',75,'#ffffff','#4b66af','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-27 19:50:45'),(6,'#3d66a4','#1ac7ea',75,'#ffffff','#4b66af','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-27 20:02:00'),(7,'#00acac','#1ac7ea',75,'#ffffff','#00acac','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-27 20:51:43'),(8,'#00acac','#1ac7ea',88,'#ffffff','#00acac','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-27 20:52:03'),(9,'#00acac','#1ac7ea',75,'#ffffff','#00acac','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-27 20:52:21'),(10,'#00acac','#1ac7ea',75,'#ffffff','#02485f','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-28 17:25:33'),(11,'#00acac','#1ac7ea',75,'#ffffff','#032235','#f5f7fb','#333333','#ffffff','#1d2b53','#ffffff','2025-10-28 17:27:03'),(12,'#2397cf','#10abf9',75,'#ffffff','#112646','#f5f7fb','#333333','#ffffff','#112646','#ffffff','2025-11-11 03:07:34'),(13,'#2397cf','#10abf9',75,'#ffffff','#112646','#f5f7fb','#333333','#ffffff','#112646','#ffffff','2025-11-11 03:08:46'),(14,'#2397cf','#10abf9',75,'#ffffff','#112646','#f5f7fb','#333333','#ffffff','#112646','#ffffff','2025-11-11 03:54:32'),(15,'#2397cf','#10abf9',75,'#ffffff','#112646','#f5f7fb','#333333','#ffffff','#112646','#ffffff','2025-11-11 03:56:14');

--
-- Table structure for table `zonas`
--

CREATE TABLE `zonas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  `imagen` varchar(255) DEFAULT NULL,
  `fecha` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `zonas`
--

INSERT INTO `zonas` (`id`, `nombre`, `descripcion`, `imagen`, `fecha`) VALUES (2,'TILOS','IPN - BLAIR - BOSQUES','','2025-10-21 21:51:08'),(3,'CEIBAS','CERCA - GASOLINERA - COPPEL','','2025-10-21 21:53:35');

--
-- Dumping events for database 'mania_olt'
--

--
-- Dumping routines for database 'mania_olt'
--


