News anzeigen (16)   News-Kategorien anzeigen



Shopware - Alle für PayPal verpflichtenden Staaten in einer SQL


Leider wirft Shopware für folgende Länder Fehler, sobald hier keine Angaben zum Staat bzw. Bundesland gemacht werden.

USA, Japan, Argentienen, Brasilien, Canada, Indien, Italien, Mexico, Thailand

Wir haben dazu diese SQL-Querry für euch, die alle relevanten Staaten enthält.
Wichtig: Die countryID müsst Ihr noch anpassen an eure eigenen IDs aus der s_core_countries. Je nach dem wie Ihr diese damals eingefügt habt, können diese varrieren.
Bei uns haben die USA bspw. die 28. Deutschland hat die 2:

id;countryname
2;Deutschland
14;Italien
16;Kanada
28;USA
36;Brasilien
51;Argentinien
112;Indien
159;Mexiko
228;Thailand

 

Bitte beachtet außerdem, dass Ihr auch für das Land die Bundesländer aktiviert und als Pflichfeld markiert.

INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Baden-Württemberg','BW',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Bayern','BY',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Berlin','BE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Brandenburg','BB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Bremen','HB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Hamburg','HH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Hessen','HE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Mecklenburg-Vorpommern','MV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Niedersachsen','NI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Nordrhein-Westfalen','NW',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Rheinland-Pfalz','RP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Saarland','SL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Sachsen','SN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Sachsen-Anhalt','ST',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Schleswig-Holstein','SH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(2,'Thüringen','TH',0,1);
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);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Aichi','23',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Akita','05',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Aomori','02',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Chiba','12',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Ehime','38',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Fukui','18',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Fukuoka','40',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Fukushima','07',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Gifu','21',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Gunma','10',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Hiroshima','34',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Hokkaido','01',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Hyogo','28',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Ibaraki','08',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Ishikawa','17',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Iwate','03',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Kagawa','37',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Kagoshima','46',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Kanagawa','14',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Kochi','39',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Kumamoto','43',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Kyoto','26',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Mie','24',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Miyagi','04',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Miyazaki','45',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Nagano','20',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Nagasaki','42',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Nara','29',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Niigata','15',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Oita','44',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Okayama','33',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Okinawa','47',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Osaka','27',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Saga','41',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Saitama','11',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Shiga','25',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Shimane','32',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Shizuoka','22',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Tochigi','09',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Tokushima','36',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Tokyo','13',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Tottori','31',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Toyama','16',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Wakayama','30',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Yamagata','06',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Yamaguchi','35',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(15,'Yamanashi','19',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Alberta','AB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'British Columbia','BC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Manitoba','MB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'New Brunswick','NB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Newfoundland and Labrador','NL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Northwest Territories','NT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Nova Scotia','NS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Nunavut','NU',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Ontario','ON',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Prince Edward Island','PE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Quebec','QC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Saskatchewan','SK',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(16,'Yukon Territory','YT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Alabama','AL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Alaska','AK',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Arizona','AZ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Arkansas','AR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Colorado','CO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Connecticut','CT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Delaware','DE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'District of Columbia','DC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Florida','FL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Georgia','GA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Hawaii','HI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Idaho','ID',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Illinois','IL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Indiana','IN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Iowa','IA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Kalifornien','CA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Kansas','KS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Kentucky','KY',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Louisiana','LA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Maine','ME',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Maryland','MD',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Massachusetts','MA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Michigan','MI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Minnesota','MN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Mississippi','MS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Missouri','MO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Montana','MT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Nebraska','NE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Nevada','NV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'New Hampshire','NH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'New Jersey','NJ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'New Mexico','NM',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'New York','NY',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'North Carolina','NC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'North Dakota','ND',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Ohio','OH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Oklahoma','OK',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Oregon','OR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Pennsylvania','PA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Rhode Island','RI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'South Carolina','SC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'South Dakota','SD',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Tennessee','TN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Texas','TX',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Utah','UT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Vermont','VT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Virginia','VA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Washington','WA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'West Virginia','WV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Wisconsin','WI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Wyoming','WY',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Acre','AC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Alagoas','AL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Amapá','AP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Amazonas','AM',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Bahia','BA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Ceará','CE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Distrito Federal','DF',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Espírito Santo','ES',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Goiás','GO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Maranhão','MA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Mato Grosso','MT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Mato Grosso do Sul','MS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Minas Gerais','MG',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Pará','PA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Paraíba','PB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Paraná','PR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Pernambuco','PE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Piauí','PI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Rio de Janeiro','RJ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Rio Grande do Norte','RN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Rio Grande do Sul','RS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Rondônia','RO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Roraima','RR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Santa Catarina','SC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'São Paulo','SP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Sergipe','SE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(36,'Tocantins','TO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Catamarca','K',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Chaco','H',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Chubut','U',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Ciudad Autónoma de Buenos Aires','C',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Córdoba','X',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Corrientes','W',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Entre Ríos','E',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Formosa','P',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Jujuy','Y',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'La Pampa','L',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'La Rioja','F',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Mendoza','M',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Misiones','N',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Neuquén','Q',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Río Negro','R',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Salta','A',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'San Juan','J',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'San Luis','D',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Santa Cruz','Z',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Santa Fe','S',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Santiago del Estero','G',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Tierra del Fuego','V',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(51,'Tucumán','T',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Andaman and Nicobar Islands','AN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Andhra Pradesh','AP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Arunachal Pradesh','AR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Assam','AS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Bihar','BR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Chandigarh','CH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Chhattisgarh','CT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Dadra and Nagar Haveli','DN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Daman and Diu','DD',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Delhi','DL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Goa','GA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Gujarat','GJ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Haryana','HR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Himachal Pradesh','HP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Jammu and Kashmir','JK',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Jharkhand','JH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Karnataka','KA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Kerala','KL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Lakshadweep','LD',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Madhya Pradesh','MP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Maharashtra','MH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Manipur','MN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Meghalaya','ML',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Mizoram','MZ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Nagaland','NL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Orissa','OR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Pondicherry','PY',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Punjab','PB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Rajasthan','RJ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Sikkim','SK',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Tamil Nadu','TN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Tripura','TR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Uttar Pradesh','UP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'Uttaranchal','UT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(112,'West Bengal','WB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Aguascalientes','AGU',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Baja California','BCN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Baja California Sur','BCS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Campeche','CAM',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Chiapas','CHP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Chihuahua','CHH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Coahuila','COA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Colima','COL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Distrito Federal','DIF',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Durango','DUR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Guanajuato','GUA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Guerrero','GRO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Hidalgo','HID',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Jalisco','JAL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'México','MEX',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Michoacán','MIC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Morelos','MOR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Nayarit','NAY',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Nuevo León','NLE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Oaxaca','OAX',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Puebla','PUE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Querétaro','QUE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Quintana Roo','ROO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'San Luis Potosí','SLP',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Sinaloa','SIN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Sonora','SON',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Tabasco','TAB',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Tamaulipas','TAM',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Tlaxcala','TLA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Veracruz','VER',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Yucatán','YUC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(159,'Zacatecas','ZAC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Amnat Charoen','37',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Ang Thong','15',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Buri Ram','31',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Chachoengsao','24',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Chai Nat','18',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Chaiyaphum','36',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Chanthaburi','22',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Chiang Mai','50',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Chiang Rai','57',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Chon Buri','20',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Chumphon','86',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Kalasin','46',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Kamphaeng Phet','62',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Kanchanaburi','71',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Khon Kaen','40',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Krabi','81',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Krung Thep Maha Nakhon [Bangkok]','10',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Lampang','52',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Lamphun','51',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Loei','42',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Lop Buri','16',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Mae Hong Son','58',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Maha Sarakham','44',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Mukdahan','49',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nakhon Nayok','26',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nakhon Pathom','73',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nakhon Phanom','48',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nakhon Ratchasima','30',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nakhon Sawan','60',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nakhon Si Thammarat','80',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nan','55',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Narathiwat','96',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nong Bua Lam Phu','39',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nong Khai','43',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Nonthaburi','12',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Pathum Thani','13',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Pattani','94',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phangnga','82',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phatthalung','93',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phatthaya','S',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phayao','56',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phetchabun','67',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phetchaburi','76',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phichit','66',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phitsanulok','65',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phra Nakhon Si Ayutthaya','14',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phrae','54',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Phuket','83',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Prachin Buri','25',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Prachuap Khiri Khan','77',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Ranong','85',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Ratchaburi','70',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Rayong','21',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Roi Et','45',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Sa Kaeo','27',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Sakon Nakhon','47',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Samut Prakan','11',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Samut Sakhon','74',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Samut Songkhram','75',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Saraburi','19',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Satun','91',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Si Sa Ket','33',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Sing Buri','17',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Songkhla','90',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Sukhothai','64',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Suphan Buri','72',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Surat Thani','84',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Surin','32',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Tak','63',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Trang','92',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Trat','23',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Ubon Ratchathani','34',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Udon Thani','41',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Uthai Thani','61',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Uttaradit','53',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Yala','95',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(228,'Yasothon','35',0,1);

 

vom 29.11.17 um 12:33




"
Schreibe EXWE auf WhatsApp