Jump to content
  • 0
blackdroots

Aporte: Consulta sql para agregar todas las comunas de Chile

Question

Hola!!, Esta consulta SQL sirve para agregar todas las comunas de Chile y asi no tener que agregarlas una a una, que es muuucho trabajo.

 

Es muy simple, para los que no saben insertar consultas SQL a sus tablas de prestashop, los pasos son los siguientes:

  1. Ingresar a su CPANEL
  2. En la parte de "Base de datos", click en PHPMY ADMIN
  3. Click en la base de datos donde instalaron prestashop (ej: _dbMiTienda), las bases de datos estan al costado izquierdo.
  4. Click en la segunda pestaña "SQL"
  5. Copiar y pegar toda la consulta SQL en el cuadro blanco y hacer click en GO
  6. En su BO, click en "transporte", "país", seleccionan su país para editarlo y activan "contiene estados".

 

NOTA: En la consulta SQL tienen que cambiar el ID de su configuración de zonas y verificar que el "id_country" sea el mismo que el mío, en mi caso es "68" (el primero número que aparece en la segunda línea de abajo, luego viene el número "30" que es el ID de mi zona. En mi caso yo hice 15 zonas (las quince regiones de chile) y cada comuna la asocié a su respectiva zona o región. Al crear las zonas vas a ver que tiene un ID, bueno ese ID es el 30 de mi zona.

Luego viene el nombre, el código ISO, tax y active...ahi no tienen que hacer nada.

Esto se aplica para cualquier país.

Ej: INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)

VALUES (68, 30, "Arica", "15101", 0, 1);

 

El código SQL:

 

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 30, "Arica", "15101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 30, "Camarones", "15102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 30, "Putre", "15201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 30, "General Lagos", "15202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 29, "Iquique", "01101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 29, "Alto Hospicio", "01107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 29, "Pozo Almonte", "01401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 29, "Camiña", "01402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 29, "Colchane", "01403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 29, "Huara", "01404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 29, "Pica", "01405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 24, "Antofagasta", "02101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 24, "Mejillones", "02102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 24, "Sierra Gorda", "02103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 24, "Taltal", "02104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 24, "Calama", "02201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 24, "Ollagüe", "02202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 24, "San Pedro de Atacama", "02203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 24, "Tocopilla", "02301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 24, "María Elena", "02302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 25, "Copiapó", "03101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 25, "Caldera", "03102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 25, "Tierra Amarilla", "03103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 25, "Chañaral", "03201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 25, "Diego de Almagro", "03202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 25, "Vallenar", "03301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 25, "Alto del Carmen", "03302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 25, "Freirina", "03303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 25, "Huasco", "03304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "La Serena", "04101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Coquimbo", "04102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Andacollo", "04103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "La Higuera", "04104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Paiguano", "04105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Vicuña", "04106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Illapel", "04201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Canela", "04202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Los Vilos", "04203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Salamanca", "04204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Ovalle", "04301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Combarbalá", "04302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Monte Patria", "04303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Punitaqui", "04304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 26, "Río Hurtado", "04305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Valparaíso", "05101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Casablanca", "05102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Concón", "05103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Juan Fernández", "05104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Puchuncaví", "05105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Quintero", "05107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Viña del Mar", "05109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Isla de Pascua", "05201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Los Andes", "05301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Calle Larga", "05302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Rinconada", "05303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "San Esteban", "05304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "La Ligua", "05401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Cabildo", "05402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Papudo", "05403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Petorca", "05404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Zapallar", "05405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Quillota", "05501", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Calera", "05502", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Hijuelas", "05503", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "La Cruz", "05504", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Nogales", "05506", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "San Antonio", "05601", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Algarrobo", "05602", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Cartagena", "05603", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "El Quisco", "05604", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "El Tabo", "05605", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Santo Domingo", "05606", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "San Felipe", "05701", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Catemu", "05702", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Llaillay", "05703", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Panquehue", "05704", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Putaendo", "05705", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Santa María", "05706", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Quilpué", "05801", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Limache", "05802", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Olmué", "05803", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 27, "Villa Alemana", "05804", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Rancagua", "06101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Codegua", "06102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Coinco", "06103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Coltauco", "06104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Doñihue", "06105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Graneros", "06106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Las Cabras", "06107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Machalí", "06108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Malloa", "06109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Mostazal", "06110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Olivar", "06111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Peumo", "06112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Pichidegua", "06113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Quinta de Tilcoco", "06114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Rengo", "06115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Requínoa", "06116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "San Vicente", "06117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Pichilemu", "06201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "La Estrella", "06202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Litueche", "06203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Marchihue", "06204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Navidad", "06205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Paredones", "06206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "San Fernando", "06301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Chépica", "06302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Chimbarongo", "06303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Lolol", "06304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Nancagua", "06305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Palmilla", "06306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Peralillo", "06307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Placilla", "06308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Pumanque", "06309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 28, "Santa Cruz", "06310", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Talca", "07101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Constitución", "07102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Curepto", "07103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Empedrado", "07104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Maule", "07105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Pelarco", "07106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Pencahue", "07107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Río Claro", "07108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "San Clemente", "07109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "San Rafael", "07110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Cauquenes", "07201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Chanco", "07202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Pelluhue", "07203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Curicó", "07301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Hualañé", "07302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Licantén", "07303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Molina", "07304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Rauco", "07305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Romeral", "07306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Sagrada Familia", "07307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Teno", "07308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Vichuquén", "07309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Linares", "07401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Colbún", "07402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Longaví", "07403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Parral", "07404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Retiro", "07405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "San Javier", "07406", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Villa Alegre", "07407", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 31, "Yerbas Buenas", "07408", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Concepción", "08101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Coronel", "08102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Chiguayante", "08103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Florida", "08104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Hualqui", "08105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Lota", "08106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Penco", "08107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "San Pedro de la Paz", "08108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Santa Juana", "08109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Talcahuano", "08110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Tomé", "08111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Hualpén", "08112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Lebu", "08201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Arauco", "08202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Cañete", "08203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Contulmo", "08204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Curanilahue", "08205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Los Álamos", "08206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Tirúa", "08207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Los Ángeles", "08301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Antuco", "08302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Cabrero", "08303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Laja", "08304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Mulchén", "08305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Nacimiento", "08306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Negrete", "08307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Quilaco", "08308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Quilleco", "08309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "San Rosendo", "08310", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Santa Bárbara", "08311", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Tucapel", "08312", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Yumbel", "08313", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Alto Biobío", "08314", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Chillán", "08401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Bulnes", "08402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Cobquecura", "08403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Coelemu", "08404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Coihueco", "08405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Chillán Viejo", "08406", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "El Carmen", "08407", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Ninhue", "08408", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Ñiquén", "08409", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Pemuco", "08410", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Pinto", "08411", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Portezuelo", "08412", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Quillón", "08413", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Quirihue", "08414", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Ránquil", "08415", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "San Carlos", "08416", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "San Fabián", "08417", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "San Ignacio", "08418", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "San Nicolás", "08419", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Treguaco", "08420", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 32, "Yungay", "08421", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Temuco", "09101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Carahue", "09102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Cunco", "09103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Curarrehue", "09104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Freire", "09105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Galvarino", "09106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Gorbea", "09107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Lautaro", "09108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Loncoche", "09109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Melipeuco", "09110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Nueva Imperial", "09111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Padre Las Casas", "09112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Perquenco", "09113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Pitrufquén", "09114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Pucón", "09115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Saavedra", "09116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Teodoro Schmidt", "09117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Toltén", "09118", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Vilcún", "09119", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Villarrica", "09120", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Cholchol", "09121", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Angol", "09201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Collipulli", "09202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Curacautín", "09203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Ercilla", "09204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Lonquimay", "09205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Los Sauces", "09206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Lumaco", "09207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Purén", "09208", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Renaico", "09209", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Traiguén", "09210", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 33, "Victoria", "09211", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Valdivia", "14101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Corral", "14102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Lanco", "14103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Los Lagos", "14104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Máfil", "14105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Mariquina", "14106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Paillaco", "14107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Panguipulli", "14108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "La Unión", "14201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Futrono", "14202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Lago Ranco", "14203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 34, "Río Bueno", "14204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Puerto Montt", "10101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Calbuco", "10102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Cochamó", "10103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Fresia", "10104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Frutillar", "10105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Los Muermos", "10106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Llanquihue", "10107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Maullín", "10108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Puerto Varas", "10109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Castro", "10201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Ancud", "10202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Chonchi", "10203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Curaco de Vélez", "10204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Dalcahue", "10205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Puqueldón", "10206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Queilén", "10207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Quellón", "10208", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Quemchi", "10209", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Quinchao", "10210", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Osorno", "10301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Puerto Octay", "10302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Purranque", "10303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Puyehue", "10304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Río Negro", "10305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "San Juan de la Costa", "10306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "San Pablo", "10307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Chaitén", "10401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Futaleufú", "10402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Hualaihué", "10403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 35, "Palena", "10404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "Coyhaique", "11101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "Lago Verde", "11102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "Aysén", "11201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "Cisnes", "11202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "Guaitecas", "11203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "Cochrane", "11301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "O’Higgins", "11302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "Tortel", "11303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "Chile Chico", "11401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 36, "Río Ibáñez", "11402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Punta Arenas", "12101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Laguna Blanca", "12102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Río Verde", "12103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "San Gregorio", "12104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Cabo de Hornos (Ex - Navarino)", "12201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Antártica", "12202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Porvenir", "12301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Primavera", "12302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Timaukel", "12303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Natales", "12401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 37, "Torres del Paine", "12402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Santiago", "13101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Cerrillos", "13102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Cerro Navia", "13103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Conchalí", "13104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "El Bosque", "13105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Estación Central", "13106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Huechuraba", "13107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Independencia", "13108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "La Cisterna", "13109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "La Florida", "13110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "La Granja", "13111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "La Pintana", "13112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "La Reina", "13113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Las Condes", "13114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Lo Barnechea", "13115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Lo Espejo", "13116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Lo Prado", "13117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Macul", "13118", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Maipú", "13119", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Ñuñoa", "13120", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Pedro Aguirre Cerda", "13121", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Peñalolén", "13122", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Providencia", "13123", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Pudahuel", "13124", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Quilicura", "13125", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Quinta Normal", "13126", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Recoleta", "13127", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Renca", "13128", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "San Joaquín", "13129", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "San Miguel", "13130", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "San Ramón", "13131", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Vitacura", "13132", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Puente Alto", "13201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Pirque", "13202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "San José de Maipo", "13203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Colina", "13301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Lampa ", "13302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Tiltil", "13303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "San Bernardo", "13401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Buin", "13402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Calera de Tango", "13403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Paine", "13404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Melipilla", "13501", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Alhué", "13502", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Curacaví", "13503", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "María Pinto", "13504", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "San Pedro", "13505", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Talagante", "13601", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "El Monte", "13602", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Isla de Maipo", "13603", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Padre Hurtado", "13604", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (68, 38, "Peñaflor", "13605", 0, 1);

 

 

Saludos.

Share this post


Link to post
Share on other sites

21 answers to this question

Recommended Posts

  • 0

Probado y perfecto.

 

MUCHAS GRACIAS!!

 

a ver si se animan a poner todos los estados de cada uno de los paises. Así completaremos una buena base de datos,!!

Share this post


Link to post
Share on other sites
  • 0

Alf inal pude instalarlo, se agradece el aporte!!!

 

dejo el ID de mis estados

 

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 9, "Arica", "15101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 9, "Camarones", "15102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 9, "Putre", "15201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 9, "General Lagos", "15202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 10, "Iquique", "01101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 10, "Alto Hospicio", "01107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 10, "Pozo Almonte", "01401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 10, "Camiña", "01402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 10, "Colchane", "01403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 10, "Huara", "01404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 10, "Pica", "01405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 11, "Antofagasta", "02101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 11, "Mejillones", "02102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 11, "Sierra Gorda", "02103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 11, "Taltal", "02104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 11, "Calama", "02201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 11, "Ollagüe", "02202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 11, "San Pedro de Atacama", "02203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 11, "Tocopilla", "02301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 11, "María Elena", "02302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 12, "Copiapó", "03101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 12, "Caldera", "03102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Tierra Amarilla", "03103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 12, "Chañaral", "03201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 12, "Diego de Almagro", "03202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 12, "Vallenar", "03301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 12, "Alto del Carmen", "03302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 12, "Freirina", "03303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 12, "Huasco", "03304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "La Serena", "04101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Coquimbo", "04102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Andacollo", "04103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "La Higuera", "04104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Paiguano", "04105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Vicuña", "04106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Illapel", "04201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Canela", "04202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Los Vilos", "04203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Salamanca", "04204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Ovalle", "04301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Combarbalá", "04302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Monte Patria", "04303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Punitaqui", "04304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 13, "Río Hurtado", "04305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Valparaíso", "05101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Casablanca", "05102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Concón", "05103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Juan Fernández", "05104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Puchuncaví", "05105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Quintero", "05107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Viña del Mar", "05109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Isla de Pascua", "05201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Los Andes", "05301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Calle Larga", "05302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Rinconada", "05303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "San Esteban", "05304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "La Ligua", "05401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Cabildo", "05402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Papudo", "05403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Petorca", "05404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Zapallar", "05405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Quillota", "05501", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Calera", "05502", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Hijuelas", "05503", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "La Cruz", "05504", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Nogales", "05506", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "San Antonio", "05601", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Algarrobo", "05602", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Cartagena", "05603", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "El Quisco", "05604", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "El Tabo", "05605", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Santo Domingo", "05606", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "San Felipe", "05701", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Catemu", "05702", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Llaillay", "05703", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Panquehue", "05704", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Putaendo", "05705", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Santa María", "05706", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Quilpué", "05801", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Limache", "05802", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Olmué", "05803", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 14, "Villa Alemana", "05804", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Rancagua", "06101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Codegua", "06102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Coinco", "06103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Coltauco", "06104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Doñihue", "06105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Graneros", "06106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Las Cabras", "06107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Machalí", "06108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Malloa", "06109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Mostazal", "06110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Olivar", "06111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Peumo", "06112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Pichidegua", "06113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Quinta de Tilcoco", "06114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Rengo", "06115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Requínoa", "06116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "San Vicente", "06117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Pichilemu", "06201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "La Estrella", "06202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Litueche", "06203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Marchihue", "06204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Navidad", "06205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Paredones", "06206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "San Fernando", "06301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Chépica", "06302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Chimbarongo", "06303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Lolol", "06304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Nancagua", "06305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Palmilla", "06306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Peralillo", "06307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Placilla", "06308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Pumanque", "06309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 16, "Santa Cruz", "06310", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Talca", "07101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Constitución", "07102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Curepto", "07103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Empedrado", "07104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Maule", "07105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Pelarco", "07106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Pencahue", "07107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Río Claro", "07108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "San Clemente", "07109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "San Rafael", "07110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Cauquenes", "07201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Chanco", "07202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Pelluhue", "07203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Curicó", "07301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Hualañé", "07302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Licantén", "07303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Molina", "07304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Rauco", "07305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Romeral", "07306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Sagrada Familia", "07307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Teno", "07308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Vichuquén", "07309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Linares", "07401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Colbún", "07402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Longaví", "07403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Parral", "07404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Retiro", "07405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "San Javier", "07406", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Villa Alegre", "07407", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 17, "Yerbas Buenas", "07408", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Concepción", "08101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Coronel", "08102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Chiguayante", "08103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Florida", "08104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Hualqui", "08105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Lota", "08106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Penco", "08107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "San Pedro de la Paz", "08108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Santa Juana", "08109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Talcahuano", "08110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Tomé", "08111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Hualpén", "08112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Lebu", "08201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Arauco", "08202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Cañete", "08203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Contulmo", "08204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Curanilahue", "08205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Los Álamos", "08206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Tirúa", "08207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Los Ángeles", "08301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Antuco", "08302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Cabrero", "08303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Laja", "08304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Mulchén", "08305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Nacimiento", "08306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Negrete", "08307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Quilaco", "08308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Quilleco", "08309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "San Rosendo", "08310", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Santa Bárbara", "08311", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Tucapel", "08312", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Yumbel", "08313", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Alto Biobío", "08314", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Chillán", "08401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Bulnes", "08402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Cobquecura", "08403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Coelemu", "08404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Coihueco", "08405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Chillán Viejo", "08406", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "El Carmen", "08407", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Ninhue", "08408", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Ñiquén", "08409", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Pemuco", "08410", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Pinto", "08411", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Portezuelo", "08412", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Quillón", "08413", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Quirihue", "08414", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Ránquil", "08415", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "San Carlos", "08416", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "San Fabián", "08417", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "San Ignacio", "08418", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "San Nicolás", "08419", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Treguaco", "08420", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 18, "Yungay", "08421", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Temuco", "09101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Carahue", "09102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Cunco", "09103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Curarrehue", "09104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Freire", "09105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Galvarino", "09106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Gorbea", "09107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Lautaro", "09108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Loncoche", "09109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Melipeuco", "09110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Nueva Imperial", "09111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Padre Las Casas", "09112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Perquenco", "09113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Pitrufquén", "09114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Pucón", "09115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Saavedra", "09116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Teodoro Schmidt", "09117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Toltén", "09118", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Vilcún", "09119", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Villarrica", "09120", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Cholchol", "09121", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Angol", "09201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Collipulli", "09202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Curacautín", "09203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Ercilla", "09204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Lonquimay", "09205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Los Sauces", "09206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Lumaco", "09207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Purén", "09208", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Renaico", "09209", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Traiguén", "09210", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 19, "Victoria", "09211", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Valdivia", "14101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Corral", "14102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Lanco", "14103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Los Lagos", "14104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Máfil", "14105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Mariquina", "14106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Paillaco", "14107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Panguipulli", "14108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "La Unión", "14201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Futrono", "14202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Lago Ranco", "14203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 20, "Río Bueno", "14204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Puerto Montt", "10101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Calbuco", "10102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Cochamó", "10103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Fresia", "10104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Frutillar", "10105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Los Muermos", "10106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Llanquihue", "10107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Maullín", "10108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Puerto Varas", "10109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Castro", "10201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Ancud", "10202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Chonchi", "10203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Curaco de Vélez", "10204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Dalcahue", "10205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Puqueldón", "10206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Queilén", "10207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Quellón", "10208", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Quemchi", "10209", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Quinchao", "10210", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Osorno", "10301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Puerto Octay", "10302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Purranque", "10303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Puyehue", "10304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Río Negro", "10305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "San Juan de la Costa", "10306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "San Pablo", "10307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Chaitén", "10401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Futaleufú", "10402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Hualaihué", "10403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 21, "Palena", "10404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "Coyhaique", "11101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "Lago Verde", "11102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "Aysén", "11201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "Cisnes", "11202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "Guaitecas", "11203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "Cochrane", "11301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "O’Higgins", "11302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "Tortel", "11303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "Chile Chico", "11401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 22, "Río Ibáñez", "11402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Punta Arenas", "12101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Laguna Blanca", "12102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Río Verde", "12103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "San Gregorio", "12104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Cabo de Hornos (Ex - Navarino)", "12201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Antártica", "12202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Porvenir", "12301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Primavera", "12302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Timaukel", "12303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Natales", "12401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 23, "Torres del Paine", "12402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Santiago", "13101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Cerrillos", "13102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Cerro Navia", "13103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Conchalí", "13104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "El Bosque", "13105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Estación Central", "13106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Huechuraba", "13107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Independencia", "13108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "La Cisterna", "13109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "La Florida", "13110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "La Granja", "13111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "La Pintana", "13112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "La Reina", "13113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Las Condes", "13114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Lo Barnechea", "13115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Lo Espejo", "13116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Lo Prado", "13117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Macul", "13118", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Maipú", "13119", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Ñuñoa", "13120", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Pedro Aguirre Cerda", "13121", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Peñalolén", "13122", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Providencia", "13123", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Pudahuel", "13124", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Quilicura", "13125", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Quinta Normal", "13126", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Recoleta", "13127", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Renca", "13128", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "San Joaquín", "13129", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "San Miguel", "13130", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "San Ramón", "13131", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Vitacura", "13132", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Puente Alto", "13201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Pirque", "13202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "San José de Maipo", "13203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Colina", "13301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Lampa ", "13302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Tiltil", "13303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "San Bernardo", "13401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Buin", "13402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Calera de Tango", "13403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Paine", "13404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Melipilla", "13501", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Alhué", "13502", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Curacaví", "13503", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "María Pinto", "13504", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "San Pedro", "13505", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Talagante", "13601", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "El Monte", "13602", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Isla de Maipo", "13603", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Padre Hurtado", "13604", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (245, 15, "Peñaflor", "13605", 0, 1);

