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'),
(140,'cf','caf',N'Afrika Erdiko Errepublika'),
(248,'ax','ala',N'Aland'),
(8,'al','alb',N'Albania'),
(276,'de','deu',N'Alemania'),
(12,'dz','dza',N'Aljeria'),
(16,'as','asm',N'Samoa Estatubatuarra'),
(20,'ad','and',N'Andorra'),
(660,'ai','aia',N'Aingira'),
(24,'ao','ago',N'Angola'),
(10,'aq','ata',N'Antartika'),
(784,'ae','are',N'Arabiar Emirerri Batuak'),
(28,'ag','atg',N'Antigua eta Barbuda'),
(32,'ar','arg',N'Argentina'),
(51,'am','arm',N'Armenia'),
(533,'aw','abw',N'Aruba'),
(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'),
(60,'bm','bmu',N'Bermuda'),
(112,'by','blr',N'Bielorrusia'),
(92,'vg','vgb',N'Birjina uharte britainiarrak'),
(850,'vi','vir',N'Birjina uharte amerikarrak'),
(384,'ci','civ',N'Boli Kosta'),
(68,'bo','bol',N'Bolivia'),
(535,'bq','bes',N'Karibeko Herbehereak'),
(70,'ba','bih',N'Bosnia-Herzegovina'),
(72,'bw','bwa',N'Botswana'),
(74,'bv','bvt',N'Bouvet Uhartea'),
(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'),
(162,'cx','cxr',N'Christmas uhartea'),
(166,'cc','cck',N'Cocosak'),
(184,'ck','cok',N'Cook uharteak'),
(531,'cw','cuw',N'Curaçao'),
(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'),
(581,'um','umi',N'Ameriketako Estatu Batuetako itsasoz haraindiko uharteak'),
(233,'ee','est',N'Estonia'),
(231,'et','eth',N'Etiopia'),
(234,'fo','fro',N'Faroeak'),
(242,'fj','fji',N'Fiji'),
(608,'ph','phl',N'Filipinak'),
(246,'fi','fin',N'Finlandia'),
(250,'fr','fra',N'Frantzia'),
(254,'gf','guf',N'Guyana Frantsesa'),
(258,'pf','pyf',N'Polinesia Frantsesa'),
(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'),
(324,'gn','gin',N'Ginea'),
(624,'gw','gnb',N'Ginea-Bissau'),
(308,'gd','grd',N'Grenada'),
(300,'gr','grc',N'Grezia'),
(304,'gl','grl',N'Groenlandia'),
(312,'gp','glp',N'Guadalupe'),
(316,'gu','gum',N'Guam'),
(320,'gt','gtm',N'Guatemala'),
(831,'gg','ggy',N'Guernsey'),
(328,'gy','guy',N'Guyana'),
(332,'ht','hti',N'Haiti'),
(334,'hm','hmd',N'Heard eta McDonald Uharteak'),
(710,'za','zaf',N'Hegoafrika'),
(239,'gs','sgs',N'Hegoaldeko Georgiak eta Hegoaldeko Sandwichak'),
(410,'kr','kor',N'Hego Korea'),
(728,'ss','ssd',N'Hego Sudan'),
(260,'tf','atf',N'Frantziaren lurralde austral eta antartikoak'),
(528,'nl','nld',N'Herbehereak'),
(340,'hn','hnd',N'Honduras'),
(344,'hk','hkg',N'Hong Kong'),
(348,'hu','hun',N'Hungaria'),
(356,'in','ind',N'India'),
(360,'id','idn',N'Indonesia'),
(408,'kp','prk',N'Ipar Korea'),
(580,'mp','mnp',N'Ipar Marianak'),
(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'),
(832,'je','jey',N'Jersey'),
(400,'jo','jor',N'Jordania'),
(132,'cv','cpv',N'Cabo Verde'),
(136,'ky','cym',N'Kaiman uharteak'),
(540,'nc','ncl',N'Kaledonia Berria'),
(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'),
(446,'mo','mac',N'Macau'),
(807,'mk','mkd',N'Ipar Mazedonia'),
(458,'my','mys',N'Malaysia'),
(454,'mw','mwi',N'Malawi'),
(238,'fk','flk',N'Falklandak'),
(462,'mv','mdv',N'Maldivak'),
(466,'ml','mli',N'Mali'),
(470,'mt','mlt',N'Malta'),
(833,'im','imn',N'Man'),
(504,'ma','mar',N'Maroko'),
(584,'mh','mhl',N'Marshall Uharteak'),
(474,'mq','mtq',N'Martinika'),
(478,'mr','mrt',N'Mauritania'),
(480,'mu','mus',N'Maurizio'),
(175,'yt','myt',N'Mayotte'),
(732,'eh','esh',N'Mendebaldeko Sahara'),
(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'),
(500,'ms','msr',N'Montserrat'),
(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'),
(570,'nu','niu',N'Niue'),
(574,'nf','nfk',N'Norfolk uhartea'),
(578,'no','nor',N'Norvegia'),
(512,'om','omn',N'Oman'),
(86,'io','iot',N'Indiako Ozeanoko Britainiar Lurraldea'),
(586,'pk','pak',N'Pakistan'),
(585,'pw','plw',N'Palau'),
(275,'ps','pse',N'Palestina'),
(591,'pa','pan',N'Panama'),
(598,'pg','png',N'Papua Ginea Berria'),
(600,'py','pry',N'Paraguai'),
(604,'pe','per',N'Peru'),
(612,'pn','pcn',N'Pitcairn uharteak'),
(616,'pl','pol',N'Polonia'),
(620,'pt','prt',N'Portugal'),
(630,'pr','pri',N'Puerto Rico'),
(634,'qa','qat',N'Qatar'),
(638,'re','reu',N'Réunion'),
(646,'rw','rwa',N'Ruanda'),
(666,'pm','spm',N'Saint-Pierre eta Mikelune'),
(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'),
(663,'mf','maf',N'Saint Martin'),
(534,'sx','sxm',N'Sint Maarten'),
(744,'sj','sjm',N'Svalbard eta Jan Mayen'),
(652,'bl','blm',N'Saint Barthélemy'),
(674,'sm','smr',N'San Marino'),
(678,'st','stp',N'Sao Tome eta Principe'),
(654,'sh','shn',N'Santa Helena, Ascension eta Tristan da Cunha'),
(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'),
(158,'tw','twn',N'Taiwan'),
(762,'tj','tjk',N'Tajikistan'),
(834,'tz','tza',N'Tanzania'),
(768,'tg','tgo',N'Togo'),
(772,'tk','tkl',N'Tokelau'),
(776,'to','ton',N'Tonga'),
(780,'tt','tto',N'Trinidad eta Tobago'),
(788,'tn','tun',N'Tunisia'),
(792,'tr','tur',N'Turkia'),
(796,'tc','tca',N'Turkak eta Caicoak'),
(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'),
(336,'va','vat',N'Vatikano Hiria'),
(862,'ve','ven',N'Venezuela'),
(704,'vn','vnm',N'Vietnam'),
(876,'wf','wlf',N'Wallis eta Futuna'),
(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')