CREATE TABLE province (
    codice serial,
    regione integer,
    provincia character varying,
    sigla character varying,
    locale character varying DEFAULT 'it'::character varying NOT NULL
);

INSERT INTO province VALUES (15, 4, 'Napoli', 'NA', 'it');
INSERT INTO province VALUES (32, 7, 'Roma', 'RM', 'it');
INSERT INTO province VALUES (46, 9, 'Milano', 'MI', 'it');
INSERT INTO province VALUES (12, 4, 'Avellino', 'AV', 'it');
INSERT INTO province VALUES (1, 1, 'L''Aquila', 'AQ', 'it');
INSERT INTO province VALUES (2, 1, 'Chieti', 'CH', 'it');
INSERT INTO province VALUES (3, 1, 'Pescara', 'PE', 'it');
INSERT INTO province VALUES (4, 1, 'Teramo', 'TE', 'it');
INSERT INTO province VALUES (5, 2, 'Matera', 'MT', 'it');
INSERT INTO province VALUES (6, 2, 'Potenza', 'PZ', 'it');
INSERT INTO province VALUES (7, 3, 'Catanzaro', 'CZ', 'it');
INSERT INTO province VALUES (8, 3, 'Cosenza', 'CS', 'it');
INSERT INTO province VALUES (9, 3, 'Crotone', 'KR', 'it');
INSERT INTO province VALUES (10, 3, 'Reggio Calabria', 'RC', 'it');
INSERT INTO province VALUES (11, 3, 'Vibo Valentia', 'VV', 'it');
INSERT INTO province VALUES (13, 4, 'Benevento', 'BN', 'it');
INSERT INTO province VALUES (14, 4, 'Caserta', 'CE', 'it');
INSERT INTO province VALUES (16, 4, 'Salerno', 'SA', 'it');
INSERT INTO province VALUES (17, 5, 'Piacenza', 'PC', 'it');
INSERT INTO province VALUES (18, 5, 'Parma', 'PR', 'it');
INSERT INTO province VALUES (19, 5, 'Reggio Emilia', 'RE', 'it');
INSERT INTO province VALUES (20, 5, 'Modena', 'MO', 'it');
INSERT INTO province VALUES (21, 5, 'Bologna', 'BO', 'it');
INSERT INTO province VALUES (22, 5, 'Ferrara', 'FE', 'it');
INSERT INTO province VALUES (23, 5, 'Ravenna', 'RA', 'it');
INSERT INTO province VALUES (25, 5, 'Rimini', 'RN', 'it');
INSERT INTO province VALUES (26, 6, 'Pordenone', 'PN', 'it');
INSERT INTO province VALUES (104, 0, ' Stato Estero', 'EE', 'it');
INSERT INTO province VALUES (75, 15, 'Agrigento', 'AG', 'it');
INSERT INTO province VALUES (56, 12, 'Alessandria', 'AL', 'it');
INSERT INTO province VALUES (51, 10, 'Ancona', 'AN', 'it');
INSERT INTO province VALUES (103, 20, 'Aosta', 'AO', 'it');
INSERT INTO province VALUES (87, 16, 'Arezzo', 'AR', 'it');
INSERT INTO province VALUES (53, 10, 'Ascoli Piceno', 'AP', 'it');
INSERT INTO province VALUES (57, 12, 'Asti', 'AT', 'it');
INSERT INTO province VALUES (65, 13, 'Bari', 'BA', 'it');
INSERT INTO province VALUES (96, 19, 'Belluno', 'BL', 'it');
INSERT INTO province VALUES (39, 9, 'Bergamo', 'BG', 'it');
INSERT INTO province VALUES (58, 12, 'Biella', 'BI', 'it');
INSERT INTO province VALUES (92, 17, 'Bolzano', 'BZ', 'it');
INSERT INTO province VALUES (40, 9, 'Brescia', 'BS', 'it');
INSERT INTO province VALUES (67, 13, 'Brindisi', 'BR', 'it');
INSERT INTO province VALUES (72, 14, 'Cagliari', 'CA', 'it');
INSERT INTO province VALUES (76, 15, 'Caltanissetta', 'CL', 'it');
INSERT INTO province VALUES (55, 11, 'Campobasso', 'CB', 'it');
INSERT INTO province VALUES (79, 15, 'Catania', 'CT', 'it');
INSERT INTO province VALUES (41, 9, 'Como', 'CO', 'it');
INSERT INTO province VALUES (42, 9, 'Cremona', 'CR', 'it');
INSERT INTO province VALUES (59, 12, 'Cuneo', 'CN', 'it');
INSERT INTO province VALUES (77, 15, 'Enna', 'EN', 'it');
INSERT INTO province VALUES (86, 16, 'Firenze', 'FI', 'it');
INSERT INTO province VALUES (64, 13, 'Foggia', 'FG', 'it');
INSERT INTO province VALUES (34, 7, 'Frosinone', 'FR', 'it');
INSERT INTO province VALUES (37, 8, 'Genova', 'GE', 'it');
INSERT INTO province VALUES (28, 6, 'Gorizia', 'GO', 'it');
INSERT INTO province VALUES (91, 16, 'Grosseto', 'GR', 'it');
INSERT INTO province VALUES (35, 8, 'Imperia', 'IM', 'it');
INSERT INTO province VALUES (54, 11, 'Isernia', 'IS', 'it');
INSERT INTO province VALUES (38, 8, 'La Spezia', 'SP', 'it');
INSERT INTO province VALUES (33, 7, 'Latina', 'LT', 'it');
INSERT INTO province VALUES (68, 13, 'Lecce', 'LE', 'it');
INSERT INTO province VALUES (43, 9, 'Lecco', 'LC', 'it');
INSERT INTO province VALUES (90, 16, 'Livorno', 'LI', 'it');
INSERT INTO province VALUES (44, 9, 'Lodi', 'LO', 'it');
INSERT INTO province VALUES (83, 16, 'Lucca', 'LU', 'it');
INSERT INTO province VALUES (52, 10, 'Macerata', 'MC', 'it');
INSERT INTO province VALUES (45, 9, 'Mantova', 'MN', 'it');
INSERT INTO province VALUES (82, 16, 'Massa Carrara', 'MS', 'it');
INSERT INTO province VALUES (78, 15, 'Messina', 'ME', 'it');
INSERT INTO province VALUES (60, 12, 'Novara', 'NO', 'it');
INSERT INTO province VALUES (70, 14, 'Nuoro', 'NU', 'it');
INSERT INTO province VALUES (71, 14, 'Oristano', 'OR', 'it');
INSERT INTO province VALUES (99, 19, 'Padova', 'PD', 'it');
INSERT INTO province VALUES (74, 15, 'Palermo', 'PA', 'it');
INSERT INTO province VALUES (47, 9, 'Pavia', 'PV', 'it');
INSERT INTO province VALUES (94, 18, 'Perugia', 'PG', 'it');
INSERT INTO province VALUES (50, 10, 'Pesaro e Urbino', 'PS', 'it');
INSERT INTO province VALUES (89, 16, 'Pisa', 'PI', 'it');
INSERT INTO province VALUES (84, 16, 'Pistoia', 'PT', 'it');
INSERT INTO province VALUES (85, 16, 'Prato', 'PO', 'it');
INSERT INTO province VALUES (81, 15, 'Ragusa', 'RG', 'it');
INSERT INTO province VALUES (31, 7, 'Rieti', 'RI', 'it');
INSERT INTO province VALUES (101, 19, 'Rovigo', 'RO', 'it');
INSERT INTO province VALUES (69, 14, 'Sassari', 'SS', 'it');
INSERT INTO province VALUES (36, 8, 'Savona', 'SV', 'it');
INSERT INTO province VALUES (88, 16, 'Siena', 'SI', 'it');
INSERT INTO province VALUES (80, 15, 'Siracusa', 'SR', 'it');
INSERT INTO province VALUES (48, 9, 'Sondrio', 'SO', 'it');
INSERT INTO province VALUES (66, 13, 'Taranto', 'TA', 'it');
INSERT INTO province VALUES (95, 18, 'Terni', 'TR', 'it');
INSERT INTO province VALUES (61, 12, 'Torino', 'TO', 'it');
INSERT INTO province VALUES (73, 15, 'Trapani', 'TP', 'it');
INSERT INTO province VALUES (93, 17, 'Trento', 'TN', 'it');
INSERT INTO province VALUES (97, 19, 'Treviso', 'TV', 'it');
INSERT INTO province VALUES (29, 6, 'Trieste', 'TS', 'it');
INSERT INTO province VALUES (27, 6, 'Udine', 'UD', 'it');
INSERT INTO province VALUES (49, 9, 'Varese', 'VA', 'it');
INSERT INTO province VALUES (100, 19, 'Venezia', 'VE', 'it');
INSERT INTO province VALUES (63, 12, 'Vercelli', 'VC', 'it');
INSERT INTO province VALUES (102, 19, 'Verona', 'VR', 'it');
INSERT INTO province VALUES (98, 19, 'Vicenza', 'VI', 'it');
INSERT INTO province VALUES (30, 7, 'Viterbo', 'VT', 'it');
INSERT INTO province VALUES (62, 12, 'Verbano-Cusio-Ossola', 'VB', 'it');
INSERT INTO province VALUES (104, 0, 'Not Italy', 'EE', 'en');
INSERT INTO province VALUES (24, 5, 'Forli'' e Cesena', 'FC', 'it');

CREATE INDEX province_codice_key ON province USING btree (codice);
CREATE INDEX province_regione_key ON province USING btree (regione);

select setval('province_codice_seq', (select max(codice) from province), true);