/*
SQLyog Community v13.2.1 (64 bit)
MySQL - 10.4.32-MariaDB : Database - api_loan
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`api_loan` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `api_loan`;

/*Table structure for table `arl_affiliates` */

DROP TABLE IF EXISTS `arl_affiliates`;

CREATE TABLE `arl_affiliates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `arl_affiliates` */

insert  into `arl_affiliates`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(11,'COLMENA',NULL,NULL,NULL),
(12,'COLPATRIA',NULL,NULL,NULL),
(13,'EQUIDAD',NULL,NULL,NULL),
(14,'POSITIVA',NULL,NULL,NULL),
(15,'SANITAS',NULL,NULL,NULL),
(16,'SEGUROS BOLIVAR',NULL,NULL,NULL),
(17,'SURA',NULL,NULL,NULL);

/*Table structure for table `authorization_policies` */

DROP TABLE IF EXISTS `authorization_policies`;

CREATE TABLE `authorization_policies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `description` varchar(3000) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `authorization_policies` */

insert  into `authorization_policies`(`id`,`title`,`description`,`created_at`,`updated_at`) values 
(1,'P1','Los titulos valores firmados serán devueltos al deudor (a) y/o fiador (a), una vez esten a PAZ Y SALVO las cuentas que avalen este titulo valor.\r\nEjs: Si el deudor (a) canceló la totalidad de la deuda pero aún es fiador (a) de una o mas cuentas que aún permanezcan activas, no se entregará dicho titulo valor hasta que las cuentas queden saldadas.','2025-11-19 17:49:22','2025-11-29 16:18:58'),
(2,'P2','Una vez cancelado el credito y siempre y cuando el deudor (a) no sea fiador (a) solidario (a) de otra cuenta, el acreedor entregará el (los) titulos valores en el lugar que ambos decidan. El costo de este envío por concepto de transporte o envío a otra ciudad o esta misma ciudad a traves de mensajeria o moto (local) sera asumida por el deudor (a)','2025-11-19 18:09:36','2025-11-29 16:20:05'),
(3,'P3','La tasa acordada para esta negociación es el porcentaje acordado entre las partes (mes y/o fracción)','2025-11-19 18:15:19','2025-11-29 16:21:32'),
(4,'P4','En caso de hacer acuerdo de pago entre deudor (a) y acreedor, ese nuevo valor o tasa acordada está sujeto al buen comportamiento de pago. Y este acuerdo aplica para pagos cumplidos y completos.\r\nCumplidos: Que el valor cancelado sea en las fechas acordadas\r\nCompleto: Que el valor de la cuota cancelada sea el acordado y no un pago fraccionado.\r\nEn caso que los pagos no sean cumplidos y ni completos, perdería automáticamente ese beneficio','2025-11-19 18:17:34','2025-11-29 16:23:16'),
(5,'P5','Por cada crédito de $ 500.000 otorgado, el deudor (a) debe tener un fiador (a) que avale o respalde la operación. En caso de no tener fidor (a) adicional, la tasa de negociación será reajustada previo acuerdo entre las partes.','2025-11-19 18:19:11','2025-11-29 16:24:19'),
(6,'P6','En caso que el pago del interes efectuado por el deudor (a) sea incompleto, la diferencia entre el valor del interes a pagar y el valor pagado, será adicionado a la deuda y generará interés a la tasa inicialmente negociada entre deudor (a) y acreedor.\r\nNuestra empresa cobra interes sobre saldo de interes no pagado.','2025-11-19 18:21:03','2025-11-29 16:25:25'),
(7,'P7','Sobre la marcha del crédito, el cliente puede solicitar cambios en las fechas de pago. Ese cambio en las fechas de pago trae consigo reajuste en la cartera y el sistema calcula los dias adicionales a cobrar en el próximo pago. Es responsabilidad del acreedor socializar al deudor (a) el nuevo valor a pagar en la nueva fecha de pago solicitada.','2025-11-19 18:23:47','2025-11-29 16:27:04'),
(8,'P8','Los titulos valores  deben ser firmados en presencia del acreedor y no de manera virtual.','2025-11-19 18:25:56','2025-11-29 16:28:30'),
(9,'P9','Una vez se avale el crédito por parte del acreedor, éste solicitará la firma de titulos valores para respaldar el crédito. Para este evento, el acredor enviará a una persona de su total confianza para la (s) firma (s) del (los) titulo (s) valor (es). El costo que acarree la obtención de esa (s) firma (s) será asumido por el deudor (a). En caso que el deudor (a) no tenga el valor a cancelar, entonces el acreedor (a) descontará el valor del domicilio al crédito solicitado y desembolsará la diferencia.','2025-11-29 16:31:48','2025-11-29 16:31:48'),
(10,'P10','Nuestra empresa no congela deudas','2025-11-29 16:32:42','2025-11-29 16:32:42'),
(11,'P11','Para la obtención del crédito con nuestra empresa, se requiere la firma de dos (2) titulos valores, firmar comprobante de egreso en blanco, adjuntar la información que solicita el acreedor y diligenciar la información en link que el acreedor envíe','2025-11-29 16:33:55','2025-11-29 16:33:55'),
(12,'P12','En caso que el nuevo cliente resida en otra ciudad, el acreedor enviará al cliente via whatsApp o mail documento titulo valor llamado PAGARE. Este documento debe solamente firmarlo el cliente en la notaría local más cercana de la ciudad donde se encuentre el cliente, no debe diligenciar ningun campo ni colocar fechas y una vez firmado y autenticado en notaria local (ciudad donde reside cliente), debe proceder al envío a la ciudad de Barranquilla o donde el acreedor disponga.\r\nEl costo del envio de este documento será asumido por cliente.\r\nUna vez cliente efectúe el pago de la totalidad de la cuenta, el costo del envío igualmente será asumido por el cliente.','2025-11-29 16:35:02','2025-11-29 16:35:02'),
(13,'P13','Nuestra empresa se abstiene de tener relaciones comerciales directas con policias, militares, trabajadores FOPEP, trabajadores FOMAG, trabajadores magisterio, profesores activos, profesores pensionados, pensionados, políticos, trabajadores de la secretaría distrital de educación, trabajadores de la secretaría departamental de educación, abogados e independientes.\r\nSin embargo para que una de las anteriores personas accedan a un crédito con nuestra empresa, se requiere dos (s) fiador (es) solidario (s).','2025-11-29 16:36:39','2025-11-29 16:36:39'),
(14,'P14','Prestamos efectuados durante el mes (inicios, mediados o antes de finalizar el mes), seran cobrados al finalizar el mes a la misma tasa porcentual % acordada desde el inicio de la negociacion.','2025-11-29 16:38:23','2025-11-29 16:38:23'),
(15,'P15','Nuestra empresa en caso de tener deudores morosos, envío al lugar de trabajo y/o lugar de residencia a cobradores autorizados para gestionar el pago y evitar inicio de pleitos legales.','2025-11-29 16:39:50','2025-11-29 16:39:50'),
(16,'P16','En caso que el cliente, solicite cambio en fechas de pago (día 30 a día 15 y viceversa, día 5 a día 20 y viceversa), el ACREEDOR calculará esos 15 días adicionales de interés con base en el saldo de cartera a la fecha y este valor será asumido y pagado por cliente por UNA SOLA VEZ. Todo cambio en fechas de pago, tiene un costo financiero que debe ser asumido por el CLIENTE.','2025-11-29 16:41:28','2025-11-29 16:41:28'),
(17,'A1','Autorizo al acreedor, EN CASO DE NO PAGO DE LAS CUOTAS ACORDADAS por más de sesenta (60) dias de NOTIFICAR de manera virtual y presencial a través de AVISO DE COBRO PREJURIDICO tanto a mí como DEUDOR y a mi FIADOR (ES) SOLIDARIO (S) en cada uno de nuestros lugares de residencia y de trabajo.','2025-11-29 16:53:52','2025-11-29 16:53:52'),
(18,'A2','Autorizo al acreedor, EN CASO DE NOTIFICACION DE AVISO DE COBRO PREJURIDICO adicionar a mi deuda (Cartera), por concepto de honorarios de abogados el 30% del valor adeudado a la fecha. En todo caso ese valor adicionado NUNCA será inferior a 1 SMLV (Salario mínimo legal vigente del año en curso)\r\nEste rubro o ese costo de honorarios cobrados por los abogados (as), legalmente debe ser asumido por el DEUDOR MOROSO.\r\nLa única manera de evitar el cobro de este rubro, es que el cliente pague sus cuotas acordadas en el tiempo previsto y acordado entre el DEUDOR y EL ACREEDOR.','2025-11-29 16:54:48','2025-11-29 16:54:48'),
(19,'A3','Autorizo al acreedor, EN CASO DE INICIO DE PROCESO LEGAL adicionar a mi deuda, además de los honorarios de los abogados, las costas del proceso y todo gasto adicional que se incurra en el proceso de demanda ejecutiva.','2025-11-29 16:56:07','2025-11-29 16:56:07'),
(20,'A4','Autorizo al acreedor, EN CASO DE INICIO DE PROCESO LEGAL diligenciar y hacer efectivo cada uno de los títulos valores firmados por mí o mi FIADOR SOLIDARIO / CODEUDOR, por el valor que a juicio del ACREEDOR este adeudando por concepto de cartera morosa, interés vencido, interés moratorio (máxima tasa legal permitida), honorarios legales, costas del proceso, búsqueda de información en plataformas digitales.','2025-11-29 16:56:44','2025-11-29 16:56:44'),
(21,'A5','Acepto, EN CASO DE RADICACION DE DEMANDA EJECUTIVA a la empresa donde presto mis servicios y/o presta sus servicios  mi FIADOR el valor liquidado por el juzgado referente a mi demanda.','2025-11-29 16:57:46','2025-11-29 16:57:46'),
(22,'A6','Autorizo al acreedor, EN CASO DE SER DEUDOR MOROSO y de haber cambiado de empresa y no haberle notificado dicho cambio o reportarle mi nueva vinculación laboral, adicionar a mi deuda el valor de la cuarta parte del salario minimo legal vigente (SMLV) a la fecha, por concepto de honorarios del Dpto. Administrativo por búsqueda en plataformas digitales la información tendiente a conseguir la nueva vinculación contractual y desconocida por el acreedor.','2025-11-29 16:58:58','2025-11-29 16:58:58'),
(23,'A7','Autorizo al acreedor, EN CASO DE PAGO INCOMPLETO O FRACCIONADO de la cuota interés por pagar, adicionar ese valor pendiente de interés a mi deuda. En este caso, ese saldo adicionado por concepto de interés o saldo de interés no pagado generaría interés a la misma tasa acordada entre DEUDOR y ACREEDOR.','2025-11-29 16:59:55','2025-11-29 16:59:55'),
(24,'A8','Autorizo al acreedor, EN CASO QUE SEA NECESARIO DE TRASLADARSE hasta donde el DEUDOR ya sea para firmar títulos valores, buscar documentos o recoger el pago por concepto de cuota acordada y pactada entre DEUDOR y FIADOR, adicionar a mi deuda el valor del transporte en que se incurrió por esta novedad.','2025-11-29 17:00:36','2025-11-29 17:00:36'),
(25,'A9','Autorizo al acreedor, EN CASO QUE YO REFERENCIE, RECOMIENDE a otra persona como cliente de su empresa ser FIADOR SOLIDARIO / CODEUDOR de esa nueva cuenta. Y en caso que se inicie a futuro algún proceso legal, los títulos valores firmados por mí, pueden tomarlo como garantía para ese proceso legal (si existiere)\r\nEl recomendar o ser recomendado por otra persona (cliente), me hace ser responsable, CODEUDOR o FIADOR SOLIDARIO de manera bilateral. O sea, yo sería CODEUDOR / FIADOR SOLIDARIO del referenciado y viceversa (el referenciado seria fiador mío).','2025-11-29 17:01:30','2025-11-29 17:01:30'),
(26,'A10','Autorizo al acreedor, EN CASO QUE ALGUIEN ME REFERENCIE, RECOMIENDE como cliente de su empresa ser FIADOR SOLIDARIO / CODEUDOR de esa cuenta del cliente que me recomendó a su empresa. Y en caso que se inicie a futuro algún proceso legal en contra de esa persona, los títulos valores firmados por mí, pueden tomarlo como garantía para ese proceso legal (si existiere)','2025-11-29 17:02:35','2025-11-29 17:02:35'),
(27,'A11','Autorizo al acreedor, quedarse con mi (s) titulo (s) valor (es) hasta que yo como DEUDOR o mi FIADOR SOLIDARIO BILATERAL o FIADOR CRUZADO haya (mos) pagado la totalidad de la deuda y estemos a PAZ y SALVO con el acreedor.','2025-11-29 17:03:52','2025-11-29 17:03:52'),
(28,'A12','Autorizo al acreedor, EN CASO DE EMBARGO SALARIAL Y/O DE BIENES (si lo hubiere), un proceso legal por cada título valor firmado: Letras y/o PAGARE.','2025-11-29 17:04:42','2025-11-29 17:04:42'),
(29,'A13','Confirmo y doy fé al acreedor, que antes de recomendar a una persona como futuro cliente de su empresa ya previamente he hablado con él (ella), y ha autorizado ser mi FIADOR SOLIDARIO / CODEUDOR de mi cuenta.','2025-11-29 17:05:52','2025-11-29 17:05:52'),
(30,'A14','Autorizo pagar costos adicionales por concepto de transporte, en caso que haya que enviar a un cobrador por decision del ACREEDOR o por incumplimientos en los pagos o acuerdos y se necesite trasladar el cobrador hasta el lugar de trabajo o de residencia del deudor.','2025-11-29 17:09:43','2025-11-29 17:09:43'),
(31,'A15','Autorizo ser fiador solidario cruzado aun en el caso que yo como deudor haya cancelado la totalidad de mi deuda y mi referenciado no haya pagado la totalidad de la cuenta. Los titulos valores me seran entregados cuando yo como deudor y mis referidos hayan cancelado la totalidad de la deuda.','2025-11-29 17:10:57','2025-11-29 17:10:57');

/*Table structure for table `cities` */

DROP TABLE IF EXISTS `cities`;

CREATE TABLE `cities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `code` int(11) NOT NULL,
  `state_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cities_state_id_foreign` (`state_id`),
  CONSTRAINT `cities_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cities` */

insert  into `cities`(`id`,`name`,`code`,`state_id`,`created_at`,`updated_at`) values 
(1,'MEDELLIN',1,1,NULL,NULL),
(2,'ABEJORRAL',2,1,NULL,NULL),
(3,'ABRIAQUI',4,1,NULL,NULL),
(4,'ALEJANDRIA',21,1,NULL,NULL),
(5,'AMAGA',30,1,NULL,NULL),
(6,'AMALFI',31,1,NULL,NULL),
(7,'ANDES',34,1,NULL,NULL),
(8,'ANGELOPOLIS',36,1,NULL,NULL),
(9,'ANGOSTURA',38,1,NULL,NULL),
(10,'ANORI',40,1,NULL,NULL),
(11,'ANTIOQUIA',42,1,NULL,NULL),
(12,'ANZA',44,1,NULL,NULL),
(13,'APARTADO',45,1,NULL,NULL),
(14,'ARBOLETES',51,1,NULL,NULL),
(15,'ARGELIA',55,1,NULL,NULL),
(16,'ARMENIA',59,1,NULL,NULL),
(17,'BARBOSA',79,1,NULL,NULL),
(18,'BELMIRA',86,1,NULL,NULL),
(19,'BELLO',88,1,NULL,NULL),
(20,'BETANIA',91,1,NULL,NULL),
(21,'BETULIA',93,1,NULL,NULL),
(22,'BOLIVAR',101,1,NULL,NULL),
(23,'BRICEÑO',107,1,NULL,NULL),
(24,'BURITICA',113,1,NULL,NULL),
(25,'CACERES',120,1,NULL,NULL),
(26,'CAICEDO',125,1,NULL,NULL),
(27,'CALDAS',129,1,NULL,NULL),
(28,'CAMPAMENTO',134,1,NULL,NULL),
(29,'CAÑASGORDAS',138,1,NULL,NULL),
(30,'CARACOLI',142,1,NULL,NULL),
(31,'CARAMANTA',145,1,NULL,NULL),
(32,'CAREPA',147,1,NULL,NULL),
(33,'CARMEN DE VIBORAL',148,1,NULL,NULL),
(34,'CAROLINA',150,1,NULL,NULL),
(35,'CAUCASIA',154,1,NULL,NULL),
(36,'CHIGORODO',172,1,NULL,NULL),
(37,'CISNEROS',190,1,NULL,NULL),
(38,'COCORNA',197,1,NULL,NULL),
(39,'CONCEPCION',206,1,NULL,NULL),
(40,'CONCORDIA',209,1,NULL,NULL),
(41,'COPACABANA',212,1,NULL,NULL),
(42,'DABEIBA',234,1,NULL,NULL),
(43,'DON MATIAS',237,1,NULL,NULL),
(44,'EBEJICO',240,1,NULL,NULL),
(45,'EL BAGRE',250,1,NULL,NULL),
(46,'ENTRERRIOS',264,1,NULL,NULL),
(47,'ENVIGADO',266,1,NULL,NULL),
(48,'FREDONIA',282,1,NULL,NULL),
(49,'FRONTINO',284,1,NULL,NULL),
(50,'GIRALDO',306,1,NULL,NULL),
(51,'GIRARDOTA',308,1,NULL,NULL),
(52,'GOMEZ PLATA',310,1,NULL,NULL),
(53,'GRANADA',313,1,NULL,NULL),
(54,'GUADALUPE',315,1,NULL,NULL),
(55,'GUARNE',318,1,NULL,NULL),
(56,'GUATAPE',321,1,NULL,NULL),
(57,'HELICONIA',347,1,NULL,NULL),
(58,'HISPANIA',353,1,NULL,NULL),
(59,'ITAGUI',360,1,NULL,NULL),
(60,'ITUANGO',361,1,NULL,NULL),
(61,'JARDIN',364,1,NULL,NULL),
(62,'JERICO',368,1,NULL,NULL),
(63,'LA CEJA',376,1,NULL,NULL),
(64,'LA ESTRELLA',380,1,NULL,NULL),
(65,'LA PINTADA',390,1,NULL,NULL),
(66,'LA UNION',400,1,NULL,NULL),
(67,'LIBORINA',411,1,NULL,NULL),
(68,'MACEO',425,1,NULL,NULL),
(69,'MARINILLA',440,1,NULL,NULL),
(70,'MONTEBELLO',467,1,NULL,NULL),
(71,'MURINDO',475,1,NULL,NULL),
(72,'MUTATA',480,1,NULL,NULL),
(73,'NARIÑO',483,1,NULL,NULL),
(74,'NECOCLI',490,1,NULL,NULL),
(75,'NECHI',495,1,NULL,NULL),
(76,'OLAYA',501,1,NULL,NULL),
(77,'PEÑOL',541,1,NULL,NULL),
(78,'PEQUE',543,1,NULL,NULL),
(79,'PUEBLORRICO',576,1,NULL,NULL),
(80,'PUERTO BERRIO',579,1,NULL,NULL),
(81,'PUERTO NARE (LA MAGDALENA)',585,1,NULL,NULL),
(82,'PUERTO TRIUNFO',591,1,NULL,NULL),
(83,'REMEDIOS',604,1,NULL,NULL),
(84,'RETIRO',607,1,NULL,NULL),
(85,'RIONEGRO',615,1,NULL,NULL),
(86,'SABANALARGA',628,1,NULL,NULL),
(87,'SABANETA',631,1,NULL,NULL),
(88,'SALGAR',642,1,NULL,NULL),
(89,'SAN ANDRES',647,1,NULL,NULL),
(90,'SAN CARLOS',649,1,NULL,NULL),
(91,'SAN FRANCISCO',652,1,NULL,NULL),
(92,'SAN JERONIMO',656,1,NULL,NULL),
(93,'SAN JOSE DE LA MONTAÑA',658,1,NULL,NULL),
(94,'SAN JUAN DE URABA',659,1,NULL,NULL),
(95,'SAN LUIS',660,1,NULL,NULL),
(96,'SAN PEDRO',664,1,NULL,NULL),
(97,'SAN PEDRO DE URABA',665,1,NULL,NULL),
(98,'SAN RAFAEL',667,1,NULL,NULL),
(99,'SAN ROQUE',670,1,NULL,NULL),
(100,'SAN VICENTE',674,1,NULL,NULL),
(101,'SANTA BARBARA',679,1,NULL,NULL),
(102,'SANTA ROSA DE OSOS',686,1,NULL,NULL),
(103,'SANTO DOMINGO',690,1,NULL,NULL),
(104,'SANTUARIO',697,1,NULL,NULL),
(105,'SEGOVIA',736,1,NULL,NULL),
(106,'SONSON',756,1,NULL,NULL),
(107,'SOPETRAN',761,1,NULL,NULL),
(108,'TAMESIS',789,1,NULL,NULL),
(109,'TARAZA',790,1,NULL,NULL),
(110,'TARSO',792,1,NULL,NULL),
(111,'TITIRIBI',809,1,NULL,NULL),
(112,'TOLEDO',819,1,NULL,NULL),
(113,'TURBO',837,1,NULL,NULL),
(114,'URAMITA',842,1,NULL,NULL),
(115,'URRAO',847,1,NULL,NULL),
(116,'VALDIVIA',854,1,NULL,NULL),
(117,'VALPARAISO',856,1,NULL,NULL),
(118,'VEGACHI',858,1,NULL,NULL),
(119,'VENECIA',861,1,NULL,NULL),
(120,'VIGIA DEL FUERTE',873,1,NULL,NULL),
(121,'YALI',885,1,NULL,NULL),
(122,'YARUMAL',887,1,NULL,NULL),
(123,'YOLOMBO',890,1,NULL,NULL),
(124,'YONDO',893,1,NULL,NULL),
(125,'ZARAGOZA',895,1,NULL,NULL),
(126,'BARRANQUILLA',1,2,NULL,NULL),
(127,'BARANOA',78,2,NULL,NULL),
(128,'CAMPO DE LA CRUZ',137,2,NULL,NULL),
(129,'CANDELARIA',141,2,NULL,NULL),
(130,'GALAPA',296,2,NULL,NULL),
(131,'JUAN DE ACOSTA',372,2,NULL,NULL),
(132,'LURUACO',421,2,NULL,NULL),
(133,'MALAMBO',433,2,NULL,NULL),
(134,'MANATI',436,2,NULL,NULL),
(135,'PALMAR DE VARELA',520,2,NULL,NULL),
(136,'PIOJO',549,2,NULL,NULL),
(137,'POLO NUEVO',558,2,NULL,NULL),
(138,'PONEDERA',560,2,NULL,NULL),
(139,'PUERTO COLOMBIA',573,2,NULL,NULL),
(140,'REPELON',606,2,NULL,NULL),
(141,'SABANAGRANDE',634,2,NULL,NULL),
(142,'SABANALARGA',638,2,NULL,NULL),
(143,'SANTA LUCIA',675,2,NULL,NULL),
(144,'SANTO TOMAS',685,2,NULL,NULL),
(145,'SOLEDAD',758,2,NULL,NULL),
(146,'SUAN',770,2,NULL,NULL),
(147,'TUBARA',832,2,NULL,NULL),
(148,'USIACURI',849,2,NULL,NULL),
(149,'Santa Fe de Bogotá',1,3,NULL,NULL),
(150,'USAQUEN',1,3,NULL,NULL),
(151,'CHAPINERO',2,3,NULL,NULL),
(152,'SANTA FE',3,3,NULL,NULL),
(153,'SAN CRISTOBAL',4,3,NULL,NULL),
(154,'USME',5,3,NULL,NULL),
(155,'TUNJUELITO',6,3,NULL,NULL),
(156,'BOSA',7,3,NULL,NULL),
(157,'KENNEDY',8,3,NULL,NULL),
(158,'FONTIBON',9,3,NULL,NULL),
(159,'ENGATIVA',10,3,NULL,NULL),
(160,'SUBA',11,3,NULL,NULL),
(161,'BARRIOS UNIDOS',12,3,NULL,NULL),
(162,'TEUSAQUILLO',13,3,NULL,NULL),
(163,'MARTIRES',14,3,NULL,NULL),
(164,'ANTONIO NARIÑO',15,3,NULL,NULL),
(165,'PUENTE ARANDA',16,3,NULL,NULL),
(166,'CANDELARIA',17,3,NULL,NULL),
(167,'RAFAEL URIBE',18,3,NULL,NULL),
(168,'CIUDAD BOLIVAR',19,3,NULL,NULL),
(169,'SUMAPAZ',20,3,NULL,NULL),
(170,'CARTAGENA (DISTRITO TURISTICO Y CULTURAL DE CARTAGENA)',1,4,NULL,NULL),
(171,'ACHI',6,4,NULL,NULL),
(172,'ALTOS DEL ROSARIO',30,4,NULL,NULL),
(173,'ARENAL',42,4,NULL,NULL),
(174,'ARJONA',52,4,NULL,NULL),
(175,'ARROYOHONDO',62,4,NULL,NULL),
(176,'BARRANCO DE LOBA',74,4,NULL,NULL),
(177,'CALAMAR',140,4,NULL,NULL),
(178,'CANTAGALLO',160,4,NULL,NULL),
(179,'CICUCO',188,4,NULL,NULL),
(180,'CORDOBA',212,4,NULL,NULL),
(181,'CLEMENCIA',222,4,NULL,NULL),
(182,'EL CARMEN DE BOLIVAR',244,4,NULL,NULL),
(183,'EL GUAMO',248,4,NULL,NULL),
(184,'EL PEÑON',268,4,NULL,NULL),
(185,'HATILLO DE LOBA',300,4,NULL,NULL),
(186,'MAGANGUE',430,4,NULL,NULL),
(187,'MAHATES',433,4,NULL,NULL),
(188,'MARGARITA',440,4,NULL,NULL),
(189,'MARIA LA BAJA',442,4,NULL,NULL),
(190,'MONTECRISTO',458,4,NULL,NULL),
(191,'MOMPOS',468,4,NULL,NULL),
(192,'MORALES',473,4,NULL,NULL),
(193,'PINILLOS',549,4,NULL,NULL),
(194,'REGIDOR',580,4,NULL,NULL),
(195,'RIO VIEJO',600,4,NULL,NULL),
(196,'SAN CRISTOBAL',620,4,NULL,NULL),
(197,'SAN ESTANISLAO',647,4,NULL,NULL),
(198,'SAN FERNANDO',650,4,NULL,NULL),
(199,'SAN JACINTO',654,4,NULL,NULL),
(200,'SAN JACINTO DEL CAUCA',655,4,NULL,NULL),
(201,'SAN JUAN NEPOMUCENO',657,4,NULL,NULL),
(202,'SAN MARTIN DE LOBA',667,4,NULL,NULL),
(203,'SAN PABLO',670,4,NULL,NULL),
(204,'SANTA CATALINA',673,4,NULL,NULL),
(205,'SANTA ROSA',683,4,NULL,NULL),
(206,'SANTA ROSA DEL SUR',688,4,NULL,NULL),
(207,'SIMITI',744,4,NULL,NULL),
(208,'SOPLAVIENTO',760,4,NULL,NULL),
(209,'TALAIGUA NUEVO',780,4,NULL,NULL),
(210,'TIQUISIO (PUERTO RICO)',810,4,NULL,NULL),
(211,'TURBACO',836,4,NULL,NULL),
(212,'TURBANA',838,4,NULL,NULL),
(213,'VILLANUEVA',873,4,NULL,NULL),
(214,'ZAMBRANO',894,4,NULL,NULL),
(215,'TUNJA',1,5,NULL,NULL),
(216,'ALMEIDA',22,5,NULL,NULL),
(217,'AQUITANIA',47,5,NULL,NULL),
(218,'ARCABUCO',51,5,NULL,NULL),
(219,'BELEN',87,5,NULL,NULL),
(220,'BERBEO',90,5,NULL,NULL),
(221,'BETEITIVA',92,5,NULL,NULL),
(222,'BOAVITA',97,5,NULL,NULL),
(223,'BOYACA',104,5,NULL,NULL),
(224,'BRICEÑO',106,5,NULL,NULL),
(225,'BUENAVISTA',109,5,NULL,NULL),
(226,'BUSBANZA',114,5,NULL,NULL),
(227,'CALDAS',131,5,NULL,NULL),
(228,'CAMPOHERMOSO',135,5,NULL,NULL),
(229,'CERINZA',162,5,NULL,NULL),
(230,'CHINAVITA',172,5,NULL,NULL),
(231,'CHIQUINQUIRA',176,5,NULL,NULL),
(232,'CHISCAS',180,5,NULL,NULL),
(233,'CHITA',183,5,NULL,NULL),
(234,'CHITARAQUE',185,5,NULL,NULL),
(235,'CHIVATA',187,5,NULL,NULL),
(236,'CIENEGA',189,5,NULL,NULL),
(237,'COMBITA',204,5,NULL,NULL),
(238,'COPER',212,5,NULL,NULL),
(239,'CORRALES',215,5,NULL,NULL),
(240,'COVARACHIA',218,5,NULL,NULL),
(241,'CUBARA',223,5,NULL,NULL),
(242,'CUCAITA',224,5,NULL,NULL),
(243,'CUITIVA',226,5,NULL,NULL),
(244,'CHIQUIZA',232,5,NULL,NULL),
(245,'CHIVOR',236,5,NULL,NULL),
(246,'DUITAMA',238,5,NULL,NULL),
(247,'EL COCUY',244,5,NULL,NULL),
(248,'EL ESPINO',248,5,NULL,NULL),
(249,'FIRAVITOBA',272,5,NULL,NULL),
(250,'FLORESTA',276,5,NULL,NULL),
(251,'GACHANTIVA',293,5,NULL,NULL),
(252,'GAMEZA',296,5,NULL,NULL),
(253,'GARAGOA',299,5,NULL,NULL),
(254,'GUACAMAYAS',317,5,NULL,NULL),
(255,'GUATEQUE',322,5,NULL,NULL),
(256,'GUAYATA',325,5,NULL,NULL),
(257,'GUICAN',332,5,NULL,NULL),
(258,'IZA',362,5,NULL,NULL),
(259,'JENESANO',367,5,NULL,NULL),
(260,'JERICO',368,5,NULL,NULL),
(261,'LABRANZAGRANDE',377,5,NULL,NULL),
(262,'LA CAPILLA',380,5,NULL,NULL),
(263,'LA VICTORIA',401,5,NULL,NULL),
(264,'LA UVITA',403,5,NULL,NULL),
(265,'VILLA DE LEIVA',407,5,NULL,NULL),
(266,'MACANAL',425,5,NULL,NULL),
(267,'MARIPI',442,5,NULL,NULL),
(268,'MIRAFLORES',455,5,NULL,NULL),
(269,'MONGUA',464,5,NULL,NULL),
(270,'MONGUI',466,5,NULL,NULL),
(271,'MONIQUIRA',469,5,NULL,NULL),
(272,'MOTAVITA',476,5,NULL,NULL),
(273,'MUZO',480,5,NULL,NULL),
(274,'NOBSA',491,5,NULL,NULL),
(275,'NUEVO COLON',494,5,NULL,NULL),
(276,'OICATA',500,5,NULL,NULL),
(277,'OTANCHE',507,5,NULL,NULL),
(278,'PACHAVITA',511,5,NULL,NULL),
(279,'PAEZ',514,5,NULL,NULL),
(280,'PAIPA',516,5,NULL,NULL),
(281,'PAJARITO',518,5,NULL,NULL),
(282,'PANQUEBA',522,5,NULL,NULL),
(283,'PAUNA',531,5,NULL,NULL),
(284,'PAYA',533,5,NULL,NULL),
(285,'PAZ DEL RIO',537,5,NULL,NULL),
(286,'PESCA',542,5,NULL,NULL),
(287,'PISBA',550,5,NULL,NULL),
(288,'PUERTO BOYACA',572,5,NULL,NULL),
(289,'QUIPAMA',580,5,NULL,NULL),
(290,'RAMIRIQUI',599,5,NULL,NULL),
(291,'RAQUIRA',600,5,NULL,NULL),
(292,'RONDON',621,5,NULL,NULL),
(293,'SABOYA',632,5,NULL,NULL),
(294,'SACHICA',638,5,NULL,NULL),
(295,'SAMACA',646,5,NULL,NULL),
(296,'SAN EDUARDO',660,5,NULL,NULL),
(297,'SAN JOSE DE PARE',664,5,NULL,NULL),
(298,'SAN LUIS DE GACENO',667,5,NULL,NULL),
(299,'SAN MATEO',673,5,NULL,NULL),
(300,'SAN MIGUEL DE SEMA',676,5,NULL,NULL),
(301,'SAN PABLO DE BORBUR',681,5,NULL,NULL),
(302,'SANTANA',686,5,NULL,NULL),
(303,'SANTA MARIA',690,5,NULL,NULL),
(304,'SANTA ROSA DE VITERBO',693,5,NULL,NULL),
(305,'SANTA SOFIA',696,5,NULL,NULL),
(306,'SATIVANORTE',720,5,NULL,NULL),
(307,'SATIVASUR',723,5,NULL,NULL),
(308,'SIACHOQUE',740,5,NULL,NULL),
(309,'SOATA',753,5,NULL,NULL),
(310,'SOCOTA',755,5,NULL,NULL),
(311,'SOCHA',757,5,NULL,NULL),
(312,'SOGAMOSO',759,5,NULL,NULL),
(313,'SOMONDOCO',761,5,NULL,NULL),
(314,'SORA',762,5,NULL,NULL),
(315,'SOTAQUIRA',763,5,NULL,NULL),
(316,'SORACA',764,5,NULL,NULL),
(317,'SUSACON',774,5,NULL,NULL),
(318,'SUTAMARCHAN',776,5,NULL,NULL),
(319,'SUTATENZA',778,5,NULL,NULL),
(320,'TASCO',790,5,NULL,NULL),
(321,'TENZA',798,5,NULL,NULL),
(322,'TIBANA',804,5,NULL,NULL),
(323,'TIBASOSA',806,5,NULL,NULL),
(324,'TINJACA',808,5,NULL,NULL),
(325,'TIPACOQUE',810,5,NULL,NULL),
(326,'TOCA',814,5,NULL,NULL),
(327,'TOGUI',816,5,NULL,NULL),
(328,'TOPAGA',820,5,NULL,NULL),
(329,'TOTA',822,5,NULL,NULL),
(330,'TUNUNGUA',832,5,NULL,NULL),
(331,'TURMEQUE',835,5,NULL,NULL),
(332,'TUTA',837,5,NULL,NULL),
(333,'TUTASA',839,5,NULL,NULL),
(334,'UMBITA',842,5,NULL,NULL),
(335,'VENTAQUEMADA',861,5,NULL,NULL),
(336,'VIRACACHA',879,5,NULL,NULL),
(337,'ZETAQUIRA',897,5,NULL,NULL),
(338,'MANIZALES',1,6,NULL,NULL),
(339,'AGUADAS',13,6,NULL,NULL),
(340,'ANSERMA',42,6,NULL,NULL),
(341,'ARANZAZU',50,6,NULL,NULL),
(342,'BELALCAZAR',88,6,NULL,NULL),
(343,'CHINCHINA',174,6,NULL,NULL),
(344,'FILADELFIA',272,6,NULL,NULL),
(345,'LA DORADA',380,6,NULL,NULL),
(346,'LA MERCED',388,6,NULL,NULL),
(347,'MANZANARES',433,6,NULL,NULL),
(348,'MARMATO',442,6,NULL,NULL),
(349,'MARQUETALIA',444,6,NULL,NULL),
(350,'MARULANDA',446,6,NULL,NULL),
(351,'NEIRA',486,6,NULL,NULL),
(352,'NORCASIA',495,6,NULL,NULL),
(353,'PACORA',513,6,NULL,NULL),
(354,'PALESTINA',524,6,NULL,NULL),
(355,'PENSILVANIA',541,6,NULL,NULL),
(356,'RIOSUCIO',614,6,NULL,NULL),
(357,'RISARALDA',616,6,NULL,NULL),
(358,'SALAMINA',653,6,NULL,NULL),
(359,'SAMANA',662,6,NULL,NULL),
(360,'SAN JOSE',665,6,NULL,NULL),
(361,'SUPIA',777,6,NULL,NULL),
(362,'VICTORIA',867,6,NULL,NULL),
(363,'VILLAMARIA',873,6,NULL,NULL),
(364,'VITERBO',877,6,NULL,NULL),
(365,'FLORENCIA',1,7,NULL,NULL),
(366,'ALBANIA',29,7,NULL,NULL),
(367,'BELEN DE LOS ANDAQUIES',94,7,NULL,NULL),
(368,'CARTAGENA DEL CHAIRA',150,7,NULL,NULL),
(369,'CURILLO',205,7,NULL,NULL),
(370,'EL DONCELLO',247,7,NULL,NULL),
(371,'EL PAUJIL',256,7,NULL,NULL),
(372,'LA MONTAÑITA',410,7,NULL,NULL),
(373,'MILAN',460,7,NULL,NULL),
(374,'MORELIA',479,7,NULL,NULL),
(375,'PUERTO RICO',592,7,NULL,NULL),
(376,'SAN JOSE DE FRAGUA',610,7,NULL,NULL),
(377,'SAN VICENTE DEL CAGUAN',753,7,NULL,NULL),
(378,'SOLANO',756,7,NULL,NULL),
(379,'SOLITA',785,7,NULL,NULL),
(380,'VALPARAISO',860,7,NULL,NULL),
(381,'POPAYAN',1,8,NULL,NULL),
(382,'ALMAGUER',22,8,NULL,NULL),
(383,'ARGELIA',50,8,NULL,NULL),
(384,'BALBOA',75,8,NULL,NULL),
(385,'BOLIVAR',100,8,NULL,NULL),
(386,'BUENOS AIRES',110,8,NULL,NULL),
(387,'CAJIBIO',130,8,NULL,NULL),
(388,'CALDONO',137,8,NULL,NULL),
(389,'CALOTO',142,8,NULL,NULL),
(390,'CORINTO',212,8,NULL,NULL),
(391,'EL TAMBO',256,8,NULL,NULL),
(392,'FLORENCIA',290,8,NULL,NULL),
(393,'GUAPI',318,8,NULL,NULL),
(394,'INZA',355,8,NULL,NULL),
(395,'JAMBALO',364,8,NULL,NULL),
(396,'LA SIERRA',392,8,NULL,NULL),
(397,'LA VEGA',397,8,NULL,NULL),
(398,'LOPEZ (MICAY)',418,8,NULL,NULL),
(399,'MERCADERES',450,8,NULL,NULL),
(400,'MIRANDA',455,8,NULL,NULL),
(401,'MORALES',473,8,NULL,NULL),
(402,'PADILLA',513,8,NULL,NULL),
(403,'PAEZ (BELALCAZAR)',517,8,NULL,NULL),
(404,'PATIA (EL BORDO)',532,8,NULL,NULL),
(405,'PIAMONTE',533,8,NULL,NULL),
(406,'PIENDAMO',548,8,NULL,NULL),
(407,'PUERTO TEJADA',573,8,NULL,NULL),
(408,'PURACE (COCONUCO)',585,8,NULL,NULL),
(409,'ROSAS',622,8,NULL,NULL),
(410,'SAN SEBASTIAN',693,8,NULL,NULL),
(411,'SANTANDER DE QUILICHAO',698,8,NULL,NULL),
(412,'SANTA ROSA',701,8,NULL,NULL),
(413,'SILVIA',743,8,NULL,NULL),
(414,'SOTARA (PAISPAMBA)',760,8,NULL,NULL),
(415,'SUAREZ',780,8,NULL,NULL),
(416,'TIMBIO',807,8,NULL,NULL),
(417,'TIMBIQUI',809,8,NULL,NULL),
(418,'TORIBIO',821,8,NULL,NULL),
(419,'TOTORO',824,8,NULL,NULL),
(420,'VILLARICA',845,8,NULL,NULL),
(421,'VALLEDUPAR',1,9,NULL,NULL),
(422,'AGUACHICA',11,9,NULL,NULL),
(423,'AGUSTIN CODAZZI',13,9,NULL,NULL),
(424,'ASTREA',32,9,NULL,NULL),
(425,'BECERRIL',45,9,NULL,NULL),
(426,'BOSCONIA',60,9,NULL,NULL),
(427,'CHIMICHAGUA',175,9,NULL,NULL),
(428,'CHIRIGUANA',178,9,NULL,NULL),
(429,'CURUMANI',228,9,NULL,NULL),
(430,'EL COPEY',238,9,NULL,NULL),
(431,'EL PASO',250,9,NULL,NULL),
(432,'GAMARRA',295,9,NULL,NULL),
(433,'GONZALEZ',310,9,NULL,NULL),
(434,'LA GLORIA',383,9,NULL,NULL),
(435,'LA JAGUA IBIRICO',400,9,NULL,NULL),
(436,'MANAURE (BALCON DEL CESAR)',443,9,NULL,NULL),
(437,'PAILITAS',517,9,NULL,NULL),
(438,'PELAYA',550,9,NULL,NULL),
(439,'PUEBLO BELLO',570,9,NULL,NULL),
(440,'RIO DE ORO',614,9,NULL,NULL),
(441,'LA PAZ (ROBLES)',621,9,NULL,NULL),
(442,'SAN ALBERTO',710,9,NULL,NULL),
(443,'SAN DIEGO',750,9,NULL,NULL),
(444,'SAN MARTIN',770,9,NULL,NULL),
(445,'TAMALAMEQUE',787,9,NULL,NULL),
(446,'MONTERIA',1,10,NULL,NULL),
(447,'AYAPEL',68,10,NULL,NULL),
(448,'BUENAVISTA',79,10,NULL,NULL),
(449,'CANALETE',90,10,NULL,NULL),
(450,'CERETE',162,10,NULL,NULL),
(451,'CHIMA',168,10,NULL,NULL),
(452,'CHINU',182,10,NULL,NULL),
(453,'CIENAGA DE ORO',189,10,NULL,NULL),
(454,'COTORRA',300,10,NULL,NULL),
(455,'LA APARTADA',350,10,NULL,NULL),
(456,'LORICA',417,10,NULL,NULL),
(457,'LOS CORDOBAS',419,10,NULL,NULL),
(458,'MOMIL',464,10,NULL,NULL),
(459,'MONTELIBANO',466,10,NULL,NULL),
(460,'MOÑITOS',500,10,NULL,NULL),
(461,'PLANETA RICA',555,10,NULL,NULL),
(462,'PUEBLO NUEVO',570,10,NULL,NULL),
(463,'PUERTO ESCONDIDO',574,10,NULL,NULL),
(464,'PUERTO LIBERTADOR',580,10,NULL,NULL),
(465,'PURISIMA',586,10,NULL,NULL),
(466,'SAHAGUN',660,10,NULL,NULL),
(467,'SAN ANDRES SOTAVENTO',670,10,NULL,NULL),
(468,'SAN ANTERO',672,10,NULL,NULL),
(469,'SAN BERNARDO DEL VIENTO',675,10,NULL,NULL),
(470,'SAN CARLOS',678,10,NULL,NULL),
(471,'SAN PELAYO',686,10,NULL,NULL),
(472,'TIERRALTA',807,10,NULL,NULL),
(473,'VALENCIA',855,10,NULL,NULL),
(474,'AGUA DE DIOS',1,11,NULL,NULL),
(475,'ALBAN',19,11,NULL,NULL),
(476,'ANAPOIMA',35,11,NULL,NULL),
(477,'ANOLAIMA',40,11,NULL,NULL),
(478,'ARBELAEZ',53,11,NULL,NULL),
(479,'BELTRAN',86,11,NULL,NULL),
(480,'BITUIMA',95,11,NULL,NULL),
(481,'BOJACA',99,11,NULL,NULL),
(482,'CABRERA',120,11,NULL,NULL),
(483,'CACHIPAY',123,11,NULL,NULL),
(484,'CAJICA',126,11,NULL,NULL),
(485,'CAPARRAPI',148,11,NULL,NULL),
(486,'CAQUEZA',151,11,NULL,NULL),
(487,'CARMEN DE CARUPA',154,11,NULL,NULL),
(488,'CHAGUANI',168,11,NULL,NULL),
(489,'CHIA',175,11,NULL,NULL),
(490,'CHIPAQUE',178,11,NULL,NULL),
(491,'CHOACHI',181,11,NULL,NULL),
(492,'CHOCONTA',183,11,NULL,NULL),
(493,'COGUA',200,11,NULL,NULL),
(494,'COTA',214,11,NULL,NULL),
(495,'CUCUNUBA',224,11,NULL,NULL),
(496,'EL COLEGIO',245,11,NULL,NULL),
(497,'EL PEÑON',258,11,NULL,NULL),
(498,'EL ROSAL',260,11,NULL,NULL),
(499,'FACATATIVA',269,11,NULL,NULL),
(500,'FOMEQUE',279,11,NULL,NULL),
(501,'FOSCA',281,11,NULL,NULL),
(502,'FUNZA',286,11,NULL,NULL),
(503,'FUQUENE',288,11,NULL,NULL),
(504,'FUSAGASUGA',290,11,NULL,NULL),
(505,'GACHALA',293,11,NULL,NULL),
(506,'GACHANCIPA',295,11,NULL,NULL),
(507,'GACHETA',297,11,NULL,NULL),
(508,'GAMA',299,11,NULL,NULL),
(509,'GIRARDOT',307,11,NULL,NULL),
(510,'GRANADA',312,11,NULL,NULL),
(511,'GUACHETA',317,11,NULL,NULL),
(512,'GUADUAS',320,11,NULL,NULL),
(513,'GUASCA',322,11,NULL,NULL),
(514,'GUATAQUI',324,11,NULL,NULL),
(515,'GUATAVITA',326,11,NULL,NULL),
(516,'GUAYABAL DE SIQUIMA',328,11,NULL,NULL),
(517,'GUAYABETAL',335,11,NULL,NULL),
(518,'GUTIERREZ',339,11,NULL,NULL),
(519,'JERUSALEN',368,11,NULL,NULL),
(520,'JUNIN',372,11,NULL,NULL),
(521,'LA CALERA',377,11,NULL,NULL),
(522,'LA MESA',386,11,NULL,NULL),
(523,'LA PALMA',394,11,NULL,NULL),
(524,'LA PEÑA',398,11,NULL,NULL),
(525,'LA VEGA',402,11,NULL,NULL),
(526,'LENGUAZAQUE',407,11,NULL,NULL),
(527,'MACHETA',426,11,NULL,NULL),
(528,'MADRID',430,11,NULL,NULL),
(529,'MANTA',436,11,NULL,NULL),
(530,'MEDINA',438,11,NULL,NULL),
(531,'MOSQUERA',473,11,NULL,NULL),
(532,'NARIÑO',483,11,NULL,NULL),
(533,'NEMOCON',486,11,NULL,NULL),
(534,'NILO',488,11,NULL,NULL),
(535,'NIMAIMA',489,11,NULL,NULL),
(536,'NOCAIMA',491,11,NULL,NULL),
(537,'VENECIA (OSPINA PEREZ)',506,11,NULL,NULL),
(538,'PACHO',513,11,NULL,NULL),
(539,'PAIME',518,11,NULL,NULL),
(540,'PANDI',524,11,NULL,NULL),
(541,'PARATEBUENO',530,11,NULL,NULL),
(542,'PASCA',535,11,NULL,NULL),
(543,'PUERTO SALGAR',572,11,NULL,NULL),
(544,'PULI',580,11,NULL,NULL),
(545,'QUEBRADANEGRA',592,11,NULL,NULL),
(546,'QUETAME',594,11,NULL,NULL),
(547,'QUIPILE',596,11,NULL,NULL),
(548,'APULO (RAFAEL REYES)',599,11,NULL,NULL),
(549,'RICAURTE',612,11,NULL,NULL),
(550,'SAN ANTONIO DEL TEQUENDAMA',645,11,NULL,NULL),
(551,'SAN BERNARDO',649,11,NULL,NULL),
(552,'SAN CAYETANO',653,11,NULL,NULL),
(553,'SAN FRANCISCO',658,11,NULL,NULL),
(554,'SAN JUAN DE RIOSECO',662,11,NULL,NULL),
(555,'SASAIMA',718,11,NULL,NULL),
(556,'SESQUILE',736,11,NULL,NULL),
(557,'SIBATE',740,11,NULL,NULL),
(558,'SILVANIA',743,11,NULL,NULL),
(559,'SIMIJACA',745,11,NULL,NULL),
(560,'SOACHA',754,11,NULL,NULL),
(561,'SOPO',758,11,NULL,NULL),
(562,'SUBACHOQUE',769,11,NULL,NULL),
(563,'SUESCA',772,11,NULL,NULL),
(564,'SUPATA',777,11,NULL,NULL),
(565,'SUSA',779,11,NULL,NULL),
(566,'SUTATAUSA',781,11,NULL,NULL),
(567,'TABIO',785,11,NULL,NULL),
(568,'TAUSA',793,11,NULL,NULL),
(569,'TENA',797,11,NULL,NULL),
(570,'TENJO',799,11,NULL,NULL),
(571,'TIBACUY',805,11,NULL,NULL),
(572,'TIBIRITA',807,11,NULL,NULL),
(573,'TOCAIMA',815,11,NULL,NULL),
(574,'TOCANCIPA',817,11,NULL,NULL),
(575,'TOPAIPI',823,11,NULL,NULL),
(576,'UBALA',839,11,NULL,NULL),
(577,'UBAQUE',841,11,NULL,NULL),
(578,'UBATE',843,11,NULL,NULL),
(579,'UNE',845,11,NULL,NULL),
(580,'UTICA',851,11,NULL,NULL),
(581,'VERGARA',862,11,NULL,NULL),
(582,'VIANI',867,11,NULL,NULL),
(583,'VILLAGOMEZ',871,11,NULL,NULL),
(584,'VILLAPINZON',873,11,NULL,NULL),
(585,'VILLETA',875,11,NULL,NULL),
(586,'VIOTA',878,11,NULL,NULL),
(587,'YACOPI',885,11,NULL,NULL),
(588,'ZIPACON',898,11,NULL,NULL),
(589,'ZIPAQUIRA',899,11,NULL,NULL),
(590,'QUIBDO (SAN FRANCISCO DE QUIBDO)',1,12,NULL,NULL),
(591,'ACANDI',6,12,NULL,NULL),
(592,'ALTO BAUDO (PIE DE PATO)',25,12,NULL,NULL),
(593,'ATRATO',50,12,NULL,NULL),
(594,'BAGADO',73,12,NULL,NULL),
(595,'BAHIA SOLANO (MUTIS)',75,12,NULL,NULL),
(596,'BAJO BAUDO (PIZARRO)',77,12,NULL,NULL),
(597,'BOJAYA (BELLAVISTA)',99,12,NULL,NULL),
(598,'CANTON DE SAN PABLO (MANAGRU)',135,12,NULL,NULL),
(599,'CONDOTO',205,12,NULL,NULL),
(600,'EL CARMEN DE ATRATO',245,12,NULL,NULL),
(601,'LITORAL DEL BAJO SAN JUAN (SANTA GENOVEVA DE DOCORDO)',250,12,NULL,NULL),
(602,'ISTMINA',361,12,NULL,NULL),
(603,'JURADO',372,12,NULL,NULL),
(604,'LLORO',413,12,NULL,NULL),
(605,'MEDIO ATRATO',425,12,NULL,NULL),
(606,'MEDIO BAUDO',430,12,NULL,NULL),
(607,'NOVITA',491,12,NULL,NULL),
(608,'NUQUI',495,12,NULL,NULL),
(609,'RIOQUITO',600,12,NULL,NULL),
(610,'RIOSUCIO',615,12,NULL,NULL),
(611,'SAN JOSE DEL PALMAR',660,12,NULL,NULL),
(612,'SIPI',745,12,NULL,NULL),
(613,'TADO',787,12,NULL,NULL),
(614,'UNGUIA',800,12,NULL,NULL),
(615,'UNION PANAMERICANA',810,12,NULL,NULL),
(616,'NEIVA',1,13,NULL,NULL),
(617,'ACEVEDO',6,13,NULL,NULL),
(618,'AGRADO',13,13,NULL,NULL),
(619,'AIPE',16,13,NULL,NULL),
(620,'ALGECIRAS',20,13,NULL,NULL),
(621,'ALTAMIRA',26,13,NULL,NULL),
(622,'BARAYA',78,13,NULL,NULL),
(623,'CAMPOALEGRE',132,13,NULL,NULL),
(624,'COLOMBIA',206,13,NULL,NULL),
(625,'ELIAS',244,13,NULL,NULL),
(626,'GARZON',298,13,NULL,NULL),
(627,'GIGANTE',306,13,NULL,NULL),
(628,'GUADALUPE',319,13,NULL,NULL),
(629,'HOBO',349,13,NULL,NULL),
(630,'IQUIRA',357,13,NULL,NULL),
(631,'ISNOS (SAN JOSE DE ISNOS)',359,13,NULL,NULL),
(632,'LA ARGENTINA',378,13,NULL,NULL),
(633,'LA PLATA',396,13,NULL,NULL),
(634,'NATAGA',483,13,NULL,NULL),
(635,'OPORAPA',503,13,NULL,NULL),
(636,'PAICOL',518,13,NULL,NULL),
(637,'PALERMO',524,13,NULL,NULL),
(638,'PALESTINA',530,13,NULL,NULL),
(639,'PITAL',548,13,NULL,NULL),
(640,'PITALITO',551,13,NULL,NULL),
(641,'RIVERA',615,13,NULL,NULL),
(642,'SALADOBLANCO',660,13,NULL,NULL),
(643,'SAN AGUSTIN',668,13,NULL,NULL),
(644,'SANTA MARIA',676,13,NULL,NULL),
(645,'SUAZA',770,13,NULL,NULL),
(646,'TARQUI',791,13,NULL,NULL),
(647,'TESALIA',797,13,NULL,NULL),
(648,'TELLO',799,13,NULL,NULL),
(649,'TERUEL',801,13,NULL,NULL),
(650,'TIMANA',807,13,NULL,NULL),
(651,'VILLAVIEJA',872,13,NULL,NULL),
(652,'YAGUARA',885,13,NULL,NULL),
(653,'RIOHACHA',1,14,NULL,NULL),
(654,'BARRANCAS',78,14,NULL,NULL),
(655,'DIBULLA',90,14,NULL,NULL),
(656,'DISTRACCION',98,14,NULL,NULL),
(657,'EL MOLINO',110,14,NULL,NULL),
(658,'FONSECA',279,14,NULL,NULL),
(659,'HATONUEVO',378,14,NULL,NULL),
(660,'LA JAGUA DEL PILAR',420,14,NULL,NULL),
(661,'MAICAO',430,14,NULL,NULL),
(662,'MANAURE',560,14,NULL,NULL),
(663,'SAN JUAN DEL CESAR',650,14,NULL,NULL),
(664,'URIBIA',847,14,NULL,NULL),
(665,'URUMITA',855,14,NULL,NULL),
(666,'VILLANUEVA',874,14,NULL,NULL),
(667,'SANTA MARTA (DISTRITO TURISTICO CULTURAL E HISTORICO DE SANTA MARTA)',1,15,NULL,NULL),
(668,'ALGARROBO',30,15,NULL,NULL),
(669,'ARACATACA',53,15,NULL,NULL),
(670,'ARIGUANI (EL DIFICIL)',58,15,NULL,NULL),
(671,'CERRO SAN ANTONIO',161,15,NULL,NULL),
(672,'CHIVOLO',170,15,NULL,NULL),
(673,'CIENAGA',189,15,NULL,NULL),
(674,'CONCORDIA',205,15,NULL,NULL),
(675,'EL BANCO',245,15,NULL,NULL),
(676,'EL PIÑON',258,15,NULL,NULL),
(677,'EL RETEN',268,15,NULL,NULL),
(678,'FUNDACION',288,15,NULL,NULL),
(679,'GUAMAL',318,15,NULL,NULL),
(680,'PEDRAZA',541,15,NULL,NULL),
(681,'PIJIÑO DEL CARMEN (PIJIÑO)',545,15,NULL,NULL),
(682,'PIVIJAY',551,15,NULL,NULL),
(683,'PLATO',555,15,NULL,NULL),
(684,'PUEBLOVIEJO',570,15,NULL,NULL),
(685,'REMOLINO',605,15,NULL,NULL),
(686,'SABANAS DE SAN ANGEL',660,15,NULL,NULL),
(687,'SALAMINA',675,15,NULL,NULL),
(688,'SAN SEBASTIAN DE BUENAVISTA',692,15,NULL,NULL),
(689,'SAN ZENON',703,15,NULL,NULL),
(690,'SANTA ANA',707,15,NULL,NULL),
(691,'SITIONUEVO',745,15,NULL,NULL),
(692,'TENERIFE',798,15,NULL,NULL),
(693,'VILLAVICENCIO',1,16,NULL,NULL),
(694,'ACACIAS',6,16,NULL,NULL),
(695,'BARRANCA DE UPIA',110,16,NULL,NULL),
(696,'CABUYARO',124,16,NULL,NULL),
(697,'CASTILLA LA NUEVA',150,16,NULL,NULL),
(698,'SAN LUIS DE CUBARRAL',223,16,NULL,NULL),
(699,'CUMARAL',226,16,NULL,NULL),
(700,'EL CALVARIO',245,16,NULL,NULL),
(701,'EL CASTILLO',251,16,NULL,NULL),
(702,'EL DORADO',270,16,NULL,NULL),
(703,'FUENTE DE ORO',287,16,NULL,NULL),
(704,'GRANADA',313,16,NULL,NULL),
(705,'GUAMAL',318,16,NULL,NULL),
(706,'MAPIRIPAN',325,16,NULL,NULL),
(707,'MESETAS',330,16,NULL,NULL),
(708,'LA MACARENA',350,16,NULL,NULL),
(709,'LA URIBE',370,16,NULL,NULL),
(710,'LEJANIAS',400,16,NULL,NULL),
(711,'PUERTO CONCORDIA',450,16,NULL,NULL),
(712,'PUERTO GAITAN',568,16,NULL,NULL),
(713,'PUERTO LOPEZ',573,16,NULL,NULL),
(714,'PUERTO LLERAS',577,16,NULL,NULL),
(715,'PUERTO RICO',590,16,NULL,NULL),
(716,'RESTREPO',606,16,NULL,NULL),
(717,'SAN CARLOS DE GUAROA',680,16,NULL,NULL),
(718,'SAN JUAN DE ARAMA',683,16,NULL,NULL),
(719,'SAN JUANITO',686,16,NULL,NULL),
(720,'SAN MARTIN',689,16,NULL,NULL),
(721,'VISTAHERMOSA',711,16,NULL,NULL),
(722,'PASTO (SAN JUAN DE PASTO)',1,17,NULL,NULL),
(723,'ALBAN (SAN JOSE)',19,17,NULL,NULL),
(724,'ALDANA',22,17,NULL,NULL),
(725,'ANCUYA',36,17,NULL,NULL),
(726,'ARBOLEDA (BERRUECOS)',51,17,NULL,NULL),
(727,'BARBACOAS',79,17,NULL,NULL),
(728,'BELEN',83,17,NULL,NULL),
(729,'BUESACO',110,17,NULL,NULL),
(730,'COLON (GENOVA)',203,17,NULL,NULL),
(731,'CONSACA',207,17,NULL,NULL),
(732,'CONTADERO',210,17,NULL,NULL),
(733,'CORDOBA',215,17,NULL,NULL),
(734,'CUASPUD (CARLOSAMA)',224,17,NULL,NULL),
(735,'CUMBAL',227,17,NULL,NULL),
(736,'CUMBITARA',233,17,NULL,NULL),
(737,'CHACHAGUI',240,17,NULL,NULL),
(738,'EL CHARCO',250,17,NULL,NULL),
(739,'EL PEÑOL',254,17,NULL,NULL),
(740,'EL ROSARIO',256,17,NULL,NULL),
(741,'EL TABLON',258,17,NULL,NULL),
(742,'EL TAMBO',260,17,NULL,NULL),
(743,'FUNES',287,17,NULL,NULL),
(744,'GUACHUCAL',317,17,NULL,NULL),
(745,'GUAITARILLA',320,17,NULL,NULL),
(746,'GUALMATAN',323,17,NULL,NULL),
(747,'ILES',352,17,NULL,NULL),
(748,'IMUES',354,17,NULL,NULL),
(749,'IPIALES',356,17,NULL,NULL),
(750,'LA CRUZ',378,17,NULL,NULL),
(751,'LA FLORIDA',381,17,NULL,NULL),
(752,'LA LLANADA',385,17,NULL,NULL),
(753,'LA TOLA',390,17,NULL,NULL),
(754,'LA UNION',399,17,NULL,NULL),
(755,'LEIVA',405,17,NULL,NULL),
(756,'LINARES',411,17,NULL,NULL),
(757,'LOS ANDES (SOTOMAYOR)',418,17,NULL,NULL),
(758,'MAGUI (PAYAN)',427,17,NULL,NULL),
(759,'MALLAMA (PIEDRANCHA)',435,17,NULL,NULL),
(760,'MOSQUERA',473,17,NULL,NULL),
(761,'OLAYA HERRERA (BOCAS DE SATINGA)',490,17,NULL,NULL),
(762,'OSPINA',506,17,NULL,NULL),
(763,'FRANCISCO PIZARRO (SALAHONDA)',520,17,NULL,NULL),
(764,'POLICARPA',540,17,NULL,NULL),
(765,'POTOSI',560,17,NULL,NULL),
(766,'PROVIDENCIA',565,17,NULL,NULL),
(767,'PUERRES',573,17,NULL,NULL),
(768,'PUPIALES',585,17,NULL,NULL),
(769,'RICAURTE',612,17,NULL,NULL),
(770,'ROBERTO PAYAN (SAN JOSE)',621,17,NULL,NULL),
(771,'SAMANIEGO',678,17,NULL,NULL),
(772,'SANDONA',683,17,NULL,NULL),
(773,'SAN BERNARDO',685,17,NULL,NULL),
(774,'SAN LORENZO',687,17,NULL,NULL),
(775,'SAN PABLO',693,17,NULL,NULL),
(776,'SAN PEDRO DE CARTAGO',694,17,NULL,NULL),
(777,'SANTA BARBARA (ISCUANDE)',696,17,NULL,NULL),
(778,'SANTA CRUZ (GUACHAVES)',699,17,NULL,NULL),
(779,'SAPUYES',720,17,NULL,NULL),
(780,'TAMINANGO',786,17,NULL,NULL),
(781,'TANGUA',788,17,NULL,NULL),
(782,'TUMACO',835,17,NULL,NULL),
(783,'TUQUERRES',838,17,NULL,NULL),
(784,'YACUANQUER',885,17,NULL,NULL),
(785,'CUCUTA',1,18,NULL,NULL),
(786,'ABREGO',3,18,NULL,NULL),
(787,'ARBOLEDAS',51,18,NULL,NULL),
(788,'BOCHALEMA',99,18,NULL,NULL),
(789,'BUCARASICA',109,18,NULL,NULL),
(790,'CACOTA',125,18,NULL,NULL),
(791,'CACHIRA',128,18,NULL,NULL),
(792,'CHINACOTA',172,18,NULL,NULL),
(793,'CHITAGA',174,18,NULL,NULL),
(794,'CONVENCION',206,18,NULL,NULL),
(795,'CUCUTILLA',223,18,NULL,NULL),
(796,'DURANIA',239,18,NULL,NULL),
(797,'EL CARMEN',245,18,NULL,NULL),
(798,'EL TARRA',250,18,NULL,NULL),
(799,'EL ZULIA',261,18,NULL,NULL),
(800,'GRAMALOTE',313,18,NULL,NULL),
(801,'HACARI',344,18,NULL,NULL),
(802,'HERRAN',347,18,NULL,NULL),
(803,'LABATECA',377,18,NULL,NULL),
(804,'LA ESPERANZA',385,18,NULL,NULL),
(805,'LA PLAYA',398,18,NULL,NULL),
(806,'LOS PATIOS',405,18,NULL,NULL),
(807,'LOURDES',418,18,NULL,NULL),
(808,'MUTISCUA',480,18,NULL,NULL),
(809,'OCAÑA',498,18,NULL,NULL),
(810,'PAMPLONA',518,18,NULL,NULL),
(811,'PAMPLONITA',520,18,NULL,NULL),
(812,'PUERTO SANTANDER',553,18,NULL,NULL),
(813,'RAGONVALIA',599,18,NULL,NULL),
(814,'SALAZAR',660,18,NULL,NULL),
(815,'SAN CALIXTO',670,18,NULL,NULL),
(816,'SAN CAYETANO',673,18,NULL,NULL),
(817,'SANTIAGO',680,18,NULL,NULL),
(818,'SARDINATA',720,18,NULL,NULL),
(819,'SILOS',743,18,NULL,NULL),
(820,'TEORAMA',800,18,NULL,NULL),
(821,'TIBU',810,18,NULL,NULL),
(822,'TOLEDO',820,18,NULL,NULL),
(823,'VILLACARO',871,18,NULL,NULL),
(824,'VILLA DEL ROSARIO',874,18,NULL,NULL),
(825,'ARMENIA',1,19,NULL,NULL),
(826,'BUENAVISTA',111,19,NULL,NULL),
(827,'CALARCA',130,19,NULL,NULL),
(828,'CIRCASIA',190,19,NULL,NULL),
(829,'CORDOBA',212,19,NULL,NULL),
(830,'FILANDIA',272,19,NULL,NULL),
(831,'GENOVA',302,19,NULL,NULL),
(832,'LA TEBAIDA',401,19,NULL,NULL),
(833,'MONTENEGRO',470,19,NULL,NULL),
(834,'PIJAO',548,19,NULL,NULL),
(835,'QUIMBAYA',594,19,NULL,NULL),
(836,'SALENTO',690,19,NULL,NULL),
(837,'PEREIRA',1,20,NULL,NULL),
(838,'APIA',45,20,NULL,NULL),
(839,'BALBOA',75,20,NULL,NULL),
(840,'BELEN DE UMBRIA',88,20,NULL,NULL),
(841,'DOS QUEBRADAS',170,20,NULL,NULL),
(842,'GUATICA',318,20,NULL,NULL),
(843,'LA CELIA',383,20,NULL,NULL),
(844,'LA VIRGINIA',400,20,NULL,NULL),
(845,'MARSELLA',440,20,NULL,NULL),
(846,'MISTRATO',456,20,NULL,NULL),
(847,'PUEBLO RICO',572,20,NULL,NULL),
(848,'QUINCHIA',594,20,NULL,NULL),
(849,'SANTA ROSA DE CABAL',682,20,NULL,NULL),
(850,'SANTUARIO',687,20,NULL,NULL),
(851,'BUCARAMANGA',1,21,NULL,NULL),
(852,'AGUADA',13,21,NULL,NULL),
(853,'ALBANIA',20,21,NULL,NULL),
(854,'ARATOCA',51,21,NULL,NULL),
(855,'BARBOSA',77,21,NULL,NULL),
(856,'BARICHARA',79,21,NULL,NULL),
(857,'BARRANCABERMEJA',81,21,NULL,NULL),
(858,'BETULIA',92,21,NULL,NULL),
(859,'BOLIVAR',101,21,NULL,NULL),
(860,'CABRERA',121,21,NULL,NULL),
(861,'CALIFORNIA',132,21,NULL,NULL),
(862,'CAPITANEJO',147,21,NULL,NULL),
(863,'CARCASI',152,21,NULL,NULL),
(864,'CEPITA',160,21,NULL,NULL),
(865,'CERRITO',162,21,NULL,NULL),
(866,'CHARALA',167,21,NULL,NULL),
(867,'CHARTA',169,21,NULL,NULL),
(868,'CHIMA',176,21,NULL,NULL),
(869,'CHIPATA',179,21,NULL,NULL),
(870,'CIMITARRA',190,21,NULL,NULL),
(871,'CONCEPCION',207,21,NULL,NULL),
(872,'CONFINES',209,21,NULL,NULL),
(873,'CONTRATACION',211,21,NULL,NULL),
(874,'COROMORO',217,21,NULL,NULL),
(875,'CURITI',229,21,NULL,NULL),
(876,'EL CARMEN DE CHUCURY',235,21,NULL,NULL),
(877,'EL GUACAMAYO',245,21,NULL,NULL),
(878,'EL PEÑON',250,21,NULL,NULL),
(879,'EL PLAYON',255,21,NULL,NULL),
(880,'ENCINO',264,21,NULL,NULL),
(881,'ENCISO',266,21,NULL,NULL),
(882,'FLORIAN',271,21,NULL,NULL),
(883,'FLORIDABLANCA',276,21,NULL,NULL),
(884,'GALAN',296,21,NULL,NULL),
(885,'GAMBITA',298,21,NULL,NULL),
(886,'GIRON',307,21,NULL,NULL),
(887,'GUACA',318,21,NULL,NULL),
(888,'GUADALUPE',320,21,NULL,NULL),
(889,'GUAPOTA',322,21,NULL,NULL),
(890,'GUAVATA',324,21,NULL,NULL),
(891,'GUEPSA',327,21,NULL,NULL),
(892,'HATO',344,21,NULL,NULL),
(893,'JESUS MARIA',368,21,NULL,NULL),
(894,'JORDAN',370,21,NULL,NULL),
(895,'LA BELLEZA',377,21,NULL,NULL),
(896,'LANDAZURI',385,21,NULL,NULL),
(897,'LA PAZ',397,21,NULL,NULL),
(898,'LEBRIJA',406,21,NULL,NULL),
(899,'LOS SANTOS',418,21,NULL,NULL),
(900,'MACARAVITA',425,21,NULL,NULL),
(901,'MALAGA',432,21,NULL,NULL),
(902,'MATANZA',444,21,NULL,NULL),
(903,'MOGOTES',464,21,NULL,NULL),
(904,'MOLAGAVITA',468,21,NULL,NULL),
(905,'OCAMONTE',498,21,NULL,NULL),
(906,'OIBA',500,21,NULL,NULL),
(907,'ONZAGA',502,21,NULL,NULL),
(908,'PALMAR',522,21,NULL,NULL),
(909,'PALMAS DEL SOCORRO',524,21,NULL,NULL),
(910,'PARAMO',533,21,NULL,NULL),
(911,'PIEDECUESTA',547,21,NULL,NULL),
(912,'PINCHOTE',549,21,NULL,NULL),
(913,'PUENTE NACIONAL',572,21,NULL,NULL),
(914,'PUERTO PARRA',573,21,NULL,NULL),
(915,'PUERTO WILCHES',575,21,NULL,NULL),
(916,'RIONEGRO',615,21,NULL,NULL),
(917,'SABANA DE TORRES',655,21,NULL,NULL),
(918,'SAN ANDRES',669,21,NULL,NULL),
(919,'SAN BENITO',673,21,NULL,NULL),
(920,'SAN GIL',679,21,NULL,NULL),
(921,'SAN JOAQUIN',682,21,NULL,NULL),
(922,'SAN JOSE DE MIRANDA',684,21,NULL,NULL),
(923,'SAN MIGUEL',686,21,NULL,NULL),
(924,'SAN VICENTE DE CHUCURI',689,21,NULL,NULL),
(925,'SANTA BARBARA',705,21,NULL,NULL),
(926,'SANTA HELENA DEL OPON',720,21,NULL,NULL),
(927,'SIMACOTA',745,21,NULL,NULL),
(928,'SOCORRO',755,21,NULL,NULL),
(929,'SUAITA',770,21,NULL,NULL),
(930,'SUCRE',773,21,NULL,NULL),
(931,'SURATA',780,21,NULL,NULL),
(932,'TONA',820,21,NULL,NULL),
(933,'VALLE SAN JOSE',855,21,NULL,NULL),
(934,'VELEZ',861,21,NULL,NULL),
(935,'VETAS',867,21,NULL,NULL),
(936,'VILLANUEVA',872,21,NULL,NULL),
(937,'ZAPATOCA',895,21,NULL,NULL),
(938,'SINCELEJO',1,22,NULL,NULL),
(939,'BUENAVISTA',110,22,NULL,NULL),
(940,'CAIMITO',124,22,NULL,NULL),
(941,'COLOSO (RICAURTE)',204,22,NULL,NULL),
(942,'COROZAL',215,22,NULL,NULL),
(943,'CHALAN',230,22,NULL,NULL),
(944,'GALERAS (NUEVA GRANADA)',235,22,NULL,NULL),
(945,'GUARANDA',265,22,NULL,NULL),
(946,'LA UNION',400,22,NULL,NULL),
(947,'LOS PALMITOS',418,22,NULL,NULL),
(948,'MAJAGUAL',429,22,NULL,NULL),
(949,'MORROA',473,22,NULL,NULL),
(950,'OVEJAS',508,22,NULL,NULL),
(951,'PALMITO',523,22,NULL,NULL),
(952,'SAMPUES',670,22,NULL,NULL),
(953,'SAN BENITO ABAD',678,22,NULL,NULL),
(954,'SAN JUAN DE BETULIA',702,22,NULL,NULL),
(955,'SAN MARCOS',708,22,NULL,NULL),
(956,'SAN ONOFRE',713,22,NULL,NULL),
(957,'SAN PEDRO',717,22,NULL,NULL),
(958,'SINCE',742,22,NULL,NULL),
(959,'SUCRE',771,22,NULL,NULL),
(960,'TOLU',820,22,NULL,NULL),
(961,'TOLUVIEJO',823,22,NULL,NULL),
(962,'IBAGUE',1,23,NULL,NULL),
(963,'ALPUJARRA',24,23,NULL,NULL),
(964,'ALVARADO',26,23,NULL,NULL),
(965,'AMBALEMA',30,23,NULL,NULL),
(966,'ANZOATEGUI',43,23,NULL,NULL),
(967,'ARMERO (GUAYABAL)',55,23,NULL,NULL),
(968,'ATACO',67,23,NULL,NULL),
(969,'CAJAMARCA',124,23,NULL,NULL),
(970,'CARMEN APICALA',148,23,NULL,NULL),
(971,'CASABIANCA',152,23,NULL,NULL),
(972,'CHAPARRAL',168,23,NULL,NULL),
(973,'COELLO',200,23,NULL,NULL),
(974,'COYAIMA',217,23,NULL,NULL),
(975,'CUNDAY',226,23,NULL,NULL),
(976,'DOLORES',236,23,NULL,NULL),
(977,'ESPINAL',268,23,NULL,NULL),
(978,'FALAN',270,23,NULL,NULL),
(979,'FLANDES',275,23,NULL,NULL),
(980,'FRESNO',283,23,NULL,NULL),
(981,'GUAMO',319,23,NULL,NULL),
(982,'HERVEO',347,23,NULL,NULL),
(983,'HONDA',349,23,NULL,NULL),
(984,'ICONONZO',352,23,NULL,NULL),
(985,'LERIDA',408,23,NULL,NULL),
(986,'LIBANO',411,23,NULL,NULL),
(987,'MARIQUITA',443,23,NULL,NULL),
(988,'MELGAR',449,23,NULL,NULL),
(989,'MURILLO',461,23,NULL,NULL),
(990,'NATAGAIMA',483,23,NULL,NULL),
(991,'ORTEGA',504,23,NULL,NULL),
(992,'PALOCABILDO',520,23,NULL,NULL),
(993,'PIEDRAS',547,23,NULL,NULL),
(994,'PLANADAS',555,23,NULL,NULL),
(995,'PRADO',563,23,NULL,NULL),
(996,'PURIFICACION',585,23,NULL,NULL),
(997,'RIOBLANCO',616,23,NULL,NULL),
(998,'RONCESVALLES',622,23,NULL,NULL),
(999,'ROVIRA',624,23,NULL,NULL),
(1000,'SALDAÑA',671,23,NULL,NULL),
(1001,'SAN ANTONIO',675,23,NULL,NULL),
(1002,'SAN LUIS',678,23,NULL,NULL),
(1003,'SANTA ISABEL',686,23,NULL,NULL),
(1004,'SUAREZ',770,23,NULL,NULL),
(1005,'VALLE DE SAN JUAN',854,23,NULL,NULL),
(1006,'VENADILLO',861,23,NULL,NULL),
(1007,'VILLAHERMOSA',870,23,NULL,NULL),
(1008,'VILLARRICA',873,23,NULL,NULL),
(1009,'CALI (SANTIAGO DE CALI)',1,24,NULL,NULL),
(1010,'ALCALA',20,24,NULL,NULL),
(1011,'ANDALUCIA',36,24,NULL,NULL),
(1012,'ANSERMANUEVO',41,24,NULL,NULL),
(1013,'ARGELIA',54,24,NULL,NULL),
(1014,'BOLIVAR',100,24,NULL,NULL),
(1015,'BUENAVENTURA',109,24,NULL,NULL),
(1016,'BUGA',111,24,NULL,NULL),
(1017,'BUGALAGRANDE',113,24,NULL,NULL),
(1018,'CAICEDONIA',122,24,NULL,NULL),
(1019,'CALIMA (DARIEN)',126,24,NULL,NULL),
(1020,'CANDELARIA',130,24,NULL,NULL),
(1021,'CARTAGO',147,24,NULL,NULL),
(1022,'DAGUA',233,24,NULL,NULL),
(1023,'EL AGUILA',243,24,NULL,NULL),
(1024,'EL CAIRO',246,24,NULL,NULL),
(1025,'EL CERRITO',248,24,NULL,NULL),
(1026,'EL DOVIO',250,24,NULL,NULL),
(1027,'FLORIDA',275,24,NULL,NULL),
(1028,'GINEBRA',306,24,NULL,NULL),
(1029,'GUACARI',318,24,NULL,NULL),
(1030,'JAMUNDI',364,24,NULL,NULL),
(1031,'LA CUMBRE',377,24,NULL,NULL),
(1032,'LA UNION',400,24,NULL,NULL),
(1033,'LA VICTORIA',403,24,NULL,NULL),
(1034,'OBANDO',497,24,NULL,NULL),
(1035,'PALMIRA',520,24,NULL,NULL),
(1036,'PRADERA',563,24,NULL,NULL),
(1037,'RESTREPO',606,24,NULL,NULL),
(1038,'RIOFRIO',616,24,NULL,NULL),
(1039,'ROLDANILLO',622,24,NULL,NULL),
(1040,'SAN PEDRO',670,24,NULL,NULL),
(1041,'SEVILLA',736,24,NULL,NULL),
(1042,'TORO',823,24,NULL,NULL),
(1043,'TRUJILLO',828,24,NULL,NULL),
(1044,'TULUA',834,24,NULL,NULL),
(1045,'ULLOA',845,24,NULL,NULL),
(1046,'VERSALLES',863,24,NULL,NULL),
(1047,'VIJES',869,24,NULL,NULL),
(1048,'YOTOCO',890,24,NULL,NULL),
(1049,'YUMBO',892,24,NULL,NULL),
(1050,'ZARZAL',895,24,NULL,NULL),
(1051,'ARAUCA',1,25,NULL,NULL),
(1052,'ARAUQUITA',65,25,NULL,NULL),
(1053,'CRAVO NORTE',220,25,NULL,NULL),
(1054,'FORTUL',300,25,NULL,NULL),
(1055,'PUERTO RONDON',591,25,NULL,NULL),
(1056,'SARAVENA',736,25,NULL,NULL),
(1057,'TAME',794,25,NULL,NULL),
(1058,'YOPAL',1,26,NULL,NULL),
(1059,'AGUAZUL',10,26,NULL,NULL),
(1060,'CHAMEZA',15,26,NULL,NULL),
(1061,'HATO COROZAL',125,26,NULL,NULL),
(1062,'LA SALINA',136,26,NULL,NULL),
(1063,'MANI',139,26,NULL,NULL),
(1064,'MONTERREY',162,26,NULL,NULL),
(1065,'NUNCHIA',225,26,NULL,NULL),
(1066,'OROCUE',230,26,NULL,NULL),
(1067,'PAZ DE ARIPORO',250,26,NULL,NULL),
(1068,'PORE',263,26,NULL,NULL),
(1069,'RECETOR',279,26,NULL,NULL),
(1070,'SABANALARGA',300,26,NULL,NULL),
(1071,'SACAMA',315,26,NULL,NULL),
(1072,'SAN LUIS DE PALENQUE',325,26,NULL,NULL),
(1073,'TAMARA',400,26,NULL,NULL),
(1074,'TAURAMENA',410,26,NULL,NULL),
(1075,'TRINIDAD',430,26,NULL,NULL),
(1076,'VILLANUEVA',440,26,NULL,NULL),
(1077,'MOCOA',1,27,NULL,NULL),
(1078,'COLON',219,27,NULL,NULL),
(1079,'ORITO',320,27,NULL,NULL),
(1080,'PUERTO ASIS',568,27,NULL,NULL),
(1081,'PUERTO CAICEDO',569,27,NULL,NULL),
(1082,'PUERTO GUZMAN',571,27,NULL,NULL),
(1083,'PUERTO LEGUIZAMO',573,27,NULL,NULL),
(1084,'SIBUNDOY',749,27,NULL,NULL),
(1085,'SAN FRANCISCO',755,27,NULL,NULL),
(1086,'SAN MIGUEL (LA DORADA)',757,27,NULL,NULL),
(1087,'SANTIAGO',760,27,NULL,NULL),
(1088,'LA HORMIGA (VALLE DEL GUAMUEZ)',865,27,NULL,NULL),
(1089,'VILLAGARZON',885,27,NULL,NULL),
(1090,'SAN ANDRES',1,28,NULL,NULL),
(1091,'PROVIDENCIA',564,28,NULL,NULL),
(1092,'LETICIA',1,29,NULL,NULL),
(1093,'EL ENCANTO',263,29,NULL,NULL),
(1094,'LA CHORRERA',405,29,NULL,NULL),
(1095,'LA PEDRERA',407,29,NULL,NULL),
(1096,'LA VICTORIA',430,29,NULL,NULL),
(1097,'MIRITI-PARANA',460,29,NULL,NULL),
(1098,'PUERTO ALEGRIA',530,29,NULL,NULL),
(1099,'PUERTO ARICA',536,29,NULL,NULL),
(1100,'PUERTO NARIÑO',540,29,NULL,NULL),
(1101,'PUERTO SANTANDER',669,29,NULL,NULL),
(1102,'TARAPACA',798,29,NULL,NULL),
(1103,'PUERTO INIRIDA',1,30,NULL,NULL),
(1104,'BARRANCO MINAS',343,30,NULL,NULL),
(1105,'SAN FELIPE',883,30,NULL,NULL),
(1106,'PUERTO COLOMBIA',884,30,NULL,NULL),
(1107,'LA GUADALUPE',885,30,NULL,NULL),
(1108,'CACAHUAL',886,30,NULL,NULL),
(1109,'PANA PANA (CAMPO ALEGRE)',887,30,NULL,NULL),
(1110,'MORICHAL (MORICHAL NUEVO)',888,30,NULL,NULL),
(1111,'SAN JOSE DEL GUAVIARE',1,31,NULL,NULL),
(1112,'CALAMAR',15,31,NULL,NULL),
(1113,'EL RETORNO',25,31,NULL,NULL),
(1114,'MIRAFLORES',200,31,NULL,NULL),
(1115,'MITU',1,32,NULL,NULL),
(1116,'CARURU',161,32,NULL,NULL),
(1117,'PACOA',511,32,NULL,NULL),
(1118,'TARAIRA',666,32,NULL,NULL),
(1119,'PAPUNAUA (MORICHAL)',777,32,NULL,NULL),
(1120,'YAVARATE',889,32,NULL,NULL),
(1121,'PUERTO CARREÑO',1,33,NULL,NULL),
(1122,'LA PRIMAVERA',524,33,NULL,NULL),
(1123,'SANTA RITA',572,33,NULL,NULL),
(1124,'SANTA ROSALIA',666,33,NULL,NULL),
(1125,'SAN JOSE DE OCUNE',760,33,NULL,NULL),
(1126,'CUMARIBO',773,33,NULL,NULL);

/*Table structure for table `client_policies` */

DROP TABLE IF EXISTS `client_policies`;

CREATE TABLE `client_policies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `policy_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `state_policy_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `client_policies_client_id_foreign` (`client_id`),
  KEY `client_policies_policy_id_foreign` (`policy_id`),
  KEY `client_policies_state_policy_id_foreign` (`state_policy_id`),
  CONSTRAINT `client_policies_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `client_policies_policy_id_foreign` FOREIGN KEY (`policy_id`) REFERENCES `authorization_policies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `client_policies_state_policy_id_foreign` FOREIGN KEY (`state_policy_id`) REFERENCES `state_policies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `client_policies` */

/*Table structure for table `clients` */

DROP TABLE IF EXISTS `clients`;

CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `identification` varchar(50) NOT NULL,
  `name_last_name` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `value_Title` varchar(50) DEFAULT NULL,
  `date_birth` date NOT NULL,
  `expedition_date` date NOT NULL,
  `neighborhood` varchar(50) NOT NULL,
  `vehicle` tinyint(4) NOT NULL DEFAULT 0,
  `estate` tinyint(4) NOT NULL DEFAULT 0,
  `seizure` tinyint(4) NOT NULL DEFAULT 0,
  `company_seizure` varchar(255) DEFAULT NULL,
  `acept_data_processing_policies` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `quality_holder_id` bigint(20) unsigned DEFAULT NULL,
  `marital_status_id` bigint(20) unsigned NOT NULL,
  `level_study_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `clients_identification_unique` (`identification`),
  KEY `clients_quality_holder_id_foreign` (`quality_holder_id`),
  KEY `clients_marital_status_id_foreign` (`marital_status_id`),
  KEY `clients_level_study_id_foreign` (`level_study_id`),
  CONSTRAINT `clients_level_study_id_foreign` FOREIGN KEY (`level_study_id`) REFERENCES `level_studies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `clients_marital_status_id_foreign` FOREIGN KEY (`marital_status_id`) REFERENCES `marital_status` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `clients_quality_holder_id_foreign` FOREIGN KEY (`quality_holder_id`) REFERENCES `quality_holders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `clients` */

