
--
-- Table structure for table `ci_revision_lazos`
--

CREATE TABLE `ci_revision_lazos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_central` bigint(20) unsigned NOT NULL,
  `numero` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_lazo_per_central` (`id_central`,`numero`),
  CONSTRAINT `ci_revision_lazos_id_central_foreign` FOREIGN KEY (`id_central`) REFERENCES `ci_revision_centrales` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ci_revision_lazos`
--

INSERT INTO `ci_revision_lazos` VALUES (1,1,1,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(2,1,2,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(3,1,3,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(4,1,4,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(5,1,5,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(6,1,6,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(7,1,7,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(8,1,8,'2025-09-24 05:03:45','2025-09-24 05:03:45'),(9,2,1,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(10,2,2,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(11,2,3,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(12,2,4,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(13,2,6,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(14,2,7,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(15,2,8,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(16,2,5,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(17,3,1,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(18,3,2,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(19,3,3,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(20,3,4,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(21,3,5,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(22,3,6,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(23,4,1,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(24,4,2,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(25,4,3,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(26,4,4,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(27,4,5,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(28,4,6,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(29,4,7,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(30,5,1,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(31,5,2,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(32,5,3,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(33,5,4,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(34,5,5,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(35,6,1,'2025-10-08 05:55:49','2025-10-08 05:55:49'),(36,6,2,'2025-10-08 05:55:49','2025-10-08 05:55:49'),(37,6,3,'2025-10-08 05:55:49','2025-10-08 05:55:49'),(38,6,4,'2025-10-08 05:55:49','2025-10-08 05:55:49'),(39,6,5,'2025-10-08 05:55:49','2025-10-08 05:55:49'),(40,6,7,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(41,6,6,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(42,7,1,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(43,7,2,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(44,7,3,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(45,7,4,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(46,8,1,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(47,8,2,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(48,8,4,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(49,8,3,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(50,8,5,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(51,9,1,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(52,9,2,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(53,10,1,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(54,10,3,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(55,10,2,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(56,11,1,'2025-10-16 13:25:32','2025-10-16 13:25:32'),(57,12,1,'2025-10-17 05:40:14','2025-10-17 05:40:14'),(58,12,2,'2025-10-17 05:40:14','2025-10-17 05:40:14'),(59,12,4,'2025-10-17 05:40:14','2025-10-17 05:40:14'),(60,12,7,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(61,12,3,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(62,12,5,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(63,12,6,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(64,13,1,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(65,13,2,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(66,13,3,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(67,13,4,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(68,13,5,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(69,13,6,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(70,13,7,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(73,16,8,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(74,16,1,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(75,16,2,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(76,16,3,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(77,16,4,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(78,16,5,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(79,16,6,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(80,16,7,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(81,17,1,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(82,17,2,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(83,17,3,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(84,17,4,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(85,17,5,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(86,18,1,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(87,18,2,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(88,18,3,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(89,18,4,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(90,18,5,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(94,20,1,'2025-10-30 14:54:00','2025-10-30 14:54:00'),(95,20,2,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(96,20,3,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(97,21,6,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(98,21,5,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(99,21,4,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(100,21,3,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(101,21,1,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(102,21,2,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(103,21,8,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(104,21,7,'2025-12-04 11:23:44','2025-12-04 11:23:44');

--
-- Table structure for table `ci_revision_tipo_elementos`
--

CREATE TABLE `ci_revision_tipo_elementos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tipo` int(11) NOT NULL,
  `abreviatura` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `nombre_largo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ci_revision_tipo_elementos`
--

INSERT INTO `ci_revision_tipo_elementos` VALUES (1,1,'OPTI','Óptico','S. Óptico'),(2,1,'TER','Térmico','S. Térmico'),(3,1,'MULT','Multi','S. Multi'),(4,1,'SMART 4','Smart 4','Smart 4 S.'),(5,2,'PUL','Pulsador','PUL de Ala'),(6,2,'SIRE','Sirena','SIRENA'),(7,2,'MON','Monitor','M. Monitor'),(8,2,'CON','Controlador','M. de Cont'),(9,2,'AUX','Auxiliar','M. Entr. A'),(10,2,'ASPR','Sprinkler Int','M. int. Si'),(11,2,'SPRK','Sprinkler','M. Sprinkl'),(12,2,'ZMX','Zona','M. Zona'),(13,2,'CDI','CDI','CDI'),(14,2,'BOOSTER','Booster','BOOSTER');

--
-- Table structure for table `ci_revision_zonas`
--

CREATE TABLE `ci_revision_zonas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `central_id` bigint(20) unsigned NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `numero` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ci_revision_zonas_central_id_numero_unique` (`central_id`,`numero`),
  KEY `ci_revision_zonas_central_id_index` (`central_id`),
  KEY `ci_revision_zonas_central_id_numero_index` (`central_id`,`numero`),
  CONSTRAINT `ci_revision_zonas_central_id_foreign` FOREIGN KEY (`central_id`) REFERENCES `ci_revision_centrales` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=378 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ci_revision_zonas`
--

INSERT INTO `ci_revision_zonas` VALUES (1,1,'Bloque grande planta 7',2,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(2,1,'Bloque grande planta 6',3,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(3,1,'Bloque grande planta 5',4,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(4,1,'Bloque grande planta 4',5,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(5,1,'Bloque grande planta 3',6,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(6,1,'Bloque grande planta 2',7,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(7,1,'Bloque grande planta 1',8,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(8,1,'Bloque pequeño azotea',9,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(9,1,'Bloque pequeño planta 6',10,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(10,1,'Bloque pequeño planta 5',11,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(11,1,'Bloque pequeño planta 4',12,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(12,1,'Bloque pequeño planta 3',13,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(13,1,'Bloque pequeño planta 2',14,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(14,1,'Bloque pequeño planta 1',15,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(15,1,'Recepción',16,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(16,1,'Comedor de clientes',17,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(17,1,'Cocina',18,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(18,1,'Bar salón',19,'2025-09-24 05:03:44','2025-09-24 05:03:44'),(19,1,'Piscina Exterior',20,'2025-09-24 05:03:45','2025-09-24 05:03:45'),(20,1,'Spa',21,'2025-09-24 05:03:45','2025-09-24 05:03:45'),(21,1,'Sótano',22,'2025-09-24 05:03:45','2025-09-24 05:03:45'),(22,1,'Parking golf',23,'2025-09-24 05:03:45','2025-09-24 05:03:45'),(23,1,'Puertas RF',24,'2025-09-24 05:03:45','2025-09-24 05:03:45'),(24,2,'Azotea Bloque Verano',1,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(25,2,'Planta 7 Verano',2,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(26,2,'Planta 6 Verano',3,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(27,2,'Planta 5 Verano',4,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(28,2,'Planta 4 Verano',5,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(29,2,'Planta 3 Verano',6,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(30,2,'Planta 2 Verano',7,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(31,2,'Planta 1 Verano',8,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(32,2,'Azotea Bloque Invierno',9,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(33,2,'Planta 6 Invierno',10,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(34,2,'Planta 5 Invierno',11,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(35,2,'Planta 4 Invierno',12,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(36,2,'Planta 3 Invierno',13,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(37,2,'Planta 2 Invierno',14,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(38,2,'Planta 1 Invierno',15,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(39,2,'Comedor Clientes',17,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(40,2,'Bar Salón',18,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(41,2,'Recepción',19,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(42,2,'Cocina',20,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(43,2,'Sótano',21,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(44,2,'Guarderías',22,'2025-09-24 13:20:00','2025-09-24 13:20:00'),(45,2,'Piscina Climatizada',23,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(46,2,'Control Puertas',24,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(47,2,'Planta Baja Personal',26,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(48,2,'Planta Técnica',28,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(49,2,'Hall Ascensores Planta 7',29,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(50,2,'Hall Ascensores Planta 6',30,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(51,2,'Hall Ascensores Planta 5',31,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(52,2,'Hall Ascensores Planta 4',32,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(53,2,'Hall Ascensores Planta 3',33,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(54,2,'Hall Ascensores Planta 2',34,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(55,2,'Hall Planta 1',35,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(56,2,'Sótano Pizzería',36,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(57,2,'Pizzería',37,'2025-09-24 13:20:01','2025-09-24 13:20:01'),(58,3,'Sala de Máquinas Azotea',1,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(59,3,'Planta 6',2,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(60,3,'Planta 5',3,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(61,3,'Planta 4',4,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(62,3,'Planta 3',5,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(63,3,'Planta 2',6,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(64,3,'Planta 1',7,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(65,3,'Recepción',8,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(66,3,'Bar Salón',9,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(67,3,'Salón Polivalente',10,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(68,3,'Piscina Exterior',11,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(69,3,'Sótano Zona de Personal',12,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(70,3,'Cocina',13,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(71,3,'Spa',14,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(72,3,'Comedor Clientes',15,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(73,3,'Piscina Interior',16,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(74,3,'Distribuidor Comedor y SPA',17,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(75,3,'Escalera Servicio Pisos',18,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(76,3,'Oficce Recepción',19,'2025-09-25 10:51:15','2025-09-25 10:51:15'),(77,4,'Actvación Sirenas Mimosa 1',1,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(78,4,'Actvación Sirenas Mimosa 2',2,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(79,4,'Actvación Sirenas Jazmines',3,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(80,4,'Actvación Sirenas Buganvilla',4,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(81,4,'Actvación Sirenas Anexo',5,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(82,4,'Actvación Sirenas Conferencias',6,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(83,4,'Buganvilla Planta 3 Izquierda',7,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(84,4,'Buganvilla Planta 2 Izquierda',8,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(85,4,'Buganvilla Planta 3 Derecha',9,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(86,4,'Buganvilla Azotea',10,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(87,4,'Buganvilla Planta 2 Derecha',11,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(88,4,'Buganvilla Planta 1 Izquierda',12,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(89,4,'Buganvilla Planta Baja Izquierda',13,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(90,4,'Buganvilla Oficinas',14,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(91,4,'Buganvilla Planta 1 Derecha',15,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(92,4,'Buganvilla Recepción',16,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(93,4,'Buganvilla Planta Noble',17,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(94,4,'Buganvilla Cocina',18,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(95,4,'Buganvilla Animación',19,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(96,4,'Buganvilla Sótano',20,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(97,4,'Buganvilla SPA',21,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(98,4,'Anexo Planta Baja',22,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(99,4,'Anexo Planta 1',23,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(100,4,'Anexo Planta 2',24,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(101,4,'Anexo Planta 3',25,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(102,4,'Anexo Azotea',26,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(103,4,'Pool Bar',27,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(104,4,'Miniland',28,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(105,4,'Gimnasio y fitness',29,'2025-10-02 08:06:22','2025-10-02 08:06:22'),(106,5,'Mimosa 1 Planta 2',2,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(107,5,'Mimosa 1 Planta 1',3,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(108,5,'Mimosa 1 Planta Baja',4,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(109,5,'Mimosa Sótano',5,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(110,5,'Mimosa 1 Tasca',6,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(111,5,'Mimosa 2 Planta 2',7,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(112,5,'Mimosa 2 Planta 1',8,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(113,5,'Mimosa 2 Planta Baja',9,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(114,5,'Jazmín 1 Azotea',10,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(115,5,'Jazmín 1 Planta 2',11,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(116,5,'Jazmín 1 Planta 1',12,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(117,5,'Jazmín 1 Planta Baja',13,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(118,5,'Mimosa 1 Puertas RF',17,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(119,5,'Mimosa 2 Puertas RF',18,'2025-10-03 06:35:44','2025-10-03 06:35:44'),(120,6,'Planta 1',1,'2025-10-08 05:55:49','2025-10-08 05:55:49'),(121,6,'Planta 2',2,'2025-10-08 05:55:49','2025-10-08 05:55:49'),(122,6,'Planta 3',3,'2025-10-08 05:55:49','2025-10-08 05:55:49'),(123,6,'Planta 4',4,'2025-10-08 05:55:49','2025-10-08 05:55:49'),(124,6,'Planta 5',5,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(125,6,'Planta 6',6,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(126,6,'Economato',7,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(127,6,'Anexo - Restaurantes',8,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(128,6,'Anexo - Planta 1',9,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(129,6,'Anexo - Planta 2',10,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(130,6,'Azotea Edificio principal',11,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(131,6,'Informacion',12,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(132,6,'Comedor Clientes',13,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(133,6,'Cocina',14,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(134,6,'Zona Pastelería',15,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(135,6,'Bar Salón',16,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(136,6,'Sótano',17,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(137,6,'Sótano - Anexo',18,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(138,6,'Puertas RF Hotel',20,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(139,6,'Zona Dirección',22,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(140,6,'Sótano - Bomba C.I. Principal',23,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(141,6,'Sótano - Bomba C.I. Apoyo Diesel',24,'2025-10-08 05:55:50','2025-10-08 05:55:50'),(142,7,'Planta -1 Botánico',1,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(143,7,'Planta 0 Botánico',2,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(144,7,'Planta 1',3,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(145,7,'Planta 2',4,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(146,7,'Planta 3',5,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(147,7,'Planta 4',6,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(148,7,'Planta 5',7,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(149,7,'Planta 6',8,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(150,7,'Recepción',9,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(151,7,'SPA',10,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(152,7,'Pasillo Trasera Spa',11,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(153,7,'No definida',13,'2025-10-08 05:56:23','2025-10-08 05:56:23'),(154,8,'Bloque 1',1,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(155,8,'Bloque 2',2,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(156,8,'Bloque 3',3,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(157,8,'Bloque 3 Sótano',4,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(158,8,'Bloque 4',5,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(159,8,'Bloque 5',6,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(160,8,'Bloque 6',7,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(161,8,'Bloque 7',8,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(162,8,'Bloque 8',9,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(163,8,'Bloque 9',10,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(164,8,'Bloque 10',11,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(165,8,'Bloque 11',12,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(166,8,'Bloque 12',13,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(167,8,'Bloque 13',14,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(168,8,'Sótano Personal',16,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(169,8,'Recepción',17,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(170,8,'Comedor-Bar',18,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(171,8,'Cocina',19,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(172,8,'Exteriores Planta Noble',20,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(173,8,'Apartamentos Garden',21,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(174,8,'Bloque 0 Azotea',22,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(175,8,'Bloque 0 Planta 2',23,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(176,8,'Bloque 0 Planta 1',24,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(177,8,'Bloque 0 Planta 0',25,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(178,8,'Bloque 0 Spa',26,'2025-10-14 15:05:40','2025-10-14 15:05:40'),(179,9,'Bloque 14',1,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(180,9,'Bloque 15',2,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(181,9,'Bloque 16',3,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(182,9,'Bloque 17',4,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(183,9,'Bloque 18',5,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(184,9,'Bloque 19',6,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(185,9,'Bloque 20',7,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(186,9,'Bloques 14 a 20',8,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(187,9,'Lavandería',9,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(188,9,'Sótano Bloque 18',10,'2025-10-14 15:06:07','2025-10-14 15:06:07'),(189,10,'Bloque 21',1,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(190,10,'Bar Piscina Garden',2,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(191,10,'La Finca Restaurante',3,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(192,10,'La Finca Cocina',4,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(193,10,'Bloque 22',5,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(194,10,'Bloque 22 Sotano y Alternadora',6,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(195,10,'Bloque 23',7,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(196,10,'Bloque 24',8,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(197,10,'Guardería Garden',9,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(198,10,'Comedor Mallorca',10,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(199,10,'Cocina Mallorca',11,'2025-10-14 15:06:58','2025-10-14 15:06:58'),(200,11,'Sótano',1,'2025-10-16 13:25:32','2025-10-16 13:25:32'),(201,11,'Planta Baja',2,'2025-10-16 13:25:32','2025-10-16 13:25:32'),(202,11,'Planta Piso',3,'2025-10-16 13:25:32','2025-10-16 13:25:32'),(203,11,'Azotea',4,'2025-10-16 13:25:32','2025-10-16 13:25:32'),(204,11,'Sirenas',5,'2025-10-16 13:25:32','2025-10-16 13:25:32'),(205,12,'Azotea',1,'2025-10-17 05:40:14','2025-10-17 05:40:14'),(206,12,'Planta 7',2,'2025-10-17 05:40:14','2025-10-17 05:40:14'),(207,12,'Planta 6',3,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(208,12,'Planta 5',4,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(209,12,'Planta 4',5,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(210,12,'Planta 3',6,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(211,12,'Planta 2',7,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(212,12,'Planta 1',8,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(213,12,'Oficinas',9,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(214,12,'Zona Comercial',10,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(215,12,'Recepción',11,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(216,12,'Cocina',12,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(217,12,'Comedor',13,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(218,12,'Bar Salón',14,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(219,12,'Distribuidor Planta -1',15,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(220,12,'Salones',16,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(221,12,'Piscina Cubierta',17,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(222,12,'Talasoterapia',18,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(223,12,'Sótano',19,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(224,12,'Control Puertas',20,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(225,12,'Acceso Rampa Proveedores',21,'2025-10-17 05:40:15','2025-10-17 05:40:15'),(226,13,'Sala espectáculos',1,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(227,13,'Lobby Bar',2,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(228,13,'Hall, office y aseos planta baja',3,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(229,13,'Comedor Coral',4,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(230,13,'Comedor Arena',5,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(231,13,'Hall Comedores',6,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(232,13,'Cocina',7,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(233,13,'Snack bar',8,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(234,13,'Parking',9,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(235,13,'Spa y Masajes',10,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(236,13,'Sótano Zona Lencería',11,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(237,13,'Sótano Zona Economatos',12,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(238,13,'Sótano Zona Servicios Técnicos',13,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(239,13,'Saunas y Gimnasio',14,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(240,13,'Sala Rebombeo',15,'2025-10-21 05:58:47','2025-10-21 05:58:47'),(243,16,'Recepción',10,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(244,16,'Planta 1 Bloque 1',11,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(245,16,'Planta 2 Bloque 1',12,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(246,16,'Planta 3 Bloque 1',13,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(247,16,'Planta 4¬ bloque 1',14,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(248,16,'Planta 5¬ bloque 1',15,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(249,16,'Planta 6¬ bloque 1',16,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(250,16,'Cubierta Bloque 1',17,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(251,16,'Planta 1 Bloque 2',21,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(252,16,'Planta 2 Bloque 2',22,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(253,16,'Planta 3 Bloque 2',23,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(254,16,'Planta 4¬ bloque 2',24,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(255,16,'Planta 5¬ bloque 2',25,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(256,16,'Planta 6¬ bloque 2',26,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(257,16,'Cubierta bloque 2',27,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(258,16,'Planta 1¬ bloque 3-4',31,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(259,16,'Planta 2¬ bloque 3-4',32,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(260,16,'Planta 3¬ bloque 3-4',33,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(261,16,'Planta 4¬ bloque 3-4',34,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(262,16,'Planta 5¬ bloque 3-4',35,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(263,16,'Planta 6¬ bloque 3-4',36,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(264,16,'Cubierta bloque 3-4',37,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(265,16,'Planta 1¬ bloque 5',51,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(266,16,'Planta 2¬ bloque 5',52,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(267,16,'Planta 3¬ bloque 5',53,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(268,16,'Planta 4¬ bloque 5',54,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(269,16,'Planta 5¬ bloque 5',55,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(270,16,'Planta 6¬ bloque 5',56,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(271,16,'Cubierta bloque 5',57,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(272,16,'Planta 1¬ bloque 7',71,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(273,16,'Planta 2¬ bloque 7',72,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(274,16,'Planta 3¬ bloque 7',73,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(275,16,'Planta 4¬ bloque 7',74,'2025-10-21 06:19:26','2025-10-21 06:19:26'),(276,16,'Planta 5¬ bloque 7',75,'2025-10-21 06:19:27','2025-10-21 06:19:27'),(277,16,'Planta 6¬ bloque 7',76,'2025-10-21 06:19:27','2025-10-21 06:19:27'),(278,17,'Hall Planta Baja',1,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(279,17,'Sala Espectáculos',2,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(280,17,'Lobby Bar',3,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(281,17,'Hall Puertas Comedores y Aseos',4,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(282,17,'Comedores',5,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(283,17,'Cocina',6,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(284,17,'Buffets Comedores',7,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(285,17,'Snack',8,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(286,17,'Parking',9,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(287,17,'Sótano Personal',10,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(288,17,'Sótano Clientes',11,'2025-10-23 11:04:46','2025-10-23 11:04:46'),(289,18,'Planta 1',1,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(290,18,'Planta 2 ala Spa y Hall',2,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(291,18,'Planta 3 ala Spa y Hall',3,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(292,18,'Planta 4 ala Spa y Hall',4,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(293,18,'Planta 5 ala Spa y Hall',5,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(294,18,'Planta 6 ala Spa y Hall',6,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(295,18,'Hall Planta 7 y Chillout',7,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(296,18,'Oficios plantas 2 a 7',8,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(297,18,'Planta 2 ala convenciones',9,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(298,18,'Planta 3 ala convenciones',10,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(299,18,'Planta 4 ala convenciones',11,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(300,18,'Planta 5 ala convenciones',12,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(301,18,'Planta 6 ala convenciones',13,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(302,18,'Planta 7 ala convenciones',14,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(303,18,'Cubierta A',15,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(304,18,'Azotea',16,'2025-10-23 11:11:09','2025-10-23 11:11:09'),(323,20,'Sótano',1,'2025-10-30 14:54:00','2025-10-30 14:54:00'),(324,20,'Planta Baja',2,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(325,20,'Calderas',3,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(326,20,'Grupos Electrógenos',4,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(327,20,'Grupo Agua Nebulizada',5,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(328,20,'Grupo Principal Bies',6,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(329,20,'Grupo Apoyo Bies',7,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(330,20,'Patinillo Conveciones',8,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(331,20,'Extinción Calderas',9,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(332,20,'Extinción Grupos',10,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(333,20,'Sala Tramontana',11,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(334,20,'Sala Poniente',12,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(335,20,'Sala Siroco',13,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(336,20,'Sala Mistral',14,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(337,20,'Distribuidor Salas',15,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(338,20,'Zona Bar Conferencias',16,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(339,20,'Baños Conferencias',17,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(340,20,'Falso Techo Salas Grandes',18,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(341,20,'Cocina',19,'2025-10-30 14:54:01','2025-10-30 14:54:01'),(342,21,'Bloque 1 Planta 1',2,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(343,21,'Bloque 1 Planta 2',3,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(344,21,'Bloque 1 Planta 3',4,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(345,21,'Bloque 1 Planta 4',5,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(346,21,'Bloque 1 Planta 5',6,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(347,21,'Bloque 1 Planta 6',7,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(348,21,'Sala Calderas',8,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(349,21,'Recepción',9,'2025-12-04 11:23:43','2025-12-04 11:23:43'),(350,21,'Pasillo Guías',10,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(351,21,'Bar Salón',11,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(352,21,'Salón Tranquilo',12,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(353,21,'Spa',13,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(354,21,'Comedor Clientes',14,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(355,21,'Cocina',15,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(356,21,'Grupo Electrógeno',16,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(357,21,'Bloque 2 Planta 1',17,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(358,21,'Bloque 2 Planta 2',18,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(359,21,'Bloque 2 Planta 3',19,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(360,21,'Módulo Control Puertas Bl. 1 y 2',20,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(361,21,'Módulo Control Puertas  Bloque 3',21,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(362,21,'Bloque 3 Planta Baja',22,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(363,21,'Bloque 3 Planta 1',23,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(364,21,'Bloque 3 Planta 2',24,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(365,21,'Bloque 3 Planta 3',25,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(366,21,'Bloque 3 Planta 4',26,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(367,21,'Bloque 3 Planta 5',27,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(368,21,'Bloque 3 Planta 6',28,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(369,21,'Sótano',29,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(370,21,'Bloque 3 Ático',31,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(371,21,'Paso Clientes Bloque 3',34,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(372,21,'Animación Exterior',35,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(373,21,'Módulo Sirenas Bloques 1 y 2',36,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(374,21,'Módulo Sirenas Bloque 3',37,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(375,21,'Módulo Sirenas Bloques 1 y 2',38,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(376,21,'Módulo 721 Retenedores',39,'2025-12-04 11:23:44','2025-12-04 11:23:44'),(377,21,'Sotano - Grupo Contra Incendios',42,'2025-12-04 11:23:44','2025-12-04 11:23:44');

--
-- Table structure for table `dispositivos`
--

CREATE TABLE `dispositivos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `mac` varchar(255) NOT NULL,
  `lugar_id` bigint(20) unsigned NOT NULL,
  `identificador` varchar(255) NOT NULL,
  `estado` tinyint(1) NOT NULL DEFAULT 0,
  `ultima_vez` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dispositivos_mac_unique` (`mac`),
  UNIQUE KEY `dispositivos_identificador_unique` (`identificador`),
  KEY `dispositivos_lugar_id_foreign` (`lugar_id`),
  CONSTRAINT `dispositivos_lugar_id_foreign` FOREIGN KEY (`lugar_id`) REFERENCES `lugares` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dispositivos`
--


--
-- Table structure for table `lugares`
--

CREATE TABLE `lugares` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `direccion` varchar(255) NOT NULL,
  `poblacion` varchar(255) NOT NULL,
  `codigo_postal` varchar(255) NOT NULL,
  `provincia` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `latitud` decimal(10,8) NOT NULL,
  `longitud` decimal(11,8) NOT NULL,
  `horario` varchar(255) DEFAULT NULL,
  `telefono` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `sitio_web` varchar(255) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  `estado` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lugares`
--

INSERT INTO `lugares` VALUES (1,'Flamenco','Avda. Sa Coma, 13','Cala Millor','07560','9','33',39.59241657,3.38362008,'','971585312','flamenco@hipotels.com','https://www.hipotels.com/hoteles/flamenco/','',1,NULL,NULL),(2,'Hipotels Gran Playa de Palma','Carrer de las Canyes, S/N','Playa de Palma','07600','9','33',39.51517410,2.75614080,'Abierto las 24 horas','971 268 045','granplayadepalma@hipotels.com','https://www.hipotels.com/hoteles/gran-playa-de-palma/','Un hotel de lujo frente a la playa con instalaciones de primera clase.',1,NULL,'2025-10-21 05:55:40'),(3,'Hipotels Bahia Cala Millor','Carrer des Pinar, 21','Cala Millor','07560','9','33',39.59191500,3.39874200,'Abierto todo el año','971585820','bahia@hipotels.com','https://www.hipotels.com/hoteles/bahia-cala-millor/','Un hotel familiar con vistas al mar y una amplia oferta de actividades para todos los gustos.',1,NULL,NULL),(4,'Hipotels Said','Carrer de Costa i Llobera, 3','Puerto de Alcudia','07400','9','33',39.83985300,3.12175800,'De 08:00 a 22:00','971892029','said@hipotels.com','https://www.hipotels.com/hoteles/said/','Situado en el norte de Mallorca, este hotel está diseñado para parejas y viajeros que buscan relax.',1,NULL,NULL),(5,'Hipotels Dunas','Avinguda de la Playa, 12','Son Servera','07550','9','33',39.58041200,3.38827400,'De 09:00 a 21:00','971583327','dunas@hipotels.com','https://www.hipotels.com/hoteles/dunas/','Un lugar ideal para disfrutar de la tranquilidad en un entorno natural cerca del mar.',1,NULL,NULL),(6,'Hipotels Bahía Grande','C/ Castell, 1','Cala Millor','07560','9','33',39.58772531,3.38386953,NULL,'971586411',NULL,'https://www.hipotels.com/hoteles/bahiagrande/',NULL,1,'2025-09-24 05:01:08','2025-09-24 05:01:08'),(7,'Hipotels Coma Gran','Cards, s/n','Sa Coma','07560','9','33',39.57699988,3.37517204,NULL,'971810179',NULL,'https://www.hipotels.com/hoteles/comagran/',NULL,1,'2025-09-24 13:18:04','2025-09-24 13:18:04'),(8,'Hipotels Hipocampo Playa','Avda. Sa Coma, 45','Cala Millor','07560','9','33',39.58936989,3.38438451,NULL,'971585262',NULL,'https://www.hipotels.com/hoteles/hipocampoplaya/',NULL,1,'2025-09-25 10:49:26','2025-09-25 10:49:26'),(9,'Sunwing Bouganvilla','Carretera Costa de los Pinos s/n','Cala Bona','07559','9','33',39.61984128,3.39113816,NULL,'971814099',NULL,'hipotels.com',NULL,1,'2025-10-02 08:04:56','2025-10-02 08:04:56'),(10,'Sunwing Mimosa-Jazmin','Carretera Costa de los Pinos s/n','Cala Bona','07559','9','33',39.61785781,3.39098811,NULL,'971814099',NULL,'hipotels.com',NULL,1,'2025-10-03 06:33:32','2025-10-03 06:33:32'),(11,'Hotel Mediterraneo','Avenida Ses Savines, s/n','Sa Coma','07560','9','33',39.57150952,3.37408483,NULL,'971 810 105',NULL,'https://www.hipotels.com/hoteles/mediterraneo/',NULL,1,'2025-10-08 05:37:58','2025-10-08 05:37:58'),(12,'Hipotels Mediterráneo Club','Avenida Ses Savines, S/N','Sa Coma','07560','9','33',39.57350182,3.37480715,NULL,'971810071',NULL,'https://www.hipotels.com/hoteles/mediterraneoclub/',NULL,1,'2025-10-14 15:02:27','2025-10-14 15:02:27'),(13,'Oficinas Hipotels','Carrer Estanyol, 18','Cala Millor','07560','9','33',39.58927635,3.38164061,NULL,'971587512','info@hipotels.com','https://www.hipotels.com/',NULL,1,'2025-10-16 13:23:33','2025-10-16 21:18:11'),(14,'Hipotels Eurotel Punta Rotja','Avda. del Pinar s/n','Costa de los Pinos','07559','9','33',1.00000000,1.00000000,NULL,'971816500','eurotel@hipotels.com','https://www.hipotels.com/hoteles/eurotelpuntarotja/',NULL,1,'2025-10-17 05:38:44','2025-10-17 05:38:44'),(15,'Gran Playa de Palma Palace','Carrer de las Canyes','Palma','07600','9','33',39.51517410,2.75614080,NULL,'971 268 045','granplayadepalma@hipotels.com',NULL,NULL,1,'2025-10-21 05:54:44','2025-10-21 05:54:44'),(16,'Hipotels Convention Centre','Carrer de las Canyes, S/N','Palma','07600','9','33',39.51517410,2.75614080,NULL,'971 58 75 12','granplayadepalma@hipotels.com',NULL,NULL,1,'2025-10-21 05:57:17','2025-10-21 05:57:17'),(17,'Cala Millor Park','Estanyol 1','Cala Millor','07560','9','33',39.59360098,3.38185072,NULL,'971813616','calamillorpark@hipotels.com','https://www.hipotels.com/hoteles/calamillorpark',NULL,1,'2025-12-04 11:10:41','2025-12-04 11:10:41');

--
-- Table structure for table `materiales`
--

CREATE TABLE `materiales` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `descripcion` text DEFAULT NULL,
  `categoria_id` bigint(20) unsigned NOT NULL,
  `codigo_sku` varchar(255) NOT NULL,
  `unidad_medida` varchar(255) NOT NULL,
  `cantidad_stock` int(11) NOT NULL DEFAULT 0,
  `cantidad_minima` int(11) NOT NULL DEFAULT 0,
  `precio_compra` decimal(8,2) NOT NULL,
  `precio_venta` decimal(8,2) DEFAULT NULL,
  `proveedor_id` bigint(20) unsigned DEFAULT NULL,
  `ubicacion_almacen` varchar(255) DEFAULT NULL,
  `fecha_entrada` date NOT NULL,
  `estado` enum('disponible','pendiente','agotado') NOT NULL DEFAULT 'disponible',
  `fecha_vencimiento` date DEFAULT NULL,
  `observaciones` text DEFAULT NULL,
  `imagen` varchar(255) DEFAULT NULL,
  `numero_lote` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `materiales_codigo_sku_unique` (`codigo_sku`),
  KEY `materiales_categoria_id_foreign` (`categoria_id`),
  KEY `materiales_proveedor_id_foreign` (`proveedor_id`),
  KEY `materiales_user_id_foreign` (`user_id`),
  CONSTRAINT `materiales_categoria_id_foreign` FOREIGN KEY (`categoria_id`) REFERENCES `categorias` (`id`) ON DELETE CASCADE,
  CONSTRAINT `materiales_proveedor_id_foreign` FOREIGN KEY (`proveedor_id`) REFERENCES `proveedores` (`id`) ON DELETE SET NULL,
  CONSTRAINT `materiales_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `materiales`
--


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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'0000_01_01_000000_create_users_table',1),(2,'2024_01_01_000001_create_templates_table',1),(3,'2024_01_01_000002_create_template_variables_table',1),(4,'2024_01_01_000003_create_template_responses_table',1),(5,'2024_10_29_185618_create_materiales_proveedores_categorias_table',1),(6,'2024_10_30_201046_create_role_user_table',1),(7,'2024_11_01_160641_create_ci_revision_central_tables',1),(8,'2024_11_02_151151_create_lugares_table',1),(9,'2024_11_07_203325_create_fichajes_table',1),(10,'2024_11_11_170312_create_dispositivos_table',1),(11,'2024_11_22_172237_create_trabajo_horas_trabajador_table',1),(12,'2024_12_16_180534_create_trabajo_registro_table',1),(13,'2025_08_26_185218_create_trabajo_registros_diarios_table',1),(14,'2025_08_26_185224_create_trabajo_registros_materiales_table',1),(15,'2025_08_26_202452_create_trabajo_partes_table',1),(16,'2025_08_30_171317_create_ci_elementos_revisados_table',1),(17,'2025_08_30_175020_create_ci_eventos_central_table',1),(18,'2025_08_30_201842_create_cache_table',1);

--
-- Table structure for table `proveedores`
--

CREATE TABLE `proveedores` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `direccion` varchar(255) DEFAULT NULL,
  `telefono` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `tipo_documento` varchar(255) NOT NULL,
  `numero_documento` varchar(255) NOT NULL,
  `descripcion` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `proveedores_numero_documento_unique` (`numero_documento`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `proveedores`
--


--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `role_user_user_id_foreign` (`user_id`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` VALUES (1,1,1,'2025-09-23 19:53:43','2025-09-23 19:53:43');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'admin','2025-09-23 19:53:43','2025-09-23 19:53:43'),(2,'user','2025-09-23 19:53:43','2025-09-23 19:53:43'),(3,'verificador','2025-09-23 19:53:43','2025-09-23 19:53:43'),(4,'trabajador','2025-09-23 19:53:43','2025-09-23 19:53:43'),(5,'contra-incendios','2025-09-23 19:53:43','2025-09-23 19:53:43');

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

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sessions` VALUES ('23RGqAgsOmSWsQoCdwTJVrKqVeGRPqZX6Z5VsNVu',NULL,'198.235.24.185','Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity','YTozOntzOjY6Il90b2tlbiI7czo0MDoidzVvdXh0SGVmMkV6NmtYZ1FnQlhJM2w0c2dBZ0g3dnB5R2V2aGxTbyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vc2l0ZWxlYy1pYi5kZG5zLm5ldC9pbmljaWFyLXNlc2lvbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1776006119),('77uXJGV250ouP1rtpGuJBZET4hGkrQO9ykeFGXbj',NULL,'81.29.142.100','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 YaBrowser/21.6.4.694 Yowser/2.5 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoicU10ZENTc3NHeVV1RkFQYnplUXR2MmhGd1JkOW9JcUlBckZNTWY4NyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyNjoiaHR0cDovL3NpdGVsZWMtaWIuZGRucy5uZXQiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyNjoiaHR0cDovL3NpdGVsZWMtaWIuZGRucy5uZXQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1775985693),('B7VKwByVnYxaa8OiiaeaOl0CgUyZD7DfDzLg7dEm',1,'192.168.1.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiZVdiRHA4M3BUNDRDNElWM0J5YjlvZVJuZUttaTNMZ2IxMGNad0dZTiI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQwOiJodHRwczovL3NpdGVsZWMtaWIuZGRucy5uZXQvcGFydGVzL2NyZWFyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1776013795),('DC0ndFHK8WTeEsw5juJgIo6B7gLTQgl5Sg76lyDN',NULL,'81.29.142.100','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36 Edg/90.0.818.49','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidDZSMXJUTlBPNzh0RkplVVZDMWJ6amMxYjZXMHdTY2VOd3REakVOVyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyNzoiaHR0cHM6Ly9zaXRlbGVjLWliLmRkbnMubmV0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vc2l0ZWxlYy1pYi5kZG5zLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1775985680),('H8TahbIaJUt0OQoSRhME2e62KgFT76GIM6HGMR93',NULL,'198.235.24.185','Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity','YTo0OntzOjY6Il90b2tlbiI7czo0MDoicW5PZ0RXQ3VxMGVtZHVPbGFxWmFHcXQwQ1pDbElwWWZCTm1NUUpYQiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyNzoiaHR0cHM6Ly9zaXRlbGVjLWliLmRkbnMubmV0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vc2l0ZWxlYy1pYi5kZG5zLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1776006118),('y1z1WNwW2XvrOTJMcwOZjE2WhpSLVI33FlWUqTwP',NULL,'81.29.142.100','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 YaBrowser/21.6.4.694 Yowser/2.5 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiamJMT2JwcjEwNFQ4bUJqUXZKaG51V2VnTWl3VnhyS1VEYkRrYjRJTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9zaXRlbGVjLWliLmRkbnMubmV0L2luaWNpYXItc2VzaW9uIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1775985694),('z4aVaMMGHvROCIJDoC3pbaoV47B6shTbhxgtGyPU',NULL,'81.29.142.100','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36 Edg/90.0.818.49','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWXNaaDA1TTZIRkw4Z01Pd3lVc0VPbHhrWDhSM3h5Mm90U0VtVzQ5YyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vc2l0ZWxlYy1pYi5kZG5zLm5ldC9pbmljaWFyLXNlc2lvbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1775985681);

--
-- Table structure for table `template_responses`
--

CREATE TABLE `template_responses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `template_id` bigint(20) unsigned NOT NULL,
  `source_type` varchar(255) DEFAULT NULL,
  `source_id` bigint(20) unsigned DEFAULT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`data`)),
  `generated_file_path` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'generated',
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `generated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `template_responses_template_id_generated_at_index` (`template_id`,`generated_at`),
  KEY `template_responses_source_type_source_id_index` (`source_type`,`source_id`),
  KEY `template_responses_user_id_index` (`user_id`),
  CONSTRAINT `template_responses_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `template_responses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `template_responses`
--


--
-- Table structure for table `template_variables`
--

CREATE TABLE `template_variables` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `template_id` bigint(20) unsigned NOT NULL,
  `variable_name` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `type` enum('text','number','date','textarea','select','email','tel') NOT NULL,
  `is_required` tinyint(1) NOT NULL DEFAULT 0,
  `default_value` text DEFAULT NULL,
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`options`)),
  `help_text` text DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `source` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `template_variables_template_id_variable_name_unique` (`template_id`,`variable_name`),
  KEY `template_variables_template_id_order_index` (`template_id`,`order`),
  CONSTRAINT `template_variables_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `template_variables`
--


--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `templates_type_is_active_index` (`type`,`is_active`),
  KEY `templates_module_index` (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `templates`
--


--
-- Table structure for table `trabajo_fichajes`
--

CREATE TABLE `trabajo_fichajes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `tipo_fichaje_id` bigint(20) unsigned NOT NULL,
  `lugar_id` bigint(20) unsigned DEFAULT NULL,
  `tipo_movimiento` enum('entrada','salida','pausa','continuar') NOT NULL DEFAULT 'entrada',
  `fecha_hora` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` enum('correcto','incorrecto') NOT NULL DEFAULT 'correcto',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trabajo_fichajes_user_id_foreign` (`user_id`),
  KEY `trabajo_fichajes_tipo_fichaje_id_foreign` (`tipo_fichaje_id`),
  KEY `trabajo_fichajes_lugar_id_foreign` (`lugar_id`),
  CONSTRAINT `trabajo_fichajes_lugar_id_foreign` FOREIGN KEY (`lugar_id`) REFERENCES `lugares` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_fichajes_tipo_fichaje_id_foreign` FOREIGN KEY (`tipo_fichaje_id`) REFERENCES `trabajo_fichajes_tipos` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trabajo_fichajes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trabajo_fichajes`
--


--
-- Table structure for table `trabajo_fichajes_tipos`
--

CREATE TABLE `trabajo_fichajes_tipos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `tipo_fichaje` enum('Código','Ubicación','QR','NFC','Aplicación') NOT NULL,
  `ubicacion_id` bigint(20) unsigned DEFAULT NULL,
  `codigo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trabajo_fichajes_tipos_user_id_foreign` (`user_id`),
  KEY `trabajo_fichajes_tipos_ubicacion_id_foreign` (`ubicacion_id`),
  CONSTRAINT `trabajo_fichajes_tipos_ubicacion_id_foreign` FOREIGN KEY (`ubicacion_id`) REFERENCES `lugares` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_fichajes_tipos_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trabajo_fichajes_tipos`
--


--
-- Table structure for table `trabajo_horas_trabajador`
--

CREATE TABLE `trabajo_horas_trabajador` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `lunes` int(11) NOT NULL DEFAULT 0,
  `martes` int(11) NOT NULL DEFAULT 0,
  `miercoles` int(11) NOT NULL DEFAULT 0,
  `jueves` int(11) NOT NULL DEFAULT 0,
  `viernes` int(11) NOT NULL DEFAULT 0,
  `horas_semanales` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trabajo_horas_trabajador_user_id_foreign` (`user_id`),
  CONSTRAINT `trabajo_horas_trabajador_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trabajo_horas_trabajador`
--

INSERT INTO `trabajo_horas_trabajador` VALUES (1,1,0,0,0,0,0,0,'2025-10-29 02:04:53','2025-10-29 02:04:53');

--
-- Table structure for table `trabajo_parte_materiales`
--

CREATE TABLE `trabajo_parte_materiales` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trabajo_parte_id` bigint(20) unsigned NOT NULL,
  `material_id` bigint(20) unsigned NOT NULL,
  `cantidad` int(11) NOT NULL,
  `observaciones` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trabajo_parte_materiales_trabajo_parte_id_foreign` (`trabajo_parte_id`),
  KEY `trabajo_parte_materiales_material_id_foreign` (`material_id`),
  CONSTRAINT `trabajo_parte_materiales_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materiales` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trabajo_parte_materiales_trabajo_parte_id_foreign` FOREIGN KEY (`trabajo_parte_id`) REFERENCES `trabajo_partes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trabajo_parte_materiales`
--


--
-- Table structure for table `trabajo_parte_registros`
--

CREATE TABLE `trabajo_parte_registros` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trabajo_parte_id` bigint(20) unsigned NOT NULL,
  `trabajo_registro_diario_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `parte_registro_unique` (`trabajo_parte_id`,`trabajo_registro_diario_id`),
  KEY `trabajo_parte_registros_trabajo_registro_diario_id_foreign` (`trabajo_registro_diario_id`),
  CONSTRAINT `trabajo_parte_registros_trabajo_parte_id_foreign` FOREIGN KEY (`trabajo_parte_id`) REFERENCES `trabajo_partes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trabajo_parte_registros_trabajo_registro_diario_id_foreign` FOREIGN KEY (`trabajo_registro_diario_id`) REFERENCES `trabajo_registros_diarios` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trabajo_parte_registros`
--


--
-- Table structure for table `trabajo_partes`
--

CREATE TABLE `trabajo_partes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lugar_id` bigint(20) unsigned NOT NULL,
  `direccion` varchar(255) NOT NULL,
  `poblacion` varchar(255) NOT NULL,
  `observaciones` text DEFAULT NULL,
  `estado` enum('borrador','finalizado','verificado') NOT NULL DEFAULT 'borrador',
  `creado_por` bigint(20) unsigned NOT NULL,
  `verificado_por` bigint(20) unsigned DEFAULT NULL,
  `fecha_verificacion` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trabajo_partes_lugar_id_foreign` (`lugar_id`),
  KEY `trabajo_partes_creado_por_foreign` (`creado_por`),
  KEY `trabajo_partes_verificado_por_foreign` (`verificado_por`),
  CONSTRAINT `trabajo_partes_creado_por_foreign` FOREIGN KEY (`creado_por`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trabajo_partes_lugar_id_foreign` FOREIGN KEY (`lugar_id`) REFERENCES `lugares` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trabajo_partes_verificado_por_foreign` FOREIGN KEY (`verificado_por`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trabajo_partes`
--


--
-- Table structure for table `trabajo_registros`
--

CREATE TABLE `trabajo_registros` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hora_inicio` time NOT NULL,
  `hora_fin` time NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_id_2` bigint(20) unsigned DEFAULT NULL,
  `user_id_3` bigint(20) unsigned DEFAULT NULL,
  `user_id_4` bigint(20) unsigned DEFAULT NULL,
  `user_id_5` bigint(20) unsigned DEFAULT NULL,
  `user_id_6` bigint(20) unsigned DEFAULT NULL,
  `user_id_7` bigint(20) unsigned DEFAULT NULL,
  `user_id_8` bigint(20) unsigned DEFAULT NULL,
  `user_id_9` bigint(20) unsigned DEFAULT NULL,
  `user_id_10` bigint(20) unsigned DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  `materiales` text DEFAULT NULL,
  `verificado` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trabajo_registros_user_id_foreign` (`user_id`),
  KEY `trabajo_registros_user_id_2_foreign` (`user_id_2`),
  KEY `trabajo_registros_user_id_3_foreign` (`user_id_3`),
  KEY `trabajo_registros_user_id_4_foreign` (`user_id_4`),
  KEY `trabajo_registros_user_id_5_foreign` (`user_id_5`),
  KEY `trabajo_registros_user_id_6_foreign` (`user_id_6`),
  KEY `trabajo_registros_user_id_7_foreign` (`user_id_7`),
  KEY `trabajo_registros_user_id_8_foreign` (`user_id_8`),
  KEY `trabajo_registros_user_id_9_foreign` (`user_id_9`),
  KEY `trabajo_registros_user_id_10_foreign` (`user_id_10`),
  CONSTRAINT `trabajo_registros_user_id_10_foreign` FOREIGN KEY (`user_id_10`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_user_id_2_foreign` FOREIGN KEY (`user_id_2`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_user_id_3_foreign` FOREIGN KEY (`user_id_3`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_user_id_4_foreign` FOREIGN KEY (`user_id_4`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_user_id_5_foreign` FOREIGN KEY (`user_id_5`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_user_id_6_foreign` FOREIGN KEY (`user_id_6`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_user_id_7_foreign` FOREIGN KEY (`user_id_7`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_user_id_8_foreign` FOREIGN KEY (`user_id_8`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_user_id_9_foreign` FOREIGN KEY (`user_id_9`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trabajo_registros`
--


--
-- Table structure for table `trabajo_registros_diarios`
--

CREATE TABLE `trabajo_registros_diarios` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `fichaje_id` bigint(20) unsigned DEFAULT NULL,
  `fecha` date NOT NULL,
  `hora_inicio` time NOT NULL,
  `hora_fin` time NOT NULL,
  `descripcion_trabajo` text NOT NULL,
  `lugar_id` bigint(20) unsigned NOT NULL,
  `estado` enum('pendiente','en_parte','verificado','aprobado','rechazado') NOT NULL DEFAULT 'pendiente',
  `observaciones` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trabajo_registros_diarios_fichaje_id_foreign` (`fichaje_id`),
  KEY `trabajo_registros_diarios_lugar_id_foreign` (`lugar_id`),
  KEY `trabajo_registros_diarios_user_id_fecha_index` (`user_id`,`fecha`),
  KEY `trabajo_registros_diarios_estado_index` (`estado`),
  CONSTRAINT `trabajo_registros_diarios_fichaje_id_foreign` FOREIGN KEY (`fichaje_id`) REFERENCES `trabajo_fichajes` (`id`) ON DELETE SET NULL,
  CONSTRAINT `trabajo_registros_diarios_lugar_id_foreign` FOREIGN KEY (`lugar_id`) REFERENCES `lugares` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trabajo_registros_diarios_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trabajo_registros_diarios`
--


--
-- Table structure for table `trabajo_registros_materiales`
--

CREATE TABLE `trabajo_registros_materiales` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `registro_diario_id` bigint(20) unsigned NOT NULL,
  `material_id` bigint(20) unsigned NOT NULL,
  `cantidad_utilizada` decimal(10,2) NOT NULL,
  `observaciones` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trabajo_registros_materiales_registro_diario_id_index` (`registro_diario_id`),
  KEY `trabajo_registros_materiales_material_id_index` (`material_id`),
  CONSTRAINT `trabajo_registros_materiales_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materiales` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trabajo_registros_materiales_registro_diario_id_foreign` FOREIGN KEY (`registro_diario_id`) REFERENCES `trabajo_registros_diarios` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trabajo_registros_materiales`
--


--
-- Dumping routines for database 'sitelec'
--


