Regiones Provincias y Comunas Chile en SQL

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

CREATE TABLE `comunas` (
`id` int NOT NULL,
`comuna` varchar(250) CHARACTER SET utf8mb4 DEFAULT NULL,
`region_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Volcado de datos para la tabla `comunas`
--
INSERT INTO `comunas` (`id`, `comuna`, `region_id`) VALUES
(1, 'Arica', 1),
(2, 'Camarones', 1),
(3, 'General Lagos', 1),
(4, 'Putre', 1),
(5, 'Alto Hospicio', 2),
(6, 'Iquique', 2),
(7, 'Camiña', 2),
(8, 'Colchane', 2),
(9, 'Huara', 2),
(10, 'Pica', 2),
(11, 'Pozo Almonte', 2),
(12, 'Tocopilla', 3),
(13, 'María Elena', 3),
(14, 'Calama', 3),
(15, 'Ollague', 3),
(16, 'San Pedro de Atacama', 3),
(17, 'Antofagasta', 3),
(18, 'Mejillones', 3),
(19, 'Sierra Gorda', 3),
(20, 'Taltal', 3),
(21, 'Chañaral', 4),
(22, 'Diego de Almagro', 4),
(23, 'Copiapó', 4),
(24, 'Caldera', 4),
(25, 'Tierra Amarilla', 4),
(26, 'Vallenar', 4),
(27, 'Alto del Carmen', 4),
(28, 'Freirina', 4),
(29, 'Huasco', 4),
(30, 'La Serena', 5),
(31, 'Coquimbo', 5),
(32, 'Andacollo', 5),
(33, 'La Higuera', 5),
(34, 'Paihuano', 5),
(35, 'Vicuña', 5),
(36, 'Ovalle', 5),
(37, 'Combarbalá', 5),
(38, 'Monte Patria', 5),
(39, 'Punitaqui', 5),
(40, 'Río Hurtado', 5),
(41, 'Illapel', 5),
(42, 'Canela', 5),
(43, 'Los Vilos', 5),
(44, 'Salamanca', 5),
(45, 'La Ligua', 6),
(46, 'Cabildo', 6),
(47, 'Zapallar', 6),
(48, 'Papudo', 6),
(49, 'Petorca', 6),
(50, 'Los Andes', 6),
(51, 'San Esteban', 6),
(52, 'Calle Larga', 6),
(53, 'Rinconada', 6),
(54, 'San Felipe', 6),
(55, 'Llaillay', 6),
(56, 'Putaendo', 6),
(57, 'Santa María', 6),
(58, 'Catemu', 6),
(59, 'Panquehue', 6),
(60, 'Quillota', 6),
(61, 'La Cruz', 6),
(62, 'La Calera', 6),
(63, 'Nogales', 6),
(64, 'Hijuelas', 6),
(65, 'Valparaíso', 6),
(66, 'Viña del Mar', 6),
(67, 'Concón', 6),
(68, 'Quintero', 6),
(69, 'Puchuncaví', 6),
(70, 'Casablanca', 6),
(71, 'Juan Fernández', 6),
(72, 'San Antonio', 6),
(73, 'Cartagena', 6),
(74, 'El Tabo', 6),
(75, 'El Quisco', 6),
(76, 'Algarrobo', 6),
(77, 'Santo Domingo', 6),
(78, 'Isla de Pascua', 6),
(79, 'Quilpué', 6),
(80, 'Limache', 6),
(81, 'Olmué', 6),
(82, 'Villa Alemana', 6),
(83, 'Colina', 7),
(84, 'Lampa', 7),
(85, 'Tiltil', 7),
(86, 'Santiago', 7),
(87, 'Vitacura', 7),
(88, 'San Ramón', 7),
(89, 'San Miguel', 7),
(90, 'San Joaquín', 7),
(91, 'Renca', 7),
(92, 'Recoleta', 7),
(93, 'Quinta Normal', 7),
(94, 'Quilicura', 7),
(95, 'Pudahuel', 7),
(96, 'Providencia', 7),
(97, 'Peñalolén', 7),
(98, 'Pedro Aguirre Cerda', 7),
(99, 'Ñuñoa', 7),
(100, 'Maipú', 7),
(101, 'Macul', 7),
(102, 'Lo Prado', 7),
(103, 'Lo Espejo', 7),
(104, 'Lo Barnechea', 7),
(105, 'Las Condes', 7),
(106, 'La Reina', 7),
(107, 'La Pintana', 7),
(108, 'La Granja', 7),
(109, 'La Florida', 7),
(110, 'La Cisterna', 7),
(111, 'Independencia', 7),
(112, 'Huechuraba', 7),
(113, 'Estación Central', 7),
(114, 'El Bosque', 7),
(115, 'Conchalí', 7),
(116, 'Cerro Navia', 7),
(117, 'Cerrillos', 7),
(118, 'Puente Alto', 7),
(119, 'San José de Maipo', 7),
(120, 'Pirque', 7),
(121, 'San Bernardo', 7),
(122, 'Buin', 7),
(123, 'Paine', 7),
(124, 'Calera de Tango', 7),
(125, 'Melipilla', 7),
(126, 'Alhué', 7),
(127, 'Curacaví', 7),
(128, 'María Pinto', 7),
(129, 'San Pedro', 7),
(130, 'Isla de Maipo', 7),
(131, 'El Monte', 7),
(132, 'Padre Hurtado', 7),
(133, 'Peñaflor', 7),
(134, 'Talagante', 7),
(135, 'Codegua', 8),
(136, 'Coínco', 8),
(137, 'Coltauco', 8),
(138, 'Doñihue', 8),
(139, 'Graneros', 8),
(140, 'Las Cabras', 8),
(141, 'Machalí', 8),
(142, 'Malloa', 8),
(143, 'Mostazal', 8),
(144, 'Olivar', 8),
(145, 'Peumo', 8),
(146, 'Pichidegua', 8),
(147, 'Quinta de Tilcoco', 8),
(148, 'Rancagua', 8),
(149, 'Rengo', 8),
(150, 'Requínoa', 8),
(151, 'San Vicente de Tagua Tagua', 8),
(152, 'Chépica', 8),
(153, 'Chimbarongo', 8),
(154, 'Lolol', 8),
(155, 'Nancagua', 8),
(156, 'Palmilla', 8),
(157, 'Peralillo', 8),
(158, 'Placilla', 8),
(159, 'Pumanque', 8),
(160, 'San Fernando', 8),
(161, 'Santa Cruz', 8),
(162, 'La Estrella', 8),
(163, 'Litueche', 8),
(164, 'Marchigüe', 8),
(165, 'Navidad', 8),
(166, 'Paredones', 8),
(167, 'Pichilemu', 8),
(168, 'Curicó', 9),
(169, 'Hualañé', 9),
(170, 'Licantén', 9),
(171, 'Molina', 9),
(172, 'Rauco', 9),
(173, 'Romeral', 9),
(174, 'Sagrada Familia', 9),
(175, 'Teno', 9),
(176, 'Vichuquén', 9),
(177, 'Talca', 9),
(178, 'San Clemente', 9),
(179, 'Pelarco', 9),
(180, 'Pencahue', 9),
(181, 'Maule', 9),
(182, 'San Rafael', 9),
(183, 'Curepto', 9),
(184, 'Constitución', 9),
(185, 'Empedrado', 9),
(186, 'Río Claro', 9),
(187, 'Linares', 9),
(188, 'San Javier', 9),
(189, 'Parral', 9),
(190, 'Villa Alegre', 9),
(191, 'Longaví', 9),
(192, 'Colbún', 9),
(193, 'Retiro', 9),
(194, 'Yerbas Buenas', 9),
(195, 'Cauquenes', 9),
(196, 'Chanco', 9),
(197, 'Pelluhue', 9),
(198, 'Bulnes', 10),
(199, 'Chillán', 10),
(200, 'Chillán Viejo', 10),
(201, 'El Carmen', 10),
(202, 'Pemuco', 10),
(203, 'Pinto', 10),
(204, 'Quillón', 10),
(205, 'San Ignacio', 10),
(206, 'Yungay', 10),
(207, 'Cobquecura', 10),
(208, 'Coelemu', 10),
(209, 'Ninhue', 10),
(210, 'Portezuelo', 10),
(211, 'Quirihue', 10),
(212, 'Ránquil', 10),
(213, 'Treguaco', 10),
(214, 'San Carlos', 10),
(215, 'Coihueco', 10),
(216, 'San Nicolás', 10),
(217, 'Ñiquén', 10),
(218, 'San Fabián', 10),
(219, 'Alto Biobío', 11),
(220, 'Antuco', 11),
(221, 'Cabrero', 11),
(222, 'Laja', 11),
(223, 'Los Ángeles', 11),
(224, 'Mulchén', 11),
(225, 'Nacimiento', 11),
(226, 'Negrete', 11),
(227, 'Quilaco', 11),
(228, 'Quilleco', 11),
(229, 'San Rosendo', 11),
(230, 'Santa Bárbara', 11),
(231, 'Tucapel', 11),
(232, 'Yumbel', 11),
(233, 'Concepción', 11),
(234, 'Coronel', 11),
(235, 'Chiguayante', 11),
(236, 'Florida', 11),
(237, 'Hualpén', 11),
(238, 'Hualqui', 11),
(239, 'Lota', 11),
(240, 'Penco', 11),
(241, 'San Pedro de La Paz', 11),
(242, 'Santa Juana', 11),
(243, 'Talcahuano', 11),
(244, 'Tomé', 11),
(245, 'Arauco', 11),
(246, 'Cañete', 11),
(247, 'Contulmo', 11),
(248, 'Curanilahue', 11),
(249, 'Lebu', 11),
(250, 'Los Álamos', 11),
(251, 'Tirúa', 11),
(252, 'Angol', 12),
(253, 'Collipulli', 12),
(254, 'Curacautín', 12),
(255, 'Ercilla', 12),
(256, 'Lonquimay', 12),
(257, 'Los Sauces', 12),
(258, 'Lumaco', 12),
(259, 'Purén', 12),
(260, 'Renaico', 12),
(261, 'Traiguén', 12),
(262, 'Victoria', 12),
(263, 'Temuco', 12),
(264, 'Carahue', 12),
(265, 'Cholchol', 12),
(266, 'Cunco', 12),
(267, 'Curarrehue', 12),
(268, 'Freire', 12),
(269, 'Galvarino', 12),
(270, 'Gorbea', 12),
(271, 'Lautaro', 12),
(272, 'Loncoche', 12),
(273, 'Melipeuco', 12),
(274, 'Nueva Imperial', 12),
(275, 'Padre Las Casas', 12),
(276, 'Perquenco', 12),
(277, 'Pitrufquén', 12),
(278, 'Pucón', 12),
(279, 'Saavedra', 12),
(280, 'Teodoro Schmidt', 12),
(281, 'Toltén', 12),
(282, 'Vilcún', 12),
(283, 'Villarrica', 12),
(284, 'Valdivia', 13),
(285, 'Corral', 13),
(286, 'Lanco', 13),
(287, 'Los Lagos', 13),
(288, 'Máfil', 13),
(289, 'Mariquina', 13),
(290, 'Paillaco', 13),
(291, 'Panguipulli', 13),
(292, 'La Unión', 13),
(293, 'Futrono', 13),
(294, 'Lago Ranco', 13),
(295, 'Río Bueno', 13),
(296, 'Osorno', 14),
(297, 'Puerto Octay', 14),
(298, 'Purranque', 14),
(299, 'Puyehue', 14),
(300, 'Río Negro', 14),
(301, 'San Juan de la Costa', 14),
(302, 'San Pablo', 14),
(303, 'Calbuco', 14),
(304, 'Cochamó', 14),
(305, 'Fresia', 14),
(306, 'Frutillar', 14),
(307, 'Llanquihue', 14),
(308, 'Los Muermos', 14),
(309, 'Maullín', 14),
(310, 'Puerto Montt', 14),
(311, 'Puerto Varas', 14),
(312, 'Ancud', 14),
(313, 'Castro', 14),
(314, 'Chonchi', 14),
(315, 'Curaco de Vélez', 14),
(316, 'Dalcahue', 14),
(317, 'Puqueldón', 14),
(318, 'Queilén', 14),
(319, 'Quellón', 14),
(320, 'Quemchi', 14),
(321, 'Quinchao', 14),
(322, 'Chaitén', 14),
(323, 'Futaleufú', 14),
(324, 'Hualaihué', 14),
(325, 'Palena', 14),
(326, 'Lago Verde', 15),
(327, 'Coihaique', 15),
(328, 'Aysén', 15),
(329, 'Cisnes', 15),
(330, 'Guaitecas', 15),
(331, 'Río Ibáñez', 15),
(332, 'Chile Chico', 15),
(333, 'Cochrane', 15),
(334, 'O\'Higgins', 15),
(335, 'Tortel', 15),
(336, 'Natales', 16),
(337, 'Torres del Paine', 16),
(338, 'Laguna Blanca', 16),
(339, 'Punta Arenas', 16),
(340, 'Río Verde', 16),
(341, 'San Gregorio', 16),
(342, 'Porvenir', 16),
(343, 'Primavera', 16),
(344, 'Timaukel', 16),
(345, 'Cabo de Hornos', 16),
(346, 'Antártica', 16);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `regiones`
--
CREATE TABLE `regiones` (
`id` int NOT NULL,
`region` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
--
-- Volcado de datos para la tabla `regiones`
--
INSERT INTO `regiones` (`id`, `region`) VALUES
(1, 'Arica y Parinacota'),
(2, 'Tarapacá'),
(3, 'Antofagasta'),
(4, 'Atacama'),
(5, 'Coquimbo'),
(6, 'Valparaiso'),
(7, 'Metropolitana de Santiago'),
(8, 'Libertador General Bernardo O\'Higgins'),
(9, 'Maule'),
(10, 'Ñuble'),
(11, 'Biobío'),
(12, 'La Araucanía'),
(13, 'Los Ríos'),
(14, 'Los Lagos'),
(15, 'Aysén del General Carlos Ibáñez del Campo'),
(16, 'Magallanes y de la Antártica Chilena');
--
-- Índices para tablas volcadas
--
--
-- Indices de la tabla `comunas`
--
ALTER TABLE `comunas`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `regiones`
--
ALTER TABLE `regiones`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT de las tablas volcadas
--
--
-- AUTO_INCREMENT de la tabla `comunas`
--
ALTER TABLE `comunas`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=347;
--
-- AUTO_INCREMENT de la tabla `regiones`
--
ALTER TABLE `regiones`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;