swad-core/sql/places.sql

-- MySQL dump 10.13  Distrib 5.1.73, for redhat-linux-gnu (x86_64)
--
-- Host: localhost    Database: swad
-- ------------------------------------------------------
-- Server version	5.1.73-log

/*!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 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 */;

--
-- Table structure for table `places`
--

DROP TABLE IF EXISTS `places`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `places` (
  `PlcCod` int(11) NOT NULL AUTO_INCREMENT,
  `InsCod` int(11) NOT NULL,
  `ShortName` varchar(511) NOT NULL,
  `FullName` varchar(2047) NOT NULL,
  UNIQUE KEY `PlcCod` (`PlcCod`),
  KEY `InsCod` (`InsCod`)
) ENGINE=MyISAM AUTO_INCREMENT=1183 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `places`
--

LOCK TABLES `places` WRITE;
/*!40000 ALTER TABLE `places` DISABLE KEYS */;
INSERT INTO `places` VALUES (1,1,'Granada','Granada'),(2,1,'Ceuta','Ceuta'),(3,1,'Melilla','Melilla'),(7,23829,'Valencia','Valencia'),(8,436,'San Lorenzo','San Lorenzo'),(9,1195,'NUEVO LAREDO','NUEVO LAREDO'),(10,1195,'REYNOSA','REYNOSA'),(11,1195,'RÍO BRAVO','RÍO BRAVO'),(12,1195,'VALLE HERMOSO','VALLE HERMOSO'),(13,1195,'MATAMOROS','MATAMOROS'),(14,1195,'VICTORIA','VICTORIA'),(15,1195,'MANTE','MANTE'),(16,1195,'TAMPICO MADERO','TAMPICO MADERO'),(18,999,'Granada','Granada'),(19,23831,'Monterrey','Monterrey'),(20,23835,'San Miguel de Tucumán','San Miguel de Tucumán, Argentina'),(21,23836,'Asunción','Asunción'),(22,23842,'Cali','Santiago de Cali'),(23,23843,'St. Gallen','St. Gallen'),(24,23845,'Oberá','Oberá'),(25,23845,'Posadas','Posadas'),(26,23845,'Corrientes','Corrientes'),(27,23845,'Formosa','Formosa'),(28,23845,'Resistencia','Resistencia'),(29,218,'Antofagasta','Antofagasta'),(30,218,'La Serena','La Serena'),(31,218,'Chillán','Chillán'),(32,218,'Santiago','Santiago'),(33,23851,'Chetumal Quintana Roo','Chetumal Quintana Roo'),(34,23853,'La Serena (Chile)','La Serena (Chile)'),(35,23856,'San Miguel de Tucumán','San Miguel de Tucumán, Argentina'),(36,23857,'Mendoza','Mendoza (Argentina)'),(37,4099,'Ambato','Ambato'),(38,427,'Villeta','Villeta'),(39,23867,'Villeta','Villeta'),(40,4082,'Riobamba','Riobamba'),(41,4071,'Riobamba','Riobamba'),(42,23873,'San Miguel','San Miguel'),(43,23874,'Quito','Quito'),(44,678,'Caracas','Caracas'),(45,23875,'Corrientes','Corrientes'),(46,23881,'Tacna','Tacna'),(47,190,'Piura','Piura'),(48,148,'Piura','Piura'),(49,144,'Lima','Lima'),(50,3694,'Bogotá','Bogotá'),(51,3694,'Chapinero','Chapinero'),(52,674,'Maturín','Maturín'),(53,674,'Turmero','Turmero'),(54,23883,'Quevedo','Quevedo'),(55,23886,'Mera','Mera'),(56,23887,'Bogotá','Bogotá'),(57,23888,'Quito','Quito'),(58,23882,'Ambato','Ambato'),(59,82,'Loja','Loja'),(60,23889,'Quito','Quito'),(61,23890,'Trujillo','Trujillo'),(62,23891,'Pitalito','Pitalito'),(63,1144,'Valencia','Valencia'),(64,1229,'Oaxaca','Oaxaca'),(65,672,'Caracas','Caracas'),(66,23896,'Tacna','Tacna'),(67,3731,'Apartadó','Apartadó'),(68,23876,'Monterrey','Monterrey'),(69,23897,'San Pablo Etla','San Pablo Etla'),(70,4078,'Guayaquil','Guayaquil'),(71,4108,'Guayaquil','Guayaquil'),(72,23901,'Rabinal','Rabinal'),(73,3736,'Bucaramanga','Bucaramanga'),(74,23905,'Trujillo','Trujillo'),(75,1189,'Guanajuato','Guanajuato'),(76,23904,'Pintag','Pintag'),(77,4079,'Guaranda','Guaranda'),(78,677,'Guayana','Guayana'),(79,4158,'Antigua Guatemala','Antigua Guatemala'),(80,4158,'Ciudad de Guatemala','Ciudad de Guatemala'),(81,23908,'Bogotá','Bogotá'),(82,23909,'Otavalo','Otavalo'),(83,674,'Vega de la Pipa','Vega de la Pipa'),(84,121,'Concepción','Concepción'),(85,665,'Naguanagua','Naguanagua'),(86,665,'Maracay','Maracay'),(87,4060,'Quito','Quito'),(88,699,'Puerto La Cruz','Puerto La Cruz'),(89,699,'Ciudad Guayana','Ciudad Guayana'),(90,699,'Maturín','Maturín'),(91,699,'Nueva Esparta','Nueva Esparta'),(92,699,'Cumaná','Cumaná'),(93,3770,'Bogotá','Bogotá'),(94,3770,'Medellín','Medellín'),(95,3770,'Pereira','Pereira'),(96,3770,'Valledupar','Valledupar'),(97,710,'Maracaibo','Maracaibo'),(98,23910,'Maracaibo','Maracaibo'),(99,23911,'Oruro','Oruro'),(100,23912,'Tabacundo','Tabacundo'),(101,415,'Asunción','Asunción'),(102,3986,'San José','San José'),(103,3986,'Cartago','Cartago'),(104,3986,'Heredia','Heredia'),(105,23913,'Tocachi','Tocachi'),(106,4210,'Santa Bárbara','Santa Bárbara'),(107,23915,'Mompox','Mompox'),(108,3939,'Moñitos','Moñitos, Córdoba'),(109,23917,'Santa Cruz de la Sierra','Santa Cruz de la Sierra'),(110,23924,'Mar del Plata','Mar del Plata'),(111,23922,'Tixán','Tixán'),(112,23925,'Valencia','Valencia'),(113,655,'Sucre','Sucre'),(114,675,'Caracas','Caracas'),(115,294,'Malang','Malang'),(116,23930,'Ambato','Ambato'),(117,23931,'Sonsonate','Sonsonate'),(118,23932,'Amsterdam','Amsterdam'),(119,4103,'Esmeraldas','Esmeraldas'),(120,2222,'Teresina','Teresina'),(121,691,'San Juan de los Morros','San Juan de los Morros'),(122,23938,'San Diego','San 
/*!40000 ALTER TABLE `places` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 on 2020-03-08 19:04:43