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'Emirelezhioù Arab Unanet'),
(4,'af','afg',N'Afghanistan'),
(28,'ag','atg',N'Antigua-ha-Barbuda'),
(660,'ai','aia',N'Anguilla'),
(8,'al','alb',N'Albania'),
(51,'am','arm',N'Armenia'),
(24,'ao','ago',N'Angola'),
(10,'aq','ata',N'Antarktika'),
(32,'ar','arg',N'Arc''hantina'),
(16,'as','asm',N'Samoa Amerikan'),
(40,'at','aut',N'Aostria'),
(36,'au','aus',N'Aostralia'),
(533,'aw','abw',N'Aruba'),
(248,'ax','ala',N'Åland'),
(31,'az','aze',N'Azerbaidjan'),
(70,'ba','bih',N'Bosnia-ha-Herzegovina'),
(52,'bb','brb',N'Barbados'),
(50,'bd','bgd',N'Bangladesh'),
(56,'be','bel',N'Belgia'),
(854,'bf','bfa',N'Burkina Faso'),
(100,'bg','bgr',N'Bulgaria'),
(48,'bh','bhr',N'Bahrein'),
(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'Izelvroioù ar C''harib'),
(76,'br','bra',N'Brazil'),
(44,'bs','bhs',N'Bahamas'),
(64,'bt','btn',N'Bhoutan'),
(74,'bv','bvt',N'Enez Bouvet'),
(72,'bw','bwa',N'Botswana'),
(112,'by','blr',N'Belarus'),
(84,'bz','blz',N'Belize'),
(124,'ca','can',N'Kanada'),
(166,'cc','cck',N'Inizi Cocos'),
(180,'cd','cod',N'Kongo (RD)'),
(140,'cf','caf',N'Republik Kreizafrikan'),
(178,'cg','cog',N'Republik Kongo'),
(756,'ch','che',N'Suis'),
(384,'ci','civ',N'Aod an Olifant'),
(184,'ck','cok',N'Inizi Cook'),
(152,'cl','chl',N'Chile'),
(120,'cm','cmr',N'Kameroun'),
(156,'cn','chn',N'Sina'),
(170,'co','col',N'Kolombia'),
(188,'cr','cri',N'Costa Rica'),
(192,'cu','cub',N'Kuba'),
(132,'cv','cpv',N'Kab Glas'),
(531,'cw','cuw',N'Curaçao'),
(162,'cx','cxr',N'Enez Christmas'),
(196,'cy','cyp',N'Republik Kiprenez'),
(203,'cz','cze',N'Tchekia'),
(276,'de','deu',N'Alamagn'),
(262,'dj','dji',N'Djibouti'),
(208,'dk','dnk',N'Danmark'),
(212,'dm','dma',N'Dominika'),
(214,'do','dom',N'Republik Dominikan'),
(12,'dz','dza',N'Aljeria'),
(218,'ec','ecu',N'Ecuador'),
(233,'ee','est',N'Estonia'),
(818,'eg','egy',N'Egipt'),
(732,'eh','esh',N'Sahara ar C''hornôg'),
(232,'er','eri',N'Eritrea'),
(724,'es','esp',N'Spagn'),
(231,'et','eth',N'Etiopia'),
(246,'fi','fin',N'Finland'),
(242,'fj','fji',N'Fidji'),
(238,'fk','flk',N'Inizi Maloù'),
(583,'fm','fsm',N'Mikronezia'),
(234,'fo','fro',N'Faero'),
(250,'fr','fra',N'Frañs'),
(266,'ga','gab',N'Gabon'),
(826,'gb','gbr',N'Rouantelezh-Unanet'),
(308,'gd','grd',N'Grenada'),
(268,'ge','geo',N'Jorjia'),
(254,'gf','guf',N'Gwiana'),
(831,'gg','ggy',N'Gwernenez'),
(288,'gh','gha',N'Ghana'),
(292,'gi','gib',N'Jibraltar'),
(304,'gl','grl',N'Greunland'),
(270,'gm','gmb',N'Gambia'),
(324,'gn','gin',N'Ginea'),
(312,'gp','glp',N'Gwadloup'),
(226,'gq','gnq',N'Ginea ar C''heheder'),
(300,'gr','grc',N'Gres'),
(239,'gs','sgs',N'Georgia ar Su hag Inizi Sandwich ar Su'),
(320,'gt','gtm',N'Guatemala'),
(316,'gu','gum',N'Guam'),
(624,'gw','gnb',N'Ginea-Bissau'),
(328,'gy','guy',N'Guyana'),
(344,'hk','hkg',N'Hong Kong'),
(334,'hm','hmd',N'Inizi Heard ha McDonald'),
(340,'hn','hnd',N'Honduras'),
(191,'hr','hrv',N'Kroatia'),
(332,'ht','hti',N'Haiti'),
(348,'hu','hun',N'Hungaria'),
(360,'id','idn',N'Indonezia'),
(372,'ie','irl',N'Iwerzhon'),
(376,'il','isr',N'Israel'),
(833,'im','imn',N'Manav'),
(356,'in','ind',N'India'),
(86,'io','iot',N'Tiriad Meurvor Indez Breizh-Veur'),
(368,'iq','irq',N'Irak'),
(364,'ir','irn',N'Iran'),
(352,'is','isl',N'Island'),
(380,'it','ita',N'Italia'),
(832,'je','jey',N'Jerzenez'),
(388,'jm','jam',N'Jamaika'),
(400,'jo','jor',N'Jordania'),
(392,'jp','jpn',N'Japan'),
(404,'ke','ken',N'Kenya'),
(417,'kg','kgz',N'Kirgizstan'),
(116,'kh','khm',N'Kambodja'),
(296,'ki','kir',N'Kiribati'),
(174,'km','com',N'Komorez'),
(659,'kn','kna',N'Saint Kitts ha Nevis'),
(408,'kp','prk',N'Korea an Norzh'),
(410,'kr','kor',N'Republik Korea'),
(414,'kw','kwt',N'Koweit'),
(136,'ky','cym',N'Inizi Cayman'),
(398,'kz','kaz',N'Kazakstan'),
(418,'la','lao',N'Laos'),
(422,'lb','lbn',N'Liban'),
(662,'lc','lca',N'Santez-Lusia'),
(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'Lituania'),
(442,'lu','lux',N'Luksembourg'),
(428,'lv','lva',N'Latvia'),
(434,'ly','lby',N'Libia'),
(504,'ma','mar',N'Maroko'),
(492,'mc','mco',N'Monako'),
(498,'md','mda',N'Moldova'),
(499,'me','mne',N'Montenegro'),
(663,'mf','maf',N'Saint-Martin'),
(450,'mg','mdg',N'Madagaskar'),
(584,'mh','mhl',N'Inizi Marshall'),
(807,'mk','mkd',N'Makedonia an Norzh'),
(466,'ml','mli',N'Mali'),
(104,'mm','mmr',N'Myanmar'),
(496,'mn','mng',N'Mongolia'),
(446,'mo','mac',N'Makao'),
(580,'mp','mnp',N'Mariana an Norzh'),
(474,'mq','mtq',N'Martinik'),
(478,'mr','mrt',N'Maouritania'),
(500,'ms','msr',N'Montserrat'),
(470,'mt','mlt',N'Malta'),
(480,'mu','mus',N'Moris'),
(462,'mv','mdv',N'Maldivez'),
(454,'mw','mwi',N'Malawi'),
(484,'mx','mex',N'Mec''hiko'),
(458,'my','mys',N'Malaysia'),
(508,'mz','moz',N'Mozambik'),
(516,'na','nam',N'Namibia'),
(540,'nc','ncl',N'Kaledonia-Nevez'),
(562,'ne','ner',N'Niger'),
(574,'nf','nfk',N'Enez Norfolk'),
(566,'ng','nga',N'Nigeria'),
(558,'ni','nic',N'Nicaragua'),
(528,'nl','nld',N'Izelvroioù'),
(578,'no','nor',N'Norvegia'),
(524,'np','npl',N'Nepal'),
(520,'nr','nru',N'Nauru'),
(570,'nu','niu',N'Niue'),
(554,'nz','nzl',N'Zeland-Nevez'),
(512,'om','omn',N'Oman'),
(591,'pa','pan',N'Panamá'),
(604,'pe','per',N'Perou'),
(258,'pf','pyf',N'Polinezia C''hall'),
(598,'pg','png',N'Papoua Ginea-Nevez'),
(608,'ph','phl',N'Filipinez'),
(586,'pk','pak',N'Pakistan'),
(616,'pl','pol',N'Polonia'),
(666,'pm','spm',N'Sant-Pêr-ha-Mikelon'),
(612,'pn','pcn',N'Inizi Pitcairn'),
(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'Reünion'),
(642,'ro','rou',N'Roumania'),
(688,'rs','srb',N'Serbia'),
(643,'ru','rus',N'Rusia'),
(646,'rw','rwa',N'Rwanda'),
(682,'sa','sau',N'Arabia Saoudat'),
(90,'sb','slb',N'Inizi Salomon'),
(690,'sc','syc',N'Sechelez'),
(729,'sd','sdn',N'Soudan'),
(752,'se','swe',N'Sveden'),
(702,'sg','sgp',N'Singapour'),
(654,'sh','shn',N'Saint Helena, Ascension ha Tristan da Cunha'),
(705,'si','svn',N'Slovenia'),
(744,'sj','sjm',N'Svalbard ha Enez Jan Mayen'),
(703,'sk','svk',N'Slovakia'),
(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'Soudan ar Su'),
(678,'st','stp',N'São Tomé ha Príncipe'),
(222,'sv','slv',N'El Salvador'),
(534,'sx','sxm',N'Sint Maarten'),
(760,'sy','syr',N'Siria'),
(748,'sz','swz',N'Eswatini'),
(796,'tc','tca',N'Inizi Turks ha Caicos'),
(148,'td','tcd',N'Tchad'),
(260,'tf','atf',N'Douaroù Aostral hag Antarktikel Frañs'),
(768,'tg','tgo',N'Togo'),
(764,'th','tha',N'Thailand'),
(762,'tj','tjk',N'Tadjikistan'),
(772,'tk','tkl',N'Tokelau'),
(626,'tl','tls',N'Timor ar Reter'),
(795,'tm','tkm',N'Turkmenistan'),
(788,'tn','tun',N'Tunizia'),
(776,'to','ton',N'Tonga'),
(792,'tr','tur',N'Turkia'),
(780,'tt','tto',N'Trinidad ha 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'Ouganda'),
(581,'um','umi',N'Inizi Minor A-bell Stadoù-Unanet'),
(840,'us','usa',N'Stadoù-Unanet'),
(858,'uy','ury',N'Uruguay'),
(860,'uz','uzb',N'Ouzbekistan'),
(336,'va','vat',N'Vatikan'),
(670,'vc','vct',N'Sant-Visant hag ar Grenadinez'),
(862,'ve','ven',N'Venezuela'),
(92,'vg','vgb',N'Inizi Gwerc''h Breizhveurat'),
(850,'vi','vir',N'Inizi Gwerc''h ar Stadoù-Unanet'),
(704,'vn','vnm',N'Viêt Nam'),
(548,'vu','vut',N'Vanuatu'),
(876,'wf','wlf',N'Wallis ha Futuna'),
(882,'ws','wsm',N'Samoa'),
(887,'ye','yem',N'Yemen'),
(175,'yt','myt',N'Mayotte'),
(710,'za','zaf',N'Suafrika'),
(894,'zm','zmb',N'Zambia'),
(716,'zw','zwe',N'Zimbabwe')