/*
 Navicat Premium Dump SQL

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

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

 Date: 10/01/2025 20:53:47
*/


-- ----------------------------
-- Table structure for actividades
-- ----------------------------
CREATE TABLE `actividades`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero_actividad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre_actividad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `actividades_meta_id_foreign`(`meta_id` ASC) USING BTREE,
  CONSTRAINT `actividades_meta_id_foreign` FOREIGN KEY (`meta_id`) REFERENCES `metas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of actividades
-- ----------------------------
INSERT INTO `actividades` VALUES (1, '0032', 'FASFASF', 1, '2024-12-01 14:04:47', '2024-12-23 17:43:25');
INSERT INTO `actividades` VALUES (3, '0067', 'activa de otra menta', 3, '2024-12-02 23:26:30', '2024-12-23 17:43:11');
INSERT INTO `actividades` VALUES (4, '0043', 'Incremento de la efectividad corriente del Impuesto Predial', 4, '2024-12-16 15:05:53', '2024-12-23 17:43:01');
INSERT INTO `actividades` VALUES (5, '0023', 'Actividade de prueba de reporte 02', 5, '2024-12-23 19:07:57', '2024-12-23 19:07:57');
INSERT INTO `actividades` VALUES (6, '0058', 'Actividad de  prueba pra reporte 04', 5, '2024-12-23 19:08:19', '2024-12-23 19:08:19');
INSERT INTO `actividades` VALUES (7, '0088', 'Actividad de prueba para repote 05', 6, '2024-12-23 19:08:39', '2024-12-23 19:08:39');
INSERT INTO `actividades` VALUES (8, '0071', 'Actividad de prueba para reporte 054', 7, '2024-12-23 19:10:56', '2024-12-23 19:10:56');
INSERT INTO `actividades` VALUES (9, '0062', 'prueb', 7, '2025-01-04 15:27:25', '2025-01-04 15:27:25');
INSERT INTO `actividades` VALUES (10, '43123', 'VXCDV', 13, '2025-01-05 17:39:21', '2025-01-05 17:39:21');
INSERT INTO `actividades` VALUES (11, '244', 'VCXDSVDFGVDF', 13, '2025-01-05 17:39:30', '2025-01-05 17:39:30');
INSERT INTO `actividades` VALUES (12, '45234', 'DGFVDGD', 12, '2025-01-05 17:39:40', '2025-01-05 17:39:40');
INSERT INTO `actividades` VALUES (13, '6435', 'XVFDSGFSD', 11, '2025-01-05 17:39:47', '2025-01-05 17:39:47');
INSERT INTO `actividades` VALUES (14, '5023', 'FDSFSD', 11, '2025-01-05 17:39:55', '2025-01-05 17:39:55');
INSERT INTO `actividades` VALUES (15, '645', 'DSFSDFSD', 10, '2025-01-05 17:40:05', '2025-01-05 17:40:05');
INSERT INTO `actividades` VALUES (16, '4234', 'FSDAFSDAF', 9, '2025-01-05 17:40:12', '2025-01-05 17:40:12');
INSERT INTO `actividades` VALUES (17, '4234', 'SDFSDFSD', 8, '2025-01-05 17:40:20', '2025-01-05 17:40:20');

-- ----------------------------
-- Table structure for areas
-- ----------------------------
CREATE TABLE `areas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipo` enum('AREA','INSTITUCION') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado` enum('ACTIVO','INACTIVO') 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
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of areas
-- ----------------------------
INSERT INTO `areas` VALUES (1, 'SUB GERENCIA DE GESTION DE RIESGO DE DESASTRES Y DEFENSA CIVIL', 'AREA', 'ACTIVO', '2023-11-16 14:09:31', '2024-12-23 18:08:05');
INSERT INTO `areas` VALUES (2, 'GERENCIA DE INFRAESTRUCTURA Y GESTION TERRITORIAL', 'AREA', 'ACTIVO', '2023-11-16 19:16:06', '2024-12-23 18:07:47');
INSERT INTO `areas` VALUES (3, 'SUB GERENCIA DE PLANEAMIENTO TERRITORIAL Y CONTROL URBANO', 'AREA', 'ACTIVO', '2023-11-16 19:16:59', '2024-12-23 18:07:24');
INSERT INTO `areas` VALUES (4, 'SUB GERENCIA DE SUPERVISION Y LIQUIDACION', 'AREA', 'ACTIVO', '2023-11-16 19:17:09', '2024-12-23 18:07:06');
INSERT INTO `areas` VALUES (5, 'GERENCIA DE ADMINISTRACION TRIBUTARIA', 'AREA', 'ACTIVO', '2023-11-16 19:19:58', '2024-12-23 18:06:42');
INSERT INTO `areas` VALUES (6, 'SUB GERENCIA DE REGISTRO RECAUDACION Y FISCALIZACION TRIBUTARIA', 'AREA', 'ACTIVO', '2023-11-20 16:09:42', '2024-12-23 18:06:23');

-- ----------------------------
-- Table structure for conductores
-- ----------------------------
CREATE TABLE `conductores`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `dni` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `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,
  `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `telefono` 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,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `licencia` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 conductores
-- ----------------------------
INSERT INTO `conductores` VALUES (1, '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 'JR. 31 DE MARZO S/N', '967444616', 'ue308@gmail.com', '2024-12-04 16:13:37', '2024-12-10 12:22:31', '5487k6875');

-- ----------------------------
-- Table structure for contratos
-- ----------------------------
CREATE TABLE `contratos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre_proveedor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `direccion_proveedor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `nombre_representante` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `telefono_representante` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `numero_contrato` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `documento_contrato` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `anio_contrato` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of contratos
-- ----------------------------
INSERT INTO `contratos` VALUES (2, 'PRUEBA', 'JR LAYKAKPTA', 'PEDRO', '97436435', '0000221', 'storage/parametros/1730923795PROVEEDOR_PRUEBA_254.pdf', '2024-11-06 15:09:55', '2024-11-06 16:57:16', '2024');
INSERT INTO `contratos` VALUES (3, 'ger', 'gr', 'gfd', 'gfd', '0000115', 'storage/parametros/1730924541PROVEEDOR_ger_256.pdf', '2024-11-06 15:22:21', '2024-11-26 11:10:39', '2024');

-- ----------------------------
-- Table structure for contratos_dos
-- ----------------------------
CREATE TABLE `contratos_dos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `proveedor_id` bigint UNSIGNED NOT NULL,
  `tipo_contrato` enum('CONTRATO','ORDEN DE COMPRA','ORDEN DE SERVICIO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `numero_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha_contrato` date NOT NULL,
  `total_cantidad` decimal(8, 2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `stock_total` decimal(10, 2) NULL DEFAULT NULL,
  `total_cantidad_actual` decimal(10, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `contratos_dos_proveedor_id_foreign`(`proveedor_id` ASC) USING BTREE,
  CONSTRAINT `contratos_dos_proveedor_id_foreign` FOREIGN KEY (`proveedor_id`) REFERENCES `proveedores` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of contratos_dos
-- ----------------------------
INSERT INTO `contratos_dos` VALUES (18, 6, 'ORDEN DE COMPRA', '08-202', '2025-01-04', 120.00, '2025-01-04 14:04:22', '2025-01-05 18:20:43', NULL, 40.00);
INSERT INTO `contratos_dos` VALUES (19, 5, 'ORDEN DE SERVICIO', '009-2024', '2025-01-04', 60.00, '2025-01-04 14:17:24', '2025-01-05 17:18:11', NULL, 0.00);

-- ----------------------------
-- Table structure for detalles_contratos
-- ----------------------------
CREATE TABLE `detalles_contratos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `contrato_id` bigint UNSIGNED NOT NULL,
  `producto_id` bigint UNSIGNED NOT NULL,
  `area_id` bigint UNSIGNED NOT NULL,
  `meta_id` bigint UNSIGNED NOT NULL,
  `actividad_id` bigint UNSIGNED NOT NULL,
  `cantidad` decimal(8, 2) NOT NULL,
  `precio` decimal(8, 2) NOT NULL,
  `total_precio` decimal(8, 2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `stock_actual` decimal(10, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `detalles_contratos_producto_id_foreign`(`producto_id` ASC) USING BTREE,
  INDEX `detalles_contratos_area_id_foreign`(`area_id` ASC) USING BTREE,
  INDEX `detalles_contratos_meta_id_foreign`(`meta_id` ASC) USING BTREE,
  INDEX `detalles_contratos_actividad_id_foreign`(`actividad_id` ASC) USING BTREE,
  INDEX `detalles_contratos_contrato_id_foreign`(`contrato_id` ASC) USING BTREE,
  CONSTRAINT `detalles_contratos_actividad_id_foreign` FOREIGN KEY (`actividad_id`) REFERENCES `actividades` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `detalles_contratos_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `detalles_contratos_contrato_id_foreign` FOREIGN KEY (`contrato_id`) REFERENCES `contratos_dos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `detalles_contratos_meta_id_foreign` FOREIGN KEY (`meta_id`) REFERENCES `metas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `detalles_contratos_producto_id_foreign` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of detalles_contratos
-- ----------------------------
INSERT INTO `detalles_contratos` VALUES (33, 19, 4, 2, 7, 9, 30.00, 30.00, 900.00, '2025-01-05 16:22:54', '2025-01-05 17:14:59', 2.00);
INSERT INTO `detalles_contratos` VALUES (34, 19, 4, 5, 3, 3, 30.00, 30.00, 900.00, '2025-01-05 17:18:11', '2025-01-05 17:18:48', 20.00);
INSERT INTO `detalles_contratos` VALUES (36, 18, 4, 6, 8, 17, 20.00, 100.00, 2000.00, '2025-01-05 17:41:10', '2025-01-05 17:41:10', 20.00);
INSERT INTO `detalles_contratos` VALUES (37, 18, 4, 4, 11, 14, 20.00, 100.00, 2000.00, '2025-01-05 17:41:31', '2025-01-05 17:41:31', 20.00);
INSERT INTO `detalles_contratos` VALUES (38, 18, 4, 4, 11, 13, 20.00, 100.00, 2000.00, '2025-01-05 17:41:36', '2025-01-05 17:41:36', 20.00);
INSERT INTO `detalles_contratos` VALUES (39, 18, 4, 2, 7, 9, 20.00, 100.00, 2000.00, '2025-01-05 17:41:57', '2025-01-05 17:47:52', 15.00);

-- ----------------------------
-- Table structure for detalles_kardexs
-- ----------------------------
CREATE TABLE `detalles_kardexs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `kardex_id` bigint UNSIGNED NOT NULL,
  `fecha` date NULL DEFAULT NULL,
  `estado` enum('ACTIVO','INACTIVO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `detalles_id` bigint UNSIGNED NULL DEFAULT NULL,
  `doc_soporte` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cantidad_inicial` decimal(8, 2) NULL DEFAULT NULL,
  `precio_inicial` decimal(8, 2) NULL DEFAULT NULL,
  `total_inicial` decimal(8, 2) NULL DEFAULT NULL,
  `cantidad_salida` decimal(8, 2) NULL DEFAULT NULL,
  `precio_salida` decimal(8, 2) NULL DEFAULT NULL,
  `precio_total` decimal(8, 2) NULL DEFAULT NULL,
  `cantidad_saldo` decimal(8, 2) NULL DEFAULT NULL,
  `precio_promedio` decimal(8, 2) NULL DEFAULT NULL,
  `costo_total_saldo` decimal(8, 2) NULL DEFAULT NULL,
  `usuario_id` bigint UNSIGNED NOT NULL,
  `tipo_operacion` enum('INICIAL','INGRESO','SALIDA') 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,
  INDEX `detalles_kardexs_kardex_id_foreign`(`kardex_id` ASC) USING BTREE,
  INDEX `detalles_kardexs_detalles_id_foreign`(`detalles_id` ASC) USING BTREE,
  INDEX `detalles_kardexs_usuario_id_foreign`(`usuario_id` ASC) USING BTREE,
  CONSTRAINT `detalles_kardexs_detalles_id_foreign` FOREIGN KEY (`detalles_id`) REFERENCES `detalles_contratos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `detalles_kardexs_kardex_id_foreign` FOREIGN KEY (`kardex_id`) REFERENCES `kardexs` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `detalles_kardexs_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of detalles_kardexs
-- ----------------------------

-- ----------------------------
-- 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,
  `ruc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `telefono` 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,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `path_logo_vale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_logo_reporte` 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 entidades
-- ----------------------------
INSERT INTO `entidades` VALUES (1, 'MUNICIPALIDAD PROVINCIAL DE ANGARES', '20406267190', 'JR. INDEPENDENCIA N° 1034', '987654321', 'storage/logo/1735442382_1.png', '2023-11-16 14:11:37', '2024-12-28 22:19:54', 'storage/logo/1735442394_1.png', 'storage/logo/1700533964_1.png');

-- ----------------------------
-- 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 kardexs
-- ----------------------------
CREATE TABLE `kardexs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `contrato_id` bigint UNSIGNED NOT NULL,
  `fecha` date NULL DEFAULT NULL,
  `monto_inicial` decimal(8, 2) NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `kardexs_contrato_id_foreign`(`contrato_id` ASC) USING BTREE,
  CONSTRAINT `kardexs_contrato_id_foreign` FOREIGN KEY (`contrato_id`) REFERENCES `contratos_dos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of kardexs
-- ----------------------------

-- ----------------------------
-- Table structure for metas
-- ----------------------------
CREATE TABLE `metas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero_meta` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre_meta` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `area_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `metas_area_id_foreign`(`area_id` ASC) USING BTREE,
  CONSTRAINT `metas_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of metas
-- ----------------------------
INSERT INTO `metas` VALUES (1, '0062', 'mn', 5, '2024-12-01 13:34:49', '2024-12-23 17:42:32');
INSERT INTO `metas` VALUES (3, '0002', 'meta de prueba', 5, '2024-12-02 23:26:13', '2024-12-23 17:42:25');
INSERT INTO `metas` VALUES (4, '0007', 'Fortalecimiento de la Administración y Gestión del Impuesto Predial', 2, '2024-12-16 15:03:13', '2024-12-23 17:42:18');
INSERT INTO `metas` VALUES (5, '0035', 'Mesta de prueba para reporte', 2, '2024-12-23 19:06:58', '2024-12-23 19:06:58');
INSERT INTO `metas` VALUES (6, '0047', 'Mesta de prueba para reporte 03', 2, '2024-12-23 19:07:24', '2024-12-23 19:07:24');
INSERT INTO `metas` VALUES (7, '0087', 'Meta de prueba para reporten004', 2, '2024-12-23 19:10:29', '2024-12-23 19:10:29');
INSERT INTO `metas` VALUES (8, '0087', 'BDGDFGVDFG', 6, '2025-01-05 17:38:19', '2025-01-05 17:38:19');
INSERT INTO `metas` VALUES (9, '0032', 'FSDFSDAFSDF', 6, '2025-01-05 17:38:34', '2025-01-05 17:38:34');
INSERT INTO `metas` VALUES (10, '00123', 'SADFSDAF', 4, '2025-01-05 17:38:45', '2025-01-05 17:38:45');
INSERT INTO `metas` VALUES (11, '312', 'SDFCSDF', 4, '2025-01-05 17:38:53', '2025-01-05 17:38:53');
INSERT INTO `metas` VALUES (12, '64325', 'CDSFCSDC', 4, '2025-01-05 17:39:00', '2025-01-05 17:39:00');
INSERT INTO `metas` VALUES (13, '21321', 'DSFDSF', 3, '2025-01-05 17:39:09', '2025-01-05 17:39:09');

-- ----------------------------
-- 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 = 30 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, '2023_11_08_190818_create_entidades_table', 1);
INSERT INTO `migrations` VALUES (6, '2023_11_08_191403_create_areas_table', 1);
INSERT INTO `migrations` VALUES (7, '2023_11_08_191528_create_personales_table', 1);
INSERT INTO `migrations` VALUES (8, '2023_11_08_195044_create_vehiculos_table', 1);
INSERT INTO `migrations` VALUES (9, '2023_11_08_195410_create_tipo_rutas_table', 1);
INSERT INTO `migrations` VALUES (10, '2023_11_08_195536_create_rutas_table', 1);
INSERT INTO `migrations` VALUES (11, '2023_11_08_222506_create_vales_table', 1);
INSERT INTO `migrations` VALUES (12, '2023_11_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (13, '2024_08_29_093029_create_permission_tables', 2);
INSERT INTO `migrations` VALUES (14, '2024_09_03_094549_create_parametros_table', 3);
INSERT INTO `migrations` VALUES (15, '2024_11_06_121541_create_contratos_table', 4);
INSERT INTO `migrations` VALUES (16, '2024_11_30_165148_create_proveedores_table', 5);
INSERT INTO `migrations` VALUES (17, '2024_11_30_173710_create_productos_table', 6);
INSERT INTO `migrations` VALUES (18, '2024_12_01_122640_create_metas_table', 7);
INSERT INTO `migrations` VALUES (19, '2024_12_01_123421_create_actividades_table', 8);
INSERT INTO `migrations` VALUES (20, '2024_12_01_164726_create_contratos_dos_table', 9);
INSERT INTO `migrations` VALUES (21, '2024_12_02_172827_create_detalles_contratos_table', 10);
INSERT INTO `migrations` VALUES (22, '2024_12_04_111818_create_conductores_table', 11);
INSERT INTO `migrations` VALUES (23, '2024_12_04_202105_create_salidas_vales_table', 12);
INSERT INTO `migrations` VALUES (24, '2024_12_23_215832_create_kardexs_table', 13);
INSERT INTO `migrations` VALUES (25, '2024_12_23_220051_create_detalles_kardexs_table', 13);
INSERT INTO `migrations` VALUES (26, '2024_12_23_232122_create_kardexs_table', 14);
INSERT INTO `migrations` VALUES (27, '2024_12_23_232404_create_kardexs_table', 15);
INSERT INTO `migrations` VALUES (28, '2024_12_23_233749_create_kardexs_table', 16);
INSERT INTO `migrations` VALUES (29, '2024_12_23_233903_create_detalles_kardexs_table', 16);

-- ----------------------------
-- 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 (8, 'App\\Models\\User', 1);
INSERT INTO `model_has_roles` VALUES (9, 'App\\Models\\User', 7);
INSERT INTO `model_has_roles` VALUES (15, 'App\\Models\\User', 12);
INSERT INTO `model_has_roles` VALUES (16, 'App\\Models\\User', 2);
INSERT INTO `model_has_roles` VALUES (16, 'App\\Models\\User', 3);
INSERT INTO `model_has_roles` VALUES (16, 'App\\Models\\User', 4);
INSERT INTO `model_has_roles` VALUES (16, 'App\\Models\\User', 5);
INSERT INTO `model_has_roles` VALUES (16, 'App\\Models\\User', 13);

-- ----------------------------
-- Table structure for parametros
-- ----------------------------
CREATE TABLE `parametros`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre_administracion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `dni_administracion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `nombre_abastecimientos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `dni_abastecimientos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `otros` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `contrato_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `contrato_id`(`contrato_id` ASC) USING BTREE,
  CONSTRAINT `parametros_ibfk_1` FOREIGN KEY (`contrato_id`) REFERENCES `contratos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 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 = 80 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of permissions
-- ----------------------------
INSERT INTO `permissions` VALUES (5, 'Ver Permisos', 'web', '2024-08-29 16:20:21', '2024-08-29 16:20:21');
INSERT INTO `permissions` VALUES (6, 'Agregar Permisos', 'web', '2024-08-29 16:20:35', '2024-08-29 16:20:35');
INSERT INTO `permissions` VALUES (7, 'Ver Roles', 'web', '2024-08-29 16:21:26', '2024-08-29 16:21:26');
INSERT INTO `permissions` VALUES (8, 'Agregar Roles', 'web', '2024-08-29 16:21:58', '2024-08-29 16:21:58');
INSERT INTO `permissions` VALUES (9, 'Editar Roles', 'web', '2024-08-29 16:22:37', '2024-08-29 16:22:37');
INSERT INTO `permissions` VALUES (10, 'Eliminar Roles', 'web', '2024-08-29 16:22:44', '2024-08-29 16:22:44');
INSERT INTO `permissions` VALUES (11, 'Asignar Permisos', 'web', '2024-08-29 16:22:59', '2024-08-29 16:22:59');
INSERT INTO `permissions` VALUES (12, 'Ver Areas', 'web', '2024-08-29 16:23:28', '2024-08-29 16:23:28');
INSERT INTO `permissions` VALUES (13, 'Agregar Areas', 'web', '2024-08-29 16:23:38', '2024-08-29 16:23:38');
INSERT INTO `permissions` VALUES (14, 'Editar Areas', 'web', '2024-08-29 16:23:48', '2024-08-29 16:23:48');
INSERT INTO `permissions` VALUES (15, 'Eliminar Areas', 'web', '2024-08-29 16:28:16', '2024-08-29 16:28:16');
INSERT INTO `permissions` VALUES (16, 'Ver Personal', 'web', '2024-08-29 16:28:42', '2024-08-29 16:28:42');
INSERT INTO `permissions` VALUES (17, 'Agregar Personal', 'web', '2024-08-29 16:28:57', '2024-08-29 16:28:57');
INSERT INTO `permissions` VALUES (18, 'Editar Personal', 'web', '2024-08-29 16:29:13', '2024-08-29 16:29:13');
INSERT INTO `permissions` VALUES (19, 'Eliminar Personal', 'web', '2024-08-29 16:29:24', '2024-08-29 16:29:24');
INSERT INTO `permissions` VALUES (20, 'Ver Cuentas', 'web', '2024-08-29 16:29:38', '2024-08-29 16:29:38');
INSERT INTO `permissions` VALUES (21, 'Agregar Cuentas', 'web', '2024-08-29 16:29:46', '2024-08-29 16:29:46');
INSERT INTO `permissions` VALUES (22, 'Editar Cuentas', 'web', '2024-08-29 16:29:56', '2024-08-29 16:29:56');
INSERT INTO `permissions` VALUES (23, 'Activar Cuentas', 'web', '2024-08-29 16:30:08', '2024-08-29 16:30:08');
INSERT INTO `permissions` VALUES (24, 'Ver Vehiculos', 'web', '2024-08-29 16:30:24', '2024-08-29 16:30:24');
INSERT INTO `permissions` VALUES (25, 'Agregar Vehiculos', 'web', '2024-08-29 16:30:35', '2024-08-29 16:30:35');
INSERT INTO `permissions` VALUES (26, 'Editar Vehiculos', 'web', '2024-08-29 16:30:49', '2024-08-29 16:30:49');
INSERT INTO `permissions` VALUES (27, 'Eliminar Vehiculos', 'web', '2024-08-29 16:31:00', '2024-08-29 16:31:00');
INSERT INTO `permissions` VALUES (28, 'Ver Rutas', 'web', '2024-08-29 16:31:19', '2024-08-29 16:31:19');
INSERT INTO `permissions` VALUES (29, 'Agregar Rutas', 'web', '2024-08-29 16:31:28', '2024-08-29 16:31:28');
INSERT INTO `permissions` VALUES (30, 'Editar Rutas', 'web', '2024-08-29 16:31:37', '2024-08-29 16:31:37');
INSERT INTO `permissions` VALUES (31, 'Eliminar Rutas', 'web', '2024-08-29 16:31:57', '2024-08-29 16:31:57');
INSERT INTO `permissions` VALUES (32, 'Ver Tipos Rutas', 'web', '2024-08-29 16:32:12', '2024-08-29 16:32:12');
INSERT INTO `permissions` VALUES (33, 'Agregar Tipos Rutas', 'web', '2024-08-29 16:32:22', '2024-08-29 16:32:22');
INSERT INTO `permissions` VALUES (34, 'Editar Tipos Rutas', 'web', '2024-08-29 16:32:33', '2024-08-29 16:32:33');
INSERT INTO `permissions` VALUES (35, 'Eliminar Tipos Rutas', 'web', '2024-08-29 16:32:42', '2024-08-29 16:32:42');
INSERT INTO `permissions` VALUES (36, 'Ver Entidad', 'web', '2024-08-29 16:33:05', '2024-08-29 16:33:05');
INSERT INTO `permissions` VALUES (37, 'Editar Entidad', 'web', '2024-08-29 16:33:17', '2024-08-29 16:33:17');
INSERT INTO `permissions` VALUES (38, 'Ver Vales Archivados', 'web', '2024-08-29 16:33:44', '2024-08-29 16:33:44');
INSERT INTO `permissions` VALUES (39, 'Editar Vales Archivados', 'web', '2024-08-29 16:33:57', '2024-08-29 16:33:57');
INSERT INTO `permissions` VALUES (40, 'Generar Vale', 'web', '2024-08-29 16:34:11', '2024-08-29 16:34:11');
INSERT INTO `permissions` VALUES (41, 'Generar Reportes', 'web', '2024-08-29 16:34:21', '2024-08-29 16:34:21');
INSERT INTO `permissions` VALUES (42, 'Ver Mis Vales', 'web', '2024-09-01 10:46:27', '2024-09-01 10:46:27');
INSERT INTO `permissions` VALUES (43, 'Aprobar Vales', 'web', '2024-09-01 11:15:08', '2024-09-01 11:15:08');
INSERT INTO `permissions` VALUES (44, 'Rechazar Vales', 'web', '2024-09-01 11:15:20', '2024-09-01 11:15:20');
INSERT INTO `permissions` VALUES (45, 'Eliminar Vales', 'web', '2024-09-01 11:15:30', '2024-09-01 11:15:30');
INSERT INTO `permissions` VALUES (46, 'Mi Firma', 'web', '2024-09-01 17:34:16', '2024-09-01 17:34:16');
INSERT INTO `permissions` VALUES (47, 'Ver Parametros', 'web', '2024-09-03 09:51:07', '2024-09-03 09:51:07');
INSERT INTO `permissions` VALUES (48, 'Editar Parametros', 'web', '2024-09-03 10:26:10', '2024-09-03 10:26:10');
INSERT INTO `permissions` VALUES (50, 'Ver Mis Vales Recientes', 'web', '2024-09-08 14:11:07', '2024-09-08 14:11:07');
INSERT INTO `permissions` VALUES (51, 'Eliminar Vales Force', 'web', '2024-09-08 15:12:50', '2024-09-08 15:12:50');
INSERT INTO `permissions` VALUES (52, 'Ver Contratos', 'web', '2024-11-06 12:27:50', '2024-11-06 12:27:50');
INSERT INTO `permissions` VALUES (53, 'Agregar Contratos', 'web', '2024-11-06 12:28:09', '2024-11-06 12:28:09');
INSERT INTO `permissions` VALUES (54, 'Editar Contratos', 'web', '2024-11-06 12:28:21', '2024-11-06 12:28:21');
INSERT INTO `permissions` VALUES (55, 'Eliminar Contratos', 'web', '2024-11-06 12:28:29', '2024-11-06 12:28:29');
INSERT INTO `permissions` VALUES (56, 'Ver Proveedores', 'web', '2024-11-30 17:28:07', '2024-11-30 17:28:07');
INSERT INTO `permissions` VALUES (57, 'Agregar Proveedores', 'web', '2024-11-30 17:28:20', '2024-11-30 17:28:20');
INSERT INTO `permissions` VALUES (58, 'Editar Proveedores', 'web', '2024-11-30 17:28:29', '2024-11-30 17:28:29');
INSERT INTO `permissions` VALUES (59, 'Eliminar Proveedores', 'web', '2024-11-30 17:28:43', '2024-11-30 17:28:43');
INSERT INTO `permissions` VALUES (60, 'Ver Productos', 'web', '2024-11-30 18:23:05', '2024-11-30 18:23:05');
INSERT INTO `permissions` VALUES (61, 'Agregar Productos', 'web', '2024-11-30 18:23:17', '2024-11-30 18:23:17');
INSERT INTO `permissions` VALUES (62, 'Editar Productos', 'web', '2024-11-30 18:23:28', '2024-11-30 18:23:28');
INSERT INTO `permissions` VALUES (63, 'Eliminar Productos', 'web', '2024-11-30 18:23:38', '2024-11-30 18:23:38');
INSERT INTO `permissions` VALUES (64, 'Ver Metas', 'web', '2024-12-01 13:32:03', '2024-12-01 13:32:03');
INSERT INTO `permissions` VALUES (65, 'Agregar Metas', 'web', '2024-12-01 13:32:19', '2024-12-01 13:32:19');
INSERT INTO `permissions` VALUES (66, 'Editar Metas', 'web', '2024-12-01 13:32:26', '2024-12-01 13:32:26');
INSERT INTO `permissions` VALUES (67, 'Eliminar Metas', 'web', '2024-12-01 13:32:35', '2024-12-01 13:32:35');
INSERT INTO `permissions` VALUES (68, 'Ver Actividades', 'web', '2024-12-01 14:03:44', '2024-12-01 14:03:44');
INSERT INTO `permissions` VALUES (69, 'Agregar Actividades', 'web', '2024-12-01 14:03:53', '2024-12-01 14:03:53');
INSERT INTO `permissions` VALUES (70, 'Editar Actividades', 'web', '2024-12-01 14:04:02', '2024-12-01 14:04:02');
INSERT INTO `permissions` VALUES (71, 'Eliminar Actividades', 'web', '2024-12-01 14:04:13', '2024-12-01 14:04:13');
INSERT INTO `permissions` VALUES (72, 'Agregar Detalle Contrato', 'web', '2024-12-03 17:12:12', '2024-12-03 17:12:12');
INSERT INTO `permissions` VALUES (73, 'Eliminar Detalle Contrato', 'web', '2024-12-03 19:55:44', '2024-12-03 19:55:44');
INSERT INTO `permissions` VALUES (74, 'Ver Conductores', 'web', '2024-12-04 12:07:02', '2024-12-04 12:07:02');
INSERT INTO `permissions` VALUES (75, 'Agregar Conductores', 'web', '2024-12-04 16:12:54', '2024-12-04 16:12:54');
INSERT INTO `permissions` VALUES (76, 'Editar Conductores', 'web', '2024-12-04 16:13:04', '2024-12-04 16:13:04');
INSERT INTO `permissions` VALUES (77, 'Eliminar Conductores', 'web', '2024-12-04 16:13:14', '2024-12-04 16:13:14');
INSERT INTO `permissions` VALUES (78, 'Generar Vales', 'web', '2024-12-04 17:35:46', '2024-12-04 17:35:46');
INSERT INTO `permissions` VALUES (79, 'Ver Kardex', 'web', '2024-12-23 22:20:29', '2024-12-23 22:20:29');

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

-- ----------------------------
-- Table structure for personales
-- ----------------------------
CREATE TABLE `personales`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `dni` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `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,
  `area_id` bigint UNSIGNED NOT NULL,
  `estado` enum('ACTIVO','INACTIVO') 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 `personales_area_id_foreign`(`area_id` ASC) USING BTREE,
  CONSTRAINT `personales_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 54 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of personales
-- ----------------------------
INSERT INTO `personales` VALUES (1, '73744393', 'FREDDY WALTER', 'HUAYNAPATA', 'UCHARICO', 2, 'ACTIVO', '2023-11-16 14:12:28', '2023-11-16 19:18:07');
INSERT INTO `personales` VALUES (2, '01296825', 'EFRAIN', 'CONDORI', 'RIVERA', 4, 'ACTIVO', '2023-11-16 19:17:57', '2023-11-16 19:17:57');
INSERT INTO `personales` VALUES (3, '40890937', 'WILBER', 'APAZA', 'MAMANI', 5, 'ACTIVO', '2023-11-16 19:20:23', '2023-12-04 06:27:03');
INSERT INTO `personales` VALUES (4, '01208565', 'AGUSTINA ANTONIA', 'OHA', 'ROMERO', 4, 'ACTIVO', '2023-11-16 19:21:03', '2023-11-16 19:21:03');
INSERT INTO `personales` VALUES (5, '42150716', 'DAVID FRANCO', 'PAREDES', 'MANSILLA', 4, 'ACTIVO', '2023-11-16 19:21:46', '2023-11-16 19:21:46');
INSERT INTO `personales` VALUES (6, '01326844', 'DAVID RICARDO', 'COILA', 'COILA', 4, 'ACTIVO', '2023-11-16 19:22:23', '2023-11-16 19:22:23');
INSERT INTO `personales` VALUES (7, '70206940', 'CRISTIAN ALCIDES', 'QUISPE', 'JAPURA', 4, 'ACTIVO', '2023-11-16 19:23:14', '2023-11-16 19:23:14');
INSERT INTO `personales` VALUES (8, '01324354', 'JUVER DEMETRIO', 'PEÑALOZA', 'GUZMAN', 4, 'ACTIVO', '2023-11-16 19:23:55', '2023-11-16 19:23:55');
INSERT INTO `personales` VALUES (9, '46701528', 'SONIA', 'ROJAS', 'HUANCAPAZA', 2, 'ACTIVO', '2023-11-16 19:24:39', '2023-11-16 19:24:39');
INSERT INTO `personales` VALUES (10, '23834691', 'ROSA GLADYS', 'ARANGOITIA', 'VALDIVIA', 2, 'ACTIVO', '2023-11-16 19:25:23', '2023-11-16 19:25:23');
INSERT INTO `personales` VALUES (11, '09715274', 'ALEJANDRO', 'HUARACHI', 'TITO', 2, 'ACTIVO', '2023-11-16 19:25:51', '2023-11-16 19:25:51');
INSERT INTO `personales` VALUES (12, '01205953', 'RAUL', 'MAMANI', 'ORTEGA', 2, 'ACTIVO', '2023-11-16 19:26:16', '2023-11-16 19:26:16');
INSERT INTO `personales` VALUES (13, '40766056', 'ALAIN ELOY', 'CACERES', 'TITO', 2, 'ACTIVO', '2023-11-16 19:26:54', '2023-11-16 19:26:54');
INSERT INTO `personales` VALUES (14, '29685714', 'FELIX RAMIRO', 'MOYA', 'SANIZO', 2, 'ACTIVO', '2023-11-16 19:27:32', '2023-11-16 19:27:32');
INSERT INTO `personales` VALUES (15, '46897936', 'YURI', 'VALENCIA', 'HUARSAYA', 2, 'ACTIVO', '2023-11-16 19:28:13', '2023-11-16 19:28:13');
INSERT INTO `personales` VALUES (16, '01338160', 'FRANCISCO', 'GUTIERREZ', 'CHALLCO', 2, 'ACTIVO', '2023-11-20 03:32:58', '2023-11-20 03:32:58');
INSERT INTO `personales` VALUES (17, '01778050', 'BEATO LUCIO', 'CASTILLO', 'ARACA', 2, 'ACTIVO', '2023-11-20 03:33:47', '2023-11-20 03:33:47');
INSERT INTO `personales` VALUES (18, '01816005', 'ERNESTO', 'LARICO', 'ROMERO', 2, 'ACTIVO', '2023-11-20 03:34:26', '2023-11-20 03:34:26');
INSERT INTO `personales` VALUES (19, '422005985', 'PEDRO', 'CHOQUE', 'ACERO', 2, 'ACTIVO', '2023-11-20 03:34:57', '2023-11-20 03:34:57');
INSERT INTO `personales` VALUES (20, '40042184', 'ALIZON RICHARD', 'TITO', 'BUSTINZA', 2, 'ACTIVO', '2023-11-20 03:36:06', '2023-11-20 03:36:06');
INSERT INTO `personales` VALUES (21, '45749237', 'HARRY JOEL', 'BARRA', 'JULI', 2, 'ACTIVO', '2023-11-20 03:36:53', '2023-11-20 03:36:53');
INSERT INTO `personales` VALUES (22, '01319959', 'CARLOS ALBERTO', 'ARANIBAR', 'AYLLON', 1, 'ACTIVO', '2023-11-20 03:40:32', '2023-11-20 03:40:32');
INSERT INTO `personales` VALUES (23, '01322309', 'JUDITH', 'COPA', 'JIMENEZ', 1, 'ACTIVO', '2023-11-20 03:41:08', '2023-11-20 03:41:08');
INSERT INTO `personales` VALUES (24, '02445896', 'EVA MARIA', 'LAURA', 'QUISPE', 1, 'ACTIVO', '2023-11-20 03:41:45', '2023-11-20 03:42:12');
INSERT INTO `personales` VALUES (25, '01314922', 'FELIX', 'NINAJA', 'CABRERA', 1, 'ACTIVO', '2023-11-20 03:42:52', '2023-11-20 03:42:52');
INSERT INTO `personales` VALUES (26, '01314782', 'JESUS WILFREDO', 'ZAPANA', 'CHOQUE', 1, 'ACTIVO', '2023-11-20 03:43:35', '2023-11-20 03:43:35');
INSERT INTO `personales` VALUES (27, '01341188', 'EDWIN', 'SAAVEDRA', 'TITO', 1, 'ACTIVO', '2023-11-20 03:44:20', '2023-11-20 03:44:20');
INSERT INTO `personales` VALUES (28, '29595412', 'PABLO RAUL', 'LAZARO', 'LAZARO', 1, 'ACTIVO', '2023-11-20 03:46:30', '2023-11-20 03:46:30');
INSERT INTO `personales` VALUES (29, '72671763', 'GERSON ABAD', 'PEREZ', 'LUQUE', 1, 'ACTIVO', '2023-11-20 05:47:16', '2023-11-20 05:47:16');
INSERT INTO `personales` VALUES (30, '42427783', 'JESUS HENRY', 'RIVERA', 'CAHUYA', 3, 'ACTIVO', '2023-11-20 05:48:02', '2023-11-20 05:48:02');
INSERT INTO `personales` VALUES (31, '01850487', 'MARTIN', 'ROJAS', 'ROSAS', 3, 'ACTIVO', '2023-11-20 05:48:30', '2023-11-20 05:48:30');
INSERT INTO `personales` VALUES (32, '01805244', 'ERNESTO', 'ALANOCA', 'ROQUE', 3, 'ACTIVO', '2023-11-20 05:49:03', '2023-11-20 05:49:03');
INSERT INTO `personales` VALUES (33, '43601245', 'EDGAR DAVID', 'ESCOBAR', 'GINEZ', 2, 'ACTIVO', '2023-11-20 05:49:34', '2024-01-03 15:35:50');
INSERT INTO `personales` VALUES (34, '44664160', 'MILTON', 'ARCE', 'MARQUEZ', 3, 'ACTIVO', '2023-11-20 05:50:03', '2023-11-20 05:50:03');
INSERT INTO `personales` VALUES (35, '45514068', 'HORACIO WILSON', 'UCHARICO', 'URUCHI', 3, 'ACTIVO', '2023-11-20 05:50:45', '2023-11-20 05:50:45');
INSERT INTO `personales` VALUES (36, '01323961', 'HELMER', 'QUISPE', 'TARQUI', 1, 'ACTIVO', '2023-11-23 02:49:51', '2023-11-23 02:49:51');
INSERT INTO `personales` VALUES (37, '01305720', 'CESAR GIOVANY', 'CHAVEZ', 'FLORES', 1, 'ACTIVO', '2023-11-30 09:31:15', '2023-11-30 09:31:15');
INSERT INTO `personales` VALUES (38, '70185013', 'LUIS ENRIQUE', 'CALLI', 'VELASQUEZ', 2, 'ACTIVO', '2024-01-03 10:39:15', '2024-02-12 09:26:29');
INSERT INTO `personales` VALUES (39, '01320209', 'NARDY ROXANA', 'LOZANO', 'AQUICE', 2, 'ACTIVO', '2024-01-03 12:53:28', '2024-01-03 14:51:08');
INSERT INTO `personales` VALUES (40, '01322133', 'LUZ MARINA', 'POMA', 'MAMANI', 1, 'ACTIVO', '2024-02-01 10:03:59', '2024-02-01 10:03:59');
INSERT INTO `personales` VALUES (41, '44669927', 'CRISS ANYELA', 'CASTRO', 'CURASI', 1, 'ACTIVO', '2024-02-01 10:04:33', '2024-02-01 10:04:33');
INSERT INTO `personales` VALUES (42, '01322109', 'DARIO', 'COAQUIRA', 'MONTEAGUDO', 3, 'ACTIVO', '2024-02-09 16:04:43', '2024-02-09 16:04:43');
INSERT INTO `personales` VALUES (43, '013117130', 'RONALDO WALDO', 'GOMEZ', 'POMA', 2, 'ACTIVO', '2024-03-04 11:00:41', '2024-03-04 11:01:03');
INSERT INTO `personales` VALUES (44, '29669539', 'RAUL', 'CAMACHO', 'CORRALES', 1, 'ACTIVO', '2024-03-04 15:05:24', '2024-03-04 15:05:24');
INSERT INTO `personales` VALUES (45, '72399520', 'NATHALY EDITH', 'MAMANI', 'CONTRERAS', 2, 'ACTIVO', '2024-03-15 14:54:16', '2024-03-15 14:54:16');
INSERT INTO `personales` VALUES (46, '70524377', 'MISAEL JAVIER', 'CUEVAS', 'PEREZ', 1, 'ACTIVO', '2024-04-08 08:46:04', '2024-04-08 08:46:04');
INSERT INTO `personales` VALUES (47, '01325619', 'RENE', 'CHECALLA', 'TISNADO', 1, 'ACTIVO', '2024-04-11 10:34:03', '2024-04-11 10:34:03');
INSERT INTO `personales` VALUES (48, '74536859', 'MARIBEL JULIANA', 'TUMI', 'VARGAS', 1, 'ACTIVO', '2024-04-15 09:02:34', '2024-04-15 09:02:34');
INSERT INTO `personales` VALUES (49, '01309606', 'ROSARIO ROXANA', 'DE LA RIVA', 'VALLE', 4, 'ACTIVO', '2024-05-16 17:12:05', '2024-05-16 17:12:05');
INSERT INTO `personales` VALUES (50, '01325751', 'MARILUZ SOFIA', 'QUILCA', 'QUISPE', 1, 'ACTIVO', '2024-05-28 11:05:32', '2024-05-28 11:05:32');
INSERT INTO `personales` VALUES (51, '01338481', 'WILVEOR JULIO', 'QUIÑONEZ', 'FLORES', 1, 'ACTIVO', '2024-06-04 17:12:26', '2024-06-04 17:12:26');
INSERT INTO `personales` VALUES (52, '70206905', 'JUAN ALBERTO', 'HUANCA', 'PERALTA', 2, 'ACTIVO', '2024-07-01 18:16:01', '2024-09-11 09:56:57');
INSERT INTO `personales` VALUES (53, '71790656', 'CINTHYA CLEOFE', 'CARITA', 'UCHARICO', 2, 'ACTIVO', '2024-08-20 17:44:10', '2024-08-20 17:44:10');

-- ----------------------------
-- Table structure for productos
-- ----------------------------
CREATE TABLE `productos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipo_combustible` enum('DIESEL','PREMIUM','REGULAR') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `unidad_medida` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `marca` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stock_total` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `stock_minimo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `estado_stock` enum('ACTIVO','INACTIVO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'ACTIVO',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of productos
-- ----------------------------
INSERT INTO `productos` VALUES (1, '0001', 'GASOLINA REGULAR 90 CT', 'DIESEL', 'GALON', 'REPSOL', '100', '10', 'ACTIVO', '2024-11-30 18:40:47', '2024-12-10 12:03:37');
INSERT INTO `productos` VALUES (3, '0012', 'GASOHOL REGULAR', 'DIESEL', 'GALON', 'RESPSOL', '100', '10', 'ACTIVO', '2024-12-16 14:57:33', '2024-12-25 20:27:22');
INSERT INTO `productos` VALUES (4, '00124', 'DIESEL B5', 'PREMIUM', 'GALON', 'RESPOL', NULL, NULL, NULL, '2024-12-16 14:58:06', '2024-12-25 21:32:12');

-- ----------------------------
-- Table structure for proveedores
-- ----------------------------
CREATE TABLE `proveedores`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `ruc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `razon_social` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `telefono` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `correo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado` enum('ACTIVO','INACTIVO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVO',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of proveedores
-- ----------------------------
INSERT INTO `proveedores` VALUES (3, '10737443936', 'EFRAIN CONDORI RIVERA', 'JR. 31 DE MARZO S/N', '9852354512', 'ue308@gmail.com', 'ACTIVO', '2024-11-30 17:33:06', '2024-11-30 17:33:06');
INSERT INTO `proveedores` VALUES (4, '645132', 'FREDDY WALTER HUAYNAPATA UCHARICO', 'JR. 31 DE MARZO S/N', '918360119', 'soto@gmail.com', 'ACTIVO', '2024-12-09 15:31:22', '2024-12-09 15:31:22');
INSERT INTO `proveedores` VALUES (5, '20121542151', 'Grifos Espinoza S.A.', 'JR. 31 DE MARZO S/N', '9852354512', 'ue308@gmail.com', 'ACTIVO', '2024-12-16 14:59:27', '2024-12-16 14:59:27');
INSERT INTO `proveedores` VALUES (6, '203423923', 'Grifo Reyes Car', 'Jr. Avelino 234', '932321293', 'orueb@gmail.com', 'ACTIVO', '2024-12-22 20:10:19', '2024-12-22 20:10:19');

-- ----------------------------
-- 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 (5, 8);
INSERT INTO `role_has_permissions` VALUES (6, 8);
INSERT INTO `role_has_permissions` VALUES (7, 8);
INSERT INTO `role_has_permissions` VALUES (8, 8);
INSERT INTO `role_has_permissions` VALUES (9, 8);
INSERT INTO `role_has_permissions` VALUES (10, 8);
INSERT INTO `role_has_permissions` VALUES (11, 8);
INSERT INTO `role_has_permissions` VALUES (12, 8);
INSERT INTO `role_has_permissions` VALUES (13, 8);
INSERT INTO `role_has_permissions` VALUES (14, 8);
INSERT INTO `role_has_permissions` VALUES (15, 8);
INSERT INTO `role_has_permissions` VALUES (16, 8);
INSERT INTO `role_has_permissions` VALUES (17, 8);
INSERT INTO `role_has_permissions` VALUES (18, 8);
INSERT INTO `role_has_permissions` VALUES (19, 8);
INSERT INTO `role_has_permissions` VALUES (20, 8);
INSERT INTO `role_has_permissions` VALUES (21, 8);
INSERT INTO `role_has_permissions` VALUES (22, 8);
INSERT INTO `role_has_permissions` VALUES (23, 8);
INSERT INTO `role_has_permissions` VALUES (24, 8);
INSERT INTO `role_has_permissions` VALUES (25, 8);
INSERT INTO `role_has_permissions` VALUES (26, 8);
INSERT INTO `role_has_permissions` VALUES (27, 8);
INSERT INTO `role_has_permissions` VALUES (28, 8);
INSERT INTO `role_has_permissions` VALUES (29, 8);
INSERT INTO `role_has_permissions` VALUES (30, 8);
INSERT INTO `role_has_permissions` VALUES (31, 8);
INSERT INTO `role_has_permissions` VALUES (32, 8);
INSERT INTO `role_has_permissions` VALUES (33, 8);
INSERT INTO `role_has_permissions` VALUES (34, 8);
INSERT INTO `role_has_permissions` VALUES (35, 8);
INSERT INTO `role_has_permissions` VALUES (36, 8);
INSERT INTO `role_has_permissions` VALUES (36, 9);
INSERT INTO `role_has_permissions` VALUES (36, 16);
INSERT INTO `role_has_permissions` VALUES (37, 8);
INSERT INTO `role_has_permissions` VALUES (38, 9);
INSERT INTO `role_has_permissions` VALUES (39, 9);
INSERT INTO `role_has_permissions` VALUES (40, 8);
INSERT INTO `role_has_permissions` VALUES (40, 9);
INSERT INTO `role_has_permissions` VALUES (40, 15);
INSERT INTO `role_has_permissions` VALUES (40, 16);
INSERT INTO `role_has_permissions` VALUES (41, 8);
INSERT INTO `role_has_permissions` VALUES (41, 9);
INSERT INTO `role_has_permissions` VALUES (41, 16);
INSERT INTO `role_has_permissions` VALUES (42, 8);
INSERT INTO `role_has_permissions` VALUES (42, 9);
INSERT INTO `role_has_permissions` VALUES (42, 16);
INSERT INTO `role_has_permissions` VALUES (43, 8);
INSERT INTO `role_has_permissions` VALUES (43, 9);
INSERT INTO `role_has_permissions` VALUES (44, 8);
INSERT INTO `role_has_permissions` VALUES (44, 9);
INSERT INTO `role_has_permissions` VALUES (45, 8);
INSERT INTO `role_has_permissions` VALUES (45, 9);
INSERT INTO `role_has_permissions` VALUES (46, 8);
INSERT INTO `role_has_permissions` VALUES (46, 9);
INSERT INTO `role_has_permissions` VALUES (46, 16);
INSERT INTO `role_has_permissions` VALUES (47, 8);
INSERT INTO `role_has_permissions` VALUES (48, 8);
INSERT INTO `role_has_permissions` VALUES (50, 8);
INSERT INTO `role_has_permissions` VALUES (50, 9);
INSERT INTO `role_has_permissions` VALUES (50, 16);
INSERT INTO `role_has_permissions` VALUES (52, 8);
INSERT INTO `role_has_permissions` VALUES (52, 16);
INSERT INTO `role_has_permissions` VALUES (53, 8);
INSERT INTO `role_has_permissions` VALUES (54, 8);
INSERT INTO `role_has_permissions` VALUES (55, 8);
INSERT INTO `role_has_permissions` VALUES (56, 8);
INSERT INTO `role_has_permissions` VALUES (57, 8);
INSERT INTO `role_has_permissions` VALUES (58, 8);
INSERT INTO `role_has_permissions` VALUES (59, 8);
INSERT INTO `role_has_permissions` VALUES (60, 8);
INSERT INTO `role_has_permissions` VALUES (61, 8);
INSERT INTO `role_has_permissions` VALUES (62, 8);
INSERT INTO `role_has_permissions` VALUES (63, 8);
INSERT INTO `role_has_permissions` VALUES (64, 8);
INSERT INTO `role_has_permissions` VALUES (65, 8);
INSERT INTO `role_has_permissions` VALUES (66, 8);
INSERT INTO `role_has_permissions` VALUES (67, 8);
INSERT INTO `role_has_permissions` VALUES (68, 8);
INSERT INTO `role_has_permissions` VALUES (69, 8);
INSERT INTO `role_has_permissions` VALUES (70, 8);
INSERT INTO `role_has_permissions` VALUES (71, 8);
INSERT INTO `role_has_permissions` VALUES (72, 8);
INSERT INTO `role_has_permissions` VALUES (73, 8);
INSERT INTO `role_has_permissions` VALUES (74, 8);
INSERT INTO `role_has_permissions` VALUES (75, 8);
INSERT INTO `role_has_permissions` VALUES (76, 8);
INSERT INTO `role_has_permissions` VALUES (77, 8);
INSERT INTO `role_has_permissions` VALUES (78, 8);
INSERT INTO `role_has_permissions` VALUES (79, 8);

-- ----------------------------
-- 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 = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (8, 'Administrador', 'web', '2024-08-29 16:21:03', '2024-08-29 16:21:03');
INSERT INTO `roles` VALUES (9, 'Jefatura', 'web', '2024-08-29 16:21:11', '2024-08-29 16:21:11');
INSERT INTO `roles` VALUES (15, 'Usuario', 'web', '2024-09-01 10:26:49', '2024-09-01 10:26:49');
INSERT INTO `roles` VALUES (16, 'Operador', 'web', '2024-09-01 10:34:23', '2024-09-01 10:34:23');

-- ----------------------------
-- Table structure for rutas
-- ----------------------------
CREATE TABLE `rutas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tipo_id` bigint UNSIGNED NOT NULL,
  `partida` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `destino` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `llegada` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado` enum('ACTIVO','INACTIVO') 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 `rutas_tipo_id_foreign`(`tipo_id` ASC) USING BTREE,
  CONSTRAINT `rutas_tipo_id_foreign` FOREIGN KEY (`tipo_id`) REFERENCES `tipo_rutas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 274 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of rutas
-- ----------------------------
INSERT INTO `rutas` VALUES (1, 2, 'YUNGUYO', 'ANAPIA', 'YUNGUYO', 'ACTIVO', '2023-11-20 05:59:11', '2023-11-20 05:59:11');
INSERT INTO `rutas` VALUES (2, 2, 'YUNGUYO', 'COPANI', 'YUNGUYO', 'ACTIVO', '2023-11-20 05:59:35', '2023-11-20 05:59:35');
INSERT INTO `rutas` VALUES (3, 2, 'YUNGUYO', 'CUTURAPI', 'YUNGUYO', 'ACTIVO', '2023-11-20 05:59:50', '2023-11-20 05:59:50');
INSERT INTO `rutas` VALUES (4, 2, 'YUNGUYO', 'OLLARAYA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:00:05', '2023-11-20 06:00:05');
INSERT INTO `rutas` VALUES (5, 2, 'YUNGUYO', 'TINICACHI', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:00:23', '2023-11-20 06:00:23');
INSERT INTO `rutas` VALUES (6, 2, 'YUNGUYO', 'UNICACHI', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:00:44', '2023-11-20 06:00:44');
INSERT INTO `rutas` VALUES (7, 2, 'YUNGUYO', 'ZONAS RURALES', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:01:08', '2023-11-20 06:01:08');
INSERT INTO `rutas` VALUES (8, 2, 'YUNGUYO', 'ZONAS URBANAS', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:01:22', '2023-11-20 06:01:22');
INSERT INTO `rutas` VALUES (9, 3, 'YUNGUYO', 'AZANGARO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:01:44', '2023-11-20 06:01:44');
INSERT INTO `rutas` VALUES (10, 3, 'YUNGUYO', 'CARABAYA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:01:56', '2023-11-20 06:01:56');
INSERT INTO `rutas` VALUES (11, 3, 'YUNGUYO', 'CHUCUITO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:02:11', '2023-11-20 06:02:11');
INSERT INTO `rutas` VALUES (12, 3, 'YUNGUYO', 'EL COLLAO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:02:27', '2023-11-20 06:02:27');
INSERT INTO `rutas` VALUES (13, 3, 'YUNGUYO', 'HUANCANE', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:02:40', '2023-11-20 06:02:40');
INSERT INTO `rutas` VALUES (14, 3, 'YUNGUYO', 'LAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:02:54', '2023-11-20 06:02:54');
INSERT INTO `rutas` VALUES (15, 3, 'YUNGUYO', 'MELGAR', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:03:08', '2023-11-20 06:03:08');
INSERT INTO `rutas` VALUES (16, 3, 'YUNGUYO', 'MOHO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:03:18', '2023-11-20 06:03:18');
INSERT INTO `rutas` VALUES (17, 3, 'YUNGUYO', 'PUNO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:03:31', '2023-11-20 06:03:31');
INSERT INTO `rutas` VALUES (18, 3, 'YUNGUYO', 'SAN ANTONIO DE PUTINA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:03:57', '2023-11-20 06:03:57');
INSERT INTO `rutas` VALUES (19, 3, 'YUNGUYO', 'SAN ROMAN', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:04:18', '2023-11-20 06:04:18');
INSERT INTO `rutas` VALUES (20, 3, 'YUNGUYO', 'SANDIA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:04:31', '2023-11-20 06:04:31');
INSERT INTO `rutas` VALUES (21, 4, 'YUNGUYO', 'TACNA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:05:03', '2023-11-20 06:05:03');
INSERT INTO `rutas` VALUES (22, 4, 'YUNGUYO', 'AREQUIPA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:05:17', '2023-11-20 06:05:17');
INSERT INTO `rutas` VALUES (23, 4, 'YUNGUYO', 'LIMA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:05:27', '2023-11-20 06:05:27');
INSERT INTO `rutas` VALUES (24, 4, 'YUNGUYO', 'CUSCO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:05:38', '2023-11-20 06:05:38');
INSERT INTO `rutas` VALUES (25, 1, 'YUNGUYO', 'YUNGUYO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:05:59', '2023-11-20 06:05:59');
INSERT INTO `rutas` VALUES (26, 1, 'YUNGUYO', 'KASANI', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:06:36', '2023-11-20 06:06:36');
INSERT INTO `rutas` VALUES (27, 1, 'YUNGUYO', 'APILLANI', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:06:53', '2023-11-20 06:06:53');
INSERT INTO `rutas` VALUES (28, 1, 'YUNGUYO', 'CHAMAJAHUIRA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:07:08', '2023-11-20 06:07:08');
INSERT INTO `rutas` VALUES (29, 1, 'YUNGUYO', 'SAN JUAN DE TOTORA SEGUNDO SEC', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:07:34', '2023-11-20 06:07:34');
INSERT INTO `rutas` VALUES (30, 1, 'YUNGUYO', 'SAN JUAN DE TOTORA PRIMER SECT', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:07:51', '2023-11-20 06:07:51');
INSERT INTO `rutas` VALUES (31, 1, 'YUNGUYO', 'ESPIRITU SANTO MULLUNI', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:08:07', '2023-11-20 06:08:07');
INSERT INTO `rutas` VALUES (32, 1, 'YUNGUYO', 'ESPIRITU SANTO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:08:24', '2023-11-20 06:08:24');
INSERT INTO `rutas` VALUES (33, 1, 'YUNGUYO', 'ESPIRITU SANTO KANTA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:08:37', '2023-11-20 06:08:37');
INSERT INTO `rutas` VALUES (34, 1, 'YUNGUYO', 'COLLEPATA AYCHUYO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:08:55', '2023-11-20 06:08:55');
INSERT INTO `rutas` VALUES (35, 1, 'YUNGUYO', 'ALTO AYCHUYO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:09:12', '2023-11-20 06:09:12');
INSERT INTO `rutas` VALUES (36, 1, 'YUNGUYO', 'CALLACAMI AYCHUYO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:09:30', '2023-11-20 06:09:30');
INSERT INTO `rutas` VALUES (37, 1, 'YUNGUYO', 'CENTRAL AYCHUYO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:09:45', '2023-11-20 06:09:45');
INSERT INTO `rutas` VALUES (38, 1, 'YUNGUYO', 'VILLAMAR AYCHUYO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:10:02', '2023-11-20 06:10:02');
INSERT INTO `rutas` VALUES (39, 1, 'YUNGUYO', 'THI HIRAMA TAPOJE', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:10:16', '2023-11-20 06:10:16');
INSERT INTO `rutas` VALUES (40, 1, 'YUNGUYO', 'PAJANA SAN AGUSTIN', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:10:47', '2023-11-20 06:10:47');
INSERT INTO `rutas` VALUES (41, 1, 'YUNGUYO', 'CHAJELLAPI (PUERTO TAPOJE)', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:11:00', '2023-11-20 06:11:00');
INSERT INTO `rutas` VALUES (42, 1, 'YUNGUYO', 'POCCONA 25 DE JULIO', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:11:22', '2023-11-20 06:11:22');
INSERT INTO `rutas` VALUES (43, 1, 'YUNGUYO', 'CHALLAPATA', 'YUNGUYO', 'ACTIVO', '2023-11-20 06:11:39', '2023-11-20 06:11:39');
INSERT INTO `rutas` VALUES (44, 1, 'YUNGUYO', 'PUQUIRE', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:27:08', '2023-11-21 03:27:08');
INSERT INTO `rutas` VALUES (45, 1, 'YUNGUYO', 'CHALLAPAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:36:38', '2023-11-21 03:36:38');
INSERT INTO `rutas` VALUES (46, 1, 'YUNGUYO', 'NUEVA AMERICA', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:37:01', '2023-11-21 03:37:01');
INSERT INTO `rutas` VALUES (47, 1, 'YUNGUYO', 'GUARAVIRE', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:39:41', '2023-11-21 03:39:41');
INSERT INTO `rutas` VALUES (48, 1, 'YUNGUYO', 'CHOCAQUE', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:40:25', '2023-11-21 03:40:25');
INSERT INTO `rutas` VALUES (49, 1, 'YUNGUYO', 'CHAMBI SANTA CRUZ', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:40:34', '2023-11-21 03:40:34');
INSERT INTO `rutas` VALUES (50, 1, 'YUNGUYO', 'SAN JUAN DE MIRAFLORES', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:45:43', '2023-11-21 03:45:43');
INSERT INTO `rutas` VALUES (51, 1, 'YUNGUYO', 'CHACAPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:47:03', '2023-11-21 03:47:03');
INSERT INTO `rutas` VALUES (52, 1, 'YUNGUYO', 'QUEÑUANI INDEPENDENCIA', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:47:14', '2023-11-21 03:47:14');
INSERT INTO `rutas` VALUES (53, 1, 'YUNGUYO', 'QUEÑUANI CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:47:28', '2023-11-21 03:47:28');
INSERT INTO `rutas` VALUES (54, 1, 'YUNGUYO', 'ACARI CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:47:41', '2023-11-21 03:47:41');
INSERT INTO `rutas` VALUES (55, 1, 'YUNGUYO', 'IMICATE', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:47:50', '2023-11-21 03:47:50');
INSERT INTO `rutas` VALUES (56, 1, 'YUNGUYO', 'HUNUMANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:48:09', '2023-11-21 03:48:09');
INSERT INTO `rutas` VALUES (57, 1, 'YUNGUYO', 'ALFONSO UGARTE', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:48:19', '2023-11-21 03:48:19');
INSERT INTO `rutas` VALUES (58, 1, 'YUNGUYO', 'CHAMBI QUIMSA CRUZ', 'YUNGUYO', 'ACTIVO', '2023-11-21 03:48:30', '2023-11-21 03:48:30');
INSERT INTO `rutas` VALUES (59, 1, 'YUNGUYO', 'CHOQUECHACA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:41:48', '2023-11-21 05:41:48');
INSERT INTO `rutas` VALUES (60, 1, 'YUNGUYO', 'POTOKALA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:42:00', '2023-11-21 05:42:00');
INSERT INTO `rutas` VALUES (61, 1, 'YUNGUYO', 'TUNCASI CHINUMANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:42:12', '2023-11-21 05:42:12');
INSERT INTO `rutas` VALUES (62, 1, 'YUNGUYO', 'INGAVI CHINUMANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:42:23', '2023-11-21 05:42:23');
INSERT INTO `rutas` VALUES (63, 1, 'YUNGUYO', 'COPAPUJO CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:42:33', '2023-11-21 05:42:33');
INSERT INTO `rutas` VALUES (64, 1, 'YUNGUYO', 'JANCOPUJO CHINUMANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:42:51', '2023-11-21 05:42:51');
INSERT INTO `rutas` VALUES (65, 1, 'YUNGUYO', 'JURANA YANAPATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:43:06', '2023-11-21 05:43:06');
INSERT INTO `rutas` VALUES (66, 1, 'YUNGUYO', 'KILY YANAPATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:43:17', '2023-11-21 05:43:17');
INSERT INTO `rutas` VALUES (67, 1, 'YUNGUYO', 'YACACHI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:43:34', '2023-11-21 05:43:34');
INSERT INTO `rutas` VALUES (68, 1, 'YUNGUYO', 'CANINSAYA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:43:46', '2023-11-21 05:43:46');
INSERT INTO `rutas` VALUES (69, 1, 'YUNGUYO', 'WILAMAYA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:44:05', '2023-11-21 05:44:05');
INSERT INTO `rutas` VALUES (70, 1, 'YUNGUYO', 'SANTA ROSA CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:44:15', '2023-11-21 05:44:15');
INSERT INTO `rutas` VALUES (71, 1, 'YUNGUYO', 'SANTA ROSA SACACATANI 2', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:44:25', '2023-11-21 05:44:25');
INSERT INTO `rutas` VALUES (72, 1, 'YUNGUYO', 'SANTA ROSA CALUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:44:46', '2023-11-21 05:44:46');
INSERT INTO `rutas` VALUES (73, 1, 'YUNGUYO', 'SANTA ROSA SACACATANI 1', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:45:28', '2023-11-21 05:45:28');
INSERT INTO `rutas` VALUES (74, 1, 'YUNGUYO', 'PINAZO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:45:38', '2023-11-21 05:45:38');
INSERT INTO `rutas` VALUES (75, 1, 'YUNGUYO', 'MACHACMARCA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:45:49', '2023-11-21 05:45:49');
INSERT INTO `rutas` VALUES (76, 1, 'YUNGUYO', 'TAHUACO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:45:58', '2023-11-21 05:45:58');
INSERT INTO `rutas` VALUES (77, 1, 'YUNGUYO', 'SANQUIRA CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:46:08', '2023-11-21 05:46:08');
INSERT INTO `rutas` VALUES (78, 1, 'YUNGUYO', 'SANQUIRA MACHACUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:46:17', '2023-11-21 05:46:17');
INSERT INTO `rutas` VALUES (79, 1, 'YUNGUYO', 'CHICANIHUMA BAJO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:46:43', '2023-11-21 05:46:43');
INSERT INTO `rutas` VALUES (80, 1, 'YUNGUYO', 'CHICANIHUMA ALTO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:46:52', '2023-11-21 05:46:52');
INSERT INTO `rutas` VALUES (81, 1, 'YUNGUYO', 'KORCORI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:47:01', '2023-11-21 05:47:01');
INSERT INTO `rutas` VALUES (82, 1, 'YUNGUYO', 'INGAVE', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:47:12', '2023-11-21 05:47:12');
INSERT INTO `rutas` VALUES (83, 1, 'YUNGUYO', 'CALAMPUNI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:47:21', '2023-11-21 05:47:21');
INSERT INTO `rutas` VALUES (84, 1, 'YUNGUYO', 'POCCONA SUMAPUJO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:47:35', '2023-11-21 05:47:35');
INSERT INTO `rutas` VALUES (85, 1, 'YUNGUYO', 'TOTORA JAHUIRA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:47:44', '2023-11-21 05:47:44');
INSERT INTO `rutas` VALUES (86, 1, 'YUNGUYO', 'ALTO SAN JOSE', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:47:52', '2023-11-21 05:47:52');
INSERT INTO `rutas` VALUES (87, 1, 'YUNGUYO', 'SAN JUAN DE TOTORA TERCER SECT', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:48:06', '2023-11-21 05:48:06');
INSERT INTO `rutas` VALUES (88, 1, 'YUNGUYO', 'YAURINAZA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:48:22', '2023-11-21 05:48:22');
INSERT INTO `rutas` VALUES (89, 1, 'YUNGUYO', 'SAN FRANCISCO DE AYCHUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:48:32', '2023-11-21 05:48:32');
INSERT INTO `rutas` VALUES (90, 1, 'YUNGUYO', 'KEHUARI OCALLASI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:48:46', '2023-11-21 05:48:46');
INSERT INTO `rutas` VALUES (91, 1, 'YUNGUYO', 'AYNACHA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:49:07', '2023-11-21 05:49:07');
INSERT INTO `rutas` VALUES (92, 1, 'YUNGUYO', 'CHAJLLAPI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:49:19', '2023-11-21 05:49:19');
INSERT INTO `rutas` VALUES (93, 1, 'YUNGUYO', 'KARACOTAÑA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:49:31', '2023-11-21 05:49:31');
INSERT INTO `rutas` VALUES (94, 1, 'YUNGUYO', 'RIO PROGRESO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:49:40', '2023-11-21 05:49:40');
INSERT INTO `rutas` VALUES (95, 1, 'YUNGUYO', 'ALMACIRCA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:49:48', '2023-11-21 05:49:48');
INSERT INTO `rutas` VALUES (96, 1, 'YUNGUYO', 'PANAMERICANA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:50:47', '2023-11-21 05:50:47');
INSERT INTO `rutas` VALUES (97, 1, 'YUNGUYO', 'RIO DE LA PLATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:50:58', '2023-11-21 05:50:58');
INSERT INTO `rutas` VALUES (98, 1, 'YUNGUYO', 'KOLLE CCOLLINE', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:51:08', '2023-11-21 05:51:08');
INSERT INTO `rutas` VALUES (99, 1, 'YUNGUYO', 'JAQUICUCHO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:51:16', '2023-11-21 05:51:16');
INSERT INTO `rutas` VALUES (100, 1, 'YUNGUYO', 'QUINTANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:51:25', '2023-11-21 05:51:25');
INSERT INTO `rutas` VALUES (101, 1, 'YUNGUYO', 'NEQUENTIRE', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:51:38', '2023-11-21 05:51:38');
INSERT INTO `rutas` VALUES (102, 1, 'YUNGUYO', 'KAIRANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:51:51', '2023-11-21 05:51:51');
INSERT INTO `rutas` VALUES (103, 1, 'YUNGUYO', 'PORTEÑO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:52:01', '2023-11-21 05:52:01');
INSERT INTO `rutas` VALUES (104, 1, 'YUNGUYO', 'VISTA ALEGRE', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:52:12', '2023-11-21 05:52:12');
INSERT INTO `rutas` VALUES (105, 1, 'YUNGUYO', 'SIMON BOLIVAR', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:52:20', '2023-11-21 05:52:20');
INSERT INTO `rutas` VALUES (106, 1, 'YUNGUYO', 'PINO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:52:31', '2023-11-21 05:52:31');
INSERT INTO `rutas` VALUES (107, 1, 'YUNGUYO', 'PROGRESO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:52:39', '2023-11-21 05:52:39');
INSERT INTO `rutas` VALUES (108, 1, 'YUNGUYO', 'SAN MARTIN', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:52:47', '2023-11-21 05:52:47');
INSERT INTO `rutas` VALUES (109, 1, 'YUNGUYO', 'MIRAFLORES', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:52:59', '2023-11-21 05:52:59');
INSERT INTO `rutas` VALUES (110, 1, 'YUNGUYO', '28 DE JULIO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:53:09', '2023-11-21 05:53:09');
INSERT INTO `rutas` VALUES (111, 1, 'YUNGUYO', 'UMAPULLOLLO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:53:23', '2023-11-21 05:53:23');
INSERT INTO `rutas` VALUES (112, 1, 'YUNGUYO', '1 DE MAYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:54:35', '2023-11-21 05:54:35');
INSERT INTO `rutas` VALUES (113, 1, 'YUNGUYO', 'CHOQUECHACA VALLECITO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:54:45', '2023-11-21 05:54:45');
INSERT INTO `rutas` VALUES (114, 1, 'YUNGUYO', 'INGLESHUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:54:58', '2023-11-21 05:54:58');
INSERT INTO `rutas` VALUES (115, 1, 'YUNGUYO', 'TISNUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:55:10', '2023-11-21 05:55:10');
INSERT INTO `rutas` VALUES (116, 1, 'YUNGUYO', 'MACHACHUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:55:24', '2023-11-21 05:55:24');
INSERT INTO `rutas` VALUES (117, 1, 'YUNGUYO', 'VISTA ALEGRE', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:55:35', '2023-11-21 05:55:35');
INSERT INTO `rutas` VALUES (118, 1, 'YUNGUYO', 'MIRAFLORES', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:55:45', '2023-11-21 05:55:45');
INSERT INTO `rutas` VALUES (119, 1, 'YUNGUYO', 'JURANA SANTA ROSA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:55:55', '2023-11-21 05:55:55');
INSERT INTO `rutas` VALUES (120, 1, 'YUNGUYO', 'SUPACACHI VIENTO', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:56:08', '2023-11-21 05:56:08');
INSERT INTO `rutas` VALUES (121, 1, 'YUNGUYO', 'ESPIRITU VILQUE', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:56:17', '2023-11-21 05:56:17');
INSERT INTO `rutas` VALUES (122, 1, 'YUNGUYO', 'HUARANAMAYA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:56:25', '2023-11-21 05:56:25');
INSERT INTO `rutas` VALUES (123, 1, 'YUNGUYO', 'KOYE PAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:56:35', '2023-11-21 05:56:35');
INSERT INTO `rutas` VALUES (124, 1, 'YUNGUYO', 'YANAPATA CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:56:46', '2023-11-21 05:56:46');
INSERT INTO `rutas` VALUES (125, 1, 'YUNGUYO', 'SAN ROQUE', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:56:57', '2023-11-21 05:56:57');
INSERT INTO `rutas` VALUES (126, 1, 'YUNGUYO', 'SANQUIRA NUEVA BELLAVISTA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:57:07', '2023-11-21 05:57:07');
INSERT INTO `rutas` VALUES (127, 1, 'YUNGUYO', 'SANQUIRA UJANAPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:57:16', '2023-11-21 05:57:16');
INSERT INTO `rutas` VALUES (128, 1, 'YUNGUYO', 'SANQUIRA PATACAYAYA CIRCAYATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:57:30', '2023-11-21 05:57:30');
INSERT INTO `rutas` VALUES (129, 1, 'YUNGUYO', 'KALAPALLALLA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:57:41', '2023-11-21 05:57:41');
INSERT INTO `rutas` VALUES (130, 1, 'YUNGUYO', 'HUAYCHANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:57:51', '2023-11-21 05:57:51');
INSERT INTO `rutas` VALUES (131, 1, 'YUNGUYO', 'HUANCARANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:58:02', '2023-11-21 05:58:02');
INSERT INTO `rutas` VALUES (132, 1, 'YUNGUYO', 'ZAPATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:58:23', '2023-11-21 05:58:23');
INSERT INTO `rutas` VALUES (133, 1, 'YUNGUYO', 'CHOQUECACHA CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:58:35', '2023-11-21 05:58:35');
INSERT INTO `rutas` VALUES (134, 1, 'YUNGUYO', 'CHALLIRI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:58:43', '2023-11-21 05:58:43');
INSERT INTO `rutas` VALUES (135, 1, 'YUNGUYO', 'YAJAHIRAMA PUERTO TAPOJE', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:58:54', '2023-11-21 05:58:54');
INSERT INTO `rutas` VALUES (136, 1, 'YUNGUYO', 'COANIHUYO CHINUMANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:59:02', '2023-11-21 05:59:02');
INSERT INTO `rutas` VALUES (137, 1, 'YUNGUYO', 'KANAMAYA', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:59:11', '2023-11-21 05:59:11');
INSERT INTO `rutas` VALUES (138, 1, 'YUNGUYO', 'QUEÑUANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:59:19', '2023-11-21 05:59:19');
INSERT INTO `rutas` VALUES (139, 1, 'YUNGUYO', 'JANCKU JANCKU', 'YUNGUYO', 'ACTIVO', '2023-11-21 05:59:29', '2023-11-21 05:59:29');
INSERT INTO `rutas` VALUES (140, 1, 'YUNGUYO', 'JENKELLUISA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:00:46', '2023-11-21 06:00:46');
INSERT INTO `rutas` VALUES (141, 1, 'YUNGUYO', 'POCCONA PRIMERO DE MAYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:00:55', '2023-11-21 06:00:55');
INSERT INTO `rutas` VALUES (142, 1, 'YUNGUYO', 'JOKEHUIRATO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:01:03', '2023-11-21 06:01:03');
INSERT INTO `rutas` VALUES (143, 1, 'YUNGUYO', 'ISKPA PATAA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:01:11', '2023-11-21 06:01:11');
INSERT INTO `rutas` VALUES (144, 1, 'YUNGUYO', 'ANAPIA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:01:21', '2023-11-21 06:01:21');
INSERT INTO `rutas` VALUES (145, 1, 'YUNGUYO', 'CAANA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:01:30', '2023-11-21 06:01:30');
INSERT INTO `rutas` VALUES (146, 1, 'YUNGUYO', 'PAMPACCATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:07:49', '2023-11-21 06:07:49');
INSERT INTO `rutas` VALUES (147, 1, 'YUNGUYO', 'SIPSIPAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:08:00', '2023-11-21 06:08:00');
INSERT INTO `rutas` VALUES (148, 1, 'YUNGUYO', 'YAMPUPATA HUENCALLA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:08:09', '2023-11-21 06:08:09');
INSERT INTO `rutas` VALUES (149, 1, 'YUNGUYO', 'KASAPAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:08:18', '2023-11-21 06:08:18');
INSERT INTO `rutas` VALUES (150, 1, 'YUNGUYO', 'KELE', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:08:27', '2023-11-21 06:08:27');
INSERT INTO `rutas` VALUES (151, 1, 'YUNGUYO', 'UTAPUJRUPAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:08:36', '2023-11-21 06:08:36');
INSERT INTO `rutas` VALUES (152, 1, 'YUNGUYO', 'YANISTIPAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:08:44', '2023-11-21 06:08:44');
INSERT INTO `rutas` VALUES (153, 1, 'YUNGUYO', 'CAÑO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:11:13', '2023-11-21 06:11:13');
INSERT INTO `rutas` VALUES (154, 1, 'YUNGUYO', 'SUANA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:11:21', '2023-11-21 06:11:21');
INSERT INTO `rutas` VALUES (155, 1, 'YUNGUYO', 'PATA HUATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:11:30', '2023-11-21 06:11:30');
INSERT INTO `rutas` VALUES (156, 1, 'YUNGUYO', 'CHIRUAKA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:11:41', '2023-11-21 06:11:41');
INSERT INTO `rutas` VALUES (157, 1, 'YUNGUYO', 'KESKAPI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:12:13', '2023-11-21 06:12:13');
INSERT INTO `rutas` VALUES (158, 1, 'YUNGUYO', 'TINAKACHI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:12:21', '2023-11-21 06:12:21');
INSERT INTO `rutas` VALUES (159, 1, 'YUNGUYO', 'TARQUI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:12:30', '2023-11-21 06:12:30');
INSERT INTO `rutas` VALUES (160, 1, 'YUNGUYO', 'KANTUTANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:12:55', '2023-11-21 06:12:55');
INSERT INTO `rutas` VALUES (161, 1, 'YUNGUYO', 'CALACOTO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:13:05', '2023-11-21 06:13:05');
INSERT INTO `rutas` VALUES (162, 1, 'YUNGUYO', 'HUAYLLANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:13:20', '2023-11-21 06:13:20');
INSERT INTO `rutas` VALUES (163, 1, 'YUNGUYO', 'AMAQUILLA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:13:29', '2023-11-21 06:13:29');
INSERT INTO `rutas` VALUES (164, 1, 'YUNGUYO', 'TACAPISI (TAMBUYO)', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:13:43', '2023-11-21 06:13:43');
INSERT INTO `rutas` VALUES (165, 1, 'YUNGUYO', 'CHALLAPAMPA CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:13:51', '2023-11-21 06:13:51');
INSERT INTO `rutas` VALUES (166, 1, 'YUNGUYO', 'BELLAVISTA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:13:59', '2023-11-21 06:13:59');
INSERT INTO `rutas` VALUES (167, 1, 'YUNGUYO', 'CCOPANI (CENTRAL)', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:14:08', '2023-11-21 06:14:08');
INSERT INTO `rutas` VALUES (168, 1, 'YUNGUYO', 'PALLCA CATO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:14:20', '2023-11-21 06:14:20');
INSERT INTO `rutas` VALUES (169, 1, 'YUNGUYO', 'ACHAQUE', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:14:28', '2023-11-21 06:14:28');
INSERT INTO `rutas` VALUES (170, 1, 'YUNGUYO', 'YOKAYA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:14:37', '2023-11-21 06:14:37');
INSERT INTO `rutas` VALUES (171, 1, 'YUNGUYO', 'CCACORCO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:14:45', '2023-11-21 06:14:45');
INSERT INTO `rutas` VALUES (172, 1, 'YUNGUYO', 'AYRIHUA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:14:53', '2023-11-21 06:14:53');
INSERT INTO `rutas` VALUES (173, 1, 'YUNGUYO', 'QUEAQUEANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:15:01', '2023-11-21 06:15:01');
INSERT INTO `rutas` VALUES (174, 1, 'YUNGUYO', 'AHUIRI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:15:09', '2023-11-21 06:15:09');
INSERT INTO `rutas` VALUES (175, 1, 'YUNGUYO', 'SAJSUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:18:44', '2023-11-21 06:18:44');
INSERT INTO `rutas` VALUES (176, 1, 'YUNGUYO', 'CHURAPAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:18:55', '2023-11-21 06:18:55');
INSERT INTO `rutas` VALUES (177, 1, 'YUNGUYO', 'SANTA ROSA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:21:25', '2023-11-21 06:21:25');
INSERT INTO `rutas` VALUES (178, 1, 'YUNGUYO', 'WECCO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:21:33', '2023-11-21 06:21:33');
INSERT INTO `rutas` VALUES (179, 1, 'YUNGUYO', 'CONDORCOLLO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:21:59', '2023-11-21 06:21:59');
INSERT INTO `rutas` VALUES (180, 1, 'YUNGUYO', 'TAUCAMAYA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:22:07', '2023-11-21 06:22:07');
INSERT INTO `rutas` VALUES (181, 1, 'YUNGUYO', 'QUELLAMAYA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:22:15', '2023-11-21 06:22:15');
INSERT INTO `rutas` VALUES (182, 1, 'YUNGUYO', 'SUCUIHUINCALLA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:23:43', '2023-11-21 06:23:43');
INSERT INTO `rutas` VALUES (183, 1, 'YUNGUYO', 'HUAÑACACHI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:23:51', '2023-11-21 06:23:51');
INSERT INTO `rutas` VALUES (184, 1, 'YUNGUYO', 'CHOJCHONI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:24:00', '2023-11-21 06:24:00');
INSERT INTO `rutas` VALUES (185, 1, 'YUNGUYO', 'SAJSUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:24:09', '2023-11-21 06:24:09');
INSERT INTO `rutas` VALUES (186, 1, 'YUNGUYO', 'HUALLAQUERI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:24:24', '2023-11-21 06:24:24');
INSERT INTO `rutas` VALUES (187, 1, 'YUNGUYO', 'CORCORI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:24:33', '2023-11-21 06:24:33');
INSERT INTO `rutas` VALUES (188, 1, 'YUNGUYO', 'TICUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:24:43', '2023-11-21 06:24:43');
INSERT INTO `rutas` VALUES (189, 1, 'YUNGUYO', 'SAN JUAN DE CUTURAPI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:24:51', '2023-11-21 06:24:51');
INSERT INTO `rutas` VALUES (190, 1, 'YUNGUYO', 'VENTILLA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:24:59', '2023-11-21 06:24:59');
INSERT INTO `rutas` VALUES (191, 1, 'YUNGUYO', 'KANTUTA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:25:06', '2023-11-21 06:25:06');
INSERT INTO `rutas` VALUES (192, 1, 'YUNGUYO', 'INOQAWI (TUPAC AMARU)', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:25:14', '2023-11-21 06:25:14');
INSERT INTO `rutas` VALUES (193, 1, 'YUNGUYO', 'CHACA CIRCA JAWIRA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:25:22', '2023-11-21 06:25:22');
INSERT INTO `rutas` VALUES (194, 1, 'YUNGUYO', 'PHUJO CHALLAWIRA PAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:25:30', '2023-11-21 06:25:30');
INSERT INTO `rutas` VALUES (195, 1, 'YUNGUYO', 'CEWENQAN QUCHO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:25:38', '2023-11-21 06:25:38');
INSERT INTO `rutas` VALUES (196, 1, 'YUNGUYO', 'WINTU SARAWI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:25:45', '2023-11-21 06:25:45');
INSERT INTO `rutas` VALUES (197, 1, 'YUNGUYO', 'CENTRAL PROGRESO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:25:54', '2023-11-21 06:25:54');
INSERT INTO `rutas` VALUES (198, 1, 'YUNGUYO', 'PAMPLONA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:26:08', '2023-11-21 06:26:08');
INSERT INTO `rutas` VALUES (199, 1, 'YUNGUYO', 'CHIMBO CHIMBOTE', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:26:19', '2023-11-21 06:26:19');
INSERT INTO `rutas` VALUES (200, 1, 'YUNGUYO', 'PEÑA FLORIDA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:26:26', '2023-11-21 06:26:26');
INSERT INTO `rutas` VALUES (201, 1, 'YUNGUYO', 'SAN JUAN', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:26:32', '2023-11-21 06:26:32');
INSERT INTO `rutas` VALUES (202, 1, 'YUNGUYO', 'SAN MIGUEL DE OLLARAYA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:26:41', '2023-11-21 06:26:41');
INSERT INTO `rutas` VALUES (203, 1, 'YUNGUYO', 'PUCARA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:26:48', '2023-11-21 06:26:48');
INSERT INTO `rutas` VALUES (204, 1, 'YUNGUYO', 'HUAYLLOJOCCO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:26:55', '2023-11-21 06:26:55');
INSERT INTO `rutas` VALUES (205, 1, 'YUNGUYO', 'BARRIO SAN JUAN', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:27:02', '2023-11-21 06:27:02');
INSERT INTO `rutas` VALUES (206, 1, 'YUNGUYO', 'HUAYLLAPUJO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:27:12', '2023-11-21 06:27:12');
INSERT INTO `rutas` VALUES (207, 1, 'YUNGUYO', 'SECTOR CHILLIUCANI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:27:21', '2023-11-21 06:27:21');
INSERT INTO `rutas` VALUES (208, 1, 'YUNGUYO', 'SECTOR COANI (CHICO)', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:27:29', '2023-11-21 06:27:29');
INSERT INTO `rutas` VALUES (209, 1, 'YUNGUYO', 'SECTOR PISAC CHURI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:27:36', '2023-11-21 06:27:36');
INSERT INTO `rutas` VALUES (210, 1, 'YUNGUYO', 'VILURCUNI SANTA BARBARA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:27:46', '2023-11-21 06:27:46');
INSERT INTO `rutas` VALUES (211, 1, 'YUNGUYO', 'VILURCUNI SAN CRISTOBAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:27:55', '2023-11-21 06:27:55');
INSERT INTO `rutas` VALUES (212, 1, 'YUNGUYO', 'VILURCUNI NATIVIDAD', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:28:04', '2023-11-21 06:28:04');
INSERT INTO `rutas` VALUES (213, 1, 'YUNGUYO', 'JISCA KOTA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:28:13', '2023-11-21 06:28:13');
INSERT INTO `rutas` VALUES (214, 1, 'YUNGUYO', 'JAKE', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:28:21', '2023-11-21 06:28:21');
INSERT INTO `rutas` VALUES (215, 1, 'YUNGUYO', 'PAMAYA (CENTRAL)', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:28:29', '2023-11-21 06:28:29');
INSERT INTO `rutas` VALUES (216, 1, 'YUNGUYO', 'ÑUJTURI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:28:36', '2023-11-21 06:28:36');
INSERT INTO `rutas` VALUES (217, 1, 'YUNGUYO', 'CALAWINKALLA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:28:43', '2023-11-21 06:28:43');
INSERT INTO `rutas` VALUES (218, 1, 'YUNGUYO', 'MOHOCACHI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:28:52', '2023-11-21 06:28:52');
INSERT INTO `rutas` VALUES (219, 1, 'YUNGUYO', 'ALIANZA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:29:00', '2023-11-21 06:29:00');
INSERT INTO `rutas` VALUES (220, 1, 'YUNGUYO', 'SANTIAGO DE KOLLCA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:29:15', '2023-11-21 06:29:15');
INSERT INTO `rutas` VALUES (221, 1, 'YUNGUYO', 'PAJANA SAN ISIDRO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:29:25', '2023-11-21 06:29:25');
INSERT INTO `rutas` VALUES (222, 1, 'YUNGUYO', 'CANTA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:29:32', '2023-11-21 06:29:32');
INSERT INTO `rutas` VALUES (223, 1, 'YUNGUYO', 'MANCO CAPAC', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:29:40', '2023-11-21 06:29:40');
INSERT INTO `rutas` VALUES (224, 1, 'YUNGUYO', 'KANTA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:29:47', '2023-11-21 06:29:47');
INSERT INTO `rutas` VALUES (225, 1, 'YUNGUYO', 'MATAN SHUYO', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:29:56', '2023-11-21 06:29:56');
INSERT INTO `rutas` VALUES (226, 1, 'YUNGUYO', 'TUPOINCA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:30:47', '2023-11-21 06:30:47');
INSERT INTO `rutas` VALUES (227, 1, 'YUNGUYO', 'COANI GRANDE', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:30:56', '2023-11-21 06:30:56');
INSERT INTO `rutas` VALUES (228, 1, 'YUNGUYO', 'CHALLAHUENCALLA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:31:05', '2023-11-21 06:31:05');
INSERT INTO `rutas` VALUES (229, 1, 'YUNGUYO', 'COCANI PATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:31:12', '2023-11-21 06:31:12');
INSERT INTO `rutas` VALUES (230, 1, 'YUNGUYO', 'CHANAPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:31:20', '2023-11-21 06:31:20');
INSERT INTO `rutas` VALUES (231, 1, 'YUNGUYO', 'ALMIRANTE GRAU', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:31:27', '2023-11-21 06:31:27');
INSERT INTO `rutas` VALUES (232, 1, 'YUNGUYO', 'SANTA ROSA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:31:36', '2023-11-21 06:31:36');
INSERT INTO `rutas` VALUES (233, 1, 'YUNGUYO', 'KAYNA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:31:43', '2023-11-21 06:31:43');
INSERT INTO `rutas` VALUES (234, 1, 'YUNGUYO', 'OLLARAYA CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:31:53', '2023-11-21 06:31:53');
INSERT INTO `rutas` VALUES (235, 1, 'YUNGUYO', 'TINICACHI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:32:00', '2023-11-21 06:32:00');
INSERT INTO `rutas` VALUES (236, 1, 'YUNGUYO', 'TOTOR JAHUIRA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:32:08', '2023-11-21 06:32:08');
INSERT INTO `rutas` VALUES (237, 1, 'YUNGUYO', 'SIHUALAYA CENTRAL', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:32:16', '2023-11-21 06:32:16');
INSERT INTO `rutas` VALUES (238, 1, 'YUNGUYO', 'MARCAJA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:32:27', '2023-11-21 06:32:27');
INSERT INTO `rutas` VALUES (239, 1, 'YUNGUYO', 'LAJJE', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:32:34', '2023-11-21 06:32:34');
INSERT INTO `rutas` VALUES (240, 1, 'YUNGUYO', 'APACHETA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:32:42', '2023-11-21 06:32:42');
INSERT INTO `rutas` VALUES (241, 1, 'YUNGUYO', 'JAYCHJA APACHETA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:32:50', '2023-11-21 06:32:50');
INSERT INTO `rutas` VALUES (242, 1, 'YUNGUYO', 'PAISCACHI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:32:57', '2023-11-21 06:32:57');
INSERT INTO `rutas` VALUES (243, 1, 'YUNGUYO', 'CANTAPATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:33:06', '2023-11-21 06:33:06');
INSERT INTO `rutas` VALUES (244, 1, 'YUNGUYO', 'CHOCANAPI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:33:14', '2023-11-21 06:33:14');
INSERT INTO `rutas` VALUES (245, 1, 'YUNGUYO', 'HUAIÑAYMARCA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:33:21', '2023-11-21 06:33:21');
INSERT INTO `rutas` VALUES (246, 1, 'YUNGUYO', 'CCUTIPATA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:33:28', '2023-11-21 06:33:28');
INSERT INTO `rutas` VALUES (247, 1, 'YUNGUYO', 'ISCAYA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:33:36', '2023-11-21 06:33:36');
INSERT INTO `rutas` VALUES (248, 1, 'YUNGUYO', 'KENAY LASA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:33:43', '2023-11-21 06:33:43');
INSERT INTO `rutas` VALUES (249, 1, 'YUNGUYO', 'HUAYLLURI', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:33:52', '2023-11-21 06:33:52');
INSERT INTO `rutas` VALUES (250, 1, 'YUNGUYO', 'SIHUALAYA PAMPA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:34:00', '2023-11-21 06:34:00');
INSERT INTO `rutas` VALUES (251, 1, 'YUNGUYO', 'INA', 'YUNGUYO', 'ACTIVO', '2023-11-21 06:34:12', '2023-11-21 06:34:12');
INSERT INTO `rutas` VALUES (252, 4, 'YUNGUYO', 'ANCASH', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:05:32', '2023-11-21 11:05:32');
INSERT INTO `rutas` VALUES (253, 4, 'YUNGUYO', 'APURIMAC', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:05:44', '2023-11-21 11:05:44');
INSERT INTO `rutas` VALUES (254, 4, 'YUNGUYO', 'AYACUCHO', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:05:55', '2023-11-21 11:05:55');
INSERT INTO `rutas` VALUES (255, 4, 'YUNGUYO', 'CAJAMARCA', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:06:05', '2023-11-21 11:06:05');
INSERT INTO `rutas` VALUES (256, 4, 'YUNGUYO', 'CALLAO', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:06:14', '2023-11-21 11:06:14');
INSERT INTO `rutas` VALUES (257, 4, 'YUNGUYO', 'HUANCAVELICA', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:06:28', '2023-11-21 11:06:28');
INSERT INTO `rutas` VALUES (258, 4, 'YUNGUYO', 'HUANUCO', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:06:40', '2023-11-21 11:06:40');
INSERT INTO `rutas` VALUES (259, 4, 'YUNGUYO', 'ICA', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:06:49', '2023-11-21 11:06:49');
INSERT INTO `rutas` VALUES (260, 4, 'YUNGUYO', 'JUNIN', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:06:59', '2023-11-21 11:06:59');
INSERT INTO `rutas` VALUES (261, 4, 'YUNGUYO', 'LA LIBERTAD', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:07:11', '2023-11-21 11:07:11');
INSERT INTO `rutas` VALUES (262, 4, 'YUNGUYO', 'LAMBAYEQUE', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:07:27', '2023-11-21 11:07:27');
INSERT INTO `rutas` VALUES (263, 4, 'YUNGUYO', 'LORETO', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:08:36', '2023-11-21 11:08:36');
INSERT INTO `rutas` VALUES (264, 4, 'YUNGUYO', 'MADRE DE DIOS', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:08:49', '2023-11-21 11:08:49');
INSERT INTO `rutas` VALUES (265, 4, 'YUNGUYO', 'MOQUEGUA', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:09:28', '2023-11-21 11:09:28');
INSERT INTO `rutas` VALUES (266, 4, 'YUNGUYO', 'PASCO', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:09:36', '2023-11-21 11:09:36');
INSERT INTO `rutas` VALUES (267, 4, 'YUNGUYO', 'PIURA', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:09:44', '2023-11-21 11:09:44');
INSERT INTO `rutas` VALUES (268, 4, 'YUNGUYO', 'PUNO', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:09:54', '2023-11-21 11:09:54');
INSERT INTO `rutas` VALUES (269, 4, 'YUNGUYO', 'SAN MARTIN', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:10:03', '2023-11-21 11:10:03');
INSERT INTO `rutas` VALUES (270, 4, 'YUNGUYO', 'TUMBES', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:10:13', '2023-11-21 11:10:13');
INSERT INTO `rutas` VALUES (271, 4, 'YUNGUYO', 'UCAYALI', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:10:26', '2023-11-21 11:10:26');
INSERT INTO `rutas` VALUES (272, 4, 'YUNGUYO', 'EXTRANJERO', 'YUNGUYO', 'ACTIVO', '2023-11-21 11:10:39', '2023-11-21 11:10:39');
INSERT INTO `rutas` VALUES (273, 2, 'YUNGUYO', 'YUNGUYO', 'YUNGUYO', 'ACTIVO', '2024-01-12 09:40:39', '2024-01-12 09:40:39');

-- ----------------------------
-- Table structure for salidas_vales
-- ----------------------------
CREATE TABLE `salidas_vales`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `area_id` bigint UNSIGNED NOT NULL,
  `personal_id` bigint UNSIGNED NOT NULL,
  `meta_id` bigint UNSIGNED NOT NULL,
  `actividad_id` bigint UNSIGNED NOT NULL,
  `usuario_id` bigint UNSIGNED NOT NULL,
  `contrato_id` bigint UNSIGNED NOT NULL,
  `proveedor_id` bigint UNSIGNED NOT NULL,
  `conductor_id` bigint UNSIGNED NOT NULL,
  `vehiculo_id` bigint UNSIGNED NOT NULL,
  `numero` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NULL DEFAULT NULL,
  `tipo_combustible` enum('DIESEL','PREMIUM','REGULAR') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cantidad` decimal(8, 2) NOT NULL,
  `precio_unitario` decimal(8, 2) NULL DEFAULT NULL,
  `precio_total` decimal(8, 2) NULL DEFAULT NULL,
  `estado` enum('PENDIENTE','APROBADO','RECHAZADO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `path_vale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `motivo` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fecha_aprobado` datetime NULL DEFAULT NULL,
  `producto_id` bigint UNSIGNED NOT NULL,
  `numero_documento` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `salidas_vales_vehiculo_id_foreign`(`vehiculo_id` ASC) USING BTREE,
  INDEX `salidas_vales_conductor_id_foreign`(`conductor_id` ASC) USING BTREE,
  INDEX `salidas_vales_proveedor_id_foreign`(`proveedor_id` ASC) USING BTREE,
  INDEX `salidas_vales_usuario_id_foreign`(`usuario_id` ASC) USING BTREE,
  INDEX `salidas_vales_actividad_id_foreign`(`actividad_id` ASC) USING BTREE,
  INDEX `salidas_vales_meta_id_foreign`(`meta_id` ASC) USING BTREE,
  INDEX `salidas_vales_area_id_foreign`(`area_id` ASC) USING BTREE,
  INDEX `salidas_vales_personal_id_foreign`(`personal_id` ASC) USING BTREE,
  INDEX `salidas_vales_contrato_id_foreign`(`contrato_id` ASC) USING BTREE,
  INDEX `producto_id`(`producto_id` ASC) USING BTREE,
  CONSTRAINT `salidas_vales_actividad_id_foreign` FOREIGN KEY (`actividad_id`) REFERENCES `actividades` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `salidas_vales_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `salidas_vales_conductor_id_foreign` FOREIGN KEY (`conductor_id`) REFERENCES `conductores` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `salidas_vales_contrato_id_foreign` FOREIGN KEY (`contrato_id`) REFERENCES `contratos_dos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `salidas_vales_ibfk_1` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `salidas_vales_meta_id_foreign` FOREIGN KEY (`meta_id`) REFERENCES `metas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `salidas_vales_personal_id_foreign` FOREIGN KEY (`personal_id`) REFERENCES `personales` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `salidas_vales_proveedor_id_foreign` FOREIGN KEY (`proveedor_id`) REFERENCES `proveedores` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `salidas_vales_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `salidas_vales_vehiculo_id_foreign` FOREIGN KEY (`vehiculo_id`) REFERENCES `vehiculos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of salidas_vales
-- ----------------------------
INSERT INTO `salidas_vales` VALUES (54, 2, 52, 7, 9, 1, 19, 5, 1, 5, '0001-2025', '2025-01-05', NULL, 10.00, NULL, NULL, 'APROBADO', 'storage/vales_generados/0001-2025_05-01-2025.pdf', '2025-01-05 16:47:58', '2025-01-05 17:12:50', 'MOTIVO DE PRUEBA', '2025-01-05 17:12:50', 4, 'OFICIO N°12-2024');
INSERT INTO `salidas_vales` VALUES (55, 2, 53, 7, 9, 1, 19, 5, 1, 4, '0002-2025', '2025-01-05', NULL, 5.00, NULL, NULL, 'APROBADO', 'storage/vales_generados/0002-2025_05-01-2025.pdf', '2025-01-05 16:52:06', '2025-01-05 17:12:17', 'MOTIVO DE PRUEBA', '2025-01-05 17:12:17', 4, 'OFICIO N°12-2024');
INSERT INTO `salidas_vales` VALUES (56, 2, 53, 7, 9, 1, 19, 5, 1, 5, '0003-2025', '2025-01-05', NULL, 10.00, NULL, NULL, 'APROBADO', 'storage/vales_generados/0003-2025_05-01-2025.pdf', '2025-01-05 16:52:39', '2025-01-05 16:54:54', 'MOTIVO DE PRUEBA', '2025-01-05 16:54:54', 4, 'OFICIO N°12-2024');
INSERT INTO `salidas_vales` VALUES (57, 2, 53, 7, 9, 1, 19, 5, 1, 5, '0004-2025', '2025-01-05', NULL, 2.00, NULL, NULL, 'APROBADO', 'storage/vales_generados/0004-2025_05-01-2025.pdf', '2025-01-05 17:13:36', '2025-01-05 17:13:47', 'MOTIVO DE PRUEBA', '2025-01-05 17:13:47', 4, 'OFICIO N°12-2024');
INSERT INTO `salidas_vales` VALUES (58, 2, 1, 7, 9, 1, 19, 5, 1, 5, '0005-2025', '2025-01-05', NULL, 1.00, NULL, NULL, 'APROBADO', 'storage/vales_generados/0005-2025_05-01-2025.pdf', '2025-01-05 17:14:59', '2025-01-05 17:15:11', 'MOTIVO DE PRUEBA', '2025-01-05 17:15:11', 4, 'OFICIO N°12-2024');
INSERT INTO `salidas_vales` VALUES (59, 5, 3, 3, 3, 1, 19, 5, 1, 4, '0006-2025', '2025-01-05', NULL, 10.00, NULL, NULL, 'APROBADO', 'storage/vales_generados/0006-2025_05-01-2025.pdf', '2025-01-05 17:18:49', '2025-01-05 17:19:00', 'MOTIVO DE PRUEBA', '2025-01-05 17:19:00', 4, 'OFICIO N°12-2024');
INSERT INTO `salidas_vales` VALUES (60, 2, 53, 7, 9, 1, 18, 6, 1, 5, '0007-2025', '2025-01-05', NULL, 5.00, NULL, NULL, 'APROBADO', 'storage/vales_generados/0007-2025_05-01-2025.pdf', '2025-01-05 17:47:52', '2025-01-05 17:48:05', 'MOTIVO DE PRUEBA', '2025-01-05 17:48:05', 4, 'OFICIO N°12-2024');

-- ----------------------------
-- Table structure for tipo_rutas
-- ----------------------------
CREATE TABLE `tipo_rutas`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado` enum('ACTIVO','INACTIVO') 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
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tipo_rutas
-- ----------------------------
INSERT INTO `tipo_rutas` VALUES (1, 'CENTRO POBLADO', 'ACTIVO', '2023-11-20 05:56:49', '2023-11-20 05:56:49');
INSERT INTO `tipo_rutas` VALUES (2, 'DISTRITAL', 'ACTIVO', '2023-11-20 05:56:58', '2023-11-20 05:56:58');
INSERT INTO `tipo_rutas` VALUES (3, 'PROVINCIAL', 'ACTIVO', '2023-11-20 05:57:06', '2023-11-20 05:57:06');
INSERT INTO `tipo_rutas` VALUES (4, 'DEPARTAMENTAL', 'ACTIVO', '2023-11-20 05:57:15', '2023-11-20 05:57:15');

-- ----------------------------
-- Table structure for vehiculos
-- ----------------------------
CREATE TABLE `vehiculos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `placa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `marca` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_id` bigint UNSIGNED NOT NULL,
  `estado` enum('ACTIVO','INACTIVO') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `clase` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `vehiculos_personal_id_foreign`(`personal_id` ASC) USING BTREE,
  CONSTRAINT `vehiculos_personal_id_foreign` FOREIGN KEY (`personal_id`) REFERENCES `personales` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of vehiculos
-- ----------------------------
INSERT INTO `vehiculos` VALUES (1, 'PIR-420', 'NISSAN', 18, 'ACTIVO', '2023-11-20 05:53:25', '2023-11-20 05:53:25', 'CAMIONETA');
INSERT INTO `vehiculos` VALUES (2, 'EGN-271', 'HYUNDAI', 22, 'ACTIVO', '2023-11-20 05:54:09', '2023-11-20 05:54:09', 'AUTOMOVIL');
INSERT INTO `vehiculos` VALUES (3, 'PGX-602', 'TOYOTA', 31, 'ACTIVO', '2023-11-20 05:54:43', '2023-11-20 05:54:43', 'CAMIONETA');
INSERT INTO `vehiculos` VALUES (4, 'EGZ-854', 'CHEVROLET', 26, 'ACTIVO', '2023-11-20 05:55:16', '2024-01-17 09:23:44', 'MINIVAN');
INSERT INTO `vehiculos` VALUES (5, 'C4Z - 861', 'TOYOTA', 17, 'ACTIVO', '2023-11-20 05:56:10', '2023-11-20 05:56:10', 'CAMIONETA');

