IF OBJECT_ID('countries', 'U') IS NOT NULL DROP TABLE [countries];

CREATE TABLE [countries] (
    [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_countries] PRIMARY KEY ([id])
);

INSERT INTO [countries] ([id], [alpha_2], [alpha_3], [name]) VALUES
(4,'af','afg',N'Afganistanas'),
(8,'al','alb',N'Albanija'),
(12,'dz','dza',N'Alžyras'),
(20,'ad','and',N'Andora'),
(24,'ao','ago',N'Angola'),
(28,'ag','atg',N'Antigva ir Barbuda'),
(32,'ar','arg',N'Argentina'),
(51,'am','arm',N'Armėnija'),
(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'),
(64,'bt','btn',N'Butanas'),
(68,'bo','bol',N'Bolivija'),
(70,'ba','bih',N'Bosnija ir Hercegovina'),
(72,'bw','bwa',N'Botsvana'),
(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'),
(242,'fj','fji',N'Fidžis'),
(266,'ga','gab',N'Gabonas'),
(270,'gm','gmb',N'Gambija'),
(288,'gh','gha',N'Gana'),
(300,'gr','grc',N'Graikija'),
(308,'gd','grd',N'Grenada'),
(268,'ge','geo',N'Gruzija'),
(320,'gt','gtm',N'Gvatemala'),
(324,'gn','gin',N'Gvinėja'),
(624,'gw','gnb',N'Bisau Gvinėja'),
(328,'gy','guy',N'Gajana'),
(332,'ht','hti',N'Haitis'),
(340,'hn','hnd',N'Hondūras'),
(348,'hu','hun',N'Vengrija'),
(352,'is','isl',N'Islandija'),
(356,'in','ind',N'Indija'),
(360,'id','idn',N'Indonezija'),
(364,'ir','irn',N'Iranas'),
(368,'iq','irq',N'Irakas'),
(372,'ie','irl',N'Airija'),
(376,'il','isr',N'Izraelis'),
(380,'it','ita',N'Italija'),
(388,'jm','jam',N'Jamaika'),
(392,'jp','jpn',N'Japonija'),
(400,'jo','jor',N'Jordanija'),
(116,'kh','khm',N'Kambodža'),
(120,'cm','cmr',N'Kamerūnas'),
(124,'ca','can',N'Kanada'),
(156,'cn','chn',N'Kinija'),
(170,'co','col',N'Kolumbija'),
(174,'km','com',N'Komorai'),
(178,'cg','cog',N'Kongo Respublika'),
(180,'cd','cod',N'Kongo Demokratinė Respublika'),
(188,'cr','cri',N'Kosta Rika'),
(191,'hr','hrv',N'Kroatija'),
(192,'cu','cub',N'Kuba'),
(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'),
(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'),
(478,'mr','mrt',N'Mauritanija'),
(480,'mu','mus',N'Mauricijus'),
(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'),
(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'),
(554,'nz','nzl',N'Naujoji Zelandija'),
(558,'ni','nic',N'Nikaragva'),
(562,'ne','ner',N'Nigeris'),
(566,'ng','nga',N'Nigerija'),
(578,'no','nor',N'Norvegija'),
(512,'om','omn',N'Omanas'),
(586,'pk','pak',N'Pakistanas'),
(585,'pw','plw',N'Palau'),
(591,'pa','pan',N'Panama'),
(250,'fr','fra',N'Prancūzija'),
(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'),
(616,'pl','pol',N'Lenkija'),
(620,'pt','prt',N'Portugalija'),
(634,'qa','qat',N'Kataras'),
(642,'ro','rou',N'Rumunija'),
(643,'ru','rus',N'Rusija'),
(646,'rw','rwa',N'Ruanda'),
(222,'sv','slv',N'Salvadoras'),
(659,'kn','kna',N'Sent Kitsas ir Nevis'),
(662,'lc','lca',N'Sent Lusija'),
(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'),
(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'),
(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'),
(748,'sz','swz',N'Svazilendas'),
(752,'se','swe',N'Švedija'),
(756,'ch','che',N'Šveicarija'),
(760,'sy','syr',N'Sirija'),
(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'),
(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'),
(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'),
(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'),
(887,'ye','yem',N'Jemenas'),
(894,'zm','zmb',N'Zambija'),
(716,'zw','zwe',N'Zimbabvė'),
(132,'cv','cpv',N'Žaliasis Kyšulys')