-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 31, 2012 at 11:04 AM
-- Server version: 5.1.58
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cineamadev4`
--

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

--
-- Dumping data for table `provinces`
--

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