SQL ITA Stati

stati.sql

CREATE TABLE IF NOT EXISTS `stati` (
  `id_stati` int(16) NOT NULL auto_increment,
  `sigla_stati` varchar(5) default NULL,
  `nome__stati` varchar(128) default NULL,
  PRIMARY KEY  (`id_stati`),
  KEY `PRIMARY_KEY` (`id_stati`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO `stati` (`id_stati`, `sigla_stati`, `nome__stati`) VALUES
	(1, 'AF', 'Afghanistan'),
	(2, 'AL', 'Albania'),
	(3, 'DZ', 'Algeria'),
	(4, 'AS', 'Samoa Americane'),
	(5, 'AD', 'Andorra'),
	(6, 'AO', 'Angola'),
	(7, 'AI', 'Anguilla'),
	(8, 'AQ', 'Antartide'),
	(9, 'AG', 'Antigua e Barbuda'),
	(10, 'AR', 'Argentina'),
	(11, 'AM', 'Armenia'),
	(12, 'AW', 'Aruba'),
	(13, 'AU', 'Australia'),
	(14, 'AT', 'Austria'),
	(15, 'AZ', 'Azerbaijan'),
	(16, 'BS', 'Bahamas'),
	(17, 'BH', 'Bahrein'),
	(18, 'BD', 'Bangladesh'),
	(19, 'BB', 'Barbados'),
	(20, 'BY', 'Bielorussia'),
	(21, 'BE', 'Belgio'),
	(22, 'BZ', 'Belize'),
	(23, 'BJ', 'Benin'),
	(24, 'BM', 'Bermuda'),
	(25, 'BT', 'Bhutan'),
	(26, 'BO', 'Bolivia'),
	(27, 'BA', 'Bosnia Erzegovina'),
	(28, 'BW', 'Botswana'),
	(29, 'BV', 'Isola Bouvet'),
	(30, 'BR', 'Brasile'),
	(31, 'IO', 'Oceano Indiano, territorio britannico'),
	(32, 'BN', 'Brunei Darussalam'),
	(33, 'BG', 'Bulgaria'),
	(34, 'BF', 'Burkina Faso'),
	(35, 'BI', 'Burundi'),
	(36, 'KH', 'Cambogia'),
	(37, 'CM', 'Camerun'),
	(38, 'CA', 'Canada'),
	(39, 'CV', 'Capo Verde'),
	(40, 'KY', 'Isole Cayman'),
	(41, 'CF', 'Repubblica Centrafricana'),
	(42, 'TD', 'Ciad'),
	(43, 'CL', 'Cile'),
	(44, 'CN', 'Cina'),
	(45, 'CX', 'Christmas Island'),
	(46, 'CC', 'Cocos (Keeling) Islands'),
	(47, 'CO', 'Colombia'),
	(48, 'KM', 'Comore'),
	(49, 'CG', 'Congo'),
	(50, 'CD', 'Congo,Rep. Democratica'),
	(51, 'CK', 'Isole di Cook'),
	(52, 'CR', 'Costa Rica'),
	(53, 'CI', 'Costa d\'Avorio'),
	(54, 'HR', 'Croazia'),
	(55, 'CU', 'Cuba'),
	(56, 'CY', 'Cipro'),
	(57, 'CZ', 'Repubblica Ceca'),
	(58, 'DK', 'Danimarca'),
	(59, 'DJ', 'Gibuti'),
	(60, 'DM', 'Dominica'),
	(61, 'DO', 'Repubblica Dominicana'),
	(62, 'TP', 'Timor Est'),
	(63, 'EC', 'Ecuador'),
	(64, 'EG', 'Egitto'),
	(65, 'SV', 'El Salvador'),
	(66, 'GQ', 'Guinea Equatoriale'),
	(67, 'ER', 'Eritrea'),
	(68, 'EE', 'Estonia'),
	(69, 'ET', 'Etiopia'),
	(70, 'FK', 'Falkland Islands (Malvinas)'),
	(71, 'FO', 'Isole Faroe'),
	(72, 'FJ', 'Figi'),
	(73, 'FI', 'Finlandia'),
	(74, 'FR', 'Francia'),
	(75, 'GF', 'Guiana Francese'),
	(76, 'PF', 'Polinesia Francese'),
	(77, 'TF', 'Territori Francesi del Sud'),
	(78, 'GA', 'Gabon'),
	(79, 'GM', 'Gambia'),
	(80, 'GE', 'Georgia'),
	(81, 'DE', 'Germania'),
	(82, 'GH', 'Ghana'),
	(83, 'GI', 'Gibilterra'),
	(84, 'GR', 'Grecia'),
	(85, 'GL', 'Groenlandia'),
	(86, 'GD', 'Grenada'),
	(87, 'GP', 'Guadalupa'),
	(88, 'GU', 'Guam'),
	(89, 'GT', 'Guatemala'),
	(90, 'GN', 'Guinea'),
	(91, 'GW', 'Guinea-Bissau'),
	(92, 'GY', 'Guyana'),
	(93, 'HT', 'Haiti'),
	(94, 'HM', 'Isole Heard e McDonald'),
	(95, 'VA', 'Holy See (Vatican City State)'),
	(96, 'HN', 'Honduras'),
	(97, 'HK', 'Hong Kong'),
	(98, 'HU', 'Ungheria'),
	(99, 'IS', 'Islanda'),
	(100, 'IN', 'India'),
	(101, 'ID', 'Indonesia'),
	(102, 'IR', 'Iran'),
	(103, 'IQ', 'Iraq'),
	(104, 'IE', 'EIRE'),
	(105, 'IL', 'Israele'),
	(106, 'IT', 'Italia'),
	(107, 'JM', 'Giamaica'),
	(108, 'JP', 'Giappone'),
	(109, 'JO', 'Giordania'),
	(110, 'KZ', 'Kazakistan'),
	(111, 'KE', 'Kenya'),
	(112, 'KI', 'Kiribati'),
	(113, 'KP', 'Corea del Nord'),
	(114, 'KR', 'Corea del Sud'),
	(115, 'KW', 'Kuwait'),
	(116, 'KG', 'Kirgizistan'),
	(117, 'LA', 'Laos'),
	(118, 'LV', 'Lettonia'),
	(119, 'LB', 'Libano'),
	(120, 'LS', 'Lesotho'),
	(121, 'LR', 'Liberia'),
	(122, 'LY', 'Libia'),
	(123, 'LI', 'Liechtenstein'),
	(124, 'LT', 'Lituania'),
	(125, 'LU', 'Lussemburgo'),
	(126, 'MO', 'Macao'),
	(127, 'MK', 'Macedonia'),
	(128, 'MG', 'Madagascar'),
	(129, 'MW', 'Malawi'),
	(130, 'MY', 'Malaysia'),
	(131, 'MV', 'Isole Maldive'),
	(132, 'ML', 'Mali'),
	(133, 'MT', 'Malta'),
	(134, 'MH', 'Isole Marshall'),
	(135, 'MQ', 'Martinica'),
	(136, 'MR', 'Mauritania'),
	(137, 'MU', 'Mauritius'),
	(138, 'YT', 'Mayotte'),
	(139, 'MX', 'Mexico'),
	(140, 'FM', 'Micronesia'),
	(141, 'MD', 'Moldova, Republic of'),
	(142, 'MC', 'Monaco'),
	(143, 'MN', 'Mongolia'),
	(144, 'MS', 'Montserrat'),
	(145, 'MA', 'Marocco'),
	(146, 'MZ', 'Mozambique'),
	(147, 'MM', 'Myanmar'),
	(148, 'NA', 'Namibia'),
	(149, 'NR', 'Nauru'),
	(150, 'NP', 'Nepal'),
	(151, 'NL', 'Paesi Bassi'),
	(152, 'AN', 'Antille Olandesi'),
	(153, 'NC', 'Nuova Caledonia'),
	(154, 'NZ', 'Nuova Zelanda'),
	(155, 'NI', 'Nicaragua'),
	(156, 'NE', 'Niger'),
	(157, 'NG', 'Nigeria'),
	(158, 'NU', 'Niue'),
	(159, 'NF', 'Isola di Norfolk'),
	(160, 'MP', 'Isole Marianne del Nord'),
	(161, 'NO', 'Norvegia'),
	(162, 'OM', 'Oman'),
	(163, 'PK', 'Pakistan'),
	(164, 'PW', 'Palau'),
	(165, 'PA', 'Panama'),
	(166, 'PG', 'Nuova Guinea'),
	(167, 'PY', 'Paraguay'),
	(168, 'PE', 'Peru'),
	(169, 'PH', 'Filippine'),
	(170, 'PN', 'Pitcairn'),
	(171, 'PL', 'Polonia'),
	(172, 'PT', 'Portogallo'),
	(173, 'PR', 'Porto Rico'),
	(174, 'QA', 'Qatar'),
	(175, 'RE', 'Rèunion'),
	(176, 'RO', 'Romania'),
	(177, 'RU', 'Russia'),
	(178, 'RW', 'Rwanda'),
	(179, 'SH', 'Sant\'Elena'),
	(180, 'KN', 'Saint Kitts e Nevis'),
	(181, 'LC', 'Santa Lucia'),
	(182, 'PM', 'Saint Pierre e Miquelon'),
	(183, 'VC', 'Saint Vincent e le Grenadine'),
	(184, 'WS', 'Samoa'),
	(185, 'SM', 'San Marino'),
	(186, 'ST', 'Sao Tome e Principe'),
	(187, 'SA', 'Arabia Saudita'),
	(188, 'SN', 'Senegal'),
	(189, 'SC', 'Seychelles'),
	(190, 'SL', 'Sierra Leone'),
	(191, 'SG', 'Singapore'),
	(192, 'SK', 'Slovacchia'),
	(193, 'SI', 'Slovenia'),
	(194, 'SB', 'Isole Solomone'),
	(195, 'SO', 'Somalia'),
	(196, 'ZA', 'Sud Africa'),
	(197, 'GS', 'Sud Georgia e Isole Sandwich del Sud'),
	(198, 'ES', 'Spagna'),
	(199, 'LK', 'Sri Lanka'),
	(200, 'SD', 'Sudan'),
	(201, 'SR', 'Suriname'),
	(202, 'SJ', 'Svalbard e Jan Mayen'),
	(203, 'SZ', 'Swaziland'),
	(204, 'SE', 'Svezia'),
	(205, 'CH', 'Svizzera'),
	(206, 'SY', 'Siria'),
	(207, 'TW', 'Taiwan'),
	(208, 'TJ', 'Tagikistan'),
	(209, 'TZ', 'Tanzania'),
	(210, 'TH', 'Thailand'),
	(211, 'TG', 'Togo'),
	(212, 'TK', 'Tokelau'),
	(213, 'TO', 'Tonga'),
	(214, 'TT', 'Trinidad e Tobago'),
	(215, 'TN', 'Tunisia'),
	(216, 'TR', 'Turchia'),
	(217, 'TM', 'Turkmenistan'),
	(218, 'TC', 'Isole Turks e Caicos'),
	(219, 'TV', 'Tuvalu'),
	(220, 'UG', 'Uganda'),
	(221, 'UA', 'Ucraina'),
	(222, 'AE', 'Emirati Arabi Uniti'),
	(223, 'GB', 'Gran Bretagna'),
	(224, 'US', 'USA'),
	(225, 'UM', 'Isole Minor Outlying, USA'),
	(226, 'UY', 'Isole Vergini, USA'),
	(227, 'UZ', 'Uruguay'),
	(228, 'VU', 'Uzbekistan'),
	(229, 'VE', 'Vanuatu'),
	(230, 'VN', 'Venezuela'),
	(231, 'VG', 'Vietnam'),
	(232, 'VI', 'Isole Vergini, GB'),
	(233, 'WF', 'Wallis e Futuna'),
	(234, 'EH', 'Sahara Occidentale'),
	(235, 'YE', 'Yemen'),
	(236, 'YU', 'Serbia e Montenegro'),
	(237, 'ZM', 'Zambia'),
	(238, 'ZW', 'Zimbabwe'),
	(239, 'PS', 'Territori Palestinesi');