Share this post


Link to post
Share on other sites
  • 0

jajaja no hombre, me refería a que vayan añadiendo las provincias de cada país. yo soy de España, aquí os dejo las provincias ESPAÑOLAS, por si alguien las necesita. Tan solo hay que cambiarle las ID de las zonas y país:

 

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'La Coruña', 'ES-C', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Vitoria', 'ES-VI', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES ( 9, 'Albacete', 'ES-AB', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES ( 6, 9, 'Alicante', 'ES-A', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 14, 'Almería', 'ES-AL', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Asturias', 'ES-O', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Ávila', 'ES-AV', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Badajoz', 'ES-BA', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 11, 'Palma de Mallorca', 'ES-PM', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Barcelona', 'ES-B', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Burgos', 'ES-BU', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Cáceres', 'ES-CC', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 14, 'Cádiz', 'ES-CA', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Santander', 'ES-S', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Castellón', 'ES-CS', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 25, 'Ceuta', 'ES-CE', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Ciudad Real', 'ES-CR', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 14, 'Córdoba', 'ES-CO', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Cuenca', 'ES-CU', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Gerona', 'ES-GI', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 14, 'Granada', 'ES-GR', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Guadalajara', 'ES-GU', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Guipúzcoa', 'ES-SS', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 14, 'Huelva', 'ES-H', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Huesca', 'ES-HU', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 14, 'Jaén', 'ES-J', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Logroño', 'ES-LO', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 23, 'Las Palmas de Gran Canaria', 'ES-GC', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'León', 'ES-LE', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Lérida', 'ES-L', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Lugo', 'ES-LU', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Madrid', 'ES-M', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 14, 'Málaga', 'ES-MA', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 26, 'Melilla', 'ES-ML', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Murcia', 'ES-MU', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Navarra', 'ES-NA', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Orense', 'ES-OR', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Palencia', 'ES-P', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Pontevedra', 'ES-PO', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Salamanca', 'ES-SA', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 24, 'Santa Cruz de Tenerife', 'ES-TF', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Segovia', 'ES-SG', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 13, 'Sevilla', 'ES-SE', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Soria', 'ES-SO', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Tarragona', 'ES-T', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Teruel', 'ES-TE', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Toledo', 'ES-TO', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Valencia', 'ES-V', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Valladolid', 'ES-VA', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Bilbao/Vizcaya', 'ES-BI', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Zamora', 'ES-ZA', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, 'Zaragoza', 'ES-Z', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 10, 'La Palma', 'ES-TF', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 10, 'La Gomera', 'ES-TF', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 10, 'El Hierro', 'ES-TF', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 10, 'Lanzarote', 'ES-GC', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 10, 'Fuerteventura', 'ES-GC', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 11, 'Ibiza', 'ES-PM', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 11, 'Formentera', 'ES-PM', 0, 1),

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 11, 'Menorca', 'ES-PM', 0, 1),

