Minisite ADIDAS para Campaña DOBLECERO

Minisite realizado para la campaña ‘Let’s Go Festival’ de Adidas Originals. Minisite alojado en Doblecero, este minisite valida el codigo de promocion de compra de El Corte Ingles y da paso a un juego para que el usuario finalmente participe en el concurso de esta promocion.

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);