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'Afganistanas'),
(248,'ax','ala',N'Alandų salos'),
(8,'al','alb',N'Albanija'),
(12,'dz','dza',N'Alžyras'),
(16,'as','asm',N'Amerikos Samoa'),
(20,'ad','and',N'Andora'),
(24,'ao','ago',N'Angola'),
(660,'ai','aia',N'Angilija'),
(10,'aq','ata',N'Antarktida'),
(28,'ag','atg',N'Antigva ir Barbuda'),
(32,'ar','arg',N'Argentina'),
(51,'am','arm',N'Armėnija'),
(533,'aw','abw',N'Aruba'),
(36,'au','aus',N'Australija'),
(40,'at','aut',N'Austrija'),
(31,'az','aze',N'Azerbaidžanas'),
(44,'bs','bhs',N'Bahamos'),
(48,'bh','bhr',N'Bahreinas'),
(112,'by','blr',N'Baltarusija'),
(50,'bd','bgd',N'Bangladešas'),
(52,'bb','brb',N'Barbadosas'),
(56,'be','bel',N'Belgija'),
(84,'bz','blz',N'Belizas'),
(204,'bj','ben',N'Beninas'),
(60,'bm','bmu',N'Bermuda'),
(64,'bt','btn',N'Butanas'),
(68,'bo','bol',N'Bolivija'),
(535,'bq','bes',N'Boneras, Sint Eustatijus ir Saba (BES salos)'),
(70,'ba','bih',N'Bosnija ir Hercegovina'),
(72,'bw','bwa',N'Botsvana'),
(74,'bv','bvt',N'Buvė sala'),
(76,'br','bra',N'Brazilija'),
(96,'bn','brn',N'Brunėjus'),
(100,'bg','bgr',N'Bulgarija'),
(854,'bf','bfa',N'Burkina Faso'),
(108,'bi','bdi',N'Burundis'),
(140,'cf','caf',N'Centrinės Afrikos Respublika'),
(148,'td','tcd',N'Čadas'),
(152,'cl','chl',N'Čilė'),
(203,'cz','cze',N'Čekija'),
(208,'dk','dnk',N'Danija'),
(384,'ci','civ',N'Dramblio Kaulo Krantas'),
(212,'dm','dma',N'Dominika'),
(214,'do','dom',N'Dominikos Respublika'),
(262,'dj','dji',N'Džibutis'),
(818,'eg','egy',N'Egiptas'),
(218,'ec','ecu',N'Ekvadoras'),
(232,'er','eri',N'Eritrėja'),
(233,'ee','est',N'Estija'),
(231,'et','eth',N'Etiopija'),
(234,'fo','fro',N'Farerų Salos'),
(242,'fj','fji',N'Fidžis'),
(238,'fk','flk',N'Folklando (Malvinų) Salos'),
(266,'ga','gab',N'Gabonas'),
(270,'gm','gmb',N'Gambija'),
(288,'gh','gha',N'Gana'),
(292,'gi','gib',N'Gibraltaras'),
(300,'gr','grc',N'Graikija'),
(304,'gl','grl',N'Grenlandija'),
(308,'gd','grd',N'Grenada'),
(268,'ge','geo',N'Gruzija'),
(312,'gp','glp',N'Gvadelupa'),
(316,'gu','gum',N'Guamas'),
(320,'gt','gtm',N'Gvatemala'),
(831,'gg','ggy',N'Gernsis'),
(324,'gn','gin',N'Gvinėja'),
(624,'gw','gnb',N'Bisau Gvinėja'),
(328,'gy','guy',N'Gajana'),
(332,'ht','hti',N'Haitis'),
(334,'hm','hmd',N'Herdo ir Makdonaldo salos'),
(336,'va','vat',N'Vatikanas'),
(340,'hn','hnd',N'Hondūras'),
(344,'hk','hkg',N'Honkongas'),
(348,'hu','hun',N'Vengrija'),
(352,'is','isl',N'Islandija'),
(356,'in','ind',N'Indija'),
(86,'io','iot',N'Indijos Vandenyno Britų Sritis'),
(360,'id','idn',N'Indonezija'),
(364,'ir','irn',N'Iranas'),
(368,'iq','irq',N'Irakas'),
(372,'ie','irl',N'Airija'),
(833,'im','imn',N'Meno sala'),
(376,'il','isr',N'Izraelis'),
(380,'it','ita',N'Italija'),
(388,'jm','jam',N'Jamaika'),
(392,'jp','jpn',N'Japonija'),
(832,'je','jey',N'Džersis'),
(400,'jo','jor',N'Jordanija'),
(116,'kh','khm',N'Kambodža'),
(120,'cm','cmr',N'Kamerūnas'),
(124,'ca','can',N'Kanada'),
(136,'ky','cym',N'Kaimanų salos'),
(156,'cn','chn',N'Kinija'),
(162,'cx','cxr',N'Kalėdų sala'),
(166,'cc','cck',N'Kokosų (Kilingo) Salos'),
(170,'co','col',N'Kolumbija'),
(174,'km','com',N'Komorai'),
(178,'cg','cog',N'Kongo Respublika'),
(180,'cd','cod',N'Kongo Demokratinė Respublika'),
(184,'ck','cok',N'Kuko Salos'),
(188,'cr','cri',N'Kosta Rika'),
(191,'hr','hrv',N'Kroatija'),
(192,'cu','cub',N'Kuba'),
(531,'cw','cuw',N'Kiurasao'),
(196,'cy','cyp',N'Kipras'),
(398,'kz','kaz',N'Kazachstanas'),
(404,'ke','ken',N'Kenija'),
(296,'ki','kir',N'Kiribatis'),
(408,'kp','prk',N'Šiaurės Korėja'),
(410,'kr','kor',N'Pietų Korėja'),
(414,'kw','kwt',N'Kuveitas'),
(417,'kg','kgz',N'Kirgizija'),
(418,'la','lao',N'Laosas'),
(428,'lv','lva',N'Latvija'),
(422,'lb','lbn',N'Libanas'),
(426,'ls','lso',N'Lesotas'),
(430,'lr','lbr',N'Liberija'),
(434,'ly','lby',N'Libija'),
(438,'li','lie',N'Lichtenšteinas'),
(440,'lt','ltu',N'Lietuva'),
(442,'lu','lux',N'Liuksemburgas'),
(446,'mo','mac',N'Makao'),
(807,'mk','mkd',N'Makedonija'),
(450,'mg','mdg',N'Madagaskaras'),
(454,'mw','mwi',N'Malavis'),
(458,'my','mys',N'Malaizija'),
(462,'mv','mdv',N'Maldyvai'),
(466,'ml','mli',N'Malis'),
(470,'mt','mlt',N'Malta'),
(584,'mh','mhl',N'Maršalo salos'),
(474,'mq','mtq',N'Martinika'),
(478,'mr','mrt',N'Mauritanija'),
(480,'mu','mus',N'Mauricijus'),
(175,'yt','myt',N'Majotas'),
(484,'mx','mex',N'Meksika'),
(583,'fm','fsm',N'Mikronezija'),
(498,'md','mda',N'Moldavija'),
(492,'mc','mco',N'Monakas'),
(496,'mn','mng',N'Mongolija'),
(499,'me','mne',N'Juodkalnija'),
(500,'ms','msr',N'Montseratas'),
(504,'ma','mar',N'Marokas'),
(508,'mz','moz',N'Mozambikas'),
(104,'mm','mmr',N'Mianmaras'),
(516,'na','nam',N'Namibija'),
(520,'nr','nru',N'Nauru'),
(524,'np','npl',N'Nepalas'),
(528,'nl','nld',N'Nyderlandai'),
(540,'nc','ncl',N'Naujoji Kaledonija'),
(554,'nz','nzl',N'Naujoji Zelandija'),
(558,'ni','nic',N'Nikaragva'),
(562,'ne','ner',N'Nigeris'),
(566,'ng','nga',N'Nigerija'),
(570,'nu','niu',N'Niujė'),
(574,'nf','nfk',N'Norfolko sala'),
(580,'mp','mnp',N'Marianos Šiaurinės Salos'),
(578,'no','nor',N'Norvegija'),
(512,'om','omn',N'Omanas'),
(586,'pk','pak',N'Pakistanas'),
(585,'pw','plw',N'Palau'),
(275,'ps','pse',N'Palestina'),
(591,'pa','pan',N'Panama'),
(250,'fr','fra',N'Prancūzija'),
(254,'gf','guf',N'Prancūzijos Gviana'),
(258,'pf','pyf',N'Prancūzijos Polinezija'),
(260,'tf','atf',N'Prancūzijos Pietų Sritys'),
(598,'pg','png',N'Papua Naujoji Gvinėja'),
(600,'py','pry',N'Paragvajus'),
(226,'gq','gnq',N'Pusiaujo Gvinėja'),
(604,'pe','per',N'Peru'),
(608,'ph','phl',N'Filipinai'),
(612,'pn','pcn',N'Pitkernas'),
(616,'pl','pol',N'Lenkija'),
(620,'pt','prt',N'Portugalija'),
(630,'pr','pri',N'Puerto Rikas'),
(634,'qa','qat',N'Kataras'),
(638,'re','reu',N'Reunjonas'),
(642,'ro','rou',N'Rumunija'),
(643,'ru','rus',N'Rusija'),
(646,'rw','rwa',N'Ruanda'),
(222,'sv','slv',N'Salvadoras'),
(652,'bl','blm',N'Šv. Bartolomėjaus sala'),
(654,'sh','shn',N'Šv. Elenos, Dangun Žengimo, Tristanas da Kunja salos'),
(659,'kn','kna',N'Sent Kitsas ir Nevis'),
(662,'lc','lca',N'Sent Lusija'),
(663,'mf','maf',N'San Martenas'),
(666,'pm','spm',N'Sen Pjeras ir Mikelonas'),
(670,'vc','vct',N'Sent Vinsentas ir Grenadinai'),
(882,'ws','wsm',N'Samoa'),
(674,'sm','smr',N'San Marinas'),
(678,'st','stp',N'San Tomė ir Prinsipė'),
(682,'sa','sau',N'Saudo Arabija'),
(686,'sn','sen',N'Senegalas'),
(688,'rs','srb',N'Serbija'),
(690,'sc','syc',N'Seišeliai'),
(694,'sl','sle',N'Siera Leonė'),
(702,'sg','sgp',N'Singapūras'),
(534,'sx','sxm',N'Sint Martenas'),
(246,'fi','fin',N'Suomija'),
(703,'sk','svk',N'Slovakija'),
(705,'si','svn',N'Slovėnija'),
(90,'sb','slb',N'Saliamono Salos'),
(706,'so','som',N'Somalis'),
(710,'za','zaf',N'PAR'),
(239,'gs','sgs',N'Pietų Džordžijos ir Pietų Sandvičo Salos'),
(728,'ss','ssd',N'Pietų Sudanas'),
(724,'es','esp',N'Ispanija'),
(144,'lk','lka',N'Šri Lanka'),
(729,'sd','sdn',N'Sudanas'),
(740,'sr','sur',N'Surinamas'),
(744,'sj','sjm',N'Svalbardo ir Jan Majeno salos'),
(748,'sz','swz',N'Svazilendas'),
(752,'se','swe',N'Švedija'),
(756,'ch','che',N'Šveicarija'),
(760,'sy','syr',N'Sirija'),
(158,'tw','twn',N'Taivanas'),
(762,'tj','tjk',N'Tadžikija'),
(834,'tz','tza',N'Tanzanija'),
(764,'th','tha',N'Tailandas'),
(626,'tl','tls',N'Rytų Timoras'),
(768,'tg','tgo',N'Togas'),
(772,'tk','tkl',N'Tokelau'),
(776,'to','ton',N'Tonga'),
(780,'tt','tto',N'Trinidadas ir Tobagas'),
(788,'tn','tun',N'Tunisas'),
(792,'tr','tur',N'Turkija'),
(795,'tm','tkm',N'Turkmėnija'),
(796,'tc','tca',N'Terksas ir Kaikosas'),
(798,'tv','tuv',N'Tuvalu'),
(800,'ug','uga',N'Uganda'),
(804,'ua','ukr',N'Ukraina'),
(784,'ae','are',N'Jungtiniai Arabų Emyratai'),
(826,'gb','gbr',N'Jungtinė Karalystė'),
(840,'us','usa',N'Jungtinės Valstijos'),
(581,'um','umi',N'JAV užjūrio mažosios salos'),
(858,'uy','ury',N'Urugvajus'),
(860,'uz','uzb',N'Uzbekistanas'),
(548,'vu','vut',N'Vanuatu'),
(862,'ve','ven',N'Venesuela'),
(276,'de','deu',N'Vokietija'),
(704,'vn','vnm',N'Vietnamas'),
(92,'vg','vgb',N'Mergelių Salos (Didžioji Britanija)'),
(850,'vi','vir',N'Mergelių Salos (JAV)'),
(876,'wf','wlf',N'Volisas ir Futūna'),
(732,'eh','esh',N'Vakarų Sahara'),
(887,'ye','yem',N'Jemenas'),
(894,'zm','zmb',N'Zambija'),
(716,'zw','zwe',N'Zimbabvė'),
(132,'cv','cpv',N'Žaliasis Kyšulys')