I would like to update french regions/departments in TABLE_ZONE.
What is in the file is some old list which is bad/incomplete.
The pb is that I have a number of entries > the old list, so it decals all entries after.
These can drive to incompatibilities with existing DBs (customers address,...).
Below, an update for TABLE_COUNTRY, with latest ISO 3166-1(IDs are compatible with old ones):
Code: Select all
# --------------------------------------------------------
# ISO 3166-1: official codes of 246 countries, territories, or areas of geographical interest.
#
INSERT INTO `country` VALUES (240, 'Aaland Islands', 0, 'AX', 'ALA', ''); ### New 2004/02/13
INSERT INTO `country` VALUES ( 1, 'Afghanistan', 0, 'AF', 'AFG', '');
INSERT INTO `country` VALUES ( 2, 'Albania', 0, 'AL', 'ALB', '');
INSERT INTO `country` VALUES ( 3, 'Algeria', 0, 'DZ', 'DZA', '');
INSERT INTO `country` VALUES ( 4, 'American Samoa', 0, 'AS', 'ASM', '');
INSERT INTO `country` VALUES ( 5, 'Andorra', 0, 'AD', 'AND', '');
INSERT INTO `country` VALUES ( 6, 'Angola', 0, 'AO', 'AGO', '');
INSERT INTO `country` VALUES ( 7, 'Anguilla', 0, 'AI', 'AIA', '');
INSERT INTO `country` VALUES ( 8, 'Antarctica', 0, 'AQ', 'ATA', '');
INSERT INTO `country` VALUES ( 9, 'Antigua and Barbuda', 0, 'AG', 'ATG', '');
INSERT INTO `country` VALUES ( 10, 'Argentina', 0, 'AR', 'ARG', '');
INSERT INTO `country` VALUES ( 11, 'Armenia', 0, 'AM', 'ARM', '');
INSERT INTO `country` VALUES ( 12, 'Aruba', 0, 'AW', 'ABW', '');
INSERT INTO `country` VALUES ( 13, 'Australia', 0, 'AU', 'AUS', '');
INSERT INTO `country` VALUES ( 14, 'Austria', 0, 'AT', 'AUT', '');
INSERT INTO `country` VALUES ( 15, 'Azerbaijan', 0, 'AZ', 'AZE', '');
INSERT INTO `country` VALUES ( 16, 'Bahamas', 0, 'BS', 'BHS', '');
INSERT INTO `country` VALUES ( 17, 'Bahrain', 0, 'BH', 'BHR', '');
INSERT INTO `country` VALUES ( 18, 'Bangladesh', 0, 'BD', 'BGD', '');
INSERT INTO `country` VALUES ( 19, 'Barbados', 0, 'BB', 'BRB', '');
INSERT INTO `country` VALUES ( 20, 'Belarus', 0, 'BY', 'BLR', '');
INSERT INTO `country` VALUES ( 21, 'Belgium', 0, 'BE', 'BEL', '');
INSERT INTO `country` VALUES ( 22, 'Belize', 0, 'BZ', 'BLZ', '');
INSERT INTO `country` VALUES ( 23, 'Benin', 0, 'BJ', 'BEN', '');
INSERT INTO `country` VALUES ( 24, 'Bermuda', 0, 'BM', 'BMU', '');
INSERT INTO `country` VALUES ( 25, 'Bhutan', 0, 'BT', 'BTN', '');
INSERT INTO `country` VALUES ( 26, 'Bolivia', 0, 'BO', 'BOL', '');
INSERT INTO `country` VALUES ( 27, 'Bosnia and Herzegowina', 0, 'BA', 'BIH', '');
INSERT INTO `country` VALUES ( 28, 'Botswana', 0, 'BW', 'BWA', '');
INSERT INTO `country` VALUES ( 29, 'Bouvet Island', 0, 'BV', 'BVT', '');
INSERT INTO `country` VALUES ( 30, 'Brazil', 0, 'BR', 'BRA', '');
INSERT INTO `country` VALUES ( 31, 'British Indian Ocean Territory', 0, 'IO', 'IOT', '');
INSERT INTO `country` VALUES ( 32, 'Brunei Darussalam', 0, 'BN', 'BRN', '');
INSERT INTO `country` VALUES ( 33, 'Bulgaria', 0, 'BG', 'BGR', '');
INSERT INTO `country` VALUES ( 34, 'Burkina Faso', 0, 'BF', 'BFA', '');
INSERT INTO `country` VALUES ( 35, 'Burundi', 0, 'BI', 'BDI', '');
INSERT INTO `country` VALUES ( 36, 'Cambodia', 0, 'KH', 'KHM', '');
INSERT INTO `country` VALUES ( 37, 'Cameroon', 0, 'CM', 'CMR', '');
INSERT INTO `country` VALUES ( 38, 'Canada', 0, 'CA', 'CAN', '');
INSERT INTO `country` VALUES ( 39, 'Cape Verde', 0, 'CV', 'CPV', '');
INSERT INTO `country` VALUES ( 40, 'Cayman Islands', 0, 'KY', 'CYM', '');
INSERT INTO `country` VALUES ( 41, 'Central African Republic', 0, 'CF', 'CAF', '');
INSERT INTO `country` VALUES ( 42, 'Chad', 0, 'TD', 'TCD', '');
INSERT INTO `country` VALUES ( 43, 'Chile', 0, 'CL', 'CHL', '');
INSERT INTO `country` VALUES ( 44, 'China', 0, 'CN', 'CHN', '');
INSERT INTO `country` VALUES ( 45, 'Christmas Island', 0, 'CX', 'CXR', '');
INSERT INTO `country` VALUES ( 46, 'Cocos (Keeling) Islands', 0, 'CC', 'CCK', '');
INSERT INTO `country` VALUES ( 47, 'Colombia', 0, 'CO', 'COL', '');
INSERT INTO `country` VALUES ( 48, 'Comoros', 0, 'KM', 'COM', '');
INSERT INTO `country` VALUES (237, 'Congo, Democratic Republic of (was Zaire)', 0, 'CD', 'COD', ''); ### New name
INSERT INTO `country` VALUES ( 49, 'Congo, Republic of', 0, 'CG', 'COG', '');
INSERT INTO `country` VALUES ( 50, 'Cook Islands', 0, 'CK', 'COK', '');
INSERT INTO `country` VALUES ( 51, 'Costa Rica', 0, 'CR', 'CRI', '');
INSERT INTO `country` VALUES ( 52, 'Cote d''Ivoire', 0, 'CI', 'CIV', '');
INSERT INTO `country` VALUES ( 53, 'Croatia (local name: Hrvatska)', 0, 'HR', 'HRV', '');
INSERT INTO `country` VALUES ( 54, 'Cuba', 0, 'CU', 'CUB', '');
INSERT INTO `country` VALUES ( 55, 'Cyprus', 0, 'CY', 'CYP', '');
INSERT INTO `country` VALUES ( 56, 'Czech Republic', 0, 'CZ', 'CZE', '');
INSERT INTO `country` VALUES ( 57, 'Denmark', 0, 'DK', 'DNK', '');
INSERT INTO `country` VALUES ( 58, 'Djibouti', 0, 'DJ', 'DJI', '');
INSERT INTO `country` VALUES ( 59, 'Dominica', 0, 'DM', 'DMA', '');
INSERT INTO `country` VALUES ( 60, 'Dominican Republic', 0, 'DO', 'DOM', '');
INSERT INTO `country` VALUES ( 62, 'Ecuador', 0, 'EC', 'ECU', '');
INSERT INTO `country` VALUES ( 63, 'Egypt', 0, 'EG', 'EGY', '');
INSERT INTO `country` VALUES ( 64, 'El salvador', 0, 'SV', 'SLV', '');
INSERT INTO `country` VALUES ( 65, 'Equatorial Guinea', 0, 'GQ', 'GNQ', '');
INSERT INTO `country` VALUES ( 66, 'Eritrea', 0, 'ER', 'ERI', '');
INSERT INTO `country` VALUES ( 67, 'Estonia', 0, 'EE', 'EST', '');
INSERT INTO `country` VALUES ( 68, 'Ethiopia', 0, 'ET', 'ETH', '');
INSERT INTO `country` VALUES ( 69, 'Falkland Islands (Malvinas)', 0, 'FK', 'FLK', '');
INSERT INTO `country` VALUES ( 70, 'Faroe Islands', 0, 'FO', 'FRO', '');
INSERT INTO `country` VALUES ( 71, 'Fiji', 0, 'FJ', 'FJI', '');
INSERT INTO `country` VALUES ( 72, 'Finland', 0, 'FI', 'FIN', '');
INSERT INTO `country` VALUES ( 73, 'France', 0, 'FR', 'FRA', '');
INSERT INTO `country` VALUES ( 74, 'France, Metropolitan', 0, 'FX', 'FXX', '');
INSERT INTO `country` VALUES ( 75, 'French Guiana', 0, 'GF', 'GUF', '');
INSERT INTO `country` VALUES ( 76, 'French Polynesia', 0, 'PF', 'PYF', '');
INSERT INTO `country` VALUES ( 77, 'French Southern Territories', 0, 'TF', 'ATF', '');
INSERT INTO `country` VALUES ( 78, 'Gabon', 0, 'GA', 'GAB', '');
INSERT INTO `country` VALUES ( 79, 'Gambia', 0, 'GM', 'GMB', '');
INSERT INTO `country` VALUES ( 80, 'Georgia', 0, 'GE', 'GEO', '');
INSERT INTO `country` VALUES ( 81, 'Germany', 0, 'DE', 'DEU', '');
INSERT INTO `country` VALUES ( 82, 'Ghana', 0, 'GH', 'GHA', '');
INSERT INTO `country` VALUES ( 83, 'Gibraltar', 0, 'GI', 'GIB', '');
INSERT INTO `country` VALUES ( 84, 'Greece', 0, 'GR', 'GRC', '');
INSERT INTO `country` VALUES ( 85, 'Greenland', 0, 'GL', 'GRL', '');
INSERT INTO `country` VALUES ( 86, 'Grenada', 0, 'GD', 'GRD', '');
INSERT INTO `country` VALUES ( 87, 'Guadeloupe', 0, 'GP', 'GLP', '');
INSERT INTO `country` VALUES ( 88, 'Guam', 0, 'GU', 'GUM', '');
INSERT INTO `country` VALUES ( 89, 'Guatemala', 0, 'GT', 'GTM', '');
INSERT INTO `country` VALUES (241, 'Guernsey', 0, 'GG', 'GGY', ''); ### New 2006/03/29
INSERT INTO `country` VALUES ( 90, 'Guinea', 0, 'GN', 'GIN', '');
INSERT INTO `country` VALUES ( 91, 'Guinea-Bissau', 0, 'GW', 'GNB', '');
INSERT INTO `country` VALUES ( 92, 'Guyana', 0, 'GY', 'GUY', '');
INSERT INTO `country` VALUES ( 93, 'Haiti', 0, 'HT', 'HTI', '');
INSERT INTO `country` VALUES ( 94, 'Heard Island and Mc Donald Islands', 0, 'HM', 'HMD', '');
INSERT INTO `country` VALUES ( 95, 'Honduras', 0, 'HN', 'HND', '');
INSERT INTO `country` VALUES ( 96, 'Hong kong', 0, 'HK', 'HKG', '');
INSERT INTO `country` VALUES ( 97, 'Hungary', 0, 'HU', 'HUN', '');
INSERT INTO `country` VALUES ( 98, 'Iceland', 0, 'IS', 'ISL', '');
INSERT INTO `country` VALUES ( 99, 'India', 0, 'IN', 'IND', '');
INSERT INTO `country` VALUES (100, 'Indonesia', 0, 'ID', 'IDN', '');
INSERT INTO `country` VALUES (101, 'Iran (Islamic Republic of)', 0, 'IR', 'IRN', '');
INSERT INTO `country` VALUES (102, 'Iraq', 0, 'IQ', 'IRQ', '');
INSERT INTO `country` VALUES (103, 'Ireland', 0, 'IE', 'IRL', '');
INSERT INTO `country` VALUES (242, 'Isle of Man', 0, 'IM', 'IMN', ''); ### New 2006/03/29
INSERT INTO `country` VALUES (104, 'Israel', 0, 'IL', 'ISR', '');
INSERT INTO `country` VALUES (105, 'Italy', 0, 'IT', 'ITA', '');
INSERT INTO `country` VALUES (106, 'Jamaica', 0, 'JM', 'JAM', '');
INSERT INTO `country` VALUES (107, 'Japan', 0, 'JP', 'JPN', '');
INSERT INTO `country` VALUES (243, 'Jersey', 0, 'JE', 'JEY', ''); ### New 2006/03/29
INSERT INTO `country` VALUES (108, 'Jordan', 0, 'JO', 'JOR', '');
INSERT INTO `country` VALUES (109, 'Kazakhstan', 0, 'KZ', 'KAZ', '');
INSERT INTO `country` VALUES (110, 'Kenya', 0, 'KE', 'KEN', '');
INSERT INTO `country` VALUES (111, 'Kiribati', 0, 'KI', 'KIR', '');
INSERT INTO `country` VALUES (112, 'Korea, Democratic People''s Republic of', 0, 'KP', 'PRK', '');
INSERT INTO `country` VALUES (113, 'Korea, Republic of', 0, 'KR', 'KOR', '');
INSERT INTO `country` VALUES (114, 'Kuwait', 0, 'KW', 'KWT', '');
INSERT INTO `country` VALUES (115, 'Kyrgyzstan', 0, 'KG', 'KGZ', '');
INSERT INTO `country` VALUES (116, 'Lao People''s Democratic Republic', 0, 'LA', 'LAO', '');
INSERT INTO `country` VALUES (117, 'Latvia', 0, 'LV', 'LVA', '');
INSERT INTO `country` VALUES (118, 'Lebanon', 0, 'LB', 'LBN', '');
INSERT INTO `country` VALUES (119, 'Lesotho', 0, 'LS', 'LSO', '');
INSERT INTO `country` VALUES (120, 'Liberia', 0, 'LR', 'LBR', '');
INSERT INTO `country` VALUES (121, 'Libyan Arab Jamahiriya', 0, 'LY', 'LBY', '');
INSERT INTO `country` VALUES (122, 'Liechtenstein', 0, 'LI', 'LIE', '');
INSERT INTO `country` VALUES (123, 'Lithuania', 0, 'LT', 'LTU', '');
INSERT INTO `country` VALUES (124, 'Luxembourg', 0, 'LU', 'LUX', '');
INSERT INTO `country` VALUES (125, 'Macau', 0, 'MO', 'MAC', '');
INSERT INTO `country` VALUES (126, 'Macedonia, The Former Yugoslav Republic of', 0, 'MK', 'MKD', '');
INSERT INTO `country` VALUES (127, 'Madagascar', 0, 'MG', 'MDG', '');
INSERT INTO `country` VALUES (128, 'Malawi', 0, 'MW', 'MWI', '');
INSERT INTO `country` VALUES (129, 'Malaysia', 0, 'MY', 'MYS', '');
INSERT INTO `country` VALUES (130, 'Maldives', 0, 'MV', 'MDV', '');
INSERT INTO `country` VALUES (131, 'Mali', 0, 'ML', 'MLI', '');
INSERT INTO `country` VALUES (132, 'Malta', 0, 'MT', 'MLT', '');
INSERT INTO `country` VALUES (133, 'Marshall Islands', 0, 'MH', 'MHL', '');
INSERT INTO `country` VALUES (134, 'Martinique', 0, 'MQ', 'MTQ', '');
INSERT INTO `country` VALUES (135, 'Mauritania', 0, 'MR', 'MRT', '');
INSERT INTO `country` VALUES (136, 'Mauritius', 0, 'MU', 'MUS', '');
INSERT INTO `country` VALUES (137, 'Mayotte', 0, 'YT', 'MYT', '');
INSERT INTO `country` VALUES (138, 'Mexico', 0, 'MX', 'MEX', '');
INSERT INTO `country` VALUES (139, 'Micronesia, Federated States of', 0, 'FM', 'FSM', '');
INSERT INTO `country` VALUES (140, 'Moldova, Republic of', 0, 'MD', 'MDA', '');
INSERT INTO `country` VALUES (141, 'Monaco', 0, 'MC', 'MCO', '');
INSERT INTO `country` VALUES (142, 'Mongolia', 0, 'MN', 'MNG', '');
INSERT INTO `country` VALUES (244, 'Montenegro', 0, 'ME', 'MNE', ''); ### New 2006/09/26
INSERT INTO `country` VALUES (143, 'Montserrat', 0, 'MS', 'MSR', '');
INSERT INTO `country` VALUES (144, 'Morocco', 0, 'MA', 'MAR', '');
INSERT INTO `country` VALUES (145, 'Mozambique', 0, 'MZ', 'MOZ', '');
INSERT INTO `country` VALUES (146, 'Myanmar', 0, 'MM', 'MMR', '');
INSERT INTO `country` VALUES (147, 'Namibia', 0, 'NA', 'NAM', '');
INSERT INTO `country` VALUES (148, 'Nauru', 0, 'NR', 'NRU', '');
INSERT INTO `country` VALUES (149, 'Nepal', 0, 'NP', 'NPL', '');
INSERT INTO `country` VALUES (150, 'Netherlands', 0, 'NL', 'NLD', '');
INSERT INTO `country` VALUES (151, 'Netherlands Antilles', 0, 'AN', 'ANT', '');
INSERT INTO `country` VALUES (152, 'New Caledonia', 0, 'NC', 'NCL', '');
INSERT INTO `country` VALUES (153, 'New Zealand', 0, 'NZ', 'NZL', '');
INSERT INTO `country` VALUES (154, 'Nicaragua', 0, 'NI', 'NIC', '');
INSERT INTO `country` VALUES (155, 'Niger', 0, 'NE', 'NER', '');
INSERT INTO `country` VALUES (156, 'Nigeria', 0, 'NG', 'NGA', '');
INSERT INTO `country` VALUES (157, 'Niue', 0, 'NU', 'NIU', '');
INSERT INTO `country` VALUES (158, 'Norfolk Island', 0, 'NF', 'NFK', '');
INSERT INTO `country` VALUES (159, 'Northern Mariana Islands', 0, 'MP', 'MNP', '');
INSERT INTO `country` VALUES (160, 'Norway', 0, 'NO', 'NOR', '');
INSERT INTO `country` VALUES (161, 'Oman', 0, 'OM', 'OMN', '');
INSERT INTO `country` VALUES (162, 'Pakistan', 0, 'PK', 'PAK', '');
INSERT INTO `country` VALUES (163, 'Palau', 0, 'PW', 'PLW', '');
INSERT INTO `country` VALUES (245, 'Palestinian Territory, occupied', 0, 'PS', 'PSE', ''); ### New 1999/10/01
INSERT INTO `country` VALUES (164, 'Panama', 0, 'PA', 'PAN', '');
INSERT INTO `country` VALUES (165, 'Papua New Guinea', 0, 'PG', 'PNG', '');
INSERT INTO `country` VALUES (166, 'Paraguay', 0, 'PY', 'PRY', '');
INSERT INTO `country` VALUES (167, 'Peru', 0, 'PE', 'PER', '');
INSERT INTO `country` VALUES (168, 'Philippines', 0, 'PH', 'PHL', '');
INSERT INTO `country` VALUES (169, 'Pitcairn', 0, 'PN', 'PCN', '');
INSERT INTO `country` VALUES (170, 'Poland', 0, 'PL', 'POL', '');
INSERT INTO `country` VALUES (171, 'Portugal', 0, 'PT', 'PRT', '');
INSERT INTO `country` VALUES (172, 'Puerto Rico', 0, 'PR', 'PRI', '');
INSERT INTO `country` VALUES (173, 'Qatar', 0, 'QA', 'QAT', '');
INSERT INTO `country` VALUES (174, 'Reunion', 0, 'RE', 'REU', '');
INSERT INTO `country` VALUES (175, 'Romania', 0, 'RO', 'ROU', '');
INSERT INTO `country` VALUES (176, 'Russian Federation', 0, 'RU', 'RUS', '');
INSERT INTO `country` VALUES (177, 'Rwanda', 0, 'RW', 'RWA', '');
INSERT INTO `country` VALUES (178, 'Saint Kitts and Nevis', 0, 'KN', 'KNA', '');
INSERT INTO `country` VALUES (179, 'Saint Lucia', 0, 'LC', 'LCA', '');
INSERT INTO `country` VALUES (180, 'Saint Vincent and The Grenadines', 0, 'VC', 'VCT', '');
INSERT INTO `country` VALUES (181, 'Samoa', 0, 'WS', 'WSM', '');
INSERT INTO `country` VALUES (182, 'San marino', 0, 'SM', 'SMR', '');
INSERT INTO `country` VALUES (183, 'Sao Tome and Principe', 0, 'ST', 'STP', '');
INSERT INTO `country` VALUES (184, 'Saudi Arabia', 0, 'SA', 'SAU', '');
INSERT INTO `country` VALUES (185, 'Senegal', 0, 'SN', 'SEN', '');
INSERT INTO `country` VALUES (246, 'Serbia', 0, 'RS', 'SRB', ''); ### New 2006/09/26
INSERT INTO `country` VALUES (186, 'Seychelles', 0, 'SC', 'SYC', '');
INSERT INTO `country` VALUES (187, 'Sierra Leone', 0, 'SL', 'SLE', '');
INSERT INTO `country` VALUES (188, 'Singapore', 0, 'SG', 'SGP', '');
INSERT INTO `country` VALUES (189, 'Slovakia (Slovak Republic)', 0, 'SK', 'SVK', '');
INSERT INTO `country` VALUES (190, 'Slovenia', 0, 'SI', 'SVN', '');
INSERT INTO `country` VALUES (191, 'Solomon Islands', 0, 'SB', 'SLB', '');
INSERT INTO `country` VALUES (192, 'Somalia', 0, 'SO', 'SOM', '');
INSERT INTO `country` VALUES (193, 'South Africa', 0, 'ZA', 'ZAF', '');
INSERT INTO `country` VALUES (194, 'South Georgia and The South Sandwich Islands', 0, 'GS', 'SGS', '');
INSERT INTO `country` VALUES (195, 'Spain', 0, 'ES', 'ESP', '');
INSERT INTO `country` VALUES (196, 'Sri Lanka', 0, 'LK', 'LKA', '');
INSERT INTO `country` VALUES (247, 'St. Barthelemy', 0, 'BL', 'BLM', ''); ### New 2007/09/21
INSERT INTO `country` VALUES (197, 'St. Helena, Ascension and Tristan da Cunha', 0, 'SH', 'SHN', '');
INSERT INTO `country` VALUES (248, 'St. Martin (french part)', 0, 'MF', 'MAF', ''); ### New 2007/09/21
INSERT INTO `country` VALUES (198, 'St. Pierre and Miquelon', 0, 'PM', 'SPM', '');
INSERT INTO `country` VALUES (199, 'Sudan', 0, 'SD', 'SDN', '');
INSERT INTO `country` VALUES (200, 'Suriname', 0, 'SR', 'SUR', '');
INSERT INTO `country` VALUES (201, 'Svalbard and Jan Mayen Islands', 0, 'SJ', 'SJM', '');
INSERT INTO `country` VALUES (202, 'Swaziland', 0, 'SZ', 'SWZ', '');
INSERT INTO `country` VALUES (203, 'Sweden', 0, 'SE', 'SWE', '');
INSERT INTO `country` VALUES (204, 'Switzerland', 0, 'CH', 'CHE', '');
INSERT INTO `country` VALUES (205, 'Syrian Arab Republic', 0, 'SY', 'SYR', '');
INSERT INTO `country` VALUES (206, 'Taiwan', 0, 'TW', 'TWN', '');
INSERT INTO `country` VALUES (207, 'Tajikistan', 0, 'TJ', 'TJK', '');
INSERT INTO `country` VALUES (208, 'Tanzania, United Republic of', 0, 'TZ', 'TZA', '');
INSERT INTO `country` VALUES (209, 'Thailand', 0, 'TH', 'THA', '');
INSERT INTO `country` VALUES (249, 'Timor-Leste', 0, 'TL', 'TLS', ''); ### New 2002/11/15
INSERT INTO `country` VALUES (210, 'Togo', 0, 'TG', 'TGO', '');
INSERT INTO `country` VALUES (211, 'Tokelau', 0, 'TK', 'TKL', '');
INSERT INTO `country` VALUES (212, 'Tonga', 0, 'TO', 'TON', '');
INSERT INTO `country` VALUES (213, 'Trinidad and Tobago', 0, 'TT', 'TTO', '');
INSERT INTO `country` VALUES (214, 'Tunisia', 0, 'TN', 'TUN', '');
INSERT INTO `country` VALUES (215, 'Turkey', 0, 'TR', 'TUR', '');
INSERT INTO `country` VALUES (216, 'Turkmenistan', 0, 'TM', 'TKM', '');
INSERT INTO `country` VALUES (217, 'Turks and Caicos Islands', 0, 'TC', 'TCA', '');
INSERT INTO `country` VALUES (218, 'Tuvalu', 0, 'TV', 'TUV', '');
INSERT INTO `country` VALUES (219, 'Uganda', 0, 'UG', 'UGA', '');
INSERT INTO `country` VALUES (220, 'Ukraine', 0, 'UA', 'UKR', '');
INSERT INTO `country` VALUES (221, 'United Arab Emirates', 0, 'AE', 'ARE', '');
INSERT INTO `country` VALUES (222, 'United Kingdom', 0, 'GB', 'GBR', '');
INSERT INTO `country` VALUES (223, 'United States', 0, 'US', 'USA', '');
INSERT INTO `country` VALUES (224, 'United States Minor Outlying Islands', 0, 'UM', 'UMI', '');
INSERT INTO `country` VALUES (225, 'Uruguay', 0, 'UY', 'URY', '');
INSERT INTO `country` VALUES (226, 'Uzbekistan', 0, 'UZ', 'UZB', '');
INSERT INTO `country` VALUES (227, 'Vanuatu', 0, 'VU', 'VUT', '');
INSERT INTO `country` VALUES (228, 'Vatican City State (Holy see)', 0, 'VA', 'VAT', '');
INSERT INTO `country` VALUES (229, 'Venezuela', 0, 'VE', 'VEN', '');
INSERT INTO `country` VALUES (230, 'Viet Nam', 0, 'VN', 'VNM', '');
INSERT INTO `country` VALUES (231, 'Virgin Islands (British)', 0, 'VG', 'VGB', '');
INSERT INTO `country` VALUES (232, 'Virgin Islands (U.S.)', 0, 'VI', 'VIR', '');
INSERT INTO `country` VALUES (233, 'Wallis and Futuna Islands', 0, 'WF', 'WLF', '');
INSERT INTO `country` VALUES (234, 'Western Sahara', 0, 'EH', 'ESH', '');
INSERT INTO `country` VALUES (235, 'Yemen', 0, 'YE', 'YEM', '');
INSERT INTO `country` VALUES (238, 'Zambia', 0, 'ZM', 'ZMB', '');
INSERT INTO `country` VALUES (239, 'Zimbabwe', 0, 'ZW', 'ZWE', '');