Jump to content
@Balthazar

SQL - Pais, Region y Ciudad de Chile.

Recommended Posts

Estimado mi colaboracion a la causa, Para gente de Chile les dejo mi compocicion.

Si alguien tiene la de transporte se lo agradeceria.

Item 1 - Pais

INSERT INTO `ps_country` (`id_country`, `id_zone`, `id_currency`, `iso_code`, `call_prefix`, `active`, `contains_states`, `need_identification_number`, `need_zip_code`, `zip_code_format`, `display_tax_label`) VALUES
(1, 13, 0, 'CL', 56, 1, 0, 0, 1, 'NNNNNNN', 1);

Item 2 -- Regiones

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(1, 'I Tarapacá', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(2, 'II Antofagasta', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(3, 'III Atacama', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(4, 'IV Coquimbo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(5, 'V Valparaíso', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(6, 'VI Libertador General Bernardo O''Higgins', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(7, 'VII Maule', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(8, 'VIII Bío - Bío', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(9, 'IX Araucanía', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(10, 'X Los Lagos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(11, 'XI Aysén del General Carlos Ibáñez del Campo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(12, 'XII Magallanes y de la Antártica Chilena', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(13, 'RM - Región Metropolitana', 1);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(14, 'XIV Los Ríos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(15, 'XV Arica y Parinacota', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(16, 'XVI Nuble', 0);

Item 3 - Regiones y Ciudades

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(1, 'I Tarapacá', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Iquique", "01101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Alto Hospicio", "01107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Pozo Almonte", "01401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Camiña", "01402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Colchane", "01403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Huara", "01404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Pica", "01405", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(2, 'II Antofagasta', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Antofagasta", "02101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Mejillones", "02102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Sierra Gorda", "02103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Taltal", "02104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Calama", "02201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Ollagüe", "02202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "San Pedro de Atacama", "02203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Tocopilla", "02301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "María Elena", "02302", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(3, 'III Atacama', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Copiapó", "03101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Caldera", "03102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Tierra Amarilla", "03103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Chañaral", "03201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Diego de Almagro", "03202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Vallenar", "03301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Alto del Carmen", "03302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Freirina", "03303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Huasco", "03304", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(4, 'IV Coquimbo', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "La Serena", "04101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Coquimbo", "04102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Andacollo", "04103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "La Higuera", "04104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Paiguano", "04105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Vicuña", "04106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Illapel", "04201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Canela", "04202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Los Vilos", "04203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Salamanca", "04204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Ovalle", "04301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Combarbalá", "04302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Monte Patria", "04303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Punitaqui", "04304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Río Hurtado", "04305", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(5, 'V Valparaíso', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Valparaíso", "05101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Casablanca", "05102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Concón", "05103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Juan Fernández", "05104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Puchuncaví", "05105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Quintero", "05107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Viña del Mar", "05109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Isla de Pascua", "05201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Los Andes", "05301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Calle Larga", "05302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Rinconada", "05303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "San Esteban", "05304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "La Ligua", "05401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Cabildo", "05402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Papudo", "05403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Petorca", "05404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Zapallar", "05405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Quillota", "05501", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Calera", "05502", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Hijuelas", "05503", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "La Cruz", "05504", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Nogales", "05506", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "San Antonio", "05601", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Algarrobo", "05602", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Cartagena", "05603", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "El Quisco", "05604", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "El Tabo", "05605", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Santo Domingo", "05606", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "San Felipe", "05701", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Catemu", "05702", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Llaillay", "05703", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Panquehue", "05704", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Putaendo", "05705", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Santa María", "05706", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Quilpué", "05801", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Limache", "05802", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Olmué", "05803", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Villa Alemana", "05804", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(6, 'VI Libertador General Bernardo O''Higgins', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Rancagua", "06101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Codegua", "06102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Coinco", "06103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Coltauco", "06104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Doñihue", "06105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Graneros", "06106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Las Cabras", "06107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Machalí", "06108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Malloa", "06109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Mostazal", "06110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Olivar", "06111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Peumo", "06112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Pichidegua", "06113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Quinta de Tilcoco", "06114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Rengo", "06115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Requínoa", "06116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "San Vicente", "06117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Pichilemu", "06201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "La Estrella", "06202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Litueche", "06203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Marchihue", "06204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Navidad", "06205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Paredones", "06206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "San Fernando", "06301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Chépica", "06302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Chimbarongo", "06303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Lolol", "06304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Nancagua", "06305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Palmilla", "06306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Peralillo", "06307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Placilla", "06308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Pumanque", "06309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Santa Cruz", "06310", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(7, 'VII Maule', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Talca", "07101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Constitución", "07102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Curepto", "07103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Empedrado", "07104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Maule", "07105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Pelarco", "07106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Pencahue", "07107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Río Claro", "07108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "San Clemente", "07109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "San Rafael", "07110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Cauquenes", "07201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Chanco", "07202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Pelluhue", "07203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Curicó", "07301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Hualañé", "07302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Licantén", "07303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Molina", "07304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Rauco", "07305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Romeral", "07306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Sagrada Familia", "07307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Teno", "07308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Vichuquén", "07309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Linares", "07401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Colbún", "07402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Longaví", "07403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Parral", "07404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Retiro", "07405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "San Javier", "07406", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Villa Alegre", "07407", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Yerbas Buenas", "07408", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(8, 'VIII Bío - Bío', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Concepción", "08101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Coronel", "08102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Chiguayante", "08103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Florida", "08104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Hualqui", "08105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Lota", "08106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Penco", "08107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Pedro de la Paz", "08108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Santa Juana", "08109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Talcahuano", "08110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Tomé", "08111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Hualpén", "08112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Lebu", "08201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Arauco", "08202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Cañete", "08203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Contulmo", "08204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Curanilahue", "08205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Los Álamos", "08206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Tirúa", "08207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Los Ángeles", "08301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Antuco", "08302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Cabrero", "08303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Laja", "08304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Mulchén", "08305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Nacimiento", "08306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Negrete", "08307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Quilaco", "08308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Quilleco", "08309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Rosendo", "08310", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Santa Bárbara", "08311", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Tucapel", "08312", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Yumbel", "08313", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Alto Biobío", "08314", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Chillán", "08401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Bulnes", "08402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Cobquecura", "08403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Coelemu", "08404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Coihueco", "08405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Chillán Viejo", "08406", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "El Carmen", "08407", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Ninhue", "08408", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Ñiquén", "08409", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Pemuco", "08410", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Pinto", "08411", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Portezuelo", "08412", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Quillón", "08413", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Quirihue", "08414", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Ránquil", "08415", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Carlos", "08416", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Fabián", "08417", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Ignacio", "08418", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Nicolás", "08419", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Treguaco", "08420", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Yungay", "08421", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(9, 'IX Araucanía', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Temuco", "09101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Carahue", "09102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Cunco", "09103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Curarrehue", "09104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Freire", "09105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Galvarino", "09106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Gorbea", "09107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Lautaro", "09108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Loncoche", "09109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Melipeuco", "09110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Nueva Imperial", "09111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Padre Las Casas", "09112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Perquenco", "09113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Pitrufquén", "09114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Pucón", "09115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Saavedra", "09116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Teodoro Schmidt", "09117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Toltén", "09118", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Vilcún", "09119", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Villarrica", "09120", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Cholchol", "09121", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Angol", "09201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Collipulli", "09202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Curacautín", "09203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Ercilla", "09204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Lonquimay", "09205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Los Sauces", "09206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Lumaco", "09207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Purén", "09208", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Renaico", "09209", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Traiguén", "09210", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Victoria", "09211", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(10, 'X Los Lagos', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puerto Montt", "10101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Calbuco", "10102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Cochamó", "10103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Fresia", "10104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Frutillar", "10105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Los Muermos", "10106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Llanquihue", "10107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Maullín", "10108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puerto Varas", "10109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Castro", "10201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Ancud", "10202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Chonchi", "10203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Curaco de Vélez", "10204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Dalcahue", "10205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puqueldón", "10206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Queilén", "10207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Quellón", "10208", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Quemchi", "10209", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Quinchao", "10210", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Osorno", "10301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puerto Octay", "10302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Purranque", "10303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puyehue", "10304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Río Negro", "10305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "San Juan de la Costa", "10306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "San Pablo", "10307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Chaitén", "10401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Futaleufú", "10402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Hualaihué", "10403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Palena", "10404", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(11, 'XI Aysén del General Carlos Ibáñez del Campo', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Coyhaique", "11101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Lago Verde", "11102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Aysén", "11201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Cisnes", "11202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Guaitecas", "11203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Cochrane", "11301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "O’Higgins", "11302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Tortel", "11303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Chile Chico", "11401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Río Ibáñez", "11402", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(12, 'XII Magallanes y de la Antártica Chilena', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Punta Arenas", "12101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Laguna Blanca", "12102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Río Verde", "12103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "San Gregorio", "12104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Cabo de Hornos", "12201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Antártica", "12202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Porvenir", "12301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Primavera", "12302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Timaukel", "12303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Natales", "12401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Torres del Paine", "12402", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(13, 'RM - Región Metropolitana', 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Santiago", "13101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Cerrillos", "13102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Cerro Navia", "13103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Conchalí", "13104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "El Bosque", "13105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Estación Central", "13106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Huechuraba", "13107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Independencia", "13108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Cisterna", "13109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Florida", "13110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Granja", "13111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Pintana", "13112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Reina", "13113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Las Condes", "13114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Lo Barnechea", "13115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Lo Espejo", "13116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Lo Prado", "13117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Macul", "13118", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Maipú", "13119", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Ñuñoa", "13120", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Pedro Aguirre Cerda", "13121", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Peñalolén", "13122", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Providencia", "13123", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Pudahuel", "13124", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Quilicura", "13125", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Quinta Normal", "13126", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Recoleta", "13127", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Renca", "13128", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Joaquín", "13129", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Miguel", "13130", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Ramón", "13131", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Vitacura", "13132", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Puente Alto", "13201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Pirque", "13202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San José de Maipo", "13203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Colina", "13301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Lampa ", "13302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Tiltil", "13303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Bernardo", "13401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Buin", "13402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Calera de Tango", "13403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Paine", "13404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Melipilla", "13501", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Alhué", "13502", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Curacaví", "13503", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "María Pinto", "13504", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Pedro", "13505", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Talagante", "13601", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "El Monte", "13602", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Isla de Maipo", "13603", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Padre Hurtado", "13604", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Peñaflor", "13605", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(14, 'XIV Los Ríos', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Valdivia", "14101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Corral", "14102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Lanco", "14103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Los Lagos", "14104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Máfil", "14105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Mariquina", "14106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Paillaco", "14107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Panguipulli", "14108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "La Unión", "14201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Futrono", "14202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Lago Ranco", "14203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Río Bueno", "14204", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(15, 'XV Arica y Parinacota', 0);


INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 15, "Arica", "15101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 15, "Camarones", "15102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 15, "Putre", "15201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 15, "General Lagos", "15202", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(16, 'XVI Nuble', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 16, "Diguillín", "16100", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 16, "Itata", "16200", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 16, "Punilla", "16300", 0, 1);

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More