text: CREATE TABLE `cliente` (
    `id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `municipio_id` int(11) NOT NULL,
    `tendero_id` int(11) NOT NULL,
    `nombre` varchar(100) NOT NULL,
    `apellido` varchar(100) NOT NULL,
    `direccion` varchar(100) DEFAULT NULL,
    `telefono` varchar(45) DEFAULT NULL,
    `email` varchar(150) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `cliente` (`id`, `user_id`, `municipio_id`, `tendero_id`, `nombre`, `apellido`, `direccion`, `telefono`, `email`) VALUES
  (1, 1, 547, 2, 'Pepito', 'Perez', 'Cra 80 # 90-34', '8745360', 'giovannyfrancoherrera@gmail.com'),
  (2, 6, 532, 2, 'Pepito', 'Perez', 'Cra 80 # 90-34', '8745360', 'giovannyfrancoherrera@gmail.com');
  
  
  CREATE TABLE `departamento` (
    `id_departamento` int(11) NOT NULL,
    `departamento` varchar(2555) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  INSERT INTO `departamento` (`id_departamento`, `departamento`) VALUES
  (5, 'ANTIOQUIA'),
  (8, 'ATLÁNTICO'),
  (11, 'BOGOTÁ, D.C.'),
  (13, 'BOLÍVAR'),
  (15, 'BOYACÁ'),
  (17, 'CALDAS'),
  (18, 'CAQUETÁ'),
  (19, 'CAUCA'),
  (20, 'CESAR'),
  (23, 'CÓRDOBA'),
  (25, 'CUNDINAMARCA'),
  (27, 'CHOCÓ'),
  (41, 'HUILA'),
  (44, 'LA GUAJIRA'),
  (47, 'MAGDALENA'),
  (50, 'META'),
  (52, 'NARIÑO'),
  (54, 'NORTE DE SANTANDER'),
  (63, 'QUINDIO'),
  (66, 'RISARALDA'),
  (68, 'SANTANDER'),
  (70, 'SUCRE'),
  (73, 'TOLIMA'),
  (76, 'VALLE DEL CAUCA'),
  (81, 'ARAUCA'),
  (85, 'CASANARE'),
  (86, 'PUTUMAYO'),
  (88, 'ARCHIPIÉLAGO DE SAN ANDRÉS, PROVIDENCIA Y SANTA CATALINA'),
  (91, 'AMAZONAS'),
  (94, 'GUAINÍA'),
  (95, 'GUAVIARE'),
  (97, 'VAUPÉS'),
  (99, 'VICHADA');
  
  CREATE TABLE `encuesta` (
    `id_encuesta` int(11) NOT NULL,
    `pregunta` varchar(255) NOT NULL,
    `estado` int(11) NOT NULL,
    `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `encuesta` (`id_encuesta`, `pregunta`, `estado`, `create_at`) VALUES
  (1, 'Consume productos cárnicos embutidos', 1, '2018-07-09 03:59:59'),
  (2, 'Cúales de los siguientes productos consume', 1, '2018-06-04 12:04:41'),
  (3, 'Con qué frecuencia consume estos productos', 1, '2018-06-04 12:05:19'),
  (4, 'Cuál es la presentación que más le gusta o le gustaría encontrar en los productos cárnicos embutidos que consume', 1, '2018-06-04 12:05:44'),
  (5, 'Cuál de las siguientes variables considera es la más importante para usted, a la hora de adquirir un embutido cárnico. Enumérelas de 1 a 5, donde 1 es la menos importante y 5 es la más importante', 1, '2018-06-04 12:06:08'),
  (6, 'Seleccione el establecimiento habitual de su compra', 1, '2018-06-04 12:06:23'),
  (7, 'Cuál es la forma en la que le gusta o le gustaría adquirir los productos cárnicos embutidos', 1, '2018-06-04 12:06:41'),
  (8, 'Le gustaría recibir ofertas e información de nuestra compañía, especialmente relacionada con campañas promocionales', 1, '2018-06-04 12:07:16');
  
  CREATE TABLE `encuesta_usuario` (
    `id_encuesta_usuario` int(11) NOT NULL,
    `respuesta` varchar(255) NOT NULL,
    `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `usuario_id` int(10) NOT NULL,
    `encuesta_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `encuesta_usuario` (`id_encuesta_usuario`, `respuesta`, `create_at`, `usuario_id`, `encuesta_id`) VALUES
  (1, '1', '2018-06-04 15:29:23', 1, 1),
  (2, '[\"2\",\"3\"]', '2018-06-04 15:29:23', 1, 2),
  (3, '2', '2018-06-04 15:29:23', 1, 3),
  (4, '2', '2018-06-04 15:29:23', 1, 4),
  (5, '{\"1\":[\"5\"],\"2\":[\"4\"],\"3\":[\"3\"],\"4\":[\"2\"],\"5\":[\"1\"]}', '2018-06-04 15:29:23', 1, 5),
  (6, '2', '2018-06-04 15:29:23', 1, 6),
  (7, '2', '2018-06-04 15:29:23', 1, 7),
  (8, '1', '2018-06-04 15:29:23', 1, 8),
  (9, '2', '2018-06-04 15:39:10', 1, 1),
  (10, '[\"1\",\"4\",\"6\"]', '2018-06-04 15:39:10', 1, 2),
  (11, '2', '2018-06-04 15:39:10', 1, 3),
  (12, '3', '2018-06-04 15:39:10', 1, 4),
  (13, '{\"1\":[\"5\"],\"2\":[\"4\"],\"3\":[\"3\"],\"4\":[\"2\"],\"5\":[\"1\"]}', '2018-06-04 15:39:10', 1, 5),
  (14, '2', '2018-06-04 15:39:10', 1, 6),
  (15, '3', '2018-06-04 15:39:10', 1, 7),
  (16, '2', '2018-06-04 15:39:10', 1, 8),
  (17, '1', '2018-06-05 07:57:58', 7, 1),
  (18, '[\"1\",\"2\",\"3\"]', '2018-06-05 07:57:58', 7, 2),
  (19, '2', '2018-06-05 07:57:58', 7, 3),
  (20, '2', '2018-06-05 07:57:58', 7, 4),
  (21, '{\"1\":[\"4\"],\"2\":[\"5\"],\"3\":[\"2\"],\"4\":[\"3\"],\"5\":[\"1\"]}', '2018-06-05 07:57:58', 7, 5),
  (22, '1', '2018-06-05 07:57:58', 7, 6),
  (23, '2', '2018-06-05 07:57:58', 7, 7),
  (24, '1', '2018-06-05 07:57:58', 7, 8);
  
  CREATE TABLE `migration` (
    `version` varchar(180) NOT NULL,
    `apply_time` int(11) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `migration` (`version`, `apply_time`) VALUES
  ('m000000_000000_base', 1527969242),
  ('m130524_201442_init', 1527969251);
  
  CREATE TABLE `municipio` (
    `id_municipio` int(11) NOT NULL,
    `departamento_id` int(11) NOT NULL,
    `municipio` varchar(255) NOT NULL,
    `estado` int(11) NOT NULL DEFAULT '1'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `municipio` (`id_municipio`, `departamento_id`, `municipio`, `estado`) VALUES
  (2, 50, 'Acacías', 1),
  (3, 27, 'Acandí', 1),
  (4, 41, 'Acevedo', 1),
  (5, 13, 'Achí', 1),
  (6, 41, 'Agrado', 1),
  (7, 25, 'Agua de Dios', 1),
  (8, 20, 'Aguachica', 1),
  (9, 68, 'Aguada', 1),
  (10, 17, 'Aguadas', 1),
  (11, 85, 'Aguazul', 1),
  (12, 20, 'Agustín Codazzi', 1),
  (13, 41, 'Aipe', 1),
  (14, 18, 'Albania', 1),
  (15, 44, 'Albania', 1),
  (16, 68, 'Albania', 1),
  (17, 25, 'Albán', 1),
  (18, 52, 'Albán (San José)', 1),
  (19, 76, 'Alcalá', 1),
  (20, 5, 'Alejandria', 1),
  (21, 47, 'Algarrobo', 1),
  (22, 41, 'Algeciras', 1),
  (23, 19, 'Almaguer', 1),
  (24, 15, 'Almeida', 1),
  (25, 73, 'Alpujarra', 1),
  (26, 41, 'Altamira', 1),
  (27, 27, 'Alto Baudó (Pie de Pato)', 1),
  (28, 13, 'Altos del Rosario', 1),
  (29, 73, 'Alvarado', 1),
  (30, 5, 'Amagá', 1),
  (31, 5, 'Amalfi', 1),
  (32, 73, 'Ambalema', 1),
  (33, 25, 'Anapoima', 1),
  (34, 52, 'Ancuya', 1),
  (35, 76, 'Andalucía', 1),
  (36, 5, 'Andes', 1),
  (37, 5, 'Angelópolis', 1),
  (38, 5, 'Angostura', 1),
  (39, 25, 'Anolaima', 1),
  (40, 5, 'Anorí', 1),
  (41, 17, 'Anserma', 1),
  (42, 76, 'Ansermanuevo', 1),
  (43, 73, 'Anzoátegui', 1),
  (44, 5, 'Anzá', 1),
  (45, 5, 'Apartadó', 1),
  (46, 25, 'Apulo', 1),
  (47, 66, 'Apía', 1),
  (48, 15, 'Aquitania', 1),
  (49, 47, 'Aracataca', 1),
  (50, 17, 'Aranzazu', 1),
  (51, 68, 'Aratoca', 1),
  (52, 81, 'Arauca', 1),
  (53, 81, 'Arauquita', 1),
  (54, 25, 'Arbeláez', 1),
  (55, 52, 'Arboleda (Berruecos)', 1),
  (56, 54, 'Arboledas', 1),
  (57, 5, 'Arboletes', 1),
  (58, 15, 'Arcabuco', 1),
  (59, 13, 'Arenal', 1),
  (60, 5, 'Argelia', 1),
  (61, 19, 'Argelia', 1),
  (62, 76, 'Argelia', 1),
  (63, 47, 'Ariguaní (El Difícil)', 1),
  (64, 13, 'Arjona', 1),
  (65, 5, 'Armenia', 1),
  (66, 63, 'Armenia', 1),
  (67, 73, 'Armero (Guayabal)', 1),
  (68, 13, 'Arroyohondo', 1),
  (69, 20, 'Astrea', 1),
  (70, 73, 'Ataco', 1),
  (71, 27, 'Atrato (Yuto)', 1),
  (72, 23, 'Ayapel', 1),
  (73, 27, 'Bagadó', 1),
  (74, 27, 'Bahía Solano (Mútis)', 1),
  (75, 27, 'Bajo Baudó (Pizarro)', 1),
  (76, 19, 'Balboa', 1),
  (77, 66, 'Balboa', 1),
  (78, 8, 'Baranoa', 1),
  (79, 41, 'Baraya', 1),
  (80, 52, 'Barbacoas', 1),
  (81, 5, 'Barbosa', 1),
  (82, 68, 'Barbosa', 1),
  (83, 68, 'Barichara', 1),
  (84, 50, 'Barranca de Upía', 1),
  (85, 68, 'Barrancabermeja', 1),
  (86, 44, 'Barrancas', 1),
  (87, 13, 'Barranco de Loba', 1),
  (88, 8, 'Barranquilla', 1),
  (89, 20, 'Becerríl', 1),
  (90, 17, 'Belalcázar', 1),
  (91, 5, 'Bello', 1),
  (92, 5, 'Belmira', 1),
  (93, 25, 'Beltrán', 1),
  (94, 15, 'Belén', 1),
  (95, 52, 'Belén', 1),
  (96, 27, 'Belén de Bajirá', 1),
  (97, 66, 'Belén de Umbría', 1),
  (98, 18, 'Belén de los Andaquíes', 1),
  (99, 15, 'Berbeo', 1),
  (100, 5, 'Betania', 1),
  (101, 15, 'Beteitiva', 1),
  (102, 5, 'Betulia', 1),
  (103, 68, 'Betulia', 1),
  (104, 25, 'Bituima', 1),
  (105, 15, 'Boavita', 1),
  (106, 54, 'Bochalema', 1),
  (107, 11, 'Bogotá D.C.', 1),
  (108, 25, 'Bojacá', 1),
  (109, 27, 'Bojayá (Bellavista)', 1),
  (110, 5, 'Bolívar', 1),
  (111, 19, 'Bolívar', 1),
  (112, 68, 'Bolívar', 1),
  (113, 76, 'Bolívar', 1),
  (114, 20, 'Bosconia', 1),
  (115, 15, 'Boyacá', 1),
  (116, 5, 'Briceño', 1),
  (117, 15, 'Briceño', 1),
  (118, 68, 'Bucaramanga', 1),
  (119, 54, 'Bucarasica', 1),
  (120, 76, 'Buenaventura', 1),
  (121, 15, 'Buenavista', 1),
  (122, 23, 'Buenavista', 1),
  (123, 63, 'Buenavista', 1),
  (124, 70, 'Buenavista', 1),
  (125, 19, 'Buenos Aires', 1),
  (126, 52, 'Buesaco', 1),
  (127, 76, 'Buga', 1),
  (128, 76, 'Bugalagrande', 1),
  (129, 5, 'Burítica', 1),
  (130, 15, 'Busbanza', 1),
  (131, 25, 'Cabrera', 1),
  (132, 68, 'Cabrera', 1),
  (133, 50, 'Cabuyaro', 1),
  (134, 25, 'Cachipay', 1),
  (135, 5, 'Caicedo', 1),
  (136, 76, 'Caicedonia', 1),
  (137, 70, 'Caimito', 1),
  (138, 73, 'Cajamarca', 1),
  (139, 19, 'Cajibío', 1),
  (140, 25, 'Cajicá', 1),
  (141, 13, 'Calamar', 1),
  (142, 95, 'Calamar', 1),
  (143, 63, 'Calarcá', 1),
  (144, 5, 'Caldas', 1),
  (145, 15, 'Caldas', 1),
  (146, 19, 'Caldono', 1),
  (147, 68, 'California', 1),
  (148, 76, 'Calima (Darién)', 1),
  (149, 19, 'Caloto', 1),
  (150, 76, 'Calí', 1),
  (151, 5, 'Campamento', 1),
  (152, 8, 'Campo de la Cruz', 1),
  (153, 41, 'Campoalegre', 1),
  (154, 15, 'Campohermoso', 1),
  (155, 23, 'Canalete', 1),
  (156, 8, 'Candelaria', 1),
  (157, 76, 'Candelaria', 1),
  (158, 13, 'Cantagallo', 1),
  (159, 27, 'Cantón de San Pablo', 1),
  (160, 25, 'Caparrapí', 1),
  (161, 68, 'Capitanejo', 1),
  (162, 5, 'Caracolí', 1),
  (163, 5, 'Caramanta', 1),
  (164, 68, 'Carcasí', 1),
  (165, 5, 'Carepa', 1),
  (166, 73, 'Carmen de Apicalá', 1),
  (167, 25, 'Carmen de Carupa', 1),
  (168, 5, 'Carmen de Viboral', 1),
  (169, 27, 'Carmen del Darién (CURBARADÓ)', 1),
  (170, 5, 'Carolina', 1),
  (171, 13, 'Cartagena', 1),
  (172, 18, 'Cartagena del Chairá', 1),
  (173, 76, 'Cartago', 1),
  (174, 97, 'Carurú', 1),
  (175, 73, 'Casabianca', 1),
  (176, 50, 'Castilla la Nueva', 1),
  (177, 5, 'Caucasia', 1),
  (178, 5, 'Cañasgordas', 1),
  (179, 68, 'Cepita', 1),
  (180, 23, 'Cereté', 1),
  (181, 15, 'Cerinza', 1),
  (182, 68, 'Cerrito', 1),
  (183, 47, 'Cerro San Antonio', 1),
  (184, 52, 'Chachaguí', 1),
  (185, 25, 'Chaguaní', 1),
  (186, 70, 'Chalán', 1),
  (187, 73, 'Chaparral', 1),
  (188, 68, 'Charalá', 1),
  (189, 68, 'Charta', 1),
  (190, 5, 'Chigorodó', 1),
  (191, 68, 'Chima', 1),
  (192, 20, 'Chimichagua', 1),
  (193, 23, 'Chimá', 1),
  (194, 15, 'Chinavita', 1),
  (195, 17, 'Chinchiná', 1),
  (196, 54, 'Chinácota', 1),
  (197, 23, 'Chinú', 1),
  (198, 25, 'Chipaque', 1),
  (199, 68, 'Chipatá', 1),
  (200, 15, 'Chiquinquirá', 1),
  (201, 20, 'Chiriguaná', 1),
  (202, 15, 'Chiscas', 1),
  (203, 15, 'Chita', 1),
  (204, 54, 'Chitagá', 1),
  (205, 15, 'Chitaraque', 1),
  (206, 15, 'Chivatá', 1),
  (207, 47, 'Chivolo', 1),
  (208, 25, 'Choachí', 1),
  (209, 25, 'Chocontá', 1),
  (210, 85, 'Chámeza', 1),
  (211, 25, 'Chía', 1),
  (212, 15, 'Chíquiza', 1),
  (213, 15, 'Chívor', 1),
  (214, 13, 'Cicuco', 1),
  (215, 68, 'Cimitarra', 1),
  (216, 63, 'Circasia', 1),
  (217, 5, 'Cisneros', 1),
  (218, 15, 'Ciénaga', 1),
  (219, 47, 'Ciénaga', 1),
  (220, 23, 'Ciénaga de Oro', 1),
  (221, 13, 'Clemencia', 1),
  (222, 5, 'Cocorná', 1),
  (223, 73, 'Coello', 1),
  (224, 25, 'Cogua', 1),
  (225, 41, 'Colombia', 1),
  (226, 70, 'Colosó (Ricaurte)', 1),
  (227, 86, 'Colón', 1),
  (228, 52, 'Colón (Génova)', 1),
  (229, 5, 'Concepción', 1),
  (230, 68, 'Concepción', 1),
  (231, 5, 'Concordia', 1),
  (232, 47, 'Concordia', 1),
  (233, 27, 'Condoto', 1),
  (234, 68, 'Confines', 1),
  (235, 52, 'Consaca', 1),
  (236, 52, 'Contadero', 1),
  (237, 68, 'Contratación', 1),
  (238, 54, 'Convención', 1),
  (239, 5, 'Copacabana', 1),
  (240, 15, 'Coper', 1),
  (241, 63, 'Cordobá', 1),
  (242, 19, 'Corinto', 1),
  (243, 68, 'Coromoro', 1),
  (244, 70, 'Corozal', 1),
  (245, 15, 'Corrales', 1),
  (246, 25, 'Cota', 1),
  (247, 23, 'Cotorra', 1),
  (248, 15, 'Covarachía', 1),
  (249, 70, 'Coveñas', 1),
  (250, 73, 'Coyaima', 1),
  (251, 81, 'Cravo Norte', 1),
  (252, 52, 'Cuaspud (Carlosama)', 1),
  (253, 50, 'Cubarral', 1),
  (254, 15, 'Cubará', 1),
  (255, 15, 'Cucaita', 1),
  (256, 25, 'Cucunubá', 1),
  (257, 54, 'Cucutilla', 1),
  (258, 15, 'Cuitiva', 1),
  (259, 50, 'Cumaral', 1),
  (260, 99, 'Cumaribo', 1),
  (261, 52, 'Cumbal', 1),
  (262, 52, 'Cumbitara', 1),
  (263, 73, 'Cunday', 1),
  (264, 18, 'Curillo', 1),
  (265, 68, 'Curití', 1),
  (266, 20, 'Curumaní', 1),
  (267, 5, 'Cáceres', 1),
  (268, 54, 'Cáchira', 1),
  (269, 54, 'Cácota', 1),
  (270, 25, 'Cáqueza', 1),
  (271, 27, 'Cértegui', 1),
  (272, 15, 'Cómbita', 1),
  (273, 13, 'Córdoba', 1),
  (274, 52, 'Córdoba', 1),
  (275, 54, 'Cúcuta', 1),
  (276, 5, 'Dabeiba', 1),
  (277, 76, 'Dagua', 1),
  (278, 44, 'Dibulla', 1),
  (279, 44, 'Distracción', 1),
  (280, 73, 'Dolores', 1),
  (281, 5, 'Don Matías', 1),
  (282, 66, 'Dos Quebradas', 1),
  (283, 15, 'Duitama', 1),
  (284, 54, 'Durania', 1),
  (285, 5, 'Ebéjico', 1),
  (286, 5, 'El Bagre', 1),
  (287, 47, 'El Banco', 1),
  (288, 76, 'El Cairo', 1),
  (289, 50, 'El Calvario', 1),
  (290, 54, 'El Carmen', 1),
  (291, 68, 'El Carmen', 1),
  (292, 27, 'El Carmen de Atrato', 1),
  (293, 13, 'El Carmen de Bolívar', 1),
  (294, 50, 'El Castillo', 1),
  (295, 76, 'El Cerrito', 1),
  (296, 52, 'El Charco', 1),
  (297, 15, 'El Cocuy', 1),
  (298, 25, 'El Colegio', 1),
  (299, 20, 'El Copey', 1),
  (300, 18, 'El Doncello', 1),
  (301, 50, 'El Dorado', 1),
  (302, 76, 'El Dovio', 1),
  (303, 15, 'El Espino', 1),
  (304, 68, 'El Guacamayo', 1),
  (305, 13, 'El Guamo', 1),
  (306, 44, 'El Molino', 1),
  (307, 20, 'El Paso', 1),
  (308, 18, 'El Paujil', 1),
  (309, 52, 'El Peñol', 1),
  (310, 13, 'El Peñon', 1),
  (311, 68, 'El Peñon', 1),
  (312, 25, 'El Peñón', 1),
  (313, 47, 'El Piñon', 1),
  (314, 68, 'El Playón', 1),
  (315, 95, 'El Retorno', 1),
  (316, 47, 'El Retén', 1),
  (317, 70, 'El Roble', 1),
  (318, 25, 'El Rosal', 1),
  (319, 52, 'El Rosario', 1),
  (320, 52, 'El Tablón de Gómez', 1),
  (321, 19, 'El Tambo', 1),
  (322, 52, 'El Tambo', 1),
  (323, 54, 'El Tarra', 1),
  (324, 54, 'El Zulia', 1),
  (325, 76, 'El Águila', 1),
  (326, 41, 'Elías', 1),
  (327, 68, 'Encino', 1),
  (328, 68, 'Enciso', 1),
  (329, 5, 'Entrerríos', 1),
  (330, 5, 'Envigado', 1),
  (331, 73, 'Espinal', 1),
  (332, 25, 'Facatativá', 1),
  (333, 73, 'Falan', 1),
  (334, 17, 'Filadelfia', 1),
  (335, 63, 'Filandia', 1),
  (336, 15, 'Firavitoba', 1),
  (337, 73, 'Flandes', 1),
  (338, 18, 'Florencia', 1),
  (339, 19, 'Florencia', 1),
  (340, 15, 'Floresta', 1),
  (341, 76, 'Florida', 1),
  (342, 68, 'Floridablanca', 1),
  (343, 68, 'Florián', 1),
  (344, 44, 'Fonseca', 1),
  (345, 81, 'Fortúl', 1),
  (346, 25, 'Fosca', 1),
  (347, 52, 'Francisco Pizarro', 1),
  (348, 5, 'Fredonia', 1),
  (349, 73, 'Fresno', 1),
  (350, 5, 'Frontino', 1),
  (351, 50, 'Fuente de Oro', 1),
  (352, 47, 'Fundación', 1),
  (353, 52, 'Funes', 1),
  (354, 25, 'Funza', 1),
  (355, 25, 'Fusagasugá', 1),
  (356, 25, 'Fómeque', 1),
  (357, 25, 'Fúquene', 1),
  (358, 25, 'Gachalá', 1),
  (359, 25, 'Gachancipá', 1),
  (360, 15, 'Gachantivá', 1),
  (361, 25, 'Gachetá', 1),
  (362, 8, 'Galapa', 1),
  (363, 70, 'Galeras (Nueva Granada)', 1),
  (364, 68, 'Galán', 1),
  (365, 25, 'Gama', 1),
  (366, 20, 'Gamarra', 1),
  (367, 15, 'Garagoa', 1),
  (368, 41, 'Garzón', 1),
  (369, 41, 'Gigante', 1),
  (370, 76, 'Ginebra', 1),
  (371, 5, 'Giraldo', 1),
  (372, 25, 'Girardot', 1),
  (373, 5, 'Girardota', 1),
  (374, 68, 'Girón', 1),
  (375, 20, 'Gonzalez', 1),
  (376, 54, 'Gramalote', 1),
  (377, 5, 'Granada', 1),
  (378, 25, 'Granada', 1),
  (379, 50, 'Granada', 1),
  (380, 68, 'Guaca', 1),
  (381, 15, 'Guacamayas', 1),
  (382, 76, 'Guacarí', 1),
  (383, 52, 'Guachavés', 1),
  (384, 19, 'Guachené', 1),
  (385, 25, 'Guachetá', 1),
  (386, 52, 'Guachucal', 1),
  (387, 5, 'Guadalupe', 1),
  (388, 41, 'Guadalupe', 1),
  (389, 68, 'Guadalupe', 1),
  (390, 25, 'Guaduas', 1),
  (391, 52, 'Guaitarilla', 1),
  (392, 52, 'Gualmatán', 1),
  (393, 47, 'Guamal', 1),
  (394, 50, 'Guamal', 1),
  (395, 73, 'Guamo', 1),
  (396, 68, 'Guapota', 1),
  (397, 19, 'Guapí', 1),
  (398, 70, 'Guaranda', 1),
  (399, 5, 'Guarne', 1),
  (400, 25, 'Guasca', 1),
  (401, 5, 'Guatapé', 1),
  (402, 25, 'Guataquí', 1),
  (403, 25, 'Guatavita', 1),
  (404, 15, 'Guateque', 1),
  (405, 68, 'Guavatá', 1),
  (406, 25, 'Guayabal de Siquima', 1),
  (407, 25, 'Guayabetal', 1),
  (408, 15, 'Guayatá', 1),
  (409, 68, 'Guepsa', 1),
  (410, 15, 'Guicán', 1),
  (411, 25, 'Gutiérrez', 1),
  (412, 66, 'Guática', 1),
  (413, 68, 'Gámbita', 1),
  (414, 15, 'Gámeza', 1),
  (415, 63, 'Génova', 1),
  (416, 5, 'Gómez Plata', 1),
  (417, 54, 'Hacarí', 1),
  (418, 13, 'Hatillo de Loba', 1),
  (419, 68, 'Hato', 1),
  (420, 85, 'Hato Corozal', 1),
  (421, 44, 'Hatonuevo', 1),
  (422, 5, 'Heliconia', 1),
  (423, 54, 'Herrán', 1),
  (424, 73, 'Herveo', 1),
  (425, 5, 'Hispania', 1),
  (426, 41, 'Hobo', 1),
  (427, 73, 'Honda', 1),
  (428, 73, 'Ibagué', 1),
  (429, 73, 'Icononzo', 1),
  (430, 52, 'Iles', 1),
  (431, 52, 'Imúes', 1),
  (432, 19, 'Inzá', 1),
  (433, 94, 'Inírida', 1),
  (434, 52, 'Ipiales', 1),
  (435, 41, 'Isnos', 1),
  (436, 27, 'Istmina', 1),
  (437, 5, 'Itagüí', 1),
  (438, 5, 'Ituango', 1),
  (439, 15, 'Izá', 1),
  (440, 19, 'Jambaló', 1),
  (441, 76, 'Jamundí', 1),
  (442, 5, 'Jardín', 1),
  (443, 15, 'Jenesano', 1),
  (444, 5, 'Jericó', 1),
  (445, 15, 'Jericó', 1),
  (446, 25, 'Jerusalén', 1),
  (447, 68, 'Jesús María', 1),
  (448, 68, 'Jordán', 1),
  (449, 8, 'Juan de Acosta', 1),
  (450, 25, 'Junín', 1),
  (451, 27, 'Juradó', 1),
  (452, 23, 'La Apartada y La Frontera', 1),
  (453, 41, 'La Argentina', 1),
  (454, 68, 'La Belleza', 1),
  (455, 25, 'La Calera', 1),
  (456, 15, 'La Capilla', 1),
  (457, 5, 'La Ceja', 1),
  (458, 66, 'La Celia', 1),
  (459, 52, 'La Cruz', 1),
  (460, 76, 'La Cumbre', 1),
  (461, 17, 'La Dorada', 1),
  (462, 54, 'La Esperanza', 1),
  (463, 5, 'La Estrella', 1),
  (464, 52, 'La Florida', 1),
  (465, 20, 'La Gloria', 1),
  (466, 20, 'La Jagua de Ibirico', 1),
  (467, 44, 'La Jagua del Pilar', 1),
  (468, 52, 'La Llanada', 1),
  (469, 50, 'La Macarena', 1),
  (470, 17, 'La Merced', 1),
  (471, 25, 'La Mesa', 1),
  (472, 18, 'La Montañita', 1),
  (473, 25, 'La Palma', 1),
  (474, 68, 'La Paz', 1),
  (475, 20, 'La Paz (Robles)', 1),
  (476, 25, 'La Peña', 1),
  (477, 5, 'La Pintada', 1),
  (478, 41, 'La Plata', 1),
  (479, 54, 'La Playa', 1),
  (480, 99, 'La Primavera', 1),
  (481, 85, 'La Salina', 1),
  (482, 19, 'La Sierra', 1),
  (483, 63, 'La Tebaida', 1),
  (484, 52, 'La Tola', 1),
  (485, 5, 'La Unión', 1),
  (486, 52, 'La Unión', 1),
  (487, 70, 'La Unión', 1),
  (488, 76, 'La Unión', 1),
  (489, 15, 'La Uvita', 1),
  (490, 19, 'La Vega', 1),
  (491, 25, 'La Vega', 1),
  (492, 15, 'La Victoria', 1),
  (493, 17, 'La Victoria', 1),
  (494, 76, 'La Victoria', 1),
  (495, 66, 'La Virginia', 1),
  (496, 54, 'Labateca', 1),
  (497, 15, 'Labranzagrande', 1),
  (498, 68, 'Landázuri', 1),
  (499, 68, 'Lebrija', 1),
  (500, 52, 'Leiva', 1),
  (501, 50, 'Lejanías', 1),
  (502, 25, 'Lenguazaque', 1),
  (503, 91, 'Leticia', 1),
  (504, 5, 'Liborina', 1),
  (505, 52, 'Linares', 1),
  (506, 27, 'Lloró', 1),
  (507, 23, 'Lorica', 1),
  (508, 23, 'Los Córdobas', 1),
  (509, 70, 'Los Palmitos', 1),
  (510, 54, 'Los Patios', 1),
  (511, 68, 'Los Santos', 1),
  (512, 54, 'Lourdes', 1),
  (513, 8, 'Luruaco', 1),
  (514, 73, 'Lérida', 1),
  (515, 73, 'Líbano', 1),
  (516, 19, 'López (Micay)', 1),
  (517, 15, 'Macanal', 1),
  (518, 68, 'Macaravita', 1),
  (519, 5, 'Maceo', 1),
  (520, 25, 'Machetá', 1),
  (521, 25, 'Madrid', 1),
  (522, 13, 'Magangué', 1),
  (523, 52, 'Magüi (Payán)', 1),
  (524, 13, 'Mahates', 1),
  (525, 44, 'Maicao', 1),
  (526, 70, 'Majagual', 1),
  (527, 8, 'Malambo', 1),
  (528, 52, 'Mallama (Piedrancha)', 1),
  (529, 8, 'Manatí', 1),
  (530, 44, 'Manaure', 1),
  (531, 20, 'Manaure Balcón del Cesar', 1),
  (532, 17, 'Manizales', 1),
  (533, 25, 'Manta', 1),
  (534, 17, 'Manzanares', 1),
  (535, 85, 'Maní', 1),
  (536, 50, 'Mapiripan', 1),
  (537, 13, 'Margarita', 1),
  (538, 5, 'Marinilla', 1),
  (539, 15, 'Maripí', 1),
  (540, 73, 'Mariquita', 1),
  (541, 17, 'Marmato', 1),
  (542, 17, 'Marquetalia', 1),
  (543, 66, 'Marsella', 1),
  (544, 17, 'Marulanda', 1),
  (545, 13, 'María la Baja', 1),
  (546, 68, 'Matanza', 1),
  (547, 5, 'Medellín', 1),
  (548, 25, 'Medina', 1),
  (549, 27, 'Medio Atrato', 1),
  (550, 27, 'Medio Baudó', 1),
  (551, 27, 'Medio San Juan (ANDAGOYA)', 1),
  (552, 73, 'Melgar', 1),
  (553, 19, 'Mercaderes', 1),
  (554, 50, 'Mesetas', 1),
  (555, 18, 'Milán', 1),
  (556, 15, 'Miraflores', 1),
  (557, 95, 'Miraflores', 1),
  (558, 19, 'Miranda', 1),
  (559, 66, 'Mistrató', 1),
  (560, 97, 'Mitú', 1),
  (561, 86, 'Mocoa', 1),
  (562, 68, 'Mogotes', 1),
  (563, 68, 'Molagavita', 1),
  (564, 23, 'Momil', 1),
  (565, 13, 'Mompós', 1),
  (566, 15, 'Mongua', 1),
  (567, 15, 'Monguí', 1),
  (568, 15, 'Moniquirá', 1),
  (569, 5, 'Montebello', 1),
  (570, 13, 'Montecristo', 1),
  (571, 23, 'Montelíbano', 1),
  (572, 63, 'Montenegro', 1),
  (573, 23, 'Monteria', 1),
  (574, 85, 'Monterrey', 1),
  (575, 13, 'Morales', 1),
  (576, 19, 'Morales', 1),
  (577, 18, 'Morelia', 1),
  (578, 70, 'Morroa', 1),
  (579, 25, 'Mosquera', 1),
  (580, 52, 'Mosquera', 1),
  (581, 15, 'Motavita', 1),
  (582, 23, 'Moñitos', 1),
  (583, 73, 'Murillo', 1),
  (584, 5, 'Murindó', 1),
  (585, 5, 'Mutatá', 1),
  (586, 54, 'Mutiscua', 1),
  (587, 15, 'Muzo', 1),
  (588, 68, 'Málaga', 1),
  (589, 5, 'Nariño', 1),
  (590, 25, 'Nariño', 1),
  (591, 52, 'Nariño', 1),
  (592, 73, 'Natagaima', 1),
  (593, 5, 'Nechí', 1),
  (594, 5, 'Necoclí', 1),
  (595, 17, 'Neira', 1),
  (596, 41, 'Neiva', 1),
  (597, 25, 'Nemocón', 1),
  (598, 25, 'Nilo', 1),
  (599, 25, 'Nimaima', 1),
  (600, 15, 'Nobsa', 1),
  (601, 25, 'Nocaima', 1),
  (602, 17, 'Norcasia', 1),
  (603, 13, 'Norosí', 1),
  (604, 27, 'Novita', 1),
  (605, 47, 'Nueva Granada', 1),
  (606, 15, 'Nuevo Colón', 1),
  (607, 85, 'Nunchía', 1),
  (608, 27, 'Nuquí', 1),
  (609, 41, 'Nátaga', 1),
  (610, 76, 'Obando', 1),
  (611, 68, 'Ocamonte', 1),
  (612, 54, 'Ocaña', 1),
  (613, 68, 'Oiba', 1),
  (614, 15, 'Oicatá', 1),
  (615, 5, 'Olaya', 1),
  (616, 52, 'Olaya Herrera', 1),
  (617, 68, 'Onzaga', 1),
  (618, 41, 'Oporapa', 1),
  (619, 86, 'Orito', 1),
  (620, 85, 'Orocué', 1),
  (621, 73, 'Ortega', 1),
  (622, 52, 'Ospina', 1),
  (623, 15, 'Otanche', 1),
  (624, 70, 'Ovejas', 1),
  (625, 15, 'Pachavita', 1),
  (626, 25, 'Pacho', 1),
  (627, 19, 'Padilla', 1),
  (628, 41, 'Paicol', 1),
  (629, 20, 'Pailitas', 1),
  (630, 25, 'Paime', 1),
  (631, 15, 'Paipa', 1),
  (632, 15, 'Pajarito', 1),
  (633, 41, 'Palermo', 1),
  (634, 17, 'Palestina', 1),
  (635, 41, 'Palestina', 1),
  (636, 68, 'Palmar', 1),
  (637, 8, 'Palmar de Varela', 1),
  (638, 68, 'Palmas del Socorro', 1),
  (639, 76, 'Palmira', 1),
  (640, 70, 'Palmito', 1),
  (641, 73, 'Palocabildo', 1),
  (642, 54, 'Pamplona', 1),
  (643, 54, 'Pamplonita', 1),
  (644, 25, 'Pandi', 1),
  (645, 15, 'Panqueba', 1),
  (646, 25, 'Paratebueno', 1),
  (647, 25, 'Pasca', 1),
  (648, 19, 'Patía (El Bordo)', 1),
  (649, 15, 'Pauna', 1),
  (650, 15, 'Paya', 1),
  (651, 85, 'Paz de Ariporo', 1),
  (652, 15, 'Paz de Río', 1),
  (653, 47, 'Pedraza', 1),
  (654, 20, 'Pelaya', 1),
  (655, 17, 'Pensilvania', 1),
  (656, 5, 'Peque', 1),
  (657, 66, 'Pereira', 1),
  (658, 15, 'Pesca', 1),
  (659, 5, 'Peñol', 1),
  (660, 19, 'Piamonte', 1),
  (661, 68, 'Pie de Cuesta', 1),
  (662, 73, 'Piedras', 1),
  (663, 19, 'Piendamó', 1),
  (664, 63, 'Pijao', 1),
  (665, 47, 'Pijiño', 1),
  (666, 68, 'Pinchote', 1),
  (667, 13, 'Pinillos', 1),
  (668, 8, 'Piojo', 1),
  (669, 15, 'Pisva', 1),
  (670, 41, 'Pital', 1),
  (671, 41, 'Pitalito', 1),
  (672, 47, 'Pivijay', 1),
  (673, 73, 'Planadas', 1),
  (674, 23, 'Planeta Rica', 1),
  (675, 47, 'Plato', 1),
  (676, 52, 'Policarpa', 1),
  (677, 8, 'Polonuevo', 1),
  (678, 8, 'Ponedera', 1),
  (679, 19, 'Popayán', 1),
  (680, 85, 'Pore', 1),
  (681, 52, 'Potosí', 1),
  (682, 76, 'Pradera', 1),
  (683, 73, 'Prado', 1),
  (684, 52, 'Providencia', 1),
  (685, 88, 'Providencia', 1),
  (686, 20, 'Pueblo Bello', 1),
  (687, 23, 'Pueblo Nuevo', 1),
  (688, 66, 'Pueblo Rico', 1),
  (689, 5, 'Pueblorrico', 1),
  (690, 47, 'Puebloviejo', 1),
  (691, 68, 'Puente Nacional', 1),
  (692, 52, 'Puerres', 1),
  (693, 86, 'Puerto Asís', 1),
  (694, 5, 'Puerto Berrío', 1),
  (695, 15, 'Puerto Boyacá', 1),
  (696, 86, 'Puerto Caicedo', 1),
  (697, 99, 'Puerto Carreño', 1),
  (698, 8, 'Puerto Colombia', 1),
  (699, 50, 'Puerto Concordia', 1),
  (700, 23, 'Puerto Escondido', 1),
  (701, 50, 'Puerto Gaitán', 1),
  (702, 86, 'Puerto Guzmán', 1),
  (703, 86, 'Puerto Leguízamo', 1),
  (704, 23, 'Puerto Libertador', 1),
  (705, 50, 'Puerto Lleras', 1),
  (706, 50, 'Puerto López', 1),
  (707, 5, 'Puerto Nare', 1),
  (708, 91, 'Puerto Nariño', 1),
  (709, 68, 'Puerto Parra', 1),
  (710, 18, 'Puerto Rico', 1),
  (711, 50, 'Puerto Rico', 1),
  (712, 81, 'Puerto Rondón', 1),
  (713, 25, 'Puerto Salgar', 1),
  (714, 54, 'Puerto Santander', 1),
  (715, 19, 'Puerto Tejada', 1),
  (716, 5, 'Puerto Triunfo', 1),
  (717, 68, 'Puerto Wilches', 1),
  (718, 25, 'Pulí', 1),
  (719, 52, 'Pupiales', 1),
  (720, 19, 'Puracé (Coconuco)', 1),
  (721, 73, 'Purificación', 1),
  (722, 23, 'Purísima', 1),
  (723, 17, 'Pácora', 1),
  (724, 15, 'Páez', 1),
  (725, 19, 'Páez (Belalcazar)', 1),
  (726, 68, 'Páramo', 1),
  (727, 25, 'Quebradanegra', 1),
  (728, 25, 'Quetame', 1),
  (729, 27, 'Quibdó', 1),
  (730, 63, 'Quimbaya', 1),
  (731, 66, 'Quinchía', 1),
  (732, 15, 'Quipama', 1),
  (733, 25, 'Quipile', 1),
  (734, 54, 'Ragonvalia', 1),
  (735, 15, 'Ramiriquí', 1),
  (736, 85, 'Recetor', 1),
  (737, 13, 'Regidor', 1),
  (738, 5, 'Remedios', 1),
  (739, 47, 'Remolino', 1),
  (740, 8, 'Repelón', 1),
  (741, 50, 'Restrepo', 1),
  (742, 76, 'Restrepo', 1),
  (743, 5, 'Retiro', 1),
  (744, 25, 'Ricaurte', 1),
  (745, 52, 'Ricaurte', 1),
  (746, 68, 'Rio Negro', 1),
  (747, 73, 'Rioblanco', 1),
  (748, 76, 'Riofrío', 1),
  (749, 44, 'Riohacha', 1),
  (750, 17, 'Risaralda', 1),
  (751, 41, 'Rivera', 1),
  (752, 52, 'Roberto Payán (San José)', 1),
  (753, 76, 'Roldanillo', 1),
  (754, 73, 'Roncesvalles', 1),
  (755, 15, 'Rondón', 1),
  (756, 19, 'Rosas', 1),
  (757, 73, 'Rovira', 1),
  (758, 15, 'Ráquira', 1),
  (759, 27, 'Río Iró', 1),
  (760, 27, 'Río Quito', 1),
  (761, 17, 'Río Sucio', 1),
  (762, 13, 'Río Viejo', 1),
  (763, 20, 'Río de oro', 1),
  (764, 5, 'Ríonegro', 1),
  (765, 27, 'Ríosucio', 1),
  (766, 68, 'Sabana de Torres', 1),
  (767, 8, 'Sabanagrande', 1),
  (768, 5, 'Sabanalarga', 1),
  (769, 8, 'Sabanalarga', 1),
  (770, 85, 'Sabanalarga', 1),
  (771, 47, 'Sabanas de San Angel (SAN ANGEL)', 1),
  (772, 5, 'Sabaneta', 1),
  (773, 15, 'Saboyá', 1),
  (774, 23, 'Sahagún', 1),
  (775, 41, 'Saladoblanco', 1),
  (776, 17, 'Salamina', 1),
  (777, 47, 'Salamina', 1),
  (778, 54, 'Salazar', 1),
  (779, 73, 'Saldaña', 1),
  (780, 63, 'Salento', 1),
  (781, 5, 'Salgar', 1),
  (782, 15, 'Samacá', 1),
  (783, 52, 'Samaniego', 1),
  (784, 17, 'Samaná', 1),
  (785, 70, 'Sampués', 1),
  (786, 41, 'San Agustín', 1),
  (787, 20, 'San Alberto', 1),
  (788, 68, 'San Andrés', 1),
  (789, 23, 'San Andrés Sotavento', 1),
  (790, 5, 'San Andrés de Cuerquía', 1),
  (791, 23, 'San Antero', 1),
  (792, 73, 'San Antonio', 1),
  (793, 25, 'San Antonio de Tequendama', 1),
  (794, 68, 'San Benito', 1),
  (795, 70, 'San Benito Abad', 1),
  (796, 25, 'San Bernardo', 1),
  (797, 52, 'San Bernardo', 1),
  (798, 23, 'San Bernardo del Viento', 1),
  (799, 54, 'San Calixto', 1),
  (800, 5, 'San Carlos', 1),
  (801, 23, 'San Carlos', 1),
  (802, 50, 'San Carlos de Guaroa', 1),
  (803, 25, 'San Cayetano', 1),
  (804, 54, 'San Cayetano', 1),
  (805, 13, 'San Cristobal', 1),
  (806, 20, 'San Diego', 1),
  (807, 15, 'San Eduardo', 1),
  (808, 13, 'San Estanislao', 1),
  (809, 13, 'San Fernando', 1),
  (810, 5, 'San Francisco', 1),
  (811, 25, 'San Francisco', 1),
  (812, 86, 'San Francisco', 1),
  (813, 68, 'San Gíl', 1),
  (814, 13, 'San Jacinto', 1),
  (815, 13, 'San Jacinto del Cauca', 1),
  (816, 5, 'San Jerónimo', 1),
  (817, 68, 'San Joaquín', 1),
  (818, 17, 'San José', 1),
  (819, 68, 'San José de Miranda', 1),
  (820, 5, 'San José de Montaña', 1),
  (821, 15, 'San José de Pare', 1),
  (822, 23, 'San José de Uré', 1),
  (823, 18, 'San José del Fragua', 1),
  (824, 95, 'San José del Guaviare', 1),
  (825, 27, 'San José del Palmar', 1),
  (826, 50, 'San Juan de Arama', 1),
  (827, 70, 'San Juan de Betulia', 1),
  (828, 13, 'San Juan de Nepomuceno', 1),
  (829, 52, 'San Juan de Pasto', 1),
  (830, 25, 'San Juan de Río Seco', 1),
  (831, 5, 'San Juan de Urabá', 1),
  (832, 44, 'San Juan del Cesar', 1),
  (833, 50, 'San Juanito', 1),
  (834, 52, 'San Lorenzo', 1),
  (835, 73, 'San Luis', 1),
  (836, 5, 'San Luís', 1),
  (837, 15, 'San Luís de Gaceno', 1),
  (838, 85, 'San Luís de Palenque', 1),
  (839, 70, 'San Marcos', 1),
  (840, 20, 'San Martín', 1),
  (841, 50, 'San Martín', 1),
  (842, 13, 'San Martín de Loba', 1),
  (843, 15, 'San Mateo', 1),
  (844, 68, 'San Miguel', 1),
  (845, 86, 'San Miguel', 1),
  (846, 15, 'San Miguel de Sema', 1),
  (847, 70, 'San Onofre', 1),
  (848, 13, 'San Pablo', 1),
  (849, 52, 'San Pablo', 1),
  (850, 15, 'San Pablo de Borbur', 1),
  (851, 5, 'San Pedro', 1),
  (852, 70, 'San Pedro', 1),
  (853, 76, 'San Pedro', 1),
  (854, 52, 'San Pedro de Cartago', 1),
  (855, 5, 'San Pedro de Urabá', 1),
  (856, 23, 'San Pelayo', 1),
  (857, 5, 'San Rafael', 1),
  (858, 5, 'San Roque', 1),
  (859, 19, 'San Sebastián', 1),
  (860, 47, 'San Sebastián de Buenavista', 1),
  (861, 5, 'San Vicente', 1),
  (862, 18, 'San Vicente del Caguán', 1),
  (863, 68, 'San Vicente del Chucurí', 1),
  (864, 47, 'San Zenón', 1),
  (865, 52, 'Sandoná', 1),
  (866, 47, 'Santa Ana', 1),
  (867, 5, 'Santa Bárbara', 1),
  (868, 68, 'Santa Bárbara', 1),
  (869, 52, 'Santa Bárbara (Iscuandé)', 1),
  (870, 47, 'Santa Bárbara de Pinto', 1),
  (871, 13, 'Santa Catalina', 1),
  (872, 5, 'Santa Fé de Antioquia', 1),
  (873, 27, 'Santa Genoveva de Docorodó', 1),
  (874, 68, 'Santa Helena del Opón', 1),
  (875, 73, 'Santa Isabel', 1),
  (876, 8, 'Santa Lucía', 1),
  (877, 47, 'Santa Marta', 1),
  (878, 15, 'Santa María', 1),
  (879, 41, 'Santa María', 1),
  (880, 13, 'Santa Rosa', 1),
  (881, 19, 'Santa Rosa', 1),
  (882, 66, 'Santa Rosa de Cabal', 1),
  (883, 5, 'Santa Rosa de Osos', 1),
  (884, 15, 'Santa Rosa de Viterbo', 1),
  (885, 13, 'Santa Rosa del Sur', 1),
  (886, 99, 'Santa Rosalía', 1),
  (887, 15, 'Santa Sofía', 1),
  (888, 15, 'Santana', 1),
  (889, 19, 'Santander de Quilichao', 1),
  (890, 54, 'Santiago', 1),
  (891, 86, 'Santiago', 1),
  (892, 5, 'Santo Domingo', 1),
  (893, 8, 'Santo Tomás', 1),
  (894, 5, 'Santuario', 1),
  (895, 66, 'Santuario', 1),
  (896, 52, 'Sapuyes', 1),
  (897, 81, 'Saravena', 1),
  (898, 54, 'Sardinata', 1),
  (899, 25, 'Sasaima', 1),
  (900, 15, 'Sativanorte', 1),
  (901, 15, 'Sativasur', 1),
  (902, 5, 'Segovia', 1),
  (903, 25, 'Sesquilé', 1),
  (904, 76, 'Sevilla', 1),
  (905, 15, 'Siachoque', 1),
  (906, 25, 'Sibaté', 1),
  (907, 86, 'Sibundoy', 1),
  (908, 54, 'Silos', 1),
  (909, 25, 'Silvania', 1),
  (910, 19, 'Silvia', 1),
  (911, 68, 'Simacota', 1),
  (912, 25, 'Simijaca', 1),
  (913, 13, 'Simití', 1),
  (914, 70, 'Sincelejo', 1),
  (915, 70, 'Sincé', 1),
  (916, 27, 'Sipí', 1),
  (917, 47, 'Sitionuevo', 1),
  (918, 25, 'Soacha', 1),
  (919, 15, 'Soatá', 1),
  (920, 15, 'Socha', 1),
  (921, 68, 'Socorro', 1),
  (922, 15, 'Socotá', 1),
  (923, 15, 'Sogamoso', 1),
  (924, 18, 'Solano', 1),
  (925, 8, 'Soledad', 1),
  (926, 18, 'Solita', 1),
  (927, 15, 'Somondoco', 1),
  (928, 5, 'Sonsón', 1),
  (929, 5, 'Sopetrán', 1),
  (930, 13, 'Soplaviento', 1),
  (931, 25, 'Sopó', 1),
  (932, 15, 'Sora', 1),
  (933, 15, 'Soracá', 1),
  (934, 15, 'Sotaquirá', 1),
  (935, 19, 'Sotara (Paispamba)', 1),
  (936, 52, 'Sotomayor (Los Andes)', 1),
  (937, 68, 'Suaita', 1),
  (938, 8, 'Suan', 1),
  (939, 41, 'Suaza', 1),
  (940, 25, 'Subachoque', 1),
  (941, 19, 'Sucre', 1),
  (942, 68, 'Sucre', 1),
  (943, 70, 'Sucre', 1),
  (944, 25, 'Suesca', 1),
  (945, 25, 'Supatá', 1),
  (946, 17, 'Supía', 1),
  (947, 68, 'Suratá', 1),
  (948, 25, 'Susa', 1),
  (949, 15, 'Susacón', 1),
  (950, 15, 'Sutamarchán', 1),
  (951, 25, 'Sutatausa', 1),
  (952, 15, 'Sutatenza', 1),
  (953, 19, 'Suárez', 1),
  (954, 73, 'Suárez', 1),
  (955, 85, 'Sácama', 1),
  (956, 15, 'Sáchica', 1),
  (957, 25, 'Tabio', 1),
  (958, 27, 'Tadó', 1),
  (959, 13, 'Talaigua Nuevo', 1),
  (960, 20, 'Tamalameque', 1),
  (961, 81, 'Tame', 1),
  (962, 52, 'Taminango', 1),
  (963, 52, 'Tangua', 1),
  (964, 97, 'Taraira', 1),
  (965, 5, 'Tarazá', 1),
  (966, 41, 'Tarqui', 1),
  (967, 5, 'Tarso', 1),
  (968, 15, 'Tasco', 1),
  (969, 85, 'Tauramena', 1),
  (970, 25, 'Tausa', 1),
  (971, 41, 'Tello', 1),
  (972, 25, 'Tena', 1),
  (973, 47, 'Tenerife', 1),
  (974, 25, 'Tenjo', 1),
  (975, 15, 'Tenza', 1),
  (976, 54, 'Teorama', 1),
  (977, 41, 'Teruel', 1),
  (978, 41, 'Tesalia', 1),
  (979, 25, 'Tibacuy', 1),
  (980, 15, 'Tibaná', 1),
  (981, 15, 'Tibasosa', 1),
  (982, 25, 'Tibirita', 1),
  (983, 54, 'Tibú', 1),
  (984, 23, 'Tierralta', 1),
  (985, 41, 'Timaná', 1),
  (986, 19, 'Timbiquí', 1),
  (987, 19, 'Timbío', 1),
  (988, 15, 'Tinjacá', 1),
  (989, 15, 'Tipacoque', 1),
  (990, 13, 'Tiquisio (Puerto Rico)', 1),
  (991, 5, 'Titiribí', 1),
  (992, 15, 'Toca', 1),
  (993, 25, 'Tocaima', 1),
  (994, 25, 'Tocancipá', 1),
  (995, 15, 'Toguí', 1),
  (996, 5, 'Toledo', 1),
  (997, 54, 'Toledo', 1),
  (998, 70, 'Tolú', 1),
  (999, 70, 'Tolú Viejo', 1),
  (1000, 68, 'Tona', 1),
  (1001, 15, 'Topagá', 1),
  (1002, 25, 'Topaipí', 1),
  (1003, 19, 'Toribío', 1),
  (1004, 76, 'Toro', 1),
  (1005, 15, 'Tota', 1),
  (1006, 19, 'Totoró', 1),
  (1007, 85, 'Trinidad', 1),
  (1008, 76, 'Trujillo', 1),
  (1009, 8, 'Tubará', 1),
  (1010, 23, 'Tuchín', 1),
  (1011, 76, 'Tulúa', 1),
  (1012, 52, 'Tumaco', 1),
  (1013, 15, 'Tunja', 1),
  (1014, 15, 'Tunungua', 1),
  (1015, 13, 'Turbaco', 1),
  (1016, 13, 'Turbaná', 1),
  (1017, 5, 'Turbo', 1),
  (1018, 15, 'Turmequé', 1),
  (1019, 15, 'Tuta', 1),
  (1020, 15, 'Tutasá', 1),
  (1021, 85, 'Támara', 1),
  (1022, 5, 'Támesis', 1),
  (1023, 52, 'Túquerres', 1),
  (1024, 25, 'Ubalá', 1),
  (1025, 25, 'Ubaque', 1),
  (1026, 25, 'Ubaté', 1),
  (1027, 76, 'Ulloa', 1),
  (1028, 25, 'Une', 1),
  (1029, 27, 'Unguía', 1),
  (1030, 27, 'Unión Panamericana (ÁNIMAS)', 1),
  (1031, 5, 'Uramita', 1),
  (1032, 50, 'Uribe', 1),
  (1033, 44, 'Uribia', 1),
  (1034, 5, 'Urrao', 1),
  (1035, 44, 'Urumita', 1),
  (1036, 8, 'Usiacuri', 1),
  (1037, 5, 'Valdivia', 1),
  (1038, 23, 'Valencia', 1),
  (1039, 68, 'Valle de San José', 1),
  (1040, 73, 'Valle de San Juan', 1),
  (1041, 86, 'Valle del Guamuez', 1),
  (1042, 20, 'Valledupar', 1),
  (1043, 5, 'Valparaiso', 1),
  (1044, 18, 'Valparaiso', 1),
  (1045, 5, 'Vegachí', 1),
  (1046, 73, 'Venadillo', 1),
  (1047, 5, 'Venecia', 1),
  (1048, 25, 'Venecia (Ospina Pérez)', 1),
  (1049, 15, 'Ventaquemada', 1),
  (1050, 25, 'Vergara', 1),
  (1051, 76, 'Versalles', 1),
  (1052, 68, 'Vetas', 1),
  (1053, 25, 'Viani', 1),
  (1054, 5, 'Vigía del Fuerte', 1),
  (1055, 76, 'Vijes', 1),
  (1056, 54, 'Villa Caro', 1),
  (1057, 19, 'Villa Rica', 1),
  (1058, 15, 'Villa de Leiva', 1),
  (1059, 54, 'Villa del Rosario', 1),
  (1060, 86, 'Villagarzón', 1),
  (1061, 25, 'Villagómez', 1),
  (1062, 73, 'Villahermosa', 1),
  (1063, 17, 'Villamaría', 1),
  (1064, 13, 'Villanueva', 1),
  (1065, 44, 'Villanueva', 1),
  (1066, 68, 'Villanueva', 1),
  (1067, 85, 'Villanueva', 1),
  (1068, 25, 'Villapinzón', 1),
  (1069, 73, 'Villarrica', 1),
  (1070, 50, 'Villavicencio', 1),
  (1071, 41, 'Villavieja', 1),
  (1072, 25, 'Villeta', 1),
  (1073, 25, 'Viotá', 1),
  (1074, 15, 'Viracachá', 1),
  (1075, 50, 'Vista Hermosa', 1),
  (1076, 17, 'Viterbo', 1),
  (1077, 68, 'Vélez', 1),
  (1078, 25, 'Yacopí', 1),
  (1079, 52, 'Yacuanquer', 1),
  (1080, 41, 'Yaguará', 1),
  (1081, 5, 'Yalí', 1),
  (1082, 5, 'Yarumal', 1),
  (1083, 5, 'Yolombó', 1),
  (1084, 5, 'Yondó (Casabe)', 1),
  (1085, 85, 'Yopal', 1),
  (1086, 76, 'Yotoco', 1),
  (1087, 76, 'Yumbo', 1),
  (1088, 13, 'Zambrano', 1),
  (1089, 68, 'Zapatoca', 1),
  (1090, 47, 'Zapayán (PUNTA DE PIEDRAS)', 1),
  (1091, 5, 'Zaragoza', 1),
  (1092, 76, 'Zarzal', 1),
  (1093, 15, 'Zetaquirá', 1),
  (1094, 25, 'Zipacón', 1),
  (1095, 25, 'Zipaquirá', 1),
  (1096, 47, 'Zona Bananera (PRADO - SEVILLA)', 1),
  (1097, 54, 'Ábrego', 1),
  (1098, 41, 'Íquira', 1),
  (1099, 15, 'Úmbita', 1),
  (1100, 25, 'Útica', 1);
  
  CREATE TABLE `outlet` (
    `id_outlet` int(11) NOT NULL,
    `producto_id` int(11) NOT NULL,
    `municipio_id` int(11) NOT NULL,
    `descuento` int(11) NOT NULL,
    `estado` int(11) NOT NULL,
    `create_at` datetime NOT NULL,
    `update_at` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `outlet` (`id_outlet`, `producto_id`, `municipio_id`, `descuento`, `estado`, `create_at`, `update_at`) VALUES
  (1, 1, 547, 25, 1, '2018-06-05 02:05:14', '2018-06-05 02:05:14');
  
  
  CREATE TABLE `pedido` (
    `id_pedido` int(11) NOT NULL,
    `producto_id` int(11) NOT NULL,
    `presentacion_id` int(11) NOT NULL,
    `precio_id` int(11) NOT NULL,
    `tendero_id` int(11) NOT NULL,
    `cantidad` int(11) NOT NULL,
    `fecha_pedido` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `pedido` (`id_pedido`, `producto_id`, `presentacion_id`, `precio_id`, `tendero_id`, `cantidad`, `fecha_pedido`) VALUES
  (1, 4, 6, 7, 2, 100, '2018-06-03 04:59:33'),
  (2, 6, 3, 2, 3, 20, '2018-06-05 03:42:50'),
  (3, 2, 6, 6, 3, 5, '2018-06-05 03:44:02');
  
  CREATE TABLE `precio` (
    `id_precio` int(11) NOT NULL,
    `precio` double NOT NULL,
    `estado` int(11) NOT NULL,
    `fecha_creacion` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `precio` (`id_precio`, `precio`, `estado`, `fecha_creacion`) VALUES
  (1, 4000, 1, '2018-06-03 02:58:49'),
  (2, 5300, 1, '2018-06-03 02:59:18'),
  (3, 3500, 1, '2018-06-03 02:59:29'),
  (4, 6000, 1, '2018-06-03 02:59:37'),
  (5, 4000, 1, '2018-06-03 02:59:46'),
  (6, 10000, 1, '2018-06-03 02:59:54'),
  (7, 18000, 1, '2018-06-03 03:00:12'),
  (8, 3000, 1, '2018-06-03 03:00:24'),
  (9, 5500, 1, '2018-06-03 03:00:35'),
  (10, 7500, 1, '2018-06-03 03:00:50'),
  (11, 18000, 1, '2018-06-03 04:58:41');
  
  CREATE TABLE `presentacion` (
    `id_presentacion` int(11) NOT NULL,
    `descripcion` varchar(100) DEFAULT NULL,
    `estado` int(11) DEFAULT NULL,
    `fecha_creacion` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `presentacion` (`id_presentacion`, `descripcion`, `estado`, `fecha_creacion`) VALUES
  (1, '300 gr', 1, '2018-06-02 08:08:00'),
  (2, '250 gr', 1, '2018-06-03 03:07:06'),
  (3, '500 gr', 1, '2018-06-03 03:07:17'),
  (4, '50 gr', 1, '2018-06-03 03:07:29'),
  (5, '150 gr', 1, '2018-06-03 03:07:39'),
  (6, '1000 gr', 1, '2018-06-03 03:07:51');
  
  CREATE TABLE `producto` (
    `id_producto` int(11) NOT NULL,
    `nombre` varchar(150) NOT NULL,
    `estado` int(11) NOT NULL,
    `fecha_creacion` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `producto` (`id_producto`, `nombre`, `estado`, `fecha_creacion`) VALUES
  (1, 'Chorizo', 1, '2018-06-03 02:47:21'),
  (2, 'Mortadela ', 1, '2018-06-03 02:47:51'),
  (3, 'Salami ', 1, '2018-06-03 02:48:01'),
  (4, 'Costilla', 1, '2018-06-03 02:48:11'),
  (5, 'Morcilla ', 1, '2018-06-03 02:48:22'),
  (6, 'Salchicha', 1, '2018-06-03 02:48:34'),
  (7, 'Salchichón', 1, '2018-06-03 02:48:44');
  
  CREATE TABLE `punto_venta` (
    `id_punto_venta` int(11) NOT NULL,
    `municipio_id` int(11) NOT NULL,
    `nombre` varchar(155) NOT NULL,
    `nit` varchar(45) NOT NULL,
    `direccion` varchar(155) DEFAULT NULL,
    `telefono` varchar(45) DEFAULT NULL,
    `barrio` varchar(250) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `punto_venta` (`id_punto_venta`, `municipio_id`, `nombre`, `nit`, `direccion`, `telefono`, `barrio`) VALUES
  (1, 532, 'La Economia', '1053810940', 'Cra 34 #64a - 34', '8745360', 'Santa Lucia'),
  (2, 547, 'La Vaquita', '9019283944', 'Cra 80 # 67 - 34', '8745360', 'La Floresta'),
  (3, 547, 'Súper Mercado Madrid', '1053810940', 'Cra 34 #64a - 34', '8745360', 'Robledo'),
  (4, 547, 'MercaZ', '9019283944', 'Cra 80 # 67 - 34', '8745360', 'La Floresta');
  
  CREATE TABLE `tendero` (
    `id_tendero` int(11) NOT NULL,
    `municipio_id` int(11) NOT NULL,
    `punto_venta_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `nombre` varchar(155) NOT NULL,
    `nit` varchar(45) NOT NULL,
    `direccion` varchar(45) NOT NULL,
    `telefono` varchar(45) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `tendero` (`id_tendero`, `municipio_id`, `punto_venta_id`, `user_id`, `nombre`, `nit`, `direccion`, `telefono`) VALUES
  (2, 532, 1, 1, 'Giovanny Franco Herrera', '1053810950', 'Cra 45 # 476-45', '8745360'),
  (3, 547, 3, 6, 'Gio Korn', '1053810940', 'Cra 45 # 476-45', '8745360');
  
  CREATE TABLE `tipo_usuario` (
    `id_tipo_usuario` int(11) NOT NULL,
    `tipo_usuario` varchar(100) NOT NULL,
    `estado` int(11) NOT NULL,
    `fecha_creacion` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `tipo_usuario` (`id_tipo_usuario`, `tipo_usuario`, `estado`, `fecha_creacion`) VALUES
  (1, 'ADMINISTRADOR', 1, '2018-06-01 00:00:00'),
  (2, 'CLIENTE', 1, '2018-06-04 00:00:00'),
  (3, 'TENDERO', 1, '2018-06-04 00:00:00'),
  (4, 'GERENTE', 1, '2018-06-04 00:00:00'),
  (5, 'REPRESENTANTE', 1, '2018-06-04 00:00:00');
  
  CREATE TABLE `user` (
    `id` int(11) NOT NULL,
    `municipio_id` int(11) NOT NULL,
    `tipo_usuario_id` int(11) NOT NULL,
    `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
    `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` smallint(6) NOT NULL DEFAULT '10',
    `nombre` varchar(155) COLLATE utf8_unicode_ci NOT NULL,
    `apellido` varchar(155) COLLATE utf8_unicode_ci NOT NULL,
    `cedula` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `direccion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `telefono` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` int(11) NOT NULL,
    `updated_at` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  INSERT INTO `user` (`id`, `municipio_id`, `tipo_usuario_id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `status`, `nombre`, `apellido`, `cedula`, `direccion`, `telefono`, `created_at`, `updated_at`) VALUES
  (1, 532, 1, 'gifrancohe', 'p0hBKTjerhoue-lNr3VlabukBJx4q18H', '$2y$13$7760lv2KXC4Iy.hmx0mQceE2JjzgAdmI0V8K/4BG2C04z.193f7cy', NULL, 'giovannyfrancoherrera@gmail.com', 10, 'Giovanny', 'Franco Herrera', '1053810940', 'Cra 90 #65 C -10', '8745360', 1527981626, 1528127061),
  (2, 532, 1, 'lfcruzs', 'UswKeNEV3FcEzy9aONyonvKAIkaxi8GA', '$2y$13$aCJTY0ZBAWpcX6Urhrj2suoB3gMvX9/xpCvo7QoYB6RFd/aDbffwe', NULL, 'lfcruzs@gmail.com', 10, 'Luisa', 'Cruz Soto', '1085929881', 'Cra 90 #65 C -10', '8745360', 1528062474, 1528062474),
  (3, 532, 1, 'santy', 'ZxAn0IHu_QfiScDXamtM7X_p9n5ZI8va', '$2y$13$vKjc3N2dKsezlXgzbCMQX.6VM5lZMLls1cLwTp2Ck8Hi8626REagO', NULL, 'geovanny-mao@hotmail.com', 10, 'Santiago', 'Escobar', '154879956', 'Cra 90 #65 C -10', '8745360', 1528062882, 1528062882),
  (4, 547, 2, 'gfrancoh', 'FuC-iou84e8pa3NVueGDCxhF7Q3h_tkq', '$2y$13$goRvQEV0W4j1BHe0IT9sPuQAFQdw9FwTOi2MrUyjVx97OmrjfxjQq', NULL, 'giovannyfranco@mattelsa.net', 10, 'Giovanny', 'Franco Herrera', '1053810940', 'Cra 90 #65 C -10', '8745360', 1528158379, 1528158379),
  (5, 107, 2, 'juliverde', 'mlpRQgg1EtSd8yi4pX6dAF0aoaIs5wLQ', '$2y$13$tODuwOu0MbgWiUYo8jQyzuePrXoYUTL/v8h8kUyYSs8PI16U7HgvC', NULL, 'gifrancohe@unal.edu.co', 10, 'Julian', 'Londoño Herrera', '1053810940', 'Cra 90 #65 C -10', '8745360', 1528158533, 1528158533),
  (6, 595, 3, 'giokorn', 'Ig01jjkQoSO68jnuwKFStli8752bWgs8', '$2y$13$3UQ4YdmSdLJ8c75dOjnCguI.7VdQWt7f2GAGUnnbo4QWyyEXPlEvu', NULL, 'luisafcs1992@hotmail.com', 10, 'Giovanny', 'Franco Herrera', '1053810940', 'Cra 90 #65 C -10', '8745360', 1528158826, 1528162467),
  (7, 547, 2, 'mercadeo', '3MD-TVyxqG_-Dh948KGt89k0e9dx86-6', '$2y$13$IvJeN/s7CZPZZ0V4oSwD1eAOlbwt07nYjH2/r.D0di/DP1B/IaKLi', NULL, 'mercadeo.item@gmail.com', 10, 'Giovanny', 'Franco Herrera', '1053810940', 'Cra 90 #65 C -10', '8745360', 1528159545, 1528159545);
  
  CREATE TABLE `venta` (
    `id_venta` int(11) NOT NULL,
    `tendero_id` int(11) NOT NULL,
    `producto_id` int(11) NOT NULL,
    `presentacion_id` int(11) NOT NULL,
    `precio_id` int(11) NOT NULL,
    `cantidad` int(11) NOT NULL,
    `fecha_venta` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `venta` (`id_venta`, `tendero_id`, `producto_id`, `presentacion_id`, `precio_id`, `cantidad`, `fecha_venta`) VALUES
  (1, 2, 1, 1, 1, 10, '2018-06-02 08:29:00'),
  (2, 2, 2, 3, 4, 12, '2018-06-02 08:29:00'),
  (3, 2, 4, 6, 7, 20, '2018-06-03 03:48:00'),
  (4, 2, 4, 6, 7, 5, '2018-06-03 03:48:00'),
  (5, 3, 6, 3, 2, 4, '2018-06-05 04:16:47');
  
  ALTER TABLE `cliente`
    ADD PRIMARY KEY (`id`),
    ADD KEY `fk_cliente_municipio1_idx` (`municipio_id`),
    ADD KEY `fk_cliente_user1_idx` (`user_id`),
    ADD KEY `fk_cliente_tendero1_idx` (`tendero_id`);
  
  
  ALTER TABLE `departamento`
    ADD PRIMARY KEY (`id_departamento`);
  
  ALTER TABLE `encuesta`
    ADD PRIMARY KEY (`id_encuesta`);
  
  
  ALTER TABLE `encuesta_usuario`
    ADD PRIMARY KEY (`id_encuesta_usuario`),
    ADD KEY `fk_encuesta_usuario_encuesta1_idx` (`encuesta_id`),
    ADD KEY `fk_encuesta_usuario_user1` (`usuario_id`);
  
  
  ALTER TABLE `migration`
    ADD PRIMARY KEY (`version`);
  
  
  ALTER TABLE `municipio`
    ADD PRIMARY KEY (`id_municipio`),
    ADD KEY `fk_municipio_departamento_idx` (`departamento_id`);
  
  
  ALTER TABLE `outlet`
    ADD PRIMARY KEY (`id_outlet`),
    ADD KEY `fk_outlet_producto1_idx` (`producto_id`),
    ADD KEY `fk_outlet_municipio1_idx` (`municipio_id`);
  
  ALTER TABLE `pedido`
    ADD PRIMARY KEY (`id_pedido`),
    ADD KEY `fk_pedido_producto1_idx` (`producto_id`),
    ADD KEY `fk_pedido_presentacion1_idx` (`presentacion_id`),
    ADD KEY `fk_pedido_precio1_idx` (`precio_id`),
    ADD KEY `fk_pedido_tendero1_idx` (`tendero_id`);
  
  
  ALTER TABLE `precio`
    ADD PRIMARY KEY (`id_precio`);
  
  ALTER TABLE `presentacion`
    ADD PRIMARY KEY (`id_presentacion`);
  
  
  ALTER TABLE `producto`
    ADD PRIMARY KEY (`id_producto`);
  
  
  ALTER TABLE `punto_venta`
    ADD PRIMARY KEY (`id_punto_venta`),
    ADD KEY `fk_punto_venta_municipio1_idx` (`municipio_id`);
  
  ALTER TABLE `tendero`
    ADD PRIMARY KEY (`id_tendero`),
    ADD KEY `fk_tendero_municipio1_idx` (`municipio_id`),
    ADD KEY `fk_tendero_punto_venta1_idx` (`punto_venta_id`),
    ADD KEY `fk_tendero_user1_idx` (`id_tendero`) USING BTREE;
  
  ALTER TABLE `tipo_usuario`
    ADD PRIMARY KEY (`id_tipo_usuario`);
  
  ALTER TABLE `user`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `username` (`username`),
    ADD UNIQUE KEY `email` (`email`),
    ADD UNIQUE KEY `password_reset_token` (`password_reset_token`),
    ADD KEY `fk_usuario_municipio1_idx` (`municipio_id`),
    ADD KEY `fk_usuario_tipo_usuario1_idx` (`tipo_usuario_id`);
  
  
  ALTER TABLE `venta`
    ADD PRIMARY KEY (`id_venta`),
    ADD KEY `fk_venta_tendero1_idx` (`tendero_id`),
    ADD KEY `fk_venta_producto1_idx` (`producto_id`),
    ADD KEY `fk_venta_presentacion1_idx` (`presentacion_id`),
    ADD KEY `fk_venta_precio1_idx` (`precio_id`);
  
  
  ALTER TABLE `cliente`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  ALTER TABLE `departamento`
    MODIFY `id_departamento` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;
  
  ALTER TABLE `encuesta`
    MODIFY `id_encuesta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  
  ALTER TABLE `encuesta_usuario`
    MODIFY `id_encuesta_usuario` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
  
  
  ALTER TABLE `municipio`
    MODIFY `id_municipio` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1101;
  
  
  ALTER TABLE `outlet`
    MODIFY `id_outlet` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  
  ALTER TABLE `pedido`
    MODIFY `id_pedido` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  
  ALTER TABLE `precio`
    MODIFY `id_precio` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  
  
  ALTER TABLE `presentacion`
    MODIFY `id_presentacion` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  
  ALTER TABLE `producto`
    MODIFY `id_producto` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  
  ALTER TABLE `punto_venta`
    MODIFY `id_punto_venta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  
  ALTER TABLE `tendero`
    MODIFY `id_tendero` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  
  ALTER TABLE `tipo_usuario`
    MODIFY `id_tipo_usuario` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  
  ALTER TABLE `user`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  
  ALTER TABLE `venta`
    MODIFY `id_venta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  
  ALTER TABLE `cliente`
    ADD CONSTRAINT `fk_cliente_municipio1` FOREIGN KEY (`municipio_id`) REFERENCES `municipio` (`id_municipio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_cliente_tendero1` FOREIGN KEY (`tendero_id`) REFERENCES `tendero` (`id_tendero`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_cliente_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  ALTER TABLE `encuesta_usuario`
    ADD CONSTRAINT `fk_encuesta_usuario_encuesta1` FOREIGN KEY (`encuesta_id`) REFERENCES `encuesta` (`id_encuesta`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_encuesta_usuario_user1` FOREIGN KEY (`usuario_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  ALTER TABLE `municipio`
    ADD CONSTRAINT `fk_municipio_departamento` FOREIGN KEY (`departamento_id`) REFERENCES `departamento` (`id_departamento`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  ALTER TABLE `outlet`
    ADD CONSTRAINT `fk_outlet_municipio1` FOREIGN KEY (`municipio_id`) REFERENCES `municipio` (`id_municipio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_outlet_producto1` FOREIGN KEY (`producto_id`) REFERENCES `producto` (`id_producto`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  ALTER TABLE `pedido`
    ADD CONSTRAINT `fk_pedido_precio1` FOREIGN KEY (`precio_id`) REFERENCES `precio` (`id_precio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_pedido_presentacion1` FOREIGN KEY (`presentacion_id`) REFERENCES `presentacion` (`id_presentacion`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_pedido_producto1` FOREIGN KEY (`producto_id`) REFERENCES `producto` (`id_producto`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_pedido_tendero1` FOREIGN KEY (`tendero_id`) REFERENCES `tendero` (`id_tendero`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  ALTER TABLE `punto_venta`
    ADD CONSTRAINT `fk_punto_venta_municipio1` FOREIGN KEY (`municipio_id`) REFERENCES `municipio` (`id_municipio`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  ALTER TABLE `tendero`
    ADD CONSTRAINT `fk_tendero_municipio1` FOREIGN KEY (`municipio_id`) REFERENCES `municipio` (`id_municipio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_tendero_punto_venta1` FOREIGN KEY (`punto_venta_id`) REFERENCES `punto_venta` (`id_punto_venta`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  ALTER TABLE `user`
    ADD CONSTRAINT `fk_user_municipio1` FOREIGN KEY (`municipio_id`) REFERENCES `municipio` (`id_municipio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_user_tipo_usuario1` FOREIGN KEY (`tipo_usuario_id`) REFERENCES `tipo_usuario` (`id_tipo_usuario`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  ALTER TABLE `venta`
    ADD CONSTRAINT `fk_venta_precio1` FOREIGN KEY (`precio_id`) REFERENCES `precio` (`id_precio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_venta_presentacion1` FOREIGN KEY (`presentacion_id`) REFERENCES `presentacion` (`id_presentacion`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_venta_producto1` FOREIGN KEY (`producto_id`) REFERENCES `producto` (`id_producto`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_venta_tendero1` FOREIGN KEY (`tendero_id`) REFERENCES `tendero` (`id_tendero`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  COMMIT;
  