CREATE TABLE `spk_country` ( `ccode` char(2) NOT NULL, `kor` varchar(255) NOT NULL, `eng` varchar(255) NOT NULL, PRIMARY KEY (`ccode`) ) ENGINE=InnoDB DEFAULT CHARSET=euckr; insert into `spk_country`(`ccode`,`kor`,`eng`) values ('-','SU','USSR'),('AD','안도라','ANDORRA'),('AE','아랍에미리트','UNITED ARAB EMIRATES'),('AF','아프가니스탄','AFGHANISTAN'),('AG','안티구아 바부다','ANTIGUA AND BARBUDA'),('AI','안길라','ANGUILLA'),('AL','알바니아','ALBANIA'),('AM','아르메니아','ARMENIA'),('AN','네덜란드령 안틸레스','NETHERLANDS ANTILLES'),('AO','앙골라','ANGOLA'),('AQ','남극','ANTARCTICA'),('AR','아르헨티나','ARGENTINA'),('AS','미국령 사모아','AMERICAN SAMOA'),('AT','오스트리아','AUSTRIA'),('AU','오스트레일리아','AUSTRALIA'),('AW','아루바','ARUBA'),('AZ','아제르바이잔','AZERBAIJAN'),('BA','보스니아 헤르체고비나','BOSNIA HERCEGOVINA'),('BB','바베이도스','BARBADOS'),('BD','방글라데시','BANGLADESH'),('BE','벨기에','BELGIUM'),('BF','부르키나파소','BURKINA FASO'),('BG','불가리아','BULGARIA'),('BH','바레인','BAHRAIN'),('BI','브룬디','BURUNDI'),('BJ','베넹','BENIN'),('BM','버뮤다','BERMUDA'),('BN','브루나이','BRUNEI DARUSSALAM'),('BO','볼리비아','BOLIVIA'),('BR','브라질','BRAZIL'),('BS','바하마','BAHAMAS'),('BT','부탄','BHUTAN'),('BV','부베이 섬','BOUVET ISLAND'),('BW','보트와나','BOTSWANA'),('BY','벨라루스','BELARUS'),('BZ','벨리즈','BELIZE'),('CA','캐나다','CANADA'),('CC','코코스킬링 제도','COCOS'),('CF','중앙 아프리카','CENTRAL AFRICAN REPUBLIC'),('CG','콩고','CONGO'),('CH','스위스','SWITZERLAND'),('CI','코트디부와르','COTE D\'IVOIRE'),('CK','쿠크 군도','COOK ISLANDS'),('CL','칠레','CHILE'),('CM','카메룬','CAMEROON'),('CN','중국','CHINA'),('CO','콜롬비아','COLOMBIA'),('CR','코스타리카','COSTA RICA'),('CS','체코슬로바키아','CZECHOSLOVAKIA'),('CU','쿠바','CUBA'),('CV','까뽀베르데','CAPE VERDE'),('CX','크리스마스 섬','CHRISTMAS ISLAND'),('CY','사이프러스','CYPRUS'),('CZ','체코','CZECH REPUBLIC'),('DE','독일','GERMANY'),('DJ','지부티','DJIBOUTI'),('DK','덴마크','DENMARK'),('DM','도미니카','DOMINICA'),('DO','도미니카 공화국','DOMINICAN REPUBLIC'),('DZ','알제리','ALGERIA'),('EC','에쿠아도르','ECUADOR'),('EE','에스토니아','ESTONIA'),('EG','이집트','EGYPT'),('EH','사하라','WESTERN SAHARA'),('ES','스페인','SPAIN'),('ET','이디오피아','ETHIOPIA'),('FI','핀란드','FINLAND'),('FJ','피지','FIJI'),('FK','포클랜드','FALKLAND ISLANDS'),('FM','마이크로네시아','MICRONESIA'),('FO','페로 군도','FAROE ISLANDS'),('FR','프랑스','FRANCE'),('GA','가봉','GABON'),('GB','영국','UNITED KINGDOM'),('GD','그레나다','GRENADA'),('GE','그루지야','GEORGIA'),('GF','프랑스령 기아나','FRENCH GUIANA'),('GH','가나','GHANA'),('GI','지브랄타','GIBRALTAR'),('GL','그린랜드','GREENLAND'),('GM','감비아','GAMBIA'),('GN','기니','GUINEA'),('GP','과달로프','GUADELOUPE'),('GQ','적도 기니','EQUATORIAL GUINEA'),('GR','그리스','GREECE'),('GT','과테말라','GUATEMALA'),('GU','괌','GUAM'),('GW','기네비쏘','GUINEA-BISSAU'),('GY','가이아나','GUYANA'),('HK','홍콩','HONG KONG'),('HM','허드섬 및 맥도날드 군도','HEARD AND MC DONALD ISLANDS'),('HN','온두라스','HONDURAS'),('HR','크로아티아','CROATIA'),('HT','아이티','HAITI'),('HU','헝가리','HUNGARY'),('ID','인도네시아','INDONESIA'),('IE','아일랜드','IRELAND'),('IL','이스라엘','ISRAEL'),('IN','인도','INDIA'),('IO','영인도 제도','BRITISH INDIAN OCEAN TERRITORY'),('IQ','이라크','IRAQ'),('IR','이란-이슬람공화국','IRAN'),('IS','아이슬랜드','ICELAND'),('IT','이탈리아','ITALY'),('JM','자메이카','JAMAICA'),('JO','요르단','JORDAN'),('JP','일본','JAPAN'),('KE','케냐','KENYA'),('KG','키르기스스탄','KYRGYZSTAN'),('KH','캄보디아','CAMBODIA'),('KI','키리바시','KIRIBATI'),('KM','코모르','COMOROS'),('KN','세인트 크리스토퍼 니비스','SAINT KITTS AND NEVIS'),('KP','북한','KOREA'),('KR','대한민국','KOREA'),('KW','쿠웨이트','KUWAIT'),('KY','카이만 군도','CAYMAN ISLANDS'),('KZ','카자흐스탄','KAZAKHSTAN'),('LA','라오스','LAO PEOPLE\'S DEMOCRATIC REPUBLIC'),('LB','레바논','LEBANON'),('LC','세인트 루시아','SAINT LUCIA'),('LI','리히텐슈타인','LIECHTENSTEIN'),('LK','스리랑카','SRI LANKA'),('LR','리베리아','LIBERIA'),('LS','레소토','LESOTHO'),('LT','리투아니아','LITHUANIA'),('LU','룩셈부르크','LUXEMBOURG'),('LV','라트비아','LATVIA'),('LY','리비아','LIBYAN ARAB JAMAHIRIYA'),('MA','모로코','MOROCCO'),('MC','모나코','MONACO'),('MD','몰도바','MOLDOVA'),('MG','마다가스카르','MADAGASCAR'),('MH','마샬 군도','MARSHALL ISLANDS'),('ML','말리','MALI'),('MM','미얀마','MYANMAR'),('MN','몽골','MONGOLIA'),('MO','마카오','MACAU'),('MP','북마리아나 군도','NORTHERN MARIANA ISLANDS'),('MQ','말티니크','MARTINIQUE'),('MR','말티니크','MAURITANIA'),('MS','몬트세라트','MONTSERRAT'),('MT','말타','MALTA'),('MU','모리셔스','MAURITIUS'),('MV','몰디브','MALDIVES'),('MW','말라위','MALAWI'),('MX','멕시코','MEXICO'),('MY','말레이지아','MALAYSIA'),('MZ','모잠비크','MOZAMBIQUE'),('NA','나미비아','NAMIBIA'),('NC','뉴칼레도니아','NEW CALEDONIA'),('NE','니제르','NIGER'),('NF','노퍽','NORFOLK ISLAND'),('NG','나이지리아','NIGERIA'),('NI','니카라과','NICARAGUA'),('NL','네덜란드','NETHERLANDS'),('NO','노르웨이','NORWAY'),('NP','네팔','NEPAL'),('NR','나우루','NAURU'),('NT','중립 지대','NEUTRAL ZONE'),('NU','니우에','NIUE'),('NZ','뉴질랜드','NEW ZEALAND'),('OM','오만','OMAN'),('PA','파나마','PANAMA'),('PE','페루','PERU'),('PF','프랑스령 폴리네시아','FRENCH POLYNESIA'),('PG','파푸아뉴기니','PAPUA NEW GUINEA'),('PH','필리핀','PHILIPPINES'),('PK','파키스탄','PAKISTAN'),('PL','폴란드','POLAND'),('PM','세인트 피에르 미퀠론','ST. PIERRE AND MIQUELON'),('PN','핏케언 군도','PITCAIRN'),('PR','푸에르토리코','PUERTO RICO'),('PT','포르투갈','PORTUGAL'),('PW','팔라우','PALAU'),('PY','파라과이','PARAGUAY'),('QA','카타르','QATAR'),('RE','리유니언','REUNION'),('RO','루마니아','ROMANIA'),('RU','러시아','RUSSIAN FEDERATION'),('RW','르완다','RWANDA'),('SA','사우디아라비아','SAUDI ARABIA'),('SB','솔로몬 군도','SOLOMON ISLANDS'),('SC','세이셸','SEYCHELLES'),('SD','수단','SUDAN'),('SE','스웨덴','SWEDEN'),('SG','싱가포르','SINGAPORE'),('SH','세인트 헬레나','ST. HELENA'),('SI','슬로베니아','SLOVENIA'),('SJ','스발바르드 얀마이엔 제도','SVALBARD AND JAN MAYEN ISLANDS'),('SK','슬로바키아','SLOVAKIA'),('SL','시에라리온','SIERRA LEONE'),('SM','산마리노','SAN MARINO'),('SN','세네갈','SENEGAL'),('SO','소말리아','SOMALIA'),('SR','수리남','SURINAME'),('ST','쌍투메 프린시페','SAO TOME AND PRINCIPE'),('SV','엘살바도르','EL SALVADOR'),('SY','시리아','SYRIAN ARAB REPUBLIC'),('SZ','스와질랜드','SWAZILAND'),('TC','터크스 카이코스 제도','TURKS AND CAICOS ISLANDS'),('TD','차드','CHAD'),('TF','프랑스 남부 지역','FRENCH SOUTHERN TERRITORIES'),('TG','토고','TOGO'),('TH','태국','THAILAND'),('TJ','타지키스탄','TAJIKISTAN'),('TK','토켈라우','TOKELAU'),('TM','투르크메니스탄','TURKMENISTAN'),('TN','튀니지','TUNISIA'),('TO','통가','TONGA'),('TP','동티모르','EAST TIMOR'),('TR','터어키','TURKEY'),('TT','트리니다드 토바고','TRINIDAD AND TOBAGO'),('TV','투발루','TUVALU'),('TW','PROVINCE OF CHINA - 대만','TAIWAN'),('TZ','UNITED REPUBLIC OF - 탄자니아','TANZANIA'),('UA','우크라이나','UKRAINE'),('UG','우간다','UGANDA'),('UM','미국령 소군도','UNITED STATES MINOR OUTLYING ISLANDS'),('US','미국','UNITED STATES'),('UY','우루과이','URUGUAY'),('UZ','우즈베키스탄','UZBEKISTAN'),('VA','HOLY SEE -바티칸','VATICAN CITY STATE'),('VC','세인트 빈센트 그레나딘스','SAINT VINCENT AND THE GRENADINES'),('VE','베네수엘라','VENEZUELA'),('VG','BRITISH -영국령 버진아일랜드','VIRGIN ISLANDS'),('VI','U.S. -미국령 버진아일랜드','VIRGIN ISLANDS'),('VN','베트남','VIET NAM'),('VU','바누아투','VANUATU'),('WF','월리스 후트나','WALLIS AND FUTUNA ISLANDS'),('WS','사모아','SAMOA'),('YE','REPUBLIC OF - 예멘','YEMEN'),('YU','유고슬라비아','YUGOSLAVIA'),('ZA','남아프리카','SOUTH AFRICA'),('ZM','잠비아','ZAMBIA'),('ZR','자이르','ZAIRE'),('ZW','짐바브웨','ZIMBABWE');