

CREATE TABLE IF NOT EXISTS `province` (
  `sigla` char(2) NOT NULL,
  `nome` varchar(100) NOT NULL,
  `id_regione` varchar(40) NOT NULL,
  PRIMARY KEY  (`sigla`)
) ;

--
-- Dump dei dati per la tabella `province`
--

INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('AQ', 'L''AQUILA', '1');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CH', 'CHIETI', '1');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PE', 'PESCARA', '1');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('TE', 'TERAMO', '1');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('MT', 'MATERA', '2');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PZ', 'POTENZA', '2');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CS', 'COSENZA', '3');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CZ', 'CATANZARO', '3');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('KR', 'CROTONE', '3');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('RC', 'REGGIO CALABRIA', '3');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('VV', 'VIBO VALENTIA', '3');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('AV', 'AVELLINO', '4');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('BN', 'BENEVENTO', '4');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CE', 'CASERTA', '4');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('NA', 'NAPOLI', '4');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('SA', 'SALERNO', '4');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('BO', 'BOLOGNA', '5');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('FE', 'FERRARA', '5');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('FC', 'FORLI''-CESENA', '5');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('MO', 'MODENA', '5');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PC', 'PIACENZA', '5');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PR', 'PARMA', '5');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('RA', 'RAVENNA', '5');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('RE', 'REGGIO EMILIA', '5');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('RN', 'RIMINI', '5');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('GO', 'GORIZIA', '6');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PN', 'PORDENONE', '6');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('TS', 'TRIESTE', '6');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('UD', 'UDINE', '6');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('FR', 'FROSINONE', '7');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('LT', 'LATINA', '7');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('RI', 'RIETI', '7');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('RM', 'ROMA', '7');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('VT', 'VITERBO', '7');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('GE', 'GENOVA', '8');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('IM', 'IMPERIA', '8');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('SP', 'LA SPEZIA', '8');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('SV', 'SAVONA', '8');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('BG', 'BERGAMO', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('BS', 'BRESCIA', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CR', 'CREMONA', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('LC', 'LECCO', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('LO', 'LODI', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('MI', 'MILANO', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('MN', 'MANTOVA', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PV', 'PAVIA', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('SO', 'SONDRIO', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('VA', 'VARESE', '9');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('AN', 'ANCONA', '10');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('AP', 'ASCOLI PICENO', '10');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('MC', 'MACERATA', '10');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PU', 'PESARO E URBINO', '10');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CB', 'CAMPOBASSO', '11');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('IS', 'ISERNIA', '11');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('AL', 'ALESSANDRIA', '12');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('AT', 'ASTI', '12');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('BI', 'BIELLA', '12');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CN', 'CUNEO', '12');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('NO', 'NOVARA', '12');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('TO', 'TORINO', '12');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('VB', 'VERBANIA', '12');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('VC', 'VERCELLI', '12');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('BA', 'BARI', '13');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('BR', 'BRINDISI', '13');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('FG', 'FOGGIA', '13');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('LE', 'LECCE', '13');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('TA', 'TARANTO', '13');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CA', 'CAGLIARI', '14');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('NU', 'NUORO', '14');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('OR', 'ORISTANO', '14');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('SS', 'SASSARI', '14');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('AG', 'AGRIGENTO', '15');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CL', 'CALTANISSETTA', '15');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CT', 'CATANIA', '15');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('EN', 'ENNA', '15');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('ME', 'MESSINA', '15');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PA', 'PALERMO', '15');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('RG', 'RAGUSA', '15');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('SR', 'SIRACUSA', '15');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('TP', 'TRAPANI', '15');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('AR', 'AREZZO', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('FI', 'FIRENZE', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('GR', 'GROSSETO', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('LI', 'LIVORNO', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('LU', 'LUCCA', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('MS', 'MASSA-CARRARA', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PI', 'PISA', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PO', 'PRATO', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PT', 'PISTOIA', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('SI', 'SIENA', '16');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('BZ', 'BOLZANO', '17');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('TN', 'TRENTO', '17');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PG', 'PERUGIA', '18');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('TR', 'TERNI', '18');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('AO', 'AOSTA', '19');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('BL', 'BELLUNO', '20');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('PD', 'PADOVA', '20');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('RO', 'ROVIGO', '20');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('TV', 'TREVISO', '20');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('VE', 'VENEZIA', '20');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('VI', 'VICENZA', '20');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('VR', 'VERONA', '20');
INSERT INTO `province` (`sigla`, `nome`, `id_regione`) VALUES('CO', 'COMO', '9');
