IF OBJECT_ID('world', 'U') IS NOT NULL DROP TABLE [world];

CREATE TABLE [world] (
    [id] INT NOT NULL,
    [alpha_2] CHAR(2) NOT NULL DEFAULT '',
    [alpha_3] CHAR(3) NOT NULL DEFAULT '',
    [name] NVARCHAR(75) NOT NULL DEFAULT '',
    CONSTRAINT [pk_world] PRIMARY KEY ([id])
);

INSERT INTO [world] ([id], [alpha_2], [alpha_3], [name]) VALUES
(4,'af','afg',N'Afghanistan'),
(8,'al','alb',N'Albanien'),
(12,'dz','dza',N'Algeriet'),
(16,'as','asm',N'Amerikansk Samoa'),
(20,'ad','and',N'Andorra'),
(24,'ao','ago',N'Angola'),
(660,'ai','aia',N'Anguilla'),
(10,'aq','ata',N'Antarktis'),
(28,'ag','atg',N'Antigua og Barbuda'),
(32,'ar','arg',N'Argentina'),
(51,'am','arm',N'Armenien'),
(533,'aw','abw',N'Aruba'),
(36,'au','aus',N'Australien'),
(31,'az','aze',N'Aserbajdsjan'),
(44,'bs','bhs',N'Bahamas'),
(48,'bh','bhr',N'Bahrain'),
(50,'bd','bgd',N'Bangladesh'),
(52,'bb','brb',N'Barbados'),
(56,'be','bel',N'Belgien'),
(84,'bz','blz',N'Belize'),
(204,'bj','ben',N'Benin'),
(60,'bm','bmu',N'Bermuda'),
(64,'bt','btn',N'Bhutan'),
(68,'bo','bol',N'Bolivia'),
(70,'ba','bih',N'Bosnien-Hercegovina'),
(72,'bw','bwa',N'Botswana'),
(74,'bv','bvt',N'Bouvetøen'),
(76,'br','bra',N'Brasilien'),
(86,'io','iot',N'Britisk territorium i det indiske ocean'),
(96,'bn','brn',N'Brunei'),
(100,'bg','bgr',N'Bulgarien'),
(854,'bf','bfa',N'Burkina Faso'),
(104,'mm','mmr',N'Myanmar'),
(108,'bi','bdi',N'Burundi'),
(116,'kh','khm',N'Cambodja'),
(120,'cm','cmr',N'Cameroun'),
(124,'ca','can',N'Canada'),
(136,'ky','cym',N'Caymanøerne'),
(140,'cf','caf',N'Centralafrikanske Republik'),
(152,'cl','chl',N'Chile'),
(162,'cx','cxr',N'Juleøen'),
(166,'cc','cck',N'Cocosøerne'),
(170,'co','col',N'Colombia'),
(174,'km','com',N'Comorerne'),
(178,'cg','cog',N'Congo'),
(180,'cd','cod',N'Demokratiske Republik Congo'),
(184,'ck','cok',N'Cookøerne'),
(188,'cr','cri',N'Costa Rica'),
(192,'cu','cub',N'Cuba'),
(531,'cw','cuw',N'Curaçao'),
(196,'cy','cyp',N'Cypern'),
(208,'dk','dnk',N'Danmark'),
(262,'dj','dji',N'Djibouti'),
(212,'dm','dma',N'Dominica'),
(214,'do','dom',N'Dominikanske Republik'),
(218,'ec','ecu',N'Ecuador'),
(818,'eg','egy',N'Egypten'),
(384,'ci','civ',N'Elfenbenskysten'),
(222,'sv','slv',N'El Salvador'),
(232,'er','eri',N'Eritrea'),
(233,'ee','est',N'Estland'),
(231,'et','eth',N'Etiopien'),
(238,'fk','flk',N'Falklandsøerne'),
(242,'fj','fji',N'Fiji'),
(608,'ph','phl',N'Filippinerne'),
(246,'fi','fin',N'Finland'),
(784,'ae','are',N'Forenede Arabiske Emirater'),
(250,'fr','fra',N'Frankrig'),
(254,'gf','guf',N'Fransk Guiana'),
(258,'pf','pyf',N'Fransk Polynesien'),
(260,'tf','atf',N'Franske Sydterritorier'),
(234,'fo','fro',N'Færøerne'),
(266,'ga','gab',N'Gabon'),
(270,'gm','gmb',N'Gambia'),
(268,'ge','geo',N'Georgien'),
(288,'gh','gha',N'Ghana'),
(292,'gi','gib',N'Gibraltar'),
(308,'gd','grd',N'Grenada'),
(300,'gr','grc',N'Grækenland'),
(304,'gl','grl',N'Grønland'),
(312,'gp','glp',N'Guadeloupe'),
(316,'gu','gum',N'Guam'),
(320,'gt','gtm',N'Guatemala'),
(831,'gg','ggy',N'Guernsey'),
(324,'gn','gin',N'Guinea'),
(624,'gw','gnb',N'Guinea-Bissau'),
(328,'gy','guy',N'Guyana'),
(332,'ht','hti',N'Haiti'),
(334,'hm','hmd',N'Heard-øen og McDonald-øerne'),
(340,'hn','hnd',N'Honduras'),
(344,'hk','hkg',N'Hongkong'),
(112,'by','blr',N'Hviderusland'),
(833,'im','imn',N'Isle of Man'),
(356,'in','ind',N'Indien'),
(360,'id','idn',N'Indonesien'),
(368,'iq','irq',N'Irak'),
(364,'ir','irn',N'Iran'),
(372,'ie','irl',N'Irland'),
(352,'is','isl',N'Island'),
(376,'il','isr',N'Israel'),
(380,'it','ita',N'Italien'),
(388,'jm','jam',N'Jamaica'),
(392,'jp','jpn',N'Japan'),
(832,'je','jey',N'Jersey'),
(92,'vg','vgb',N'Britiske Jomfruøer'),
(850,'vi','vir',N'Amerikanske Jomfruøer'),
(400,'jo','jor',N'Jordan'),
(535,'bq','bes',N'Nederlandske Antiller'),
(132,'cv','cpv',N'Kap Verde'),
(398,'kz','kaz',N'Kasakhstan'),
(404,'ke','ken',N'Kenya'),
(156,'cn','chn',N'Kina'),
(417,'kg','kgz',N'Kirgisistan'),
(296,'ki','kir',N'Kiribati'),
(191,'hr','hrv',N'Kroatien'),
(414,'kw','kwt',N'Kuwait'),
(418,'la','lao',N'Laos'),
(428,'lv','lva',N'Letland'),
(426,'ls','lso',N'Lesotho'),
(422,'lb','lbn',N'Libanon'),
(430,'lr','lbr',N'Liberia'),
(434,'ly','lby',N'Libyen'),
(438,'li','lie',N'Liechtenstein'),
(440,'lt','ltu',N'Litauen'),
(442,'lu','lux',N'Luxembourg'),
(446,'mo','mac',N'Macao'),
(450,'mg','mdg',N'Madagaskar'),
(807,'mk','mkd',N'Nordmakedonien'),
(454,'mw','mwi',N'Malawi'),
(458,'my','mys',N'Malaysia'),
(462,'mv','mdv',N'Maldiverne'),
(466,'ml','mli',N'Mali'),
(470,'mt','mlt',N'Malta'),
(504,'ma','mar',N'Marokko'),
(584,'mh','mhl',N'Marshalløerne'),
(474,'mq','mtq',N'Martinique'),
(478,'mr','mrt',N'Mauretanien'),
(480,'mu','mus',N'Mauritius'),
(175,'yt','myt',N'Mayotte'),
(484,'mx','mex',N'Mexico'),
(583,'fm','fsm',N'Mikronesien'),
(498,'md','mda',N'Moldova'),
(492,'mc','mco',N'Monaco'),
(496,'mn','mng',N'Mongoliet'),
(499,'me','mne',N'Montenegro'),
(500,'ms','msr',N'Montserrat'),
(508,'mz','moz',N'Mozambique'),
(516,'na','nam',N'Namibia'),
(520,'nr','nru',N'Nauru'),
(528,'nl','nld',N'Holland'),
(524,'np','npl',N'Nepal'),
(554,'nz','nzl',N'New Zealand'),
(558,'ni','nic',N'Nicaragua'),
(562,'ne','ner',N'Niger'),
(566,'ng','nga',N'Nigeria'),
(570,'nu','niu',N'Niue'),
(408,'kp','prk',N'Nordkorea'),
(580,'mp','mnp',N'Nordmarianerne'),
(574,'nf','nfk',N'Norfolk Island'),
(578,'no','nor',N'Norge'),
(540,'nc','ncl',N'Ny Kaledonien'),
(512,'om','omn',N'Oman'),
(586,'pk','pak',N'Pakistan'),
(585,'pw','plw',N'Palau'),
(275,'ps','pse',N'Palæstina'),
(591,'pa','pan',N'Panama'),
(598,'pg','png',N'Papua Ny Guinea'),
(600,'py','pry',N'Paraguay'),
(604,'pe','per',N'Peru'),
(612,'pn','pcn',N'Pitcairn'),
(616,'pl','pol',N'Polen'),
(620,'pt','prt',N'Portugal'),
(630,'pr','pri',N'Puerto Rico'),
(634,'qa','qat',N'Qatar'),
(638,'re','reu',N'Réunion'),
(642,'ro','rou',N'Rumænien'),
(643,'ru','rus',N'Rusland'),
(646,'rw','rwa',N'Rwanda'),
(654,'sh','shn',N'Sankt Helena'),
(652,'bl','blm',N'Saint Barthélemy'),
(659,'kn','kna',N'Saint Kitts og Nevis'),
(662,'lc','lca',N'Saint Lucia'),
(663,'mf','maf',N'Saint Martin'),
(666,'pm','spm',N'Saint-Pierre og Miquelon'),
(670,'vc','vct',N'Saint Vincent og Grenadinerne'),
(90,'sb','slb',N'Salomonøerne'),
(882,'ws','wsm',N'Samoa'),
(674,'sm','smr',N'San Marino'),
(678,'st','stp',N'São Tomé og Príncipe'),
(682,'sa','sau',N'Saudi-Arabien'),
(686,'sn','sen',N'Senegal'),
(688,'rs','srb',N'Serbien'),
(690,'sc','syc',N'Seychellerne'),
(694,'sl','sle',N'Sierra Leone'),
(702,'sg','sgp',N'Singapore'),
(534,'sx','sxm',N'Sint Maarten'),
(703,'sk','svk',N'Slovakiet'),
(705,'si','svn',N'Slovenien'),
(706,'so','som',N'Somalia'),
(724,'es','esp',N'Spanien'),
(144,'lk','lka',N'Sri Lanka'),
(826,'gb','gbr',N'Storbritannien'),
(729,'sd','sdn',N'Sudan'),
(740,'sr','sur',N'Surinam'),
(744,'sj','sjm',N'Svalbard og Jan Mayen (Norge)'),
(752,'se','swe',N'Sverige'),
(756,'ch','che',N'Schweiz'),
(748,'sz','swz',N'Eswatini'),
(760,'sy','syr',N'Syrien'),
(710,'za','zaf',N'Sydafrika'),
(239,'gs','sgs',N'South Georgia og South Sandwich Islands'),
(410,'kr','kor',N'Sydkorea'),
(728,'ss','ssd',N'Sydsudan'),
(158,'tw','twn',N'Taiwan (Republikken Kina)'),
(762,'tj','tjk',N'Tadsjikistan'),
(834,'tz','tza',N'Tanzania'),
(764,'th','tha',N'Thailand'),
(768,'tg','tgo',N'Togo'),
(772,'tk','tkl',N'Tokelau'),
(776,'to','ton',N'Tonga'),
(780,'tt','tto',N'Trinidad og Tobago'),
(148,'td','tcd',N'Tchad'),
(203,'cz','cze',N'Tjekkiet'),
(788,'tn','tun',N'Tunesien'),
(792,'tr','tur',N'Tyrkiet'),
(795,'tm','tkm',N'Turkmenistan'),
(796,'tc','tca',N'Turks- og Caicosøerne'),
(276,'de','deu',N'Tyskland'),
(798,'tv','tuv',N'Tuvalu'),
(800,'ug','uga',N'Uganda'),
(804,'ua','ukr',N'Ukraine'),
(348,'hu','hun',N'Ungarn'),
(858,'uy','ury',N'Uruguay'),
(840,'us','usa',N'USA'),
(581,'um','umi',N'USA''s ydre småøer'),
(860,'uz','uzb',N'Usbekistan'),
(548,'vu','vut',N'Vanuatu'),
(336,'va','vat',N'Vatikanstaten'),
(862,'ve','ven',N'Venezuela'),
(732,'eh','esh',N'Vestsahara'),
(704,'vn','vnm',N'Vietnam'),
(876,'wf','wlf',N'Wallis og Futuna'),
(887,'ye','yem',N'Yemen'),
(894,'zm','zmb',N'Zambia'),
(716,'zw','zwe',N'Zimbabwe'),
(226,'gq','gnq',N'Ækvatorialguinea'),
(40,'at','aut',N'Østrig'),
(626,'tl','tls',N'Østtimor'),
(248,'ax','ala',N'Ålandsøerne')