/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 100432 (10.4.32-MariaDB)
 Source Host           : localhost:3306
 Source Schema         : siadi

 Target Server Type    : MySQL
 Target Server Version : 100432 (10.4.32-MariaDB)
 File Encoding         : 65001

 Date: 22/09/2024 09:30:39
*/


-- ----------------------------
-- Table structure for archivadores_campos
-- ----------------------------
CREATE TABLE `archivadores_campos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `campo_nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `campo_tipo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `archivador_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `archivadores_campos_archivador_id_foreign`(`archivador_id` ASC) USING BTREE,
  CONSTRAINT `archivadores_campos_archivador_id_foreign` FOREIGN KEY (`archivador_id`) REFERENCES `archivadors` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of archivadores_campos
-- ----------------------------

-- ----------------------------
-- Table structure for archivadors
-- ----------------------------
CREATE TABLE `archivadors`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `carpeta_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `archivadors_carpeta_id_foreign`(`carpeta_id` ASC) USING BTREE,
  CONSTRAINT `archivadors_carpeta_id_foreign` FOREIGN KEY (`carpeta_id`) REFERENCES `carpetas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of archivadors
-- ----------------------------

-- ----------------------------
-- Table structure for carpetas
-- ----------------------------
CREATE TABLE `carpetas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `anio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `oficina_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `carpetas_oficina_id_foreign`(`oficina_id` ASC) USING BTREE,
  CONSTRAINT `carpetas_oficina_id_foreign` FOREIGN KEY (`oficina_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of carpetas
-- ----------------------------

-- ----------------------------
-- Table structure for compartidos
-- ----------------------------
CREATE TABLE `compartidos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `usuario_id` bigint UNSIGNED NOT NULL,
  `documento_id` bigint UNSIGNED NOT NULL,
  `fecha_limite` date NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `compartidos_usuario_id_foreign`(`usuario_id` ASC) USING BTREE,
  INDEX `compartidos_documento_id_foreign`(`documento_id` ASC) USING BTREE,
  CONSTRAINT `compartidos_documento_id_foreign` FOREIGN KEY (`documento_id`) REFERENCES `documentos` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `compartidos_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of compartidos
-- ----------------------------
INSERT INTO `compartidos` VALUES (4, 6, 8, '2024-08-07', '2024-08-04 22:38:42', '2024-08-04 22:38:42');
INSERT INTO `compartidos` VALUES (5, 6, 10, '2024-08-04', '2024-08-04 23:03:03', '2024-08-04 19:07:43');
INSERT INTO `compartidos` VALUES (7, 2, 8, '2024-08-16', '2024-08-04 19:11:59', '2024-08-04 19:11:59');
INSERT INTO `compartidos` VALUES (8, 2, 12, '2024-08-16', '2024-08-04 19:11:59', '2024-08-04 19:11:59');
INSERT INTO `compartidos` VALUES (9, 2, 8, '2024-09-04', '2024-09-02 17:05:38', '2024-09-02 17:05:38');

-- ----------------------------
-- Table structure for defunciones
-- ----------------------------
CREATE TABLE `defunciones`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero_acta` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_defuncion` date NOT NULL,
  `dni_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `distrito_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provincia_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `departamento_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `centro_poblado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of defunciones
-- ----------------------------

