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'),
(248,'ax','ala',N'Insulele Åland'),
(8,'al','alb',N'Albania'),
(12,'dz','dza',N'Algeria'),
(16,'as','asm',N'Samoa Americană'),
(20,'ad','and',N'Andorra'),
(24,'ao','ago',N'Angola'),
(660,'ai','aia',N'Anguilla'),
(10,'aq','ata',N'Antarctica'),
(28,'ag','atg',N'Antigua și 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'Azerbaidjan'),
(44,'bs','bhs',N'Bahamas'),
(48,'bh','bhr',N'Bahrain'),
(50,'bd','bgd',N'Bangladesh'),
(52,'bb','brb',N'Barbados'),
(112,'by','blr',N'Belarus'),
(56,'be','bel',N'Belgia'),
(84,'bz','blz',N'Belize'),
(204,'bj','ben',N'Benin'),
(60,'bm','bmu',N'Bermude'),
(64,'bt','btn',N'Bhutan'),
(68,'bo','bol',N'Bolivia'),
(535,'bq','bes',N'Insulele Bonaire, Sint Eustatius și Saba'),
(70,'ba','bih',N'Bosnia și Herțegovina'),
(72,'bw','bwa',N'Botswana'),
(74,'bv','bvt',N'Insula Bouvet'),
(76,'br','bra',N'Brazilia'),
(86,'io','iot',N'Teritoriul Britanic din Oceanul Indian'),
(96,'bn','brn',N'Brunei'),
(100,'bg','bgr',N'Bulgaria'),
(854,'bf','bfa',N'Burkina Faso'),
(108,'bi','bdi',N'Burundi'),
(116,'kh','khm',N'Cambodgia'),
(120,'cm','cmr',N'Camerun'),
(124,'ca','can',N'Canada'),
(531,'cw','cuw',N'Curaçao'),
(132,'cv','cpv',N'Republica Capului Verde'),
(136,'ky','cym',N'Insulele Cayman'),
(140,'cf','caf',N'Republica Centrafricană'),
(148,'td','tcd',N'Ciad'),
(152,'cl','chl',N'Chile'),
(156,'cn','chn',N'Republica Populară Chineză'),
(162,'cx','cxr',N'Insula Crăciunului'),
(166,'cc','cck',N'Insulele Cocos'),
(170,'co','col',N'Columbia'),
(174,'km','com',N'Comore'),
(178,'cg','cog',N'Congo'),
(180,'cd','cod',N'Republica Democrată Congo'),
(184,'ck','cok',N'Insulele Cook'),
(188,'cr','cri',N'Costa Rica'),
(384,'ci','civ',N'Coasta de Fildeș'),
(191,'hr','hrv',N'Croația'),
(192,'cu','cub',N'Cuba'),
(196,'cy','cyp',N'Cipru'),
(203,'cz','cze',N'Cehia'),
(208,'dk','dnk',N'Danemarca'),
(262,'dj','dji',N'Djibouti'),
(212,'dm','dma',N'Dominica'),
(214,'do','dom',N'Republica Dominicană'),
(218,'ec','ecu',N'Ecuador'),
(818,'eg','egy',N'Egipt'),
(222,'sv','slv',N'El Salvador'),
(226,'gq','gnq',N'Guineea Ecuatorială'),
(232,'er','eri',N'Eritreea'),
(233,'ee','est',N'Estonia'),
(748,'sz','swz',N'Eswatini'),
(231,'et','eth',N'Etiopia'),
(238,'fk','flk',N'Insulele Falkland'),
(234,'fo','fro',N'Insulele Feroe'),
(242,'fj','fji',N'Fiji'),
(246,'fi','fin',N'Finlanda'),
(250,'fr','fra',N'Franța'),
(254,'gf','guf',N'Guiana Franceză'),
(258,'pf','pyf',N'Polinezia Franceză'),
(260,'tf','atf',N'Teritoriile Australe și Antarctice Franceze'),
(266,'ga','gab',N'Gabon'),
(270,'gm','gmb',N'Gambia'),
(268,'ge','geo',N'Georgia'),
(276,'de','deu',N'Germania'),
(288,'gh','gha',N'Ghana'),
(292,'gi','gib',N'Gibraltar'),
(300,'gr','grc',N'Grecia'),
(304,'gl','grl',N'Groenlanda'),
(308,'gd','grd',N'Grenada'),
(312,'gp','glp',N'Guadelupa'),
(316,'gu','gum',N'Guam'),
(320,'gt','gtm',N'Guatemala'),
(831,'gg','ggy',N'Guernsey'),
(324,'gn','gin',N'Guineea'),
(624,'gw','gnb',N'Guineea-Bissau'),
(328,'gy','guy',N'Guyana'),
(332,'ht','hti',N'Haiti'),
(334,'hm','hmd',N'Insula Heard și Insulele McDonald'),
(336,'va','vat',N'Vatican'),
(340,'hn','hnd',N'Honduras'),
(344,'hk','hkg',N'Hong Kong'),
(348,'hu','hun',N'Ungaria'),
(352,'is','isl',N'Islanda'),
(356,'in','ind',N'India'),
(360,'id','idn',N'Indonezia'),
(364,'ir','irn',N'Iran'),
(368,'iq','irq',N'Irak'),
(372,'ie','irl',N'Republica Irlanda'),
(833,'im','imn',N'Insula Man'),
(376,'il','isr',N'Israel'),
(380,'it','ita',N'Italia'),
(388,'jm','jam',N'Jamaica'),
(392,'jp','jpn',N'Japonia'),
(832,'je','jey',N'Insula Jersey'),
(400,'jo','jor',N'Iordania'),
(398,'kz','kaz',N'Kazahstan'),
(404,'ke','ken',N'Kenya'),
(296,'ki','kir',N'Kiribati'),
(408,'kp','prk',N'Coreea de Nord'),
(410,'kr','kor',N'Coreea de Sud'),
(414,'kw','kwt',N'Kuweit'),
(417,'kg','kgz',N'Kârgâzstan'),
(418,'la','lao',N'Laos'),
(428,'lv','lva',N'Letonia'),
(422,'lb','lbn',N'Liban'),
(426,'ls','lso',N'Lesotho'),
(430,'lr','lbr',N'Liberia'),
(434,'ly','lby',N'Libia'),
(438,'li','lie',N'Liechtenstein'),
(440,'lt','ltu',N'Lituania'),
(442,'lu','lux',N'Luxemburg'),
(446,'mo','mac',N'Macao'),
(807,'mk','mkd',N'Macedonia de Nord'),
(450,'mg','mdg',N'Madagascar'),
(454,'mw','mwi',N'Malawi'),
(458,'my','mys',N'Malaezia'),
(462,'mv','mdv',N'Maldive'),
(466,'ml','mli',N'Mali'),
(470,'mt','mlt',N'Malta'),
(584,'mh','mhl',N'Insulele Marshall'),
(474,'mq','mtq',N'Martinica'),
(478,'mr','mrt',N'Mauritania'),
(480,'mu','mus',N'Mauritius'),
(175,'yt','myt',N'Mayotte'),
(484,'mx','mex',N'Mexic'),
(583,'fm','fsm',N'Micronezia'),
(498,'md','mda',N'Republica Moldova'),
(492,'mc','mco',N'Monaco'),
(496,'mn','mng',N'Mongolia'),
(499,'me','mne',N'Muntenegru'),
(500,'ms','msr',N'Montserrat'),
(504,'ma','mar',N'Maroc'),
(508,'mz','moz',N'Mozambic'),
(104,'mm','mmr',N'Myanmar'),
(516,'na','nam',N'Namibia'),
(520,'nr','nru',N'Nauru'),
(524,'np','npl',N'Nepal'),
(528,'nl','nld',N'Țările de Jos'),
(540,'nc','ncl',N'Noua Caledonie'),
(554,'nz','nzl',N'Noua Zeelandă'),
(558,'ni','nic',N'Nicaragua'),
(562,'ne','ner',N'Niger'),
(566,'ng','nga',N'Nigeria'),
(570,'nu','niu',N'Niue'),
(574,'nf','nfk',N'Insula Norfolk'),
(580,'mp','mnp',N'Insulele Mariane de Nord'),
(578,'no','nor',N'Norvegia'),
(512,'om','omn',N'Oman'),
(586,'pk','pak',N'Pakistan'),
(585,'pw','plw',N'Palau'),
(275,'ps','pse',N'Teritoriile Palestiniene Ocupate'),
(591,'pa','pan',N'Panama'),
(598,'pg','png',N'Papua Noua Guinee'),
(600,'py','pry',N'Paraguay'),
(604,'pe','per',N'Peru'),
(608,'ph','phl',N'Filipine'),
(612,'pn','pcn',N'Pitcairn'),
(616,'pl','pol',N'Polonia'),
(620,'pt','prt',N'Portugalia'),
(630,'pr','pri',N'Puerto Rico'),
(634,'qa','qat',N'Qatar'),
(638,'re','reu',N'Réunion'),
(642,'ro','rou',N'România'),
(643,'ru','rus',N'Rusia'),
(646,'rw','rwa',N'Rwanda'),
(652,'bl','blm',N'Saint Barthélemy'),
(654,'sh','shn',N'Sfânta Elena'),
(659,'kn','kna',N'Sfântul Kitts și Nevis'),
(662,'lc','lca',N'Sfânta Lucia'),
(663,'mf','maf',N'Sint Maarten (partea franceză)'),
(666,'pm','spm',N'Sfântul Pierre și Miquelon'),
(670,'vc','vct',N'Sfântul Vincent și Grenadine'),
(882,'ws','wsm',N'Samoa'),
(674,'sm','smr',N'San Marino'),
(678,'st','stp',N'Sao Tome și Principe'),
(682,'sa','sau',N'Arabia Saudită'),
(686,'sn','sen',N'Senegal'),
(688,'rs','srb',N'Serbia'),
(690,'sc','syc',N'Seychelles'),
(694,'sl','sle',N'Sierra Leone'),
(702,'sg','sgp',N'Singapore'),
(534,'sx','sxm',N'Sint Maarten (partea olandeză)'),
(703,'sk','svk',N'Slovacia'),
(705,'si','svn',N'Slovenia'),
(90,'sb','slb',N'Insulele Solomon'),
(706,'so','som',N'Somalia'),
(710,'za','zaf',N'Africa de Sud'),
(239,'gs','sgs',N'Georgia de Sud și Insulele Sandwich de Sud'),
(724,'es','esp',N'Spania'),
(144,'lk','lka',N'Sri Lanka'),
(729,'sd','sdn',N'Sudan'),
(728,'ss','ssd',N'Sudanul de Sud'),
(740,'sr','sur',N'Surinam'),
(744,'sj','sjm',N'Svalbard și Jan Mayen'),
(752,'se','swe',N'Suedia'),
(756,'ch','che',N'Elveția'),
(760,'sy','syr',N'Siria'),
(158,'tw','twn',N'Taiwan'),
(762,'tj','tjk',N'Tadjikistan'),
(834,'tz','tza',N'Tanzania'),
(764,'th','tha',N'Thailanda'),
(626,'tl','tls',N'Timorul de Est'),
(768,'tg','tgo',N'Togo'),
(772,'tk','tkl',N'Tokelau'),
(776,'to','ton',N'Tonga'),
(780,'tt','tto',N'Trinidad și Tobago'),
(788,'tn','tun',N'Tunisia'),
(792,'tr','tur',N'Turcia'),
(795,'tm','tkm',N'Turkmenistan'),
(796,'tc','tca',N'Insulele Turks și Caicos'),
(798,'tv','tuv',N'Tuvalu'),
(800,'ug','uga',N'Uganda'),
(804,'ua','ukr',N'Ucraina'),
(784,'ae','are',N'Emiratele Arabe Unite'),
(826,'gb','gbr',N'Regatul Unit'),
(840,'us','usa',N'Statele Unite ale Americii'),
(581,'um','umi',N'Insulele Minore Îndepărtate ale Statelor Unite'),
(858,'uy','ury',N'Uruguay'),
(860,'uz','uzb',N'Uzbekistan'),
(548,'vu','vut',N'Vanuatu'),
(862,'ve','ven',N'Venezuela'),
(704,'vn','vnm',N'Vietnam'),
(92,'vg','vgb',N'Insulele Virgine Britanice'),
(850,'vi','vir',N'Insulele Virgine Americane'),
(876,'wf','wlf',N'Wallis și Futuna'),
(732,'eh','esh',N'Sahara Occidentală'),
(887,'ye','yem',N'Yemen'),
(894,'zm','zmb',N'Zambia'),
(716,'zw','zwe',N'Zimbabwe')