SQL para poner las provincias de España en Prestashop

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Albacete”, “ALB”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Alicante”, “ALC”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Almería”, “ALM”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Asturias”, “AST”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Ávila”, “AVL”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Badajoz”, “BDJ”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Islas Baleares”, “BLS”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Barcelona”, “BCN”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Burgos”, “BUG”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Cáceres”, “CCR”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Cádiz”, “CAD”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Cantabria”, “CNT”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Castellón”, “CST”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Ceuta”, “CET”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Ciudad Real”, “CRE”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Córdoba”, “COR”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Cuenca”, “CUE”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Gerona”, “GIR”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Granada”, “GRA”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Guadalajara”, “GUA”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Guipúzcoa”, “GIZ”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Huelva”, “HUV”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Huesca”, “HUS”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Jaén”, “JAN”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “La Rioja”, “LRJ”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Las Palmas”, “LPS”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “León”, “LEO”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Lérida”, “LER”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Lugo”, “LUG”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Madrid”, “MAD”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Málaga”, “MAG”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Melilla”, “MEL”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Murcia”, “MUR”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Orense”, “ORE”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Palencia”, “ESP”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Pontevedra”, “PNT”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Salamanca”, “SAL”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Santa Cruz de Tenerife”, “STF”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Segovia”, “SGV”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Sevilla”, “SEV”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Soria”, “SOR”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Tarragona”, “TAR”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Teruel”, “TER”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Toledo”, “TOL”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Valencia”, “VLN”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Valladolid”, “VAL”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Vizcaya”, “VIZ”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Zamora”, “ZAM”, 0, 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active)
VALUES (6, 9, “Zaragoza”, “ZAG”, 0, 1);