SQL crezione tabella provincie italiane

province.sql

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generato il: 18 Apr, 2007 at 04:00 PM
-- Versione MySQL: 3.23.58
-- Versione PHP: 4.3.11
-- 
-- Database: `test`
-- 

-- --------------------------------------------------------

-- 
-- Struttura della tabella `province`
-- 

CREATE TABLE `province` (
  `id` int(4) NOT NULL auto_increment,
  `nome` varchar(20) NOT NULL default '',
  `idregione` int(4) NOT NULL default '0',
  `sigla` char(2) NOT NULL default '',
  PRIMARY KEY  (`idprovincia`)
) TYPE=MyISAM AUTO_INCREMENT=109 ;

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

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