TABELLA directory_country_region_name

INSERT INTO `directory_country_region` VALUES(278, 'IT', 'AG', 'Agrigento');
INSERT INTO `directory_country_region` VALUES(279, 'IT', 'AL', 'Alessandria');
INSERT INTO `directory_country_region` VALUES(280, 'IT', 'AN', 'Ancona');
INSERT INTO `directory_country_region` VALUES(281, 'IT', 'AO', 'Aosta');
INSERT INTO `directory_country_region` VALUES(282, 'IT', 'AR', 'Arezzo');
INSERT INTO `directory_country_region` VALUES(283, 'IT', 'AP', 'Ascoli Piceno');
INSERT INTO `directory_country_region` VALUES(284, 'IT', 'AT', 'Asti');
INSERT INTO `directory_country_region` VALUES(285, 'IT', 'AV', 'Avellino');
INSERT INTO `directory_country_region` VALUES(286, 'IT', 'BA', 'Bari');
INSERT INTO `directory_country_region` VALUES(287, 'IT', 'BL', 'Belluno');
INSERT INTO `directory_country_region` VALUES(288, 'IT', 'BN', 'Benevento');
INSERT INTO `directory_country_region` VALUES(289, 'IT', 'BG', 'Bergamo');
INSERT INTO `directory_country_region` VALUES(290, 'IT', 'BI', 'Biella');
INSERT INTO `directory_country_region` VALUES(291, 'IT', 'BO', 'Bologna');
INSERT INTO `directory_country_region` VALUES(292, 'IT', 'BZ', 'Bolzano');
INSERT INTO `directory_country_region` VALUES(293, 'IT', 'BS', 'Brescia');
INSERT INTO `directory_country_region` VALUES(294, 'IT', 'BR', 'Brindisi');
INSERT INTO `directory_country_region` VALUES(295, 'IT', 'CA', 'Cagliari');
INSERT INTO `directory_country_region` VALUES(296, 'IT', 'CL', 'Caltanissetta');
INSERT INTO `directory_country_region` VALUES(297, 'IT', 'CB', 'Campobasso');
INSERT INTO `directory_country_region` VALUES(298, 'IT', 'CI', 'Carbonia-Iglesias');
INSERT INTO `directory_country_region` VALUES(299, 'IT', 'CE', 'Caserta');
INSERT INTO `directory_country_region` VALUES(300, 'IT', 'CT', 'Catania');
INSERT INTO `directory_country_region` VALUES(301, 'IT', 'CZ', 'Catanzaro');
INSERT INTO `directory_country_region` VALUES(302, 'IT', 'CH', 'Chieti');
INSERT INTO `directory_country_region` VALUES(303, 'IT', 'CO', 'Como');
INSERT INTO `directory_country_region` VALUES(304, 'IT', 'CS', 'Cosenza');
INSERT INTO `directory_country_region` VALUES(305, 'IT', 'CR', 'Cremona');
INSERT INTO `directory_country_region` VALUES(306, 'IT', 'KR', 'Crotone');
INSERT INTO `directory_country_region` VALUES(307, 'IT', 'CN', 'Cuneo');
INSERT INTO `directory_country_region` VALUES(308, 'IT', 'EN', 'Enna');
INSERT INTO `directory_country_region` VALUES(309, 'IT', 'FE', 'Ferrara');
INSERT INTO `directory_country_region` VALUES(310, 'IT', 'FI', 'Firenze');
INSERT INTO `directory_country_region` VALUES(311, 'IT', 'FG', 'Foggia');
INSERT INTO `directory_country_region` VALUES(312, 'IT', 'FC', 'Forlė-Cesena');
INSERT INTO `directory_country_region` VALUES(313, 'IT', 'FR', 'Frosinone');
INSERT INTO `directory_country_region` VALUES(314, 'IT', 'GE', 'Genova');
INSERT INTO `directory_country_region` VALUES(315, 'IT', 'GO', 'Gorizia');
INSERT INTO `directory_country_region` VALUES(316, 'IT', 'GR', 'Grosseto');
INSERT INTO `directory_country_region` VALUES(317, 'IT', 'IM', 'Imperia');
INSERT INTO `directory_country_region` VALUES(318, 'IT', 'IS', 'Isernia');
INSERT INTO `directory_country_region` VALUES(319, 'IT', 'AQ', 'L''Aquila');
INSERT INTO `directory_country_region` VALUES(320, 'IT', 'SP', 'La Spezia');
INSERT INTO `directory_country_region` VALUES(321, 'IT', 'LT', 'Latina');
INSERT INTO `directory_country_region` VALUES(322, 'IT', 'LE', 'Lecce');
INSERT INTO `directory_country_region` VALUES(323, 'IT', 'LC', 'Lecco');
INSERT INTO `directory_country_region` VALUES(324, 'IT', 'LI', 'Livorno');
INSERT INTO `directory_country_region` VALUES(325, 'IT', 'LO', 'Lodi');
INSERT INTO `directory_country_region` VALUES(326, 'IT', 'LU', 'Lucca');
INSERT INTO `directory_country_region` VALUES(327, 'IT', 'MC', 'Macerata');
INSERT INTO `directory_country_region` VALUES(328, 'IT', 'MN', 'Mantova');
INSERT INTO `directory_country_region` VALUES(329, 'IT', 'MS', 'Massa-Carrara');
INSERT INTO `directory_country_region` VALUES(330, 'IT', 'MT', 'Matera');
INSERT INTO `directory_country_region` VALUES(331, 'IT', 'VS', 'Medio Campidano');
INSERT INTO `directory_country_region` VALUES(332, 'IT', 'ME', 'Messina');
INSERT INTO `directory_country_region` VALUES(333, 'IT', 'MI', 'Milano');
INSERT INTO `directory_country_region` VALUES(334, 'IT', 'MO', 'Modena');
INSERT INTO `directory_country_region` VALUES(335, 'IT', 'NA', 'Napoli');
INSERT INTO `directory_country_region` VALUES(336, 'IT', 'NO', 'Novara');
INSERT INTO `directory_country_region` VALUES(337, 'IT', 'NU', 'Nuoro');
INSERT INTO `directory_country_region` VALUES(338, 'IT', 'OG', 'Ogliastra');
INSERT INTO `directory_country_region` VALUES(339, 'IT', 'OT', 'Olbia-Tempio');
INSERT INTO `directory_country_region` VALUES(340, 'IT', 'OR', 'Oristano');
INSERT INTO `directory_country_region` VALUES(341, 'IT', 'PD', 'Padova');
INSERT INTO `directory_country_region` VALUES(342, 'IT', 'PA', 'Palermo');
INSERT INTO `directory_country_region` VALUES(343, 'IT', 'PR', 'Parma');
INSERT INTO `directory_country_region` VALUES(344, 'IT', 'PV', 'Pavia');
INSERT INTO `directory_country_region` VALUES(345, 'IT', 'PG', 'Perugia');
INSERT INTO `directory_country_region` VALUES(346, 'IT', 'PU', 'Pesaro Urbino');
INSERT INTO `directory_country_region` VALUES(347, 'IT', 'PE', 'Pescara');
INSERT INTO `directory_country_region` VALUES(348, 'IT', 'PC', 'Piacenza');
INSERT INTO `directory_country_region` VALUES(349, 'IT', 'PI', 'Pisa');
INSERT INTO `directory_country_region` VALUES(350, 'IT', 'PT', 'Pistoia');
INSERT INTO `directory_country_region` VALUES(351, 'IT', 'PN', 'Pordenone');
INSERT INTO `directory_country_region` VALUES(352, 'IT', 'PZ', 'Potenza');
INSERT INTO `directory_country_region` VALUES(353, 'IT', 'PO', 'Prato');
INSERT INTO `directory_country_region` VALUES(354, 'IT', 'RG', 'Ragusa');
INSERT INTO `directory_country_region` VALUES(355, 'IT', 'RA', 'Ravenna');
INSERT INTO `directory_country_region` VALUES(356, 'IT', 'RC', 'Reggio Calabria');
INSERT INTO `directory_country_region` VALUES(357, 'IT', 'RE', 'Reggio Emilia');
INSERT INTO `directory_country_region` VALUES(358, 'IT', 'RI', 'Rieti');
INSERT INTO `directory_country_region` VALUES(359, 'IT', 'RN', 'Rimini');
INSERT INTO `directory_country_region` VALUES(360, 'IT', 'RM', 'Roma');
INSERT INTO `directory_country_region` VALUES(361, 'IT', 'RO', 'Rovigo');
INSERT INTO `directory_country_region` VALUES(362, 'IT', 'SA', 'Salerno');
INSERT INTO `directory_country_region` VALUES(363, 'IT', 'SS', 'Sassari');
INSERT INTO `directory_country_region` VALUES(364, 'IT', 'SV', 'Savona');
INSERT INTO `directory_country_region` VALUES(365, 'IT', 'SI', 'Siena');
INSERT INTO `directory_country_region` VALUES(366, 'IT', 'SR', 'Siracusa');
INSERT INTO `directory_country_region` VALUES(367, 'IT', 'SO', 'Sondrio');
INSERT INTO `directory_country_region` VALUES(368, 'IT', 'TA', 'Taranto');
INSERT INTO `directory_country_region` VALUES(369, 'IT', 'TE', 'Teramo');
INSERT INTO `directory_country_region` VALUES(370, 'IT', 'TR', 'Terni');
INSERT INTO `directory_country_region` VALUES(371, 'IT', 'TO', 'Torino');
INSERT INTO `directory_country_region` VALUES(372, 'IT', 'TP', 'Trapani');
INSERT INTO `directory_country_region` VALUES(373, 'IT', 'TN', 'Trento');
INSERT INTO `directory_country_region` VALUES(374, 'IT', 'TV', 'Treviso');
INSERT INTO `directory_country_region` VALUES(375, 'IT', 'TS', 'Trieste');
INSERT INTO `directory_country_region` VALUES(376, 'IT', 'UD', 'Udine');
INSERT INTO `directory_country_region` VALUES(377, 'IT', 'VA', 'Varese');
INSERT INTO `directory_country_region` VALUES(378, 'IT', 'VE', 'Venezia');
INSERT INTO `directory_country_region` VALUES(379, 'IT', 'VB', 'Verbano-Cusio-Ossola');
INSERT INTO `directory_country_region` VALUES(380, 'IT', 'VC', 'Vercelli');
INSERT INTO `directory_country_region` VALUES(381, 'IT', 'VR', 'Verona');
INSERT INTO `directory_country_region` VALUES(382, 'IT', 'VV', 'Vibo Valentia');
INSERT INTO `directory_country_region` VALUES(383, 'IT', 'VI', 'Vicenza');
INSERT INTO `directory_country_region` VALUES(384, 'IT', 'VT', 'Viterbo');



