text: -- phpMyAdmin SQL Dump
  -- version 4.5.2
  -- http://www.phpmyadmin.net
  --
  -- Servidor: 127.0.0.1
  -- Tiempo de generación: 24-08-2016 a las 04:23:24
  -- Versión del servidor: 5.7.9
  -- Versión de PHP: 5.6.16
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Base de datos: `pd_marroquineria`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `bodega`
  --
  
  DROP TABLE IF EXISTS `bodega`;
  CREATE TABLE IF NOT EXISTS `bodega` (
    `bod_id` int(11) NOT NULL AUTO_INCREMENT,
    `pro_id` int(11) NOT NULL,
    `bod_total` int(11) DEFAULT NULL,
    PRIMARY KEY (`bod_id`),
    KEY `fk_bodega_producto1_idx` (`pro_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `ciudad`
  --
  
  DROP TABLE IF EXISTS `ciudad`;
  CREATE TABLE IF NOT EXISTS `ciudad` (
    `ciu_id` int(11) NOT NULL AUTO_INCREMENT,
    `ciu_nombre` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`ciu_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2217 DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `ciudad`
  --
  
  INSERT INTO `ciudad` (`ciu_id`, `ciu_nombre`) VALUES
  (1, 'EL ENCANTO'),
  (2, 'LA CHORRERA'),
  (3, 'LA PEDRERA'),
  (4, 'LA VICTORIA'),
  (5, 'LETICIA'),
  (6, 'MIRITI'),
  (7, 'PUERTO ALEGRIA'),
  (8, 'PUERTO ARICA'),
  (9, 'PUERTO NARIÑO'),
  (10, 'PUERTO SANTANDER'),
  (11, 'TURAPACA'),
  (12, 'ABEJORRAL'),
  (13, 'ABRIAQUI'),
  (14, 'ALEJANDRIA'),
  (15, 'AMAGA'),
  (16, 'AMALFI'),
  (17, 'ANDES'),
  (18, 'ANGELOPOLIS'),
  (19, 'ANGOSTURA'),
  (20, 'ANORI'),
  (21, 'ANTIOQUIA'),
  (22, 'ANZA'),
  (23, 'APARTADO'),
  (24, 'ARBOLETES'),
  (25, 'ARGELIA'),
  (26, 'ARMENIA'),
  (27, 'BARBOSA'),
  (28, 'BELLO'),
  (29, 'BELMIRA'),
  (30, 'BETANIA'),
  (31, 'BETULIA'),
  (32, 'BOLIVAR'),
  (33, 'BRICEÑO'),
  (34, 'BURITICA'),
  (35, 'CACERES'),
  (36, 'CAICEDO'),
  (37, 'CALDAS'),
  (38, 'CAMPAMENTO'),
  (39, 'CANASGORDAS'),
  (40, 'CARACOLI'),
  (41, 'CARAMANTA'),
  (42, 'CAREPA'),
  (43, 'CAROLINA DEL PRINCIPE'),
  (44, 'CAUCASIA'),
  (45, 'CHIGORODO'),
  (46, 'CISNEROS'),
  (47, 'COCORNA'),
  (48, 'CONCEPCION'),
  (49, 'CONCORDIA'),
  (50, 'COPACABANA'),
  (51, 'DABEIBA'),
  (52, 'DONMATIAS'),
  (53, 'EBEJICO'),
  (54, 'EL BAGRE'),
  (55, 'EL PENOL'),
  (56, 'EL RETIRO'),
  (57, 'ENTRERRIOS'),
  (58, 'ENVIGADO'),
  (59, 'FREDONIA'),
  (60, 'FRONTINO'),
  (61, 'GIRALDO'),
  (62, 'GIRARDOTA'),
  (63, 'GOMEZ PLATA'),
  (64, 'GRANADA'),
  (65, 'GUADALUPE'),
  (66, 'GUARNE'),
  (67, 'GUATAQUE'),
  (68, 'HELICONIA'),
  (69, 'HISPANIA'),
  (70, 'ITAGUI'),
  (71, 'ITUANGO'),
  (72, 'JARDIN'),
  (73, 'JERICO'),
  (74, 'LA CEJA'),
  (75, 'LA ESTRELLA'),
  (76, 'LA PINTADA'),
  (77, 'LA UNION'),
  (78, 'LIBORINA'),
  (79, 'MACEO'),
  (80, 'MARINILLA'),
  (81, 'MEDELLIN'),
  (82, 'MONTEBELLO'),
  (83, 'MURINDO'),
  (84, 'MUTATA'),
  (85, 'NARINO'),
  (86, 'NECHI'),
  (87, 'NECOCLI'),
  (88, 'OLAYA'),
  (89, 'PEQUE'),
  (90, 'PUEBLORRICO'),
  (91, 'PUERTO BERRIO'),
  (92, 'PUERTO NARE'),
  (93, 'PUERTO TRIUNFO'),
  (94, 'REMEDIOS'),
  (95, 'RIONEGRO'),
  (96, 'SABANALARGA'),
  (97, 'SABANETA'),
  (98, 'SALGAR'),
  (99, 'SAN ANDRES DE CERQUIA'),
  (100, 'SAN CARLOS'),
  (101, 'SAN FRANCISCO'),
  (102, 'SAN JERONIMO'),
  (103, 'SAN JOSE DE LA MONTAÑA'),
  (104, 'SAN JUAN DE URABA'),
  (105, 'SAN LUIS'),
  (106, 'SAN PEDRO DE LOS MILAROS'),
  (107, 'SAN PEDRO DE URABA'),
  (108, 'SAN RAFAEL'),
  (109, 'SAN ROQUE'),
  (110, 'SAN VICENTE'),
  (111, 'SANTA BARBARA'),
  (112, 'SANTA ROSA DE OSOS'),
  (113, 'SANTO DOMINGO'),
  (114, 'SANTUARIO'),
  (115, 'SEGOVIA'),
  (116, 'SONSON'),
  (117, 'SOPETRAN'),
  (118, 'TAMESIS'),
  (119, 'TARAZA'),
  (120, 'TARSO'),
  (121, 'TITIRIBI'),
  (122, 'TOLEDO'),
  (123, 'TURBO'),
  (124, 'URAMITA'),
  (125, 'URRAO'),
  (126, 'VALDIVIA'),
  (127, 'VALPARAISO'),
  (128, 'VEGACHI'),
  (129, 'VENECIA'),
  (130, 'VIGIA DEL FUERTE'),
  (131, 'YALI'),
  (132, 'YARUMAL'),
  (133, 'YOLOMBO'),
  (134, 'YONDO'),
  (135, 'ZARAGOZA'),
  (136, 'ARAUCA'),
  (137, 'ARAUQUITA'),
  (138, 'CRAVO NORTE'),
  (139, 'FORTUL'),
  (140, 'PUERTO RONDON'),
  (141, 'SARAVENA'),
  (142, 'TAME'),
  (143, 'BARANOA'),
  (144, 'BARRANQUILLA'),
  (145, 'CAMPO DE LA CRUZ'),
  (146, 'CANDELARIA'),
  (147, 'GALAPA'),
  (148, 'JUAN DE ACOSTA'),
  (149, 'LURUACO'),
  (150, 'MALAMBO'),
  (151, 'MANATI'),
  (152, 'PALMAR DE VARELA'),
  (153, 'PIOJO'),
  (154, 'POLO NUEVO'),
  (155, 'PONEDERA'),
  (156, 'PUERTO COLOMBIA'),
  (157, 'REPELON'),
  (158, 'SABANAGRANDE'),
  (159, 'SABANALARGA'),
  (160, 'SANTA LUCIA'),
  (161, 'SANTO TOMAS'),
  (162, 'SOLEDAD'),
  (163, 'SUAN'),
  (164, 'TUBARA'),
  (165, 'USIACURI'),
  (166, 'ACHI'),
  (167, 'ALTOS DEL OSARIO'),
  (168, 'ARENAL'),
  (169, 'ARJONA'),
  (170, 'ARROYOHONDO'),
  (171, 'BARRANCO DE LOBA'),
  (172, 'BRAZUELO DE PAPAYAL'),
  (173, 'CALAMAR'),
  (174, 'CANTAGALLO'),
  (175, 'CARTAGENA DE INDIAS'),
  (176, 'CICUCO'),
  (177, 'CLEMENCIA'),
  (178, 'CORDOBA'),
  (179, 'EL CARMEN DE BOLIVAR'),
  (180, 'EL GUAMO'),
  (181, 'EL PENION'),
  (182, 'HATILLO DE LOBA'),
  (183, 'MAGANGUE'),
  (184, 'MAHATES'),
  (185, 'MARGARITA'),
  (186, 'MARIA LA BAJA'),
  (187, 'MONTECRISTO'),
  (188, 'MORALES'),
  (189, 'MORALES'),
  (190, 'NOROSI'),
  (191, 'PINILLOS'),
  (192, 'REGIDOR'),
  (193, 'RIO VIEJO'),
  (194, 'SAN CRISTOBAL'),
  (195, 'SAN ESTANISLAO'),
  (196, 'SAN FERNANDO'),
  (197, 'SAN JACINTO'),
  (198, 'SAN JACINTO DEL CAUCA'),
  (199, 'SAN JUAN DE NEPOMUCENO'),
  (200, 'SAN MARTIN DE LOBA'),
  (201, 'SAN PABLO'),
  (202, 'SAN PABLO NORTE'),
  (203, 'SANTA CATALINA'),
  (204, 'SANTA CRUZ DE MOMPOX'),
  (205, 'SANTA ROSA'),
  (206, 'SANTA ROSA DEL SUR'),
  (207, 'SIMITI'),
  (208, 'SOPLAVIENTO'),
  (209, 'TALAIGUA NUEVO'),
  (210, 'TUQUISIO'),
  (211, 'TURBACO'),
  (212, 'TURBANA'),
  (213, 'VILLANUEVA'),
  (214, 'ZAMBRANO'),
  (215, 'AQUITANIA'),
  (216, 'ARCABUCO'),
  (217, 'BELÉN'),
  (218, 'BERBEO'),
  (219, 'BETÉITIVA'),
  (220, 'BOAVITA'),
  (221, 'BOYACÁ'),
  (222, 'BRICEÑO'),
  (223, 'BUENAVISTA'),
  (224, 'BUSBANZÁ'),
  (225, 'CALDAS'),
  (226, 'CAMPO HERMOSO'),
  (227, 'CERINZA'),
  (228, 'CHINAVITA'),
  (229, 'CHIQUINQUIRÁ'),
  (230, 'CHÍQUIZA'),
  (231, 'CHISCAS'),
  (232, 'CHITA'),
  (233, 'CHITARAQUE'),
  (234, 'CHIVATÁ'),
  (235, 'CIÉNEGA'),
  (236, 'CÓMBITA'),
  (237, 'COPER'),
  (238, 'CORRALES'),
  (239, 'COVARACHÍA'),
  (240, 'CUBARA'),
  (241, 'CUCAITA'),
  (242, 'CUITIVA'),
  (243, 'DUITAMA'),
  (244, 'EL COCUY'),
  (245, 'EL ESPINO'),
  (246, 'FIRAVITOBA'),
  (247, 'FLORESTA'),
  (248, 'GACHANTIVÁ'),
  (249, 'GÁMEZA'),
  (250, 'GARAGOA'),
  (251, 'GUACAMAYAS'),
  (252, 'GÜICÁN'),
  (253, 'IZA'),
  (254, 'JENESANO'),
  (255, 'JERICÓ'),
  (256, 'LA UVITA'),
  (257, 'LA VICTORIA'),
  (258, 'LABRANZA GRANDE'),
  (259, 'MACANAL'),
  (260, 'MARIPÍ'),
  (261, 'MIRAFLORES'),
  (262, 'MONGUA'),
  (263, 'MONGUÍ'),
  (264, 'MONIQUIRÁ'),
  (265, 'MOTAVITA'),
  (266, 'MUZO'),
  (267, 'NOBSA'),
  (268, 'NUEVO COLÓN'),
  (269, 'OICATÁ'),
  (270, 'OTANCHE'),
  (271, 'PACHAVITA'),
  (272, 'PÁEZ'),
  (273, 'PAIPA'),
  (274, 'PAJARITO'),
  (275, 'PANQUEBA'),
  (276, 'PAUNA'),
  (277, 'PAYA'),
  (278, 'PAZ DE RÍO'),
  (279, 'PESCA'),
  (280, 'PISBA'),
  (281, 'PUERTO BOYACA'),
  (282, 'QUÍPAMA'),
  (283, 'RAMIRIQUÍ'),
  (284, 'RÁQUIRA'),
  (285, 'RONDÓN'),
  (286, 'SABOYÁ'),
  (287, 'SÁCHICA'),
  (288, 'SAMACÁ'),
  (289, 'SAN EDUARDO'),
  (290, 'SAN JOSÉ DE PARE'),
  (291, 'SAN LUÍS DE GCENO'),
  (292, 'SAN MATEO'),
  (293, 'SAN MIGUEL DE SEMA'),
  (294, 'SAN PABLO DE BORBUR'),
  (295, 'SANTA MARÍA'),
  (296, 'SANTA ROSA DE VITERBO'),
  (297, 'SANTA SOFÍA'),
  (298, 'SANTANA'),
  (299, 'SATIVANORTE'),
  (300, 'SATIVASUR'),
  (301, 'SIACHOQUE'),
  (302, 'SOATÁ'),
  (303, 'SOCHA'),
  (304, 'SOCOTÁ'),
  (305, 'SOGAMOSO'),
  (306, 'SORA'),
  (307, 'SORACÁ'),
  (308, 'SOTAQUIRÁ'),
  (309, 'SUSACÓN'),
  (310, 'SUTARMACHÁN'),
  (311, 'TASCO'),
  (312, 'TIBANÁ'),
  (313, 'TIBASOSA'),
  (314, 'TINJACÁ'),
  (315, 'TIPACOQUE'),
  (316, 'TOCA'),
  (317, 'TOGÜÍ'),
  (318, 'TÓPAGA'),
  (319, 'TOTA'),
  (320, 'TUNJA'),
  (321, 'TUNUNGUÁ'),
  (322, 'TURMEQUÉ'),
  (323, 'TUTA'),
  (324, 'TUTAZÁ'),
  (325, 'UMBITA'),
  (326, 'VENTA QUEMADA'),
  (327, 'VILLA DE LEYVA'),
  (328, 'VIRACACHÁ'),
  (329, 'ZETAQUIRA'),
  (330, 'AGUADAS'),
  (331, 'ANSERMA'),
  (332, 'ARANZAZU'),
  (333, 'BELALCAZAR'),
  (334, 'CHINCHINÁ'),
  (335, 'FILADELFIA'),
  (336, 'LA DORADA'),
  (337, 'LA MERCED'),
  (338, 'MANIZALES'),
  (339, 'MANZANARES'),
  (340, 'MARMATO'),
  (341, 'MARQUETALIA'),
  (342, 'MARULANDA'),
  (343, 'NEIRA'),
  (344, 'NORCASIA'),
  (345, 'PACORA'),
  (346, 'PALESTINA'),
  (347, 'PENSILVANIA'),
  (348, 'RIOSUCIO'),
  (349, 'RISARALDA'),
  (350, 'SALAMINA'),
  (351, 'SAMANA'),
  (352, 'SAN JOSE'),
  (353, 'SUPÍA'),
  (354, 'VICTORIA'),
  (355, 'VILLAMARÍA'),
  (356, 'VITERBO'),
  (357, 'ALBANIA'),
  (358, 'BELÉN ANDAQUIES'),
  (359, 'CARTAGENA DEL CHAIRA'),
  (360, 'CURILLO'),
  (361, 'EL DONCELLO'),
  (362, 'EL PAUJIL'),
  (363, 'FLORENCIA'),
  (364, 'LA MONTAÑITA'),
  (365, 'MILÁN'),
  (366, 'MORELIA'),
  (367, 'PUERTO RICO'),
  (368, 'SAN  VICENTE DEL CAGUAN'),
  (369, 'SAN JOSÉ DE FRAGUA'),
  (370, 'SOLANO'),
  (371, 'SOLITA'),
  (372, 'VALPARAÍSO'),
  (373, 'AGUAZUL'),
  (374, 'CHAMEZA'),
  (375, 'HATO COROZAL'),
  (376, 'LA SALINA'),
  (377, 'MANÍ'),
  (378, 'MONTERREY'),
  (379, 'NUNCHIA'),
  (380, 'OROCUE'),
  (381, 'PAZ DE ARIPORO'),
  (382, 'PORE'),
  (383, 'RECETOR'),
  (384, 'SABANA LARGA'),
  (385, 'SACAMA'),
  (386, 'SAN LUIS DE PLENQUE'),
  (387, 'TAMARA'),
  (388, 'TAURAMENA'),
  (389, 'TRINIDAD'),
  (390, 'VILLANUEVA'),
  (391, 'YOPAL'),
  (392, 'ALMAGUER'),
  (393, 'ARGELIA'),
  (394, 'BALBOA'),
  (395, 'BOLÍVAR'),
  (396, 'BUENOS AIRE'),
  (397, 'CAJIBIO'),
  (398, 'CALDONO'),
  (399, 'CALOTO'),
  (400, 'CORINTO'),
  (401, 'EL TAMBO'),
  (402, 'FLORENCIA'),
  (403, 'GUAPI'),
  (404, 'INZA'),
  (405, 'JAMBALÓ'),
  (406, 'LA SIERRA'),
  (407, 'LA VEGA'),
  (408, 'LÓPEZ'),
  (409, 'MERCADERES'),
  (410, 'MIRANDA'),
  (411, 'MORALES'),
  (412, 'PADILLA'),
  (413, 'PÁEZ'),
  (414, 'PATIA (EL BORDO)'),
  (415, 'PIAMONTE'),
  (416, 'PIENDAMO'),
  (417, 'POPAYÁN'),
  (418, 'PUERTO TEJADA'),
  (419, 'PURACE'),
  (420, 'ROSAS'),
  (421, 'SAN SEBASTIÁN'),
  (422, 'SANTA ROSA'),
  (423, 'SILVIA'),
  (424, 'SOTARA'),
  (425, 'SUÁREZ'),
  (426, 'SUCRE'),
  (427, 'TIMBÍO'),
  (428, 'TIMBIQUÍ'),
  (429, 'TORIBIO'),
  (430, 'TOTORO'),
  (431, 'VILLA RICA'),
  (432, 'AGUACHICA'),
  (433, 'AGUSTÍN CODAZZI'),
  (434, 'ASTREA'),
  (435, 'BECERRIL'),
  (436, 'BOSCONIA'),
  (437, 'CHIMICHAGUA'),
  (438, 'CHIRIGUANÁ'),
  (439, 'CURUMANÍ'),
  (440, 'EL COPEY'),
  (441, 'EL PASO'),
  (442, 'GAMARRA'),
  (443, 'GONZÁLEZ'),
  (444, 'LA GLORIA'),
  (445, 'LA JAGUA IBIRICO'),
  (446, 'MANAURE BALCÓN DEL CESAR'),
  (447, 'PAILITAS'),
  (448, 'PELAYA'),
  (449, 'PUEBLO BELLO'),
  (450, 'RÍO DE ORO'),
  (451, 'ROBLES (LA PAZ)'),
  (452, 'SAN ALBERTO'),
  (453, 'SAN DIEGO'),
  (454, 'SAN MARTÍN'),
  (455, 'TAMALAMEQUE'),
  (456, 'VALLEDUPAR'),
  (457, 'ACANDI'),
  (458, 'ALTO BAUDO (PIE DE PATO)'),
  (459, 'ATRATO'),
  (460, 'BAGADO'),
  (461, 'BAHIA SOLANO (MUTIS)'),
  (462, 'BAJO BAUDO (PIZARRO)'),
  (463, 'BOJAYA (BELLAVISTA)'),
  (464, 'CANTON DE SAN PABLO'),
  (465, 'CARMEN DEL DARIEN'),
  (466, 'CERTEGUI'),
  (467, 'CONDOTO'),
  (468, 'EL CARMEN'),
  (469, 'ISTMINA'),
  (470, 'JURADO'),
  (471, 'LITORAL DEL SAN JUAN'),
  (472, 'LLORO'),
  (473, 'MEDIO ATRATO'),
  (474, 'MEDIO BAUDO (BOCA DE PEPE)'),
  (475, 'MEDIO SAN JUAN'),
  (476, 'NOVITA'),
  (477, 'NUQUI'),
  (478, 'QUIBDO'),
  (479, 'RIO IRO'),
  (480, 'RIO QUITO'),
  (481, 'RIOSUCIO'),
  (482, 'SAN JOSE DEL PALMAR'),
  (483, 'SIPI'),
  (484, 'TADO'),
  (485, 'UNGUIA'),
  (486, 'UNIÓN PANAMERICANA'),
  (487, 'AYAPEL'),
  (488, 'BUENAVISTA'),
  (489, 'CANALETE'),
  (490, 'CERETÉ'),
  (491, 'CHIMA'),
  (492, 'CHINÚ'),
  (493, 'CIENAGA DE ORO'),
  (494, 'COTORRA'),
  (495, 'LA APARTADA'),
  (496, 'LORICA'),
  (497, 'LOS CÓRDBAS'),
  (498, 'MOMIL'),
  (499, 'MONTELÍBANO'),
  (500, 'MONTERÍA'),
  (501, 'MOÑITOS'),
  (502, 'PLANETA RICA'),
  (503, 'PUEBLO NUEVO'),
  (504, 'PUERTO ESCONDIDO'),
  (505, 'PUERTO LIBERTADOR'),
  (506, 'PURÍSIMA'),
  (507, 'SAHAGÚN'),
  (508, 'SAN ANDRÉS SOTAENTO'),
  (509, 'SAN ANTERO'),
  (510, 'SAN BERNARDO VIENTO'),
  (511, 'SAN CARLOS'),
  (512, 'SAN PELAYO'),
  (513, 'TIERRALTA'),
  (514, 'VALENCIA'),
  (515, 'AGUA DE DIOS'),
  (516, 'ALBAN'),
  (517, 'ANAPOIMA'),
  (518, 'ANOLAIMA'),
  (519, 'ARBELAEZ'),
  (520, 'BELTRÁN'),
  (521, 'BITUIMA'),
  (522, 'BOGOTÁ DC'),
  (523, 'BOJACÁ'),
  (524, 'CABRERA'),
  (525, 'CACHIPAY'),
  (526, 'CAJICÁ'),
  (527, 'CAPARRAPÍ'),
  (528, 'CAQUEZA'),
  (529, 'CARMEN DE CARUPA'),
  (530, 'CHAGUANÍ'),
  (531, 'CHIA'),
  (532, 'CHIPAQUE'),
  (533, 'CHOACHÍ'),
  (534, 'CHOCONTÁ'),
  (535, 'COGUA'),
  (536, 'COTA'),
  (537, 'CUCUNUBÁ'),
  (538, 'EL COLEGIO'),
  (539, 'EL PEÑÓN'),
  (540, 'EL ROSAL'),
  (541, 'FACATATIVA'),
  (542, 'FÓMEQUE'),
  (543, 'FOSCA'),
  (544, 'FUNZA'),
  (545, 'FÚQUENE'),
  (546, 'FUSAGASUGA'),
  (547, 'GACHALÁ'),
  (548, 'GACHANCIPÁ'),
  (549, 'GACHETA'),
  (550, 'GAMA'),
  (551, 'GIRARDOT'),
  (552, 'GRANADA'),
  (553, 'GUACHETÁ'),
  (554, 'GUADUAS'),
  (555, 'GUASCA'),
  (556, 'GUATAQUÍ'),
  (557, 'GUATAVITA'),
  (558, 'GUAYABAL DE SIQUIMA'),
  (559, 'GUAYABETAL'),
  (560, 'GUTIÉRREZ'),
  (561, 'JERUSALÉN'),
  (562, 'JUNÍN'),
  (563, 'LA CALERA'),
  (564, 'LA MESA'),
  (565, 'LA PALMA'),
  (566, 'LA PEÑA'),
  (567, 'LA VEGA'),
  (568, 'LENGUAZAQUE'),
  (569, 'MACHETÁ'),
  (570, 'MADRID'),
  (571, 'MANTA'),
  (572, 'MEDINA'),
  (573, 'MOSQUERA'),
  (574, 'NARIÑO'),
  (575, 'NEMOCÓN'),
  (576, 'NILO'),
  (577, 'NIMAIMA'),
  (578, 'NOCAIMA'),
  (579, 'OSPINA PÉREZ'),
  (580, 'PACHO'),
  (581, 'PAIME'),
  (582, 'PANDI'),
  (583, 'PARATEBUENO'),
  (584, 'PASCA'),
  (585, 'PUERTO SALGAR'),
  (586, 'PULÍ'),
  (587, 'QUEBRADANEGRA'),
  (588, 'QUETAME'),
  (589, 'QUIPILE'),
  (590, 'RAFAEL REYES'),
  (591, 'RICAURTE'),
  (592, 'SAN  ANTONIO DEL  TEQUENDAMA'),
  (593, 'SAN BERNARDO'),
  (594, 'SAN CAYETANO'),
  (595, 'SAN FRANCISCO'),
  (596, 'SAN JUAN DE RIOSECO'),
  (597, 'SASAIMA'),
  (598, 'SESQUILÉ'),
  (599, 'SIBATÉ'),
  (600, 'SILVANIA'),
  (601, 'SIMIJACA'),
  (602, 'SOACHA'),
  (603, 'SOPO'),
  (604, 'SUBACHOQUE'),
  (605, 'SUESCA'),
  (606, 'SUPATÁ'),
  (607, 'SUSA'),
  (608, 'SUTATAUSA'),
  (609, 'TABIO'),
  (610, 'TAUSA'),
  (611, 'TENA'),
  (612, 'TENJO'),
  (613, 'TIBACUY'),
  (614, 'TIBIRITA'),
  (615, 'TOCAIMA'),
  (616, 'TOCANCIPÁ'),
  (617, 'TOPAIPÍ'),
  (618, 'UBALÁ'),
  (619, 'UBAQUE'),
  (620, 'UBATÉ'),
  (621, 'UNE'),
  (622, 'UTICA'),
  (623, 'VERGARA'),
  (624, 'VIANI'),
  (625, 'VILLA GOMEZ'),
  (626, 'VILLA PINZÓN'),
  (627, 'VILLETA'),
  (628, 'VIOTA'),
  (629, 'YACOPÍ'),
  (630, 'ZIPACÓN'),
  (631, 'ZIPAQUIRÁ'),
  (632, 'BARRANCO MINAS'),
  (633, 'CACAHUAL'),
  (634, 'INÍRIDA'),
  (635, 'LA GUADALUPE'),
  (636, 'MAPIRIPANA'),
  (637, 'MORICHAL'),
  (638, 'PANA PANA'),
  (639, 'PUERTO COLOMBIA'),
  (640, 'SAN FELIPE'),
  (641, 'CALAMAR'),
  (642, 'EL RETORNO'),
  (643, 'MIRAFLOREZ'),
  (644, 'SAN JOSÉ DEL GUAVIARE'),
  (645, 'ACEVEDO'),
  (646, 'AGRADO'),
  (647, 'AIPE'),
  (648, 'ALGECIRAS'),
  (649, 'ALTAMIRA'),
  (650, 'BARAYA'),
  (651, 'CAMPO ALEGRE'),
  (652, 'COLOMBIA'),
  (653, 'ELIAS'),
  (654, 'GARZÓN'),
  (655, 'GIGANTE'),
  (656, 'GUADALUPE'),
  (657, 'HOBO'),
  (658, 'IQUIRA'),
  (659, 'ISNOS'),
  (660, 'LA ARGENTINA'),
  (661, 'LA PLATA'),
  (662, 'NATAGA'),
  (663, 'NEIVA'),
  (664, 'OPORAPA'),
  (665, 'PAICOL'),
  (666, 'PALERMO'),
  (667, 'PALESTINA'),
  (668, 'PITAL'),
  (669, 'PITALITO'),
  (670, 'RIVERA'),
  (671, 'SALADO BLANCO'),
  (672, 'SAN AGUSTÍN'),
  (673, 'SANTA MARIA'),
  (674, 'SUAZA'),
  (675, 'TARQUI'),
  (676, 'TELLO'),
  (677, 'TERUEL'),
  (678, 'TESALIA'),
  (679, 'TIMANA'),
  (680, 'VILLAVIEJA'),
  (681, 'YAGUARA'),
  (682, 'ALBANIA'),
  (683, 'BARRANCAS'),
  (684, 'DIBULLA'),
  (685, 'DISTRACCIÓN'),
  (686, 'EL MOLINO'),
  (687, 'FONSECA'),
  (688, 'HATO NUEVO'),
  (689, 'LA JAGUA DEL PILAR'),
  (690, 'MAICAO'),
  (691, 'MANAURE'),
  (692, 'RIOHACHA'),
  (693, 'SAN JUAN DEL CESAR'),
  (694, 'URUMITA'),
  (695, 'VILLANUEVA'),
  (696, 'ALGARROBO'),
  (697, 'ARACATACA'),
  (698, 'ARIGUANI'),
  (699, 'CERRO SAN ANTONIO'),
  (700, 'CHIVOLO'),
  (701, 'CIENAGA'),
  (702, 'CONCORDIA'),
  (703, 'EL BANCO'),
  (704, 'EL PIÑON'),
  (705, 'EL RETEN'),
  (706, 'FUNDACION'),
  (707, 'GUAMAL'),
  (708, 'NUEVA GRANADA'),
  (709, 'PEDRAZA'),
  (710, 'PIJIÑO DEL CARMEN'),
  (711, 'PIVIJAY'),
  (712, 'PLATO'),
  (713, 'PUEBLO VIEJO'),
  (714, 'REMOLINO'),
  (715, 'SABANAS DE SN ANGEL'),
  (716, 'SALAMINA'),
  (717, 'SAN SEBASTIAN DE BUENAVISTA'),
  (718, 'SAN ZENON'),
  (719, 'SANTA ANA'),
  (720, 'SANTA BARBARA DE PINTO'),
  (721, 'SANTA MARTA'),
  (722, 'SITIONUEVO'),
  (723, 'TENERIFE'),
  (724, 'ZAPAYAN'),
  (725, 'ZONA BANANERA'),
  (726, 'ACACIAS'),
  (727, 'BARRANCA DE UPIA'),
  (728, 'CABUYARO'),
  (729, 'CASTILLA LA NUEVA'),
  (730, 'CUBARRAL'),
  (731, 'CUMARAL'),
  (732, 'EL CALVARIO'),
  (733, 'EL CASTILLO'),
  (734, 'EL DORADO'),
  (735, 'FUENTE DE ORO'),
  (736, 'GRANADA'),
  (737, 'GUAMAL'),
  (738, 'LA MACARENA'),
  (739, 'LA URIBE'),
  (740, 'LEJANÍAS'),
  (741, 'MAPIRIPÁN'),
  (742, 'MESETAS'),
  (743, 'PUERTO CONCORDIA'),
  (744, 'PUERTO GAITÁN'),
  (745, 'PUERTO LLERAS'),
  (746, 'PUERTO LÓPEZ'),
  (747, 'PUERTO RICO'),
  (748, 'RESTREPO'),
  (749, 'SAN  JUAN DE ARAMA'),
  (750, 'SAN CARLOS GUARA'),
  (751, 'SAN JUANITO'),
  (752, 'SAN MARTÍN'),
  (753, 'VILLAVICENCIO'),
  (754, 'VISTA HERMOSA'),
  (755, 'ALBAN'),
  (756, 'ALDAÑA'),
  (757, 'ANCUYA'),
  (758, 'ARBOLEDA'),
  (759, 'BARBACOAS'),
  (760, 'BELEN'),
  (761, 'BUESACO'),
  (762, 'CHACHAGUI'),
  (763, 'COLON (GENOVA)'),
  (764, 'CONSACA'),
  (765, 'CONTADERO'),
  (766, 'CORDOBA'),
  (767, 'CUASPUD'),
  (768, 'CUMBAL'),
  (769, 'CUMBITARA'),
  (770, 'EL CHARCO'),
  (771, 'EL PEÑOL'),
  (772, 'EL ROSARIO'),
  (773, 'EL TABLÓN'),
  (774, 'EL TAMBO'),
  (775, 'FUNES'),
  (776, 'GUACHUCAL'),
  (777, 'GUAITARILLA'),
  (778, 'GUALMATAN'),
  (779, 'ILES'),
  (780, 'IMUES'),
  (781, 'IPIALES'),
  (782, 'LA CRUZ'),
  (783, 'LA FLORIDA'),
  (784, 'LA LLANADA'),
  (785, 'LA TOLA'),
  (786, 'LA UNION'),
  (787, 'LEIVA'),
  (788, 'LINARES'),
  (789, 'LOS ANDE'),
  (790, 'MAGUI'),
  (791, 'MALLAMA'),
  (792, 'MOSQUEZA'),
  (793, 'NARIÑO'),
  (794, 'OLAYA HERRERA'),
  (795, 'OSPINA'),
  (796, 'PASTO'),
  (797, 'PIZARRO'),
  (798, 'POLICARPA'),
  (799, 'POTOSI'),
  (800, 'PROVIDENCIA'),
  (801, 'PUERRES'),
  (802, 'PUPIALES'),
  (803, 'RICAURTE'),
  (804, 'ROBERTO PAYAN'),
  (805, 'SAMANIEGO'),
  (806, 'SAN BERNARDO'),
  (807, 'SAN LORENZO'),
  (808, 'SAN PABLO'),
  (809, 'SAN PEDRO DE CARTAGO'),
  (810, 'SANDONA'),
  (811, 'SANTA BARBARA'),
  (812, 'SANTACRUZ'),
  (813, 'SAPUYES'),
  (814, 'TAMINANGO'),
  (815, 'TANGUA'),
  (816, 'TUMACO'),
  (817, 'TUQUERRES'),
  (818, 'YACUANQUER'),
  (819, 'ABREGO'),
  (820, 'ARBOLEDAS'),
  (821, 'BOCHALEMA'),
  (822, 'BUCARASICA'),
  (823, 'CÁCHIRA'),
  (824, 'CÁCOTA'),
  (825, 'CHINÁCOTA'),
  (826, 'CHITAGÁ'),
  (827, 'CONVENCIÓN'),
  (828, 'CÚCUTA'),
  (829, 'CUCUTILLA'),
  (830, 'DURANIA'),
  (831, 'EL CARMEN'),
  (832, 'EL TARRA'),
  (833, 'EL ZULIA'),
  (834, 'GRAMALOTE'),
  (835, 'HACARI'),
  (836, 'HERRÁN'),
  (837, 'LA ESPERANZA'),
  (838, 'LA PLAYA'),
  (839, 'LABATECA'),
  (840, 'LOS PATIS'),
  (841, 'LOURDES'),
  (842, 'MUTISCUA'),
  (843, 'OCAÑA'),
  (844, 'PAMPLONA'),
  (845, 'PAMPLONITA'),
  (846, 'PUERTO SANTANDER'),
  (847, 'RAGONVALIA'),
  (848, 'SALAZAR'),
  (849, 'SAN CALIXTO'),
  (850, 'SAN CAYETANO'),
  (851, 'SANTIAGO'),
  (852, 'SARDINATA'),
  (853, 'SILOS'),
  (854, 'TEORAMA'),
  (855, 'TIBÚ'),
  (856, 'TOLEDO'),
  (857, 'VILLA CARO'),
  (858, 'VILLA DEL ROSARIO'),
  (859, 'COLÓN'),
  (860, 'MOCOA'),
  (861, 'ORITO'),
  (862, 'PUERTO ASÍS'),
  (863, 'PUERTO CAYCEDO'),
  (864, 'PUERTO GUZMÁN'),
  (865, 'PUERTO LEGUÍZAMO'),
  (866, 'SAN FRANCISCO'),
  (867, 'SAN MIGUEL'),
  (868, 'SANTIAGO'),
  (869, 'SIBUNDOY'),
  (870, 'VALLE DEL GUAMUEZ'),
  (871, 'VILLAGARZÓN'),
  (872, 'ARMENIA'),
  (873, 'BUENAVISTA'),
  (874, 'CALARCÁ'),
  (875, 'CIRCASIA'),
  (876, 'CÓRDOBA'),
  (877, 'FILANDIA'),
  (878, 'GÉNOVA'),
  (879, 'LA TEBAIDA'),
  (880, 'MONTENEGRO'),
  (881, 'PIJAO'),
  (882, 'QUIMBAYA'),
  (883, 'SALENTO'),
  (884, 'APIA'),
  (885, 'BALBOA'),
  (886, 'BELÉN DE UMBRÍA'),
  (887, 'DOS QUEBADAS'),
  (888, 'GUATICA'),
  (889, 'LA CELIA'),
  (890, 'LA VIRGINIA'),
  (891, 'MARSELLA'),
  (892, 'MISTRATO'),
  (893, 'PEREIRA'),
  (894, 'PUEBLO RICO'),
  (895, 'QUINCHÍA'),
  (896, 'SANTA ROSA DE CABAL'),
  (897, 'SANTUARIO'),
  (898, 'PROVIDENCIA'),
  (899, 'SAN ANDRES'),
  (900, 'SANTA CATALINA'),
  (901, 'AGUADA'),
  (902, 'ALBANIA'),
  (903, 'ARATOCA'),
  (904, 'BARBOSA'),
  (905, 'BARICHARA'),
  (906, 'BARRANCABERMEJA'),
  (907, 'BETULIA'),
  (908, 'BOLÍVAR'),
  (909, 'BUCARAMANGA'),
  (910, 'CABRERA'),
  (911, 'CALIFORNIA'),
  (912, 'CAPITANEJO'),
  (913, 'CARCASI'),
  (914, 'CEPITA'),
  (915, 'CERRITO'),
  (916, 'CHARALÁ'),
  (917, 'CHARTA'),
  (918, 'CHIMA'),
  (919, 'CHIPATÁ'),
  (920, 'CIMITARRA'),
  (921, 'CONCEPCIÓN'),
  (922, 'CONFINES'),
  (923, 'CONTRATACIÓN'),
  (924, 'COROMORO'),
  (925, 'CURITÍ'),
  (926, 'EL CARMEN'),
  (927, 'EL GUACAMAYO'),
  (928, 'EL PEÑÓN'),
  (929, 'EL PLAYÓN'),
  (930, 'ENCINO'),
  (931, 'ENCISO'),
  (932, 'FLORIÁN'),
  (933, 'FLORIDABLANCA'),
  (934, 'GALÁN'),
  (935, 'GAMBITA'),
  (936, 'GIRÓN'),
  (937, 'GUACA'),
  (938, 'GUADALUPE'),
  (939, 'GUAPOTA'),
  (940, 'GUAVATÁ'),
  (941, 'GUEPSA'),
  (942, 'HATO'),
  (943, 'JESÚS MARI'),
  (944, 'JORDÁN'),
  (945, 'LA BELLEZA'),
  (946, 'LA PAZ'),
  (947, 'LANDAZURI'),
  (948, 'LEBRIJA'),
  (949, 'LOS SANTS'),
  (950, 'MACARAVITA'),
  (951, 'MÁLAGA'),
  (952, 'MATANZA'),
  (953, 'MOGOTES'),
  (954, 'MOLAGAVITA'),
  (955, 'OCAMONTE'),
  (956, 'OIBA'),
  (957, 'ONZAGA'),
  (958, 'PALMAR'),
  (959, 'PALMAS DEL OCORRO'),
  (960, 'PÁRAMO'),
  (961, 'PIEDECUESTA'),
  (962, 'PINCHOTE'),
  (963, 'PUENTE NACIONAL'),
  (964, 'PUERTO PARRA'),
  (965, 'PUERTO WILCHES'),
  (966, 'RIONEGRO'),
  (967, 'SABANA DE TORRES'),
  (968, 'SAN ANDRÉS'),
  (969, 'SAN BENITO'),
  (970, 'SAN GIL'),
  (971, 'SAN JOAQUÍN'),
  (972, 'SAN JOSÉ DE MIRANDA'),
  (973, 'SAN MIGUEL'),
  (974, 'SAN VICENTE DE CHUCURÍ'),
  (975, 'SANTA BÁRBARA'),
  (976, 'SANTA HELENA'),
  (977, 'SIMACOTA'),
  (978, 'SOCORRO'),
  (979, 'SUAITA'),
  (980, 'SUCRE'),
  (981, 'SURATA'),
  (982, 'TONA'),
  (983, 'VALLE SAN JOSÉ'),
  (984, 'VÉLEZ'),
  (985, 'VETAS'),
  (986, 'VILLANUEVA'),
  (987, 'ZAPATOCA'),
  (988, 'BUENAVISTA'),
  (989, 'CAIMITO'),
  (990, 'CHALÁN'),
  (991, 'COLOSO'),
  (992, 'COROZAL'),
  (993, 'EL ROBLE'),
  (994, 'GALERAS'),
  (995, 'GUARANDA'),
  (996, 'LOS PALMIOS'),
  (997, 'MAJAGUAL'),
  (998, 'MORROA'),
  (999, 'OVEJAS'),
  (1000, 'PALMITO'),
  (1001, 'SAMPUES'),
  (1002, 'SAN BENITO ABAD'),
  (1003, 'SAN JUAN DE BETULIA'),
  (1004, 'SAN MARCOS'),
  (1005, 'SAN ONOFRE'),
  (1006, 'SAN PEDRO'),
  (1007, 'SINCÉ'),
  (1008, 'SINCELEJO'),
  (1009, 'SUCRE'),
  (1010, 'TOLÚ'),
  (1011, 'TOLUVIEJO'),
  (1012, 'ALPUJARRA'),
  (1013, 'ALVARADO'),
  (1014, 'AMBALEMA'),
  (1015, 'ANZOATEGUI'),
  (1016, 'ARMERO (GUAYABAL)'),
  (1017, 'ATACO'),
  (1018, 'CAJAMARCA'),
  (1019, 'CARMEN DE APICALÁ'),
  (1020, 'CASABIANCA'),
  (1021, 'CHAPARRAL'),
  (1022, 'COELLO'),
  (1023, 'COYAIMA'),
  (1024, 'CUNDAY'),
  (1025, 'DOLORES'),
  (1026, 'ESPINAL'),
  (1027, 'FALÁN'),
  (1028, 'FLANDES'),
  (1029, 'FRESNO'),
  (1030, 'GUAMO'),
  (1031, 'HERVEO'),
  (1032, 'HONDA'),
  (1033, 'IBAGUÉ'),
  (1034, 'ICONONZO'),
  (1035, 'LÉRIDA'),
  (1036, 'LÍBANO'),
  (1037, 'MARIQUITA'),
  (1038, 'MELGAR'),
  (1039, 'MURILLO'),
  (1040, 'NATAGAIMA'),
  (1041, 'ORTEGA'),
  (1042, 'PALOCABILDO'),
  (1043, 'PIEDRAS PLANAAS'),
  (1044, 'PRADO'),
  (1045, 'PURIFICACIÓN'),
  (1046, 'RIOBLANCO'),
  (1047, 'RONCESVALLES'),
  (1048, 'ROVIRA'),
  (1049, 'SALDAÑA'),
  (1050, 'SAN ANTONIO'),
  (1051, 'SAN LUIS'),
  (1052, 'SANTA ISABEL'),
  (1053, 'SUÁREZ'),
  (1054, 'VALLE DE SAN JUAN'),
  (1055, 'VENADILLO'),
  (1056, 'VILLAHERMOSA'),
  (1057, 'VILLARRICA'),
  (1058, 'ALCALÁ'),
  (1059, 'ANDALUCÍA'),
  (1060, 'ANSERMA NUEVO'),
  (1061, 'ARGELIA'),
  (1062, 'BOLÍVAR'),
  (1063, 'BUENAVENTURA'),
  (1064, 'BUGA'),
  (1065, 'BUGALAGRANDE'),
  (1066, 'CAICEDONIA'),
  (1067, 'CALI'),
  (1068, 'CALIMA (DARIEN)'),
  (1069, 'CANDELARIA'),
  (1070, 'CARTAGO'),
  (1071, 'DAGUA'),
  (1072, 'EL AGUILA'),
  (1073, 'EL CAIRO'),
  (1074, 'EL CERRITO'),
  (1075, 'EL DOVIO'),
  (1076, 'FLORIDA'),
  (1077, 'GINEBRA GUACARI'),
  (1078, 'JAMUNDÍ'),
  (1079, 'LA CUMBRE'),
  (1080, 'LA UNIÓN'),
  (1081, 'LA VICTORIA'),
  (1082, 'OBANDO'),
  (1083, 'PALMIRA'),
  (1084, 'PRADERA'),
  (1085, 'RESTREPO'),
  (1086, 'RIO FRÍO'),
  (1087, 'ROLDANILLO'),
  (1088, 'SAN PEDRO'),
  (1089, 'SEVILLA'),
  (1090, 'TORO'),
  (1091, 'TRUJILLO'),
  (1092, 'TULÚA'),
  (1093, 'ULLOA'),
  (1094, 'VERSALLES'),
  (1095, 'VIJES'),
  (1096, 'YOTOCO'),
  (1097, 'YUMBO'),
  (1098, 'ZARZAL'),
  (1099, 'CARURÚ'),
  (1100, 'MITÚ'),
  (1101, 'PACOA'),
  (1102, 'PAPUNAUA'),
  (1103, 'TARAIRA'),
  (1104, 'YAVARATÉ'),
  (1105, 'CUMARIBO'),
  (1106, 'LA PRIMAVERA'),
  (1107, 'PUERTO CARREÑO'),
  (1108, 'SANTA ROSALIA'),
  (1109, 'EL ENCANTO'),
  (1110, 'LA CHORRERA'),
  (1111, 'LA PEDRERA'),
  (1112, 'LA VICTORIA'),
  (1113, 'LETICIA'),
  (1114, 'MIRITI'),
  (1115, 'PUERTO ALEGRIA'),
  (1116, 'PUERTO ARICA'),
  (1117, 'PUERTO NARIÑO'),
  (1118, 'PUERTO SANTANDER'),
  (1119, 'TURAPACA'),
  (1120, 'ABEJORRAL'),
  (1121, 'ABRIAQUI'),
  (1122, 'ALEJANDRIA'),
  (1123, 'AMAGA'),
  (1124, 'AMALFI'),
  (1125, 'ANDES'),
  (1126, 'ANGELOPOLIS'),
  (1127, 'ANGOSTURA'),
  (1128, 'ANORI'),
  (1129, 'ANTIOQUIA'),
  (1130, 'ANZA'),
  (1131, 'APARTADO'),
  (1132, 'ARBOLETES'),
  (1133, 'ARGELIA'),
  (1134, 'ARMENIA'),
  (1135, 'BARBOSA'),
  (1136, 'BELLO'),
  (1137, 'BELMIRA'),
  (1138, 'BETANIA'),
  (1139, 'BETULIA'),
  (1140, 'BOLIVAR'),
  (1141, 'BRICEÑO'),
  (1142, 'BURITICA'),
  (1143, 'CACERES'),
  (1144, 'CAICEDO'),
  (1145, 'CALDAS'),
  (1146, 'CAMPAMENTO'),
  (1147, 'CANASGORDAS'),
  (1148, 'CARACOLI'),
  (1149, 'CARAMANTA'),
  (1150, 'CAREPA'),
  (1151, 'CAROLINA DEL PRINCIPE'),
  (1152, 'CAUCASIA'),
  (1153, 'CHIGORODO'),
  (1154, 'CISNEROS'),
  (1155, 'COCORNA'),
  (1156, 'CONCEPCION'),
  (1157, 'CONCORDIA'),
  (1158, 'COPACABANA'),
  (1159, 'DABEIBA'),
  (1160, 'DONMATIAS'),
  (1161, 'EBEJICO'),
  (1162, 'EL BAGRE'),
  (1163, 'EL PENOL'),
  (1164, 'EL RETIRO'),
  (1165, 'ENTRERRIOS'),
  (1166, 'ENVIGADO'),
  (1167, 'FREDONIA'),
  (1168, 'FRONTINO'),
  (1169, 'GIRALDO'),
  (1170, 'GIRARDOTA'),
  (1171, 'GOMEZ PLATA'),
  (1172, 'GRANADA'),
  (1173, 'GUADALUPE'),
  (1174, 'GUARNE'),
  (1175, 'GUATAQUE'),
  (1176, 'HELICONIA'),
  (1177, 'HISPANIA'),
  (1178, 'ITAGUI'),
  (1179, 'ITUANGO'),
  (1180, 'JARDIN'),
  (1181, 'JERICO'),
  (1182, 'LA CEJA'),
  (1183, 'LA ESTRELLA'),
  (1184, 'LA PINTADA'),
  (1185, 'LA UNION'),
  (1186, 'LIBORINA'),
  (1187, 'MACEO'),
  (1188, 'MARINILLA'),
  (1189, 'MEDELLIN'),
  (1190, 'MONTEBELLO'),
  (1191, 'MURINDO'),
  (1192, 'MUTATA'),
  (1193, 'NARINO'),
  (1194, 'NECHI'),
  (1195, 'NECOCLI'),
  (1196, 'OLAYA'),
  (1197, 'PEQUE'),
  (1198, 'PUEBLORRICO'),
  (1199, 'PUERTO BERRIO'),
  (1200, 'PUERTO NARE'),
  (1201, 'PUERTO TRIUNFO'),
  (1202, 'REMEDIOS'),
  (1203, 'RIONEGRO'),
  (1204, 'SABANALARGA'),
  (1205, 'SABANETA'),
  (1206, 'SALGAR'),
  (1207, 'SAN ANDRES DE CERQUIA'),
  (1208, 'SAN CARLOS'),
  (1209, 'SAN FRANCISCO'),
  (1210, 'SAN JERONIMO'),
  (1211, 'SAN JOSE DE LA MONTAÑA'),
  (1212, 'SAN JUAN DE URABA'),
  (1213, 'SAN LUIS'),
  (1214, 'SAN PEDRO DE LOS MILAROS'),
  (1215, 'SAN PEDRO DE URABA'),
  (1216, 'SAN RAFAEL'),
  (1217, 'SAN ROQUE'),
  (1218, 'SAN VICENTE'),
  (1219, 'SANTA BARBARA'),
  (1220, 'SANTA ROSA DE OSOS'),
  (1221, 'SANTO DOMINGO'),
  (1222, 'SANTUARIO'),
  (1223, 'SEGOVIA'),
  (1224, 'SONSON'),
  (1225, 'SOPETRAN'),
  (1226, 'TAMESIS'),
  (1227, 'TARAZA'),
  (1228, 'TARSO'),
  (1229, 'TITIRIBI'),
  (1230, 'TOLEDO'),
  (1231, 'TURBO'),
  (1232, 'URAMITA'),
  (1233, 'URRAO'),
  (1234, 'VALDIVIA'),
  (1235, 'VALPARAISO'),
  (1236, 'VEGACHI'),
  (1237, 'VENECIA'),
  (1238, 'VIGIA DEL FUERTE'),
  (1239, 'YALI'),
  (1240, 'YARUMAL'),
  (1241, 'YOLOMBO'),
  (1242, 'YONDO'),
  (1243, 'ZARAGOZA'),
  (1244, 'ARAUCA'),
  (1245, 'ARAUQUITA'),
  (1246, 'CRAVO NORTE'),
  (1247, 'FORTUL'),
  (1248, 'PUERTO RONDON'),
  (1249, 'SARAVENA'),
  (1250, 'TAME'),
  (1251, 'BARANOA'),
  (1252, 'BARRANQUILLA'),
  (1253, 'CAMPO DE LA CRUZ'),
  (1254, 'CANDELARIA'),
  (1255, 'GALAPA'),
  (1256, 'JUAN DE ACOSTA'),
  (1257, 'LURUACO'),
  (1258, 'MALAMBO'),
  (1259, 'MANATI'),
  (1260, 'PALMAR DE VARELA'),
  (1261, 'PIOJO'),
  (1262, 'POLO NUEVO'),
  (1263, 'PONEDERA'),
  (1264, 'PUERTO COLOMBIA'),
  (1265, 'REPELON'),
  (1266, 'SABANAGRANDE'),
  (1267, 'SABANALARGA'),
  (1268, 'SANTA LUCIA'),
  (1269, 'SANTO TOMAS'),
  (1270, 'SOLEDAD'),
  (1271, 'SUAN'),
  (1272, 'TUBARA'),
  (1273, 'USIACURI'),
  (1274, 'ACHI'),
  (1275, 'ALTOS DEL OSARIO'),
  (1276, 'ARENAL'),
  (1277, 'ARJONA'),
  (1278, 'ARROYOHONDO'),
  (1279, 'BARRANCO DE LOBA'),
  (1280, 'BRAZUELO DE PAPAYAL'),
  (1281, 'CALAMAR'),
  (1282, 'CANTAGALLO'),
  (1283, 'CARTAGENA DE INDIAS'),
  (1284, 'CICUCO'),
  (1285, 'CLEMENCIA'),
  (1286, 'CORDOBA'),
  (1287, 'EL CARMEN DE BOLIVAR'),
  (1288, 'EL GUAMO'),
  (1289, 'EL PENION'),
  (1290, 'HATILLO DE LOBA'),
  (1291, 'MAGANGUE'),
  (1292, 'MAHATES'),
  (1293, 'MARGARITA'),
  (1294, 'MARIA LA BAJA'),
  (1295, 'MONTECRISTO'),
  (1296, 'MORALES'),
  (1297, 'MORALES'),
  (1298, 'NOROSI'),
  (1299, 'PINILLOS'),
  (1300, 'REGIDOR'),
  (1301, 'RIO VIEJO'),
  (1302, 'SAN CRISTOBAL'),
  (1303, 'SAN ESTANISLAO'),
  (1304, 'SAN FERNANDO'),
  (1305, 'SAN JACINTO'),
  (1306, 'SAN JACINTO DEL CAUCA'),
  (1307, 'SAN JUAN DE NEPOMUCENO'),
  (1308, 'SAN MARTIN DE LOBA'),
  (1309, 'SAN PABLO'),
  (1310, 'SAN PABLO NORTE'),
  (1311, 'SANTA CATALINA'),
  (1312, 'SANTA CRUZ DE MOMPOX'),
  (1313, 'SANTA ROSA'),
  (1314, 'SANTA ROSA DEL SUR'),
  (1315, 'SIMITI'),
  (1316, 'SOPLAVIENTO'),
  (1317, 'TALAIGUA NUEVO'),
  (1318, 'TUQUISIO'),
  (1319, 'TURBACO'),
  (1320, 'TURBANA'),
  (1321, 'VILLANUEVA'),
  (1322, 'ZAMBRANO'),
  (1323, 'AQUITANIA'),
  (1324, 'ARCABUCO'),
  (1325, 'BELÉN'),
  (1326, 'BERBEO'),
  (1327, 'BETÉITIVA'),
  (1328, 'BOAVITA'),
  (1329, 'BOYACÁ'),
  (1330, 'BRICEÑO'),
  (1331, 'BUENAVISTA'),
  (1332, 'BUSBANZÁ'),
  (1333, 'CALDAS'),
  (1334, 'CAMPO HERMOSO'),
  (1335, 'CERINZA'),
  (1336, 'CHINAVITA'),
  (1337, 'CHIQUINQUIRÁ'),
  (1338, 'CHÍQUIZA'),
  (1339, 'CHISCAS'),
  (1340, 'CHITA'),
  (1341, 'CHITARAQUE'),
  (1342, 'CHIVATÁ'),
  (1343, 'CIÉNEGA'),
  (1344, 'CÓMBITA'),
  (1345, 'COPER'),
  (1346, 'CORRALES'),
  (1347, 'COVARACHÍA'),
  (1348, 'CUBARA'),
  (1349, 'CUCAITA'),
  (1350, 'CUITIVA'),
  (1351, 'DUITAMA'),
  (1352, 'EL COCUY'),
  (1353, 'EL ESPINO'),
  (1354, 'FIRAVITOBA'),
  (1355, 'FLORESTA'),
  (1356, 'GACHANTIVÁ'),
  (1357, 'GÁMEZA'),
  (1358, 'GARAGOA'),
  (1359, 'GUACAMAYAS'),
  (1360, 'GÜICÁN'),
  (1361, 'IZA'),
  (1362, 'JENESANO'),
  (1363, 'JERICÓ'),
  (1364, 'LA UVITA'),
  (1365, 'LA VICTORIA'),
  (1366, 'LABRANZA GRANDE'),
  (1367, 'MACANAL'),
  (1368, 'MARIPÍ'),
  (1369, 'MIRAFLORES'),
  (1370, 'MONGUA'),
  (1371, 'MONGUÍ'),
  (1372, 'MONIQUIRÁ'),
  (1373, 'MOTAVITA'),
  (1374, 'MUZO'),
  (1375, 'NOBSA'),
  (1376, 'NUEVO COLÓN'),
  (1377, 'OICATÁ'),
  (1378, 'OTANCHE'),
  (1379, 'PACHAVITA'),
  (1380, 'PÁEZ'),
  (1381, 'PAIPA'),
  (1382, 'PAJARITO'),
  (1383, 'PANQUEBA'),
  (1384, 'PAUNA'),
  (1385, 'PAYA'),
  (1386, 'PAZ DE RÍO'),
  (1387, 'PESCA'),
  (1388, 'PISBA'),
  (1389, 'PUERTO BOYACA'),
  (1390, 'QUÍPAMA'),
  (1391, 'RAMIRIQUÍ'),
  (1392, 'RÁQUIRA'),
  (1393, 'RONDÓN'),
  (1394, 'SABOYÁ'),
  (1395, 'SÁCHICA'),
  (1396, 'SAMACÁ'),
  (1397, 'SAN EDUARDO'),
  (1398, 'SAN JOSÉ DE PARE'),
  (1399, 'SAN LUÍS DE GCENO'),
  (1400, 'SAN MATEO'),
  (1401, 'SAN MIGUEL DE SEMA'),
  (1402, 'SAN PABLO DE BORBUR'),
  (1403, 'SANTA MARÍA'),
  (1404, 'SANTA ROSA DE VITERBO'),
  (1405, 'SANTA SOFÍA'),
  (1406, 'SANTANA'),
  (1407, 'SATIVANORTE'),
  (1408, 'SATIVASUR'),
  (1409, 'SIACHOQUE'),
  (1410, 'SOATÁ'),
  (1411, 'SOCHA'),
  (1412, 'SOCOTÁ'),
  (1413, 'SOGAMOSO'),
  (1414, 'SORA'),
  (1415, 'SORACÁ'),
  (1416, 'SOTAQUIRÁ'),
  (1417, 'SUSACÓN'),
  (1418, 'SUTARMACHÁN'),
  (1419, 'TASCO'),
  (1420, 'TIBANÁ'),
  (1421, 'TIBASOSA'),
  (1422, 'TINJACÁ'),
  (1423, 'TIPACOQUE'),
  (1424, 'TOCA'),
  (1425, 'TOGÜÍ'),
  (1426, 'TÓPAGA'),
  (1427, 'TOTA'),
  (1428, 'TUNJA'),
  (1429, 'TUNUNGUÁ'),
  (1430, 'TURMEQUÉ'),
  (1431, 'TUTA'),
  (1432, 'TUTAZÁ'),
  (1433, 'UMBITA'),
  (1434, 'VENTA QUEMADA'),
  (1435, 'VILLA DE LEYVA'),
  (1436, 'VIRACACHÁ'),
  (1437, 'ZETAQUIRA'),
  (1438, 'AGUADAS'),
  (1439, 'ANSERMA'),
  (1440, 'ARANZAZU'),
  (1441, 'BELALCAZAR'),
  (1442, 'CHINCHINÁ'),
  (1443, 'FILADELFIA'),
  (1444, 'LA DORADA'),
  (1445, 'LA MERCED'),
  (1446, 'MANIZALES'),
  (1447, 'MANZANARES'),
  (1448, 'MARMATO'),
  (1449, 'MARQUETALIA'),
  (1450, 'MARULANDA'),
  (1451, 'NEIRA'),
  (1452, 'NORCASIA'),
  (1453, 'PACORA'),
  (1454, 'PALESTINA'),
  (1455, 'PENSILVANIA'),
  (1456, 'RIOSUCIO'),
  (1457, 'RISARALDA'),
  (1458, 'SALAMINA'),
  (1459, 'SAMANA'),
  (1460, 'SAN JOSE'),
  (1461, 'SUPÍA'),
  (1462, 'VICTORIA'),
  (1463, 'VILLAMARÍA'),
  (1464, 'VITERBO'),
  (1465, 'ALBANIA'),
  (1466, 'BELÉN ANDAQUIES'),
  (1467, 'CARTAGENA DEL CHAIRA'),
  (1468, 'CURILLO'),
  (1469, 'EL DONCELLO'),
  (1470, 'EL PAUJIL'),
  (1471, 'FLORENCIA'),
  (1472, 'LA MONTAÑITA'),
  (1473, 'MILÁN'),
  (1474, 'MORELIA'),
  (1475, 'PUERTO RICO'),
  (1476, 'SAN  VICENTE DEL CAGUAN'),
  (1477, 'SAN JOSÉ DE FRAGUA'),
  (1478, 'SOLANO'),
  (1479, 'SOLITA'),
  (1480, 'VALPARAÍSO'),
  (1481, 'AGUAZUL'),
  (1482, 'CHAMEZA'),
  (1483, 'HATO COROZAL'),
  (1484, 'LA SALINA'),
  (1485, 'MANÍ'),
  (1486, 'MONTERREY'),
  (1487, 'NUNCHIA'),
  (1488, 'OROCUE'),
  (1489, 'PAZ DE ARIPORO'),
  (1490, 'PORE'),
  (1491, 'RECETOR'),
  (1492, 'SABANA LARGA'),
  (1493, 'SACAMA'),
  (1494, 'SAN LUIS DE PLENQUE'),
  (1495, 'TAMARA'),
  (1496, 'TAURAMENA'),
  (1497, 'TRINIDAD'),
  (1498, 'VILLANUEVA'),
  (1499, 'YOPAL'),
  (1500, 'ALMAGUER'),
  (1501, 'ARGELIA'),
  (1502, 'BALBOA'),
  (1503, 'BOLÍVAR'),
  (1504, 'BUENOS AIRE'),
  (1505, 'CAJIBIO'),
  (1506, 'CALDONO'),
  (1507, 'CALOTO'),
  (1508, 'CORINTO'),
  (1509, 'EL TAMBO'),
  (1510, 'FLORENCIA'),
  (1511, 'GUAPI'),
  (1512, 'INZA'),
  (1513, 'JAMBALÓ'),
  (1514, 'LA SIERRA'),
  (1515, 'LA VEGA'),
  (1516, 'LÓPEZ'),
  (1517, 'MERCADERES'),
  (1518, 'MIRANDA'),
  (1519, 'MORALES'),
  (1520, 'PADILLA'),
  (1521, 'PÁEZ'),
  (1522, 'PATIA (EL BORDO)'),
  (1523, 'PIAMONTE'),
  (1524, 'PIENDAMO'),
  (1525, 'POPAYÁN'),
  (1526, 'PUERTO TEJADA'),
  (1527, 'PURACE'),
  (1528, 'ROSAS'),
  (1529, 'SAN SEBASTIÁN'),
  (1530, 'SANTA ROSA'),
  (1531, 'SILVIA'),
  (1532, 'SOTARA'),
  (1533, 'SUÁREZ'),
  (1534, 'SUCRE'),
  (1535, 'TIMBÍO'),
  (1536, 'TIMBIQUÍ'),
  (1537, 'TORIBIO'),
  (1538, 'TOTORO'),
  (1539, 'VILLA RICA'),
  (1540, 'AGUACHICA'),
  (1541, 'AGUSTÍN CODAZZI'),
  (1542, 'ASTREA'),
  (1543, 'BECERRIL'),
  (1544, 'BOSCONIA'),
  (1545, 'CHIMICHAGUA'),
  (1546, 'CHIRIGUANÁ'),
  (1547, 'CURUMANÍ'),
  (1548, 'EL COPEY'),
  (1549, 'EL PASO'),
  (1550, 'GAMARRA'),
  (1551, 'GONZÁLEZ'),
  (1552, 'LA GLORIA'),
  (1553, 'LA JAGUA IBIRICO'),
  (1554, 'MANAURE BALCÓN DEL CESAR'),
  (1555, 'PAILITAS'),
  (1556, 'PELAYA'),
  (1557, 'PUEBLO BELLO'),
  (1558, 'RÍO DE ORO'),
  (1559, 'ROBLES (LA PAZ)'),
  (1560, 'SAN ALBERTO'),
  (1561, 'SAN DIEGO'),
  (1562, 'SAN MARTÍN'),
  (1563, 'TAMALAMEQUE'),
  (1564, 'VALLEDUPAR'),
  (1565, 'ACANDI'),
  (1566, 'ALTO BAUDO (PIE DE PATO)'),
  (1567, 'ATRATO'),
  (1568, 'BAGADO'),
  (1569, 'BAHIA SOLANO (MUTIS)'),
  (1570, 'BAJO BAUDO (PIZARRO)'),
  (1571, 'BOJAYA (BELLAVISTA)'),
  (1572, 'CANTON DE SAN PABLO'),
  (1573, 'CARMEN DEL DARIEN'),
  (1574, 'CERTEGUI'),
  (1575, 'CONDOTO'),
  (1576, 'EL CARMEN'),
  (1577, 'ISTMINA'),
  (1578, 'JURADO'),
  (1579, 'LITORAL DEL SAN JUAN'),
  (1580, 'LLORO'),
  (1581, 'MEDIO ATRATO'),
  (1582, 'MEDIO BAUDO (BOCA DE PEPE)'),
  (1583, 'MEDIO SAN JUAN'),
  (1584, 'NOVITA'),
  (1585, 'NUQUI'),
  (1586, 'QUIBDO'),
  (1587, 'RIO IRO'),
  (1588, 'RIO QUITO'),
  (1589, 'RIOSUCIO'),
  (1590, 'SAN JOSE DEL PALMAR'),
  (1591, 'SIPI'),
  (1592, 'TADO'),
  (1593, 'UNGUIA'),
  (1594, 'UNIÓN PANAMERICANA'),
  (1595, 'AYAPEL'),
  (1596, 'BUENAVISTA'),
  (1597, 'CANALETE'),
  (1598, 'CERETÉ'),
  (1599, 'CHIMA'),
  (1600, 'CHINÚ'),
  (1601, 'CIENAGA DE ORO'),
  (1602, 'COTORRA'),
  (1603, 'LA APARTADA'),
  (1604, 'LORICA'),
  (1605, 'LOS CÓRDBAS'),
  (1606, 'MOMIL'),
  (1607, 'MONTELÍBANO'),
  (1608, 'MONTERÍA'),
  (1609, 'MOÑITOS'),
  (1610, 'PLANETA RICA'),
  (1611, 'PUEBLO NUEVO'),
  (1612, 'PUERTO ESCONDIDO'),
  (1613, 'PUERTO LIBERTADOR'),
  (1614, 'PURÍSIMA'),
  (1615, 'SAHAGÚN'),
  (1616, 'SAN ANDRÉS SOTAENTO'),
  (1617, 'SAN ANTERO'),
  (1618, 'SAN BERNARDO VIENTO'),
  (1619, 'SAN CARLOS'),
  (1620, 'SAN PELAYO'),
  (1621, 'TIERRALTA'),
  (1622, 'VALENCIA'),
  (1623, 'AGUA DE DIOS'),
  (1624, 'ALBAN'),
  (1625, 'ANAPOIMA'),
  (1626, 'ANOLAIMA'),
  (1627, 'ARBELAEZ'),
  (1628, 'BELTRÁN'),
  (1629, 'BITUIMA'),
  (1630, 'BOGOTÁ DC'),
  (1631, 'BOJACÁ'),
  (1632, 'CABRERA'),
  (1633, 'CACHIPAY'),
  (1634, 'CAJICÁ'),
  (1635, 'CAPARRAPÍ'),
  (1636, 'CAQUEZA'),
  (1637, 'CARMEN DE CARUPA'),
  (1638, 'CHAGUANÍ'),
  (1639, 'CHIA'),
  (1640, 'CHIPAQUE'),
  (1641, 'CHOACHÍ'),
  (1642, 'CHOCONTÁ'),
  (1643, 'COGUA'),
  (1644, 'COTA'),
  (1645, 'CUCUNUBÁ'),
  (1646, 'EL COLEGIO'),
  (1647, 'EL PEÑÓN'),
  (1648, 'EL ROSAL'),
  (1649, 'FACATATIVA'),
  (1650, 'FÓMEQUE'),
  (1651, 'FOSCA'),
  (1652, 'FUNZA'),
  (1653, 'FÚQUENE'),
  (1654, 'FUSAGASUGA'),
  (1655, 'GACHALÁ'),
  (1656, 'GACHANCIPÁ'),
  (1657, 'GACHETA'),
  (1658, 'GAMA'),
  (1659, 'GIRARDOT'),
  (1660, 'GRANADA'),
  (1661, 'GUACHETÁ'),
  (1662, 'GUADUAS'),
  (1663, 'GUASCA'),
  (1664, 'GUATAQUÍ'),
  (1665, 'GUATAVITA'),
  (1666, 'GUAYABAL DE SIQUIMA'),
  (1667, 'GUAYABETAL'),
  (1668, 'GUTIÉRREZ'),
  (1669, 'JERUSALÉN'),
  (1670, 'JUNÍN'),
  (1671, 'LA CALERA'),
  (1672, 'LA MESA'),
  (1673, 'LA PALMA'),
  (1674, 'LA PEÑA'),
  (1675, 'LA VEGA'),
  (1676, 'LENGUAZAQUE'),
  (1677, 'MACHETÁ'),
  (1678, 'MADRID'),
  (1679, 'MANTA'),
  (1680, 'MEDINA'),
  (1681, 'MOSQUERA'),
  (1682, 'NARIÑO'),
  (1683, 'NEMOCÓN'),
  (1684, 'NILO'),
  (1685, 'NIMAIMA'),
  (1686, 'NOCAIMA'),
  (1687, 'OSPINA PÉREZ'),
  (1688, 'PACHO'),
  (1689, 'PAIME'),
  (1690, 'PANDI'),
  (1691, 'PARATEBUENO'),
  (1692, 'PASCA'),
  (1693, 'PUERTO SALGAR'),
  (1694, 'PULÍ'),
  (1695, 'QUEBRADANEGRA'),
  (1696, 'QUETAME'),
  (1697, 'QUIPILE'),
  (1698, 'RAFAEL REYES'),
  (1699, 'RICAURTE'),
  (1700, 'SAN  ANTONIO DEL  TEQUENDAMA'),
  (1701, 'SAN BERNARDO'),
  (1702, 'SAN CAYETANO'),
  (1703, 'SAN FRANCISCO'),
  (1704, 'SAN JUAN DE RIOSECO'),
  (1705, 'SASAIMA'),
  (1706, 'SESQUILÉ'),
  (1707, 'SIBATÉ'),
  (1708, 'SILVANIA'),
  (1709, 'SIMIJACA'),
  (1710, 'SOACHA'),
  (1711, 'SOPO'),
  (1712, 'SUBACHOQUE'),
  (1713, 'SUESCA'),
  (1714, 'SUPATÁ'),
  (1715, 'SUSA'),
  (1716, 'SUTATAUSA'),
  (1717, 'TABIO'),
  (1718, 'TAUSA'),
  (1719, 'TENA'),
  (1720, 'TENJO'),
  (1721, 'TIBACUY'),
  (1722, 'TIBIRITA'),
  (1723, 'TOCAIMA'),
  (1724, 'TOCANCIPÁ'),
  (1725, 'TOPAIPÍ'),
  (1726, 'UBALÁ'),
  (1727, 'UBAQUE'),
  (1728, 'UBATÉ'),
  (1729, 'UNE'),
  (1730, 'UTICA'),
  (1731, 'VERGARA'),
  (1732, 'VIANI'),
  (1733, 'VILLA GOMEZ'),
  (1734, 'VILLA PINZÓN'),
  (1735, 'VILLETA'),
  (1736, 'VIOTA'),
  (1737, 'YACOPÍ'),
  (1738, 'ZIPACÓN'),
  (1739, 'ZIPAQUIRÁ'),
  (1740, 'BARRANCO MINAS'),
  (1741, 'CACAHUAL'),
  (1742, 'INÍRIDA'),
  (1743, 'LA GUADALUPE'),
  (1744, 'MAPIRIPANA'),
  (1745, 'MORICHAL'),
  (1746, 'PANA PANA'),
  (1747, 'PUERTO COLOMBIA'),
  (1748, 'SAN FELIPE'),
  (1749, 'CALAMAR'),
  (1750, 'EL RETORNO'),
  (1751, 'MIRAFLOREZ'),
  (1752, 'SAN JOSÉ DEL GUAVIARE'),
  (1753, 'ACEVEDO'),
  (1754, 'AGRADO'),
  (1755, 'AIPE'),
  (1756, 'ALGECIRAS'),
  (1757, 'ALTAMIRA'),
  (1758, 'BARAYA'),
  (1759, 'CAMPO ALEGRE'),
  (1760, 'COLOMBIA'),
  (1761, 'ELIAS'),
  (1762, 'GARZÓN'),
  (1763, 'GIGANTE'),
  (1764, 'GUADALUPE'),
  (1765, 'HOBO'),
  (1766, 'IQUIRA'),
  (1767, 'ISNOS'),
  (1768, 'LA ARGENTINA'),
  (1769, 'LA PLATA'),
  (1770, 'NATAGA'),
  (1771, 'NEIVA'),
  (1772, 'OPORAPA'),
  (1773, 'PAICOL'),
  (1774, 'PALERMO'),
  (1775, 'PALESTINA'),
  (1776, 'PITAL'),
  (1777, 'PITALITO'),
  (1778, 'RIVERA'),
  (1779, 'SALADO BLANCO'),
  (1780, 'SAN AGUSTÍN'),
  (1781, 'SANTA MARIA'),
  (1782, 'SUAZA'),
  (1783, 'TARQUI'),
  (1784, 'TELLO'),
  (1785, 'TERUEL'),
  (1786, 'TESALIA'),
  (1787, 'TIMANA'),
  (1788, 'VILLAVIEJA'),
  (1789, 'YAGUARA'),
  (1790, 'ALBANIA'),
  (1791, 'BARRANCAS'),
  (1792, 'DIBULLA'),
  (1793, 'DISTRACCIÓN'),
  (1794, 'EL MOLINO'),
  (1795, 'FONSECA'),
  (1796, 'HATO NUEVO'),
  (1797, 'LA JAGUA DEL PILAR'),
  (1798, 'MAICAO'),
  (1799, 'MANAURE'),
  (1800, 'RIOHACHA'),
  (1801, 'SAN JUAN DEL CESAR'),
  (1802, 'URUMITA'),
  (1803, 'VILLANUEVA'),
  (1804, 'ALGARROBO'),
  (1805, 'ARACATACA'),
  (1806, 'ARIGUANI'),
  (1807, 'CERRO SAN ANTONIO'),
  (1808, 'CHIVOLO'),
  (1809, 'CIENAGA'),
  (1810, 'CONCORDIA'),
  (1811, 'EL BANCO'),
  (1812, 'EL PIÑON'),
  (1813, 'EL RETEN'),
  (1814, 'FUNDACION'),
  (1815, 'GUAMAL'),
  (1816, 'NUEVA GRANADA'),
  (1817, 'PEDRAZA'),
  (1818, 'PIJIÑO DEL CARMEN'),
  (1819, 'PIVIJAY'),
  (1820, 'PLATO'),
  (1821, 'PUEBLO VIEJO'),
  (1822, 'REMOLINO'),
  (1823, 'SABANAS DE SN ANGEL'),
  (1824, 'SALAMINA'),
  (1825, 'SAN SEBASTIAN DE BUENAVISTA'),
  (1826, 'SAN ZENON'),
  (1827, 'SANTA ANA'),
  (1828, 'SANTA BARBARA DE PINTO'),
  (1829, 'SANTA MARTA'),
  (1830, 'SITIONUEVO'),
  (1831, 'TENERIFE'),
  (1832, 'ZAPAYAN'),
  (1833, 'ZONA BANANERA'),
  (1834, 'ACACIAS'),
  (1835, 'BARRANCA DE UPIA'),
  (1836, 'CABUYARO'),
  (1837, 'CASTILLA LA NUEVA'),
  (1838, 'CUBARRAL'),
  (1839, 'CUMARAL'),
  (1840, 'EL CALVARIO'),
  (1841, 'EL CASTILLO'),
  (1842, 'EL DORADO'),
  (1843, 'FUENTE DE ORO'),
  (1844, 'GRANADA'),
  (1845, 'GUAMAL'),
  (1846, 'LA MACARENA'),
  (1847, 'LA URIBE'),
  (1848, 'LEJANÍAS'),
  (1849, 'MAPIRIPÁN'),
  (1850, 'MESETAS'),
  (1851, 'PUERTO CONCORDIA'),
  (1852, 'PUERTO GAITÁN'),
  (1853, 'PUERTO LLERAS'),
  (1854, 'PUERTO LÓPEZ'),
  (1855, 'PUERTO RICO'),
  (1856, 'RESTREPO'),
  (1857, 'SAN  JUAN DE ARAMA'),
  (1858, 'SAN CARLOS GUARA'),
  (1859, 'SAN JUANITO'),
  (1860, 'SAN MARTÍN'),
  (1861, 'VILLAVICENCIO'),
  (1862, 'VISTA HERMOSA'),
  (1863, 'ALBAN'),
  (1864, 'ALDAÑA'),
  (1865, 'ANCUYA'),
  (1866, 'ARBOLEDA'),
  (1867, 'BARBACOAS'),
  (1868, 'BELEN'),
  (1869, 'BUESACO'),
  (1870, 'CHACHAGUI'),
  (1871, 'COLON (GENOVA)'),
  (1872, 'CONSACA'),
  (1873, 'CONTADERO'),
  (1874, 'CORDOBA'),
  (1875, 'CUASPUD'),
  (1876, 'CUMBAL'),
  (1877, 'CUMBITARA'),
  (1878, 'EL CHARCO'),
  (1879, 'EL PEÑOL'),
  (1880, 'EL ROSARIO'),
  (1881, 'EL TABLÓN'),
  (1882, 'EL TAMBO'),
  (1883, 'FUNES'),
  (1884, 'GUACHUCAL'),
  (1885, 'GUAITARILLA'),
  (1886, 'GUALMATAN'),
  (1887, 'ILES'),
  (1888, 'IMUES'),
  (1889, 'IPIALES'),
  (1890, 'LA CRUZ'),
  (1891, 'LA FLORIDA'),
  (1892, 'LA LLANADA'),
  (1893, 'LA TOLA'),
  (1894, 'LA UNION'),
  (1895, 'LEIVA'),
  (1896, 'LINARES'),
  (1897, 'LOS ANDE'),
  (1898, 'MAGUI'),
  (1899, 'MALLAMA'),
  (1900, 'MOSQUEZA'),
  (1901, 'NARIÑO'),
  (1902, 'OLAYA HERRERA'),
  (1903, 'OSPINA'),
  (1904, 'PASTO'),
  (1905, 'PIZARRO'),
  (1906, 'POLICARPA'),
  (1907, 'POTOSI'),
  (1908, 'PROVIDENCIA'),
  (1909, 'PUERRES'),
  (1910, 'PUPIALES'),
  (1911, 'RICAURTE'),
  (1912, 'ROBERTO PAYAN'),
  (1913, 'SAMANIEGO'),
  (1914, 'SAN BERNARDO'),
  (1915, 'SAN LORENZO'),
  (1916, 'SAN PABLO'),
  (1917, 'SAN PEDRO DE CARTAGO'),
  (1918, 'SANDONA'),
  (1919, 'SANTA BARBARA'),
  (1920, 'SANTACRUZ'),
  (1921, 'SAPUYES'),
  (1922, 'TAMINANGO'),
  (1923, 'TANGUA'),
  (1924, 'TUMACO'),
  (1925, 'TUQUERRES'),
  (1926, 'YACUANQUER'),
  (1927, 'ABREGO'),
  (1928, 'ARBOLEDAS'),
  (1929, 'BOCHALEMA'),
  (1930, 'BUCARASICA'),
  (1931, 'CÁCHIRA'),
  (1932, 'CÁCOTA'),
  (1933, 'CHINÁCOTA'),
  (1934, 'CHITAGÁ'),
  (1935, 'CONVENCIÓN'),
  (1936, 'CÚCUTA'),
  (1937, 'CUCUTILLA'),
  (1938, 'DURANIA'),
  (1939, 'EL CARMEN'),
  (1940, 'EL TARRA'),
  (1941, 'EL ZULIA'),
  (1942, 'GRAMALOTE'),
  (1943, 'HACARI'),
  (1944, 'HERRÁN'),
  (1945, 'LA ESPERANZA'),
  (1946, 'LA PLAYA'),
  (1947, 'LABATECA'),
  (1948, 'LOS PATIS'),
  (1949, 'LOURDES'),
  (1950, 'MUTISCUA'),
  (1951, 'OCAÑA'),
  (1952, 'PAMPLONA'),
  (1953, 'PAMPLONITA'),
  (1954, 'PUERTO SANTANDER'),
  (1955, 'RAGONVALIA'),
  (1956, 'SALAZAR'),
  (1957, 'SAN CALIXTO'),
  (1958, 'SAN CAYETANO'),
  (1959, 'SANTIAGO'),
  (1960, 'SARDINATA'),
  (1961, 'SILOS'),
  (1962, 'TEORAMA'),
  (1963, 'TIBÚ'),
  (1964, 'TOLEDO'),
  (1965, 'VILLA CARO'),
  (1966, 'VILLA DEL ROSARIO'),
  (1967, 'COLÓN'),
  (1968, 'MOCOA'),
  (1969, 'ORITO'),
  (1970, 'PUERTO ASÍS'),
  (1971, 'PUERTO CAYCEDO'),
  (1972, 'PUERTO GUZMÁN'),
  (1973, 'PUERTO LEGUÍZAMO'),
  (1974, 'SAN FRANCISCO'),
  (1975, 'SAN MIGUEL'),
  (1976, 'SANTIAGO'),
  (1977, 'SIBUNDOY'),
  (1978, 'VALLE DEL GUAMUEZ'),
  (1979, 'VILLAGARZÓN'),
  (1980, 'ARMENIA'),
  (1981, 'BUENAVISTA'),
  (1982, 'CALARCÁ'),
  (1983, 'CIRCASIA'),
  (1984, 'CÓRDOBA'),
  (1985, 'FILANDIA'),
  (1986, 'GÉNOVA'),
  (1987, 'LA TEBAIDA'),
  (1988, 'MONTENEGRO'),
  (1989, 'PIJAO'),
  (1990, 'QUIMBAYA'),
  (1991, 'SALENTO'),
  (1992, 'APIA'),
  (1993, 'BALBOA'),
  (1994, 'BELÉN DE UMBRÍA'),
  (1995, 'DOS QUEBADAS'),
  (1996, 'GUATICA'),
  (1997, 'LA CELIA'),
  (1998, 'LA VIRGINIA'),
  (1999, 'MARSELLA'),
  (2000, 'MISTRATO'),
  (2001, 'PEREIRA'),
  (2002, 'PUEBLO RICO'),
  (2003, 'QUINCHÍA'),
  (2004, 'SANTA ROSA DE CABAL'),
  (2005, 'SANTUARIO'),
  (2006, 'PROVIDENCIA'),
  (2007, 'SAN ANDRES'),
  (2008, 'SANTA CATALINA'),
  (2009, 'AGUADA'),
  (2010, 'ALBANIA'),
  (2011, 'ARATOCA'),
  (2012, 'BARBOSA'),
  (2013, 'BARICHARA'),
  (2014, 'BARRANCABERMEJA'),
  (2015, 'BETULIA'),
  (2016, 'BOLÍVAR'),
  (2017, 'BUCARAMANGA'),
  (2018, 'CABRERA'),
  (2019, 'CALIFORNIA'),
  (2020, 'CAPITANEJO'),
  (2021, 'CARCASI'),
  (2022, 'CEPITA'),
  (2023, 'CERRITO'),
  (2024, 'CHARALÁ'),
  (2025, 'CHARTA'),
  (2026, 'CHIMA'),
  (2027, 'CHIPATÁ'),
  (2028, 'CIMITARRA'),
  (2029, 'CONCEPCIÓN'),
  (2030, 'CONFINES'),
  (2031, 'CONTRATACIÓN'),
  (2032, 'COROMORO'),
  (2033, 'CURITÍ'),
  (2034, 'EL CARMEN'),
  (2035, 'EL GUACAMAYO'),
  (2036, 'EL PEÑÓN'),
  (2037, 'EL PLAYÓN'),
  (2038, 'ENCINO'),
  (2039, 'ENCISO'),
  (2040, 'FLORIÁN'),
  (2041, 'FLORIDABLANCA'),
  (2042, 'GALÁN'),
  (2043, 'GAMBITA'),
  (2044, 'GIRÓN'),
  (2045, 'GUACA'),
  (2046, 'GUADALUPE'),
  (2047, 'GUAPOTA'),
  (2048, 'GUAVATÁ'),
  (2049, 'GUEPSA'),
  (2050, 'HATO'),
  (2051, 'JESÚS MARI'),
  (2052, 'JORDÁN'),
  (2053, 'LA BELLEZA'),
  (2054, 'LA PAZ'),
  (2055, 'LANDAZURI'),
  (2056, 'LEBRIJA'),
  (2057, 'LOS SANTS'),
  (2058, 'MACARAVITA'),
  (2059, 'MÁLAGA'),
  (2060, 'MATANZA'),
  (2061, 'MOGOTES'),
  (2062, 'MOLAGAVITA'),
  (2063, 'OCAMONTE'),
  (2064, 'OIBA'),
  (2065, 'ONZAGA'),
  (2066, 'PALMAR'),
  (2067, 'PALMAS DEL OCORRO'),
  (2068, 'PÁRAMO'),
  (2069, 'PIEDECUESTA'),
  (2070, 'PINCHOTE'),
  (2071, 'PUENTE NACIONAL'),
  (2072, 'PUERTO PARRA'),
  (2073, 'PUERTO WILCHES'),
  (2074, 'RIONEGRO'),
  (2075, 'SABANA DE TORRES'),
  (2076, 'SAN ANDRÉS'),
  (2077, 'SAN BENITO'),
  (2078, 'SAN GIL'),
  (2079, 'SAN JOAQUÍN'),
  (2080, 'SAN JOSÉ DE MIRANDA'),
  (2081, 'SAN MIGUEL'),
  (2082, 'SAN VICENTE DE CHUCURÍ'),
  (2083, 'SANTA BÁRBARA'),
  (2084, 'SANTA HELENA'),
  (2085, 'SIMACOTA'),
  (2086, 'SOCORRO'),
  (2087, 'SUAITA'),
  (2088, 'SUCRE'),
  (2089, 'SURATA'),
  (2090, 'TONA'),
  (2091, 'VALLE SAN JOSÉ'),
  (2092, 'VÉLEZ'),
  (2093, 'VETAS'),
  (2094, 'VILLANUEVA'),
  (2095, 'ZAPATOCA'),
  (2096, 'BUENAVISTA'),
  (2097, 'CAIMITO'),
  (2098, 'CHALÁN'),
  (2099, 'COLOSO'),
  (2100, 'COROZAL'),
  (2101, 'EL ROBLE'),
  (2102, 'GALERAS'),
  (2103, 'GUARANDA'),
  (2104, 'LOS PALMIOS'),
  (2105, 'MAJAGUAL'),
  (2106, 'MORROA'),
  (2107, 'OVEJAS'),
  (2108, 'PALMITO'),
  (2109, 'SAMPUES'),
  (2110, 'SAN BENITO ABAD'),
  (2111, 'SAN JUAN DE BETULIA'),
  (2112, 'SAN MARCOS'),
  (2113, 'SAN ONOFRE'),
  (2114, 'SAN PEDRO'),
  (2115, 'SINCÉ'),
  (2116, 'SINCELEJO'),
  (2117, 'SUCRE'),
  (2118, 'TOLÚ'),
  (2119, 'TOLUVIEJO'),
  (2120, 'ALPUJARRA'),
  (2121, 'ALVARADO'),
  (2122, 'AMBALEMA'),
  (2123, 'ANZOATEGUI'),
  (2124, 'ARMERO (GUAYABAL)'),
  (2125, 'ATACO'),
  (2126, 'CAJAMARCA'),
  (2127, 'CARMEN DE APICALÁ'),
  (2128, 'CASABIANCA'),
  (2129, 'CHAPARRAL'),
  (2130, 'COELLO'),
  (2131, 'COYAIMA'),
  (2132, 'CUNDAY'),
  (2133, 'DOLORES'),
  (2134, 'ESPINAL'),
  (2135, 'FALÁN'),
  (2136, 'FLANDES'),
  (2137, 'FRESNO'),
  (2138, 'GUAMO'),
  (2139, 'HERVEO'),
  (2140, 'HONDA'),
  (2141, 'IBAGUÉ'),
  (2142, 'ICONONZO'),
  (2143, 'LÉRIDA'),
  (2144, 'LÍBANO'),
  (2145, 'MARIQUITA'),
  (2146, 'MELGAR'),
  (2147, 'MURILLO'),
  (2148, 'NATAGAIMA'),
  (2149, 'ORTEGA'),
  (2150, 'PALOCABILDO'),
  (2151, 'PIEDRAS PLANAAS'),
  (2152, 'PRADO'),
  (2153, 'PURIFICACIÓN'),
  (2154, 'RIOBLANCO'),
  (2155, 'RONCESVALLES'),
  (2156, 'ROVIRA'),
  (2157, 'SALDAÑA'),
  (2158, 'SAN ANTONIO'),
  (2159, 'SAN LUIS'),
  (2160, 'SANTA ISABEL'),
  (2161, 'SUÁREZ'),
  (2162, 'VALLE DE SAN JUAN'),
  (2163, 'VENADILLO'),
  (2164, 'VILLAHERMOSA'),
  (2165, 'VILLARRICA'),
  (2166, 'ALCALÁ'),
  (2167, 'ANDALUCÍA'),
  (2168, 'ANSERMA NUEVO'),
  (2169, 'ARGELIA'),
  (2170, 'BOLÍVAR'),
  (2171, 'BUENAVENTURA'),
  (2172, 'BUGA'),
  (2173, 'BUGALAGRANDE'),
  (2174, 'CAICEDONIA'),
  (2175, 'CALI'),
  (2176, 'CALIMA (DARIEN)'),
  (2177, 'CANDELARIA'),
  (2178, 'CARTAGO'),
  (2179, 'DAGUA'),
  (2180, 'EL AGUILA'),
  (2181, 'EL CAIRO'),
  (2182, 'EL CERRITO'),
  (2183, 'EL DOVIO'),
  (2184, 'FLORIDA'),
  (2185, 'GINEBRA GUACARI'),
  (2186, 'JAMUNDÍ'),
  (2187, 'LA CUMBRE'),
  (2188, 'LA UNIÓN'),
  (2189, 'LA VICTORIA'),
  (2190, 'OBANDO'),
  (2191, 'PALMIRA'),
  (2192, 'PRADERA'),
  (2193, 'RESTREPO'),
  (2194, 'RIO FRÍO'),
  (2195, 'ROLDANILLO'),
  (2196, 'SAN PEDRO'),
  (2197, 'SEVILLA'),
  (2198, 'TORO'),
  (2199, 'TRUJILLO'),
  (2200, 'TULÚA'),
  (2201, 'ULLOA'),
  (2202, 'VERSALLES'),
  (2203, 'VIJES'),
  (2204, 'YOTOCO'),
  (2205, 'YUMBO'),
  (2206, 'ZARZAL'),
  (2207, 'CARURÚ'),
  (2208, 'MITÚ'),
  (2209, 'PACOA'),
  (2210, 'PAPUNAUA'),
  (2211, 'TARAIRA'),
  (2212, 'YAVARATÉ'),
  (2213, 'CUMARIBO'),
  (2214, 'LA PRIMAVERA'),
  (2215, 'PUERTO CARREÑO'),
  (2216, 'SANTA ROSALIA');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `color`
  --
  
  DROP TABLE IF EXISTS `color`;
  CREATE TABLE IF NOT EXISTS `color` (
    `col_id` int(11) NOT NULL AUTO_INCREMENT,
    `col_descripcion` varchar(100) DEFAULT NULL,
    `col_estado` tinyint(1) DEFAULT '1',
    PRIMARY KEY (`col_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8 COMMENT='	';
  
  --
  -- Volcado de datos para la tabla `color`
  --
  
  INSERT INTO `color` (`col_id`, `col_descripcion`, `col_estado`) VALUES
  (1, 'BLANCO', 1),
  (2, 'AZUR', 1),
  (3, 'CREMA', 1),
  (4, 'NIEVE', 1),
  (5, 'MARFIL', 1),
  (6, 'BLANCO FANTASMA', 1),
  (7, 'BLANCO FLORAL', 1),
  (8, 'AZUL ALICIA', 1),
  (9, 'CIAN CLARO', 1),
  (10, 'MELÓN VERDE', 1),
  (11, 'AMARILLO CLARO', 1),
  (12, 'CONCHA', 1),
  (13, 'SONROJO LAVANDA', 1),
  (14, 'HUMO BLANCO', 1),
  (15, 'ENCAJE ANTIGUO', 1),
  (16, 'SEDA DE MAÍZ', 1),
  (17, 'LINO', 1),
  (18, 'AMARILLO ALAMBRE DORADO CLARO', 1),
  (19, 'GASA LIMÓN', 1),
  (20, 'BEIGE', 1),
  (21, 'LAVANDA', 1),
  (22, 'BATIDO DE PAPAYA', 1),
  (23, 'ROSA BRUMOSA', 1),
  (24, 'BLANCO ANTIGUO', 1),
  (25, 'BLANCO ALMENDRA', 1),
  (26, 'SOPA', 1),
  (27, 'TURQUESA PÁLIDO', 1),
  (28, 'MOCASÍN', 1),
  (29, 'GAINSBORO', 1),
  (30, 'SOPLIDO MELOCOTÓN', 1),
  (31, 'BLANCO NAVAJO', 1),
  (32, 'DORADO ALAMBRE PÁLIDO', 1),
  (33, 'TRIGO', 1),
  (34, 'POLVO AZUL', 1),
  (35, 'AGUAMARINA', 1),
  (36, 'GRIS CLARO', 1),
  (37, 'ROSA', 1),
  (38, 'AZUL CLARO', 1),
  (39, 'CARDO', 1),
  (40, 'ROSA CLARO', 1),
  (41, 'AZUL CIELO CLARO', 1),
  (42, 'VERDE PÁLIDO', 1),
  (43, 'AZUL ACERO CLARO', 1),
  (44, 'CAQUI', 1),
  (45, 'AZUL CIELO', 1),
  (46, 'AGUA', 1),
  (47, 'CIAN', 1),
  (48, 'PLATA', 1),
  (49, 'CIRUELA', 1),
  (50, 'GRIS', 1),
  (51, 'VERDE CLARO', 1),
  (52, 'VIOLETA', 1),
  (53, 'AMARILLO', 1),
  (54, 'TURQUESA', 1),
  (55, 'MADERA FORNIDA', 1),
  (56, 'AMARILLO VERDE', 1),
  (57, 'BRONCEADO', 1),
  (58, 'TURQUESA MEDIO', 1),
  (59, 'SALMÓN CLARO', 1),
  (60, 'AGUAMARINA MEDIO', 1),
  (61, 'GRIS OSCURO', 1),
  (62, 'ORQUÍDEA', 1),
  (63, 'VERDE MAR INTENSO', 1),
  (64, 'AZUL CIELO INTENSO', 1),
  (65, 'MARRÓN ARENA', 1),
  (66, 'DORADO', 1),
  (67, 'VERDE PRIMAVERA MEDIO', 1),
  (68, 'CAQUI OSCURO', 1),
  (69, 'ACIANO AZUL', 1),
  (70, 'ROSA CALIENTE', 1),
  (71, 'SALMÓN OSCURO', 1),
  (72, 'TURQUESA OSCURO', 1),
  (73, 'VERDE PRIMAVERA', 1),
  (74, 'CORAL CLARO', 1),
  (75, 'MARRÓN ROSADO', 1),
  (76, 'SALMÓN', 1),
  (77, 'CHARTREUSE', 1),
  (78, 'PÚRPURA MEDIO', 1),
  (79, 'VERDE CÉSPED', 1),
  (80, 'AZUL DODGER', 1),
  (81, 'VERDE AMARILLO', 1),
  (82, 'VIOLETA ROJO PÁLIDO', 1),
  (83, 'AZUL PIZARRA MEDIO', 1),
  (84, 'ORQUÍDEA MEDIO', 1),
  (85, 'CORAL', 1),
  (86, 'AZUL CADETE', 1),
  (87, 'VERDE MAR CLARO', 1),
  (88, 'DORADO ALAMBRE', 1),
  (89, 'NARANJA', 1),
  (90, 'GRIS PIZARRA CLARO', 1),
  (91, 'FUCSIA', 1),
  (92, 'MAGENTA', 1),
  (93, 'VERDE MAR MEDIO', 1),
  (94, 'PERÚ', 1),
  (95, 'AZUL ACERO', 1),
  (96, 'AZUL REAL', 1),
  (97, 'GRIS PIZARRA', 1),
  (98, 'TOMATE', 1),
  (99, 'NARANJA OSCURO', 1),
  (100, 'AZUL PIZARRA', 1),
  (101, 'VERDE LIMA', 1),
  (102, 'LIMA', 1),
  (103, 'ROJO INDIO', 1),
  (104, 'ORQUÍDEA OSCURO', 1),
  (105, 'AZUL VIOLETA', 1),
  (106, 'ROSA INTENSO', 1),
  (107, 'DORADO ALAMBRE OSCURO', 1),
  (108, 'CHOCOLATE', 1),
  (109, 'CIAN OSCURO', 1),
  (110, 'GRIS DIFUSO', 1),
  (111, 'GRIS ACEITUNA', 1),
  (112, 'VERDE MAR', 1),
  (113, 'VERDE CERCETA', 1),
  (114, 'VIOLETA OSCURO', 1),
  (115, 'VIOLETA ROJO MEDIO', 1),
  (116, 'NARANJA ROJO', 1),
  (117, 'ACEITUNA', 1),
  (118, 'SIENA', 1),
  (119, 'AZUL PIZARRA OSCURO', 1),
  (120, 'VERDE ACEITUNA OSCURO', 1),
  (121, 'VERDE BOSQUE', 1),
  (122, 'CARMESÍ', 1),
  (123, 'AZUL', 1),
  (124, 'MAGENTA OSCURO', 1),
  (125, 'GRIS PIZARRA OSCURO', 1),
  (126, 'MARRÓN MONTURA', 1),
  (127, 'MARRÓN', 1),
  (128, 'LADRILLO REFRACTARIO', 1),
  (129, 'PÚRPURA', 1),
  (130, 'VERDE', 1),
  (131, 'ROJO', 1),
  (132, 'AZUL MEDIO', 1),
  (133, 'ÍNDIGO', 1),
  (134, 'AZUL MEDIANOCHE', 1),
  (135, 'VERDE OSCURO', 1),
  (136, 'AZUL OSCURO', 1),
  (137, 'AZUL MARINO', 1),
  (138, 'ROJO OSCURO', 1),
  (139, 'GRANATE', 1),
  (140, 'NEGRO', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `detalle_orden_de_compra`
  --
  
  DROP TABLE IF EXISTS `detalle_orden_de_compra`;
  CREATE TABLE IF NOT EXISTS `detalle_orden_de_compra` (
    `pro_id` int(11) NOT NULL,
    `ord_com_id` int(11) NOT NULL,
    `det_com_cantidad` int(11) DEFAULT NULL,
    `det_com_etapa` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`pro_id`,`ord_com_id`),
    KEY `fk_producto_has_orden_de_compra_orden_de_compra1_idx` (`ord_com_id`),
    KEY `fk_producto_has_orden_de_compra_producto1_idx` (`pro_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `detalle_orden_de_compra`
  --
  
  INSERT INTO `detalle_orden_de_compra` (`pro_id`, `ord_com_id`, `det_com_cantidad`, `det_com_etapa`) VALUES
  (1, 29, 10, ''),
  (1, 31, 10, ''),
  (2, 30, 5, ''),
  (2, 32, 10, ''),
  (2, 33, 10, '');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `empresa`
  --
  
  DROP TABLE IF EXISTS `empresa`;
  CREATE TABLE IF NOT EXISTS `empresa` (
    `emp_id` int(11) NOT NULL AUTO_INCREMENT,
    `emp_nit` varchar(100) DEFAULT NULL,
    `emp_razon_social` varchar(100) DEFAULT NULL,
    `emp_telefono` varchar(100) DEFAULT NULL,
    `emp_direccion` varchar(100) DEFAULT NULL,
    `emp_correo` varchar(100) DEFAULT NULL,
    `emp_contacto` varchar(100) DEFAULT NULL,
    `emp_estado` tinyint(4) DEFAULT '1',
    `tip_cli_id` int(11) NOT NULL,
    `ciu_id` int(11) NOT NULL,
    `emp_nombres` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`emp_id`),
    KEY `fk_empresa_ciudad1_idx` (`ciu_id`),
    KEY `fk_empresa_tipo_cliente1_idx` (`tip_cli_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `empresa`
  --
  
  INSERT INTO `empresa` (`emp_id`, `emp_nit`, `emp_razon_social`, `emp_telefono`, `emp_direccion`, `emp_correo`, `emp_contacto`, `emp_estado`, `tip_cli_id`, `ciu_id`, `emp_nombres`) VALUES
  (1, '12', 'aakjs', 'ssoso', 'sjsjs', 'jjdjd@dfff.ff', 'kkdd', 1, 1, 1067, 'nombre'),
  (3, '76', 'sas', '877', 'cjaauu', 'ytty@khsh.uy', '7777', 1, 1, 3, 'sas');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `orden_de_compra`
  --
  
  DROP TABLE IF EXISTS `orden_de_compra`;
  CREATE TABLE IF NOT EXISTS `orden_de_compra` (
    `ord_com_id` int(11) NOT NULL AUTO_INCREMENT,
    `ord_com_fecha` date DEFAULT NULL,
    `ord_com_total` int(11) DEFAULT NULL,
    `ord_com_estado` varchar(45) DEFAULT NULL,
    `ord_tipo_cli` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`ord_com_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `orden_de_compra`
  --
  
  INSERT INTO `orden_de_compra` (`ord_com_id`, `ord_com_fecha`, `ord_com_total`, `ord_com_estado`, `ord_tipo_cli`) VALUES
  (29, '2016-08-23', 200000, '1', '1, p'),
  (30, '2016-08-23', 50000, '0', '1, p'),
  (31, '2016-08-23', 200000, '1', '1, b'),
  (32, '2016-08-23', 100000, '0', '1, b'),
  (33, '2016-08-23', 100000, '1', '3, b');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `persona`
  --
  
  DROP TABLE IF EXISTS `persona`;
  CREATE TABLE IF NOT EXISTS `persona` (
    `per_id` int(11) NOT NULL AUTO_INCREMENT,
    `per_telefono` varchar(20) DEFAULT NULL,
    `per_direccion` varchar(100) DEFAULT NULL,
    `per_correo` varchar(100) DEFAULT NULL,
    `per_fecha_nacimiento` date DEFAULT NULL,
    `per_estado` tinyint(1) DEFAULT '1',
    `tip_cli_id` int(11) NOT NULL,
    `ciu_id` int(11) NOT NULL,
    `per_identificacion` int(11) DEFAULT NULL,
    `per_nombres` varchar(100) DEFAULT NULL,
    `per_apellidos` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`per_id`),
    KEY `fk_persona_ciudad_idx` (`ciu_id`),
    KEY `fk_persona_tipo_cliente1_idx` (`tip_cli_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=503 DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `persona`
  --
  
  INSERT INTO `persona` (`per_id`, `per_telefono`, `per_direccion`, `per_correo`, `per_fecha_nacimiento`, `per_estado`, `tip_cli_id`, `ciu_id`, `per_identificacion`, `per_nombres`, `per_apellidos`) VALUES
  (3, '4876900', 'CARRERA 26 A 2 # 0', '0DEMO@HOT.COM', '2016-08-23', 1, 1, 253, 1010049356, 'luis fernando', 'angulo'),
  (4, '4876901', 'CARRERA 26 A 2 # 1', '1DEMO@HOT.COM', '2016-08-23', 0, 2, 1050, NULL, NULL, NULL),
  (5, '4876902', 'CARRERA 26 A 2 # 2', '2DEMO@HOT.COM', '2016-08-23', 0, 2, 355, NULL, NULL, NULL),
  (6, '4876903', 'CARRERA 26 A 2 # 3', '3DEMO@HOT.COM', '2016-08-23', 0, 2, 570, NULL, NULL, NULL),
  (7, '4876904', 'CARRERA 26 A 2 # 4', '4DEMO@HOT.COM', '2016-08-23', 0, 1, 1706, NULL, NULL, NULL),
  (8, '4876905', 'CARRERA 26 A 2 # 5', '5DEMO@HOT.COM', '2016-08-23', 0, 1, 1702, NULL, NULL, NULL),
  (9, '4876906', 'CARRERA 26 A 2 # 6', '6DEMO@HOT.COM', '2016-08-23', 0, 2, 1450, NULL, NULL, NULL),
  (10, '4876907', 'CARRERA 26 A 2 # 7', '7DEMO@HOT.COM', '2016-08-23', 0, 1, 122, NULL, NULL, NULL),
  (11, '4876908', 'CARRERA 26 A 2 # 8', '8DEMO@HOT.COM', '2016-08-23', 0, 1, 1242, NULL, NULL, NULL),
  (12, '4876909', 'CARRERA 26 A 2 # 9', '9DEMO@HOT.COM', '2016-08-23', 0, 1, 1419, NULL, NULL, NULL),
  (13, '48769010', 'CARRERA 26 A 2 # 10', '10DEMO@HOT.COM', '2016-08-23', 0, 1, 572, NULL, NULL, NULL),
  (14, '48769011', 'CARRERA 26 A 2 # 11', '11DEMO@HOT.COM', '2016-08-23', 0, 1, 1008, NULL, NULL, NULL),
  (15, '48769012', 'CARRERA 26 A 2 # 12', '12DEMO@HOT.COM', '2016-08-23', 0, 1, 643, NULL, NULL, NULL),
  (16, '48769013', 'CARRERA 26 A 2 # 13', '13DEMO@HOT.COM', '2016-08-23', 0, 1, 1624, NULL, NULL, NULL),
  (17, '48769014', 'CARRERA 26 A 2 # 14', '14DEMO@HOT.COM', '2016-08-23', 0, 2, 650, NULL, NULL, NULL),
  (18, '48769015', 'CARRERA 26 A 2 # 15', '15DEMO@HOT.COM', '2016-08-23', 0, 1, 17, NULL, NULL, NULL),
  (19, '48769016', 'CARRERA 26 A 2 # 16', '16DEMO@HOT.COM', '2016-08-23', 0, 1, 343, NULL, NULL, NULL),
  (20, '48769017', 'CARRERA 26 A 2 # 17', '17DEMO@HOT.COM', '2016-08-23', 0, 2, 704, NULL, NULL, NULL),
  (21, '48769018', 'CARRERA 26 A 2 # 18', '18DEMO@HOT.COM', '2016-08-23', 0, 2, 1491, NULL, NULL, NULL),
  (22, '48769019', 'CARRERA 26 A 2 # 19', '19DEMO@HOT.COM', '2016-08-23', 0, 1, 1446, NULL, NULL, NULL),
  (23, '48769020', 'CARRERA 26 A 2 # 20', '20DEMO@HOT.COM', '2016-08-23', 0, 2, 1635, NULL, NULL, NULL),
  (24, '48769021', 'CARRERA 26 A 2 # 21', '21DEMO@HOT.COM', '2016-08-23', 0, 2, 1145, NULL, NULL, NULL),
  (25, '48769022', 'CARRERA 26 A 2 # 22', '22DEMO@HOT.COM', '2016-08-23', 0, 1, 1478, NULL, NULL, NULL),
  (26, '48769023', 'CARRERA 26 A 2 # 23', '23DEMO@HOT.COM', '2016-08-23', 0, 1, 572, NULL, NULL, NULL),
  (27, '48769024', 'CARRERA 26 A 2 # 24', '24DEMO@HOT.COM', '2016-08-23', 0, 1, 1602, NULL, NULL, NULL),
  (28, '48769025', 'CARRERA 26 A 2 # 25', '25DEMO@HOT.COM', '2016-08-23', 0, 2, 243, NULL, NULL, NULL),
  (29, '48769026', 'CARRERA 26 A 2 # 26', '26DEMO@HOT.COM', '2016-08-23', 0, 1, 336, NULL, NULL, NULL),
  (30, '48769027', 'CARRERA 26 A 2 # 27', '27DEMO@HOT.COM', '2016-08-23', 0, 2, 633, NULL, NULL, NULL),
  (31, '48769028', 'CARRERA 26 A 2 # 28', '28DEMO@HOT.COM', '2016-08-23', 0, 2, 1443, NULL, NULL, NULL),
  (32, '48769029', 'CARRERA 26 A 2 # 29', '29DEMO@HOT.COM', '2016-08-23', 0, 1, 150, NULL, NULL, NULL),
  (33, '48769030', 'CARRERA 26 A 2 # 30', '30DEMO@HOT.COM', '2016-08-23', 0, 2, 1729, NULL, NULL, NULL),
  (34, '48769031', 'CARRERA 26 A 2 # 31', '31DEMO@HOT.COM', '2016-08-23', 0, 1, 1297, NULL, NULL, NULL),
  (35, '48769032', 'CARRERA 26 A 2 # 32', '32DEMO@HOT.COM', '2016-08-23', 0, 1, 865, NULL, NULL, NULL),
  (36, '48769033', 'CARRERA 26 A 2 # 33', '33DEMO@HOT.COM', '2016-08-23', 0, 1, 164, NULL, NULL, NULL),
  (37, '48769034', 'CARRERA 26 A 2 # 34', '34DEMO@HOT.COM', '2016-08-23', 0, 1, 1275, NULL, NULL, NULL),
  (38, '48769035', 'CARRERA 26 A 2 # 35', '35DEMO@HOT.COM', '2016-08-23', 0, 2, 532, NULL, NULL, NULL),
  (39, '48769036', 'CARRERA 26 A 2 # 36', '36DEMO@HOT.COM', '2016-08-23', 0, 1, 80, NULL, NULL, NULL),
  (40, '48769037', 'CARRERA 26 A 2 # 37', '37DEMO@HOT.COM', '2016-08-23', 0, 1, 592, NULL, NULL, NULL),
  (41, '48769038', 'CARRERA 26 A 2 # 38', '38DEMO@HOT.COM', '2016-08-23', 0, 2, 704, NULL, NULL, NULL),
  (42, '48769039', 'CARRERA 26 A 2 # 39', '39DEMO@HOT.COM', '2016-08-23', 0, 1, 707, NULL, NULL, NULL),
  (43, '48769040', 'CARRERA 26 A 2 # 40', '40DEMO@HOT.COM', '2016-08-23', 0, 2, 1510, NULL, NULL, NULL),
  (44, '48769041', 'CARRERA 26 A 2 # 41', '41DEMO@HOT.COM', '2016-08-23', 0, 2, 1932, NULL, NULL, NULL),
  (45, '48769042', 'CARRERA 26 A 2 # 42', '42DEMO@HOT.COM', '2016-08-23', 0, 2, 657, NULL, NULL, NULL),
  (46, '48769043', 'CARRERA 26 A 2 # 43', '43DEMO@HOT.COM', '2016-08-23', 0, 2, 1694, NULL, NULL, NULL),
  (47, '48769044', 'CARRERA 26 A 2 # 44', '44DEMO@HOT.COM', '2016-08-23', 0, 1, 1194, NULL, NULL, NULL),
  (48, '48769045', 'CARRERA 26 A 2 # 45', '45DEMO@HOT.COM', '2016-08-23', 0, 2, 1003, NULL, NULL, NULL),
  (49, '48769046', 'CARRERA 26 A 2 # 46', '46DEMO@HOT.COM', '2016-08-23', 0, 1, 79, NULL, NULL, NULL),
  (50, '48769047', 'CARRERA 26 A 2 # 47', '47DEMO@HOT.COM', '2016-08-23', 0, 2, 87, NULL, NULL, NULL),
  (51, '48769048', 'CARRERA 26 A 2 # 48', '48DEMO@HOT.COM', '2016-08-23', 0, 2, 877, NULL, NULL, NULL),
  (52, '48769049', 'CARRERA 26 A 2 # 49', '49DEMO@HOT.COM', '2016-08-23', 0, 2, 971, NULL, NULL, NULL),
  (53, '48769050', 'CARRERA 26 A 2 # 50', '50DEMO@HOT.COM', '2016-08-23', 0, 2, 1082, NULL, NULL, NULL),
  (54, '48769051', 'CARRERA 26 A 2 # 51', '51DEMO@HOT.COM', '2016-08-23', 0, 1, 1570, NULL, NULL, NULL),
  (55, '48769052', 'CARRERA 26 A 2 # 52', '52DEMO@HOT.COM', '2016-08-23', 0, 1, 83, NULL, NULL, NULL),
  (56, '48769053', 'CARRERA 26 A 2 # 53', '53DEMO@HOT.COM', '2016-08-23', 0, 2, 1985, NULL, NULL, NULL),
  (57, '48769054', 'CARRERA 26 A 2 # 54', '54DEMO@HOT.COM', '2016-08-23', 0, 1, 1858, NULL, NULL, NULL),
  (58, '48769055', 'CARRERA 26 A 2 # 55', '55DEMO@HOT.COM', '2016-08-23', 0, 1, 331, NULL, NULL, NULL),
  (59, '48769056', 'CARRERA 26 A 2 # 56', '56DEMO@HOT.COM', '2016-08-23', 0, 1, 1106, NULL, NULL, NULL),
  (60, '48769057', 'CARRERA 26 A 2 # 57', '57DEMO@HOT.COM', '2016-08-23', 0, 2, 492, NULL, NULL, NULL),
  (61, '48769058', 'CARRERA 26 A 2 # 58', '58DEMO@HOT.COM', '2016-08-23', 0, 2, 211, NULL, NULL, NULL),
  (62, '48769059', 'CARRERA 26 A 2 # 59', '59DEMO@HOT.COM', '2016-08-23', 0, 1, 9, NULL, NULL, NULL),
  (63, '48769060', 'CARRERA 26 A 2 # 60', '60DEMO@HOT.COM', '2016-08-23', 0, 1, 278, NULL, NULL, NULL),
  (64, '48769061', 'CARRERA 26 A 2 # 61', '61DEMO@HOT.COM', '2016-08-23', 0, 2, 1608, NULL, NULL, NULL),
  (65, '48769062', 'CARRERA 26 A 2 # 62', '62DEMO@HOT.COM', '2016-08-23', 0, 2, 399, NULL, NULL, NULL),
  (66, '48769063', 'CARRERA 26 A 2 # 63', '63DEMO@HOT.COM', '2016-08-23', 0, 2, 1770, NULL, NULL, NULL),
  (67, '48769064', 'CARRERA 26 A 2 # 64', '64DEMO@HOT.COM', '2016-08-23', 0, 1, 719, NULL, NULL, NULL),
  (68, '48769065', 'CARRERA 26 A 2 # 65', '65DEMO@HOT.COM', '2016-08-23', 0, 2, 899, NULL, NULL, NULL),
  (69, '48769066', 'CARRERA 26 A 2 # 66', '66DEMO@HOT.COM', '2016-08-23', 0, 1, 302, NULL, NULL, NULL),
  (70, '48769067', 'CARRERA 26 A 2 # 67', '67DEMO@HOT.COM', '2016-08-23', 0, 1, 138, NULL, NULL, NULL),
  (71, '48769068', 'CARRERA 26 A 2 # 68', '68DEMO@HOT.COM', '2016-08-23', 0, 1, 1284, NULL, NULL, NULL),
  (72, '48769069', 'CARRERA 26 A 2 # 69', '69DEMO@HOT.COM', '2016-08-23', 0, 2, 583, NULL, NULL, NULL),
  (73, '48769070', 'CARRERA 26 A 2 # 70', '70DEMO@HOT.COM', '2016-08-23', 0, 1, 380, NULL, NULL, NULL),
  (74, '48769071', 'CARRERA 26 A 2 # 71', '71DEMO@HOT.COM', '2016-08-23', 0, 1, 414, NULL, NULL, NULL),
  (75, '48769072', 'CARRERA 26 A 2 # 72', '72DEMO@HOT.COM', '2016-08-23', 0, 2, 804, NULL, NULL, NULL),
  (76, '48769073', 'CARRERA 26 A 2 # 73', '73DEMO@HOT.COM', '2016-08-23', 0, 2, 1973, NULL, NULL, NULL),
  (77, '48769074', 'CARRERA 26 A 2 # 74', '74DEMO@HOT.COM', '2016-08-23', 0, 2, 1278, NULL, NULL, NULL),
  (78, '48769075', 'CARRERA 26 A 2 # 75', '75DEMO@HOT.COM', '2016-08-23', 0, 2, 149, NULL, NULL, NULL),
  (79, '48769076', 'CARRERA 26 A 2 # 76', '76DEMO@HOT.COM', '2016-08-23', 0, 2, 1538, NULL, NULL, NULL),
  (80, '48769077', 'CARRERA 26 A 2 # 77', '77DEMO@HOT.COM', '2016-08-23', 0, 1, 751, NULL, NULL, NULL),
  (81, '48769078', 'CARRERA 26 A 2 # 78', '78DEMO@HOT.COM', '2016-08-23', 0, 2, 326, NULL, NULL, NULL),
  (82, '48769079', 'CARRERA 26 A 2 # 79', '79DEMO@HOT.COM', '2016-08-23', 0, 2, 40, NULL, NULL, NULL),
  (83, '48769080', 'CARRERA 26 A 2 # 80', '80DEMO@HOT.COM', '2016-08-23', 0, 1, 1104, NULL, NULL, NULL),
  (84, '48769081', 'CARRERA 26 A 2 # 81', '81DEMO@HOT.COM', '2016-08-23', 0, 2, 1474, NULL, NULL, NULL),
  (85, '48769082', 'CARRERA 26 A 2 # 82', '82DEMO@HOT.COM', '2016-08-23', 0, 1, 901, NULL, NULL, NULL),
  (86, '48769083', 'CARRERA 26 A 2 # 83', '83DEMO@HOT.COM', '2016-08-23', 0, 1, 239, NULL, NULL, NULL),
  (87, '48769084', 'CARRERA 26 A 2 # 84', '84DEMO@HOT.COM', '2016-08-23', 0, 2, 1537, NULL, NULL, NULL),
  (88, '48769085', 'CARRERA 26 A 2 # 85', '85DEMO@HOT.COM', '2016-08-23', 0, 2, 76, NULL, NULL, NULL),
  (89, '48769086', 'CARRERA 26 A 2 # 86', '86DEMO@HOT.COM', '2016-08-23', 0, 2, 1249, NULL, NULL, NULL),
  (90, '48769087', 'CARRERA 26 A 2 # 87', '87DEMO@HOT.COM', '2016-08-23', 0, 2, 29, NULL, NULL, NULL),
  (91, '48769088', 'CARRERA 26 A 2 # 88', '88DEMO@HOT.COM', '2016-08-23', 0, 1, 1175, NULL, NULL, NULL),
  (92, '48769089', 'CARRERA 26 A 2 # 89', '89DEMO@HOT.COM', '2016-08-23', 0, 2, 623, NULL, NULL, NULL),
  (93, '48769090', 'CARRERA 26 A 2 # 90', '90DEMO@HOT.COM', '2016-08-23', 0, 2, 1003, NULL, NULL, NULL),
  (94, '48769091', 'CARRERA 26 A 2 # 91', '91DEMO@HOT.COM', '2016-08-23', 0, 1, 189, NULL, NULL, NULL),
  (95, '48769092', 'CARRERA 26 A 2 # 92', '92DEMO@HOT.COM', '2016-08-23', 0, 1, 714, NULL, NULL, NULL),
  (96, '48769093', 'CARRERA 26 A 2 # 93', '93DEMO@HOT.COM', '2016-08-23', 0, 2, 1944, NULL, NULL, NULL),
  (97, '48769094', 'CARRERA 26 A 2 # 94', '94DEMO@HOT.COM', '2016-08-23', 0, 1, 1562, NULL, NULL, NULL),
  (98, '48769095', 'CARRERA 26 A 2 # 95', '95DEMO@HOT.COM', '2016-08-23', 0, 1, 765, NULL, NULL, NULL),
  (99, '48769096', 'CARRERA 26 A 2 # 96', '96DEMO@HOT.COM', '2016-08-23', 0, 2, 1763, NULL, NULL, NULL),
  (100, '48769097', 'CARRERA 26 A 2 # 97', '97DEMO@HOT.COM', '2016-08-23', 0, 1, 444, NULL, NULL, NULL),
  (101, '48769098', 'CARRERA 26 A 2 # 98', '98DEMO@HOT.COM', '2016-08-23', 0, 1, 1424, NULL, NULL, NULL),
  (102, '48769099', 'CARRERA 26 A 2 # 99', '99DEMO@HOT.COM', '2016-08-23', 0, 2, 1043, NULL, NULL, NULL),
  (103, '487690100', 'CARRERA 26 A 2 # 100', '100DEMO@HOT.COM', '2016-08-23', 0, 2, 1573, NULL, NULL, NULL),
  (104, '487690101', 'CARRERA 26 A 2 # 101', '101DEMO@HOT.COM', '2016-08-23', 0, 1, 1027, NULL, NULL, NULL),
  (105, '487690102', 'CARRERA 26 A 2 # 102', '102DEMO@HOT.COM', '2016-08-23', 0, 1, 484, NULL, NULL, NULL),
  (106, '487690103', 'CARRERA 26 A 2 # 103', '103DEMO@HOT.COM', '2016-08-23', 0, 2, 1579, NULL, NULL, NULL),
  (107, '487690104', 'CARRERA 26 A 2 # 104', '104DEMO@HOT.COM', '2016-08-23', 0, 2, 1044, NULL, NULL, NULL),
  (108, '487690105', 'CARRERA 26 A 2 # 105', '105DEMO@HOT.COM', '2016-08-23', 0, 2, 290, NULL, NULL, NULL),
  (109, '487690106', 'CARRERA 26 A 2 # 106', '106DEMO@HOT.COM', '2016-08-23', 0, 2, 1756, NULL, NULL, NULL),
  (110, '487690107', 'CARRERA 26 A 2 # 107', '107DEMO@HOT.COM', '2016-08-23', 0, 2, 947, NULL, NULL, NULL),
  (111, '487690108', 'CARRERA 26 A 2 # 108', '108DEMO@HOT.COM', '2016-08-23', 0, 1, 1126, NULL, NULL, NULL),
  (112, '487690109', 'CARRERA 26 A 2 # 109', '109DEMO@HOT.COM', '2016-08-23', 0, 1, 1124, NULL, NULL, NULL),
  (113, '487690110', 'CARRERA 26 A 2 # 110', '110DEMO@HOT.COM', '2016-08-23', 0, 1, 285, NULL, NULL, NULL),
  (114, '487690111', 'CARRERA 26 A 2 # 111', '111DEMO@HOT.COM', '2016-08-23', 0, 2, 1021, NULL, NULL, NULL),
  (115, '487690112', 'CARRERA 26 A 2 # 112', '112DEMO@HOT.COM', '2016-08-23', 0, 1, 1098, NULL, NULL, NULL),
  (116, '487690113', 'CARRERA 26 A 2 # 113', '113DEMO@HOT.COM', '2016-08-23', 0, 1, 890, NULL, NULL, NULL),
  (117, '487690114', 'CARRERA 26 A 2 # 114', '114DEMO@HOT.COM', '2016-08-23', 0, 1, 1802, NULL, NULL, NULL),
  (118, '487690115', 'CARRERA 26 A 2 # 115', '115DEMO@HOT.COM', '2016-08-23', 0, 1, 1114, NULL, NULL, NULL),
  (119, '487690116', 'CARRERA 26 A 2 # 116', '116DEMO@HOT.COM', '2016-08-23', 0, 1, 1856, NULL, NULL, NULL),
  (120, '487690117', 'CARRERA 26 A 2 # 117', '117DEMO@HOT.COM', '2016-08-23', 0, 1, 273, NULL, NULL, NULL),
  (121, '487690118', 'CARRERA 26 A 2 # 118', '118DEMO@HOT.COM', '2016-08-23', 0, 2, 258, NULL, NULL, NULL),
  (122, '487690119', 'CARRERA 26 A 2 # 119', '119DEMO@HOT.COM', '2016-08-23', 0, 1, 1546, NULL, NULL, NULL),
  (123, '487690120', 'CARRERA 26 A 2 # 120', '120DEMO@HOT.COM', '2016-08-23', 0, 2, 89, NULL, NULL, NULL),
  (124, '487690121', 'CARRERA 26 A 2 # 121', '121DEMO@HOT.COM', '2016-08-23', 0, 1, 674, NULL, NULL, NULL),
  (125, '487690122', 'CARRERA 26 A 2 # 122', '122DEMO@HOT.COM', '2016-08-23', 0, 1, 880, NULL, NULL, NULL),
  (126, '487690123', 'CARRERA 26 A 2 # 123', '123DEMO@HOT.COM', '2016-08-23', 0, 2, 1625, NULL, NULL, NULL),
  (127, '487690124', 'CARRERA 26 A 2 # 124', '124DEMO@HOT.COM', '2016-08-23', 0, 2, 1860, NULL, NULL, NULL),
  (128, '487690125', 'CARRERA 26 A 2 # 125', '125DEMO@HOT.COM', '2016-08-23', 0, 2, 797, NULL, NULL, NULL),
  (129, '487690126', 'CARRERA 26 A 2 # 126', '126DEMO@HOT.COM', '2016-08-23', 0, 2, 7, NULL, NULL, NULL),
  (130, '487690127', 'CARRERA 26 A 2 # 127', '127DEMO@HOT.COM', '2016-08-23', 0, 1, 261, NULL, NULL, NULL),
  (131, '487690128', 'CARRERA 26 A 2 # 128', '128DEMO@HOT.COM', '2016-08-23', 0, 2, 76, NULL, NULL, NULL),
  (132, '487690129', 'CARRERA 26 A 2 # 129', '129DEMO@HOT.COM', '2016-08-23', 0, 2, 613, NULL, NULL, NULL),
  (133, '487690130', 'CARRERA 26 A 2 # 130', '130DEMO@HOT.COM', '2016-08-23', 0, 1, 1897, NULL, NULL, NULL),
  (134, '487690131', 'CARRERA 26 A 2 # 131', '131DEMO@HOT.COM', '2016-08-23', 0, 2, 552, NULL, NULL, NULL),
  (135, '487690132', 'CARRERA 26 A 2 # 132', '132DEMO@HOT.COM', '2016-08-23', 0, 1, 422, NULL, NULL, NULL),
  (136, '487690133', 'CARRERA 26 A 2 # 133', '133DEMO@HOT.COM', '2016-08-23', 0, 2, 1065, NULL, NULL, NULL),
  (137, '487690134', 'CARRERA 26 A 2 # 134', '134DEMO@HOT.COM', '2016-08-23', 0, 1, 1257, NULL, NULL, NULL),
  (138, '487690135', 'CARRERA 26 A 2 # 135', '135DEMO@HOT.COM', '2016-08-23', 0, 1, 1930, NULL, NULL, NULL),
  (139, '487690136', 'CARRERA 26 A 2 # 136', '136DEMO@HOT.COM', '2016-08-23', 0, 1, 1897, NULL, NULL, NULL),
  (140, '487690137', 'CARRERA 26 A 2 # 137', '137DEMO@HOT.COM', '2016-08-23', 0, 2, 451, NULL, NULL, NULL),
  (141, '487690138', 'CARRERA 26 A 2 # 138', '138DEMO@HOT.COM', '2016-08-23', 0, 1, 919, NULL, NULL, NULL),
  (142, '487690139', 'CARRERA 26 A 2 # 139', '139DEMO@HOT.COM', '2016-08-23', 0, 1, 1555, NULL, NULL, NULL),
  (143, '487690140', 'CARRERA 26 A 2 # 140', '140DEMO@HOT.COM', '2016-08-23', 0, 1, 1105, NULL, NULL, NULL),
  (144, '487690141', 'CARRERA 26 A 2 # 141', '141DEMO@HOT.COM', '2016-08-23', 0, 2, 1289, NULL, NULL, NULL),
  (145, '487690142', 'CARRERA 26 A 2 # 142', '142DEMO@HOT.COM', '2016-08-23', 0, 1, 1200, NULL, NULL, NULL),
  (146, '487690143', 'CARRERA 26 A 2 # 143', '143DEMO@HOT.COM', '2016-08-23', 0, 1, 1654, NULL, NULL, NULL),
  (147, '487690144', 'CARRERA 26 A 2 # 144', '144DEMO@HOT.COM', '2016-08-23', 0, 2, 1613, NULL, NULL, NULL),
  (148, '487690145', 'CARRERA 26 A 2 # 145', '145DEMO@HOT.COM', '2016-08-23', 0, 1, 361, NULL, NULL, NULL),
  (149, '487690146', 'CARRERA 26 A 2 # 146', '146DEMO@HOT.COM', '2016-08-23', 0, 2, 1069, NULL, NULL, NULL),
  (150, '487690147', 'CARRERA 26 A 2 # 147', '147DEMO@HOT.COM', '2016-08-23', 0, 2, 90, NULL, NULL, NULL),
  (151, '487690148', 'CARRERA 26 A 2 # 148', '148DEMO@HOT.COM', '2016-08-23', 0, 2, 852, NULL, NULL, NULL),
  (152, '487690149', 'CARRERA 26 A 2 # 149', '149DEMO@HOT.COM', '2016-08-23', 0, 2, 677, NULL, NULL, NULL),
  (153, '487690150', 'CARRERA 26 A 2 # 150', '150DEMO@HOT.COM', '2016-08-23', 0, 2, 1050, NULL, NULL, NULL),
  (154, '487690151', 'CARRERA 26 A 2 # 151', '151DEMO@HOT.COM', '2016-08-23', 0, 1, 4, NULL, NULL, NULL),
  (155, '487690152', 'CARRERA 26 A 2 # 152', '152DEMO@HOT.COM', '2016-08-23', 0, 1, 1367, NULL, NULL, NULL),
  (156, '487690153', 'CARRERA 26 A 2 # 153', '153DEMO@HOT.COM', '2016-08-23', 0, 2, 1086, NULL, NULL, NULL),
  (157, '487690154', 'CARRERA 26 A 2 # 154', '154DEMO@HOT.COM', '2016-08-23', 0, 2, 1720, NULL, NULL, NULL),
  (158, '487690155', 'CARRERA 26 A 2 # 155', '155DEMO@HOT.COM', '2016-08-23', 0, 2, 1287, NULL, NULL, NULL),
  (159, '487690156', 'CARRERA 26 A 2 # 156', '156DEMO@HOT.COM', '2016-08-23', 0, 2, 1140, NULL, NULL, NULL),
  (160, '487690157', 'CARRERA 26 A 2 # 157', '157DEMO@HOT.COM', '2016-08-23', 0, 1, 1734, NULL, NULL, NULL),
  (161, '487690158', 'CARRERA 26 A 2 # 158', '158DEMO@HOT.COM', '2016-08-23', 0, 1, 1909, NULL, NULL, NULL),
  (162, '487690159', 'CARRERA 26 A 2 # 159', '159DEMO@HOT.COM', '2016-08-23', 0, 2, 419, NULL, NULL, NULL),
  (163, '487690160', 'CARRERA 26 A 2 # 160', '160DEMO@HOT.COM', '2016-08-23', 0, 2, 876, NULL, NULL, NULL),
  (164, '487690161', 'CARRERA 26 A 2 # 161', '161DEMO@HOT.COM', '2016-08-23', 0, 2, 1909, NULL, NULL, NULL),
  (165, '487690162', 'CARRERA 26 A 2 # 162', '162DEMO@HOT.COM', '2016-08-23', 0, 2, 583, NULL, NULL, NULL),
  (166, '487690163', 'CARRERA 26 A 2 # 163', '163DEMO@HOT.COM', '2016-08-23', 0, 2, 222, NULL, NULL, NULL),
  (167, '487690164', 'CARRERA 26 A 2 # 164', '164DEMO@HOT.COM', '2016-08-23', 0, 1, 1904, NULL, NULL, NULL),
  (168, '487690165', 'CARRERA 26 A 2 # 165', '165DEMO@HOT.COM', '2016-08-23', 0, 1, 1130, NULL, NULL, NULL),
  (169, '487690166', 'CARRERA 26 A 2 # 166', '166DEMO@HOT.COM', '2016-08-23', 0, 1, 639, NULL, NULL, NULL),
  (170, '487690167', 'CARRERA 26 A 2 # 167', '167DEMO@HOT.COM', '2016-08-23', 0, 1, 708, NULL, NULL, NULL),
  (171, '487690168', 'CARRERA 26 A 2 # 168', '168DEMO@HOT.COM', '2016-08-23', 0, 2, 1175, NULL, NULL, NULL),
  (172, '487690169', 'CARRERA 26 A 2 # 169', '169DEMO@HOT.COM', '2016-08-23', 0, 2, 425, NULL, NULL, NULL),
  (173, '487690170', 'CARRERA 26 A 2 # 170', '170DEMO@HOT.COM', '2016-08-23', 0, 1, 60, NULL, NULL, NULL),
  (174, '487690171', 'CARRERA 26 A 2 # 171', '171DEMO@HOT.COM', '2016-08-23', 0, 1, 690, NULL, NULL, NULL),
  (175, '487690172', 'CARRERA 26 A 2 # 172', '172DEMO@HOT.COM', '2016-08-23', 0, 1, 761, NULL, NULL, NULL),
  (176, '487690173', 'CARRERA 26 A 2 # 173', '173DEMO@HOT.COM', '2016-08-23', 0, 1, 268, NULL, NULL, NULL),
  (177, '487690174', 'CARRERA 26 A 2 # 174', '174DEMO@HOT.COM', '2016-08-23', 0, 1, 482, NULL, NULL, NULL),
  (178, '487690175', 'CARRERA 26 A 2 # 175', '175DEMO@HOT.COM', '2016-08-23', 0, 2, 169, NULL, NULL, NULL),
  (179, '487690176', 'CARRERA 26 A 2 # 176', '176DEMO@HOT.COM', '2016-08-23', 0, 1, 82, NULL, NULL, NULL),
  (180, '487690177', 'CARRERA 26 A 2 # 177', '177DEMO@HOT.COM', '2016-08-23', 0, 2, 1435, NULL, NULL, NULL),
  (181, '487690178', 'CARRERA 26 A 2 # 178', '178DEMO@HOT.COM', '2016-08-23', 0, 2, 338, NULL, NULL, NULL),
  (182, '487690179', 'CARRERA 26 A 2 # 179', '179DEMO@HOT.COM', '2016-08-23', 0, 1, 939, NULL, NULL, NULL),
  (183, '487690180', 'CARRERA 26 A 2 # 180', '180DEMO@HOT.COM', '2016-08-23', 0, 1, 430, NULL, NULL, NULL),
  (184, '487690181', 'CARRERA 26 A 2 # 181', '181DEMO@HOT.COM', '2016-08-23', 0, 1, 215, NULL, NULL, NULL),
  (185, '487690182', 'CARRERA 26 A 2 # 182', '182DEMO@HOT.COM', '2016-08-23', 0, 2, 459, NULL, NULL, NULL),
  (186, '487690183', 'CARRERA 26 A 2 # 183', '183DEMO@HOT.COM', '2016-08-23', 0, 1, 703, NULL, NULL, NULL),
  (187, '487690184', 'CARRERA 26 A 2 # 184', '184DEMO@HOT.COM', '2016-08-23', 0, 2, 873, NULL, NULL, NULL),
  (188, '487690185', 'CARRERA 26 A 2 # 185', '185DEMO@HOT.COM', '2016-08-23', 0, 1, 1903, NULL, NULL, NULL),
  (189, '487690186', 'CARRERA 26 A 2 # 186', '186DEMO@HOT.COM', '2016-08-23', 0, 2, 1353, NULL, NULL, NULL),
  (190, '487690187', 'CARRERA 26 A 2 # 187', '187DEMO@HOT.COM', '2016-08-23', 0, 2, 1956, NULL, NULL, NULL),
  (191, '487690188', 'CARRERA 26 A 2 # 188', '188DEMO@HOT.COM', '2016-08-23', 0, 1, 1440, NULL, NULL, NULL),
  (192, '487690189', 'CARRERA 26 A 2 # 189', '189DEMO@HOT.COM', '2016-08-23', 0, 2, 1379, NULL, NULL, NULL),
  (193, '487690190', 'CARRERA 26 A 2 # 190', '190DEMO@HOT.COM', '2016-08-23', 0, 2, 1418, NULL, NULL, NULL),
  (194, '487690191', 'CARRERA 26 A 2 # 191', '191DEMO@HOT.COM', '2016-08-23', 0, 2, 1223, NULL, NULL, NULL),
  (195, '487690192', 'CARRERA 26 A 2 # 192', '192DEMO@HOT.COM', '2016-08-23', 0, 1, 1544, NULL, NULL, NULL),
  (196, '487690193', 'CARRERA 26 A 2 # 193', '193DEMO@HOT.COM', '2016-08-23', 0, 2, 1525, NULL, NULL, NULL),
  (197, '487690194', 'CARRERA 26 A 2 # 194', '194DEMO@HOT.COM', '2016-08-23', 0, 1, 1100, NULL, NULL, NULL),
  (198, '487690195', 'CARRERA 26 A 2 # 195', '195DEMO@HOT.COM', '2016-08-23', 0, 2, 760, NULL, NULL, NULL),
  (199, '487690196', 'CARRERA 26 A 2 # 196', '196DEMO@HOT.COM', '2016-08-23', 0, 1, 899, NULL, NULL, NULL),
  (200, '487690197', 'CARRERA 26 A 2 # 197', '197DEMO@HOT.COM', '2016-08-23', 0, 2, 1172, NULL, NULL, NULL),
  (201, '487690198', 'CARRERA 26 A 2 # 198', '198DEMO@HOT.COM', '2016-08-23', 0, 2, 1262, NULL, NULL, NULL),
  (202, '487690199', 'CARRERA 26 A 2 # 199', '199DEMO@HOT.COM', '2016-08-23', 0, 2, 937, NULL, NULL, NULL),
  (203, '487690200', 'CARRERA 26 A 2 # 200', '200DEMO@HOT.COM', '2016-08-23', 0, 2, 58, NULL, NULL, NULL),
  (204, '487690201', 'CARRERA 26 A 2 # 201', '201DEMO@HOT.COM', '2016-08-23', 0, 2, 520, NULL, NULL, NULL),
  (205, '487690202', 'CARRERA 26 A 2 # 202', '202DEMO@HOT.COM', '2016-08-23', 0, 1, 339, NULL, NULL, NULL),
  (206, '487690203', 'CARRERA 26 A 2 # 203', '203DEMO@HOT.COM', '2016-08-23', 0, 1, 1176, NULL, NULL, NULL),
  (207, '487690204', 'CARRERA 26 A 2 # 204', '204DEMO@HOT.COM', '2016-08-23', 0, 1, 1954, NULL, NULL, NULL),
  (208, '487690205', 'CARRERA 26 A 2 # 205', '205DEMO@HOT.COM', '2016-08-23', 0, 2, 1847, NULL, NULL, NULL),
  (209, '487690206', 'CARRERA 26 A 2 # 206', '206DEMO@HOT.COM', '2016-08-23', 0, 1, 991, NULL, NULL, NULL),
  (210, '487690207', 'CARRERA 26 A 2 # 207', '207DEMO@HOT.COM', '2016-08-23', 0, 1, 1257, NULL, NULL, NULL),
  (211, '487690208', 'CARRERA 26 A 2 # 208', '208DEMO@HOT.COM', '2016-08-23', 0, 2, 1568, NULL, NULL, NULL),
  (212, '487690209', 'CARRERA 26 A 2 # 209', '209DEMO@HOT.COM', '2016-08-23', 0, 2, 1129, NULL, NULL, NULL),
  (213, '487690210', 'CARRERA 26 A 2 # 210', '210DEMO@HOT.COM', '2016-08-23', 0, 2, 1433, NULL, NULL, NULL),
  (214, '487690211', 'CARRERA 26 A 2 # 211', '211DEMO@HOT.COM', '2016-08-23', 0, 2, 186, NULL, NULL, NULL),
  (215, '487690212', 'CARRERA 26 A 2 # 212', '212DEMO@HOT.COM', '2016-08-23', 0, 2, 375, NULL, NULL, NULL),
  (216, '487690213', 'CARRERA 26 A 2 # 213', '213DEMO@HOT.COM', '2016-08-23', 0, 2, 1743, NULL, NULL, NULL),
  (217, '487690214', 'CARRERA 26 A 2 # 214', '214DEMO@HOT.COM', '2016-08-23', 0, 1, 1499, NULL, NULL, NULL),
  (218, '487690215', 'CARRERA 26 A 2 # 215', '215DEMO@HOT.COM', '2016-08-23', 0, 2, 1548, NULL, NULL, NULL),
  (219, '487690216', 'CARRERA 26 A 2 # 216', '216DEMO@HOT.COM', '2016-08-23', 0, 1, 710, NULL, NULL, NULL),
  (220, '487690217', 'CARRERA 26 A 2 # 217', '217DEMO@HOT.COM', '2016-08-23', 0, 2, 917, NULL, NULL, NULL),
  (221, '487690218', 'CARRERA 26 A 2 # 218', '218DEMO@HOT.COM', '2016-08-23', 0, 1, 839, NULL, NULL, NULL),
  (222, '487690219', 'CARRERA 26 A 2 # 219', '219DEMO@HOT.COM', '2016-08-23', 0, 1, 328, NULL, NULL, NULL),
  (223, '487690220', 'CARRERA 26 A 2 # 220', '220DEMO@HOT.COM', '2016-08-23', 0, 2, 1568, NULL, NULL, NULL),
  (224, '487690221', 'CARRERA 26 A 2 # 221', '221DEMO@HOT.COM', '2016-08-23', 0, 1, 1895, NULL, NULL, NULL),
  (225, '487690222', 'CARRERA 26 A 2 # 222', '222DEMO@HOT.COM', '2016-08-23', 0, 1, 1779, NULL, NULL, NULL),
  (226, '487690223', 'CARRERA 26 A 2 # 223', '223DEMO@HOT.COM', '2016-08-23', 0, 2, 1681, NULL, NULL, NULL),
  (227, '487690224', 'CARRERA 26 A 2 # 224', '224DEMO@HOT.COM', '2016-08-23', 0, 1, 911, NULL, NULL, NULL),
  (228, '487690225', 'CARRERA 26 A 2 # 225', '225DEMO@HOT.COM', '2016-08-23', 0, 2, 601, NULL, NULL, NULL),
  (229, '487690226', 'CARRERA 26 A 2 # 226', '226DEMO@HOT.COM', '2016-08-23', 0, 1, 1876, NULL, NULL, NULL),
  (230, '487690227', 'CARRERA 26 A 2 # 227', '227DEMO@HOT.COM', '2016-08-23', 0, 2, 778, NULL, NULL, NULL),
  (231, '487690228', 'CARRERA 26 A 2 # 228', '228DEMO@HOT.COM', '2016-08-23', 0, 1, 1857, NULL, NULL, NULL),
  (232, '487690229', 'CARRERA 26 A 2 # 229', '229DEMO@HOT.COM', '2016-08-23', 0, 1, 1032, NULL, NULL, NULL),
  (233, '487690230', 'CARRERA 26 A 2 # 230', '230DEMO@HOT.COM', '2016-08-23', 0, 1, 1044, NULL, NULL, NULL),
  (234, '487690231', 'CARRERA 26 A 2 # 231', '231DEMO@HOT.COM', '2016-08-23', 0, 2, 50, NULL, NULL, NULL),
  (235, '487690232', 'CARRERA 26 A 2 # 232', '232DEMO@HOT.COM', '2016-08-23', 0, 1, 1475, NULL, NULL, NULL),
  (236, '487690233', 'CARRERA 26 A 2 # 233', '233DEMO@HOT.COM', '2016-08-23', 0, 1, 1008, NULL, NULL, NULL),
  (237, '487690234', 'CARRERA 26 A 2 # 234', '234DEMO@HOT.COM', '2016-08-23', 0, 2, 358, NULL, NULL, NULL),
  (238, '487690235', 'CARRERA 26 A 2 # 235', '235DEMO@HOT.COM', '2016-08-23', 0, 1, 848, NULL, NULL, NULL),
  (239, '487690236', 'CARRERA 26 A 2 # 236', '236DEMO@HOT.COM', '2016-08-23', 0, 1, 1287, NULL, NULL, NULL),
  (240, '487690237', 'CARRERA 26 A 2 # 237', '237DEMO@HOT.COM', '2016-08-23', 0, 1, 713, NULL, NULL, NULL),
  (241, '487690238', 'CARRERA 26 A 2 # 238', '238DEMO@HOT.COM', '2016-08-23', 0, 2, 468, NULL, NULL, NULL),
  (242, '487690239', 'CARRERA 26 A 2 # 239', '239DEMO@HOT.COM', '2016-08-23', 0, 2, 1882, NULL, NULL, NULL),
  (243, '487690240', 'CARRERA 26 A 2 # 240', '240DEMO@HOT.COM', '2016-08-23', 0, 2, 1515, NULL, NULL, NULL),
  (244, '487690241', 'CARRERA 26 A 2 # 241', '241DEMO@HOT.COM', '2016-08-23', 0, 1, 837, NULL, NULL, NULL),
  (245, '487690242', 'CARRERA 26 A 2 # 242', '242DEMO@HOT.COM', '2016-08-23', 0, 1, 1885, NULL, NULL, NULL),
  (246, '487690243', 'CARRERA 26 A 2 # 243', '243DEMO@HOT.COM', '2016-08-23', 0, 2, 92, NULL, NULL, NULL),
  (247, '487690244', 'CARRERA 26 A 2 # 244', '244DEMO@HOT.COM', '2016-08-23', 0, 1, 1528, NULL, NULL, NULL),
  (248, '487690245', 'CARRERA 26 A 2 # 245', '245DEMO@HOT.COM', '2016-08-23', 0, 1, 1746, NULL, NULL, NULL),
  (249, '487690246', 'CARRERA 26 A 2 # 246', '246DEMO@HOT.COM', '2016-08-23', 0, 2, 461, NULL, NULL, NULL),
  (250, '487690247', 'CARRERA 26 A 2 # 247', '247DEMO@HOT.COM', '2016-08-23', 0, 2, 600, NULL, NULL, NULL),
  (251, '487690248', 'CARRERA 26 A 2 # 248', '248DEMO@HOT.COM', '2016-08-23', 0, 2, 426, NULL, NULL, NULL),
  (252, '487690249', 'CARRERA 26 A 2 # 249', '249DEMO@HOT.COM', '2016-08-23', 0, 1, 1320, NULL, NULL, NULL),
  (253, '487690250', 'CARRERA 26 A 2 # 250', '250DEMO@HOT.COM', '2016-08-23', 0, 2, 410, NULL, NULL, NULL),
  (254, '487690251', 'CARRERA 26 A 2 # 251', '251DEMO@HOT.COM', '2016-08-23', 0, 1, 21, NULL, NULL, NULL),
  (255, '487690252', 'CARRERA 26 A 2 # 252', '252DEMO@HOT.COM', '2016-08-23', 0, 1, 1264, NULL, NULL, NULL),
  (256, '487690253', 'CARRERA 26 A 2 # 253', '253DEMO@HOT.COM', '2016-08-23', 0, 2, 669, NULL, NULL, NULL),
  (257, '487690254', 'CARRERA 26 A 2 # 254', '254DEMO@HOT.COM', '2016-08-23', 0, 1, 1851, NULL, NULL, NULL),
  (258, '487690255', 'CARRERA 26 A 2 # 255', '255DEMO@HOT.COM', '2016-08-23', 0, 2, 268, NULL, NULL, NULL),
  (259, '487690256', 'CARRERA 26 A 2 # 256', '256DEMO@HOT.COM', '2016-08-23', 0, 2, 810, NULL, NULL, NULL),
  (260, '487690257', 'CARRERA 26 A 2 # 257', '257DEMO@HOT.COM', '2016-08-23', 0, 2, 1333, NULL, NULL, NULL),
  (261, '487690258', 'CARRERA 26 A 2 # 258', '258DEMO@HOT.COM', '2016-08-23', 0, 2, 687, NULL, NULL, NULL),
  (262, '487690259', 'CARRERA 26 A 2 # 259', '259DEMO@HOT.COM', '2016-08-23', 0, 2, 1233, NULL, NULL, NULL),
  (263, '487690260', 'CARRERA 26 A 2 # 260', '260DEMO@HOT.COM', '2016-08-23', 0, 2, 1212, NULL, NULL, NULL),
  (264, '487690261', 'CARRERA 26 A 2 # 261', '261DEMO@HOT.COM', '2016-08-23', 0, 1, 1619, NULL, NULL, NULL),
  (265, '487690262', 'CARRERA 26 A 2 # 262', '262DEMO@HOT.COM', '2016-08-23', 0, 2, 310, NULL, NULL, NULL),
  (266, '487690263', 'CARRERA 26 A 2 # 263', '263DEMO@HOT.COM', '2016-08-23', 0, 1, 1234, NULL, NULL, NULL),
  (267, '487690264', 'CARRERA 26 A 2 # 264', '264DEMO@HOT.COM', '2016-08-23', 0, 1, 1956, NULL, NULL, NULL),
  (268, '487690265', 'CARRERA 26 A 2 # 265', '265DEMO@HOT.COM', '2016-08-23', 0, 1, 1504, NULL, NULL, NULL),
  (269, '487690266', 'CARRERA 26 A 2 # 266', '266DEMO@HOT.COM', '2016-08-23', 0, 2, 852, NULL, NULL, NULL),
  (270, '487690267', 'CARRERA 26 A 2 # 267', '267DEMO@HOT.COM', '2016-08-23', 0, 2, 308, NULL, NULL, NULL),
  (271, '487690268', 'CARRERA 26 A 2 # 268', '268DEMO@HOT.COM', '2016-08-23', 0, 1, 762, NULL, NULL, NULL),
  (272, '487690269', 'CARRERA 26 A 2 # 269', '269DEMO@HOT.COM', '2016-08-23', 0, 1, 1282, NULL, NULL, NULL),
  (273, '487690270', 'CARRERA 26 A 2 # 270', '270DEMO@HOT.COM', '2016-08-23', 0, 2, 1651, NULL, NULL, NULL),
  (274, '487690271', 'CARRERA 26 A 2 # 271', '271DEMO@HOT.COM', '2016-08-23', 0, 1, 1474, NULL, NULL, NULL),
  (275, '487690272', 'CARRERA 26 A 2 # 272', '272DEMO@HOT.COM', '2016-08-23', 0, 1, 1474, NULL, NULL, NULL),
  (276, '487690273', 'CARRERA 26 A 2 # 273', '273DEMO@HOT.COM', '2016-08-23', 0, 1, 350, NULL, NULL, NULL),
  (277, '487690274', 'CARRERA 26 A 2 # 274', '274DEMO@HOT.COM', '2016-08-23', 0, 1, 719, NULL, NULL, NULL),
  (278, '487690275', 'CARRERA 26 A 2 # 275', '275DEMO@HOT.COM', '2016-08-23', 0, 1, 1342, NULL, NULL, NULL),
  (279, '487690276', 'CARRERA 26 A 2 # 276', '276DEMO@HOT.COM', '2016-08-23', 0, 1, 413, NULL, NULL, NULL),
  (280, '487690277', 'CARRERA 26 A 2 # 277', '277DEMO@HOT.COM', '2016-08-23', 0, 1, 1611, NULL, NULL, NULL),
  (281, '487690278', 'CARRERA 26 A 2 # 278', '278DEMO@HOT.COM', '2016-08-23', 0, 1, 1255, NULL, NULL, NULL),
  (282, '487690279', 'CARRERA 26 A 2 # 279', '279DEMO@HOT.COM', '2016-08-23', 0, 1, 787, NULL, NULL, NULL),
  (283, '487690280', 'CARRERA 26 A 2 # 280', '280DEMO@HOT.COM', '2016-08-23', 0, 2, 754, NULL, NULL, NULL),
  (284, '487690281', 'CARRERA 26 A 2 # 281', '281DEMO@HOT.COM', '2016-08-23', 0, 1, 1042, NULL, NULL, NULL),
  (285, '487690282', 'CARRERA 26 A 2 # 282', '282DEMO@HOT.COM', '2016-08-23', 0, 1, 1359, NULL, NULL, NULL),
  (286, '487690283', 'CARRERA 26 A 2 # 283', '283DEMO@HOT.COM', '2016-08-23', 0, 2, 139, NULL, NULL, NULL),
  (287, '487690284', 'CARRERA 26 A 2 # 284', '284DEMO@HOT.COM', '2016-08-23', 0, 2, 1695, NULL, NULL, NULL),
  (288, '487690285', 'CARRERA 26 A 2 # 285', '285DEMO@HOT.COM', '2016-08-23', 0, 1, 994, NULL, NULL, NULL),
  (289, '487690286', 'CARRERA 26 A 2 # 286', '286DEMO@HOT.COM', '2016-08-23', 0, 2, 291, NULL, NULL, NULL),
  (290, '487690287', 'CARRERA 26 A 2 # 287', '287DEMO@HOT.COM', '2016-08-23', 0, 2, 868, NULL, NULL, NULL),
  (291, '487690288', 'CARRERA 26 A 2 # 288', '288DEMO@HOT.COM', '2016-08-23', 0, 1, 405, NULL, NULL, NULL),
  (292, '487690289', 'CARRERA 26 A 2 # 289', '289DEMO@HOT.COM', '2016-08-23', 0, 2, 1, NULL, NULL, NULL),
  (293, '487690290', 'CARRERA 26 A 2 # 290', '290DEMO@HOT.COM', '2016-08-23', 0, 1, 656, NULL, NULL, NULL),
  (294, '487690291', 'CARRERA 26 A 2 # 291', '291DEMO@HOT.COM', '2016-08-23', 0, 2, 1625, NULL, NULL, NULL),
  (295, '487690292', 'CARRERA 26 A 2 # 292', '292DEMO@HOT.COM', '2016-08-23', 0, 2, 381, NULL, NULL, NULL),
  (296, '487690293', 'CARRERA 26 A 2 # 293', '293DEMO@HOT.COM', '2016-08-23', 0, 2, 1123, NULL, NULL, NULL),
  (297, '487690294', 'CARRERA 26 A 2 # 294', '294DEMO@HOT.COM', '2016-08-23', 0, 1, 980, NULL, NULL, NULL),
  (298, '487690295', 'CARRERA 26 A 2 # 295', '295DEMO@HOT.COM', '2016-08-23', 0, 1, 1791, NULL, NULL, NULL),
  (299, '487690296', 'CARRERA 26 A 2 # 296', '296DEMO@HOT.COM', '2016-08-23', 0, 1, 1837, NULL, NULL, NULL),
  (300, '487690297', 'CARRERA 26 A 2 # 297', '297DEMO@HOT.COM', '2016-08-23', 0, 2, 1578, NULL, NULL, NULL),
  (301, '487690298', 'CARRERA 26 A 2 # 298', '298DEMO@HOT.COM', '2016-08-23', 0, 2, 1451, NULL, NULL, NULL),
  (302, '487690299', 'CARRERA 26 A 2 # 299', '299DEMO@HOT.COM', '2016-08-23', 0, 2, 429, NULL, NULL, NULL),
  (303, '487690300', 'CARRERA 26 A 2 # 300', '300DEMO@HOT.COM', '2016-08-23', 0, 2, 648, NULL, NULL, NULL),
  (304, '487690301', 'CARRERA 26 A 2 # 301', '301DEMO@HOT.COM', '2016-08-23', 0, 1, 1883, NULL, NULL, NULL),
  (305, '487690302', 'CARRERA 26 A 2 # 302', '302DEMO@HOT.COM', '2016-08-23', 0, 2, 1147, NULL, NULL, NULL),
  (306, '487690303', 'CARRERA 26 A 2 # 303', '303DEMO@HOT.COM', '2016-08-23', 0, 1, 565, NULL, NULL, NULL),
  (307, '487690304', 'CARRERA 26 A 2 # 304', '304DEMO@HOT.COM', '2016-08-23', 0, 1, 267, NULL, NULL, NULL),
  (308, '487690305', 'CARRERA 26 A 2 # 305', '305DEMO@HOT.COM', '2016-08-23', 0, 1, 544, NULL, NULL, NULL),
  (309, '487690306', 'CARRERA 26 A 2 # 306', '306DEMO@HOT.COM', '2016-08-23', 0, 1, 503, NULL, NULL, NULL),
  (310, '487690307', 'CARRERA 26 A 2 # 307', '307DEMO@HOT.COM', '2016-08-23', 0, 1, 1559, NULL, NULL, NULL),
  (311, '487690308', 'CARRERA 26 A 2 # 308', '308DEMO@HOT.COM', '2016-08-23', 0, 1, 619, NULL, NULL, NULL),
  (312, '487690309', 'CARRERA 26 A 2 # 309', '309DEMO@HOT.COM', '2016-08-23', 0, 1, 230, NULL, NULL, NULL),
  (313, '487690310', 'CARRERA 26 A 2 # 310', '310DEMO@HOT.COM', '2016-08-23', 0, 1, 1337, NULL, NULL, NULL),
  (314, '487690311', 'CARRERA 26 A 2 # 311', '311DEMO@HOT.COM', '2016-08-23', 0, 2, 827, NULL, NULL, NULL),
  (315, '487690312', 'CARRERA 26 A 2 # 312', '312DEMO@HOT.COM', '2016-08-23', 0, 2, 953, NULL, NULL, NULL),
  (316, '487690313', 'CARRERA 26 A 2 # 313', '313DEMO@HOT.COM', '2016-08-23', 0, 1, 48, NULL, NULL, NULL),
  (317, '487690314', 'CARRERA 26 A 2 # 314', '314DEMO@HOT.COM', '2016-08-23', 0, 2, 849, NULL, NULL, NULL),
  (318, '487690315', 'CARRERA 26 A 2 # 315', '315DEMO@HOT.COM', '2016-08-23', 0, 1, 620, NULL, NULL, NULL),
  (319, '487690316', 'CARRERA 26 A 2 # 316', '316DEMO@HOT.COM', '2016-08-23', 0, 1, 300, NULL, NULL, NULL),
  (320, '487690317', 'CARRERA 26 A 2 # 317', '317DEMO@HOT.COM', '2016-08-23', 0, 2, 1108, NULL, NULL, NULL),
  (321, '487690318', 'CARRERA 26 A 2 # 318', '318DEMO@HOT.COM', '2016-08-23', 0, 2, 1175, NULL, NULL, NULL),
  (322, '487690319', 'CARRERA 26 A 2 # 319', '319DEMO@HOT.COM', '2016-08-23', 0, 2, 1657, NULL, NULL, NULL),
  (323, '487690320', 'CARRERA 26 A 2 # 320', '320DEMO@HOT.COM', '2016-08-23', 0, 2, 227, NULL, NULL, NULL),
  (324, '487690321', 'CARRERA 26 A 2 # 321', '321DEMO@HOT.COM', '2016-08-23', 0, 2, 1877, NULL, NULL, NULL),
  (325, '487690322', 'CARRERA 26 A 2 # 322', '322DEMO@HOT.COM', '2016-08-23', 0, 2, 671, NULL, NULL, NULL),
  (326, '487690323', 'CARRERA 26 A 2 # 323', '323DEMO@HOT.COM', '2016-08-23', 0, 1, 117, NULL, NULL, NULL),
  (327, '487690324', 'CARRERA 26 A 2 # 324', '324DEMO@HOT.COM', '2016-08-23', 0, 1, 164, NULL, NULL, NULL),
  (328, '487690325', 'CARRERA 26 A 2 # 325', '325DEMO@HOT.COM', '2016-08-23', 0, 1, 1504, NULL, NULL, NULL),
  (329, '487690326', 'CARRERA 26 A 2 # 326', '326DEMO@HOT.COM', '2016-08-23', 0, 2, 1782, NULL, NULL, NULL),
  (330, '487690327', 'CARRERA 26 A 2 # 327', '327DEMO@HOT.COM', '2016-08-23', 0, 1, 167, NULL, NULL, NULL),
  (331, '487690328', 'CARRERA 26 A 2 # 328', '328DEMO@HOT.COM', '2016-08-23', 0, 1, 1393, NULL, NULL, NULL),
  (332, '487690329', 'CARRERA 26 A 2 # 329', '329DEMO@HOT.COM', '2016-08-23', 0, 2, 115, NULL, NULL, NULL),
  (333, '487690330', 'CARRERA 26 A 2 # 330', '330DEMO@HOT.COM', '2016-08-23', 0, 1, 656, NULL, NULL, NULL),
  (334, '487690331', 'CARRERA 26 A 2 # 331', '331DEMO@HOT.COM', '2016-08-23', 0, 1, 969, NULL, NULL, NULL),
  (335, '487690332', 'CARRERA 26 A 2 # 332', '332DEMO@HOT.COM', '2016-08-23', 0, 2, 1025, NULL, NULL, NULL),
  (336, '487690333', 'CARRERA 26 A 2 # 333', '333DEMO@HOT.COM', '2016-08-23', 0, 2, 1733, NULL, NULL, NULL),
  (337, '487690334', 'CARRERA 26 A 2 # 334', '334DEMO@HOT.COM', '2016-08-23', 0, 1, 1489, NULL, NULL, NULL),
  (338, '487690335', 'CARRERA 26 A 2 # 335', '335DEMO@HOT.COM', '2016-08-23', 0, 2, 579, NULL, NULL, NULL),
  (339, '487690336', 'CARRERA 26 A 2 # 336', '336DEMO@HOT.COM', '2016-08-23', 0, 2, 502, NULL, NULL, NULL),
  (340, '487690337', 'CARRERA 26 A 2 # 337', '337DEMO@HOT.COM', '2016-08-23', 0, 1, 1869, NULL, NULL, NULL),
  (341, '487690338', 'CARRERA 26 A 2 # 338', '338DEMO@HOT.COM', '2016-08-23', 0, 2, 74, NULL, NULL, NULL),
  (342, '487690339', 'CARRERA 26 A 2 # 339', '339DEMO@HOT.COM', '2016-08-23', 0, 2, 811, NULL, NULL, NULL),
  (343, '487690340', 'CARRERA 26 A 2 # 340', '340DEMO@HOT.COM', '2016-08-23', 0, 1, 67, NULL, NULL, NULL),
  (344, '487690341', 'CARRERA 26 A 2 # 341', '341DEMO@HOT.COM', '2016-08-23', 0, 1, 1263, NULL, NULL, NULL),
  (345, '487690342', 'CARRERA 26 A 2 # 342', '342DEMO@HOT.COM', '2016-08-23', 0, 2, 677, NULL, NULL, NULL),
  (346, '487690343', 'CARRERA 26 A 2 # 343', '343DEMO@HOT.COM', '2016-08-23', 0, 2, 20, NULL, NULL, NULL),
  (347, '487690344', 'CARRERA 26 A 2 # 344', '344DEMO@HOT.COM', '2016-08-23', 0, 1, 316, NULL, NULL, NULL),
  (348, '487690345', 'CARRERA 26 A 2 # 345', '345DEMO@HOT.COM', '2016-08-23', 0, 1, 1429, NULL, NULL, NULL),
  (349, '487690346', 'CARRERA 26 A 2 # 346', '346DEMO@HOT.COM', '2016-08-23', 0, 1, 1072, NULL, NULL, NULL),
  (350, '487690347', 'CARRERA 26 A 2 # 347', '347DEMO@HOT.COM', '2016-08-23', 0, 2, 566, NULL, NULL, NULL),
  (351, '487690348', 'CARRERA 26 A 2 # 348', '348DEMO@HOT.COM', '2016-08-23', 0, 2, 967, NULL, NULL, NULL),
  (352, '487690349', 'CARRERA 26 A 2 # 349', '349DEMO@HOT.COM', '2016-08-23', 0, 1, 1116, NULL, NULL, NULL),
  (353, '487690350', 'CARRERA 26 A 2 # 350', '350DEMO@HOT.COM', '2016-08-23', 0, 1, 1153, NULL, NULL, NULL),
  (354, '487690351', 'CARRERA 26 A 2 # 351', '351DEMO@HOT.COM', '2016-08-23', 0, 2, 865, NULL, NULL, NULL),
  (355, '487690352', 'CARRERA 26 A 2 # 352', '352DEMO@HOT.COM', '2016-08-23', 0, 1, 751, NULL, NULL, NULL),
  (356, '487690353', 'CARRERA 26 A 2 # 353', '353DEMO@HOT.COM', '2016-08-23', 0, 1, 361, NULL, NULL, NULL),
  (357, '487690354', 'CARRERA 26 A 2 # 354', '354DEMO@HOT.COM', '2016-08-23', 0, 1, 219, NULL, NULL, NULL),
  (358, '487690355', 'CARRERA 26 A 2 # 355', '355DEMO@HOT.COM', '2016-08-23', 0, 2, 838, NULL, NULL, NULL),
  (359, '487690356', 'CARRERA 26 A 2 # 356', '356DEMO@HOT.COM', '2016-08-23', 0, 2, 139, NULL, NULL, NULL),
  (360, '487690357', 'CARRERA 26 A 2 # 357', '357DEMO@HOT.COM', '2016-08-23', 0, 2, 163, NULL, NULL, NULL),
  (361, '487690358', 'CARRERA 26 A 2 # 358', '358DEMO@HOT.COM', '2016-08-23', 0, 1, 1595, NULL, NULL, NULL),
  (362, '487690359', 'CARRERA 26 A 2 # 359', '359DEMO@HOT.COM', '2016-08-23', 0, 1, 1846, NULL, NULL, NULL),
  (363, '487690360', 'CARRERA 26 A 2 # 360', '360DEMO@HOT.COM', '2016-08-23', 0, 2, 1901, NULL, NULL, NULL),
  (364, '487690361', 'CARRERA 26 A 2 # 361', '361DEMO@HOT.COM', '2016-08-23', 0, 2, 1402, NULL, NULL, NULL),
  (365, '487690362', 'CARRERA 26 A 2 # 362', '362DEMO@HOT.COM', '2016-08-23', 0, 2, 31, NULL, NULL, NULL),
  (366, '487690363', 'CARRERA 26 A 2 # 363', '363DEMO@HOT.COM', '2016-08-23', 0, 2, 55, NULL, NULL, NULL),
  (367, '487690364', 'CARRERA 26 A 2 # 364', '364DEMO@HOT.COM', '2016-08-23', 0, 1, 112, NULL, NULL, NULL),
  (368, '487690365', 'CARRERA 26 A 2 # 365', '365DEMO@HOT.COM', '2016-08-23', 0, 1, 578, NULL, NULL, NULL),
  (369, '487690366', 'CARRERA 26 A 2 # 366', '366DEMO@HOT.COM', '2016-08-23', 0, 2, 153, NULL, NULL, NULL),
  (370, '487690367', 'CARRERA 26 A 2 # 367', '367DEMO@HOT.COM', '2016-08-23', 0, 1, 1231, NULL, NULL, NULL),
  (371, '487690368', 'CARRERA 26 A 2 # 368', '368DEMO@HOT.COM', '2016-08-23', 0, 1, 521, NULL, NULL, NULL),
  (372, '487690369', 'CARRERA 26 A 2 # 369', '369DEMO@HOT.COM', '2016-08-23', 0, 2, 1621, NULL, NULL, NULL),
  (373, '487690370', 'CARRERA 26 A 2 # 370', '370DEMO@HOT.COM', '2016-08-23', 0, 1, 581, NULL, NULL, NULL),
  (374, '487690371', 'CARRERA 26 A 2 # 371', '371DEMO@HOT.COM', '2016-08-23', 0, 2, 699, NULL, NULL, NULL),
  (375, '487690372', 'CARRERA 26 A 2 # 372', '372DEMO@HOT.COM', '2016-08-23', 0, 2, 416, NULL, NULL, NULL),
  (376, '487690373', 'CARRERA 26 A 2 # 373', '373DEMO@HOT.COM', '2016-08-23', 0, 1, 878, NULL, NULL, NULL),
  (377, '487690374', 'CARRERA 26 A 2 # 374', '374DEMO@HOT.COM', '2016-08-23', 0, 1, 349, NULL, NULL, NULL),
  (378, '487690375', 'CARRERA 26 A 2 # 375', '375DEMO@HOT.COM', '2016-08-23', 0, 2, 663, NULL, NULL, NULL),
  (379, '487690376', 'CARRERA 26 A 2 # 376', '376DEMO@HOT.COM', '2016-08-23', 0, 2, 1280, NULL, NULL, NULL),
  (380, '487690377', 'CARRERA 26 A 2 # 377', '377DEMO@HOT.COM', '2016-08-23', 0, 1, 1294, NULL, NULL, NULL),
  (381, '487690378', 'CARRERA 26 A 2 # 378', '378DEMO@HOT.COM', '2016-08-23', 0, 2, 1316, NULL, NULL, NULL),
  (382, '487690379', 'CARRERA 26 A 2 # 379', '379DEMO@HOT.COM', '2016-08-23', 0, 2, 1426, NULL, NULL, NULL),
  (383, '487690380', 'CARRERA 26 A 2 # 380', '380DEMO@HOT.COM', '2016-08-23', 0, 1, 365, NULL, NULL, NULL),
  (384, '487690381', 'CARRERA 26 A 2 # 381', '381DEMO@HOT.COM', '2016-08-23', 0, 2, 1778, NULL, NULL, NULL),
  (385, '487690382', 'CARRERA 26 A 2 # 382', '382DEMO@HOT.COM', '2016-08-23', 0, 1, 1752, NULL, NULL, NULL),
  (386, '487690383', 'CARRERA 26 A 2 # 383', '383DEMO@HOT.COM', '2016-08-23', 0, 1, 317, NULL, NULL, NULL),
  (387, '487690384', 'CARRERA 26 A 2 # 384', '384DEMO@HOT.COM', '2016-08-23', 0, 1, 222, NULL, NULL, NULL),
  (388, '487690385', 'CARRERA 26 A 2 # 385', '385DEMO@HOT.COM', '2016-08-23', 0, 1, 21, NULL, NULL, NULL),
  (389, '487690386', 'CARRERA 26 A 2 # 386', '386DEMO@HOT.COM', '2016-08-23', 0, 2, 1344, NULL, NULL, NULL),
  (390, '487690387', 'CARRERA 26 A 2 # 387', '387DEMO@HOT.COM', '2016-08-23', 0, 2, 964, NULL, NULL, NULL),
  (391, '487690388', 'CARRERA 26 A 2 # 388', '388DEMO@HOT.COM', '2016-08-23', 0, 2, 765, NULL, NULL, NULL),
  (392, '487690389', 'CARRERA 26 A 2 # 389', '389DEMO@HOT.COM', '2016-08-23', 0, 2, 41, NULL, NULL, NULL),
  (393, '487690390', 'CARRERA 26 A 2 # 390', '390DEMO@HOT.COM', '2016-08-23', 0, 2, 1687, NULL, NULL, NULL),
  (394, '487690391', 'CARRERA 26 A 2 # 391', '391DEMO@HOT.COM', '2016-08-23', 0, 1, 1923, NULL, NULL, NULL),
  (395, '487690392', 'CARRERA 26 A 2 # 392', '392DEMO@HOT.COM', '2016-08-23', 0, 1, 1072, NULL, NULL, NULL),
  (396, '487690393', 'CARRERA 26 A 2 # 393', '393DEMO@HOT.COM', '2016-08-23', 0, 2, 191, NULL, NULL, NULL),
  (397, '487690394', 'CARRERA 26 A 2 # 394', '394DEMO@HOT.COM', '2016-08-23', 0, 1, 659, NULL, NULL, NULL),
  (398, '487690395', 'CARRERA 26 A 2 # 395', '395DEMO@HOT.COM', '2016-08-23', 0, 1, 668, NULL, NULL, NULL),
  (399, '487690396', 'CARRERA 26 A 2 # 396', '396DEMO@HOT.COM', '2016-08-23', 0, 1, 1285, NULL, NULL, NULL),
  (400, '487690397', 'CARRERA 26 A 2 # 397', '397DEMO@HOT.COM', '2016-08-23', 0, 2, 1967, NULL, NULL, NULL),
  (401, '487690398', 'CARRERA 26 A 2 # 398', '398DEMO@HOT.COM', '2016-08-23', 0, 2, 895, NULL, NULL, NULL),
  (402, '487690399', 'CARRERA 26 A 2 # 399', '399DEMO@HOT.COM', '2016-08-23', 0, 1, 641, NULL, NULL, NULL),
  (403, '487690400', 'CARRERA 26 A 2 # 400', '400DEMO@HOT.COM', '2016-08-23', 0, 2, 181, NULL, NULL, NULL),
  (404, '487690401', 'CARRERA 26 A 2 # 401', '401DEMO@HOT.COM', '2016-08-23', 0, 2, 1995, NULL, NULL, NULL),
  (405, '487690402', 'CARRERA 26 A 2 # 402', '402DEMO@HOT.COM', '2016-08-23', 0, 1, 28, NULL, NULL, NULL),
  (406, '487690403', 'CARRERA 26 A 2 # 403', '403DEMO@HOT.COM', '2016-08-23', 0, 1, 1794, NULL, NULL, NULL),
  (407, '487690404', 'CARRERA 26 A 2 # 404', '404DEMO@HOT.COM', '2016-08-23', 0, 1, 1041, NULL, NULL, NULL),
  (408, '487690405', 'CARRERA 26 A 2 # 405', '405DEMO@HOT.COM', '2016-08-23', 0, 2, 1284, NULL, NULL, NULL),
  (409, '487690406', 'CARRERA 26 A 2 # 406', '406DEMO@HOT.COM', '2016-08-23', 0, 2, 1014, NULL, NULL, NULL),
  (410, '487690407', 'CARRERA 26 A 2 # 407', '407DEMO@HOT.COM', '2016-08-23', 0, 2, 1181, NULL, NULL, NULL),
  (411, '487690408', 'CARRERA 26 A 2 # 408', '408DEMO@HOT.COM', '2016-08-23', 0, 1, 1367, NULL, NULL, NULL),
  (412, '487690409', 'CARRERA 26 A 2 # 409', '409DEMO@HOT.COM', '2016-08-23', 0, 1, 1815, NULL, NULL, NULL),
  (413, '487690410', 'CARRERA 26 A 2 # 410', '410DEMO@HOT.COM', '2016-08-23', 0, 1, 1360, NULL, NULL, NULL),
  (414, '487690411', 'CARRERA 26 A 2 # 411', '411DEMO@HOT.COM', '2016-08-23', 0, 1, 1783, NULL, NULL, NULL),
  (415, '487690412', 'CARRERA 26 A 2 # 412', '412DEMO@HOT.COM', '2016-08-23', 0, 2, 1711, NULL, NULL, NULL),
  (416, '487690413', 'CARRERA 26 A 2 # 413', '413DEMO@HOT.COM', '2016-08-23', 0, 2, 972, NULL, NULL, NULL),
  (417, '487690414', 'CARRERA 26 A 2 # 414', '414DEMO@HOT.COM', '2016-08-23', 0, 2, 1371, NULL, NULL, NULL),
  (418, '487690415', 'CARRERA 26 A 2 # 415', '415DEMO@HOT.COM', '2016-08-23', 0, 2, 782, NULL, NULL, NULL),
  (419, '487690416', 'CARRERA 26 A 2 # 416', '416DEMO@HOT.COM', '2016-08-23', 0, 2, 1370, NULL, NULL, NULL),
  (420, '487690417', 'CARRERA 26 A 2 # 417', '417DEMO@HOT.COM', '2016-08-23', 0, 1, 235, NULL, NULL, NULL),
  (421, '487690418', 'CARRERA 26 A 2 # 418', '418DEMO@HOT.COM', '2016-08-23', 0, 1, 1171, NULL, NULL, NULL),
  (422, '487690419', 'CARRERA 26 A 2 # 419', '419DEMO@HOT.COM', '2016-08-23', 0, 1, 687, NULL, NULL, NULL),
  (423, '487690420', 'CARRERA 26 A 2 # 420', '420DEMO@HOT.COM', '2016-08-23', 0, 1, 110, NULL, NULL, NULL),
  (424, '487690421', 'CARRERA 26 A 2 # 421', '421DEMO@HOT.COM', '2016-08-23', 0, 1, 1326, NULL, NULL, NULL),
  (425, '487690422', 'CARRERA 26 A 2 # 422', '422DEMO@HOT.COM', '2016-08-23', 0, 1, 1254, NULL, NULL, NULL),
  (426, '487690423', 'CARRERA 26 A 2 # 423', '423DEMO@HOT.COM', '2016-08-23', 0, 1, 1935, NULL, NULL, NULL),
  (427, '487690424', 'CARRERA 26 A 2 # 424', '424DEMO@HOT.COM', '2016-08-23', 0, 1, 1276, NULL, NULL, NULL),
  (428, '487690425', 'CARRERA 26 A 2 # 425', '425DEMO@HOT.COM', '2016-08-23', 0, 1, 954, NULL, NULL, NULL),
  (429, '487690426', 'CARRERA 26 A 2 # 426', '426DEMO@HOT.COM', '2016-08-23', 0, 1, 146, NULL, NULL, NULL),
  (430, '487690427', 'CARRERA 26 A 2 # 427', '427DEMO@HOT.COM', '2016-08-23', 0, 2, 119, NULL, NULL, NULL),
  (431, '487690428', 'CARRERA 26 A 2 # 428', '428DEMO@HOT.COM', '2016-08-23', 0, 2, 87, NULL, NULL, NULL),
  (432, '487690429', 'CARRERA 26 A 2 # 429', '429DEMO@HOT.COM', '2016-08-23', 0, 2, 1507, NULL, NULL, NULL),
  (433, '487690430', 'CARRERA 26 A 2 # 430', '430DEMO@HOT.COM', '2016-08-23', 0, 2, 814, NULL, NULL, NULL),
  (434, '487690431', 'CARRERA 26 A 2 # 431', '431DEMO@HOT.COM', '2016-08-23', 0, 1, 1277, NULL, NULL, NULL),
  (435, '487690432', 'CARRERA 26 A 2 # 432', '432DEMO@HOT.COM', '2016-08-23', 0, 1, 1894, NULL, NULL, NULL),
  (436, '487690433', 'CARRERA 26 A 2 # 433', '433DEMO@HOT.COM', '2016-08-23', 0, 1, 1861, NULL, NULL, NULL),
  (437, '487690434', 'CARRERA 26 A 2 # 434', '434DEMO@HOT.COM', '2016-08-23', 0, 2, 1654, NULL, NULL, NULL),
  (438, '487690435', 'CARRERA 26 A 2 # 435', '435DEMO@HOT.COM', '2016-08-23', 0, 1, 378, NULL, NULL, NULL),
  (439, '487690436', 'CARRERA 26 A 2 # 436', '436DEMO@HOT.COM', '2016-08-23', 0, 1, 1438, NULL, NULL, NULL),
  (440, '487690437', 'CARRERA 26 A 2 # 437', '437DEMO@HOT.COM', '2016-08-23', 0, 2, 1700, NULL, NULL, NULL),
  (441, '487690438', 'CARRERA 26 A 2 # 438', '438DEMO@HOT.COM', '2016-08-23', 0, 2, 59, NULL, NULL, NULL),
  (442, '487690439', 'CARRERA 26 A 2 # 439', '439DEMO@HOT.COM', '2016-08-23', 0, 1, 819, NULL, NULL, NULL),
  (443, '487690440', 'CARRERA 26 A 2 # 440', '440DEMO@HOT.COM', '2016-08-23', 0, 1, 1073, NULL, NULL, NULL),
  (444, '487690441', 'CARRERA 26 A 2 # 441', '441DEMO@HOT.COM', '2016-08-23', 0, 2, 703, NULL, NULL, NULL),
  (445, '487690442', 'CARRERA 26 A 2 # 442', '442DEMO@HOT.COM', '2016-08-23', 0, 1, 754, NULL, NULL, NULL),
  (446, '487690443', 'CARRERA 26 A 2 # 443', '443DEMO@HOT.COM', '2016-08-23', 0, 2, 717, NULL, NULL, NULL),
  (447, '487690444', 'CARRERA 26 A 2 # 444', '444DEMO@HOT.COM', '2016-08-23', 0, 1, 1118, NULL, NULL, NULL),
  (448, '487690445', 'CARRERA 26 A 2 # 445', '445DEMO@HOT.COM', '2016-08-23', 0, 1, 381, NULL, NULL, NULL),
  (449, '487690446', 'CARRERA 26 A 2 # 446', '446DEMO@HOT.COM', '2016-08-23', 0, 2, 600, NULL, NULL, NULL),
  (450, '487690447', 'CARRERA 26 A 2 # 447', '447DEMO@HOT.COM', '2016-08-23', 0, 2, 790, NULL, NULL, NULL),
  (451, '487690448', 'CARRERA 26 A 2 # 448', '448DEMO@HOT.COM', '2016-08-23', 0, 1, 789, NULL, NULL, NULL),
  (452, '487690449', 'CARRERA 26 A 2 # 449', '449DEMO@HOT.COM', '2016-08-23', 0, 2, 1865, NULL, NULL, NULL),
  (453, '487690450', 'CARRERA 26 A 2 # 450', '450DEMO@HOT.COM', '2016-08-23', 0, 1, 576, NULL, NULL, NULL),
  (454, '487690451', 'CARRERA 26 A 2 # 451', '451DEMO@HOT.COM', '2016-08-23', 0, 2, 1956, NULL, NULL, NULL),
  (455, '487690452', 'CARRERA 26 A 2 # 452', '452DEMO@HOT.COM', '2016-08-23', 0, 1, 908, NULL, NULL, NULL),
  (456, '487690453', 'CARRERA 26 A 2 # 453', '453DEMO@HOT.COM', '2016-08-23', 0, 2, 1021, NULL, NULL, NULL),
  (457, '487690454', 'CARRERA 26 A 2 # 454', '454DEMO@HOT.COM', '2016-08-23', 0, 1, 1967, NULL, NULL, NULL),
  (458, '487690455', 'CARRERA 26 A 2 # 455', '455DEMO@HOT.COM', '2016-08-23', 0, 2, 567, NULL, NULL, NULL),
  (459, '487690456', 'CARRERA 26 A 2 # 456', '456DEMO@HOT.COM', '2016-08-23', 0, 2, 1688, NULL, NULL, NULL),
  (460, '487690457', 'CARRERA 26 A 2 # 457', '457DEMO@HOT.COM', '2016-08-23', 0, 2, 1745, NULL, NULL, NULL),
  (461, '487690458', 'CARRERA 26 A 2 # 458', '458DEMO@HOT.COM', '2016-08-23', 0, 2, 408, NULL, NULL, NULL),
  (462, '487690459', 'CARRERA 26 A 2 # 459', '459DEMO@HOT.COM', '2016-08-23', 0, 2, 290, NULL, NULL, NULL),
  (463, '487690460', 'CARRERA 26 A 2 # 460', '460DEMO@HOT.COM', '2016-08-23', 0, 2, 1368, NULL, NULL, NULL),
  (464, '487690461', 'CARRERA 26 A 2 # 461', '461DEMO@HOT.COM', '2016-08-23', 0, 2, 1735, NULL, NULL, NULL),
  (465, '487690462', 'CARRERA 26 A 2 # 462', '462DEMO@HOT.COM', '2016-08-23', 0, 1, 529, NULL, NULL, NULL),
  (466, '487690463', 'CARRERA 26 A 2 # 463', '463DEMO@HOT.COM', '2016-08-23', 0, 2, 560, NULL, NULL, NULL),
  (467, '487690464', 'CARRERA 26 A 2 # 464', '464DEMO@HOT.COM', '2016-08-23', 0, 2, 204, NULL, NULL, NULL),
  (468, '487690465', 'CARRERA 26 A 2 # 465', '465DEMO@HOT.COM', '2016-08-23', 0, 1, 1442, NULL, NULL, NULL),
  (469, '487690466', 'CARRERA 26 A 2 # 466', '466DEMO@HOT.COM', '2016-08-23', 0, 1, 724, NULL, NULL, NULL),
  (470, '487690467', 'CARRERA 26 A 2 # 467', '467DEMO@HOT.COM', '2016-08-23', 0, 2, 1533, NULL, NULL, NULL),
  (471, '487690468', 'CARRERA 26 A 2 # 468', '468DEMO@HOT.COM', '2016-08-23', 0, 1, 684, NULL, NULL, NULL),
  (472, '487690469', 'CARRERA 26 A 2 # 469', '469DEMO@HOT.COM', '2016-08-23', 0, 1, 1508, NULL, NULL, NULL),
  (473, '487690470', 'CARRERA 26 A 2 # 470', '470DEMO@HOT.COM', '2016-08-23', 0, 1, 1169, NULL, NULL, NULL),
  (474, '487690471', 'CARRERA 26 A 2 # 471', '471DEMO@HOT.COM', '2016-08-23', 0, 1, 840, NULL, NULL, NULL),
  (475, '487690472', 'CARRERA 26 A 2 # 472', '472DEMO@HOT.COM', '2016-08-23', 0, 2, 1681, NULL, NULL, NULL),
  (476, '487690473', 'CARRERA 26 A 2 # 473', '473DEMO@HOT.COM', '2016-08-23', 0, 1, 1417, NULL, NULL, NULL),
  (477, '487690474', 'CARRERA 26 A 2 # 474', '474DEMO@HOT.COM', '2016-08-23', 0, 2, 106, NULL, NULL, NULL),
  (478, '487690475', 'CARRERA 26 A 2 # 475', '475DEMO@HOT.COM', '2016-08-23', 0, 2, 1091, NULL, NULL, NULL),
  (479, '487690476', 'CARRERA 26 A 2 # 476', '476DEMO@HOT.COM', '2016-08-23', 0, 1, 540, NULL, NULL, NULL),
  (480, '487690477', 'CARRERA 26 A 2 # 477', '477DEMO@HOT.COM', '2016-08-23', 0, 1, 1400, NULL, NULL, NULL),
  (481, '487690478', 'CARRERA 26 A 2 # 478', '478DEMO@HOT.COM', '2016-08-23', 0, 2, 611, NULL, NULL, NULL),
  (482, '487690479', 'CARRERA 26 A 2 # 479', '479DEMO@HOT.COM', '2016-08-23', 0, 2, 1071, NULL, NULL, NULL);
  INSERT INTO `persona` (`per_id`, `per_telefono`, `per_direccion`, `per_correo`, `per_fecha_nacimiento`, `per_estado`, `tip_cli_id`, `ciu_id`, `per_identificacion`, `per_nombres`, `per_apellidos`) VALUES
  (483, '487690480', 'CARRERA 26 A 2 # 480', '480DEMO@HOT.COM', '2016-08-23', 0, 2, 793, NULL, NULL, NULL),
  (484, '487690481', 'CARRERA 26 A 2 # 481', '481DEMO@HOT.COM', '2016-08-23', 0, 1, 959, NULL, NULL, NULL),
  (485, '487690482', 'CARRERA 26 A 2 # 482', '482DEMO@HOT.COM', '2016-08-23', 0, 2, 1152, NULL, NULL, NULL),
  (486, '487690483', 'CARRERA 26 A 2 # 483', '483DEMO@HOT.COM', '2016-08-23', 0, 2, 316, NULL, NULL, NULL),
  (487, '487690484', 'CARRERA 26 A 2 # 484', '484DEMO@HOT.COM', '2016-08-23', 0, 1, 1156, NULL, NULL, NULL),
  (488, '487690485', 'CARRERA 26 A 2 # 485', '485DEMO@HOT.COM', '2016-08-23', 0, 1, 1018, NULL, NULL, NULL),
  (489, '487690486', 'CARRERA 26 A 2 # 486', '486DEMO@HOT.COM', '2016-08-23', 0, 1, 1128, NULL, NULL, NULL),
  (490, '487690487', 'CARRERA 26 A 2 # 487', '487DEMO@HOT.COM', '2016-08-23', 0, 2, 1403, NULL, NULL, NULL),
  (491, '487690488', 'CARRERA 26 A 2 # 488', '488DEMO@HOT.COM', '2016-08-23', 0, 1, 1863, NULL, NULL, NULL),
  (492, '487690489', 'CARRERA 26 A 2 # 489', '489DEMO@HOT.COM', '2016-08-23', 0, 1, 622, NULL, NULL, NULL),
  (493, '487690490', 'CARRERA 26 A 2 # 490', '490DEMO@HOT.COM', '2016-08-23', 0, 2, 1779, NULL, NULL, NULL),
  (494, '487690491', 'CARRERA 26 A 2 # 491', '491DEMO@HOT.COM', '2016-08-23', 0, 2, 1167, NULL, NULL, NULL),
  (495, '487690492', 'CARRERA 26 A 2 # 492', '492DEMO@HOT.COM', '2016-08-23', 0, 2, 1118, NULL, NULL, NULL),
  (496, '487690493', 'CARRERA 26 A 2 # 493', '493DEMO@HOT.COM', '2016-08-23', 0, 2, 493, NULL, NULL, NULL),
  (497, '487690494', 'CARRERA 26 A 2 # 494', '494DEMO@HOT.COM', '2016-08-23', 0, 2, 1294, NULL, NULL, NULL),
  (498, '487690495', 'CARRERA 26 A 2 # 495', '495DEMO@HOT.COM', '2016-08-23', 0, 2, 1303, NULL, NULL, NULL),
  (499, '487690496', 'CARRERA 26 A 2 # 496', '496DEMO@HOT.COM', '2016-08-23', 0, 2, 492, NULL, NULL, NULL),
  (500, '487690497', 'CARRERA 26 A 2 # 497', '497DEMO@HOT.COM', '2016-08-23', 0, 2, 1445, NULL, NULL, NULL),
  (501, '487690498', 'CARRERA 26 A 2 # 498', '498DEMO@HOT.COM', '2016-08-23', 0, 1, 21, NULL, NULL, NULL),
  (502, '487690499', 'CARRERA 26 A 2 # 499', '499DEMO@HOT.COM', '2016-08-23', 0, 1, 94, NULL, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `producto`
  --
  
  DROP TABLE IF EXISTS `producto`;
  CREATE TABLE IF NOT EXISTS `producto` (
    `pro_id` int(11) NOT NULL AUTO_INCREMENT,
    `pro_descripcion` varchar(100) DEFAULT NULL,
    `pro_costo` int(11) DEFAULT NULL,
    `pro_cantidad` int(11) DEFAULT NULL,
    `tal_id` int(11) NOT NULL,
    `col_id` int(11) NOT NULL,
    `pro_estado` tinyint(1) DEFAULT '1',
    PRIMARY KEY (`pro_id`),
    KEY `fk_producto_talla1_idx` (`tal_id`),
    KEY `fk_producto_color1_idx` (`col_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `producto`
  --
  
  INSERT INTO `producto` (`pro_id`, `pro_descripcion`, `pro_costo`, `pro_cantidad`, `tal_id`, `col_id`, `pro_estado`) VALUES
  (1, 'Producto 1', 20000, 30, 1, 4, 1),
  (2, 'producto 2', 10000, 25, 1, 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `talla`
  --
  
  DROP TABLE IF EXISTS `talla`;
  CREATE TABLE IF NOT EXISTS `talla` (
    `tal_id` int(11) NOT NULL AUTO_INCREMENT,
    `tal_dimension` varchar(50) DEFAULT NULL,
    `tip_pro_id` int(11) NOT NULL,
    `tal_estado` tinyint(1) DEFAULT '1',
    PRIMARY KEY (`tal_id`),
    KEY `fk_talla_tipo_producto1_idx` (`tip_pro_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `talla`
  --
  
  INSERT INTO `talla` (`tal_id`, `tal_dimension`, `tip_pro_id`, `tal_estado`) VALUES
  (1, '40', 1, 1),
  (2, '39', 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `tipo_cliente`
  --
  
  DROP TABLE IF EXISTS `tipo_cliente`;
  CREATE TABLE IF NOT EXISTS `tipo_cliente` (
    `tip_cli_id` int(11) NOT NULL AUTO_INCREMENT,
    `tip_cli_descripcion` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`tip_cli_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `tipo_cliente`
  --
  
  INSERT INTO `tipo_cliente` (`tip_cli_id`, `tip_cli_descripcion`) VALUES
  (1, 'JURIDICA'),
  (2, 'NATURAL');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `tipo_producto`
  --
  
  DROP TABLE IF EXISTS `tipo_producto`;
  CREATE TABLE IF NOT EXISTS `tipo_producto` (
    `tip_pro_id` int(11) NOT NULL AUTO_INCREMENT,
    `tip_descripcion` varchar(50) DEFAULT NULL,
    `tipo_estado` tinyint(1) DEFAULT '1',
    PRIMARY KEY (`tip_pro_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `tipo_producto`
  --
  
  INSERT INTO `tipo_producto` (`tip_pro_id`, `tip_descripcion`, `tipo_estado`) VALUES
  (1, 'ZAPATOS', 1),
  (2, 'BOTAS', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `usuarios`
  --
  
  DROP TABLE IF EXISTS `usuarios`;
  CREATE TABLE IF NOT EXISTS `usuarios` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nombre` varchar(100) DEFAULT NULL,
    `apellido` varchar(100) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `password` varchar(60) DEFAULT NULL,
    `remember_token` varchar(100) NOT NULL,
    `created_at` timestamp(6) NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `estado` tinyint(1) DEFAULT '1',
    PRIMARY KEY (`id`),
    UNIQUE KEY `email_UNIQUE` (`email`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `usuarios`
  --
  
  INSERT INTO `usuarios` (`id`, `nombre`, `apellido`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `estado`) VALUES
  (1, 'Desarrollo', 'Desarrollo', 'desarrollo@sena.com', '$2y$10$9R/SilIaZWVfMiNk38nyJuyP98lxQXkhY1Vec/b0OccP1UkN332gG', 'xfq9om8P7xJcbYYIbWn14HhnhHoTFhVBcr85a9qBdQC3sj5dzo1BW5HzWI39', NULL, NULL, 1),
  (2, 'coordinador', 'coordinador', 'coordinador@sena.com', '$2y$10$9R/SilIaZWVfMiNk38nyJuyP98lxQXkhY1Vec/b0OccP1UkN332gG', 'MZM2xVmnvVjt9v03roWKcWNy8xIdpJo4SIq4s8eic4EsQDZ7WBqCPqQ2ag8t', NULL, NULL, 1);
  
  --
  -- Restricciones para tablas volcadas
  --
  
  --
  -- Filtros para la tabla `bodega`
  --
  ALTER TABLE `bodega`
    ADD CONSTRAINT `fk_bodega_producto1` FOREIGN KEY (`pro_id`) REFERENCES `producto` (`pro_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Filtros para la tabla `detalle_orden_de_compra`
  --
  ALTER TABLE `detalle_orden_de_compra`
    ADD CONSTRAINT `fk_producto_has_orden_de_compra_orden_de_compra1` FOREIGN KEY (`ord_com_id`) REFERENCES `orden_de_compra` (`ord_com_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_producto_has_orden_de_compra_producto1` FOREIGN KEY (`pro_id`) REFERENCES `producto` (`pro_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Filtros para la tabla `empresa`
  --
  ALTER TABLE `empresa`
    ADD CONSTRAINT `fk_empresa_ciudad1` FOREIGN KEY (`ciu_id`) REFERENCES `ciudad` (`ciu_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_empresa_tipo_cliente1` FOREIGN KEY (`tip_cli_id`) REFERENCES `tipo_cliente` (`tip_cli_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Filtros para la tabla `persona`
  --
  ALTER TABLE `persona`
    ADD CONSTRAINT `fk_persona_ciudad` FOREIGN KEY (`ciu_id`) REFERENCES `ciudad` (`ciu_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_persona_tipo_cliente1` FOREIGN KEY (`tip_cli_id`) REFERENCES `tipo_cliente` (`tip_cli_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Filtros para la tabla `producto`
  --
  ALTER TABLE `producto`
    ADD CONSTRAINT `fk_producto_color1` FOREIGN KEY (`col_id`) REFERENCES `color` (`col_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_producto_talla1` FOREIGN KEY (`tal_id`) REFERENCES `talla` (`tal_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Filtros para la tabla `talla`
  --
  ALTER TABLE `talla`
    ADD CONSTRAINT `fk_talla_tipo_producto1` FOREIGN KEY (`tip_pro_id`) REFERENCES `tipo_producto` (`tip_pro_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;