-- 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 `stato`
--

DROP TABLE IF EXISTS `stato`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stato` (
  `IdStato` varchar(10) NOT NULL,
  `IdStatoEsteso` varchar(10) NOT NULL DEFAULT '',
  `DescStato` varchar(100) NOT NULL DEFAULT '',
  `CodiceCatasto` varchar(50) NOT NULL DEFAULT '',
  `CodiceIstat` varchar(3) NOT NULL,
  PRIMARY KEY (`IdStato`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stato`
--

LOCK TABLES `stato` WRITE;
/*!40000 ALTER TABLE `stato` DISABLE KEYS */;
INSERT INTO `stato` VALUES ('AD','AND','Andorra','Z101','202'),('AE','ARE','Emirati Arabi Uniti','Z215','322'),('AF','AFG','Afghanistan','Z200','301'),('AG','ATG','Antigua e Barbuda','Z532','503'),('AI','AIA','Anguilla','Z529','917'),('AL','ALB','Albania','Z100','201'),('AM','ARM','Armenia','Z252','358'),('AO','AGO','Angola','Z302','402'),('AR','ARG','Argentina','Z600','602'),('AT','AUT','Austria','Z102','203'),('AU','AUS','Australia','Z700','701'),('AW','ABW','Aruba','Z501','926'),('AZ','AZE','Azerbaigian','Z253','359'),('BA','BIH','Bosnia-Erzegovina','Z153','252'),('BB','BRB','Barbados','Z522','506'),('BD','BGD','Bangladesh','Z249','305'),('BE','BEL','Belgio','Z103','206'),('BF','BFA','Burkina Faso','Z354','409'),('BG','BGR','Bulgaria','Z104','209'),('BH','BHR','Bahrein','Z204','304'),('BI','BDI','Burundi','Z305','410'),('BJ','BEN','Benin','Z314','406'),('BL','BLM','Saint-Barthe\'lemy','n.d.','906'),('BM','BMU','Bermuda','Z400','908'),('BN','BRN','Brunei Darussalam','Z207','309'),('BO','BOL','Bolivia','Z601','604'),('BR','BRA','Brasile','Z602','605'),('BS','BHS','Bahamas','Z502','505'),('BT','BTN','Bhutan','Z205','306'),('BW','BWA','Botswana','Z358','408'),('BY','BLR','Bielorussia','Z139','256'),('BZ','BLZ','Belize','Z512','507'),('CA','CAN','Canada','Z401','509'),('CD','COD','Repubblica Democratica del Congo','Z312','463'),('CF','CAF','Repubblica Centrafricana','Z308','414'),('CG','COG','Congo','Z311','418'),('CH','CHE','Svizzera','Z133','241'),('CI','CIV','Costa d\'Avorio','Z313','404'),('CK','COK','Isole Cook (NZ)','Z703','909'),('CL','CHL','Cile','Z603','606'),('CM','CMR','Camerun','Z306','411'),('CN','CHN','Cina','Z210','314'),('CO','COL','Colombia','Z604','608'),('CR','CRI','Costa Rica','Z503','513'),('CU','CUB','Cuba','Z504','514'),('CV','CPV','Capo Verde','Z307','413'),('CW','CUW','Curaçao','n.d.','966'),('CY','CYP','Cipro','Z211','315'),('CZ','CZE','Repubblica ceca','Z156','257'),('DE','DEU','Germania','Z112','216'),('DJ','DJI','Gibuti','Z361','424'),('DK','DNK','Danimarca','Z107','212'),('DM','DMA','Dominica','Z526','515'),('DO','DOM','Repubblica Dominicana','Z505','516'),('DZ','DZA','Algeria','Z301','401'),('EC','ECU','Ecuador','Z605','609'),('EE','EST','Estonia','Z144','247'),('EG','EGY','Egitto','Z336','419'),('EH','ESH','Sahara occidentale','Z339','905'),('ER','ERI','Eritrea','Z368','466'),('ES','ESP','Spagna','Z131','239'),('ET','ETH','Etiopia','Z315','420'),('FI','FIN','Finlandia','Z109','214'),('FJ','FJI','Figi','Z704','703'),('FK','FLK','Isole Falkland (Malvine)','Z609','958'),('FM','FSM','Stati Federati di Micronesia','Z735','713'),('FO','FRO','Isole Faer','Z108','924'),('FR','FRA','Francia','Z110','215'),('GA','GAB','Gabon','Z316','421'),('GD','GRD','Grenada','Z524','519'),('GE','GEO','Georgia','Z254','360'),('GG','GGY','Guernsey','n.d.','940'),('GH','GHA','Ghana','Z318','423'),('GI','GIB','Gibilterra','Z113','910'),('GL','GRL','Groenlandia','Z402','934'),('GM','GMB','Gambia','Z317','422'),('GN','GIN','Guinea','Z319','425'),('GQ','GNQ','Guinea equatoriale','Z321','427'),('GR','GRC','Grecia','Z115','220'),('GT','GTM','Guatemala','Z509','523'),('GW','GNB','Guinea-Bissau','Z320','426'),('GY','GUY','Guyana','Z606','612'),('HN','HND','Honduras','Z511','525'),('HR','HRV','Croazia','Z149','250'),('HT','HTI','Haiti','Z510','524'),('HU','HUN','Ungheria','Z134','244'),('ID','IDN','Indonesia','Z223','331'),('IE','IRL','Irlanda','Z116','221'),('IL','ISR','Israele','Z226','334'),('IM','IMN','Isola di Man','Z122','959'),('IN','IND','India','Z222','330'),('IQ','IRQ','Iraq','Z225','333'),('IR','IRN','Iran','Z224','332'),('IS','ISL','Islanda','Z117','223'),('IT','ITA','Italia','n.d.','100'),('JE','JEY','Jersey','n.d.','925'),('JM','JAM','Giamaica','Z507','518'),('JO','JOR','Giordania','Z220','327'),('JP','JPN','Giappone','Z219','326'),('KE','KEN','Kenya','Z322','428'),('KG','KGZ','Kirghizistan','Z256','361'),('KH','KHM','Cambogia','Z208','310'),('KI','KIR','Kiribati','Z731','708'),('KM','COM','Comore','Z310','417'),('KN','KNA','Saint Kitts e Nevis','Z533','534'),('KP','PRK','Corea del Nord','Z214','319'),('KR','KOR','Corea del Sud','Z213','320'),('KW','KWT','Kuwait','Z227','335'),('KY','CYM','Isole Cayman','Z530','911'),('KZ','KAZ','Kazakhstan','Z255','356'),('LA','LAO','Laos','Z228','336'),('LB','LBN','Libano','Z229','337'),('LC','LCA','Santa Lucia','Z527','532'),('LI','LIE','Liechtenstein','Z119','225'),('LK','LKA','Sri Lanka','Z209','311'),('LR','LBR','Liberia','Z325','430'),('LS','LSO','Lesotho','Z359','429'),('LT','LTU','Lituania','Z146','249'),('LU','LUX','Lussemburgo','Z120','226'),('LV','LVA','Lettonia','Z145','248'),('LY','LBY','Libia','Z326','431'),('MA','MAR','Marocco','Z330','436'),('MC','MCO','Monaco','Z123','229'),('MD','MDA','Moldova','Z140','254'),('ME','MNE','Montenegro','Z159','270'),('MF','MAF','Saint-Martin (FR)','n.d.','904'),('MG','MDG','Madagascar','Z327','432'),('MH','MHL','Isole Marshall','Z711','712'),('MK','MKD','Macedonia del Nord','Z148','253'),('ML','MLI','Mali','Z329','435'),('MM','MMR','Myanmar/Birmania','Z206','307'),('MN','MNG','Mongolia','Z233','341'),('MR','MRT','Mauritania','Z331','437'),('MS','MSR','Montserrat','Z531','964'),('MT','MLT','Malta','Z121','227'),('MU','MUS','Maurizio','Z332','438'),('MV','MDV','Maldive','Z232','339'),('MW','MWI','Malawi','Z328','434'),('MX','MEX','Messico','Z514','527'),('MY','MYS','Malaysia','Z247','340'),('MZ','MOZ','Mozambico','Z333','440'),('n.d.','KOS','Kosovo','Z160','272'),('NA','NAM','Namibia','Z300','441'),('NC','NCL','Nuova Caledonia','Z716','902'),('NE','NER','Niger','Z334','442'),('NG','NGA','Nigeria','Z335','443'),('NI','NIC','Nicaragua','Z515','529'),('NL','NLD','Paesi Bassi','Z126','232'),('NO','NOR','Norvegia','Z125','231'),('NP','NPL','Nepal','Z234','342'),('NR','NRU','Nauru','Z713','715'),('NZ','NZL','Nuova Zelanda','Z719','719'),('OM','OMN','Oman','Z235','343'),('PA','PAN','Panama','Z516','530'),('PE','PER','Perù','Z611','615'),('PF','PYF','Polinesia francese','Z723','920'),('PG','PNG','Papua Nuova Guinea','Z730','721'),('PH','PHL','Filippine','Z216','323'),('PK','PAK','Pakistan','Z236','344'),('PL','POL','Polonia','Z127','233'),('PM','SPM','Saint Pierre e Miquelon','Z403','980'),('PN','PCN','Isole Pitcairn','Z722','972'),('PS','PSE','Palestina','Z161','324'),('PT','PRT','Portogallo','Z128','234'),('PW','PLW','Palau','Z734','720'),('PY','PRY','Paraguay','Z610','614'),('QA','QAT','Qatar','Z237','345'),('RO','ROU','Romania','Z129','235'),('RS','SRB','Serbia','Z158','271'),('RU','RUS','Federazione russa','Z154','245'),('RW','RWA','Ruanda','Z338','446'),('SA','SAU','Arabia Saudita','Z203','302'),('SB','SLB','Isole Salomone','Z724','725'),('SC','SYC','Seychelles','Z342','449'),('SD','SDN','Sudan','Z348','455'),('SE','SWE','Svezia','Z132','240'),('SG','SGP','Singapore','Z248','346'),('SH','SHN','Sant\'Elena','Z340','983'),('SI','SVN','Slovenia','Z150','251'),('SK','SVK','Slovacchia','Z155','255'),('SL','SLE','Sierra Leone','Z344','451'),('SM','SMR','San Marino','Z130','236'),('SN','SEN','Senegal','Z343','450'),('SO','SOM','Somalia','Z345','453'),('SR','SUR','Suriname','Z608','616'),('SS','SSD','Sud Sudan','Z907','467'),('ST','STP','Sao Tome\' e Principe','Z341','448'),('SV','SLV','El Salvador','Z506','517'),('SX','SXM','Sint Maarten (NL)','n.d.','928'),('SY','SYR','Siria','Z240','348'),('SZ','SWZ','Eswatini','Z349','456'),('TC','TCA','Isole Turks e Caicos','Z519','992'),('TD','TCD','Ciad','Z309','415'),('TF','ATF','Terre australi e antartiche francesi','n.d.','988'),('TG','TGO','Togo','Z351','458'),('TH','THA','Thailandia','Z241','349'),('TJ','TJK','Tagikistan','Z257','362'),('TL','TLS','Timor Leste','Z242','338'),('TM','TKM','Turkmenistan','Z258','364'),('TN','TUN','Tunisia','Z352','460'),('TO','TON','Tonga','Z728','730'),('TR','TUR','Turchia','Z243','351'),('TT','TTO','Trinidad e Tobago','Z612','617'),('TV','TUV','Tuvalu','Z732','731'),('TW','TWN','Taiwan','Z217','363'),('TZ','TZA','Tanzania','Z357','457'),('UA','UKR','Ucraina','Z138','243'),('UG','UGA','Uganda','Z353','461'),('UK','GBR','Regno Unito','Z114','219'),('US','USA','Stati Uniti d\'America','Z404','536'),('UY','URY','Uruguay','Z613','618'),('UZ','UZB','Uzbekistan','Z259','357'),('VA','VAT','Stato della Citta\' del Vaticano','Z106','246'),('VC','VCT','Saint Vincent e Grenadine','Z528','533'),('VE','VEN','Venezuela','Z614','619'),('VG','VGB','Isole Vergini britanniche','Z525','994'),('VN','VNM','Vietnam','Z251','353'),('VU','VUT','Vanuatu','Z733','732'),('WF','WLF','Wallis e Futuna','Z729','997'),('WS','WSM','Samoa','Z726','727'),('YE','YEM','Yemen','Z246','354'),('ZA','ZAF','Sudafrica','Z347','454'),('ZM','ZMB','Zambia','Z355','464'),('ZW','ZWE','Zimbabwe','Z337','465');
/*!40000 ALTER TABLE `stato` 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:08