-- ----------------------------
-- Table structure for documentos
-- ----------------------------
CREATE TABLE `documentos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tipo_archivador` enum('Informes Emitidos','Informes Recibidos','Memorándums Emitidos','Memorándums Recibidos','Oficios','Cartas','Resolución de Gerencia Municipal','Resolución de Alcaldía','Ordenanza Municipal','Decretos de Alcaldía','Directivas','Comprobantes de Pago','Expedientes','Licencias de Construcción Emitidas','Parámetros Urbanísticos','Ordenes de Compra','Ordenes de Servicio','Adjudicaciones Simplificadas','Contratos de Locación de Servicios','Contratos de Servicio','Alquiler de Vehículos','Recibos de Ingreso','Convenios','Opiniones Legales','Proyectos','Inventario Patrimonio') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `oficina_id` bigint UNSIGNED NOT NULL,
  `oficina_id_actual` bigint UNSIGNED NULL DEFAULT NULL,
  `fecha_internamiento` date NOT NULL,
  `fecha_archivador` date NOT NULL,
  `numero_folios` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion_archivador` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `numero_tomo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `color_archivador` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `numero_archivador` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `documentos_oficina_id_foreign`(`oficina_id` ASC) USING BTREE,
  INDEX `documentos_oficina_id_actual_foreign`(`oficina_id_actual` ASC) USING BTREE,
  CONSTRAINT `documentos_oficina_id_actual_foreign` FOREIGN KEY (`oficina_id_actual`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `documentos_oficina_id_foreign` FOREIGN KEY (`oficina_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of documentos
-- ----------------------------
INSERT INTO `documentos` VALUES (7, 'Informes Emitidos', 1, 1, '2024-08-01', '2024-08-16', '123213213', 'dasdsafda', 'I', 'ROJO', '2143213', 'storage/documentos/1722532291_Informes Emitidos_1.pdf', '2024-08-01 17:11:31', '2024-08-01 17:11:31');
INSERT INTO `documentos` VALUES (8, 'Informes Emitidos', 2, 7, '2024-08-01', '2024-08-02', '4234', 'sffsaf', 'I', 'ROJO', '34234', 'storage/documentos/1722532729_Informes Emitidos_2.pdf', '2024-08-01 17:18:49', '2024-08-01 17:21:08');
INSERT INTO `documentos` VALUES (10, 'Informes Emitidos', 3, 7, '2024-08-16', '2024-08-16', '4234', 'wfrwr', 'II', 'ROJO', '243234', 'storage/documentos/1722533635_Informes Emitidos_3.pdf', '2024-08-01 17:33:55', '2024-08-01 17:33:55');
INSERT INTO `documentos` VALUES (11, 'Informes Emitidos', 7, 7, '2024-08-09', '2024-08-10', '3213', 'dfad', 'I', 'ROJO', '23213', 'storage/documentos/1722533683_Informes Emitidos_7.pdf', '2024-08-01 17:34:43', '2024-08-01 17:34:43');
INSERT INTO `documentos` VALUES (12, 'Informes Emitidos', 2, 7, '2024-08-01', '2024-08-02', '74', 'jki', 'I', 'ROJO', '7', 'storage/documentos/1722540077_Informes Emitidos_2.pdf', '2024-08-01 19:21:17', '2024-08-02 21:40:03');
INSERT INTO `documentos` VALUES (13, 'Informes Emitidos', 1, 1, '2024-08-08', '2024-08-16', '123', '12sfcsa', 'III', 'ROJO', '2312', 'storage/documentos/1722808839_Informes Emitidos_1.pdf', '2024-08-04 22:00:39', '2024-08-04 22:00:39');
INSERT INTO `documentos` VALUES (14, 'Informes Emitidos', 1, 1, '2024-08-21', '2024-08-24', '123', 'wdqwdq', 'III', 'ROJO', '12312', 'storage/documentos/1722808866_Informes Emitidos_1.pdf', '2024-08-04 22:01:06', '2024-08-04 22:01:06');

-- ----------------------------
-- Table structure for empleados
-- ----------------------------
CREATE TABLE `empleados`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `paterno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `materno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `celular` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `correo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_foto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of empleados
-- ----------------------------
INSERT INTO `empleados` VALUES (1, 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', '73744393', '9852354512', 'ue308@gmail.com', 'JR.  31 DE MARZO', 'DSF', '2024-08-01 10:48:03', '2024-08-01 15:50:15');
INSERT INTO `empleados` VALUES (2, 'MARY LUZ', 'HUAYNAPATA', 'UCHARICO', '73744395', '98745412', 'ue308@gmail.com', 'JR. INDEPENDENCIA  N°1034-YUNGUYO', NULL, '2024-08-01 16:04:48', '2024-08-01 16:04:48');
INSERT INTO `empleados` VALUES (3, 'EFRAIN', 'CONDORI', 'RIVERA', '01338160', '98745412', 'ue308@gmail.com', 'JR. INDEPENDENCIA  N°1034-YUNGUYO', NULL, '2024-08-01 17:15:04', '2024-08-01 17:15:04');
INSERT INTO `empleados` VALUES (4, 'LOUDES', 'DFSDAFDS', 'DSFDSF', '1241242', 'FDSF', 'DSFSDF', 'DSFDS', NULL, '2024-08-01 19:33:43', '2024-08-01 19:33:43');
INSERT INTO `empleados` VALUES (5, 'JUAN PREDO', 'ARANIBAR', 'FLORES', '23423523', '98745412', 'ue308@gmail.com', 'JR. INDEPENDENCIA  N°1034-YUNGUYO', NULL, '2024-08-01 21:17:21', '2024-08-01 21:17:21');
INSERT INTO `empleados` VALUES (9, 'FDGSFDG', 'FDSGSFD', 'GFDSG', 'vdgfvdsgfdg', 'sgfdsg', 'fdsgsfdgf', 'fdsgfd', NULL, '2024-08-01 23:00:15', '2024-08-01 23:00:15');
INSERT INTO `empleados` VALUES (10, 'ASEDFA', 'DSFSDAF', 'SDAF', 'efewf', 'sdaf', 'sdfds', 'dsfsdf', NULL, '2024-08-02 21:42:45', '2024-08-02 21:42:45');
INSERT INTO `empleados` VALUES (11, 'PACO', 'CACERES', 'FLORES', '12345678', '98745412', 'ue308@gmail.com', 'JR. INDEPENDENCIA  N°1034-YUNGUYO', NULL, '2024-08-02 21:43:08', '2024-08-02 21:43:08');

-- ----------------------------
-- Table structure for entidades
-- ----------------------------
CREATE TABLE `entidades`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `telefono` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ruc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_anexos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_oficios` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_reportes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `representante` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre_anio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of entidades
-- ----------------------------
INSERT INTO `entidades` VALUES (1, 'Municipalidad Provincial de Arequipa', 'SDFSD', 'FSDF', 'DSFSDF', 'DSFSD', 'storage/logo/1724260870_1.png', 'SDF', 'FDSF', 'DFSD', 'DSFS', 'SDF', '2024-08-01 10:47:38', '2024-08-21 12:21:35');

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
CREATE TABLE `failed_jobs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of failed_jobs
-- ----------------------------

-- ----------------------------
-- Table structure for informes
-- ----------------------------
CREATE TABLE `informes`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `anio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `folios` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipo` enum('Emitidos','Recibidos') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `oficina_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `informes_oficina_id_foreign`(`oficina_id` ASC) USING BTREE,
  CONSTRAINT `informes_oficina_id_foreign` FOREIGN KEY (`oficina_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of informes
-- ----------------------------

-- ----------------------------
-- Table structure for libros_defunciones
-- ----------------------------
CREATE TABLE `libros_defunciones`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero_certificado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_certificado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dni_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `distrito_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provincia_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `departamento_defuncion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `centro_poblado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of libros_defunciones
-- ----------------------------

-- ----------------------------
-- Table structure for libros_matrimonios
-- ----------------------------
CREATE TABLE `libros_matrimonios`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero_acta` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_acta` date NOT NULL,
  `fecha_nacimiento_esposo` date NOT NULL,
  `fecha_nacimiento_esposa` date NOT NULL,
  `dni_esposo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dni_esposa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_esposo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_esposa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lugar_matrimonio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion_esposo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion_esposa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `distrito_conyuges` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provincia_conyuges` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `departamento_conyuges` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `centro_poblado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of libros_matrimonios
-- ----------------------------

-- ----------------------------
-- Table structure for libros_nacimientos
-- ----------------------------
CREATE TABLE `libros_nacimientos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `path_certificado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_expediente` date NOT NULL,
  `dni_nacido` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_nacido` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lugar_nacimiento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dni_padre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_padre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dni_madre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_madre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion_padre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion_madre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `distrito_padres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provincia_padres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `departamento_padres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `centro_poblado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of libros_nacimientos
-- ----------------------------

-- ----------------------------
-- Table structure for matrimonios
-- ----------------------------
CREATE TABLE `matrimonios`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero_acta` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_matrimonio` date NOT NULL,
  `fecha_nacimiento_esposo` date NOT NULL,
  `fecha_nacimiento_esposa` date NOT NULL,
  `dni_esposo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dni_esposa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_esposo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_esposa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lugar_matrimonio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion_esposo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion_esposa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `distrito_conyuges` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provincia_conyuges` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `departamento_conyuges` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `centro_poblado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of matrimonios
-- ----------------------------
INSERT INTO `matrimonios` VALUES (1, '2342343', '2024-07-31', '2024-08-01', '2024-08-09', '234234', '23423', 'sdfsadf', 'sfdsfsfd', '4', 'sfff', 'fff', 'Chugur', 'Hualgayoc', 'Cajamarca', 'storage/documentos/1722531510_ACTA_MATRIMONIO_2342343_1.pdf', '2024-08-01 16:58:30', '2024-08-01 16:58:30', 'sffffsd');

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
CREATE TABLE `migrations`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2014_10_12_100000_create_password_reset_tokens_table', 1);
INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (3, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `migrations` VALUES (4, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO `migrations` VALUES (5, '2024_06_20_223708_create_oficinas_table', 1);
INSERT INTO `migrations` VALUES (6, '2024_06_20_225337_create_empleados_table', 1);
INSERT INTO `migrations` VALUES (7, '2024_06_21_201910_create_permission_tables', 1);
INSERT INTO `migrations` VALUES (8, '2024_06_25_230050_create_carpetas_table', 1);
INSERT INTO `migrations` VALUES (9, '2024_06_26_165211_create_archivadors_table', 1);
INSERT INTO `migrations` VALUES (10, '2024_06_27_020720_create_archivadores_campos_table', 1);
INSERT INTO `migrations` VALUES (11, '2024_06_29_221813_create_oficios_table', 1);
INSERT INTO `migrations` VALUES (12, '2024_07_09_014506_create_informes_table', 1);
INSERT INTO `migrations` VALUES (13, '2024_07_22_160043_create_documentos_table', 1);
INSERT INTO `migrations` VALUES (14, '2024_07_23_033219_create_tipos_archivadores_table', 1);
INSERT INTO `migrations` VALUES (15, '2024_07_23_144548_create_nacimientos_table', 1);
INSERT INTO `migrations` VALUES (16, '2024_07_23_192925_create_matrimonios_table', 1);
INSERT INTO `migrations` VALUES (17, '2024_07_23_211350_create_defunciones_table', 1);
INSERT INTO `migrations` VALUES (18, '2024_07_24_005542_create_libros_nacimientos_table', 1);
INSERT INTO `migrations` VALUES (19, '2024_07_24_025227_create_libros_matrimonios_table', 1);
INSERT INTO `migrations` VALUES (20, '2024_07_24_031844_create_libros_defunciones_table', 1);
INSERT INTO `migrations` VALUES (21, '2024_07_30_015241_create_entidades_table', 1);
INSERT INTO `migrations` VALUES (22, '2024_07_31_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (23, '2024_08_01_195809_create_visualizaciones_table', 2);
INSERT INTO `migrations` VALUES (24, '2024_08_04_221353_create_compartidos_table', 3);
INSERT INTO `migrations` VALUES (25, '2024_08_19_105143_create_resoluciones_directorales_table', 4);

-- ----------------------------
-- Table structure for model_has_permissions
-- ----------------------------
CREATE TABLE `model_has_permissions`  (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_permissions_model_id_model_type_index`(`model_id` ASC, `model_type` ASC) USING BTREE,
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of model_has_permissions
-- ----------------------------

-- ----------------------------
-- Table structure for model_has_roles
-- ----------------------------
CREATE TABLE `model_has_roles`  (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_roles_model_id_model_type_index`(`model_id` ASC, `model_type` ASC) USING BTREE,
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of model_has_roles
-- ----------------------------
INSERT INTO `model_has_roles` VALUES (1, 'App\\Models\\User', 1);
INSERT INTO `model_has_roles` VALUES (2, 'App\\Models\\User', 2);
INSERT INTO `model_has_roles` VALUES (2, 'App\\Models\\User', 3);
INSERT INTO `model_has_roles` VALUES (4, 'App\\Models\\User', 4);
INSERT INTO `model_has_roles` VALUES (5, 'App\\Models\\User', 5);
INSERT INTO `model_has_roles` VALUES (8, 'App\\Models\\User', 6);

-- ----------------------------
-- Table structure for nacimientos
-- ----------------------------
CREATE TABLE `nacimientos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tipo` enum('Acta de Nacimiento','Libro de Nacimiento') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `numero_acta` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_nacimiento` date NOT NULL,
  `dni_nacido` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_nacido` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lugar_nacimiento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dni_padre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_padre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dni_madre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombres_madre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion_padres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `distrito_padres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provincia_padres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `departamento_padres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `centro_poblado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of nacimientos
-- ----------------------------
INSERT INTO `nacimientos` VALUES (1, 'Acta de Nacimiento', '431243', '2024-08-14', '213213', 'das', 'dasd', '34234', 'dsad', '32423', 'sdsd', 'asdasd', 'Chacas', 'Asunción', 'Ancash', 'storage/documentos/1724265473_ACTA_NACIMIENTO_431243_1.pdf', '2024-08-21 13:37:53', '2024-08-21 13:37:53', 'dsadsad');

-- ----------------------------
-- Table structure for oficinas
-- ----------------------------
CREATE TABLE `oficinas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tipo` enum('Normal','Archivo') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Normal',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oficinas
-- ----------------------------
INSERT INTO `oficinas` VALUES (1, 'INFORMATICA', '2024-08-01 10:48:22', '2024-08-01 10:48:24', 'Normal');
INSERT INTO `oficinas` VALUES (2, 'CONTABILIDAD', '2024-08-01 16:03:59', '2024-08-01 16:38:47', 'Normal');
INSERT INTO `oficinas` VALUES (3, 'RECURSOS HUMANOS', '2024-08-01 16:32:21', '2024-08-01 16:32:21', 'Normal');
INSERT INTO `oficinas` VALUES (4, 'ABASTECIMIENTO', '2024-08-01 16:32:47', '2024-08-01 16:32:47', 'Normal');
INSERT INTO `oficinas` VALUES (5, 'PLANILLAS', '2024-08-01 16:32:57', '2024-08-01 16:32:57', 'Normal');
INSERT INTO `oficinas` VALUES (7, 'ARCHIVO CENTRAL', '2024-08-01 16:39:00', '2024-08-02 21:38:48', 'Archivo');

-- ----------------------------
-- Table structure for oficios
-- ----------------------------
CREATE TABLE `oficios`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `anio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `asunto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NOT NULL,
  `path_documento` date NOT NULL,
  `tipo` enum('Emitidos','Recibidos') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `archivador_id` bigint UNSIGNED NOT NULL,
  `oficina_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `oficios_archivador_id_foreign`(`archivador_id` ASC) USING BTREE,
  INDEX `oficios_oficina_id_foreign`(`oficina_id` ASC) USING BTREE,
  CONSTRAINT `oficios_archivador_id_foreign` FOREIGN KEY (`archivador_id`) REFERENCES `archivadors` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `oficios_oficina_id_foreign` FOREIGN KEY (`oficina_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oficios
-- ----------------------------

-- ----------------------------
-- Table structure for password_reset_tokens
-- ----------------------------
CREATE TABLE `password_reset_tokens`  (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of password_reset_tokens
-- ----------------------------

-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
CREATE TABLE `password_resets`  (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  INDEX `password_resets_email_index`(`email` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of password_resets
-- ----------------------------

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
CREATE TABLE `permissions`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `permissions_name_guard_name_unique`(`name` ASC, `guard_name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of permissions
-- ----------------------------
INSERT INTO `permissions` VALUES (29, 'Actas de Nacimiento', 'web', '2024-07-01 19:34:27', '2024-07-25 19:34:27');
INSERT INTO `permissions` VALUES (30, 'Actas de Matrimonio', 'web', '2024-07-02 19:34:43', '2024-07-25 19:34:43');
INSERT INTO `permissions` VALUES (31, 'Actas de Defunción', 'web', '2024-07-03 19:35:46', '2024-07-25 19:35:46');
INSERT INTO `permissions` VALUES (32, 'Libro de Nacimiento', 'web', '2024-07-04 19:40:47', '2024-07-25 19:40:47');
INSERT INTO `permissions` VALUES (33, 'Libro de Matrimonio', 'web', '2024-07-05 19:41:02', '2024-07-25 19:41:02');
INSERT INTO `permissions` VALUES (34, 'Libro de Defunción', 'web', '2024-07-06 19:41:23', '2024-07-25 19:41:23');
INSERT INTO `permissions` VALUES (35, 'Informes Emitidos', 'web', '2024-07-07 19:41:41', '2024-07-25 19:41:41');
INSERT INTO `permissions` VALUES (36, 'Informes Recibidos', 'web', '2024-07-08 19:42:01', '2024-07-25 19:42:01');
INSERT INTO `permissions` VALUES (37, 'Memorándums Emitidos', 'web', '2024-07-09 19:42:38', '2024-07-25 19:42:38');
INSERT INTO `permissions` VALUES (38, 'Memorándums Recibidos', 'web', '2024-07-10 19:42:56', '2024-07-25 19:42:56');
INSERT INTO `permissions` VALUES (39, 'Oficios', 'web', '2024-07-11 19:43:08', '2024-07-25 19:43:08');
INSERT INTO `permissions` VALUES (40, 'Cartas', 'web', '2024-07-12 19:43:20', '2024-07-25 19:43:20');
INSERT INTO `permissions` VALUES (41, 'Resolución de Gerencia Municipal', 'web', '2024-07-13 19:43:49', '2024-07-25 19:43:49');
INSERT INTO `permissions` VALUES (42, 'Resolución de Alcaldía', 'web', '2024-07-14 19:44:22', '2024-07-25 19:44:22');
INSERT INTO `permissions` VALUES (43, 'Resolución Directoral', 'web', '2024-07-15 19:44:22', '2024-07-25 19:44:22');
INSERT INTO `permissions` VALUES (44, 'Ordenanza Municipal', 'web', '2024-07-16 19:46:39', '2024-07-25 19:46:39');
INSERT INTO `permissions` VALUES (45, 'Decretos de Alcaldía', 'web', '2024-07-17 19:47:31', '2024-07-25 19:47:31');
INSERT INTO `permissions` VALUES (46, 'Directivas', 'web', '2024-07-18 19:47:53', '2024-07-25 19:47:53');
INSERT INTO `permissions` VALUES (47, 'Comprobantes de Pago', 'web', '2024-07-19 19:48:26', '2024-07-25 19:48:26');
INSERT INTO `permissions` VALUES (48, 'Expedientes', 'web', '2024-07-20 19:48:42', '2024-07-25 19:48:42');
INSERT INTO `permissions` VALUES (49, 'Licencias de Construcción Emitidas', 'web', '2024-07-21 19:49:12', '2024-07-25 19:49:12');
INSERT INTO `permissions` VALUES (50, 'Parámetros Urbanísticos', 'web', '2024-07-22 19:51:02', '2024-07-25 19:51:02');
INSERT INTO `permissions` VALUES (51, 'Ordenes de Compra', 'web', '2024-07-23 19:51:19', '2024-07-25 19:51:19');
INSERT INTO `permissions` VALUES (52, 'Ordenes de Servicio', 'web', '2024-07-24 19:51:33', '2024-07-25 19:51:33');
INSERT INTO `permissions` VALUES (53, 'Adjudicaciones Simplificadas', 'web', '2024-07-25 19:51:58', '2024-07-25 19:51:58');
INSERT INTO `permissions` VALUES (54, 'Contratos de Locación de Servicios', 'web', '2024-07-26 19:53:30', '2024-07-25 19:53:30');
INSERT INTO `permissions` VALUES (55, 'Contratos de Servicio', 'web', '2024-07-27 19:53:57', '2024-07-25 19:53:57');
INSERT INTO `permissions` VALUES (56, 'Alquiler de Vehículos', 'web', '2024-07-28 19:54:15', '2024-07-25 19:54:15');
INSERT INTO `permissions` VALUES (57, 'Recibos de Ingreso', 'web', '2024-07-29 19:54:33', '2024-07-25 19:54:33');
INSERT INTO `permissions` VALUES (58, 'Convenios', 'web', '2024-07-30 19:54:48', '2024-07-25 19:54:48');
INSERT INTO `permissions` VALUES (59, 'Opiniones Legales', 'web', '2024-07-31 19:55:06', '2024-07-25 19:55:06');
INSERT INTO `permissions` VALUES (60, 'Proyectos', 'web', '2024-08-01 19:55:17', '2024-07-25 19:55:17');
INSERT INTO `permissions` VALUES (61, 'Inventario Patrimonio', 'web', '2024-08-02 19:55:32', '2024-07-25 19:55:32');
INSERT INTO `permissions` VALUES (62, 'Buscar Documentos', 'web', '2024-08-03 15:55:40', '2024-08-01 15:55:40');
INSERT INTO `permissions` VALUES (63, 'Buscar Actas y Libros', 'web', '2024-08-04 15:55:53', '2024-08-01 15:55:53');
INSERT INTO `permissions` VALUES (64, 'Oficinas', 'web', '2024-08-05 15:56:09', '2024-08-01 15:56:09');
INSERT INTO `permissions` VALUES (65, 'Empleados', 'web', '2024-08-06 15:56:21', '2024-08-01 15:56:21');
INSERT INTO `permissions` VALUES (66, 'Cuentas', 'web', '2024-08-07 15:56:29', '2024-08-01 15:56:29');
INSERT INTO `permissions` VALUES (67, 'Roles', 'web', '2024-08-08 15:56:35', '2024-08-01 15:56:35');
INSERT INTO `permissions` VALUES (68, 'Permisos', 'web', '2024-08-09 15:56:41', '2024-08-01 15:56:41');
INSERT INTO `permissions` VALUES (69, 'Entidad', 'web', '2024-08-10 15:56:48', '2024-08-01 15:56:48');
INSERT INTO `permissions` VALUES (70, 'MultiOficinas', 'web', '2024-08-11 17:16:02', '2024-08-01 17:16:02');
INSERT INTO `permissions` VALUES (71, 'Agregar Documentos', 'web', '2024-08-12 19:48:26', '2024-08-01 19:48:26');
INSERT INTO `permissions` VALUES (72, 'Editar Documentos', 'web', '2024-08-13 19:48:36', '2024-08-01 19:48:36');
INSERT INTO `permissions` VALUES (73, 'Eliminar Documentos', 'web', '2024-08-14 15:59:07', '2024-08-01 15:59:07');
INSERT INTO `permissions` VALUES (74, 'Internar Documentos', 'web', '2024-08-15 17:24:58', '2024-08-01 17:24:58');
INSERT INTO `permissions` VALUES (75, 'Compartir Documentos', 'web', '2024-08-16 21:38:24', '2024-08-04 21:38:24');
INSERT INTO `permissions` VALUES (76, 'Visualizadores', 'web', '2024-08-17 20:02:04', '2024-08-01 20:02:04');
INSERT INTO `permissions` VALUES (77, 'Editar Empleados', 'web', '2024-08-18 22:54:54', '2024-08-01 22:54:54');
INSERT INTO `permissions` VALUES (78, 'Eliminar Empleados', 'web', '2024-08-19 22:54:43', '2024-08-01 22:54:43');
INSERT INTO `permissions` VALUES (79, 'Compartidos', 'web', '2024-08-20 22:45:36', '2024-08-04 22:45:36');
INSERT INTO `permissions` VALUES (80, 'Editar Visualizador', 'web', '2024-08-21 19:10:13', '2024-08-04 19:10:13');
INSERT INTO `permissions` VALUES (81, 'Eliminar Visualizador', 'web', '2024-08-22 19:10:21', '2024-08-04 19:10:21');

-- ----------------------------
-- Table structure for personal_access_tokens
-- ----------------------------
CREATE TABLE `personal_access_tokens`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `personal_access_tokens_token_unique`(`token` ASC) USING BTREE,
  INDEX `personal_access_tokens_tokenable_type_tokenable_id_index`(`tokenable_type` ASC, `tokenable_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of personal_access_tokens
-- ----------------------------

-- ----------------------------
-- Table structure for resoluciones_directorales
-- ----------------------------
CREATE TABLE `resoluciones_directorales`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero_rd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `anio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_res` date NOT NULL,
  `administrado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `motivo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `concepto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `usuario_up` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_up` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of resoluciones_directorales
-- ----------------------------
INSERT INTO `resoluciones_directorales` VALUES (2, '5485786', '2023', '2024-08-22', 'sdfsd', 'fsdf', 'sdf', 'dsfd', 'storage/documentos/1724087515_RESOLUCION_DIRECTORAL_5485786_1.pdf', 'admin', '2024-08-19 12:11:55', '2024-08-19 12:11:55', '2024-08-19 12:11:55');

-- ----------------------------
-- Table structure for role_has_permissions
-- ----------------------------
CREATE TABLE `role_has_permissions`  (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `role_id`) USING BTREE,
  INDEX `role_has_permissions_role_id_foreign`(`role_id` ASC) USING BTREE,
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_has_permissions
-- ----------------------------
INSERT INTO `role_has_permissions` VALUES (29, 1);
INSERT INTO `role_has_permissions` VALUES (30, 1);
INSERT INTO `role_has_permissions` VALUES (31, 1);
INSERT INTO `role_has_permissions` VALUES (32, 1);
INSERT INTO `role_has_permissions` VALUES (33, 1);
INSERT INTO `role_has_permissions` VALUES (34, 1);
INSERT INTO `role_has_permissions` VALUES (35, 1);
INSERT INTO `role_has_permissions` VALUES (35, 2);
INSERT INTO `role_has_permissions` VALUES (36, 1);
INSERT INTO `role_has_permissions` VALUES (36, 2);
INSERT INTO `role_has_permissions` VALUES (37, 1);
INSERT INTO `role_has_permissions` VALUES (37, 2);
INSERT INTO `role_has_permissions` VALUES (38, 1);
INSERT INTO `role_has_permissions` VALUES (38, 2);
INSERT INTO `role_has_permissions` VALUES (39, 1);
INSERT INTO `role_has_permissions` VALUES (40, 1);
INSERT INTO `role_has_permissions` VALUES (41, 1);
INSERT INTO `role_has_permissions` VALUES (42, 1);
INSERT INTO `role_has_permissions` VALUES (43, 1);
INSERT INTO `role_has_permissions` VALUES (44, 1);
INSERT INTO `role_has_permissions` VALUES (45, 1);
INSERT INTO `role_has_permissions` VALUES (46, 1);
INSERT INTO `role_has_permissions` VALUES (47, 1);
INSERT INTO `role_has_permissions` VALUES (48, 1);
INSERT INTO `role_has_permissions` VALUES (49, 1);
INSERT INTO `role_has_permissions` VALUES (50, 1);
INSERT INTO `role_has_permissions` VALUES (51, 1);
INSERT INTO `role_has_permissions` VALUES (51, 2);
INSERT INTO `role_has_permissions` VALUES (52, 1);
INSERT INTO `role_has_permissions` VALUES (52, 2);
INSERT INTO `role_has_permissions` VALUES (53, 1);
INSERT INTO `role_has_permissions` VALUES (54, 1);
INSERT INTO `role_has_permissions` VALUES (55, 1);
INSERT INTO `role_has_permissions` VALUES (56, 1);
INSERT INTO `role_has_permissions` VALUES (57, 1);
INSERT INTO `role_has_permissions` VALUES (58, 1);
INSERT INTO `role_has_permissions` VALUES (59, 1);
INSERT INTO `role_has_permissions` VALUES (60, 1);
INSERT INTO `role_has_permissions` VALUES (61, 1);
INSERT INTO `role_has_permissions` VALUES (62, 1);
INSERT INTO `role_has_permissions` VALUES (62, 2);
INSERT INTO `role_has_permissions` VALUES (63, 1);
INSERT INTO `role_has_permissions` VALUES (64, 1);
INSERT INTO `role_has_permissions` VALUES (65, 1);
INSERT INTO `role_has_permissions` VALUES (66, 1);
INSERT INTO `role_has_permissions` VALUES (67, 1);
INSERT INTO `role_has_permissions` VALUES (68, 1);
INSERT INTO `role_has_permissions` VALUES (69, 1);
INSERT INTO `role_has_permissions` VALUES (70, 1);
INSERT INTO `role_has_permissions` VALUES (71, 1);
INSERT INTO `role_has_permissions` VALUES (71, 2);
INSERT INTO `role_has_permissions` VALUES (72, 1);
INSERT INTO `role_has_permissions` VALUES (72, 2);
INSERT INTO `role_has_permissions` VALUES (73, 1);
INSERT INTO `role_has_permissions` VALUES (74, 1);
INSERT INTO `role_has_permissions` VALUES (74, 2);
INSERT INTO `role_has_permissions` VALUES (75, 1);
INSERT INTO `role_has_permissions` VALUES (75, 2);
INSERT INTO `role_has_permissions` VALUES (76, 1);
INSERT INTO `role_has_permissions` VALUES (77, 1);
INSERT INTO `role_has_permissions` VALUES (78, 1);
INSERT INTO `role_has_permissions` VALUES (79, 1);
INSERT INTO `role_has_permissions` VALUES (79, 2);
INSERT INTO `role_has_permissions` VALUES (80, 1);
INSERT INTO `role_has_permissions` VALUES (81, 1);

-- ----------------------------
-- Table structure for roles
-- ----------------------------
CREATE TABLE `roles`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `roles_name_guard_name_unique`(`name` ASC, `guard_name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (1, 'Administrador', 'web', '2024-08-01 10:53:17', '2024-08-01 10:53:20');
INSERT INTO `roles` VALUES (2, 'Usuario Nivel 1', 'web', '2024-08-01 16:04:59', '2024-08-01 16:04:59');
INSERT INTO `roles` VALUES (3, 'Usuario Nivel 2', 'web', '2024-08-01 17:16:28', '2024-08-01 17:16:28');
INSERT INTO `roles` VALUES (4, 'Visualizador 1', 'web', '2024-08-01 19:23:11', '2024-08-01 20:26:41');
INSERT INTO `roles` VALUES (5, 'Visualizador Tipo 5', 'web', '2024-08-01 21:17:47', '2024-08-01 21:17:47');
INSERT INTO `roles` VALUES (6, 'Visualizador Prueba', 'web', '2024-08-02 02:28:30', '2024-08-02 02:28:30');
INSERT INTO `roles` VALUES (7, 'Administrador 2', 'web', '2024-08-02 02:28:52', '2024-08-02 02:28:52');
INSERT INTO `roles` VALUES (8, 'Visualizador General', 'web', '2024-08-02 21:46:20', '2024-08-02 21:46:20');

-- ----------------------------
-- Table structure for tipos_archivadores
-- ----------------------------
CREATE TABLE `tipos_archivadores`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tipos_archivadores
-- ----------------------------

-- ----------------------------
-- Table structure for users
-- ----------------------------
CREATE TABLE `users`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `entidad_id` bigint UNSIGNED NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado` enum('ACTIVO','INACTIVO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `empleado_id` bigint UNSIGNED NOT NULL,
  `oficina_id` bigint UNSIGNED NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `users_username_unique`(`username` ASC) USING BTREE,
  INDEX `users_entidad_id_foreign`(`entidad_id` ASC) USING BTREE,
  INDEX `users_empleado_id_foreign`(`empleado_id` ASC) USING BTREE,
  INDEX `users_oficina_id_foreign`(`oficina_id` ASC) USING BTREE,
  CONSTRAINT `users_empleado_id_foreign` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `users_entidad_id_foreign` FOREIGN KEY (`entidad_id`) REFERENCES `entidades` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `users_oficina_id_foreign` FOREIGN KEY (`oficina_id`) REFERENCES `oficinas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 1, 'admin', '$2y$10$ZSDIDGsJ94GP2VT0wEffQun8/3Tv8SeqMbnRfytu5T7sCHzb7GCFu', 'ACTIVO', 1, 1, NULL, '2024-08-01 10:49:12', '2024-08-01 15:49:57');
INSERT INTO `users` VALUES (2, 1, 'conta', '$2y$10$WnofcJjbM.y2scr8ltPSrun6VXv61wxGhY.yGnFb.9Bn001yaodSm', 'ACTIVO', 2, 2, NULL, '2024-08-01 16:05:33', '2024-08-02 21:36:07');
INSERT INTO `users` VALUES (3, 1, 'archi', '$2y$10$BHkGWJSkpQuUp4FMVL8sLOrxKifgPHJ7XBeAWyxeqVWHlxX33KgKy', 'ACTIVO', 3, 7, NULL, '2024-08-01 17:17:08', '2024-08-01 17:17:08');
INSERT INTO `users` VALUES (4, 1, 'vis', '$2y$10$g.w.ijAV5YhehYwfhDvDkeRzqP2cDOtn8Q0QTMgYAGEAl69FqsXHm', 'ACTIVO', 4, 7, NULL, '2024-08-01 19:35:04', '2024-08-01 19:35:04');
INSERT INTO `users` VALUES (5, 1, 'juan', '$2y$10$Us62CAP4AZ/qOYN5wJnrAuDJ//KXh7sZ8K9c30dBFK49XpblfOaXy', 'ACTIVO', 5, 7, NULL, '2024-08-01 21:18:13', '2024-08-01 23:06:51');
INSERT INTO `users` VALUES (6, 1, 'paco', '$2y$10$z8EFyFI4PKOQZ/BER/brguWWLgCdi7y87u9pko3HghVxIkOzbU23q', 'ACTIVO', 11, 7, NULL, '2024-08-02 21:48:06', '2024-08-02 21:48:06');

-- ----------------------------
-- Table structure for visualizaciones
-- ----------------------------
CREATE TABLE `visualizaciones`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `fecha_inicio` date NULL DEFAULT NULL,
  `fecha_fin` date NULL DEFAULT NULL,
  `fecha_limite` date NULL DEFAULT NULL,
  `usuario_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `visualizaciones_usuario_id_foreign`(`usuario_id` ASC) USING BTREE,
  CONSTRAINT `visualizaciones_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of visualizaciones
-- ----------------------------
INSERT INTO `visualizaciones` VALUES (1, '2024-08-01', '2024-08-05', '2024-08-29', 4, '2024-08-01 21:10:37', '2024-08-01 21:16:05');
INSERT INTO `visualizaciones` VALUES (2, '2024-08-02', '2024-08-03', '2024-08-03', 5, '2024-08-01 21:58:51', '2024-08-01 22:37:02');
INSERT INTO `visualizaciones` VALUES (3, '2024-08-01', '2024-08-03', '2024-08-05', 6, '2024-08-02 21:51:34', '2024-08-02 21:51:34');

