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'Afganistan'),
(140,'cf','caf',N'Afrika Erdiko Errepublika'),
(8,'al','alb',N'Albania'),
(276,'de','deu',N'Alemania'),
(12,'dz','dza',N'Aljeria'),
(20,'ad','and',N'Andorra'),
(24,'ao','ago',N'Angola'),
(784,'ae','are',N'Arabiar Emirerri Batuak'),
(28,'ag','atg',N'Antigua eta Barbuda'),
(32,'ar','arg',N'Argentina'),
(51,'am','arm',N'Armenia'),
(36,'au','aus',N'Australia'),
(40,'at','aut',N'Austria'),
(31,'az','aze',N'Azerbaijan'),
(44,'bs','bhs',N'Bahamak'),
(50,'bd','bgd',N'Bangladesh'),
(52,'bb','brb',N'Barbados'),
(48,'bh','bhr',N'Bahrain'),
(56,'be','bel',N'Belgika'),
(84,'bz','blz',N'Belize'),
(204,'bj','ben',N'Benin'),
(112,'by','blr',N'Bielorrusia'),
(384,'ci','civ',N'Boli Kosta'),
(68,'bo','bol',N'Bolivia'),
(70,'ba','bih',N'Bosnia-Herzegovina'),
(72,'bw','bwa',N'Botswana'),
(76,'br','bra',N'Brasil'),
(96,'bn','brn',N'Brunei'),
(100,'bg','bgr',N'Bulgaria'),
(854,'bf','bfa',N'Burkina Faso'),
(108,'bi','bdi',N'Burundi'),
(64,'bt','btn',N'Bhutan'),
(208,'dk','dnk',N'Danimarka'),
(262,'dj','dji',N'Djibuti'),
(212,'dm','dma',N'Dominika'),
(214,'do','dom',N'Dominikar Errepublika'),
(818,'eg','egy',N'Egipto'),
(626,'tl','tls',N'Ekialdeko Timor'),
(218,'ec','ecu',N'Ekuador'),
(226,'gq','gnq',N'Ekuatore Ginea'),
(232,'er','eri',N'Eritrea'),
(826,'gb','gbr',N'Erresuma Batua'),
(642,'ro','rou',N'Errumania'),
(643,'ru','rus',N'Errusia'),
(703,'sk','svk',N'Eslovakia'),
(705,'si','svn',N'Eslovenia'),
(724,'es','esp',N'Espainia'),
(840,'us','usa',N'AEB'),
(233,'ee','est',N'Estonia'),
(231,'et','eth',N'Etiopia'),
(242,'fj','fji',N'Fiji'),
(608,'ph','phl',N'Filipinak'),
(246,'fi','fin',N'Finlandia'),
(250,'fr','fra',N'Frantzia'),
(266,'ga','gab',N'Gabon'),
(270,'gm','gmb',N'Gambia'),
(268,'ge','geo',N'Georgia'),
(288,'gh','gha',N'Ghana'),
(324,'gn','gin',N'Ginea'),
(624,'gw','gnb',N'Ginea-Bissau'),
(308,'gd','grd',N'Grenada'),
(300,'gr','grc',N'Grezia'),
(320,'gt','gtm',N'Guatemala'),
(328,'gy','guy',N'Guyana'),
(332,'ht','hti',N'Haiti'),
(710,'za','zaf',N'Hegoafrika'),
(410,'kr','kor',N'Hego Korea'),
(728,'ss','ssd',N'Hego Sudan'),
(528,'nl','nld',N'Herbehereak'),
(340,'hn','hnd',N'Honduras'),
(348,'hu','hun',N'Hungaria'),
(356,'in','ind',N'India'),
(360,'id','idn',N'Indonesia'),
(408,'kp','prk',N'Ipar Korea'),
(368,'iq','irq',N'Irak'),
(364,'ir','irn',N'Iran'),
(372,'ie','irl',N'Irlandako Errepublika'),
(352,'is','isl',N'Islandia'),
(376,'il','isr',N'Israel'),
(380,'it','ita',N'Italia'),
(388,'jm','jam',N'Jamaika'),
(392,'jp','jpn',N'Japonia'),
(400,'jo','jor',N'Jordania'),
(132,'cv','cpv',N'Cabo Verde'),
(120,'cm','cmr',N'Kamerun'),
(124,'ca','can',N'Kanada'),
(116,'kh','khm',N'Kanbodia'),
(398,'kz','kaz',N'Kazakhstan'),
(404,'ke','ken',N'Kenya'),
(417,'kg','kgz',N'Kirgizistan'),
(296,'ki','kir',N'Kiribati'),
(170,'co','col',N'Kolonbia'),
(174,'km','com',N'Komoreak'),
(178,'cg','cog',N'Kongoko Errepublika'),
(180,'cd','cod',N'Kongoko Errepublika Demokratikoa'),
(188,'cr','cri',N'Costa Rica'),
(191,'hr','hrv',N'Kroazia'),
(192,'cu','cub',N'Kuba'),
(414,'kw','kwt',N'Kuwait'),
(418,'la','lao',N'Laos'),
(426,'ls','lso',N'Lesotho'),
(428,'lv','lva',N'Letonia'),
(422,'lb','lbn',N'Libano'),
(430,'lr','lbr',N'Liberia'),
(434,'ly','lby',N'Libia'),
(438,'li','lie',N'Liechtenstein'),
(440,'lt','ltu',N'Lituania'),
(442,'lu','lux',N'Luxenburgo'),
(450,'mg','mdg',N'Madagaskar'),
(807,'mk','mkd',N'Ipar Mazedonia'),
(458,'my','mys',N'Malaysia'),
(454,'mw','mwi',N'Malawi'),
(462,'mv','mdv',N'Maldivak'),
(466,'ml','mli',N'Mali'),
(470,'mt','mlt',N'Malta'),
(504,'ma','mar',N'Maroko'),
(584,'mh','mhl',N'Marshall Uharteak'),
(478,'mr','mrt',N'Mauritania'),
(480,'mu','mus',N'Maurizio'),
(484,'mx','mex',N'Mexiko'),
(583,'fm','fsm',N'Mikronesiako Estatu Federatuak'),
(498,'md','mda',N'Moldavia'),
(492,'mc','mco',N'Monako'),
(496,'mn','mng',N'Mongolia'),
(499,'me','mne',N'Montenegro'),
(508,'mz','moz',N'Mozambike'),
(104,'mm','mmr',N'Myanmar'),
(516,'na','nam',N'Namibia'),
(520,'nr','nru',N'Nauru'),
(524,'np','npl',N'Nepal'),
(562,'ne','ner',N'Niger'),
(566,'ng','nga',N'Nigeria'),
(558,'ni','nic',N'Nikaragua'),
(578,'no','nor',N'Norvegia'),
(512,'om','omn',N'Oman'),
(586,'pk','pak',N'Pakistan'),
(585,'pw','plw',N'Palau'),
(591,'pa','pan',N'Panama'),
(598,'pg','png',N'Papua Ginea Berria'),
(600,'py','pry',N'Paraguai'),
(604,'pe','per',N'Peru'),
(616,'pl','pol',N'Polonia'),
(620,'pt','prt',N'Portugal'),
(634,'qa','qat',N'Qatar'),
(646,'rw','rwa',N'Ruanda'),
(222,'sv','slv',N'El Salvador'),
(90,'sb','slb',N'Salomon Uharteak'),
(882,'ws','wsm',N'Samoa'),
(670,'vc','vct',N'Saint Vincent eta Grenadinak'),
(659,'kn','kna',N'Saint Kitts eta Nevis'),
(674,'sm','smr',N'San Marino'),
(678,'st','stp',N'Sao Tome eta Principe'),
(662,'lc','lca',N'Santa Luzia'),
(682,'sa','sau',N'Saudi Arabia'),
(686,'sn','sen',N'Senegal'),
(688,'rs','srb',N'Serbia'),
(690,'sc','syc',N'Seychelleak'),
(694,'sl','sle',N'Sierra Leona'),
(702,'sg','sgp',N'Singapur'),
(760,'sy','syr',N'Siria'),
(706,'so','som',N'Somalia'),
(144,'lk','lka',N'Sri Lanka'),
(748,'sz','swz',N'Eswatini'),
(729,'sd','sdn',N'Sudan'),
(752,'se','swe',N'Suedia'),
(756,'ch','che',N'Suitza'),
(740,'sr','sur',N'Surinam'),
(764,'th','tha',N'Thailandia'),
(762,'tj','tjk',N'Tajikistan'),
(834,'tz','tza',N'Tanzania'),
(768,'tg','tgo',N'Togo'),
(776,'to','ton',N'Tonga'),
(780,'tt','tto',N'Trinidad eta Tobago'),
(788,'tn','tun',N'Tunisia'),
(792,'tr','tur',N'Turkia'),
(795,'tm','tkm',N'Turkmenistan'),
(798,'tv','tuv',N'Tuvalu'),
(148,'td','tcd',N'Txad'),
(203,'cz','cze',N'Txekia'),
(152,'cl','chl',N'Txile'),
(156,'cn','chn',N'Txina'),
(800,'ug','uga',N'Uganda'),
(804,'ua','ukr',N'Ukraina'),
(858,'uy','ury',N'Uruguai'),
(860,'uz','uzb',N'Uzbekistan'),
(548,'vu','vut',N'Vanuatu'),
(862,'ve','ven',N'Venezuela'),
(704,'vn','vnm',N'Vietnam'),
(887,'ye','yem',N'Yemen'),
(894,'zm','zmb',N'Zambia'),
(554,'nz','nzl',N'Zeelanda Berria'),
(716,'zw','zwe',N'Zimbabwe'),
(196,'cy','cyp',N'Zipre')