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'Arnavutluk'),
(12,'dz','dza',N'Cezayir'),
(20,'ad','and',N'Andorra'),
(24,'ao','ago',N'Angola'),
(28,'ag','atg',N'Antigua ve Barbuda'),
(32,'ar','arg',N'Arjantin'),
(51,'am','arm',N'Ermenistan'),
(36,'au','aus',N'Avustralya'),
(40,'at','aut',N'Avusturya'),
(31,'az','aze',N'Azerbaycan'),
(44,'bs','bhs',N'Bahamalar'),
(48,'bh','bhr',N'Bahreyn'),
(50,'bd','bgd',N'Bangladeş'),
(52,'bb','brb',N'Barbados'),
(112,'by','blr',N'Belarus'),
(56,'be','bel',N'Belçika'),
(84,'bz','blz',N'Belize'),
(204,'bj','ben',N'Benin'),
(64,'bt','btn',N'Bhutan'),
(68,'bo','bol',N'Bolivya'),
(70,'ba','bih',N'Bosna-Hersek'),
(72,'bw','bwa',N'Botsvana'),
(76,'br','bra',N'Brezilya'),
(96,'bn','brn',N'Brunei Darüsselam'),
(100,'bg','bgr',N'Bulgaristan'),
(854,'bf','bfa',N'Burkina Faso'),
(108,'bi','bdi',N'Burundi'),
(132,'cv','cpv',N'Yeşil Burun Adaları'),
(116,'kh','khm',N'Kamboçya'),
(120,'cm','cmr',N'Kamerun'),
(124,'ca','can',N'Kanada'),
(140,'cf','caf',N'Orta Afrika Cumhuriyeti'),
(148,'td','tcd',N'Çad'),
(152,'cl','chl',N'Şili'),
(156,'cn','chn',N'Çin'),
(170,'co','col',N'Kolombiya'),
(174,'km','com',N'Komorlar'),
(180,'cd','cod',N'Kongo Demokratik Cumhuriyeti'),
(178,'cg','cog',N'Kongo Cumhuriyeti'),
(188,'cr','cri',N'Kosta Rika'),
(384,'ci','civ',N'Fildişi Sahili'),
(191,'hr','hrv',N'Hırvatistan'),
(192,'cu','cub',N'Küba'),
(196,'cy','cyp',N'Kıbrıs Cumhuriyeti'),
(203,'cz','cze',N'Çekya'),
(208,'dk','dnk',N'Danimarka'),
(262,'dj','dji',N'Cibuti'),
(212,'dm','dma',N'Dominika'),
(214,'do','dom',N'Dominik Cumhuriyeti'),
(218,'ec','ecu',N'Ekvador'),
(818,'eg','egy',N'Mısır'),
(222,'sv','slv',N'El Salvador'),
(226,'gq','gnq',N'Ekvator Ginesi'),
(232,'er','eri',N'Eritre'),
(233,'ee','est',N'Estonya'),
(748,'sz','swz',N'Esvatini'),
(231,'et','eth',N'Etiyopya'),
(242,'fj','fji',N'Fiji'),
(246,'fi','fin',N'Finlandiya'),
(250,'fr','fra',N'Fransa'),
(266,'ga','gab',N'Gabon'),
(270,'gm','gmb',N'Gambiya'),
(268,'ge','geo',N'Gürcistan'),
(276,'de','deu',N'Almanya'),
(288,'gh','gha',N'Gana'),
(300,'gr','grc',N'Yunanistan'),
(308,'gd','grd',N'Grenada'),
(320,'gt','gtm',N'Guatemala'),
(324,'gn','gin',N'Gine'),
(624,'gw','gnb',N'Gine-Bissau'),
(328,'gy','guy',N'Guyana'),
(332,'ht','hti',N'Haiti'),
(340,'hn','hnd',N'Honduras'),
(348,'hu','hun',N'Macaristan'),
(352,'is','isl',N'İzlanda'),
(356,'in','ind',N'Hindistan'),
(360,'id','idn',N'Endonezya'),
(364,'ir','irn',N'İran'),
(368,'iq','irq',N'Irak'),
(372,'ie','irl',N'İrlanda'),
(376,'il','isr',N'İsrail'),
(380,'it','ita',N'İtalya'),
(388,'jm','jam',N'Jamaika'),
(392,'jp','jpn',N'Japonya'),
(400,'jo','jor',N'Ürdün'),
(398,'kz','kaz',N'Kazakistan'),
(404,'ke','ken',N'Kenya'),
(296,'ki','kir',N'Kiribati'),
(408,'kp','prk',N'Kore Demokratik Halk Cumhuriyeti'),
(410,'kr','kor',N'Kore Cumhuriyeti'),
(414,'kw','kwt',N'Kuveyt'),
(417,'kg','kgz',N'Kırgızistan'),
(418,'la','lao',N'Lao Demokratik Halk Cumhuriyeti'),
(428,'lv','lva',N'Letonya'),
(422,'lb','lbn',N'Lübnan'),
(426,'ls','lso',N'Lesotho'),
(430,'lr','lbr',N'Liberya'),
(434,'ly','lby',N'Libya'),
(438,'li','lie',N'Lihtenştayn'),
(440,'lt','ltu',N'Litvanya'),
(442,'lu','lux',N'Lüksemburg'),
(807,'mk','mkd',N'Kuzey Makedonya'),
(450,'mg','mdg',N'Madagaskar'),
(454,'mw','mwi',N'Malavi'),
(458,'my','mys',N'Malezya'),
(462,'mv','mdv',N'Maldivler'),
(466,'ml','mli',N'Mali'),
(470,'mt','mlt',N'Malta'),
(584,'mh','mhl',N'Marshall Adaları'),
(478,'mr','mrt',N'Moritanya'),
(480,'mu','mus',N'Mauritius'),
(484,'mx','mex',N'Meksika'),
(583,'fm','fsm',N'Mikronezya Federal Devletleri'),
(498,'md','mda',N'Moldova'),
(492,'mc','mco',N'Monako'),
(496,'mn','mng',N'Moğolistan'),
(499,'me','mne',N'Karadağ'),
(504,'ma','mar',N'Fas'),
(508,'mz','moz',N'Mozambik'),
(104,'mm','mmr',N'Myanmar'),
(516,'na','nam',N'Namibya'),
(520,'nr','nru',N'Nauru'),
(524,'np','npl',N'Nepal'),
(528,'nl','nld',N'Hollanda'),
(554,'nz','nzl',N'Yeni Zelanda'),
(558,'ni','nic',N'Nikaragua'),
(562,'ne','ner',N'Nijer'),
(566,'ng','nga',N'Nijerya'),
(578,'no','nor',N'Norveç'),
(512,'om','omn',N'Umman'),
(586,'pk','pak',N'Pakistan'),
(585,'pw','plw',N'Palau'),
(591,'pa','pan',N'Panama'),
(598,'pg','png',N'Papua Yeni Gine'),
(600,'py','pry',N'Paraguay'),
(604,'pe','per',N'Peru'),
(608,'ph','phl',N'Filipinler'),
(616,'pl','pol',N'Polonya'),
(620,'pt','prt',N'Portekiz'),
(634,'qa','qat',N'Katar'),
(642,'ro','rou',N'Romanya'),
(643,'ru','rus',N'Rusya Federasyonu'),
(646,'rw','rwa',N'Ruanda'),
(659,'kn','kna',N'Saint Kitts ve Nevis'),
(662,'lc','lca',N'Saint Lucia'),
(670,'vc','vct',N'Saint Vincent ve Grenadinler'),
(882,'ws','wsm',N'Samoa'),
(674,'sm','smr',N'San Marino'),
(678,'st','stp',N'São Tomé ve Príncipe'),
(682,'sa','sau',N'Suudi Arabistan'),
(686,'sn','sen',N'Senegal'),
(688,'rs','srb',N'Sırbistan'),
(690,'sc','syc',N'Seyşeller'),
(694,'sl','sle',N'Sierra Leone'),
(702,'sg','sgp',N'Singapur'),
(703,'sk','svk',N'Slovakya'),
(705,'si','svn',N'Slovenya'),
(90,'sb','slb',N'Solomon Adaları'),
(706,'so','som',N'Somali'),
(710,'za','zaf',N'Güney Afrika'),
(728,'ss','ssd',N'Güney Sudan'),
(724,'es','esp',N'İspanya'),
(144,'lk','lka',N'Sri Lanka'),
(729,'sd','sdn',N'Sudan'),
(740,'sr','sur',N'Surinam'),
(752,'se','swe',N'İsveç'),
(756,'ch','che',N'İsviçre'),
(760,'sy','syr',N'Suriye Arap Cumhuriyeti'),
(762,'tj','tjk',N'Tacikistan'),
(834,'tz','tza',N'Tanzanya Birleşik Cumhuriyeti'),
(764,'th','tha',N'Tayland'),
(626,'tl','tls',N'Timor-Leste'),
(768,'tg','tgo',N'Togo'),
(776,'to','ton',N'Tonga'),
(780,'tt','tto',N'Trinidad ve Tobago'),
(788,'tn','tun',N'Tunus'),
(792,'tr','tur',N'Türkiye'),
(795,'tm','tkm',N'Türkmenistan'),
(798,'tv','tuv',N'Tuvalu'),
(800,'ug','uga',N'Uganda'),
(804,'ua','ukr',N'Ukrayna'),
(784,'ae','are',N'Birleşik Arap Emirlikleri'),
(826,'gb','gbr',N'Birleşik Krallık'),
(840,'us','usa',N'Amerika Birleşik Devletleri'),
(858,'uy','ury',N'Uruguay'),
(860,'uz','uzb',N'Özbekistan'),
(548,'vu','vut',N'Vanuatu'),
(862,'ve','ven',N'Venezuela'),
(704,'vn','vnm',N'Viet Nam'),
(887,'ye','yem',N'Yemen'),
(894,'zm','zmb',N'Zambiya'),
(716,'zw','zwe',N'Zimbabve')