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'),
(8,'al','alb',N'Albania'),
(12,'dz','dza',N'Algeria'),
(20,'ad','and',N'Andorra'),
(24,'ao','ago',N'Angola'),
(28,'ag','atg',N'Antigua și 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'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'),
(64,'bt','btn',N'Bhutan'),
(68,'bo','bol',N'Bolivia'),
(70,'ba','bih',N'Bosnia și Herțegovina'),
(72,'bw','bwa',N'Botswana'),
(76,'br','bra',N'Brazilia'),
(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'),
(132,'cv','cpv',N'Republica Capului Verde'),
(140,'cf','caf',N'Republica Centrafricană'),
(148,'td','tcd',N'Ciad'),
(152,'cl','chl',N'Chile'),
(156,'cn','chn',N'Republica Populară Chineză'),
(170,'co','col',N'Columbia'),
(174,'km','com',N'Comore'),
(178,'cg','cog',N'Congo'),
(180,'cd','cod',N'Republica Democrată Congo'),
(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'),
(242,'fj','fji',N'Fiji'),
(246,'fi','fin',N'Finlanda'),
(250,'fr','fra',N'Franța'),
(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'),
(300,'gr','grc',N'Grecia'),
(308,'gd','grd',N'Grenada'),
(320,'gt','gtm',N'Guatemala'),
(324,'gn','gin',N'Guineea'),
(624,'gw','gnb',N'Guineea-Bissau'),
(328,'gy','guy',N'Guyana'),
(332,'ht','hti',N'Haiti'),
(340,'hn','hnd',N'Honduras'),
(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'),
(376,'il','isr',N'Israel'),
(380,'it','ita',N'Italia'),
(388,'jm','jam',N'Jamaica'),
(392,'jp','jpn',N'Japonia'),
(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'),
(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'),
(478,'mr','mrt',N'Mauritania'),
(480,'mu','mus',N'Mauritius'),
(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'),
(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'),
(554,'nz','nzl',N'Noua Zeelandă'),
(558,'ni','nic',N'Nicaragua'),
(562,'ne','ner',N'Niger'),
(566,'ng','nga',N'Nigeria'),
(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 Noua Guinee'),
(600,'py','pry',N'Paraguay'),
(604,'pe','per',N'Peru'),
(608,'ph','phl',N'Filipine'),
(616,'pl','pol',N'Polonia'),
(620,'pt','prt',N'Portugalia'),
(634,'qa','qat',N'Qatar'),
(642,'ro','rou',N'România'),
(643,'ru','rus',N'Rusia'),
(646,'rw','rwa',N'Rwanda'),
(659,'kn','kna',N'Sfântul Kitts și Nevis'),
(662,'lc','lca',N'Sfânta Lucia'),
(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'),
(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'),
(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'),
(752,'se','swe',N'Suedia'),
(756,'ch','che',N'Elveția'),
(760,'sy','syr',N'Siria'),
(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'),
(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'),
(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'),
(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'),
(887,'ye','yem',N'Yemen'),
(894,'zm','zmb',N'Zambia'),
(716,'zw','zwe',N'Zimbabwe')