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