CREATE TABLE list (id VARCHAR(64) NOT NULL, value VARCHAR(64) NOT NULL, PRIMARY KEY(id));

INSERT INTO "list" ("id", "value") VALUES ('YE', '也門');
INSERT INTO "list" ("id", "value") VALUES ('TT', '千里達和多巴哥');
INSERT INTO "list" ("id", "value") VALUES ('TR', '土耳其');
INSERT INTO "list" ("id", "value") VALUES ('TM', '土庫曼');
INSERT INTO "list" ("id", "value") VALUES ('BT', '不丹');
INSERT INTO "list" ("id", "value") VALUES ('CF', '中非共和國');
INSERT INTO "list" ("id", "value") VALUES ('CN', '中國');
INSERT INTO "list" ("id", "value") VALUES ('HK', '中國香港特別行政區');
INSERT INTO "list" ("id", "value") VALUES ('MO', '中國澳門特別行政區');
INSERT INTO "list" ("id", "value") VALUES ('DK', '丹麥');
INSERT INTO "list" ("id", "value") VALUES ('EC', '厄瓜多爾');
INSERT INTO "list" ("id", "value") VALUES ('ER', '厄立特里亞');
INSERT INTO "list" ("id", "value") VALUES ('BB', '巴巴多斯');
INSERT INTO "list" ("id", "value") VALUES ('PG', '巴布亞新幾內亞');
INSERT INTO "list" ("id", "value") VALUES ('BR', '巴西');
INSERT INTO "list" ("id", "value") VALUES ('PY', '巴拉圭');
INSERT INTO "list" ("id", "value") VALUES ('BH', '巴林');
INSERT INTO "list" ("id", "value") VALUES ('BS', '巴哈馬');
INSERT INTO "list" ("id", "value") VALUES ('PA', '巴拿馬');
INSERT INTO "list" ("id", "value") VALUES ('PS', '巴勒斯坦領土');
INSERT INTO "list" ("id", "value") VALUES ('PK', '巴基斯坦');
INSERT INTO "list" ("id", "value") VALUES ('JP', '日本');
INSERT INTO "list" ("id", "value") VALUES ('BE', '比利時');
INSERT INTO "list" ("id", "value") VALUES ('MR', '毛里塔尼亞');
INSERT INTO "list" ("id", "value") VALUES ('MU', '毛里裘斯');
INSERT INTO "list" ("id", "value") VALUES ('JM', '牙買加');
INSERT INTO "list" ("id", "value") VALUES ('TD', '乍得');
INSERT INTO "list" ("id", "value") VALUES ('IL', '以色列');
INSERT INTO "list" ("id", "value") VALUES ('CA', '加拿大');
INSERT INTO "list" ("id", "value") VALUES ('GH', '加納');
INSERT INTO "list" ("id", "value") VALUES ('GA', '加蓬');
INSERT INTO "list" ("id", "value") VALUES ('MP', '北馬利安納群島');
INSERT INTO "list" ("id", "value") VALUES ('MK', '北馬其頓');
INSERT INTO "list" ("id", "value") VALUES ('KP', '北韓');
INSERT INTO "list" ("id", "value") VALUES ('QA', '卡塔爾');
INSERT INTO "list" ("id", "value") VALUES ('CU', '古巴');
INSERT INTO "list" ("id", "value") VALUES ('TW', '台灣');
INSERT INTO "list" ("id", "value") VALUES ('NG', '尼日利亞');
INSERT INTO "list" ("id", "value") VALUES ('NE', '尼日爾');
INSERT INTO "list" ("id", "value") VALUES ('NI', '尼加拉瓜');
INSERT INTO "list" ("id", "value") VALUES ('NP', '尼泊爾');
INSERT INTO "list" ("id", "value") VALUES ('BF', '布基納法索');
INSERT INTO "list" ("id", "value") VALUES ('BI', '布隆迪');
INSERT INTO "list" ("id", "value") VALUES ('GP', '瓜地洛普');
INSERT INTO "list" ("id", "value") VALUES ('WF', '瓦利斯群島和富圖那群島');
INSERT INTO "list" ("id", "value") VALUES ('VU', '瓦努阿圖');
INSERT INTO "list" ("id", "value") VALUES ('BY', '白俄羅斯');
INSERT INTO "list" ("id", "value") VALUES ('PN', '皮特凱恩島');
INSERT INTO "list" ("id", "value") VALUES ('LT', '立陶宛');
INSERT INTO "list" ("id", "value") VALUES ('IQ', '伊拉克');
INSERT INTO "list" ("id", "value") VALUES ('IR', '伊朗');
INSERT INTO "list" ("id", "value") VALUES ('IS', '冰島');
INSERT INTO "list" ("id", "value") VALUES ('LI', '列支敦士登');
INSERT INTO "list" ("id", "value") VALUES ('HU', '匈牙利');
INSERT INTO "list" ("id", "value") VALUES ('ID', '印尼');
INSERT INTO "list" ("id", "value") VALUES ('IN', '印度');
INSERT INTO "list" ("id", "value") VALUES ('GT', '危地馬拉');
INSERT INTO "list" ("id", "value") VALUES ('DJ', '吉布提');
INSERT INTO "list" ("id", "value") VALUES ('KI', '吉里巴斯');
INSERT INTO "list" ("id", "value") VALUES ('KG', '吉爾吉斯');
INSERT INTO "list" ("id", "value") VALUES ('GY', '圭亞那');
INSERT INTO "list" ("id", "value") VALUES ('DO', '多米尼加共和國');
INSERT INTO "list" ("id", "value") VALUES ('DM', '多米尼克');
INSERT INTO "list" ("id", "value") VALUES ('TG', '多哥共和國');
INSERT INTO "list" ("id", "value") VALUES ('AI', '安奎拉');
INSERT INTO "list" ("id", "value") VALUES ('AO', '安哥拉');
INSERT INTO "list" ("id", "value") VALUES ('AG', '安提瓜和巴布達');
INSERT INTO "list" ("id", "value") VALUES ('AD', '安道爾');
INSERT INTO "list" ("id", "value") VALUES ('TK', '托克勞群島');
INSERT INTO "list" ("id", "value") VALUES ('BM', '百慕達');
INSERT INTO "list" ("id", "value") VALUES ('LA', '老撾');
INSERT INTO "list" ("id", "value") VALUES ('ES', '西班牙');
INSERT INTO "list" ("id", "value") VALUES ('EH', '西撒哈拉');
INSERT INTO "list" ("id", "value") VALUES ('BZ', '伯利茲');
INSERT INTO "list" ("id", "value") VALUES ('CV', '佛得角');
INSERT INTO "list" ("id", "value") VALUES ('HR', '克羅地亞');
INSERT INTO "list" ("id", "value") VALUES ('LR', '利比里亞');
INSERT INTO "list" ("id", "value") VALUES ('LY', '利比亞');
INSERT INTO "list" ("id", "value") VALUES ('GR', '希臘');
INSERT INTO "list" ("id", "value") VALUES ('BN', '汶萊');
INSERT INTO "list" ("id", "value") VALUES ('SA', '沙地阿拉伯');
INSERT INTO "list" ("id", "value") VALUES ('BJ', '貝寧');
INSERT INTO "list" ("id", "value") VALUES ('GQ', '赤道幾內亞');
INSERT INTO "list" ("id", "value") VALUES ('AM', '亞美尼亞');
INSERT INTO "list" ("id", "value") VALUES ('AZ', '亞塞拜疆');
INSERT INTO "list" ("id", "value") VALUES ('TZ', '坦桑尼亞');
INSERT INTO "list" ("id", "value") VALUES ('VE', '委內瑞拉');
INSERT INTO "list" ("id", "value") VALUES ('BD', '孟加拉');
INSERT INTO "list" ("id", "value") VALUES ('GM', '岡比亞');
INSERT INTO "list" ("id", "value") VALUES ('PW', '帛琉');
INSERT INTO "list" ("id", "value") VALUES ('SB', '所羅門群島');
INSERT INTO "list" ("id", "value") VALUES ('LV', '拉脫維亞');
INSERT INTO "list" ("id", "value") VALUES ('TL', '東帝汶');
INSERT INTO "list" ("id", "value") VALUES ('FR', '法國');
INSERT INTO "list" ("id", "value") VALUES ('FO', '法羅群島');
INSERT INTO "list" ("id", "value") VALUES ('GF', '法屬圭亞那');
INSERT INTO "list" ("id", "value") VALUES ('PF', '法屬波利尼西亞');
INSERT INTO "list" ("id", "value") VALUES ('TF', '法屬南部領地');
INSERT INTO "list" ("id", "value") VALUES ('MF', '法屬聖馬丁');
INSERT INTO "list" ("id", "value") VALUES ('PR', '波多黎各');
INSERT INTO "list" ("id", "value") VALUES ('BA', '波斯尼亞和黑塞哥維那');
INSERT INTO "list" ("id", "value") VALUES ('PL', '波蘭');
INSERT INTO "list" ("id", "value") VALUES ('GI', '直布羅陀');
INSERT INTO "list" ("id", "value") VALUES ('KE', '肯尼亞');
INSERT INTO "list" ("id", "value") VALUES ('FI', '芬蘭');
INSERT INTO "list" ("id", "value") VALUES ('AE', '阿拉伯聯合酋長國');
INSERT INTO "list" ("id", "value") VALUES ('AR', '阿根廷');
INSERT INTO "list" ("id", "value") VALUES ('OM', '阿曼');
INSERT INTO "list" ("id", "value") VALUES ('AF', '阿富汗');
INSERT INTO "list" ("id", "value") VALUES ('DZ', '阿爾及利亞');
INSERT INTO "list" ("id", "value") VALUES ('AL', '阿爾巴尼亞');
INSERT INTO "list" ("id", "value") VALUES ('AW', '阿魯巴');
INSERT INTO "list" ("id", "value") VALUES ('RU', '俄羅斯');
INSERT INTO "list" ("id", "value") VALUES ('BG', '保加利亞');
INSERT INTO "list" ("id", "value") VALUES ('GS', '南佐治亞島與南桑威奇群島');
INSERT INTO "list" ("id", "value") VALUES ('ZA', '南非');
INSERT INTO "list" ("id", "value") VALUES ('AQ', '南極洲');
INSERT INTO "list" ("id", "value") VALUES ('KR', '南韓');
INSERT INTO "list" ("id", "value") VALUES ('SS', '南蘇丹');
INSERT INTO "list" ("id", "value") VALUES ('KZ', '哈薩克');
INSERT INTO "list" ("id", "value") VALUES ('KH', '柬埔寨');
INSERT INTO "list" ("id", "value") VALUES ('ZW', '津巴布韋');
INSERT INTO "list" ("id", "value") VALUES ('HN', '洪都拉斯');
INSERT INTO "list" ("id", "value") VALUES ('BO', '玻利維亞');
INSERT INTO "list" ("id", "value") VALUES ('KW', '科威特');
INSERT INTO "list" ("id", "value") VALUES ('CC', '科科斯 (基林) 群島');
INSERT INTO "list" ("id", "value") VALUES ('CI', '科特迪瓦');
INSERT INTO "list" ("id", "value") VALUES ('KM', '科摩羅');
INSERT INTO "list" ("id", "value") VALUES ('TN', '突尼西亞');
INSERT INTO "list" ("id", "value") VALUES ('JO', '約旦');
INSERT INTO "list" ("id", "value") VALUES ('US', '美國');
INSERT INTO "list" ("id", "value") VALUES ('UM', '美國本土外小島嶼');
INSERT INTO "list" ("id", "value") VALUES ('VI', '美屬維爾京群島');
INSERT INTO "list" ("id", "value") VALUES ('AS', '美屬薩摩亞');
INSERT INTO "list" ("id", "value") VALUES ('GB', '英國');
INSERT INTO "list" ("id", "value") VALUES ('IO', '英屬印度洋領地');
INSERT INTO "list" ("id", "value") VALUES ('VG', '英屬維爾京群島');
INSERT INTO "list" ("id", "value") VALUES ('CG', '剛果（布拉薩）');
INSERT INTO "list" ("id", "value") VALUES ('CD', '剛果（金夏沙）');
INSERT INTO "list" ("id", "value") VALUES ('CO', '哥倫比亞');
INSERT INTO "list" ("id", "value") VALUES ('CR', '哥斯達黎加');
INSERT INTO "list" ("id", "value") VALUES ('EG', '埃及');
INSERT INTO "list" ("id", "value") VALUES ('ET', '埃塞俄比亞');
INSERT INTO "list" ("id", "value") VALUES ('CK', '庫克群島');
INSERT INTO "list" ("id", "value") VALUES ('CW', '庫拉索');
INSERT INTO "list" ("id", "value") VALUES ('NO', '挪威');
INSERT INTO "list" ("id", "value") VALUES ('GG', '根息');
INSERT INTO "list" ("id", "value") VALUES ('GD', '格林納達');
INSERT INTO "list" ("id", "value") VALUES ('GL', '格陵蘭');
INSERT INTO "list" ("id", "value") VALUES ('GE', '格魯吉亞');
INSERT INTO "list" ("id", "value") VALUES ('TH', '泰國');
INSERT INTO "list" ("id", "value") VALUES ('HT', '海地');
INSERT INTO "list" ("id", "value") VALUES ('UG', '烏干達');
INSERT INTO "list" ("id", "value") VALUES ('UA', '烏克蘭');
INSERT INTO "list" ("id", "value") VALUES ('UY', '烏拉圭');
INSERT INTO "list" ("id", "value") VALUES ('UZ', '烏茲別克');
INSERT INTO "list" ("id", "value") VALUES ('TC', '特克斯和凱科斯群島');
INSERT INTO "list" ("id", "value") VALUES ('RE', '留尼旺');
INSERT INTO "list" ("id", "value") VALUES ('PE', '秘魯');
INSERT INTO "list" ("id", "value") VALUES ('NA', '納米比亞');
INSERT INTO "list" ("id", "value") VALUES ('NZ', '紐西蘭');
INSERT INTO "list" ("id", "value") VALUES ('NU', '紐埃島');
INSERT INTO "list" ("id", "value") VALUES ('SO', '索馬里');
INSERT INTO "list" ("id", "value") VALUES ('MQ', '馬丁尼克');
INSERT INTO "list" ("id", "value") VALUES ('MT', '馬耳他');
INSERT INTO "list" ("id", "value") VALUES ('ML', '馬里');
INSERT INTO "list" ("id", "value") VALUES ('MY', '馬來西亞');
INSERT INTO "list" ("id", "value") VALUES ('MW', '馬拉維');
INSERT INTO "list" ("id", "value") VALUES ('YT', '馬約特');
INSERT INTO "list" ("id", "value") VALUES ('IM', '馬恩島');
INSERT INTO "list" ("id", "value") VALUES ('MH', '馬紹爾群島');
INSERT INTO "list" ("id", "value") VALUES ('MG', '馬達加斯加');
INSERT INTO "list" ("id", "value") VALUES ('MV', '馬爾代夫');
INSERT INTO "list" ("id", "value") VALUES ('FM', '密克羅尼西亞');
INSERT INTO "list" ("id", "value") VALUES ('CZ', '捷克');
INSERT INTO "list" ("id", "value") VALUES ('SY', '敘利亞');
INSERT INTO "list" ("id", "value") VALUES ('VA', '梵蒂岡');
INSERT INTO "list" ("id", "value") VALUES ('SX', '荷屬聖馬丁');
INSERT INTO "list" ("id", "value") VALUES ('NL', '荷蘭');
INSERT INTO "list" ("id", "value") VALUES ('BQ', '荷蘭加勒比區');
INSERT INTO "list" ("id", "value") VALUES ('MZ', '莫桑比克');
INSERT INTO "list" ("id", "value") VALUES ('BW', '博茨瓦納');
INSERT INTO "list" ("id", "value") VALUES ('CM', '喀麥隆');
INSERT INTO "list" ("id", "value") VALUES ('GN', '幾內亞');
INSERT INTO "list" ("id", "value") VALUES ('GW', '幾內亞比紹');
INSERT INTO "list" ("id", "value") VALUES ('FJ', '斐濟');
INSERT INTO "list" ("id", "value") VALUES ('SJ', '斯瓦爾巴特群島及揚馬延島');
INSERT INTO "list" ("id", "value") VALUES ('LK', '斯里蘭卡');
INSERT INTO "list" ("id", "value") VALUES ('SZ', '斯威士蘭');
INSERT INTO "list" ("id", "value") VALUES ('SI', '斯洛文尼亞');
INSERT INTO "list" ("id", "value") VALUES ('SK', '斯洛伐克');
INSERT INTO "list" ("id", "value") VALUES ('CL', '智利');
INSERT INTO "list" ("id", "value") VALUES ('TO', '湯加');
INSERT INTO "list" ("id", "value") VALUES ('PH', '菲律賓');
INSERT INTO "list" ("id", "value") VALUES ('VN', '越南');
INSERT INTO "list" ("id", "value") VALUES ('KY', '開曼群島');
INSERT INTO "list" ("id", "value") VALUES ('ME', '黑山');
INSERT INTO "list" ("id", "value") VALUES ('TJ', '塔吉克');
INSERT INTO "list" ("id", "value") VALUES ('SN', '塞內加爾');
INSERT INTO "list" ("id", "value") VALUES ('SC', '塞舌爾');
INSERT INTO "list" ("id", "value") VALUES ('SL', '塞拉利昂');
INSERT INTO "list" ("id", "value") VALUES ('CY', '塞浦路斯');
INSERT INTO "list" ("id", "value") VALUES ('RS', '塞爾維亞');
INSERT INTO "list" ("id", "value") VALUES ('AT', '奧地利');
INSERT INTO "list" ("id", "value") VALUES ('AX', '奧蘭群島');
INSERT INTO "list" ("id", "value") VALUES ('IT', '意大利');
INSERT INTO "list" ("id", "value") VALUES ('EE', '愛沙尼亞');
INSERT INTO "list" ("id", "value") VALUES ('IE', '愛爾蘭');
INSERT INTO "list" ("id", "value") VALUES ('SG', '新加坡');
INSERT INTO "list" ("id", "value") VALUES ('NC', '新喀里多尼亞');
INSERT INTO "list" ("id", "value") VALUES ('NR', '瑙魯');
INSERT INTO "list" ("id", "value") VALUES ('CH', '瑞士');
INSERT INTO "list" ("id", "value") VALUES ('SE', '瑞典');
INSERT INTO "list" ("id", "value") VALUES ('BL', '聖巴泰勒米');
INSERT INTO "list" ("id", "value") VALUES ('VC', '聖文森特和格林納丁斯');
INSERT INTO "list" ("id", "value") VALUES ('PM', '聖皮埃與密克隆群島');
INSERT INTO "list" ("id", "value") VALUES ('ST', '聖多美和普林西比');
INSERT INTO "list" ("id", "value") VALUES ('SM', '聖馬利諾');
INSERT INTO "list" ("id", "value") VALUES ('KN', '聖基茨和尼維斯');
INSERT INTO "list" ("id", "value") VALUES ('SH', '聖赫勒拿島');
INSERT INTO "list" ("id", "value") VALUES ('CX', '聖誕島');
INSERT INTO "list" ("id", "value") VALUES ('LC', '聖盧西亞');
INSERT INTO "list" ("id", "value") VALUES ('PT', '葡萄牙');
INSERT INTO "list" ("id", "value") VALUES ('TV', '圖瓦盧');
INSERT INTO "list" ("id", "value") VALUES ('FK', '福克蘭群島');
INSERT INTO "list" ("id", "value") VALUES ('MN', '蒙古');
INSERT INTO "list" ("id", "value") VALUES ('MS', '蒙特塞拉特');
INSERT INTO "list" ("id", "value") VALUES ('HM', '赫德島及麥唐納群島');
INSERT INTO "list" ("id", "value") VALUES ('DE', '德國');
INSERT INTO "list" ("id", "value") VALUES ('MA', '摩洛哥');
INSERT INTO "list" ("id", "value") VALUES ('MC', '摩納哥');
INSERT INTO "list" ("id", "value") VALUES ('MD', '摩爾多瓦');
INSERT INTO "list" ("id", "value") VALUES ('MM', '緬甸');
INSERT INTO "list" ("id", "value") VALUES ('LB', '黎巴嫩');
INSERT INTO "list" ("id", "value") VALUES ('MX', '墨西哥');
INSERT INTO "list" ("id", "value") VALUES ('JE', '澤西島');
INSERT INTO "list" ("id", "value") VALUES ('AU', '澳洲');
INSERT INTO "list" ("id", "value") VALUES ('RW', '盧旺達');
INSERT INTO "list" ("id", "value") VALUES ('LU', '盧森堡');
INSERT INTO "list" ("id", "value") VALUES ('NF', '諾福克島');
INSERT INTO "list" ("id", "value") VALUES ('LS', '賴索托');
INSERT INTO "list" ("id", "value") VALUES ('BV', '鮑威特島');
INSERT INTO "list" ("id", "value") VALUES ('SV', '薩爾瓦多');
INSERT INTO "list" ("id", "value") VALUES ('WS', '薩摩亞');
INSERT INTO "list" ("id", "value") VALUES ('RO', '羅馬尼亞');
INSERT INTO "list" ("id", "value") VALUES ('ZM', '贊比亞');
INSERT INTO "list" ("id", "value") VALUES ('GU', '關島');
INSERT INTO "list" ("id", "value") VALUES ('SD', '蘇丹');
INSERT INTO "list" ("id", "value") VALUES ('SR', '蘇里南');