Skip to content

Instantly share code, notes, and snippets.

@victor-falcon
Created August 10, 2012 07:46
Show Gist options
  • Save victor-falcon/3312403 to your computer and use it in GitHub Desktop.
Save victor-falcon/3312403 to your computer and use it in GitHub Desktop.
SQL to insert Spanish States in Prestashop
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