CREATE TABLE list (id VARCHAR(64) NOT NULL, value VARCHAR(64) NOT NULL, PRIMARY KEY(id));

INSERT INTO "list" ("id", "value") VALUES (E'AF', E'i-Afghanistan');
INSERT INTO "list" ("id", "value") VALUES (E'AX', E'i-Åland Islands');
INSERT INTO "list" ("id", "value") VALUES (E'AL', E'i-Albania');
INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'i-Algeria');
INSERT INTO "list" ("id", "value") VALUES (E'AS', E'i-American Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'AD', E'i-Andorra');
INSERT INTO "list" ("id", "value") VALUES (E'AO', E'i-Angola');
INSERT INTO "list" ("id", "value") VALUES (E'AI', E'i-Anguilla');
INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'i-Antarctica');
INSERT INTO "list" ("id", "value") VALUES (E'AG', E'i-Antigua ne-Barbuda');
INSERT INTO "list" ("id", "value") VALUES (E'AR', E'i-Argentina');
INSERT INTO "list" ("id", "value") VALUES (E'AM', E'i-Armenia');
INSERT INTO "list" ("id", "value") VALUES (E'AW', E'i-Aruba');
INSERT INTO "list" ("id", "value") VALUES (E'AU', E'i-Australia');
INSERT INTO "list" ("id", "value") VALUES (E'AT', E'i-Austria');
INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'i-Azerbaijan');
INSERT INTO "list" ("id", "value") VALUES (E'BS', E'i-Bahamas');
INSERT INTO "list" ("id", "value") VALUES (E'BH', E'i-Bahrain');
INSERT INTO "list" ("id", "value") VALUES (E'BD', E'i-Bangladesh');
INSERT INTO "list" ("id", "value") VALUES (E'BB', E'i-Barbados');
INSERT INTO "list" ("id", "value") VALUES (E'BY', E'i-Belarus');
INSERT INTO "list" ("id", "value") VALUES (E'BE', E'i-Belgium');
INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'i-Belize');
INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'i-Benin');
INSERT INTO "list" ("id", "value") VALUES (E'BM', E'i-Bermuda');
INSERT INTO "list" ("id", "value") VALUES (E'BT', E'i-Bhutan');
INSERT INTO "list" ("id", "value") VALUES (E'BO', E'i-Bolivia');
INSERT INTO "list" ("id", "value") VALUES (E'BA', E'i-Bosnia ne-Herzegovina');
INSERT INTO "list" ("id", "value") VALUES (E'BV', E'i-Bouvet Island');
INSERT INTO "list" ("id", "value") VALUES (E'BR', E'i-Brazil');
INSERT INTO "list" ("id", "value") VALUES (E'IO', E'i-British Indian Ocean Territory');
INSERT INTO "list" ("id", "value") VALUES (E'VG', E'i-British Virgin Islands');
INSERT INTO "list" ("id", "value") VALUES (E'BN', E'i-Brunei');
INSERT INTO "list" ("id", "value") VALUES (E'BG', E'i-Bulgaria');
INSERT INTO "list" ("id", "value") VALUES (E'BF', E'i-Burkina Faso');
INSERT INTO "list" ("id", "value") VALUES (E'BI', E'i-Burundi');
INSERT INTO "list" ("id", "value") VALUES (E'KH', E'i-Cambodia');
INSERT INTO "list" ("id", "value") VALUES (E'CM', E'i-Cameroon');
INSERT INTO "list" ("id", "value") VALUES (E'CA', E'i-Canada');
INSERT INTO "list" ("id", "value") VALUES (E'CV', E'i-Cape Verde');
INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'i-Caribbean Netherlands');
INSERT INTO "list" ("id", "value") VALUES (E'KY', E'i-Cayman Islands');
INSERT INTO "list" ("id", "value") VALUES (E'CF', E'i-Central African Republic');
INSERT INTO "list" ("id", "value") VALUES (E'TD', E'i-Chad');
INSERT INTO "list" ("id", "value") VALUES (E'CL', E'i-Chile');
INSERT INTO "list" ("id", "value") VALUES (E'CN', E'i-China');
INSERT INTO "list" ("id", "value") VALUES (E'CX', E'i-Christmas Island');
INSERT INTO "list" ("id", "value") VALUES (E'CC', E'i-Cocos (Keeling) Islands');
INSERT INTO "list" ("id", "value") VALUES (E'CO', E'i-Colombia');
INSERT INTO "list" ("id", "value") VALUES (E'KM', E'i-Comoros');
INSERT INTO "list" ("id", "value") VALUES (E'CG', E'i-Congo - Brazzaville');
INSERT INTO "list" ("id", "value") VALUES (E'CD', E'i-Congo - Kinshasa');
INSERT INTO "list" ("id", "value") VALUES (E'CK', E'i-Cook Islands');
INSERT INTO "list" ("id", "value") VALUES (E'CR', E'i-Costa Rica');
INSERT INTO "list" ("id", "value") VALUES (E'CI', E'i-Côte d’Ivoire');
INSERT INTO "list" ("id", "value") VALUES (E'HR', E'i-Croatia');
INSERT INTO "list" ("id", "value") VALUES (E'CU', E'i-Cuba');
INSERT INTO "list" ("id", "value") VALUES (E'CW', E'i-Curaçao');
INSERT INTO "list" ("id", "value") VALUES (E'CY', E'i-Cyprus');
INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'i-Czechia');
INSERT INTO "list" ("id", "value") VALUES (E'DK', E'i-Denmark');
INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'i-Djibouti');
INSERT INTO "list" ("id", "value") VALUES (E'DM', E'i-Dominica');
INSERT INTO "list" ("id", "value") VALUES (E'DO', E'i-Dominican Republic');
INSERT INTO "list" ("id", "value") VALUES (E'EC', E'i-Ecuador');
INSERT INTO "list" ("id", "value") VALUES (E'EG', E'i-Egypt');
INSERT INTO "list" ("id", "value") VALUES (E'SV', E'i-El Salvador');
INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'i-Equatorial Guinea');
INSERT INTO "list" ("id", "value") VALUES (E'ER', E'i-Eritrea');
INSERT INTO "list" ("id", "value") VALUES (E'EE', E'i-Estonia');
INSERT INTO "list" ("id", "value") VALUES (E'ET', E'i-Ethiopia');
INSERT INTO "list" ("id", "value") VALUES (E'FK', E'i-Falkland Islands');
INSERT INTO "list" ("id", "value") VALUES (E'FO', E'i-Faroe Islands');
INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'i-Fiji');
INSERT INTO "list" ("id", "value") VALUES (E'FI', E'i-Finland');
INSERT INTO "list" ("id", "value") VALUES (E'FR', E'i-France');
INSERT INTO "list" ("id", "value") VALUES (E'GF', E'i-French Guiana');
INSERT INTO "list" ("id", "value") VALUES (E'PF', E'i-French Polynesia');
INSERT INTO "list" ("id", "value") VALUES (E'TF', E'i-French Southern Territories');
INSERT INTO "list" ("id", "value") VALUES (E'GA', E'i-Gabon');
INSERT INTO "list" ("id", "value") VALUES (E'GM', E'i-Gambia');
INSERT INTO "list" ("id", "value") VALUES (E'GE', E'i-Georgia');
INSERT INTO "list" ("id", "value") VALUES (E'DE', E'i-Germany');
INSERT INTO "list" ("id", "value") VALUES (E'GH', E'i-Ghana');
INSERT INTO "list" ("id", "value") VALUES (E'GI', E'i-Gibraltar');
INSERT INTO "list" ("id", "value") VALUES (E'GR', E'i-Greece');
INSERT INTO "list" ("id", "value") VALUES (E'GL', E'i-Greenland');
INSERT INTO "list" ("id", "value") VALUES (E'GD', E'i-Grenada');
INSERT INTO "list" ("id", "value") VALUES (E'GP', E'i-Guadeloupe');
INSERT INTO "list" ("id", "value") VALUES (E'GU', E'i-Guam');
INSERT INTO "list" ("id", "value") VALUES (E'GT', E'i-Guatemala');
INSERT INTO "list" ("id", "value") VALUES (E'GG', E'i-Guernsey');
INSERT INTO "list" ("id", "value") VALUES (E'GN', E'i-Guinea');
INSERT INTO "list" ("id", "value") VALUES (E'GW', E'i-Guinea-Bissau');
INSERT INTO "list" ("id", "value") VALUES (E'GY', E'i-Guyana');
INSERT INTO "list" ("id", "value") VALUES (E'HT', E'i-Haiti');
INSERT INTO "list" ("id", "value") VALUES (E'HM', E'I-Heard & McDonald Island');
INSERT INTO "list" ("id", "value") VALUES (E'HN', E'i-Honduras');
INSERT INTO "list" ("id", "value") VALUES (E'HK', E'i-Hong Kong SAR China');
INSERT INTO "list" ("id", "value") VALUES (E'HU', E'i-Hungary');
INSERT INTO "list" ("id", "value") VALUES (E'IS', E'i-Iceland');
INSERT INTO "list" ("id", "value") VALUES (E'IN', E'i-India');
INSERT INTO "list" ("id", "value") VALUES (E'ID', E'i-Indonesia');
INSERT INTO "list" ("id", "value") VALUES (E'IR', E'i-Iran');
INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'i-Iraq');
INSERT INTO "list" ("id", "value") VALUES (E'IE', E'i-Ireland');
INSERT INTO "list" ("id", "value") VALUES (E'IM', E'i-Isle of Man');
INSERT INTO "list" ("id", "value") VALUES (E'IT', E'i-Italy');
INSERT INTO "list" ("id", "value") VALUES (E'JM', E'i-Jamaica');
INSERT INTO "list" ("id", "value") VALUES (E'JP', E'i-Japan');
INSERT INTO "list" ("id", "value") VALUES (E'JE', E'i-Jersey');
INSERT INTO "list" ("id", "value") VALUES (E'JO', E'i-Jordan');
INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'i-Kazakhstan');
INSERT INTO "list" ("id", "value") VALUES (E'KE', E'i-Kenya');
INSERT INTO "list" ("id", "value") VALUES (E'KI', E'i-Kiribati');
INSERT INTO "list" ("id", "value") VALUES (E'KW', E'i-Kuwait');
INSERT INTO "list" ("id", "value") VALUES (E'KG', E'i-Kyrgyzstan');
INSERT INTO "list" ("id", "value") VALUES (E'LA', E'i-Laos');
INSERT INTO "list" ("id", "value") VALUES (E'LV', E'i-Latvia');
INSERT INTO "list" ("id", "value") VALUES (E'LB', E'i-Lebanon');
INSERT INTO "list" ("id", "value") VALUES (E'LR', E'i-Liberia');
INSERT INTO "list" ("id", "value") VALUES (E'LY', E'i-Libya');
INSERT INTO "list" ("id", "value") VALUES (E'LI', E'i-Liechtenstein');
INSERT INTO "list" ("id", "value") VALUES (E'LT', E'i-Lithuania');
INSERT INTO "list" ("id", "value") VALUES (E'LU', E'i-Luxembourg');
INSERT INTO "list" ("id", "value") VALUES (E'MO', E'i-Macau SAR China');
INSERT INTO "list" ("id", "value") VALUES (E'MG', E'i-Madagascar');
INSERT INTO "list" ("id", "value") VALUES (E'MY', E'i-Malaysia');
INSERT INTO "list" ("id", "value") VALUES (E'MV', E'i-Maldives');
INSERT INTO "list" ("id", "value") VALUES (E'MT', E'i-Malta');
INSERT INTO "list" ("id", "value") VALUES (E'MH', E'i-Marshall Islands');
INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'i-Martinique');
INSERT INTO "list" ("id", "value") VALUES (E'MR', E'i-Mauritania');
INSERT INTO "list" ("id", "value") VALUES (E'MU', E'i-Mauritius');
INSERT INTO "list" ("id", "value") VALUES (E'YT', E'i-Mayotte');
INSERT INTO "list" ("id", "value") VALUES (E'MX', E'i-Mexico');
INSERT INTO "list" ("id", "value") VALUES (E'FM', E'i-Micronesia');
INSERT INTO "list" ("id", "value") VALUES (E'MD', E'i-Moldova');
INSERT INTO "list" ("id", "value") VALUES (E'MC', E'i-Monaco');
INSERT INTO "list" ("id", "value") VALUES (E'MN', E'i-Mongolia');
INSERT INTO "list" ("id", "value") VALUES (E'ME', E'i-Montenegro');
INSERT INTO "list" ("id", "value") VALUES (E'MS', E'i-Montserrat');
INSERT INTO "list" ("id", "value") VALUES (E'MA', E'i-Morocco');
INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'i-Mozambique');
INSERT INTO "list" ("id", "value") VALUES (E'MM', E'i-Myanmar (Burma)');
INSERT INTO "list" ("id", "value") VALUES (E'NA', E'i-Namibia');
INSERT INTO "list" ("id", "value") VALUES (E'NR', E'i-Nauru');
INSERT INTO "list" ("id", "value") VALUES (E'NP', E'i-Nepal');
INSERT INTO "list" ("id", "value") VALUES (E'NL', E'i-Netherlands');
INSERT INTO "list" ("id", "value") VALUES (E'NC', E'i-New Caledonia');
INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'i-New Zealand');
INSERT INTO "list" ("id", "value") VALUES (E'NI', E'i-Nicaragua');
INSERT INTO "list" ("id", "value") VALUES (E'NE', E'i-Niger');
INSERT INTO "list" ("id", "value") VALUES (E'NG', E'i-Nigeria');
INSERT INTO "list" ("id", "value") VALUES (E'NU', E'i-Niue');
INSERT INTO "list" ("id", "value") VALUES (E'NF', E'i-Norfolk Island');
INSERT INTO "list" ("id", "value") VALUES (E'KP', E'i-North Korea');
INSERT INTO "list" ("id", "value") VALUES (E'MK', E'i-North Macedonia');
INSERT INTO "list" ("id", "value") VALUES (E'MP', E'i-Northern Mariana Islands');
INSERT INTO "list" ("id", "value") VALUES (E'NO', E'i-Norway');
INSERT INTO "list" ("id", "value") VALUES (E'OM', E'i-Oman');
INSERT INTO "list" ("id", "value") VALUES (E'PK', E'i-Pakistan');
INSERT INTO "list" ("id", "value") VALUES (E'PW', E'i-Palau');
INSERT INTO "list" ("id", "value") VALUES (E'PS', E'i-Palestinian Territories');
INSERT INTO "list" ("id", "value") VALUES (E'PA', E'i-Panama');
INSERT INTO "list" ("id", "value") VALUES (E'PG', E'i-Papua New Guinea');
INSERT INTO "list" ("id", "value") VALUES (E'PY', E'i-Paraguay');
INSERT INTO "list" ("id", "value") VALUES (E'PE', E'i-Peru');
INSERT INTO "list" ("id", "value") VALUES (E'PH', E'i-Philippines');
INSERT INTO "list" ("id", "value") VALUES (E'PN', E'i-Pitcairn Islands');
INSERT INTO "list" ("id", "value") VALUES (E'PL', E'i-Poland');
INSERT INTO "list" ("id", "value") VALUES (E'PT', E'i-Portugal');
INSERT INTO "list" ("id", "value") VALUES (E'PR', E'i-Puerto Rico');
INSERT INTO "list" ("id", "value") VALUES (E'QA', E'i-Qatar');
INSERT INTO "list" ("id", "value") VALUES (E'RE', E'i-Réunion');
INSERT INTO "list" ("id", "value") VALUES (E'RO', E'i-Romania');
INSERT INTO "list" ("id", "value") VALUES (E'RU', E'i-Russia');
INSERT INTO "list" ("id", "value") VALUES (E'RW', E'i-Rwanda');
INSERT INTO "list" ("id", "value") VALUES (E'BL', E'i-Saint Barthélemy');
INSERT INTO "list" ("id", "value") VALUES (E'KN', E'i-Saint Kitts ne-Nevis');
INSERT INTO "list" ("id", "value") VALUES (E'LC', E'i-Saint Lucia');
INSERT INTO "list" ("id", "value") VALUES (E'MF', E'i-Saint Martin');
INSERT INTO "list" ("id", "value") VALUES (E'PM', E'i-Saint Pierre kanye ne-Miquelon');
INSERT INTO "list" ("id", "value") VALUES (E'VC', E'i-Saint Vincent ne-Grenadines');
INSERT INTO "list" ("id", "value") VALUES (E'WS', E'i-Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'SM', E'i-San Marino');
INSERT INTO "list" ("id", "value") VALUES (E'ST', E'i-São Tomé kanye ne-Príncipe');
INSERT INTO "list" ("id", "value") VALUES (E'SA', E'i-Saudi Arabia');
INSERT INTO "list" ("id", "value") VALUES (E'SN', E'i-Senegal');
INSERT INTO "list" ("id", "value") VALUES (E'RS', E'i-Serbia');
INSERT INTO "list" ("id", "value") VALUES (E'SC', E'i-Seychelles');
INSERT INTO "list" ("id", "value") VALUES (E'SL', E'i-Sierra Leone');
INSERT INTO "list" ("id", "value") VALUES (E'SG', E'i-Singapore');
INSERT INTO "list" ("id", "value") VALUES (E'SX', E'i-Sint Maarten');
INSERT INTO "list" ("id", "value") VALUES (E'SK', E'i-Slovakia');
INSERT INTO "list" ("id", "value") VALUES (E'SI', E'i-Slovenia');
INSERT INTO "list" ("id", "value") VALUES (E'SB', E'i-Solomon Islands');
INSERT INTO "list" ("id", "value") VALUES (E'SO', E'i-Somalia');
INSERT INTO "list" ("id", "value") VALUES (E'GS', E'i-South Georgia ne-South Sandwich Islands');
INSERT INTO "list" ("id", "value") VALUES (E'KR', E'i-South Korea');
INSERT INTO "list" ("id", "value") VALUES (E'SS', E'i-South Sudan');
INSERT INTO "list" ("id", "value") VALUES (E'ES', E'i-Spain');
INSERT INTO "list" ("id", "value") VALUES (E'LK', E'i-Sri Lanka');
INSERT INTO "list" ("id", "value") VALUES (E'SH', E'i-St. Helena');
INSERT INTO "list" ("id", "value") VALUES (E'SD', E'i-Sudan');
INSERT INTO "list" ("id", "value") VALUES (E'SR', E'i-Suriname');
INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'i-Svalbard ne-Jan Mayen');
INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'i-Swaziland');
INSERT INTO "list" ("id", "value") VALUES (E'SE', E'i-Sweden');
INSERT INTO "list" ("id", "value") VALUES (E'CH', E'i-Switzerland');
INSERT INTO "list" ("id", "value") VALUES (E'SY', E'i-Syria');
INSERT INTO "list" ("id", "value") VALUES (E'TW', E'i-Taiwan');
INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'i-Tajikistan');
INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'i-Tanzania');
INSERT INTO "list" ("id", "value") VALUES (E'TH', E'i-Thailand');
INSERT INTO "list" ("id", "value") VALUES (E'TL', E'i-Timor-Leste');
INSERT INTO "list" ("id", "value") VALUES (E'TG', E'i-Togo');
INSERT INTO "list" ("id", "value") VALUES (E'TK', E'i-Tokelau');
INSERT INTO "list" ("id", "value") VALUES (E'TO', E'i-Tonga');
INSERT INTO "list" ("id", "value") VALUES (E'TT', E'i-Trinidad ne-Tobago');
INSERT INTO "list" ("id", "value") VALUES (E'TN', E'i-Tunisia');
INSERT INTO "list" ("id", "value") VALUES (E'TR', E'i-Turkey');
INSERT INTO "list" ("id", "value") VALUES (E'TM', E'i-Turkmenistan');
INSERT INTO "list" ("id", "value") VALUES (E'TC', E'i-Turks ne-Caicos Islands');
INSERT INTO "list" ("id", "value") VALUES (E'TV', E'i-Tuvalu');
INSERT INTO "list" ("id", "value") VALUES (E'UM', E'I-U.S. Outlying Islands');
INSERT INTO "list" ("id", "value") VALUES (E'VI', E'i-U.S. Virgin Islands');
INSERT INTO "list" ("id", "value") VALUES (E'UG', E'i-Uganda');
INSERT INTO "list" ("id", "value") VALUES (E'UA', E'i-Ukraine');
INSERT INTO "list" ("id", "value") VALUES (E'AE', E'i-United Arab Emirates');
INSERT INTO "list" ("id", "value") VALUES (E'GB', E'i-United Kingdom');
INSERT INTO "list" ("id", "value") VALUES (E'US', E'i-United States');
INSERT INTO "list" ("id", "value") VALUES (E'UY', E'i-Uruguay');
INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'i-Uzbekistan');
INSERT INTO "list" ("id", "value") VALUES (E'VU', E'i-Vanuatu');
INSERT INTO "list" ("id", "value") VALUES (E'VA', E'i-Vatican City');
INSERT INTO "list" ("id", "value") VALUES (E'VE', E'i-Venezuela');
INSERT INTO "list" ("id", "value") VALUES (E'VN', E'i-Vietnam');
INSERT INTO "list" ("id", "value") VALUES (E'WF', E'i-Wallis ne-Futuna');
INSERT INTO "list" ("id", "value") VALUES (E'EH', E'i-Western Sahara');
INSERT INTO "list" ("id", "value") VALUES (E'YE', E'i-Yemen');
INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'i-Zambia');
INSERT INTO "list" ("id", "value") VALUES (E'BW', E'iBotswana');
INSERT INTO "list" ("id", "value") VALUES (E'LS', E'iLesotho');
INSERT INTO "list" ("id", "value") VALUES (E'MW', E'iMalawi');
INSERT INTO "list" ("id", "value") VALUES (E'ML', E'iMali');
INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'iNingizimu Afrika');
INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'iZimbabwe');
INSERT INTO "list" ("id", "value") VALUES (E'IL', E'kwa-Israel');