Edited by JoaquinBM

Share this post


Link to post
Share on other sites
  • 0

Muchas Gracias, en mi caso después de instalar PrestaShop v1.5.6 agregué las quince regiones como zonas tal cual informas.

 

El SQL de ello es:

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(9, 'Arica y Parinacota', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(10, 'Tarapacá', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(11, 'Antofagasta', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(12, 'Atacama', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(13, 'Coquimbo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(14, 'Valparaíso', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(15, 'Región Metropolitana', 1);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(16, 'Libertador General Bernardo O''Higgins', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(17, 'Maule', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(18, 'Bío - Bío', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(19, 'Araucanía', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(20, 'Los Ríos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(21, 'Los Lagos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(22, 'Aysén del General Carlos Ibáñez del Campo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(23, 'Magallanes y de la Antártica Chilena', 0);

Eso si consideran que no han agregado otras zonas después de la instalación.

 

Cordialmente,

 

Yigo.

Share this post


Link to post
Share on other sites
  • 0

Estimados,

     Agradeciendo los aportes anteriores, me gustaría me ayudaran un poco porque he estado revisando este post y me he enredado un poco con el problema de las ciudades de Chile.

Me gustaría incluir en mi web, una lista de selección para ciudades y regiones al momento del registro.

Con vuestro aporte ya tengo las comunas que serian el equivalente a las ciudades (eso entiendo), agregue también la Zonas y es ahí donde se me produce el detalle:

 

1.- Cuando reviso el Pais, Chile en el Nº 68, no le puedo asociar todas las zonas creadas (o es una o es otra), el tema es que no me deja seleccionar las comunas en el Front y es lógico dado que el país queda solo asociado a una (en el caso mio Antofagasta por defecto).

Mi pregunta es:

.-¿debo utilizar el listado de Países como ciudades, así tendría selección de ciudades en el front ?

-Si es así: ¿Como puedo hacer para que las zonas sean elegibles también desde el front?

-Y finalmente : ¿los estados serian las comunas que amablemente compartieron Ustedes?.

La verdad me tiene medio complicado este tema, lo vi simple pero parece que no lo es tanto. 

Gracias de antemano.

Share this post


Link to post
Share on other sites
  • 0

Hola, amigos muchas gracias por el aporte. Lo hice y me fue muy bien. 

 

Para contribuir con el foro, y siguiendo el consejo del amigo JoaquinBM, voy a colocar como agregar los estados de Venezuela:

 

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Amazonas", "VE-Z", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Anzoátegui", "VE-B", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Apure", "VE-C", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Aragua", "VE-D", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Barinas", "VE-E", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Bolívar", "VE-F", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Carabobo", "VE-G", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Cojedes", "VE-H", 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Delta Amacuro", "VE-Y", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Distrito Capital", "VE-A", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Falcón", "VE-I", 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Guárico", "VE-J", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Lara", "VE-K", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Mérida", "VE-L", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Miranda", "VE-M", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Monagas", "VE-N", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Nueva Esparta", "VE-O", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Portuguesa", "VE-P", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Sucre", "VE-R", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Táchira", "VE-S", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Trujillo", "VE-T", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Vargas", "VE-X", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Yaracuy", "VE-U", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (221, 6, "Zulia", "VE-V", 0, 1);

 

Espero que le sirva a alguna persona interesada, y que cada quien contribuya con algo para así enriquecer el foro y ampliar nuestros negocios.

Share this post


Link to post
Share on other sites
  • 0

Hola a todos, siguiendo con la contribución les traigo las provincias o estados de Francia:

 

  INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Ain', 'FR-01', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Aisne', 'FR-02', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Allier', 'FR-03', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, ' Alpes-de-Haute-Provence', 'FR-04', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Hautes-Alpes', 'FR-05', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Alpes-Maritimes', 'FR-06', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Ardèche', 'FR-07', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Ardennes', 'FR-08', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Ariège', 'FR-09', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Aube', 'FR-10', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Aude', 'FR-11', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Aveyron', 'FR-12', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Bouches-du-Rhône', 'FR-13', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Calvados', 'FR-14', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Cantal', 'FR-15', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Charente', 'FR-16', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Charente-Maritime', 'FR-17', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Cher', 'FR-18', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Corrèze', 'FR-19', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Corse-du-Sud', 'FR-2A', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Haute-Corse', 'FR-2B', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Côte-d`Or', 'FR-21', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Côtes-d`Armor', 'FR-22', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Creuse', 'FR-23', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Dordogne', 'FR-24', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Doubs', 'FR-25', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Drôme', 'FR-26', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Eure', 'FR-27', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Eure-et-Loir', 'FR-28', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Finistère', 'FR-29', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Gard', 'FR-30', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Haute-Garonne', 'FR-31', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Gers', 'FR-32', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Gironde', 'FR-33', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Hérault', 'FR-34', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Ille-et-Vilaine', 'FR-35', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Indre', 'FR-36', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Indre-et-Loire', 'FR-37', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Isère', 'FR-38', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Jura', 'FR-39', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Landes', 'FR-40', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Loir-et-Cher', 'FR-41', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Loire', 'FR-42', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Haute-Loire', 'FR-43', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Loire-Atlantique', 'FR-44', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Loiret', 'FR-45', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Lot', 'FR-46', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Lot-et-Garonne', 'FR-47', 0, 1);  

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Lozère', 'FR-48', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Maine-et-Loire', 'FR-49', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Manche', 'FR-50', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Marne', 'FR-51', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Haute-Marne', 'FR-52', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Mayenne', 'FR-53', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Meurthe-et-Moselle', 'FR-54', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Meuse', 'FR-55', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Morbihan', 'FR-56', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Moselle', 'FR-57', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Nièvre', 'FR-58', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Nord', 'FR-59', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Oise', 'FR-60', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Orne', 'FR-61', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Pas-de-Calais', 'FR-62', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Puy-de-Dôme', 'FR-63', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Pyrénées-Atlantiques', 'FR-64', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Hautes-Pyrénées', 'FR-65', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Pyrénées-Orientales', 'FR-66', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Bas-Rhin', 'FR-67', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Haut-Rhin', 'FR-68', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Rhône', 'FR-69', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Haute-Saône', 'FR-70', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Saône-et-Loire', 'FR-71', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Sarthe', 'FR-72', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Savoie', 'FR-73', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Haute-Savoie', 'FR-74', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Paris', 'FR-75', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Seine-Maritime', 'FR-76', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Seine-et-Marne', 'FR-77', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Yvelines', 'FR-78', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Deux-Sèvres', 'FR-79', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Somme', 'FR-80', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Tarn', 'FR-81', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Tarn-et-Garonne', 'FR-82', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Var', 'FR-83', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Vaucluse', 'FR-84', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Vendée', ' FR-85', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Vienne', 'FR-86', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Haute-Vienne', 'FR-87', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Vosges', ' 'FR-88', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Yonne', 'FR-89', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Territoire de Belfort', ' FR-90', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Essonne', 'FR-91', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Hauts-de-Seine', 'FR-92', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Seine-Saint-Denis', 'FR-93', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Val-de-Marne', 'FR-94', 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (8, 1, 'Val-d`Oise', 'FR-95', 0, 1);

 

 

Espero les sirva de algo...

Share this post


Link to post
Share on other sites
  • 0

La tabla anterior es de solo copiar y pegar, con la salvedad que en el registro donde está 'FR-88' hay un ' de sobra. Quítenle esa comilla y listo...

Share this post


Link to post
Share on other sites
  • 0

Hola amigos! Si es compatible, yo los cargué, pero ahora mi duda es qué hacer para poder dejar los gastos de envío por comuna de santiago.

 

He intentado agregar zona region metropolitana y provincia de chile las comunas, pero no me resulta, dado que el gasto de envio se puede configurar, pero por zona, no por provincias de un pais.

 

Si alguien me pueda ayudar, infinitamente agradecido. Saludos

Share this post


Link to post
Share on other sites
  • 0

Yo hice todo como dijeron (regiones y comunas de Chile) y les agradezco porque después de muchas horas buscando solución, la encontré aquí.

 

Pero me surgió un problema: Cuando quise asignar las comunas a una región (vale decir, una provincia a una zona) me aparece error del código ISO de la comuna (provincia en prestashop).

 

Qué puedo hacer?

 

Adjunto un pantallazo.

 

Y gracias comunidad!

post-1239516-0-42933700-1461097411_thumb.png

Share this post


Link to post
Share on other sites
  • 0

Gracias a todos los aportes de este post. fueron bien utilies.
Pero alguien tiene el dato de como agregar las Provincias (Comunas) a las regiones (Zonas) de forma masiva?
Algun codigo SQL hecho?

Slds y gracias

Share this post


Link to post
Share on other sites
  • 0
On 27/1/2014 at 11:42 PM, Yigo said:

Muchas Gracias, en mi caso después de instalar PrestaShop v1.5.6 agregué las quince regiones como zonas tal cual informas.

 

El SQL de ello es:


INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(9, 'Arica y Parinacota', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(10, 'Tarapacá', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(11, 'Antofagasta', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(12, 'Atacama', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(13, 'Coquimbo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(14, 'Valparaíso', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(15, 'Región Metropolitana', 1);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(16, 'Libertador General Bernardo O''Higgins', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(17, 'Maule', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(18, 'Bío - Bío', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(19, 'Araucanía', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(20, 'Los Ríos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(21, 'Los Lagos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(22, 'Aysén del General Carlos Ibáñez del Campo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(23, 'Magallanes y de la Antártica Chilena', 0);

Eso si consideran que no han agregado otras zonas después de la instalación.

 

Cordialmente,

 

Yigo.

Corrigido los ID_ZONE que no cuadravan con el SQL de blackdroots. Ahora las comunas aparecen con sus regiones despues de agregar el SQL:

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(30, 'Arica y Parinacota', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(29, 'Tarapacá', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(24, 'Antofagasta', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(25, 'Atacama', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(26, 'Coquimbo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(27, 'Valparaíso', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(38, 'Región Metropolitana', 1);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(28, 'Libertador General Bernardo O''Higgins', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(31, 'Maule', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(32, 'Bío - Bío', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(33, 'Araucanía', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(34, 'Los Ríos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(35, 'Los Lagos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(36, 'Aysén del General Carlos Ibáñez del Campo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(37, 'Magallanes y de la Antártica Chilena', 0);

Share this post


Link to post
Share on other sites
  • 0
On 26/11/2012 at 9:43 AM, ErickClock said:

Hola sabes que no pude hacerlo!!!

Hola al final como lo lograste? , solo me sale chile pero nada más, estoy usando 1.7 y me aprovecho de preguntar como "rayos "agregar el rut y validarlo .... gracias y disculpas si no el tema .... saludos de Iquique

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

×