TABELLA directory_country_region_name

INSERT INTO `directory_country_region_name` VALUES('en_US', 278, 'Agrigento');
INSERT INTO `directory_country_region_name` VALUES('en_US', 279, 'Alessandria');
INSERT INTO `directory_country_region_name` VALUES('en_US', 280, 'Ancona');
INSERT INTO `directory_country_region_name` VALUES('en_US', 281, 'Aosta');
INSERT INTO `directory_country_region_name` VALUES('en_US', 282, 'Arezzo');
INSERT INTO `directory_country_region_name` VALUES('en_US', 283, 'Ascoli Piceno');
INSERT INTO `directory_country_region_name` VALUES('en_US', 284, 'Asti');
INSERT INTO `directory_country_region_name` VALUES('en_US', 285, 'Avellino');
INSERT INTO `directory_country_region_name` VALUES('en_US', 286, 'Bari');
INSERT INTO `directory_country_region_name` VALUES('en_US', 287, 'Belluno');
INSERT INTO `directory_country_region_name` VALUES('en_US', 288, 'Benevento');
INSERT INTO `directory_country_region_name` VALUES('en_US', 289, 'Bergamo');
INSERT INTO `directory_country_region_name` VALUES('en_US', 290, 'Biella');
INSERT INTO `directory_country_region_name` VALUES('en_US', 291, 'Bologna');
INSERT INTO `directory_country_region_name` VALUES('en_US', 292, 'Bolzano');
INSERT INTO `directory_country_region_name` VALUES('en_US', 293, 'Brescia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 294, 'Brindisi');
INSERT INTO `directory_country_region_name` VALUES('en_US', 295, 'Cagliari');
INSERT INTO `directory_country_region_name` VALUES('en_US', 296, 'Caltanisetta');
INSERT INTO `directory_country_region_name` VALUES('en_US', 297, 'Campobasso');
INSERT INTO `directory_country_region_name` VALUES('en_US', 298, 'Carbonia-Iglesias');
INSERT INTO `directory_country_region_name` VALUES('en_US', 299, 'Caserta');
INSERT INTO `directory_country_region_name` VALUES('en_US', 300, 'Catania');
INSERT INTO `directory_country_region_name` VALUES('en_US', 301, 'Catanzaro');
INSERT INTO `directory_country_region_name` VALUES('en_US', 302, 'Chieti');
INSERT INTO `directory_country_region_name` VALUES('en_US', 303, 'Como');
INSERT INTO `directory_country_region_name` VALUES('en_US', 304, 'Cosenza');
INSERT INTO `directory_country_region_name` VALUES('en_US', 305, 'Cremona');
INSERT INTO `directory_country_region_name` VALUES('en_US', 306, 'Crotone');
INSERT INTO `directory_country_region_name` VALUES('en_US', 307, 'Cuneo');
INSERT INTO `directory_country_region_name` VALUES('en_US', 308, 'Enna');
INSERT INTO `directory_country_region_name` VALUES('en_US', 309, 'Ferrara');
INSERT INTO `directory_country_region_name` VALUES('en_US', 310, 'Firenze');
INSERT INTO `directory_country_region_name` VALUES('en_US', 311, 'Foggia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 312, 'Forlė-Cesena');
INSERT INTO `directory_country_region_name` VALUES('en_US', 313, 'Frosinone');
INSERT INTO `directory_country_region_name` VALUES('en_US', 314, 'Genova');
INSERT INTO `directory_country_region_name` VALUES('en_US', 315, 'Gorizia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 316, 'Grosseto');
INSERT INTO `directory_country_region_name` VALUES('en_US', 317, 'Imperia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 318, 'Isernia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 319, 'L''Aquila');
INSERT INTO `directory_country_region_name` VALUES('en_US', 320, 'La Spezia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 321, 'Latina');
INSERT INTO `directory_country_region_name` VALUES('en_US', 322, 'Lecce');
INSERT INTO `directory_country_region_name` VALUES('en_US', 323, 'Lecco');
INSERT INTO `directory_country_region_name` VALUES('en_US', 324, 'Livorno');
INSERT INTO `directory_country_region_name` VALUES('en_US', 325, 'Lodi');
INSERT INTO `directory_country_region_name` VALUES('en_US', 326, 'Lucca');
INSERT INTO `directory_country_region_name` VALUES('en_US', 327, 'Macerata');
INSERT INTO `directory_country_region_name` VALUES('en_US', 328, 'Mantova');
INSERT INTO `directory_country_region_name` VALUES('en_US', 329, 'Massa-Carrara');
INSERT INTO `directory_country_region_name` VALUES('en_US', 330, 'Matera');
INSERT INTO `directory_country_region_name` VALUES('en_US', 331, 'Medio Campidano');
INSERT INTO `directory_country_region_name` VALUES('en_US', 332, 'Messina');
INSERT INTO `directory_country_region_name` VALUES('en_US', 333, 'Milano');
INSERT INTO `directory_country_region_name` VALUES('en_US', 334, 'Modena');
INSERT INTO `directory_country_region_name` VALUES('en_US', 335, 'Napoli');
INSERT INTO `directory_country_region_name` VALUES('en_US', 336, 'Novara');
INSERT INTO `directory_country_region_name` VALUES('en_US', 337, 'Nuoro');
INSERT INTO `directory_country_region_name` VALUES('en_US', 338, 'Ogliastra');
INSERT INTO `directory_country_region_name` VALUES('en_US', 339, 'Olbia-Tempio');
INSERT INTO `directory_country_region_name` VALUES('en_US', 340, 'Oristano');
INSERT INTO `directory_country_region_name` VALUES('en_US', 341, 'Padova');
INSERT INTO `directory_country_region_name` VALUES('en_US', 342, 'Palermo');
INSERT INTO `directory_country_region_name` VALUES('en_US', 343, 'Parma');
INSERT INTO `directory_country_region_name` VALUES('en_US', 344, 'Pavia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 345, 'Perugia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 346, 'Pesaro Urbino');
INSERT INTO `directory_country_region_name` VALUES('en_US', 347, 'Pescara');
INSERT INTO `directory_country_region_name` VALUES('en_US', 348, 'Piacenza');
INSERT INTO `directory_country_region_name` VALUES('en_US', 349, 'Pisa');
INSERT INTO `directory_country_region_name` VALUES('en_US', 350, 'Pistoia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 351, 'Pordenone');
INSERT INTO `directory_country_region_name` VALUES('en_US', 352, 'Potenza');
INSERT INTO `directory_country_region_name` VALUES('en_US', 353, 'Prato');
INSERT INTO `directory_country_region_name` VALUES('en_US', 354, 'Ragusa');
INSERT INTO `directory_country_region_name` VALUES('en_US', 355, 'Ravenna');
INSERT INTO `directory_country_region_name` VALUES('en_US', 356, 'Reggio Calabria');
INSERT INTO `directory_country_region_name` VALUES('en_US', 357, 'Reggio Emilia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 358, 'Rieti');
INSERT INTO `directory_country_region_name` VALUES('en_US', 359, 'Rimini');
INSERT INTO `directory_country_region_name` VALUES('en_US', 360, 'Roma');
INSERT INTO `directory_country_region_name` VALUES('en_US', 361, 'Rovigo');
INSERT INTO `directory_country_region_name` VALUES('en_US', 362, 'Salerno');
INSERT INTO `directory_country_region_name` VALUES('en_US', 363, 'Sassari');
INSERT INTO `directory_country_region_name` VALUES('en_US', 364, 'Savona');
INSERT INTO `directory_country_region_name` VALUES('en_US', 365, 'Siena');
INSERT INTO `directory_country_region_name` VALUES('en_US', 366, 'Siracusa');
INSERT INTO `directory_country_region_name` VALUES('en_US', 367, 'Sondrio');
INSERT INTO `directory_country_region_name` VALUES('en_US', 368, 'Taranto');
INSERT INTO `directory_country_region_name` VALUES('en_US', 369, 'Teramo');
INSERT INTO `directory_country_region_name` VALUES('en_US', 370, 'Terni');
INSERT INTO `directory_country_region_name` VALUES('en_US', 371, 'Torino');
INSERT INTO `directory_country_region_name` VALUES('en_US', 372, 'Trapani');
INSERT INTO `directory_country_region_name` VALUES('en_US', 373, 'Trento');
INSERT INTO `directory_country_region_name` VALUES('en_US', 374, 'Treviso');
INSERT INTO `directory_country_region_name` VALUES('en_US', 375, 'Trieste');
INSERT INTO `directory_country_region_name` VALUES('en_US', 376, 'Udine');
INSERT INTO `directory_country_region_name` VALUES('en_US', 377, 'Varese');
INSERT INTO `directory_country_region_name` VALUES('en_US', 378, 'Venezia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 379, 'Verbano-Cusio-Ossola');
INSERT INTO `directory_country_region_name` VALUES('en_US', 380, 'Vercelli');
INSERT INTO `directory_country_region_name` VALUES('en_US', 381, 'Verona');
INSERT INTO `directory_country_region_name` VALUES('en_US', 382, 'Vibo Valentia');
INSERT INTO `directory_country_region_name` VALUES('en_US', 383, 'Vicenza');
INSERT INTO `directory_country_region_name` VALUES('en_US', 384, 'Viterbo');