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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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