/*Table structure for table `company_payment_dates` */

DROP TABLE IF EXISTS `company_payment_dates`;

CREATE TABLE `company_payment_dates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `company_payment_dates` */

insert  into `company_payment_dates`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Dia 5','',NULL,NULL),
(2,'Dia 10','',NULL,NULL),
(3,'Dia 20','',NULL,NULL),
(4,'Dia 30','',NULL,NULL),
(5,'Dia 5 | 20','',NULL,NULL),
(6,'Dia 10 | 25','',NULL,NULL),
(7,'Dia 15 | 30','',NULL,NULL);

/*Table structure for table `contact_informations` */

DROP TABLE IF EXISTS `contact_informations`;

CREATE TABLE `contact_informations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(50) NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `phone_type_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contact_informations_client_id_foreign` (`client_id`),
  KEY `contact_informations_phone_type_id_foreign` (`phone_type_id`),
  CONSTRAINT `contact_informations_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `contact_informations_phone_type_id_foreign` FOREIGN KEY (`phone_type_id`) REFERENCES `phone_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `contact_informations` */

/*Table structure for table `contract_types` */

DROP TABLE IF EXISTS `contract_types`;

CREATE TABLE `contract_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `contract_types` */

insert  into `contract_types`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Indefinido','',NULL,NULL),
(2,'Prestacion de servicios','',NULL,NULL),
(3,'Termino fijo','',NULL,NULL);

/*Table structure for table `customer_payment_dates` */

DROP TABLE IF EXISTS `customer_payment_dates`;

CREATE TABLE `customer_payment_dates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `customer_payment_dates` */

