-- MySQL dump 10.13  Distrib 8.0.36, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: migliozzi
-- ------------------------------------------------------
-- Server version	8.0.37

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `provincia`
--

DROP TABLE IF EXISTS `provincia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provincia` (
  `IdProvincia` varchar(20) NOT NULL,
  `IdRegione` varchar(20) NOT NULL,
  `DescProvincia` varchar(100) NOT NULL DEFAULT '',
  `SiglaProvincia` varchar(20) NOT NULL DEFAULT '',
  `CodiceCatasto` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`IdProvincia`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `provincia`
--

LOCK TABLES `provincia` WRITE;
/*!40000 ALTER TABLE `provincia` DISABLE KEYS */;
INSERT INTO `provincia` VALUES ('IT_AG','IT_SIC','Agrigento','AG','A089'),('IT_AL','IT_PIE','Alessandria','AL','A182'),('IT_AN','IT_MAR','Ancona','AN','A271'),('IT_AO','IT_VDA','Aosta','AO','A326'),('IT_AP','IT_MAR','Ascoli Piceno','AP','A462'),('IT_AQ','IT_ABR','L\'Aquila','AQ','A345'),('IT_AR','IT_TOS','Arezzo','AR','A390'),('IT_AT','IT_PIE','Asti','AT','A479'),('IT_AV','IT_CAM','Avellino','AV','A509'),('IT_BA','IT_PUG','BARI','BA','A662'),('IT_BG','IT_LOM','Bergamo','BG','A794'),('IT_BI','IT_PIE','Biella','BI','A859'),('IT_BL','IT_VEN','Belluno','BL','A757'),('IT_BN','IT_CAM','Benevento','BN','A783'),('IT_BO','IT_EMR','BOLOGNA','BO','A944'),('IT_BR','IT_PUG','Brindisi','BR','B180'),('IT_BS','IT_LOM','Brescia','BS','B157'),('IT_BT','IT_PUG','Barletta-Andria-Trani','BT','A285'),('IT_BZ','IT_TAA','Bolzano','BZ','A952'),('IT_CA','IT_SAR','CAGLIARI','CA','B354'),('IT_CB','IT_MOL','Campobasso','CB','B519'),('IT_CE','IT_CAM','Caserta','CE','B963'),('IT_CH','IT_ABR','Chieti','CH','C632'),('IT_CL','IT_SIC','Caltanissetta','CL','B429'),('IT_CN','IT_PIE','Cuneo','CN','D205'),('IT_CO','IT_LOM','Como','CO','C933'),('IT_CR','IT_LOM','Cremona','CR','D150'),('IT_CS','IT_CAL','Cosenza','CS','D086'),('IT_CT','IT_SIC','CATANIA','CT','C351'),('IT_CZ','IT_CAL','Catanzaro','CZ','C352'),('IT_EN','IT_SIC','Enna','EN','C342'),('IT_FC','IT_EMR','Forli\'-Cesena','FC','D704'),('IT_FE','IT_EMR','Ferrara','FE','D548'),('IT_FG','IT_PUG','Foggia','FG','D643'),('IT_FI','IT_TOS','FIRENZE','FI','D612'),('IT_FM','IT_MAR','Fermo','FM','D542'),('IT_FR','IT_LAZ','Frosinone','FR','D810'),('IT_GE','IT_LIG','GENOVA','GE','D969'),('IT_GO','IT_FVG','Gorizia','GO','E098'),('IT_GR','IT_TOS','Grosseto','GR','E202'),('IT_IM','IT_LIG','Imperia','IM','E290'),('IT_IS','IT_MOL','Isernia','IS','E335'),('IT_KR','IT_CAL','Crotone','KR','D122'),('IT_LC','IT_LOM','Lecco','LC','E507'),('IT_LE','IT_PUG','Lecce','LE','E506'),('IT_LI','IT_TOS','Livorno','LI','E625'),('IT_LO','IT_LOM','Lodi','LO','E648'),('IT_LT','IT_LAZ','Latina','LT','E472'),('IT_LU','IT_TOS','Lucca','LU','E715'),('IT_MB','IT_LOM','Monza e Brianza','MB','F704'),('IT_MC','IT_MAR','Macerata','MC','E783'),('IT_ME','IT_SIC','MESSINA','ME','F158'),('IT_MI','IT_LOM','MILANO','MI','F205'),('IT_MN','IT_LOM','Mantova','MN','E897'),('IT_MO','IT_EMR','Modena','MO','F257'),('IT_MS','IT_TOS','Massa-Carrara','MS','F023'),('IT_MT','IT_BAS','Matera','MT','F052'),('IT_NA','IT_CAM','NAPOLI','NA','F839'),('IT_NO','IT_PIE','Novara','NO','F952'),('IT_NU','IT_SAR','Nuoro','NU','F979'),('IT_OR','IT_SAR','Oristano','OR','G113'),('IT_PA','IT_SIC','PALERMO','PA','G273'),('IT_PC','IT_EMR','Piacenza','PC','G535'),('IT_PD','IT_VEN','Padova','PD','G224'),('IT_PE','IT_ABR','Pescara','PE','G482'),('IT_PG','IT_UMB','Perugia','PG','G478'),('IT_PI','IT_TOS','Pisa','PI','G702'),('IT_PN','IT_FVG','Pordenone','PN','G888'),('IT_PO','IT_TOS','Prato','PO','G999'),('IT_PR','IT_EMR','Parma','PR','G337'),('IT_PT','IT_TOS','Pistoia','PT','G713'),('IT_PU','IT_MAR','Pesaro e Urbino','PU','G479'),('IT_PV','IT_LOM','Pavia','PV','G388'),('IT_PZ','IT_BAS','Potenza','PZ','G942'),('IT_RA','IT_EMR','Ravenna','RA','H199'),('IT_RC','IT_CAL','REGGIO CALABRIA','RC','H224'),('IT_RE','IT_EMR','Reggio Emilia','RE','H223'),('IT_RG','IT_SIC','Ragusa','RG','H163'),('IT_RI','IT_LAZ','Rieti','RI','H282'),('IT_RM','IT_LAZ','ROMA','RM','H501'),('IT_RN','IT_EMR','Rimini','RN','H294'),('IT_RO','IT_VEN','Rovigo','RO','H620'),('IT_SA','IT_CAM','Salerno','SA','H703'),('IT_SI','IT_TOS','Siena','SI','I726'),('IT_SO','IT_LOM','Sondrio','SO','I829'),('IT_SP','IT_LIG','La Spezia','SP','E463'),('IT_SR','IT_SIC','Siracusa','SR','I754'),('IT_SS','IT_SAR','Sassari','SS','I452'),('IT_SU','IT_SAR','Sardegna','SU','B745'),('IT_SV','IT_LIG','Savona','SV','I480'),('IT_TA','IT_PUG','Taranto','TA','L049'),('IT_TE','IT_ABR','Teramo','TE','L103'),('IT_TN','IT_TAA','Trento','TN','L378'),('IT_TO','IT_PIE','TORINO','TO','L219'),('IT_TP','IT_SIC','Trapani','TP','L331'),('IT_TR','IT_UMB','Terni','TR','L117'),('IT_TS','IT_FVG','Trieste','TS','L424'),('IT_TV','IT_VEN','Treviso','TV','L407'),('IT_UD','IT_FVG','Udine','UD','L483'),('IT_VA','IT_LOM','Varese','VA','L682'),('IT_VB','IT_PIE','Verbano-Cusio-Ossola','VB','L746'),('IT_VC','IT_PIE','Vercelli','VC','L750'),('IT_VE','IT_VEN','VENEZIA','VE','L736'),('IT_VI','IT_VEN','Vicenza','VI','L840'),('IT_VR','IT_VEN','Verona','VR','L781'),('IT_VT','IT_LAZ','Viterbo','VT','M082'),('IT_VV','IT_CAL','Vibo Valentia','VV','F537');
/*!40000 ALTER TABLE `provincia` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-04-29 13:01:04
