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'),
(248,'ax','ala',N'Åland'),
(8,'al','alb',N'Albanië'),
(12,'dz','dza',N'Algerije'),
(850,'vi','vir',N'Amerikaanse Maagdeneilanden'),
(16,'as','asm',N'Amerikaans-Samoa'),
(20,'ad','and',N'Andorra'),
(24,'ao','ago',N'Angola'),
(660,'ai','aia',N'Anguilla'),
(10,'aq','ata',N'Antarctica'),
(28,'ag','atg',N'Antigua en Barbuda'),
(32,'ar','arg',N'Argentinië'),
(51,'am','arm',N'Armenië'),
(533,'aw','abw',N'Aruba'),
(36,'au','aus',N'Australië'),
(31,'az','aze',N'Azerbeidzjan'),
(44,'bs','bhs',N'Bahama''s'),
(48,'bh','bhr',N'Bahrein'),
(50,'bd','bgd',N'Bangladesh'),
(52,'bb','brb',N'Barbados'),
(56,'be','bel',N'België'),
(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'Bosnië en Herzegovina'),
(72,'bw','bwa',N'Botswana'),
(74,'bv','bvt',N'Bouvet'),
(76,'br','bra',N'Brazilië'),
(92,'vg','vgb',N'Britse Maagdeneilanden'),
(86,'io','iot',N'Brits Indische Oceaanterritorium'),
(96,'bn','brn',N'Brunei'),
(100,'bg','bgr',N'Bulgarije'),
(854,'bf','bfa',N'Burkina Faso'),
(108,'bi','bdi',N'Burundi'),
(116,'kh','khm',N'Cambodja'),
(124,'ca','can',N'Canada'),
(535,'bq','bes',N'Caribisch Nederland'),
(140,'cf','caf',N'Centraal-Afrikaanse Republiek'),
(152,'cl','chl',N'Chili'),
(156,'cn','chn',N'China'),
(162,'cx','cxr',N'Christmaseiland'),
(166,'cc','cck',N'Cocoseilanden'),
(170,'co','col',N'Colombia'),
(174,'km','com',N'Comoren'),
(178,'cg','cog',N'Congo-Brazzaville'),
(180,'cd','cod',N'Congo-Kinshasa'),
(184,'ck','cok',N'Cookeilanden'),
(188,'cr','cri',N'Costa Rica'),
(192,'cu','cub',N'Cuba'),
(531,'cw','cuw',N'Curaçao'),
(196,'cy','cyp',N'Cyprus'),
(208,'dk','dnk',N'Denemarken'),
(262,'dj','dji',N'Djibouti'),
(212,'dm','dma',N'Dominica'),
(214,'do','dom',N'Dominicaanse Republiek'),
(276,'de','deu',N'Duitsland'),
(218,'ec','ecu',N'Ecuador'),
(818,'eg','egy',N'Egypte'),
(222,'sv','slv',N'El Salvador'),
(226,'gq','gnq',N'Equatoriaal-Guinea'),
(232,'er','eri',N'Eritrea'),
(233,'ee','est',N'Estland'),
(231,'et','eth',N'Ethiopië'),
(234,'fo','fro',N'Faeröer'),
(238,'fk','flk',N'Falklandeilanden'),
(242,'fj','fji',N'Fiji'),
(608,'ph','phl',N'Filipijnen'),
(246,'fi','fin',N'Finland'),
(250,'fr','fra',N'Frankrijk'),
(260,'tf','atf',N'Franse Zuidelijke Gebieden'),
(254,'gf','guf',N'Frans-Guyana'),
(258,'pf','pyf',N'Frans-Polynesië'),
(266,'ga','gab',N'Gabon'),
(270,'gm','gmb',N'Gambia'),
(268,'ge','geo',N'Georgië'),
(288,'gh','gha',N'Ghana'),
(292,'gi','gib',N'Gibraltar'),
(308,'gd','grd',N'Grenada'),
(300,'gr','grc',N'Griekenland'),
(304,'gl','grl',N'Groenland'),
(312,'gp','glp',N'Guadeloupe'),
(316,'gu','gum',N'Guam'),
(320,'gt','gtm',N'Guatemala'),
(831,'gg','ggy',N'Guernsey'),
(324,'gn','gin',N'Guinee'),
(624,'gw','gnb',N'Guinee-Bissau'),
(328,'gy','guy',N'Guyana'),
(332,'ht','hti',N'Haïti'),
(334,'hm','hmd',N'Heard en McDonaldeilanden'),
(340,'hn','hnd',N'Honduras'),
(348,'hu','hun',N'Hongarije'),
(344,'hk','hkg',N'Hongkong'),
(372,'ie','irl',N'Ierland'),
(352,'is','isl',N'IJsland'),
(356,'in','ind',N'India'),
(360,'id','idn',N'Indonesië'),
(368,'iq','irq',N'Irak'),
(364,'ir','irn',N'Iran'),
(376,'il','isr',N'Israël'),
(380,'it','ita',N'Italië'),
(384,'ci','civ',N'Ivoorkust'),
(388,'jm','jam',N'Jamaica'),
(392,'jp','jpn',N'Japan'),
(887,'ye','yem',N'Jemen'),
(832,'je','jey',N'Jersey'),
(400,'jo','jor',N'Jordanië'),
(136,'ky','cym',N'Kaaimaneilanden'),
(132,'cv','cpv',N'Kaapverdië'),
(120,'cm','cmr',N'Kameroen'),
(398,'kz','kaz',N'Kazachstan'),
(404,'ke','ken',N'Kenia'),
(417,'kg','kgz',N'Kirgizië'),
(296,'ki','kir',N'Kiribati'),
(581,'um','umi',N'Kleine afgelegen eilanden van de Verenigde Staten'),
(414,'kw','kwt',N'Koeweit'),
(191,'hr','hrv',N'Kroatië'),
(418,'la','lao',N'Laos'),
(426,'ls','lso',N'Lesotho'),
(428,'lv','lva',N'Letland'),
(422,'lb','lbn',N'Libanon'),
(430,'lr','lbr',N'Liberia'),
(434,'ly','lby',N'Libië'),
(438,'li','lie',N'Liechtenstein'),
(440,'lt','ltu',N'Litouwen'),
(442,'lu','lux',N'Luxemburg'),
(446,'mo','mac',N'Macau'),
(450,'mg','mdg',N'Madagaskar'),
(454,'mw','mwi',N'Malawi'),
(462,'mv','mdv',N'Malediven'),
(458,'my','mys',N'Maleisië'),
(466,'ml','mli',N'Mali'),
(470,'mt','mlt',N'Malta'),
(833,'im','imn',N'Man'),
(504,'ma','mar',N'Marokko'),
(584,'mh','mhl',N'Marshalleilanden'),
(474,'mq','mtq',N'Martinique'),
(478,'mr','mrt',N'Mauritanië'),
(480,'mu','mus',N'Mauritius'),
(175,'yt','myt',N'Mayotte'),
(484,'mx','mex',N'Mexico'),
(583,'fm','fsm',N'Micronesië'),
(498,'md','mda',N'Moldavië'),
(492,'mc','mco',N'Monaco'),
(496,'mn','mng',N'Mongolië'),
(499,'me','mne',N'Montenegro'),
(500,'ms','msr',N'Montserrat'),
(508,'mz','moz',N'Mozambique'),
(104,'mm','mmr',N'Myanmar'),
(516,'na','nam',N'Namibië'),
(520,'nr','nru',N'Nauru'),
(528,'nl','nld',N'Nederland'),
(524,'np','npl',N'Nepal'),
(558,'ni','nic',N'Nicaragua'),
(540,'nc','ncl',N'Nieuw-Caledonië'),
(554,'nz','nzl',N'Nieuw-Zeeland'),
(562,'ne','ner',N'Niger'),
(566,'ng','nga',N'Nigeria'),
(570,'nu','niu',N'Niue'),
(580,'mp','mnp',N'Noordelijke Marianen'),
(408,'kp','prk',N'Noord-Korea'),
(807,'mk','mkd',N'Noord-Macedonië'),
(578,'no','nor',N'Noorwegen'),
(574,'nf','nfk',N'Norfolk'),
(800,'ug','uga',N'Oeganda'),
(804,'ua','ukr',N'Oekraïne'),
(860,'uz','uzb',N'Oezbekistan'),
(512,'om','omn',N'Oman'),
(40,'at','aut',N'Oostenrijk'),
(626,'tl','tls',N'Oost-Timor'),
(586,'pk','pak',N'Pakistan'),
(585,'pw','plw',N'Palau'),
(275,'ps','pse',N'Palestina'),
(591,'pa','pan',N'Panama'),
(598,'pg','png',N'Papoea-Nieuw-Guinea'),
(600,'py','pry',N'Paraguay'),
(604,'pe','per',N'Peru'),
(612,'pn','pcn',N'Pitcairneilanden'),
(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'Roemenië'),
(643,'ru','rus',N'Rusland'),
(646,'rw','rwa',N'Rwanda'),
(652,'bl','blm',N'Saint-Barthélemy'),
(659,'kn','kna',N'Saint Kitts en Nevis'),
(662,'lc','lca',N'Saint Lucia'),
(666,'pm','spm',N'Saint-Pierre en Miquelon'),
(670,'vc','vct',N'Saint Vincent en de Grenadines'),
(90,'sb','slb',N'Salomonseilanden'),
(882,'ws','wsm',N'Samoa'),
(674,'sm','smr',N'San Marino'),
(682,'sa','sau',N'Saoedi-Arabië'),
(678,'st','stp',N'Sao Tomé en Principe'),
(686,'sn','sen',N'Senegal'),
(688,'rs','srb',N'Servië'),
(690,'sc','syc',N'Seychellen'),
(694,'sl','sle',N'Sierra Leone'),
(702,'sg','sgp',N'Singapore'),
(654,'sh','shn',N'Sint-Helena, Ascension en Tristan da Cunha'),
(663,'mf','maf',N'Saint-Martin'),
(534,'sx','sxm',N'Sint Maarten'),
(705,'si','svn',N'Slovenië'),
(703,'sk','svk',N'Slowakije'),
(729,'sd','sdn',N'Soedan'),
(706,'so','som',N'Somalië'),
(724,'es','esp',N'Spanje'),
(744,'sj','sjm',N'Spitsbergen en Jan Mayen'),
(144,'lk','lka',N'Sri Lanka'),
(740,'sr','sur',N'Suriname'),
(748,'sz','swz',N'Swaziland'),
(760,'sy','syr',N'Syrië'),
(762,'tj','tjk',N'Tadzjikistan'),
(158,'tw','twn',N'Taiwan'),
(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 en Tobago'),
(148,'td','tcd',N'Tsjaad'),
(203,'cz','cze',N'Tsjechië'),
(788,'tn','tun',N'Tunesië'),
(792,'tr','tur',N'Turkije'),
(795,'tm','tkm',N'Turkmenistan'),
(796,'tc','tca',N'Turks- en Caicoseilanden'),
(798,'tv','tuv',N'Tuvalu'),
(858,'uy','ury',N'Uruguay'),
(548,'vu','vut',N'Vanuatu'),
(336,'va','vat',N'Vaticaanstad'),
(862,'ve','ven',N'Venezuela'),
(784,'ae','are',N'Verenigde Arabische Emiraten'),
(840,'us','usa',N'Verenigde Staten'),
(826,'gb','gbr',N'Verenigd Koninkrijk'),
(704,'vn','vnm',N'Vietnam'),
(876,'wf','wlf',N'Wallis en Futuna'),
(732,'eh','esh',N'Westelijke Sahara/SADR'),
(112,'by','blr',N'Wit-Rusland'),
(894,'zm','zmb',N'Zambia'),
(716,'zw','zwe',N'Zimbabwe'),
(710,'za','zaf',N'Zuid-Afrika'),
(239,'gs','sgs',N'Zuid-Georgia en de Zuidelijke Sandwicheilanden'),
(410,'kr','kor',N'Zuid-Korea'),
(728,'ss','ssd',N'Zuid-Soedan'),
(752,'se','swe',N'Zweden'),
(756,'ch','che',N'Zwitserland')