insert  into `customer_payment_dates`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'5','',NULL,NULL),
(2,'10','',NULL,NULL),
(3,'20','',NULL,NULL),
(4,'30','',NULL,NULL),
(5,'5 | 20','',NULL,NULL),
(6,'10 | 25','',NULL,NULL),
(7,'15 | 30','',NULL,NULL);

/*Table structure for table `document_types` */

DROP TABLE IF EXISTS `document_types`;

CREATE TABLE `document_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `document_types` */

insert  into `document_types`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Cedula de ciudadania (ambos lados)',NULL,'2025-11-24 16:51:37','2025-11-26 22:53:07'),
(2,'Certificado laboral no mayor a 30 dias',NULL,'2025-11-26 01:56:51','2025-11-26 22:54:11'),
(3,'Desprendible de pago del ultimo mes',NULL,'2025-11-26 01:57:49','2025-11-26 01:59:49'),
(4,'Extracto bancario utlimo mes',NULL,'2025-11-26 01:59:32','2025-11-26 22:58:14'),
(5,'Carnet de empleado ambas caras',NULL,'2025-11-26 02:06:45','2025-11-26 22:59:42'),
(6,'Carnet ARL ambas caras',NULL,'2025-11-26 02:07:15','2025-11-26 23:02:07'),
(7,'Recibo de servicio publico',NULL,'2025-11-26 02:07:58','2025-11-26 23:03:09');

/*Table structure for table `documents` */

DROP TABLE IF EXISTS `documents`;

CREATE TABLE `documents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `document_type_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `documents_client_id_foreign` (`client_id`),
  KEY `documents_document_type_id_foreign` (`document_type_id`),
  CONSTRAINT `documents_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `documents_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `document_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `documents` */

/*Table structure for table `employment_informations` */

DROP TABLE IF EXISTS `employment_informations`;

CREATE TABLE `employment_informations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nit_company_work` varchar(50) NOT NULL,
  `company_works` varchar(100) NOT NULL,
  `main_address` varchar(50) NOT NULL,
  `city_id` bigint(20) unsigned NOT NULL,
  `company_on_mission` varchar(50) DEFAULT NULL,
  `nit` varchar(50) DEFAULT NULL,
  `branch_address` varchar(50) DEFAULT NULL,
  `entry_date` date NOT NULL,
  `average_monthly_salary` decimal(10,2) NOT NULL,
  `current_position` varchar(255) NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `payment_frequency_id` bigint(20) unsigned NOT NULL,
  `company_payment_date_id` bigint(20) unsigned NOT NULL,
  `customer_payment_date_id` bigint(20) unsigned NOT NULL,
  `contract_type_id` bigint(20) unsigned NOT NULL,
  `eps_affiliate_id` bigint(20) unsigned NOT NULL,
  `arl_affiliate_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `state_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `employment_informations_client_id_foreign` (`client_id`),
  KEY `employment_informations_payment_frequency_id_foreign` (`payment_frequency_id`),
  KEY `employment_informations_company_payment_date_id_foreign` (`company_payment_date_id`),
  KEY `employment_informations_customer_payment_date_id_foreign` (`customer_payment_date_id`),
  KEY `employment_informations_contract_type_id_foreign` (`contract_type_id`),
  KEY `employment_informations_eps_affiliate_id_foreign` (`eps_affiliate_id`),
  KEY `employment_informations_arl_affiliate_id_foreign` (`arl_affiliate_id`),
  KEY `employment_informations_city_id_foreign` (`city_id`),
  KEY `employment_informations_state_id_foreign` (`state_id`),
  CONSTRAINT `employment_informations_arl_affiliate_id_foreign` FOREIGN KEY (`arl_affiliate_id`) REFERENCES `arl_affiliates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `employment_informations_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `employment_informations_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `employment_informations_company_payment_date_id_foreign` FOREIGN KEY (`company_payment_date_id`) REFERENCES `company_payment_dates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `employment_informations_contract_type_id_foreign` FOREIGN KEY (`contract_type_id`) REFERENCES `contract_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `employment_informations_customer_payment_date_id_foreign` FOREIGN KEY (`customer_payment_date_id`) REFERENCES `customer_payment_dates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `employment_informations_eps_affiliate_id_foreign` FOREIGN KEY (`eps_affiliate_id`) REFERENCES `eps_affiliates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `employment_informations_payment_frequency_id_foreign` FOREIGN KEY (`payment_frequency_id`) REFERENCES `payment_frequency` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `employment_informations_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `employment_informations` */

