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
(288,'gh','gha',N'가나'),
(266,'ga','gab',N'가봉'),
(328,'gy','guy',N'가이아나'),
(270,'gm','gmb',N'감비아'),
(320,'gt','gtm',N'과테말라'),
(308,'gd','grd',N'그레나다'),
(300,'gr','grc',N'그리스'),
(324,'gn','gin',N'기니'),
(624,'gw','gnb',N'기니비사우'),
(516,'na','nam',N'나미비아'),
(520,'nr','nru',N'나우루'),
(566,'ng','nga',N'나이지리아'),
(728,'ss','ssd',N'남수단'),
(710,'za','zaf',N'남아프리카 공화국'),
(528,'nl','nld',N'네덜란드'),
(524,'np','npl',N'네팔'),
(578,'no','nor',N'노르웨이'),
(554,'nz','nzl',N'뉴질랜드'),
(562,'ne','ner',N'니제르'),
(558,'ni','nic',N'니카라과'),
(410,'kr','kor',N'대한민국'),
(208,'dk','dnk',N'덴마크'),
(214,'do','dom',N'도미니카 공화국'),
(212,'dm','dma',N'도미니카 연방'),
(276,'de','deu',N'독일'),
(626,'tl','tls',N'동티모르'),
(418,'la','lao',N'라오스'),
(430,'lr','lbr',N'라이베리아'),
(428,'lv','lva',N'라트비아'),
(643,'ru','rus',N'러시아'),
(422,'lb','lbn',N'레바논'),
(426,'ls','lso',N'레소토'),
(642,'ro','rou',N'루마니아'),
(442,'lu','lux',N'룩셈부르크'),
(646,'rw','rwa',N'르완다'),
(434,'ly','lby',N'리비아'),
(440,'lt','ltu',N'리투아니아'),
(438,'li','lie',N'리히텐슈타인'),
(450,'mg','mdg',N'마다가스카르'),
(584,'mh','mhl',N'마셜 제도'),
(807,'mk','mkd',N'북마케도니아'),
(454,'mw','mwi',N'말라위'),
(458,'my','mys',N'말레이시아'),
(466,'ml','mli',N'말리'),
(484,'mx','mex',N'멕시코'),
(492,'mc','mco',N'모나코'),
(504,'ma','mar',N'모로코'),
(480,'mu','mus',N'모리셔스'),
(478,'mr','mrt',N'모리타니'),
(508,'mz','moz',N'모잠비크'),
(499,'me','mne',N'몬테네그로'),
(498,'md','mda',N'몰도바'),
(462,'mv','mdv',N'몰디브'),
(470,'mt','mlt',N'몰타'),
(496,'mn','mng',N'몽골'),
(840,'us','usa',N'미국'),
(104,'mm','mmr',N'미얀마'),
(583,'fm','fsm',N'미크로네시아 연방'),
(548,'vu','vut',N'바누아투'),
(48,'bh','bhr',N'바레인'),
(52,'bb','brb',N'바베이도스'),
(44,'bs','bhs',N'바하마'),
(50,'bd','bgd',N'방글라데시'),
(204,'bj','ben',N'베냉'),
(862,'ve','ven',N'베네수엘라'),
(704,'vn','vnm',N'베트남'),
(56,'be','bel',N'벨기에'),
(112,'by','blr',N'벨라루스'),
(84,'bz','blz',N'벨리즈'),
(70,'ba','bih',N'보스니아 헤르체고비나'),
(72,'bw','bwa',N'보츠와나'),
(68,'bo','bol',N'볼리비아'),
(108,'bi','bdi',N'부룬디'),
(854,'bf','bfa',N'부르키나파소'),
(64,'bt','btn',N'부탄'),
(100,'bg','bgr',N'불가리아'),
(76,'br','bra',N'브라질'),
(96,'bn','brn',N'브루나이'),
(882,'ws','wsm',N'사모아'),
(682,'sa','sau',N'사우디아라비아'),
(674,'sm','smr',N'산마리노'),
(678,'st','stp',N'상투메 프린시페'),
(686,'sn','sen',N'세네갈'),
(688,'rs','srb',N'세르비아'),
(690,'sc','syc',N'세이셸'),
(662,'lc','lca',N'세인트루시아'),
(670,'vc','vct',N'세인트빈센트 그레나딘'),
(659,'kn','kna',N'세인트키츠 네비스'),
(706,'so','som',N'소말리아'),
(90,'sb','slb',N'솔로몬 제도'),
(729,'sd','sdn',N'수단'),
(740,'sr','sur',N'수리남'),
(144,'lk','lka',N'스리랑카'),
(752,'se','swe',N'스웨덴'),
(756,'ch','che',N'스위스'),
(724,'es','esp',N'스페인'),
(703,'sk','svk',N'슬로바키아'),
(705,'si','svn',N'슬로베니아'),
(760,'sy','syr',N'시리아'),
(694,'sl','sle',N'시에라리온'),
(702,'sg','sgp',N'싱가포르'),
(784,'ae','are',N'아랍에미리트'),
(51,'am','arm',N'아르메니아'),
(32,'ar','arg',N'아르헨티나'),
(352,'is','isl',N'아이슬란드'),
(332,'ht','hti',N'아이티'),
(372,'ie','irl',N'아일랜드'),
(31,'az','aze',N'아제르바이잔'),
(4,'af','afg',N'아프가니스탄'),
(20,'ad','and',N'안도라'),
(8,'al','alb',N'알바니아'),
(12,'dz','dza',N'알제리'),
(24,'ao','ago',N'앙골라'),
(28,'ag','atg',N'앤티가 바부다'),
(232,'er','eri',N'에리트레아'),
(748,'sz','swz',N'에스와티니'),
(233,'ee','est',N'에스토니아'),
(218,'ec','ecu',N'에콰도르'),
(231,'et','eth',N'에티오피아'),
(222,'sv','slv',N'엘살바도르'),
(826,'gb','gbr',N'영국'),
(887,'ye','yem',N'예멘'),
(512,'om','omn',N'오만'),
(36,'au','aus',N'오스트레일리아'),
(40,'at','aut',N'오스트리아'),
(340,'hn','hnd',N'온두라스'),
(400,'jo','jor',N'요르단'),
(800,'ug','uga',N'우간다'),
(858,'uy','ury',N'우루과이'),
(860,'uz','uzb',N'우즈베키스탄'),
(804,'ua','ukr',N'우크라이나'),
(368,'iq','irq',N'이라크'),
(364,'ir','irn',N'이란'),
(376,'il','isr',N'이스라엘'),
(818,'eg','egy',N'이집트'),
(380,'it','ita',N'이탈리아'),
(356,'in','ind',N'인도'),
(360,'id','idn',N'인도네시아'),
(392,'jp','jpn',N'일본'),
(388,'jm','jam',N'자메이카'),
(894,'zm','zmb',N'잠비아'),
(226,'gq','gnq',N'적도 기니'),
(408,'kp','prk',N'조선민주주의인민공화국'),
(268,'ge','geo',N'조지아'),
(156,'cn','chn',N'중국'),
(140,'cf','caf',N'중앙아프리카 공화국'),
(262,'dj','dji',N'지부티'),
(716,'zw','zwe',N'짐바브웨'),
(148,'td','tcd',N'차드'),
(203,'cz','cze',N'체코'),
(152,'cl','chl',N'칠레'),
(120,'cm','cmr',N'카메룬'),
(132,'cv','cpv',N'카보베르데'),
(398,'kz','kaz',N'카자흐스탄'),
(634,'qa','qat',N'카타르'),
(116,'kh','khm',N'캄보디아'),
(124,'ca','can',N'캐나다'),
(404,'ke','ken',N'케냐'),
(174,'km','com',N'코모로'),
(188,'cr','cri',N'코스타리카'),
(384,'ci','civ',N'코트디부아르'),
(170,'co','col',N'콜롬비아'),
(178,'cg','cog',N'콩고 공화국'),
(180,'cd','cod',N'콩고 민주 공화국'),
(192,'cu','cub',N'쿠바'),
(414,'kw','kwt',N'쿠웨이트'),
(191,'hr','hrv',N'크로아티아'),
(417,'kg','kgz',N'키르기스스탄'),
(296,'ki','kir',N'키리바시'),
(196,'cy','cyp',N'키프로스'),
(762,'tj','tjk',N'타지키스탄'),
(834,'tz','tza',N'탄자니아'),
(764,'th','tha',N'태국'),
(792,'tr','tur',N'튀르키예'),
(768,'tg','tgo',N'토고'),
(776,'to','ton',N'통가'),
(795,'tm','tkm',N'투르크메니스탄'),
(798,'tv','tuv',N'투발루'),
(788,'tn','tun',N'튀니지'),
(780,'tt','tto',N'트리니다드 토바고'),
(591,'pa','pan',N'파나마'),
(600,'py','pry',N'파라과이'),
(586,'pk','pak',N'파키스탄'),
(598,'pg','png',N'파푸아뉴기니'),
(585,'pw','plw',N'팔라우'),
(604,'pe','per',N'페루'),
(620,'pt','prt',N'포르투갈'),
(616,'pl','pol',N'폴란드'),
(250,'fr','fra',N'프랑스'),
(242,'fj','fji',N'피지'),
(246,'fi','fin',N'핀란드'),
(608,'ph','phl',N'필리핀'),
(348,'hu','hun',N'헝가리')