Skip to content

Instantly share code, notes, and snippets.

@kirs
Created August 14, 2023 04:39
Show Gist options
  • Save kirs/a6631cd342890c5962e91d4ec74e18fe to your computer and use it in GitHub Desktop.
Save kirs/a6631cd342890c5962e91d4ec74e18fe to your computer and use it in GitHub Desktop.
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE list (id VARCHAR(64) NOT NULL, value VARCHAR(64) NOT NULL, PRIMARY KEY(id));
INSERT INTO list VALUES('AF','Afghanistan');
INSERT INTO list VALUES('AL','Albania');
INSERT INTO list VALUES('DZ','Algerie');
INSERT INTO list VALUES('AS','Amerikansk Samoa');
INSERT INTO list VALUES('AD','Andorra');
INSERT INTO list VALUES('AO','Angola');
INSERT INTO list VALUES('AI','Anguilla');
INSERT INTO list VALUES('AQ','Antarktis');
INSERT INTO list VALUES('AG','Antigua og Barbuda');
INSERT INTO list VALUES('AR','Argentina');
INSERT INTO list VALUES('AM','Armenia');
INSERT INTO list VALUES('AW','Aruba');
INSERT INTO list VALUES('AZ','Aserbajdsjan');
INSERT INTO list VALUES('AU','Australia');
INSERT INTO list VALUES('BS','Bahamas');
INSERT INTO list VALUES('BH','Bahrain');
INSERT INTO list VALUES('BD','Bangladesh');
INSERT INTO list VALUES('BB','Barbados');
INSERT INTO list VALUES('BE','Belgia');
INSERT INTO list VALUES('BZ','Belize');
INSERT INTO list VALUES('BJ','Benin');
INSERT INTO list VALUES('BM','Bermuda');
INSERT INTO list VALUES('BT','Bhutan');
INSERT INTO list VALUES('BO','Bolivia');
INSERT INTO list VALUES('BA','Bosnia-Hercegovina');
INSERT INTO list VALUES('BW','Botswana');
INSERT INTO list VALUES('BV','Bouvetøya');
INSERT INTO list VALUES('BR','Brasil');
INSERT INTO list VALUES('BN','Brunei');
INSERT INTO list VALUES('BG','Bulgaria');
INSERT INTO list VALUES('BF','Burkina Faso');
INSERT INTO list VALUES('BI','Burundi');
INSERT INTO list VALUES('CA','Canada');
INSERT INTO list VALUES('KY','Caymanøyene');
INSERT INTO list VALUES('CL','Chile');
INSERT INTO list VALUES('CX','Christmasøya');
INSERT INTO list VALUES('CO','Colombia');
INSERT INTO list VALUES('CK','Cookøyene');
INSERT INTO list VALUES('CR','Costa Rica');
INSERT INTO list VALUES('CU','Cuba');
INSERT INTO list VALUES('CW','Curaçao');
INSERT INTO list VALUES('DK','Danmark');
INSERT INTO list VALUES('VI','De amerikanske jomfruøyene');
INSERT INTO list VALUES('VG','De britiske jomfruøyene');
INSERT INTO list VALUES('AE','De forente arabiske emirater');
INSERT INTO list VALUES('TF','De franske sørterritorier');
INSERT INTO list VALUES('DO','Den dominikanske republikk');
INSERT INTO list VALUES('CF','Den sentralafrikanske republikk');
INSERT INTO list VALUES('IO','Det britiske territoriet i Indiahavet');
INSERT INTO list VALUES('PS','Det palestinske området');
INSERT INTO list VALUES('DJ','Djibouti');
INSERT INTO list VALUES('DM','Dominica');
INSERT INTO list VALUES('EC','Ecuador');
INSERT INTO list VALUES('EG','Egypt');
INSERT INTO list VALUES('GQ','Ekvatorial-Guinea');
INSERT INTO list VALUES('SV','El Salvador');
INSERT INTO list VALUES('CI','Elfenbenskysten');
INSERT INTO list VALUES('ER','Eritrea');
INSERT INTO list VALUES('EE','Estland');
INSERT INTO list VALUES('SZ','Eswatini');
INSERT INTO list VALUES('ET','Etiopia');
INSERT INTO list VALUES('FK','Falklandsøyene');
INSERT INTO list VALUES('FJ','Fiji');
INSERT INTO list VALUES('PH','Filippinene');
INSERT INTO list VALUES('FI','Finland');
INSERT INTO list VALUES('FR','Frankrike');
INSERT INTO list VALUES('GF','Fransk Guyana');
INSERT INTO list VALUES('PF','Fransk Polynesia');
INSERT INTO list VALUES('FO','Færøyene');
INSERT INTO list VALUES('GA','Gabon');
INSERT INTO list VALUES('GM','Gambia');
INSERT INTO list VALUES('GE','Georgia');
INSERT INTO list VALUES('GH','Ghana');
INSERT INTO list VALUES('GI','Gibraltar');
INSERT INTO list VALUES('GD','Grenada');
INSERT INTO list VALUES('GL','Grønland');
INSERT INTO list VALUES('GP','Guadeloupe');
INSERT INTO list VALUES('GU','Guam');
INSERT INTO list VALUES('GT','Guatemala');
INSERT INTO list VALUES('GG','Guernsey');
INSERT INTO list VALUES('GN','Guinea');
INSERT INTO list VALUES('GW','Guinea-Bissau');
INSERT INTO list VALUES('GY','Guyana');
INSERT INTO list VALUES('HT','Haiti');
INSERT INTO list VALUES('HM','Heard- og McDonaldøyene');
INSERT INTO list VALUES('GR','Hellas');
INSERT INTO list VALUES('HN','Honduras');
INSERT INTO list VALUES('HK','Hongkong S.A.R. Kina');
INSERT INTO list VALUES('BY','Hviterussland');
INSERT INTO list VALUES('IN','India');
INSERT INTO list VALUES('ID','Indonesia');
INSERT INTO list VALUES('IQ','Irak');
INSERT INTO list VALUES('IR','Iran');
INSERT INTO list VALUES('IE','Irland');
INSERT INTO list VALUES('IS','Island');
INSERT INTO list VALUES('IL','Israel');
INSERT INTO list VALUES('IT','Italia');
INSERT INTO list VALUES('JM','Jamaica');
INSERT INTO list VALUES('JP','Japan');
INSERT INTO list VALUES('YE','Jemen');
INSERT INTO list VALUES('JE','Jersey');
INSERT INTO list VALUES('JO','Jordan');
INSERT INTO list VALUES('KH','Kambodsja');
INSERT INTO list VALUES('CM','Kamerun');
INSERT INTO list VALUES('CV','Kapp Verde');
INSERT INTO list VALUES('BQ','Karibisk Nederland');
INSERT INTO list VALUES('KZ','Kasakhstan');
INSERT INTO list VALUES('KE','Kenya');
INSERT INTO list VALUES('CN','Kina');
INSERT INTO list VALUES('KG','Kirgisistan');
INSERT INTO list VALUES('KI','Kiribati');
INSERT INTO list VALUES('CC','Kokosøyene');
INSERT INTO list VALUES('KM','Komorene');
INSERT INTO list VALUES('CG','Kongo-Brazzaville');
INSERT INTO list VALUES('CD','Kongo-Kinshasa');
INSERT INTO list VALUES('HR','Kroatia');
INSERT INTO list VALUES('KW','Kuwait');
INSERT INTO list VALUES('CY','Kypros');
INSERT INTO list VALUES('LA','Laos');
INSERT INTO list VALUES('LV','Latvia');
INSERT INTO list VALUES('LS','Lesotho');
INSERT INTO list VALUES('LB','Libanon');
INSERT INTO list VALUES('LR','Liberia');
INSERT INTO list VALUES('LY','Libya');
INSERT INTO list VALUES('LI','Liechtenstein');
INSERT INTO list VALUES('LT','Litauen');
INSERT INTO list VALUES('LU','Luxemburg');
INSERT INTO list VALUES('MO','Macao S.A.R. Kina');
INSERT INTO list VALUES('MG','Madagaskar');
INSERT INTO list VALUES('MW','Malawi');
INSERT INTO list VALUES('MY','Malaysia');
INSERT INTO list VALUES('MV','Maldivene');
INSERT INTO list VALUES('ML','Mali');
INSERT INTO list VALUES('MT','Malta');
INSERT INTO list VALUES('IM','Man');
INSERT INTO list VALUES('MA','Marokko');
INSERT INTO list VALUES('MH','Marshalløyene');
INSERT INTO list VALUES('MQ','Martinique');
INSERT INTO list VALUES('MR','Mauritania');
INSERT INTO list VALUES('MU','Mauritius');
INSERT INTO list VALUES('YT','Mayotte');
INSERT INTO list VALUES('MX','Mexico');
INSERT INTO list VALUES('FM','Mikronesiaføderasjonen');
INSERT INTO list VALUES('MD','Moldova');
INSERT INTO list VALUES('MC','Monaco');
INSERT INTO list VALUES('MN','Mongolia');
INSERT INTO list VALUES('ME','Montenegro');
INSERT INTO list VALUES('MS','Montserrat');
INSERT INTO list VALUES('MZ','Mosambik');
INSERT INTO list VALUES('MM','Myanmar (Burma)');
INSERT INTO list VALUES('NA','Namibia');
INSERT INTO list VALUES('NR','Nauru');
INSERT INTO list VALUES('NL','Nederland');
INSERT INTO list VALUES('NP','Nepal');
INSERT INTO list VALUES('NZ','New Zealand');
INSERT INTO list VALUES('NI','Nicaragua');
INSERT INTO list VALUES('NE','Niger');
INSERT INTO list VALUES('NG','Nigeria');
INSERT INTO list VALUES('NU','Niue');
INSERT INTO list VALUES('KP','Nord-Korea');
INSERT INTO list VALUES('MK','Nord-Makedonia');
INSERT INTO list VALUES('MP','Nord-Marianene');
INSERT INTO list VALUES('NF','Norfolkøya');
INSERT INTO list VALUES('NO','Norge');
INSERT INTO list VALUES('NC','Ny-Caledonia');
INSERT INTO list VALUES('OM','Oman');
INSERT INTO list VALUES('PK','Pakistan');
INSERT INTO list VALUES('PW','Palau');
INSERT INTO list VALUES('PA','Panama');
INSERT INTO list VALUES('PG','Papua Ny-Guinea');
INSERT INTO list VALUES('PY','Paraguay');
INSERT INTO list VALUES('PE','Peru');
INSERT INTO list VALUES('PN','Pitcairnøyene');
INSERT INTO list VALUES('PL','Polen');
INSERT INTO list VALUES('PT','Portugal');
INSERT INTO list VALUES('PR','Puerto Rico');
INSERT INTO list VALUES('QA','Qatar');
INSERT INTO list VALUES('RE','Réunion');
INSERT INTO list VALUES('RO','Romania');
INSERT INTO list VALUES('RU','Russland');
INSERT INTO list VALUES('RW','Rwanda');
INSERT INTO list VALUES('KN','Saint Kitts og Nevis');
INSERT INTO list VALUES('BL','Saint-Barthélemy');
INSERT INTO list VALUES('MF','Saint-Martin');
INSERT INTO list VALUES('PM','Saint-Pierre-et-Miquelon');
INSERT INTO list VALUES('SB','Salomonøyene');
INSERT INTO list VALUES('WS','Samoa');
INSERT INTO list VALUES('SM','San Marino');
INSERT INTO list VALUES('ST','São Tomé og Príncipe');
INSERT INTO list VALUES('SA','Saudi-Arabia');
INSERT INTO list VALUES('SN','Senegal');
INSERT INTO list VALUES('RS','Serbia');
INSERT INTO list VALUES('SC','Seychellene');
INSERT INTO list VALUES('SL','Sierra Leone');
INSERT INTO list VALUES('SG','Singapore');
INSERT INTO list VALUES('SX','Sint Maarten');
INSERT INTO list VALUES('SK','Slovakia');
INSERT INTO list VALUES('SI','Slovenia');
INSERT INTO list VALUES('SO','Somalia');
INSERT INTO list VALUES('ES','Spania');
INSERT INTO list VALUES('LK','Sri Lanka');
INSERT INTO list VALUES('SH','St. Helena');
INSERT INTO list VALUES('LC','St. Lucia');
INSERT INTO list VALUES('VC','St. Vincent og Grenadinene');
INSERT INTO list VALUES('GB','Storbritannia');
INSERT INTO list VALUES('SD','Sudan');
INSERT INTO list VALUES('SR','Surinam');
INSERT INTO list VALUES('SJ','Svalbard og Jan Mayen');
INSERT INTO list VALUES('CH','Sveits');
INSERT INTO list VALUES('SE','Sverige');
INSERT INTO list VALUES('SY','Syria');
INSERT INTO list VALUES('ZA','Sør-Afrika');
INSERT INTO list VALUES('GS','Sør-Georgia og Sør-Sandwichøyene');
INSERT INTO list VALUES('KR','Sør-Korea');
INSERT INTO list VALUES('SS','Sør-Sudan');
INSERT INTO list VALUES('TJ','Tadsjikistan');
INSERT INTO list VALUES('TW','Taiwan');
INSERT INTO list VALUES('TZ','Tanzania');
INSERT INTO list VALUES('TH','Thailand');
INSERT INTO list VALUES('TG','Togo');
INSERT INTO list VALUES('TK','Tokelau');
INSERT INTO list VALUES('TO','Tonga');
INSERT INTO list VALUES('TT','Trinidad og Tobago');
INSERT INTO list VALUES('TD','Tsjad');
INSERT INTO list VALUES('CZ','Tsjekkia');
INSERT INTO list VALUES('TN','Tunisia');
INSERT INTO list VALUES('TM','Turkmenistan');
INSERT INTO list VALUES('TC','Turks- og Caicosøyene');
INSERT INTO list VALUES('TV','Tuvalu');
INSERT INTO list VALUES('TR','Tyrkia');
INSERT INTO list VALUES('DE','Tyskland');
INSERT INTO list VALUES('UG','Uganda');
INSERT INTO list VALUES('UA','Ukraina');
INSERT INTO list VALUES('HU','Ungarn');
INSERT INTO list VALUES('UY','Uruguay');
INSERT INTO list VALUES('US','USA');
INSERT INTO list VALUES('UM','USAs ytre øyer');
INSERT INTO list VALUES('UZ','Usbekistan');
INSERT INTO list VALUES('VU','Vanuatu');
INSERT INTO list VALUES('VA','Vatikanstaten');
INSERT INTO list VALUES('VE','Venezuela');
INSERT INTO list VALUES('EH','Vest-Sahara');
INSERT INTO list VALUES('VN','Vietnam');
INSERT INTO list VALUES('WF','Wallis og Futuna');
INSERT INTO list VALUES('ZM','Zambia');
INSERT INTO list VALUES('ZW','Zimbabwe');
INSERT INTO list VALUES('TL','Øst-Timor');
INSERT INTO list VALUES('AT','Østerrike');
INSERT INTO list VALUES('AX','Åland');
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment