0FDj9ZUK

1/*
2Wea con las comunas, provincias y regiones.
3*/
4
5
6SET NAMES utf8;
7
8SET SQL_MODE='';
9
10create database if not exists `regiones`;
11
12USE `regiones`;
13
14SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
15SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
16
17/*Table structure for table `comunas` */
18
19DROP TABLE IF EXISTS `comunas`;
20
21CREATE TABLE `comunas` (
22`id_region` int(11) default NULL,
23`id_provincia` int(11) default NULL,
24`id_comuna` int(11) default NULL,
25`comuna` varchar(250) default NULL
26) ENGINE=MyISAM DEFAULT CHARSET=latin1;
27
28/*Data for the table `comunas` */
29
30insert into `comunas`(`id_region`,`id_provincia`,`id_comuna`,` comuna`) values (1,1,1,'el elqui'),(1,1,1,'Alto Hospicio'),(1,1,2,'Iquique'),(1,53,3,'Camiña'),(1, 53,4,'Colchane'),(1,53,5,'Huara'),(1,53,6,'Pica'), (1,53,7,'Pozo Almonte'),(2,4,12,'Antofagasta'),(2,4,13,'Mejillon es'),(2,4,14,'Sierra Gorda'),(2,4,15,'Taltal'),(2,5,16,'Calama'),(2,5,1 7,'Ollagüe'),(2,5,18,'San Pedro de Atacama'),(2,6,19,'María Elena'),(2,6,20,'Tocopilla'),(3,7,21,'Chañaral'),( 3,7,22,'Diego de Almagro'),(3,8,23,'Caldera'),(3,8,24,'Copiapó'),(3 ,8,25,'Tierra Amarilla'),(3,9,26,'Alto del Carmen'),(3,9,27,'Freirina'),(3,9,28,'Huasco'),(3, 9,29,'Vallenar'),(4,10,30,'Canela'),(4,10,31,'Illa pel'),(4,10,32,'Los Vilos'),(4,10,33,'Salamanca'),(4,11,34,'Andacollo' ),(4,11,35,'Coquimbo'),(4,11,36,'La Higuera'),(4,11,37,'La Serena'),(4,11,38,'Paihuano'),(4,11,39,'Vicuña'),( 4,12,40,'Combarbalá'),(4,12,41,'Monte Patria'),(4,12,42,'Ovalle'),(4,12,43,'Punitaqui'), (4,12,44,'Río Hurtado'),(5,13,45,'Isla de Pascua'),(5,14,46,'Calle Larga'),(5,14,47,'Los Andes'),(5,14,48,'Rinconada'),(5,14,49,'San Esteban'),(5,15,50,'Cabildo'),(5,15,51,'La Ligua'),(5,15,52,'Papudo'),(5,15,53,'Petorca'),(5, 15,54,'Zapallar'),(5,16,55,'Hijuelas'),(5,16,56,'L a Calera'),(5,16,57,'La Cruz'),(5,16,58,'Limache'),(5,16,59,'Nogales'),(5, 16,60,'Olmué'),(5,16,61,'Quillota'),(5,17,62,'Alga rrobo'),(5,17,63,'Cartagena'),(5,17,64,'El Quisco'),(5,17,65,'El Tabo'),(5,17,66,'San Antonio'),(5,17,67,'Santo Domingo'),(5,18,68,'Catemu'),(5,18,69,'Llaillay'), (5,18,70,'Panquehue'),(5,18,71,'Putaendo'),(5,18,7 2,'San Felipe'),(5,18,73,'Santa María'),(5,19,74,'Casablanca'),(5,19,75,'Concón'), (5,19,76,'Juan Fernández'),(5,19,77,'Puchuncaví'),(5,19,78,'Quilp ué'),(5,19,79,'Quintero'),(5,19,80,'Valparaíso'),( 5,19,81,'Villa Alemana'),(5,19,82,'Viña del Mar'),(6,26,135,'Codegua'),(6,26,136,'Coínco'),(6, 26,137,'Coltauco'),(6,26,138,'Doñihue'),(6,26,139, 'Graneros'),(6,26,140,'Las Cabras'),(6,26,141,'Machalí'),(6,26,142,'Malloa'), (6,26,143,'Mostazal'),(6,26,144,'Olivar'),(6,26,14 5,'Peumo'),(6,26,146,'Pichidegua'),(6,26,147,'Quin ta de Tilcoco'),(6,26,148,'Rancagua'),(6,26,149,'Rengo') ,(6,26,150,'Requínoa'),(6,26,151,'San Vicente de Tagua Tagua'),(6,27,152,'La Estrella'),(6,27,153,'Litueche'),(6,27,154,'Marchi hue'),(6,27,155,'Navidad'),(6,27,156,'Paredones'), (6,27,157,'Pichilemu'),(6,28,158,'Chépica'),(6,28, 159,'Chimbarongo'),(6,28,160,'Lolol'),(6,28,161,'N ancagua'),(6,28,162,'Palmilla'),(6,28,163,'Peralil lo'),(6,28,164,'Placilla'),(6,28,165,'Pumanque'),( 6,28,166,'San Fernando'),(6,28,167,'Santa Cruz'),(7,29,168,'Cauquenes'),(7,29,169,'Chanco'), (7,29,170,'Pelluhue'),(7,30,171,'Curicó'),(7,30,17 2,'Hualañé'),(7,30,173,'Licantén'),(7,30,174,'Moli na'),(7,30,175,'Rauco'),(7,30,176,'Romeral'),(7,30 ,177,'Sagrada Familia'),(7,30,178,'Teno'),(7,30,179,'Vichuquén') ,(7,31,180,'Colbún'),(7,31,181,'Linares'),(7,31,18 2,'Longaví'),(7,31,183,'Parral'),(7,31,184,'Retiro '),(7,31,185,'San Javier'),(7,31,186,'Villa Alegre'),(7,31,187,'Yerbas Buenas'),(7,32,188,'Constitución'),(7,32,189,'Cure pto'),(7,32,190,'Empedrado'),(7,32,191,'Maule'),(7 ,32,192,'Pelarco'),(7,32,193,'Pencahue'),(7,32,194 ,'Río Claro'),(7,32,195,'San Clemente'),(7,32,196,'San Rafael'),(7,32,197,'Talca'),(8,33,198,'Arauco'),(8 ,33,199,'Cañete'),(8,33,200,'Contulmo'),(8,33,201, 'Curanilahue'),(8,33,202,'Lebu'),(8,33,203,'Los Álamos'),(8,33,204,'Tirúa'),(8,34,205,'Alto Biobío'),(8,34,206,'Antuco'),(8,34,207,'Cabrero'), (8,34,208,'Laja'),(8,34,209,'Los Ángeles'),(8,34,210,'Mulchén'),(8,34,211,'Nacimien to'),(8,34,212,'Negrete'),(8,34,213,'Quilaco'),(8, 34,214,'Quilleco'),(8,34,215,'San Rosendo'),(8,34,216,'Santa Bárbara'),(8,34,217,'Tucapel'),(8,34,218,'Yumbel') ,(8,35,219,'Chiguayante'),(8,35,220,'Concepción'), (8,35,221,'Coronel'),(8,35,222,'Florida'),(8,35,22 3,'Hualpén'),(8,35,224,'Hualqui'),(8,35,225,'Lota' ),(8,35,226,'Penco'),(8,35,227,'San Pedro de la Paz'),(8,35,228,'Santa Juana'),(8,35,229,'Talcahuano'),(8,35,230,'Tomé'), (8,36,231,'Bulnes'),(8,36,232,'Chillán'),(8,36,233 ,'Chillán Viejo'),(8,36,234,'Cobquecura'),(8,36,235,'Coelemu '),(8,36,236,'Coihueco'),(8,36,237,'El Carmen'),(8,36,238,'Ninhue'),(8,36,239,'Ñiquén'),( 8,36,240,'Pemuco'),(8,36,241,'Pinto'),(8,36,242,'P ortezuelo'),(8,36,243,'Quillón'),(8,36,244,'Quirih ue'),(8,36,245,'Ránquil'),(8,36,246,'San Carlos'),(8,36,247,'San Fabián'),(8,36,248,'San Ignacio'),(8,36,249,'San Nicolás'),(8,36,250,'Treguaco'),(8,36,251,'Yungay' ),(9,37,252,'Carahue'),(9,37,253,'Cholchol'),(9,37 ,254,'Cunco'),(9,37,255,'Curarrehue'),(9,37,256,'F reire'),(9,37,257,'Galvarino'),(9,37,258,'Gorbea') ,(9,37,259,'Lautaro'),(9,37,260,'Loncoche'),(9,37, 261,'Melipeuco'),(9,37,262,'Nueva Imperial'),(9,37,263,'Padre Las Casas'),(9,37,264,'Perquenco'),(9,37,265,'Pitrufqu én'),(9,37,266,'Pucón'),(9,37,267,'Saavedra'),(9,3 7,268,'Temuco'),(9,37,269,'Teodoro Schmidt'),(9,37,270,'Toltén'),(9,37,271,'Vilcún'), (9,37,272,'Villarrica'),(9,38,273,'Angol'),(9,38,2 74,'Collipulli'),(9,38,275,'Curacautín'),(9,38,276 ,'Ercilla'),(9,38,277,'Lonquimay'),(9,38,278,'Los Sauces'),(9,38,279,'Lumaco'),(9,38,280,'Purén'),(9 ,38,281,'Renaico'),(9,38,282,'Traiguén'),(9,38,283 ,'Victoria'),(10,40,296,'Ancud'),(10,40,297,'Castr o'),(10,40,298,'Chonchi'),(10,40,299,'Curaco de Vélez'),(10,40,300,'Dalcahue'),(10,40,301,'Puqueld ón'),(10,40,302,'Queilén'),(10,40,303,'Quemchi'),( 10,40,304,'Quellón'),(10,40,305,'Quinchao'),(10,41 ,306,'Calbuco'),(10,41,307,'Cochamó'),(10,41,308,' Fresia'),(10,41,309,'Frutillar'),(10,41,310,'Llanq uihue'),(10,41,311,'Los Muermos'),(10,41,312,'Maullín'),(10,41,313,'Puerto Montt'),(10,41,314,'Puerto Varas'),(10,42,315,'Osorno'),(10,42,316,'Puerto Octay'),(10,42,317,'Purranque'),(10,42,318,'Puyehu e'),(10,42,319,'Río Negro'),(10,42,320,'San Juan de la Costa'),(10,42,321,'San Pablo'),(10,43,322,'Chaitén'),(10,43,323,'Futaleuf ú'),(10,43,324,'Hualaihué'),(10,43,325,'Palena'),( 11,44,326,'Aisén'),(11,44,327,'Cisnes'),(11,44,328 ,'Guaitecas'),(11,45,329,'Cochrane'),(11,45,330,'O ´Higgins'),(11,45,331,'Tortel'),(11,46,332,'Coihai que'),(11,46,333,'Lago Verde'),(11,47,334,'Chile Chico'),(11,47,335,'Río Ibañez'),(12,48,336,'Antártica'),(12,48,337,'Cabo de Hornos'),(12,49,338,'Laguna Blanca'),(12,49,339,'Punta Arenas'),(12,49,340,'Río Verde'),(12,49,341,'San Gregorio'),(12,50,342,'Porvenir'),(12,50,343,'Prim avera'),(12,50,344,'Timaukel'),(12,51,345,'Puerto Natales'),(12,51,346,'Torres del Paine'),(13,20,83,'Colina'),(13,20,84,'Lampa'),(13 ,20,85,'Tiltil'),(13,21,86,'Pirque'),(13,21,87,'Pu ente Alto'),(13,21,88,'San José de Maipo'),(13,22,89,'Buin'),(13,22,90,'Calera de Tango'),(13,22,91,'Paine'),(13,22,92,'San Bernardo'),(13,23,93,'Alhué'),(13,23,94,'Curacaví' ),(13,23,95,'María Pinto'),(13,23,96,'Melipilla'),(13,23,97,'San Pedro'),(13,24,98,'Cerrillos'),(13,24,99,'Cerro Navia'),(13,24,100,'Conchalí'),(13,24,101,'El Bosque'),(13,24,102,'Estación Central'),(13,24,103,'Huechuraba'),(13,24,104,'Ind ependencia'),(13,24,105,'La Cisterna'),(13,24,106,'La Granja'),(13,24,107,'La Florida'),(13,24,108,'La Pintana'),(13,24,109,'La Reina'),(13,24,110,'Las Condes'),(13,24,111,'Lo Barnechea'),(13,24,112,'Lo Espejo'),(13,24,113,'Lo Prado'),(13,24,114,'Macul'),(13,24,115,'Maipú'),(1 3,24,116,'Ñuñoa'),(13,24,117,'Pedro Aguirre Cerda'),(13,24,118,'Peñalolén'),(13,24,119,'Provid encia'),(13,24,120,'Pudahuel'),(13,24,121,'Quilicu ra'),(13,24,122,'Quinta Normal'),(13,24,123,'Recoleta'),(13,24,124,'Renca' ),(13,24,125,'San Miguel'),(13,24,126,'San Joaquín'),(13,24,127,'San Ramón'),(13,24,128,'Santiago'),(13,24,129,'Vitacur a'),(13,25,130,'El Monte'),(13,25,131,'Isla de Maipo'),(13,25,132,'Padre Hurtado'),(13,25,133,'Peñaflor'),(13,25,134,'Talag ante'),(14,39,284,'Corral'),(14,39,285,'Lanco'),(1 4,39,286,'Los Lagos'),(14,39,287,'Máfil'),(14,39,288,'Paillaco') ,(14,39,289,'Panguipulli'),(14,39,290,'San José de la Mariquina'),(14,39,291,'Valdivia'),(14,52,292,'Fut rono'),(14,52,293,'La Unión'),(14,52,294,'Lago Ranco'),(14,52,295,'Río Bueno'),(15,2,8,'arica'),(15,2,9,'Camarones'),(15, 3,10,'General Lagos'),(15,3,11,'Putre');
31
32/*Table structure for table `provincias` */
33
34DROP TABLE IF EXISTS `provincias`;
35
36CREATE TABLE `provincias` (
37`id_region` int(11) default NULL,
38`id_provincia` int(11) default NULL,
39`provincia` varchar(250) default NULL,
40`capital` varchar(250) default NULL
41) ENGINE=MyISAM DEFAULT CHARSET=latin1;
42
43/*Data for the table `provincias` */
44
45insert into `provincias`(`id_region`,`id_provincia`,`provincia `,`capital`) values (1,1,'Iquique','Iquique'),(1,53,'Tamarugal','Pozo Almonte'),(2,4,'Antofagasta','Antofagasta'),(2,5,' El Loa','Calama'),(2,6,'Tocopilla','Tocopilla'),(3,7, 'Chañaral','Chañaral'),(3,8,'Copiapó','Copiapó'),( 3,9,'Huasco','Vallenar'),(4,10,'Choapa','Illapel') ,(4,11,'Elqui','Coquimbo'),(4,12,'Limarí','Ovalle' ),(5,13,'Isla de Pascua','Hanga Roa'),(5,14,'Los Andes','Los Andes'),(5,15,'Petorca','La Ligua'),(5,16,'Quillota','Quillota'),(5,17,'San Antonio','San Antonio'),(5,18,'San Felipe de Aconcagua','San Felipe'),(5,19,'Valparaíso','Valparaíso'),(6,26,'C achapoal','Rancagua'),(6,27,'Cardenal Caro','Pichilemu'),(6,28,'Colchagua','San Fernando'),(7,29,'Cauquenes','Cauquenes'),(7,30,'C uricó','Curicó'),(7,31,'Linares','Linares'),(7,32, 'Talca','Talca'),(8,33,'Arauco','Lebu'),(8,34,'Bio bío','Los Ángeles'),(8,35,'Concepción','Concepción'),(8,36,' Ñuble','Chillán'),(9,37,'Cautín','Temuco'),(9,38,' Malleco','Angol'),(10,40,'Chiloé','Castro'),(10,41 ,'Llanquihue','Puerto Montt'),(10,42,'Osorno','Osorno'),(10,43,'Palena', 'Chaitén'),(11,44,'Aisén','Puerto Aisén'),(11,45,'Capitán Prat','Cochrane'),(11,46,'Coihaique','Coihaique'), (11,47,'General Carrera','Chile Chico'),(12,48,'Antártica Chilena','Puerto Williams'),(12,49,'Magallanes','Punta Arenas'),(12,50,'Tierra del Fuego','Porvenir'),(12,51,'Última Esperanza','Puerto Natales'),(13,20,'Chacabuco','Colina'),(13,21,'Cor dillera','Puente Alto'),(13,22,'Maipo','San Bernardo'),(13,23,'Melipilla','Melipilla'),(13,24, 'Santiago','Santiago'),(13,25,'Talagante','Talagan te'),(14,39,'Valdivia','Valdivia'),(14,52,'Ranco', 'La Unión'),(15,2,'Arica','Arica'),(15,3,'Parinacota', 'Putre');
46
47/*Table structure for table `regiones` */
48
49DROP TABLE IF EXISTS `regiones`;
50
51CREATE TABLE `regiones` (
52`id_pais` int(11) default NULL,
53`id_region` int(11) default NULL,
54`numero` varchar(4) default NULL,
55`region` varchar(250) default NULL,
56`capital` varchar(250) default NULL
57) ENGINE=MyISAM DEFAULT CHARSET=latin1;
58
59/*Data for the table `regiones` */
60
61insert into `regiones`(`id_pais`,`id_region`,`numero`,`region` ,`capital`) values (1,1,'I','Tarapacá','Iquique'),(1,2,'II','Antofaga sta','Antofagasta'),(1,3,'III','Atacama','Copiapó' ),(1,4,'IV','Coquimbo','La Serena'),(1,5,'V','Valparaíso','Valparaíso'),(1,6, 'VI','Libertador General Bernardo O\'Higgins','Rancagua'),(1,7,'VII','Maule','Talca' ),(1,8,'VIII','Biobío','Concepción'),(1,9,'IX','La Araucanía','Temuco'),(1,10,'X','Los Lagos','Puerto Montt'),(1,11,'XI','Aisén del General Carlos Ibáñez del Campo','Coihaique'),(1,12,'XII','Magallanes y de la Antártica Chilena','Punta Arenas'),(1,13,'RM','Región Metropolitana de Santiago','Santiago'),(1,14,'XIV','De los Ríos','Valdivia'),(1,15,'XV','Arica Parinacota','Arica');
62
63SET SQL_MODE=@OLD_SQL_MODE;
64SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;