/*Table structure for table `eps_affiliates` */

DROP TABLE IF EXISTS `eps_affiliates`;

CREATE TABLE `eps_affiliates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `eps_affiliates` */

insert  into `eps_affiliates`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(17,'ALIANSALUD',NULL,NULL,NULL),
(18,'CAJACOPI',NULL,NULL,NULL),
(19,'CONSALUD',NULL,NULL,NULL),
(20,'COOSALUD',NULL,NULL,NULL),
(21,'FAMISANAR',NULL,NULL,NULL),
(22,'MEDIEPS',NULL,NULL,NULL),
(23,'MUTUAL SER',NULL,NULL,NULL),
(24,'NUEVA EPS',NULL,NULL,NULL),
(25,'SALUD TOTAL',NULL,NULL,NULL),
(26,'SANITAS',NULL,NULL,NULL),
(27,'SURA',NULL,NULL,NULL);

/*Table structure for table `failed_jobs` */

DROP TABLE IF EXISTS `failed_jobs`;

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `failed_jobs` */

/*Table structure for table `level_studies` */

DROP TABLE IF EXISTS `level_studies`;

CREATE TABLE `level_studies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `level_studies` */

insert  into `level_studies`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Bachiller',NULL,NULL,NULL),
(2,'Tecnico',NULL,NULL,NULL),
(3,'Pre grado',NULL,NULL,NULL),
(4,'Post grado',NULL,NULL,NULL);

/*Table structure for table `loans` */

DROP TABLE IF EXISTS `loans`;

CREATE TABLE `loans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference` varchar(50) NOT NULL,
  `ammount` decimal(10,2) NOT NULL,
  `term` varchar(255) NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `warranty_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `loans_reference_unique` (`reference`),
  KEY `loans_client_id_foreign` (`client_id`),
  KEY `loans_warranty_id_foreign` (`warranty_id`),
  CONSTRAINT `loans_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `loans_warranty_id_foreign` FOREIGN KEY (`warranty_id`) REFERENCES `warranties` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `loans` */

/*Table structure for table `marital_status` */

DROP TABLE IF EXISTS `marital_status`;

CREATE TABLE `marital_status` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `marital_status` */

insert  into `marital_status`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Casado','',NULL,NULL),
(2,'Soltero','',NULL,NULL),
(3,'Union libre','',NULL,NULL),
(4,'Viudo','',NULL,NULL);

/*Table structure for table `migrations` */

DROP TABLE IF EXISTS `migrations`;

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

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values 
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_reset_tokens_table',1),
(3,'2019_08_19_000000_create_failed_jobs_table',1),
(4,'2019_12_14_000001_create_personal_access_tokens_table',1),
(5,'2025_10_22_224906_create_clients_table',1),
(6,'2025_10_29_162016_add_to_clients_table',1),
(7,'2025_10_29_181035_create__quality_holders_table',1),
(8,'2025_10_29_181629_create__marital_status_table',1),
(9,'2025_10_29_212509_create_phone_types_table',1),
(10,'2025_10_29_212945_create_contact_informations_table',1),
(11,'2025_10_29_214918_create_payment_frequency_table',1),
(12,'2025_10_29_220003_create_company_payment_date_table',1),
(13,'2025_10_29_225110_create_customer_payment_date_table',1),
(14,'2025_10_29_233543_create_contract_type_table',1),
(15,'2025_10_29_233913_create_eps_affiliate_table',1),
(16,'2025_10_29_235806_create_arl_affiliates_table',1),
(17,'2025_10_30_155523_create__employment_information_table',1),
(18,'2025_10_30_192557_create_level_studies_table',1),
(19,'2025_10_30_192849_add_to_clients_table',1),
(20,'2025_10_30_195221_create_warranties_table',1),
(21,'2025_10_30_203118_create_loans_table',1),
(22,'2025_11_03_204857_create_states_table',1),
(23,'2025_11_03_205403_create_cities_table',1),
(24,'2025_11_03_210323_add_to_employment_informations_table',1),
(25,'2025_11_10_164341_add_to_employment_informations_table',1),
(26,'2025_11_13_134645_add_to_clients_table',2),
(27,'2025_11_19_131930_create_authorization_policies_table',3),
(28,'2025_11_19_212136_create_client_policies_table',4),
(29,'2025_11_19_213611_add_to_clients_table',4),
(30,'2025_11_23_180509_create_document_types_table',5),
(31,'2025_11_23_204913_create_documents_table',5),
(32,'2025_11_24_183852_create_state_policies_table',6),
(33,'2025_11_24_184150_add_to_client_policies_table',7);

/*Table structure for table `password_reset_tokens` */

DROP TABLE IF EXISTS `password_reset_tokens`;

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `password_reset_tokens` */

/*Table structure for table `payment_frequency` */

DROP TABLE IF EXISTS `payment_frequency`;

CREATE TABLE `payment_frequency` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `payment_frequency` */

insert  into `payment_frequency`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Semanal','',NULL,NULL),
(2,'Quincenal','',NULL,NULL),
(3,'Mensual','',NULL,NULL);

/*Table structure for table `personal_access_tokens` */

DROP TABLE IF EXISTS `personal_access_tokens`;

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `personal_access_tokens` */

/*Table structure for table `phone_types` */

DROP TABLE IF EXISTS `phone_types`;

CREATE TABLE `phone_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `phone_types` */

insert  into `phone_types`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Celular','',NULL,NULL),
(2,'WhatsApp','',NULL,NULL),
(3,'Fijo','',NULL,NULL),
(4,'Corporativo','',NULL,NULL);

/*Table structure for table `quality_holders` */

DROP TABLE IF EXISTS `quality_holders`;

CREATE TABLE `quality_holders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `quality_holders` */

insert  into `quality_holders`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Deudor titular','',NULL,NULL),
(2,'Fiador solidario','',NULL,NULL),
(3,'Fiador solidario cruzado','',NULL,NULL);

/*Table structure for table `state_policies` */

DROP TABLE IF EXISTS `state_policies`;

CREATE TABLE `state_policies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `state_policies` */

insert  into `state_policies`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Acepto',NULL,NULL,NULL),
(2,'No aepto',NULL,NULL,NULL),
(3,'No entiendo',NULL,NULL,NULL);

/*Table structure for table `states` */

DROP TABLE IF EXISTS `states`;

CREATE TABLE `states` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `code` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `states` */

insert  into `states`(`id`,`name`,`code`,`created_at`,`updated_at`) values 
(1,'Antioquia',5,NULL,NULL),
(2,'Atlantico',8,NULL,NULL),
(3,'Bogotá D. C. ',11,NULL,NULL),
(4,'Bolivar',13,NULL,NULL),
(5,'Boyaca',15,NULL,NULL),
(6,'Caldas',17,NULL,NULL),
(7,'Caqueta',18,NULL,NULL),
(8,'Cauca',19,NULL,NULL),
(9,'Cesar',20,NULL,NULL),
(10,'Cordova',23,NULL,NULL),
(11,'Cundinamarca',25,NULL,NULL),
(12,'Choco',27,NULL,NULL),
(13,'Huila',41,NULL,NULL),
(14,'La Guajira',44,NULL,NULL),
(15,'Magdalena',47,NULL,NULL),
(16,'Meta',50,NULL,NULL),
(17,'Nariño',52,NULL,NULL),
(18,'Norte de Santander',54,NULL,NULL),
(19,'Quindio',63,NULL,NULL),
(20,'Risaralda',66,NULL,NULL),
(21,'Santander',68,NULL,NULL),
(22,'Sucre',70,NULL,NULL),
(23,'Tolima',73,NULL,NULL),
(24,'Valle',76,NULL,NULL),
(25,'Arauca',81,NULL,NULL),
(26,'Casanare',85,NULL,NULL),
(27,'Putumayo',86,NULL,NULL),
(28,'San Andres',88,NULL,NULL),
(29,'Amazonas',91,NULL,NULL),
(30,'Guainia',94,NULL,NULL),
(31,'Guaviare',95,NULL,NULL),
(32,'Vaupes',97,NULL,NULL),
(33,'Vichada',99,NULL,NULL);

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `users` */

insert  into `users`(`id`,`name`,`email`,`email_verified_at`,`password`,`remember_token`,`created_at`,`updated_at`) values 
(1,'admin','admin@example.com',NULL,'$2y$12$8JQGS7yH1dHX97UDtfbJtung58yO96yZPj/1N0bo7AVJ.QKBPU9Iq',NULL,NULL,NULL);

/*Table structure for table `warranties` */

DROP TABLE IF EXISTS `warranties`;

CREATE TABLE `warranties` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `warranties` */

insert  into `warranties`(`id`,`name`,`description`,`created_at`,`updated_at`) values 
(1,'Letra',NULL,NULL,NULL),
(2,'Pagaré',NULL,NULL,NULL),
(3,'Palabra',NULL,NULL,NULL),
(4,'Prenda de garantia',NULL,NULL,NULL),
(5,'Clave virtual',NULL,NULL,NULL),
(6,'Contrato de arriendo',NULL,NULL,NULL),
(7,'Hipoteca',NULL,NULL,NULL),
(8,'Pignoración',NULL,NULL,NULL),
(9,'Letra y pagare',NULL,NULL,NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
