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'Afganistan'),
(248,'ax','ala',N'Ahvenanmaa'),
(528,'nl','nld',N'Alankomaat'),
(535,'bq','bes',N'Alankomaiden Karibia'),
(8,'al','alb',N'Albania'),
(12,'dz','dza',N'Algeria'),
(16,'as','asm',N'Amerikan 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 ja Barbuda'),
(784,'ae','are',N'Arabiemiirikunnat'),
(32,'ar','arg',N'Argentiina'),
(51,'am','arm',N'Armenia'),
(533,'aw','abw',N'Aruba'),
(36,'au','aus',N'Australia'),
(31,'az','aze',N'Azerbaidžan'),
(44,'bs','bhs',N'Bahama'),
(48,'bh','bhr',N'Bahrain'),
(50,'bd','bgd',N'Bangladesh'),
(52,'bb','brb',N'Barbados'),
(56,'be','bel',N'Belgia'),
(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'Bosnia ja Hertsegovina'),
(72,'bw','bwa',N'Botswana'),
(74,'bv','bvt',N'Bouvet’nsaari'),
(76,'br','bra',N'Brasilia'),
(86,'io','iot',N'Brittiläinen Intian valtameren alue'),
(92,'vg','vgb',N'Brittiläiset Neitsytsaaret'),
(96,'bn','brn',N'Brunei'),
(100,'bg','bgr',N'Bulgaria'),
(854,'bf','bfa',N'Burkina Faso'),
(108,'bi','bdi',N'Burundi'),
(136,'ky','cym',N'Caymansaaret'),
(152,'cl','chl',N'Chile'),
(184,'ck','cok',N'Cookinsaaret'),
(188,'cr','cri',N'Costa Rica'),
(531,'cw','cuw',N'Curaçao'),
(262,'dj','dji',N'Djibouti'),
(212,'dm','dma',N'Dominica'),
(214,'do','dom',N'Dominikaaninen tasavalta'),
(218,'ec','ecu',N'Ecuador'),
(818,'eg','egy',N'Egypti'),
(222,'sv','slv',N'El Salvador'),
(232,'er','eri',N'Eritrea'),
(724,'es','esp',N'Espanja'),
(231,'et','eth',N'Etiopia'),
(710,'za','zaf',N'Etelä-Afrikka'),
(239,'gs','sgs',N'Etelä-Georgia ja Eteläiset Sandwichsaaret'),
(728,'ss','ssd',N'Etelä-Sudan'),
(238,'fk','flk',N'Falklandinsaaret'),
(234,'fo','fro',N'Färsaaret'),
(242,'fj','fji',N'Fidži'),
(608,'ph','phl',N'Filippiinit'),
(266,'ga','gab',N'Gabon'),
(270,'gm','gmb',N'Gambia'),
(268,'ge','geo',N'Georgia'),
(288,'gh','gha',N'Ghana'),
(292,'gi','gib',N'Gibraltar'),
(308,'gd','grd',N'Grenada'),
(304,'gl','grl',N'Grönlanti'),
(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 ja McDonaldinsaaret'),
(340,'hn','hnd',N'Honduras'),
(344,'hk','hkg',N'Hongkong'),
(360,'id','idn',N'Indonesia'),
(356,'in','ind',N'Intia'),
(368,'iq','irq',N'Irak'),
(364,'ir','irn',N'Iran'),
(372,'ie','irl',N'Irlanti'),
(352,'is','isl',N'Islanti'),
(376,'il','isr',N'Israel'),
(380,'it','ita',N'Italia'),
(626,'tl','tls',N'Itä-Timor'),
(40,'at','aut',N'Itävalta'),
(388,'jm','jam',N'Jamaika'),
(392,'jp','jpn',N'Japani'),
(887,'ye','yem',N'Jemen'),
(832,'je','jey',N'Jersey'),
(400,'jo','jor',N'Jordania'),
(162,'cx','cxr',N'Joulusaari'),
(116,'kh','khm',N'Kambodža'),
(120,'cm','cmr',N'Kamerun'),
(124,'ca','can',N'Kanada'),
(132,'cv','cpv',N'Kap Verde'),
(398,'kz','kaz',N'Kazakstan'),
(404,'ke','ken',N'Kenia'),
(140,'cf','caf',N'Keski-Afrikan tasavalta'),
(156,'cn','chn',N'Kiina'),
(417,'kg','kgz',N'Kirgisia'),
(296,'ki','kir',N'Kiribati'),
(170,'co','col',N'Kolumbia'),
(174,'km','com',N'Komorit'),
(180,'cd','cod',N'Kongon demokraattinen tasavalta'),
(178,'cg','cog',N'Kongon tasavalta'),
(166,'cc','cck',N'Kookossaaret'),
(408,'kp','prk',N'Korean demokraattinen kansantasavalta'),
(410,'kr','kor',N'Korean tasavalta'),
(300,'gr','grc',N'Kreikka'),
(191,'hr','hrv',N'Kroatia'),
(192,'cu','cub',N'Kuuba'),
(414,'kw','kwt',N'Kuwait'),
(196,'cy','cyp',N'Kypros'),
(418,'la','lao',N'Laos'),
(428,'lv','lva',N'Latvia'),
(426,'ls','lso',N'Lesotho'),
(422,'lb','lbn',N'Libanon'),
(430,'lr','lbr',N'Liberia'),
(434,'ly','lby',N'Libya'),
(438,'li','lie',N'Liechtenstein'),
(440,'lt','ltu',N'Liettua'),
(442,'lu','lux',N'Luxemburg'),
(732,'eh','esh',N'Länsi-Sahara'),
(446,'mo','mac',N'Macao'),
(450,'mg','mdg',N'Madagaskar'),
(454,'mw','mwi',N'Malawi'),
(462,'mv','mdv',N'Malediivit'),
(458,'my','mys',N'Malesia'),
(466,'ml','mli',N'Mali'),
(470,'mt','mlt',N'Malta'),
(833,'im','imn',N'Mansaari'),
(504,'ma','mar',N'Marokko'),
(584,'mh','mhl',N'Marshallinsaaret'),
(474,'mq','mtq',N'Martinique'),
(478,'mr','mrt',N'Mauritania'),
(480,'mu','mus',N'Mauritius'),
(175,'yt','myt',N'Mayotte'),
(484,'mx','mex',N'Meksiko'),
(583,'fm','fsm',N'Mikronesian liittovaltio'),
(498,'md','mda',N'Moldova'),
(492,'mc','mco',N'Monaco'),
(496,'mn','mng',N'Mongolia'),
(499,'me','mne',N'Montenegro'),
(500,'ms','msr',N'Montserrat'),
(508,'mz','moz',N'Mosambik'),
(104,'mm','mmr',N'Myanmar'),
(516,'na','nam',N'Namibia'),
(520,'nr','nru',N'Nauru'),
(524,'np','npl',N'Nepal'),
(558,'ni','nic',N'Nicaragua'),
(562,'ne','ner',N'Niger'),
(566,'ng','nga',N'Nigeria'),
(570,'nu','niu',N'Niue'),
(574,'nf','nfk',N'Norfolkinsaari'),
(578,'no','nor',N'Norja'),
(384,'ci','civ',N'Norsunluurannikko'),
(512,'om','omn',N'Oman'),
(586,'pk','pak',N'Pakistan'),
(585,'pw','plw',N'Palau'),
(275,'ps','pse',N'Palestiina'),
(591,'pa','pan',N'Panama'),
(598,'pg','png',N'Papua-Uusi-Guinea'),
(600,'py','pry',N'Paraguay'),
(604,'pe','per',N'Peru'),
(580,'mp','mnp',N'Pohjois-Mariaanit'),
(612,'pn','pcn',N'Pitcairn'),
(807,'mk','mkd',N'Pohjois-Makedonia'),
(620,'pt','prt',N'Portugali'),
(630,'pr','pri',N'Puerto Rico'),
(616,'pl','pol',N'Puola'),
(226,'gq','gnq',N'Päiväntasaajan Guinea'),
(634,'qa','qat',N'Qatar'),
(250,'fr','fra',N'Ranska'),
(260,'tf','atf',N'Ranskan eteläiset alueet'),
(254,'gf','guf',N'Ranskan Guayana'),
(258,'pf','pyf',N'Ranskan Polynesia'),
(638,'re','reu',N'Réunion'),
(642,'ro','rou',N'Romania'),
(646,'rw','rwa',N'Ruanda'),
(752,'se','swe',N'Ruotsi'),
(652,'bl','blm',N'Saint Barthélemy'),
(654,'sh','shn',N'Saint Helena, Ascension ja Tristan da Cunha'),
(659,'kn','kna',N'Saint Kitts ja Nevis'),
(662,'lc','lca',N'Saint Lucia'),
(663,'mf','maf',N'Saint Martin (Ranska)'),
(666,'pm','spm',N'Saint-Pierre ja Miquelon'),
(670,'vc','vct',N'Saint Vincent ja Grenadiinit'),
(276,'de','deu',N'Saksa'),
(90,'sb','slb',N'Salomonsaaret'),
(894,'zm','zmb',N'Sambia'),
(882,'ws','wsm',N'Samoa'),
(674,'sm','smr',N'San Marino'),
(678,'st','stp',N'São Tomé ja Príncipe'),
(682,'sa','sau',N'Saudi-Arabia'),
(686,'sn','sen',N'Senegal'),
(688,'rs','srb',N'Serbia'),
(690,'sc','syc',N'Seychellit'),
(694,'sl','sle',N'Sierra Leone'),
(702,'sg','sgp',N'Singapore'),
(534,'sx','sxm',N'Sint Maarten (Alankomaat)'),
(703,'sk','svk',N'Slovakia'),
(705,'si','svn',N'Slovenia'),
(706,'so','som',N'Somalia'),
(144,'lk','lka',N'Sri Lanka'),
(729,'sd','sdn',N'Sudan'),
(246,'fi','fin',N'Suomi'),
(740,'sr','sur',N'Suriname'),
(744,'sj','sjm',N'Svalbard ja Jan Mayen'),
(748,'sz','swz',N'Swazimaa'),
(756,'ch','che',N'Sveitsi'),
(760,'sy','syr',N'Syyria'),
(762,'tj','tjk',N'Tadžikistan'),
(158,'tw','twn',N'Taiwan'),
(834,'tz','tza',N'Tansania'),
(208,'dk','dnk',N'Tanska'),
(764,'th','tha',N'Thaimaa'),
(768,'tg','tgo',N'Togo'),
(772,'tk','tkl',N'Tokelau'),
(776,'to','ton',N'Tonga'),
(780,'tt','tto',N'Trinidad ja Tobago'),
(148,'td','tcd',N'Tšad'),
(203,'cz','cze',N'Tšekki'),
(788,'tn','tun',N'Tunisia'),
(792,'tr','tur',N'Turkki'),
(795,'tm','tkm',N'Turkmenistan'),
(796,'tc','tca',N'Turks- ja Caicossaaret'),
(798,'tv','tuv',N'Tuvalu'),
(800,'ug','uga',N'Uganda'),
(804,'ua','ukr',N'Ukraina'),
(348,'hu','hun',N'Unkari'),
(858,'uy','ury',N'Uruguay'),
(540,'nc','ncl',N'Uusi-Kaledonia'),
(554,'nz','nzl',N'Uusi-Seelanti'),
(860,'uz','uzb',N'Uzbekistan'),
(112,'by','blr',N'Valko-Venäjä'),
(548,'vu','vut',N'Vanuatu'),
(336,'va','vat',N'Vatikaanivaltio (Pyhä istuin)'),
(862,'ve','ven',N'Venezuela'),
(643,'ru','rus',N'Venäjä'),
(704,'vn','vnm',N'Vietnam'),
(233,'ee','est',N'Viro'),
(876,'wf','wlf',N'Wallis ja Futunasaaret'),
(826,'gb','gbr',N'Yhdistynyt kuningaskunta'),
(840,'us','usa',N'Yhdysvallat'),
(850,'vi','vir',N'Yhdysvaltain Neitsytsaaret'),
(581,'um','umi',N'Yhdysvaltain pienet erillissaaret'),
(716,'zw','zwe',N'Zimbabwe')