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'Afghánistán');
INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Ålandy');
INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Albánie');
INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Alžírsko');
INSERT INTO "list" ("id", "value") VALUES (E'AS', E'Americká Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'VI', E'Americké Panenské ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andorra');
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'Antarktida');
INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antigua a Barbuda');
INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Argentina');
INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Arménie');
INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Aruba');
INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Austrálie');
INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Ázerbájdžán');
INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahamy');
INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Bahrajn');
INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangladéš');
INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Barbados');
INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Belgie');
INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belize');
INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Bělorusko');
INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Benin');
INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermudy');
INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Bhútán');
INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Bolívie');
INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bosna a Hercegovina');
INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botswana');
INSERT INTO "list" ("id", "value") VALUES (E'BV', E'Bouvetův ostrov');
INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Brazílie');
INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Britské indickooceánské území');
INSERT INTO "list" ("id", "value") VALUES (E'VG', E'Britské Panenské ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Brunej');
INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Bulharsko');
INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Burkina Faso');
INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Burundi');
INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Cookovy ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Curaçao');
INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Čad');
INSERT INTO "list" ("id", "value") VALUES (E'ME', E'Černá Hora');
INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Česko');
INSERT INTO "list" ("id", "value") VALUES (E'CN', E'Čína');
INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Dánsko');
INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Dominika');
INSERT INTO "list" ("id", "value") VALUES (E'DO', E'Dominikánská republika');
INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Džibutsko');
INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Egypt');
INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Ekvádor');
INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Eritrea');
INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Estonsko');
INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Etiopie');
INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Faerské ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Falklandské ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fidži');
INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Filipíny');
INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Finsko');
INSERT INTO "list" ("id", "value") VALUES (E'FR', E'Francie');
INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Francouzská Guyana');
INSERT INTO "list" ("id", "value") VALUES (E'TF', E'Francouzská jižní území');
INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Francouzská Polynésie');
INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabon');
INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gambie');
INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Ghana');
INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Gibraltar');
INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Grenada');
INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Grónsko');
INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Gruzie');
INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Guadeloupe');
INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Guam');
INSERT INTO "list" ("id", "value") VALUES (E'GT', E'Guatemala');
INSERT INTO "list" ("id", "value") VALUES (E'GG', E'Guernsey');
INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Guinea');
INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Guinea-Bissau');
INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Guyana');
INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Haiti');
INSERT INTO "list" ("id", "value") VALUES (E'HM', E'Heardův ostrov a McDonaldovy ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Honduras');
INSERT INTO "list" ("id", "value") VALUES (E'HK', E'Hongkong – ZAO Číny');
INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Chile');
INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Chorvatsko');
INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Indie');
INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indonésie');
INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Irák');
INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Írán');
INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Irsko');
INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Island');
INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Itálie');
INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Izrael');
INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jamajka');
INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Japonsko');
INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Jemen');
INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Jersey');
INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'Jihoafrická republika');
INSERT INTO "list" ("id", "value") VALUES (E'GS', E'Jižní Georgie a Jižní Sandwichovy ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Jižní Korea');
INSERT INTO "list" ("id", "value") VALUES (E'SS', E'Jižní Súdán');
INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Jordánsko');
INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Kajmanské ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Kambodža');
INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Kamerun');
INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Kanada');
INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Kapverdy');
INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Karibské Nizozemsko');
INSERT INTO "list" ("id", "value") VALUES (E'QA', E'Katar');
INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Kazachstán');
INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Keňa');
INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribati');
INSERT INTO "list" ("id", "value") VALUES (E'CC', E'Kokosové ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Kolumbie');
INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Komory');
INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Kongo – Brazzaville');
INSERT INTO "list" ("id", "value") VALUES (E'CD', E'Kongo – Kinshasa');
INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Kostarika');
INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Kuba');
INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Kuvajt');
INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Kypr');
INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kyrgyzstán');
INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laos');
INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesotho');
INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Libanon');
INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Libérie');
INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Libye');
INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Lichtenštejnsko');
INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Litva');
INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Lotyšsko');
INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Lucembursko');
INSERT INTO "list" ("id", "value") VALUES (E'MO', E'Macao – ZAO Číny');
INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagaskar');
INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Maďarsko');
INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malajsie');
INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malawi');
INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maledivy');
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'MA', E'Maroko');
INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Marshallovy ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martinik');
INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Mauricius');
INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Mauritánie');
INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Mayotte');
INSERT INTO "list" ("id", "value") VALUES (E'UM', E'Menší odlehlé ostrovy USA');
INSERT INTO "list" ("id", "value") VALUES (E'MX', E'Mexiko');
INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Mikronésie');
INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Moldavsko');
INSERT INTO "list" ("id", "value") VALUES (E'MC', E'Monako');
INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Mongolsko');
INSERT INTO "list" ("id", "value") VALUES (E'MS', E'Montserrat');
INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Mosambik');
INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Myanmar (Barma)');
INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namibie');
INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Nauru');
INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Německo');
INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Nepál');
INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Niger');
INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nigérie');
INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nikaragua');
INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niue');
INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Nizozemsko');
INSERT INTO "list" ("id", "value") VALUES (E'NF', E'Norfolk');
INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Norsko');
INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Nová Kaledonie');
INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Nový Zéland');
INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Omán');
INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Ostrov Man');
INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Pákistán');
INSERT INTO "list" ("id", "value") VALUES (E'PW', E'Palau');
INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Palestinská území');
INSERT INTO "list" ("id", "value") VALUES (E'PA', E'Panama');
INSERT INTO "list" ("id", "value") VALUES (E'PG', E'Papua-Nová Guinea');
INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paraguay');
INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Peru');
INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Pitcairnovy ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Pobřeží slonoviny');
INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Polsko');
INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Portoriko');
INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Portugalsko');
INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Rakousko');
INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Réunion');
INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Rovníková Guinea');
INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Rumunsko');
INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Rusko');
INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Rwanda');
INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Řecko');
INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Saint-Pierre a Miquelon');
INSERT INTO "list" ("id", "value") VALUES (E'SV', E'Salvador');
INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'SM', E'San Marino');
INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Saúdská Arábie');
INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Senegal');
INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Severní Korea');
INSERT INTO "list" ("id", "value") VALUES (E'MK', E'Severní Makedonie');
INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Severní Mariany');
INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Seychely');
INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Sierra Leone');
INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singapur');
INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Slovensko');
INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Slovinsko');
INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Somálsko');
INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Spojené arabské emiráty');
INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Spojené království');
INSERT INTO "list" ("id", "value") VALUES (E'US', E'Spojené státy');
INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Srbsko');
INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Srí Lanka');
INSERT INTO "list" ("id", "value") VALUES (E'CF', E'Středoafrická republika');
INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Súdán');
INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Surinam');
INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Svatá Helena');
INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Svatá Lucie');
INSERT INTO "list" ("id", "value") VALUES (E'BL', E'Svatý Bartoloměj');
INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Svatý Kryštof a Nevis');
INSERT INTO "list" ("id", "value") VALUES (E'MF', E'Svatý Martin (Francie)');
INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Svatý Martin (Nizozemsko)');
INSERT INTO "list" ("id", "value") VALUES (E'ST', E'Svatý Tomáš a Princův ostrov');
INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Svatý Vincenc a Grenadiny');
INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Svazijsko');
INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Sýrie');
INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Šalamounovy ostrovy');
INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Španělsko');
INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Špicberky a Jan Mayen');
INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Švédsko');
INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Švýcarsko');
INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Tádžikistán');
INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzanie');
INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Thajsko');
INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Tchaj-wan');
INSERT INTO "list" ("id", "value") VALUES (E'TG', E'Togo');
INSERT INTO "list" ("id", "value") VALUES (E'TK', E'Tokelau');
INSERT INTO "list" ("id", "value") VALUES (E'TO', E'Tonga');
INSERT INTO "list" ("id", "value") VALUES (E'TT', E'Trinidad a Tobago');
INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tunisko');
INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Turecko');
INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turkmenistán');
INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Turks a Caicos');
INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalu');
INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Uganda');
INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ukrajina');
INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Uruguay');
INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Uzbekistán');
INSERT INTO "list" ("id", "value") VALUES (E'CX', E'Vánoční ostrov');
INSERT INTO "list" ("id", "value") VALUES (E'VU', E'Vanuatu');
INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Vatikán');
INSERT INTO "list" ("id", "value") VALUES (E'VE', E'Venezuela');
INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Vietnam');
INSERT INTO "list" ("id", "value") VALUES (E'TL', E'Východní Timor');
INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Wallis a Futuna');
INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zambie');
INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Západní Sahara');
INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbabwe');
