-- MySQL dump 10.13  Distrib 8.0.17, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: escola
-- ------------------------------------------------------
-- Server version	5.7.26

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `contract_variables`
INSERT INTO `cidades` (`id`, `nome`, `estado_id`) VALUES
(5300109,'Ciudad del Este',55),
(5300110,'Presidente Franco',55),
(5300111,'Minga Guazú',55),
(5300112,'Hernandarias',55),
(5300113,'Itakyry',55),
(5300114,'Santa Rita',55),
(5300115,"Juan Emilio O'Leary",55),
(5300116,'Doctor Juan León Mallorquín',55),
(5300117,'Pedro Juan Caballero',59),
(5300118,'Capitán Bado',59),
(5300119,'Bella Vista Norte',59),
(5300120,'Mariscal José Félix Estigarribia',70),
(5300121,'Filadelfia',70),
(5300122,'Caaguazú',58),
(5300123,'Coronel Oviedo',58),
(5300124,'Doctor Juan Eulogio Estigarribia',58),
(5300125,'Yhú',58),
(5300126,'Repatriación',58),
(5300127,'Doctor Juan Manuel Frutos',58),
(5300128,'San José de los Arroyos',58),
(5300129,'San Joaquín',58),
(5300130,'Raúl Arsenio Oviedo',58),
(5300131,'San Juan Nepomuceno',67),
(5300132,'Abaí',67),
(5300133,'Caazapá',67),
(5300134,'Yuty',67),
(5300135,'Tres de Mayo',67),
(5300136,'Tavaí',67),
(5300137,'Curuguaty',63),
(5300138,'Salto del Guairá',63),
(5300139,'Yasy Cañy',63),
(5300140,'Villa Ygatimí',63),
(5300141,'Luque',56),
(5300142,'San Lorenzo',56),
(5300143,'Capiatá',56),
(5300144,'Lambaré',56),
(5300145,'Fernando de la Mora',56),
(5300146,'Limpio',56),
(5300147,'Ñemby',56),
(5300148,'Itauguá',56),
(5300149,'Mariano Roque Alonso',56),
(5300150,'Itá',56),
(5300151,'Villa Elisa',56),
(5300152,'Areguá',56),
(5300153,'San Antonio',56),
(5300154,'Julián Augusto Saldívar',56),
(5300155,'Ypané',56),
(5300156,'Villeta',56),
(5300157,'Guarambaré',56),
(5300158,'Ypacaraí',56),
(5300159,'Concepción',60),
(5300160,'Horqueta',60),
(5300161,'Yby Yaú',60),
(5300162,'Loreto',60),
(5300163,'Caacupé',62),
(5300164,'Tobatí',62),
(5300165,'Piribebuy',62),
(5300166,'Arroyos y Esteros',62),
(5300167,'Eusebio Ayala',62),
(5300168,'Emboscada',62),
(5300169,'Atyrá',62),
(5300170,'Assunção',54),
(5300171,'Villarrica',61),
(5300172,'Independencia',61),
(5300173,'Paso Yobái',61),
(5300174,'Encarnación',57),
(5300175,'Cambyretá',57),
(5300176,'San Pedro del Paraná',57),
(5300177,'Tomás Romero Pereira',57),
(5300178,'Edelira',57),
(5300179,'San Rafael del Paraná',57),
(5300180,'Natalio',57),
(5300181,'Coronel José Félix Bogado',57),
(5300182,'Carlos Antonio López',57),
(5300183,'Alto Verá',57),
(5300184,'Obligado',57),
(5300185,'Itapúa Poty',57),
(5300186,'San Ignacio Guazú',65),
(5300187,'San Juan Bautista',65),
(5300188,'Ayolas',65),
(5300189,'Santa Rosa de Lima',65),
(5300190,'Pilar',69),
(5300191,'Carapeguá',68),
(5300192,'Yaguarón',68),
(5300193,'Ybycuí',68),
(5300194,'Paraguarí',68),
(5300195,'Quiindy',68),
(5300196,'Pirayú',68),
(5300197,'Villa Hayes',66),
(5300198,'Teniente Primero Manuel Irala Fernández',66),
(5300199,'Benjamín Aceval',66),
(5300200,'San Estanislao',64),
(5300201,'Capiibary',64),
(5300202,'Santa Rosa del Aguaray',64),
(5300203,'San Pedro de Ycuamandiyú',64),
(5300204,'Guayaibí',64),
(5300205,'Choré',64),
(5300206,'General Isidoro Resquín',64),
(5300207,'Liberación',64),
(5300208,'General Elizardo Aquino',64),
(5300210, 'Cruce Guaraní', 63),
(5300211, 'Ybyrarobana', 63),
(5300212, 'Corpus Christi', 63),
(5300213, 'General Francisco Caballero Álvares', 63),
(5300214, 'Itanará', 63),
(5300215, 'Katueté', 63),
(5300216, 'La Paloma', 63),
(5300217, 'Nueva Esperanza', 63),
(5300218, 'Puerto Adela', 63),
(5300219, 'Ypejhú', 63),
(5300220, 'Yby Pytá', 63),
(5300221, 'Domingo Martínez de Irala', 55),
(5300222, 'Los Cedrales', 55),
(5300223, 'Mbaracayú', 55),
(5300224, 'Minga Porá', 55),
(5300225, 'Naranjal', 55),
(5300226, 'Ñacunday', 55),
(5300227, 'San Alberto', 55),
(5300228, 'San Cristóbal', 55),
(5300229, 'Santa Fe del Paraná', 55),
(5300230, 'Santa Rosa del Monday', 55),
(5300231, 'Yguazú', 55),
(5300232, 'Tavapy', 55),
(5300233, 'Doctor Raul Peña', 55),
(5300234, 'Iruña', 55),
(5300235, 'Arroyito', 60),
(5300236, 'Azotey', 60),
(5300237, 'Belén', 60),
(5300238, 'Paso Barreto', 60),
(5300239, 'San Alfredo', 60),
(5300240, 'San Carlos del Apa', 60),
(5300241, 'San Lázaro', 60),
(5300242, 'Sargento José Félix López', 60),
(5300243, 'Paso Horqueta', 60),
(5300244, 'Itacuá', 60);

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed