News anzeigen (17)   News-Kategorien anzeigen



Shopware italienische Staaten


Die "14" im nachfolgenden Skript muss durch die ID des entsprechenden Landes ausgetauscht werden.
Die Liste mit den Ländern und den ID's findet Ihr in s_core_countries
Hier der Insert für die italienischen Bundesstaaten auf Englisch:

INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Abruzzo','65',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Agrigento','AG',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Alessandria','AL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Ancona','AN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Aosta','AO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Arezzo','AR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Ascoli Piceno','AP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Asti','AT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Avellino','AV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Bari','BA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Barletta-Andria-Trani','BT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Basilicata','77',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Belluno','BL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Benevento','BN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Bergamo','BG',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Biella','BI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Bologna','BO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Bolzano','BZ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Brescia','BS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Brindisi','BR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Cagliari','CA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Calabria','78',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Caltanissetta','CL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Campania','72',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Campobasso','CB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Carbonia-Iglesias','CI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Caserta','CE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Catania','CT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Catanzaro','CZ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Chieti','CH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Como','CO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Cosenza','CS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Cremona','CR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Crotone','KR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Cuneo','CN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Emilia-Romagna','45',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Enna','EN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Fermo','FM',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Ferrara','FE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Firenze','FI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Foggia','FG',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Forli-Cesena','FC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Friuli-Venezia Giulia','36',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Frosinone ','FR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Genova','GE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Gorizia','GO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Grosseto','GR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Imperia','IM',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Isernia','IS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'L\'Aquila','AQ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'La Spezia','SP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Latina','LT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Lazio','62',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Lecce','LE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Lecco','LC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Liguria','42',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Livorno','LI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Lodi','LO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Lombardia','25',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Lucca','LU',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Macerata','MC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Mantova','MN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Marche','57',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Massa-Carrara','MS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Matera','MT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Medio Campidano','VS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Messina','ME',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Milano','MI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Modena','MO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Molise','67',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Monza e Brianza','MB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Napoli','NA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Novara','NO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Nuoro','NU',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Ogliastra','OG',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Olbia-Tempio','OT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Oristano','OR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Padova','PD',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Palermo','PA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Parma','PR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Pavia','PV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Perugia','PG',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Pesaro e Urbino','PU',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Pescara','PE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Piacenza','PC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Piemonte','21',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Pisa','PI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Pistoia','PT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Pordenone','PN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Potenza','PZ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Prato','PO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Puglia','75',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Ragusa','RG',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Ravenna','RA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Reggio Calabria','RC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Reggio Emilia','RE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Rieti','RI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Rimini','RN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Roma','RM',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Rovigo','RO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Salerno','SA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Sardegna','88',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Sassari','SS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Savona','SV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Sicilia','82',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Siena','SI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Siracusa','SR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Sondrio','SO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Taranto','TA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Teramo','TE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Terni','TR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Torino','TO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Toscana','52',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Trapani','TP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Trentino-Alto Adige','32',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Trento','TN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Treviso','TV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Trieste','TS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Udine','UD',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Umbria','55',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Valle d\'Aosta','23',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Varese','VA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Veneto','34',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Venezia','VE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Verbano-Cusio-Ossola','VB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Vercelli','VC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Verona','VR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Vibo Valentia','VV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Vicenza','VI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(14,'Viterbo','VT',0,1);

vom 29.11.17 um 12:33




Schreibe EXWE auf WhatsApp