CREATE DATABASE `area` ;
--
-- Estructura de tabla para la tabla `departamento`
--
CREATE TABLE `departamento` (
`Iddepartamento` int(4) NOT NULL auto_increment,
`departamento` varchar(50) NOT NULL,
PRIMARY KEY (`Iddepartamento`),
UNIQUE KEY `departamento` (`departamento`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
--
-- Volcar la base de datos para la tabla `departamento`
--
INSERT INTO `departamento` (`Iddepartamento`, `departamento`) VALUES
(15, 'Neembucú'),
(1, 'Alto Paraguay'),
(2, 'Alto Paraná'),
(3, 'Amambay'),
(4, 'Asunción Capital'),
(5, 'Boquerón'),
(6, 'Caaguazú'),
(7, 'Caazapá'),
(8, 'Canindeyú'),
(9, 'Central'),
(10, 'Concepción'),
(11, 'Cordillera'),
(12, 'Guairá'),
(13, 'Itapua'),
(14, 'Misiones'),
(16, 'Paraguarí'),
(17, 'Presidente Hayes'),
(18, 'San Pedro');
--
-- Estructura de tabla para la tabla `ciudad`
--
CREATE TABLE `ciudad` (
`Idciudad` int(10) NOT NULL auto_increment,
`Iddepartamento` varchar(4) NOT NULL,
`Ciudad` varchar(50) NOT NULL,
PRIMARY KEY (`Idciudad`),
UNIQUE KEY `Iddepartamento` (`Iddepartamento`,`Ciudad`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=226 ;
--
-- Volcar la base de datos para la tabla `ciudad`
--
INSERT INTO `ciudad` (`Idciudad`, `Iddepartamento`, `Ciudad`) VALUES
(1, '1', 'Fuerte Olimpo'),
(2, '1', 'Puerto Casado'),
(86, '10', 'Belén'),
(87, '10', 'Concepción Capital'),
(88, '10', 'Horqueta'),
(89, '10', 'Loreto'),
(90, '10', 'San Lázaro'),
(91, '10', 'Yby Yau'),
(92, '11', 'Altos'),
(93, '11', 'Arroyos y Esteros'),
(94, '11', 'Atyrá'),
(95, '11', 'Caacupé'),
(96, '11', 'Caraguatay'),
(97, '11', 'Emboscada'),
(98, '11', 'Eusebio Ayala'),
(99, '11', 'Isla Pucú'),
(100, '11', 'Itacurubí de la Cordillera'),
(101, '11', 'Juan de Mena'),
(102, '11', 'Loma Grande'),
(103, '11', 'Mbocayaty del Yhaguy'),
(104, '11', 'Nueva Comlombia'),
(105, '11', 'Piribebuy'),
(106, '11', 'Primero de Marzo'),
(107, '11', 'San Bernardino'),
(108, '11', 'San José Obrero'),
(109, '11', 'Santa Elena'),
(110, '11', 'Tobatí'),
(111, '11', 'Valenzuela'),
(112, '12', 'Borja'),
(113, '12', 'Capitán Mauricio José Troche'),
(114, '12', 'Coronel Martinez'),
(115, '12', 'Doctor Botrell'),
(116, '12', 'Féliz Pérez Cardozo'),
(117, '12', 'General Eugenio A. Garay'),
(118, '12', 'Independencia'),
(119, '12', 'Itapé'),
(120, '12', 'Iturbe'),
(121, '12', 'José Fassardi'),
(122, '12', 'Mbocayaty del Guairá'),
(123, '12', 'Natalicio Talavera'),
(124, '12', 'Ñumi'),
(125, '12', 'Paso Yobai'),
(126, '12', 'San Salvador'),
(127, '12', 'Villarrica'),
(128, '12', 'Yataity del Guairá'),
(129, '13', 'Alto Verá'),
(130, '13', 'Bella Vista'),
(131, '13', 'Cambyretá'),
(132, '13', 'Capitán Meza'),
(133, '13', 'Capitán Miranda'),
(134, '13', 'Carlos Antonio López'),
(135, '13', 'Carmen del Paraná'),
(136, '13', 'Coronel Bogado'),
(137, '13', 'Edelira'),
(138, '13', 'Encarnación'),
(139, '13', 'Fram'),
(140, '13', 'General Artigas'),
(141, '13', 'General Delgado'),
(142, '13', 'Hohenau'),
(143, '13', 'Itapúa Poty'),
(144, '13', 'Jesús'),
(145, '13', 'José Leandro Oviedo'),
(146, '13', 'La Paz'),
(147, '13', 'Mayor Julio D. Otaño'),
(148, '13', 'Natalio'),
(149, '13', 'Nueva Alborada'),
(150, '13', 'Obligado'),
(151, '13', 'Pirapó'),
(152, '13', 'San Cosme y Damiá'),
(153, '13', 'San Juan del Paraná'),
(154, '13', 'San Pedro del Paraná'),
(155, '13', 'San Rafael del Paraná'),
(156, '13', 'Tomás Romero Pereira'),
(157, '13', 'Trinidad'),
(158, '13', 'Yatytay'),
(159, '14', 'Ayolas'),
(160, '14', 'San Ignacio'),
(161, '14', 'San Juan Bautista'),
(162, '14', 'San Miguel'),
(163, '14', 'San Patricio'),
(164, '14', 'Santa María'),
(165, '14', 'Santa Rosa'),
(166, '14', 'Santiago'),
(167, '14', 'Villa Florida'),
(168, '14', 'Yabebyry'),
(169, '15', 'Alberdi'),
(170, '15', 'Cerrito'),
(171, '15', 'Desmochados'),
(172, '15', 'General José E. Díaz'),
(173, '15', 'Guazú Cuá'),
(174, '15', 'Humaitá'),
(175, '15', 'Isla Umbú'),
(176, '15', 'Laureles'),
(177, '15', 'Mayor José Dejesús Martínez'),
(178, '15', 'Paso de Patria'),
(179, '15', 'Pilar'),
(180, '15', 'San Juan Bautista de Ñeembucú'),
(181, '15', 'Tacuaras'),
(182, '15', 'Villa Franca'),
(183, '15', 'Villa Oliva'),
(184, '15', 'Villalbín'),
(185, '16', 'Acahay'),
(186, '16', 'Caapucú'),
(187, '16', 'Caballero'),
(188, '16', 'Carapeguá'),
(189, '16', 'Escobar'),
(190, '16', 'La Colmena'),
(191, '16', 'Mbuyapey'),
(192, '16', 'Paraguarí Capital'),
(193, '16', 'Pirayú'),
(194, '16', 'Quiindy'),
(195, '16', 'Quyquyhó'),
(196, '16', 'San Roque G. de Santa Cruz'),
(197, '16', 'Sapucai'),
(198, '16', 'Tebicuarymí'),
(199, '16', 'Yaguarón'),
(200, '16', 'Ybycuí'),
(201, '16', 'Ybytimí'),
(202, '17', 'Benjamín Aceval'),
(203, '17', 'Mariano Roque Alonso'),
(204, '17', 'Nanawa'),
(205, '17', 'Nueva Esperanza'),
(206, '17', 'Puerto José Falcón'),
(207, '17', 'Puerto Pinasco'),
(208, '17', 'Villa Hayes'),
(209, '18', '25 de Diciembre'),
(210, '18', 'Antequera'),
(211, '18', 'Capiibary'),
(212, '18', 'Choré'),
(213, '18', 'General Elizardo Aquino'),
(214, '18', 'General Francisco I. Resquín'),
(215, '18', 'Guajayvi'),
(216, '18', 'Itacurubí del Rosario'),
(217, '18', 'Lima'),
(218, '18', 'Nueva Germania'),
(219, '18', 'San Estanislao'),
(220, '18', 'San Pablo'),
(221, '18', 'San Pedro Capital'),
(222, '18', 'Tacuatí'),
(223, '18', 'Unión'),
(224, '18', 'Villa del Rosario'),
(225, '18', 'Yataity del Norte'),
(3, '2', 'Ciudad del Este'),
(4, '2', 'Domingo Martínez de Irala'),
(5, '2', 'Dr. Juan León Malloquín'),
(6, '2', 'Hernandaríaz'),
(7, '2', 'Iruña'),
(8, '2', 'Itakyry'),
(9, '2', 'Juan Emilio O''Leary'),
(10, '2', 'Los Cedrales'),
(11, '2', 'Mbaracayú'),
(12, '2', 'Minga Guazú'),
(13, '2', 'Minga Porá'),
(14, '2', 'Ñacunday'),
(15, '2', 'Naranjal'),
(16, '2', 'Presidente Franco'),
(17, '2', 'San Alberto'),
(18, '2', 'San Cristóbal'),
(19, '2', 'Santa Rita'),
(20, '2', 'Santa Rosa del Monday'),
(21, '2', 'Yguazú'),
(22, '3', 'Bella vista'),
(23, '3', 'Capitan Bado'),
(24, '3', 'Pedro juan Caballero'),
(25, '4', 'Asunción Capital'),
(26, '5', 'Mcal. Jose Felix Estigarribia'),
(27, '6', '3 de Febrero'),
(28, '6', 'Caaguazú'),
(29, '6', 'Carayaó'),
(30, '6', 'Coronel Oviedo'),
(31, '6', 'Dr. Cecilio Báez'),
(32, '6', 'Dr. J. Eulogio Estigarribia'),
(33, '6', 'Dr. Juan Manuel Frutos'),
(34, '6', 'José Domingo Ocampos'),
(35, '6', 'La Pastora'),
(36, '6', 'Mcal. Francisco Solano López'),
(37, '6', 'Nueva Londres'),
(38, '6', 'R.I. 3 Corrales'),
(39, '6', 'Raúl Arsenio Oviedo'),
(40, '6', 'Repatriación'),
(41, '6', 'San Joaquín'),
(42, '6', 'San José de los Arroyos'),
(43, '6', 'Santa Rosa del Mbutuy'),
(44, '6', 'Simón Bolivar'),
(45, '6', 'Vaquería'),
(46, '6', 'Yhú'),
(47, '7', 'Abaí'),
(48, '7', 'Buena Vista'),
(49, '7', 'Caazapá Capital'),
(50, '7', 'Dr. Moisés S. Bertoni'),
(51, '7', 'General Higinio Morínigo'),
(52, '7', 'Maciel'),
(53, '7', 'San Juan Nemopuceno'),
(54, '7', 'Tavaí'),
(55, '7', 'Yegros'),
(56, '7', 'Yuty'),
(57, '8', 'Corpus Chisti'),
(58, '8', 'Curuguaty'),
(59, '8', 'Francisco Caballero Alvarez'),
(60, '8', 'Itanará'),
(61, '8', 'Katuete'),
(62, '8', 'La Paloma'),
(63, '8', 'Salto del Guairá'),
(64, '8', 'Villa Curuguaty'),
(65, '8', 'Villa Ygatimi'),
(66, '8', 'Ypejhú'),
(67, '9', 'Areguá'),
(68, '9', 'Capiatá'),
(69, '9', 'Fernando de la Mora'),
(70, '9', 'Guarambaré'),
(71, '9', 'Itá'),
(72, '9', 'Itauguá'),
(73, '9', 'José Augusto Saldivar'),
(74, '9', 'Lambaré'),
(75, '9', 'Limpio'),
(76, '9', 'Luque'),
(77, '9', 'Mariano Roque Alonso'),
(78, '9', 'Ñemby'),
(79, '9', 'Nueva Italia'),
(80, '9', 'San Antonio'),
(81, '9', 'San Lorenzo'),
(82, '9', 'Villa Elisa'),
(83, '9', 'Villeta'),
(84, '9', 'Ypané'),
(85, '9', 'Yparacaí');