Code: Select all
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (105,'NA','NAPOLI'),
(105,'BA','BARI'),
(105,'BO','BOLOGNA'),
(105,'CA','CAGLIARI'),
(105,'CT','CATANIA'),
(105,'FI','FIRENZE'),
(105,'GE','GENOVA'),
(105,'ME','MESSINA'),
(105,'MI','MILANO'),
(105,'PA','PALERMO'),
(105,'RC','REGGIO CALABRIA'),
(105,'RM','ROMA'),
(105,'TO','TORINO'),
(105,'VE','VENEZIA'),
(105,'AG','Agrigento'),
(105,'AL', 'Alessandria'),
(105,'AN', 'Ancona'),
(105,'AR', 'Arezzo'),
(105,'AP', 'Ascoli Piceno'),
(105,'AT', 'Asti'),
(105,'AV', 'Avellino'),
(105,'BT', 'Barletta-Andria-Trani'),
(105,'BL', 'Belluno'),
(105,'BN', 'Benevento'),
(105,'BG', 'Bergamo'),
(105,'BI', 'Biella'),
(105,'BZ', 'Bolzano'),
(105,'BS', 'Brescia'),
(105,'BR', 'Brindisi'),
(105,'CL', 'Caltanissetta'),
(105,'CB', 'Campobasso'),
(105,'CE', 'Caserta'),
(105,'CZ', 'Catanzaro'),
(105,'CH', 'Chieti'),
(105,'CO', 'Como'),
(105,'CS', 'Cosenza'),
(105,'CR', 'Cremona'),
(105,'KR', 'Crotone'),
(105,'CN', 'Cuneo'),
(105,'EN', 'Enna'),
(105,'FM', 'Fermo'),
(105,'FE', 'Ferrara'),
(105,'FG', 'Foggia'),
(105,'FC', 'Forlì-Cesena'),
(105,'FR', 'Frosinone'),
(105,'GO', 'Gorizia'),
(105,'GR', 'Grosseto'),
(105,'IM', 'Imperia'),
(105,'IS', 'Isernia'),
(105,'AQ', 'L\'Aquila'),
(105,'SP', 'La Spezia'),
(105,'LT', 'Latina'),
(105,'LE', 'Lecce'),
(105,'LC', 'Lecco'),
(105,'LI', 'Livorno'),
(105,'LO', 'Lodi'),
(105,'LU', 'Lucca'),
(105,'MC', 'Macerata'),
(105,'MN', 'Mantova'),
(105,'MS', 'Massa-Carrara'),
(105,'MT', 'Matera'),
(105,'MO', 'Modena'),
(105,'MB', 'Monza e Brianza'),
(105,'NO', 'Novara'),
(105,'NU', 'Nuoro'),
(105,'OR', 'Oristano'),
(105,'PD', 'Padova'),
(105,'PR', 'Parma'),
(105,'PV', 'Pavia'),
(105,'PG', 'Perugia'),
(105,'PU', 'Pesaro e Urbino'),
(105,'PE', 'Pescara'),
(105,'PC', 'Piacenza'),
(105,'PI', 'Pisa'),
(105,'PT', 'Pistoia'),
(105,'PN', 'Pordenone'),
(105,'PZ', 'Potenza'),
(105,'PO', 'Prato'),
(105,'RG', 'Ragusa'),
(105,'RA', 'Ravenna'),
(105,'RE', 'Reggio Emilia'),
(105,'RI', 'Rieti'),
(105,'RN', 'Rimini'),
(105,'RO', 'Rovigo'),
(105,'SA', 'Salerno'),
(105,'SS', 'Sassari'),
(105,'SV', 'Savona'),
(105,'SI', 'Siena'),
(105,'SR', 'Siracusa'),
(105,'SO', 'Sondrio'),
(105,'SU', 'Sud Sardegna'),
(105,'TA', 'Taranto'),
(105,'TE', 'Teramo'),
(105,'TR', 'Terni'),
(105,'TP', 'Trapani'),
(105,'TN', 'Trento'),
(105,'TV', 'Treviso'),
(105,'TS', 'Trieste'),
(105,'UD', 'Udine'),
(105,'VA', 'Varese'),
(105,'VB', 'Verbano-Cusio-Ossola'),
(105,'VC', 'Vercelli'),
(105,'VR', 'Verona'),
(105,'VV', 'Vibo Valentia'),
(105,'VI', 'Vicenza'),
(105,'VT', 'Viterbo');