Created
August 10, 2012 07:46
-
-
Save victor-falcon/3312403 to your computer and use it in GitHub Desktop.
SQL to insert Spanish States in Prestashop
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Álava", "ALA", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Albacete", "ALB", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Alicante", "ALC", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Almería", "ALM", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Asturias", "AST", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Ávila", "AVL", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Badajoz", "BDJ", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Islas Baleares", "BLS", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Barcelona", "BCN", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Burgos", "BUG", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Cáceres", "CCR", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Cádiz", "CAD", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Cantabria", "CNT", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Castellón", "CST", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Ceuta", "CET", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Ciudad Real", "CRE", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Córdoba", "COR", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Cuenca", "CUE", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Gerona", "GIR", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Granada", "GRA", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Guadalajara", "GUA", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Guipúzcoa", "GIZ", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Huelva", "HUV", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Huesca", "HUS", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Jaén", "JAN", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "La Coruña", "COR", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "La Rioja", "LRJ", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Las Palmas", "LPS", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "León", "LEO", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Lérida", "LER", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Lugo", "LUG", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Madrid", "MAD", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Málaga", "MAG", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Melilla", "MEL", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Murcia", "MUR", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Navarra", "NAV", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Orense", "ORE", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Palencia", "ESP", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Pontevedra", "PNT", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Salamanca", "SAL", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Santa Cruz de Tenerife", "STF", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Segovia", "SGV", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Sevilla", "SEV", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Soria", "SOR", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Tarragona", "TAR", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Teruel", "TER", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Toledo", "TOL", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Valencia", "VLN", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Valladolid", "VAL", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Vizcaya", "VIZ", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Zamora", "ZAM", 0, 1); | |
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) | |
VALUES (6, 1, "Zaragoza", "ZAG", 0, 1); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment