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'Afghanistan');
INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'Afrika Atsimo');
INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Åland Islands');
INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Albania');
INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Alemaina');
INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Alzeria');
INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andorra');
INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Angletera');
INSERT INTO "list" ("id", "value") VALUES (E'AO', E'Angola');
INSERT INTO "list" ("id", "value") VALUES (E'AI', E'Anguilla');
INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antarctica');
INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antiga sy Barboda');
INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Aostralia');
INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Aotrisy');
INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Arabia saodita');
INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Armenia');
INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Arobà');
INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Arzantina');
INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azerbaidjan');
INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahamas');
INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Bahrain');
INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangladesy');
INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Barbady');
INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Belarosy');
INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belize');
INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Belzika');
INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Benin');
INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermioda');
INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Bhotana');
INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Biolgaria');
INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Bolivia');
INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Borkina Faso');
INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Borondi');
INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bosnia sy Herzegovina');
INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botsoana');
INSERT INTO "list" ("id", "value") VALUES (E'BV', E'Bouvet Island');
INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Brezila');
INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Brunei');
INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Caribbean Netherlands');
INSERT INTO "list" ("id", "value") VALUES (E'CX', E'Christmas Island');
INSERT INTO "list" ("id", "value") VALUES (E'CC', E'Cocos (Keeling) Islands');
INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Côte d’Ivoire');
INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Curaçao');
INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Danmarka');
INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Djiboti');
INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Dominika');
INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Ejypta');
INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Ekoatera');
INSERT INTO "list" ("id", "value") VALUES (E'SV', E'El Salvador');
INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Emirà Arabo mitambatra');
INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Eritrea');
INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Espaina');
INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Estonia');
INSERT INTO "list" ("id", "value") VALUES (E'US', E'Etazonia');
INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Ethiopia');
INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Faridranomasina indiana britanika');
INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Faroe Islands');
INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fidji');
INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Filipina');
INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Finlandy');
INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Firenen’i Vatikana');
INSERT INTO "list" ("id", "value") VALUES (E'FR', E'Frantsa');
INSERT INTO "list" ("id", "value") VALUES (E'TF', E'French Southern Territories');
INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabon');
INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gambia');
INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Ghana');
INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Giné-Bisao');
INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Ginea');
INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Goadelopy');
INSERT INTO "list" ("id", "value") VALUES (E'GT', E'Goatemalà');
INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Grenady');
INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Gresy');
INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Groenland');
INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Guam');
INSERT INTO "list" ("id", "value") VALUES (E'GG', E'Guernsey');
INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Guinea Ekoatera');
INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Guyana');
INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Guyana frantsay');
INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Haiti');
INSERT INTO "list" ("id", "value") VALUES (E'HM', E'Heard & McDonald Islands');
INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Holanda');
INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Hondiorasy');
INSERT INTO "list" ("id", "value") VALUES (E'HK', E'Hong Kong SAR China');
INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Hongria');
INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indonezia');
INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Indy');
INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Irak');
INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Iran');
INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Irlandy');
INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Islandy');
INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Isle of Man');
INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Israely');
INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Italia');
INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jamaïka');
INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Japana');
INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Jersey');
INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Jordania');
INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Kambôdja');
INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Kamerona');
INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Kanada');
INSERT INTO "list" ("id", "value") VALUES (E'QA', E'Katar');
INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Kazakhstan');
INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Kenya');
INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Kiobà');
INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kiordistan');
INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribati');
INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Kôeity');
INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Kôlômbia');
INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Kômaoro');
INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Kôngô');
INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Korea Atsimo');
INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Korea Avaratra');
INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Kosta Rikà');
INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Kroasia');
INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laôs');
INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Larenion');
INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesotho');
INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Letonia');
INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Libana');
INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Liberia');
INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Libya');
INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Lioksamboro');
INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Listenstein');
INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Litoania');
INSERT INTO "list" ("id", "value") VALUES (E'MO', E'Macao SAR China');
INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagasikara');
INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malaizia');
INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malaoì');
INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maldiva');
INSERT INTO "list" ("id", "value") VALUES (E'ML', E'Mali');
INSERT INTO "list" ("id", "value") VALUES (E'MT', E'Malta');
INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Maorisy');
INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Maoritania');
INSERT INTO "list" ("id", "value") VALUES (E'MA', E'Marôka');
INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martinika');
INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Mayôty');
INSERT INTO "list" ("id", "value") VALUES (E'MX', E'Meksika');
INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Mikrônezia');
INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Môldavia');
INSERT INTO "list" ("id", "value") VALUES (E'MC', E'Mônakô');
INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Môngôlia');
INSERT INTO "list" ("id", "value") VALUES (E'ME', E'Montenegro');
INSERT INTO "list" ("id", "value") VALUES (E'MS', E'Montserrat');
INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Mozambika');
INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Myanmar');
INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namibia');
INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Naorò');
INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Nepala');
INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Niger');
INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nikaragoà');
INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Nioé');
INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nizeria');
INSERT INTO "list" ("id", "value") VALUES (E'MK', E'North Macedonia');
INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Nôrvezy');
INSERT INTO "list" ("id", "value") VALUES (E'VG', E'Nosy britanika virijiny');
INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Nosy Cap-Vert');
INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Nosy Falkand');
INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Nosy Kayman');
INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Nosy Kook');
INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Nosy Mariana Atsinanana');
INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Nosy Marshall');
INSERT INTO "list" ("id", "value") VALUES (E'NF', E'Nosy Norfolk');
INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Nosy Salomona');
INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Nosy Turks sy Caïques');
INSERT INTO "list" ("id", "value") VALUES (E'VI', E'Nosy Virijiny Etazonia');
INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Nouvelle-Calédonie');
INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Nouvelle-Zélande');
INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Oganda');
INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Okraina');
INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Oman');
INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Orogoay');
INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Ozbekistan');
INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Pakistan');
INSERT INTO "list" ("id", "value") VALUES (E'PW', E'Palao');
INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Palestina');
INSERT INTO "list" ("id", "value") VALUES (E'PA', E'Panama');
INSERT INTO "list" ("id", "value") VALUES (E'PG', E'Papouasie-Nouvelle-Guinée');
INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paragoay');
INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Peroa');
INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Pitkairn');
INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Pôlôna');
INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Polynezia frantsay');
INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Pôrtiogala');
INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Pôrtô Rikô');
INSERT INTO "list" ("id", "value") VALUES (E'DO', E'Repoblika Dominikanina');
INSERT INTO "list" ("id", "value") VALUES (E'CF', E'Repoblika Ivon’Afrika');
INSERT INTO "list" ("id", "value") VALUES (E'CD', E'Repoblikan’i Kongo');
INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Repoblikan’i Tseky');
INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Roanda');
INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Romania');
INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Rosia');
INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Saint-Christophe-et-Niévès');
INSERT INTO "list" ("id", "value") VALUES (E'SM', E'Saint-Marin');
INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Saint-Pierre-et-Miquelon');
INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Saint-Vincent-et-les Grenadines');
INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Sainte-Hélène');
INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Sainte-Lucie');
INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'AS', E'Samoa amerikanina');
INSERT INTO "list" ("id", "value") VALUES (E'ST', E'São Tomé-et-Príncipe');
INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Senegal');
INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Serbia');
INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Seyshela');
INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Shili');
INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Sierra Leone');
INSERT INTO "list" ("id", "value") VALUES (E'CN', E'Sina');
INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singaporo');
INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Sint Maarten');
INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Slovakia');
INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Slovenia');
INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Soazilandy');
INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Sodan');
INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Soedy');
INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Soisa');
INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Somalia');
INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Sorinam');
INSERT INTO "list" ("id", "value") VALUES (E'GS', E'South Georgia & South Sandwich Islands');
INSERT INTO "list" ("id", "value") VALUES (E'SS', E'South Sudan');
INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Sri Lanka');
INSERT INTO "list" ("id", "value") VALUES (E'BL', E'St. Barthélemy');
INSERT INTO "list" ("id", "value") VALUES (E'MF', E'St. Martin');
INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbard & Jan Mayen');
INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Sypra');
INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Syria');
INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Taioana');
INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Tajikistan');
INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzania');
INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Thailandy');
INSERT INTO "list" ("id", "value") VALUES (E'TL', E'Timor Atsinanana');
INSERT INTO "list" ("id", "value") VALUES (E'TG', E'Togo');
INSERT INTO "list" ("id", "value") VALUES (E'TK', E'Tokelao');
INSERT INTO "list" ("id", "value") VALUES (E'TO', E'Tongà');
INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tonizia');
INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Torkia');
INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Torkmenistan');
INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tovalò');
INSERT INTO "list" ("id", "value") VALUES (E'TT', E'Trinidad sy Tobagô');
INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Tsady');
INSERT INTO "list" ("id", "value") VALUES (E'UM', E'U.S. Outlying Islands');
INSERT INTO "list" ("id", "value") VALUES (E'VU', E'Vanoatò');
INSERT INTO "list" ("id", "value") VALUES (E'VE', E'Venezoelà');
INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Vietnam');
INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Wallis sy Futuna');
INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Western Sahara');
INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Yemen');
INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zambia');
INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Zeorzia');
INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Zibraltara');
INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbaboe');