-- Copyright (c) 2010, Attigo (Hong Kong) Limited
-- All rights reserved.

-- Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

-- Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
-- Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
-- Neither the name of the Attigo (Hong Kong) Limited nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
-- THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.


CREATE TABLE `countries` (
  `id` int(11) NOT NULL auto_increment,
  `iso2` char(2) NOT NULL,
  `iso3` char(3) NOT NULL,
  `name` varchar(100) NOT NULL,
  `dialing_code` int(4) NOT NULL,
  `name_zh_cn` varchar(100) NOT NULL,
  `name_zh_tw` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) CHARSET=utf8;

INSERT INTO `countries` VALUES (1,'AF','AFG','Afghanistan',93,'阿富汗','阿富汗'),(2,'AX','ALA','Aland Islands',0,'奥兰群岛','奧蘭群島'),(3,'AL','ALB','Albania',355,'阿尔巴尼亚','阿爾巴尼亞'),(4,'DZ','DZA','Algeria',213,'阿尔及利亚','阿爾及利亞'),(5,'AS','ASM','American Samoa',1,'美属萨摩亚','美屬薩摩亞'),(6,'AD','AND','Andorra',376,'安道尔共和国','安道爾共和國'),(7,'AO','AGO','Angola',244,'安哥拉','安哥拉'),(8,'AI','AIA','Anguilla',1,'安圭拉岛','安圭拉島'),(9,'AQ','ATA','Antarctica',0,'南极洲','南極洲'),(10,'AG','ATG','Antigua and Barbuda',1,'安提瓜和巴布达','安提瓜和巴布達'),(11,'AR','ARG','Argentina',54,'阿根廷','阿根廷'),(12,'AM','ARM','Armenia',374,'亚美尼亚','亞美尼亞'),(13,'AW','ABW','Aruba',297,'阿鲁巴岛','阿魯巴島'),(14,'AU','AUS','Australia',61,'澳大利亚','澳大利亞'),(15,'AT','AUT','Austria',43,'奥地利','奧地利'),(16,'AZ','AZE','Azerbaijan',994,'阿塞拜疆','阿塞拜疆'),(17,'BS','BHS','Bahamas',1,'巴哈马群岛','巴哈馬群島'),(18,'BH','BHR','Bahrain',973,'巴林','巴林'),(19,'BD','BGD','Bangladesh',880,'孟加拉共和国','孟加拉共和國'),(20,'BB','BRB','Barbados',1,'巴巴多斯岛','巴巴多斯島'),(21,'BY','BLR','Belarus',375,'白俄罗斯','白俄羅斯'),(22,'BE','BEL','Belgium',32,'比利时','比利時'),(23,'BZ','BLZ','Belize',501,'伯利兹城(洪都拉斯首都)','伯利茲城洪都拉斯首都'),(24,'BJ','BEN','Benin',229,'贝宁湾','貝甯灣'),(25,'BM','BMU','Bermuda',1,'百慕大群岛','百慕大群島'),(26,'BT','BTN','Bhutan',975,'不丹','不丹'),(27,'BO','BOL','Bolivia',591,'玻利维亚','玻利維亞'),(28,'BA','BIH','Bosnia and Herzegovina',387,'波斯尼亚和黑塞哥维那','波斯尼亞和黑塞哥維那'),(29,'BW','BWA','Botswana',267,'博茨瓦纳','博茨瓦納'),(30,'BV','BVT','Bouvet Island',0,'布韦岛','布韋島'),(31,'BR','BRA','Brazil',55,'巴西','巴西'),(32,'IO','IOT','British Indian Ocean Territory',1,'英属印度洋领地','英屬印度洋領地'),(33,'BN','BRN','Brunei Darussalam',673,'文莱达鲁萨兰国','文萊達魯薩蘭國'),(34,'BG','BGR','Bulgaria',359,'保加利亚','保加利亞'),(35,'BF','BFA','Burkina Faso',226,'布基纳法索','布基納法索'),(36,'BI','BDI','Burundi',257,'布隆迪','布隆迪'),(37,'KH','KHM','Cambodia',855,'柬埔寨','柬埔寨'),(38,'CM','CMR','Cameroon',237,'喀麦隆','喀麥隆'),(39,'CA','CAN','Canada',1,'加拿大','加拿大'),(40,'CV','CPV','Cape Verde',238,'佛得角','佛得角'),(41,'KY','CYM','Cayman Islands',1,'开曼群岛','開曼群島'),(42,'CF','CAF','Central African Republic',236,'中非共和国','中非共和國'),(43,'TD','TCD','Chad',235,'乍得湖','乍得湖'),(44,'CL','CHL','Chile',56,'智利','智利'),(45,'CN','CHN','China',86,'中国','中國'),(46,'CX','CXR','Christmas Island',0,'圣诞岛','聖誕島'),(47,'CC','CCK','Cocos (Keeling) Islands',0,'科科斯群岛','科科斯群島'),(48,'CO','COL','Colombia',57,'哥伦比亚','哥倫比亞'),(49,'KM','COM','Comoros',269,' 科摩罗（非洲）','科摩羅（非洲）'),(50,'CG','COG','Congo',242,'刚果','剛果'),(51,'CD','COD','Congo, Democratic Republic of the',243,'刚果民主共和国','剛果民主共和國'),(52,'CK','COK','Cook Islands',682,'库克群岛','庫克群島'),(53,'CR','CRI','Costa Rica',506,'哥斯达黎加','哥斯達黎加'),(54,'CI','CIV','Côte d\'Ivoire',225,'科特迪瓦','科特迪瓦'),(55,'HR','HRV','Croatia',385,'克罗地亚','克羅地亞'),(56,'CU','CUB','Cuba',53,'古巴','古巴'),(57,'CY','CYP','Cyprus',357,'塞浦路斯','塞浦路斯'),(58,'CZ','CZE','Czech Republic',420,'捷克共和国','捷克共和國'),(59,'DK','DNK','Denmark',45,' 丹麦','丹麥'),(60,'DJ','DJI','Djibouti',253,'吉布提(非洲)','吉布提非洲'),(61,'DM','DMA','Dominica',1,'多米尼加','多米尼加'),(62,'DO','DOM','Dominican Republic',1,'多米尼加共和国','多米尼加共和國'),(63,'EC','ECU','Ecuador',593,'厄瓜多尔','厄瓜多爾'),(64,'EG','EGY','Egypt',20,'埃及','埃及'),(65,'SV','SLV','El Salvador',503,'萨尔瓦多','薩爾瓦多'),(66,'GQ','GNQ','Equatorial Guinea',240,'赤道几内亚','赤道幾內亞'),(67,'ER','ERI','Eritrea',291,'厄立特里亚','厄立特裏亞'),(68,'EE','EST','Estonia',372,'爱沙尼亚','愛沙尼亞'),(69,'ET','ETH','Ethiopia',251,'埃塞俄比亚','埃塞俄比亞'),(70,'FK','FLK','Falkland Islands (Malvinas)',500,'福克兰（马尔维纳斯）群岛','福克蘭（馬爾維納斯）群島'),(71,'FO','FRO','Faroe Islands',298,'法罗群岛','法羅群島'),(72,'FJ','FJI','Fiji',679,'斐济','斐濟'),(73,'FI','FIN','Finland',358,'芬兰','芬蘭'),(74,'FR','FRA','France',33,'法国','法國'),(75,'GF','GUF','French Guiana',594,'法属圭亚那','法屬圭亞那'),(76,'PF','PYF','French Polynesia',689,'法属玻利尼西亚','法屬玻利尼西亞'),(77,'TF','ATF','French Southern Territories',262,'法属南部领土','法屬南部領土'),(78,'GA','GAB','Gabon',241,'加蓬','加蓬'),(79,'GM','GMB','Gambia',220,'冈比亚','岡比亞'),(80,'GE','GEO','Georgia',995,'格鲁吉亚','格魯吉亞'),(81,'DE','DEU','Germany',49,'德国','德國'),(82,'GH','GHA','Ghana',233,'加纳','加納'),(83,'GI','GIB','Gibraltar',350,'直布罗陀','直布羅陀'),(84,'GR','GRC','Greece',30,'希腊','希臘'),(85,'GL','GRL','Greenland',299,'格林兰','格林蘭'),(86,'GD','GRD','Grenada',1,'格林纳达','格林納達'),(87,'GP','GLP','Guadeloupe',590,'瓜德罗普岛','瓜德羅普島'),(88,'GU','GUM','Guam',1,'关岛','關島'),(89,'GT','GTM','Guatemala',502,'危地马拉','危地馬拉'),(90,'GG','GGY','Guernsey',0,'根西岛','根西島'),(91,'GN','GIN','Guinea',224,'几内亚共和国','幾內亞共和國'),(92,'GW','GNB','Guinea-Bissau',245,'几内亚比绍共和国','-幾內亞比紹共和國'),(93,'GY','GUY','Guyana',592,'圭亚那(拉丁美洲)','圭亞那拉丁美洲'),(94,'HT','HTI','Haiti',509,'海地','海地'),(95,'HM','HMD','Heard Island and McDonald Islands',0,' 赫德岛和麦克唐纳岛','赫德島和麥克唐納島'),(96,'VA','VAT','Holy See (Vatican City State)',0,'梵蒂冈','梵蒂岡'),(97,'HN','HND','Honduras',504,'宏都拉斯','宏都拉斯'),(98,'HK','HKG','Hong Kong',852,'中国香港','中國香港'),(99,'HU','HUN','Hungary',36,'匈牙利','匈牙利'),(100,'IS','ISL','Iceland',354,'冰岛','冰島'),(101,'IN','IND','India',91,'印度','印度'),(102,'ID','IDN','Indonesia',62,'印度尼西亚','印度尼西亞'),(103,'IR','IRN','Iran, Islamic Republic of',98,'伊朗伊斯兰共和国','伊朗伊斯蘭共和國'),(104,'IQ','IRQ','Iraq',964,'伊拉克共和国','伊拉克共和國'),(105,'IE','IRL','Ireland',353,'爱尔兰','愛爾蘭'),(106,'IM','IMN','Isle of Man',0,'马恩岛','馬恩島'),(107,'IL','ISR','Israel',972,'以色列','以色列'),(108,'IT','ITA','Italy',39,'意大利','意大利'),(109,'JM','JAM','Jamaica',1,'牙买加','牙買加'),(110,'JP','JPN','Japan',81,'日本','日本'),(111,'JE','JEY','Jersey',0,'泽西岛','澤西島'),(112,'JO','JOR','Jordan',962,'约旦','約旦'),(113,'KZ','KAZ','Kazakhstan',7,'哈萨克斯坦','哈薩克斯坦'),(114,'KE','KEN','Kenya',254,'肯尼亚','肯尼亞'),(115,'KI','KIR','Kiribati',686,'基里巴斯','基裏巴斯'),(116,'KP','PRK','Korea, Democratic People\'s Republic of',850,'朝鲜民主主义人民共和国','朝鮮民主主義人民共和國'),(117,'KR','KOR','Korea, Republic of',82,'韩国','韓國'),(118,'KW','KWT','Kuwait',965,'科威特','科威特'),(119,'KG','KGZ','Kyrgyzstan',996,'吉尔吉斯斯坦','吉爾吉斯斯坦'),(120,'LA','LAO','Lao People\'s Democratic Republic',856,'老挝','老撾'),(121,'LV','LVA','Latvia',371,'拉脱维亚','拉脫維亞'),(122,'LB','LBN','Lebanon',961,'黎巴嫩','黎巴嫩'),(123,'LS','LSO','Lesotho',266,'莱索托','萊索托'),(124,'LR','LBR','Liberia',231,'利比里亚','利比裏亞'),(125,'LY','LBY','Libyan Arab Jamahiriya',218,'阿拉伯利比亚民众国','阿拉伯利比亞民衆國'),(126,'LI','LIE','Liechtenstein',423,'列支敦士登','列支敦士登'),(127,'LT','LTU','Lithuania',370,'立陶宛','立陶宛'),(128,'LU','LUX','Luxembourg',352,'卢森堡公国','盧森堡公國'),(129,'MO','MAC','Macao',853,'中国澳门','中國澳門'),(130,'MK','MKD','Macedonia, the former Yugoslav Republic of',0,'前南马其顿','前南馬其頓'),(131,'MG','MDG','Madagascar',261,'马达加斯加岛','馬達加斯加島'),(132,'MW','MWI','Malawi',265,'马拉维(非洲国家)','馬拉維非洲國家'),(133,'MY','MYS','Malaysia',60,'马来西亚','馬來西亞'),(134,'MV','MDV','Maldives',960,'马尔代夫(群岛)','馬爾代夫群島'),(135,'ML','MLI','Mali',223,'马里','馬裏'),(136,'MT','MLT','Malta',356,'马耳他(地中海的岛国)','馬耳他地中海的島國'),(137,'MH','MHL','Marshall Islands',692,'马绍尔群岛','馬紹爾群島'),(138,'MQ','MTQ','Martinique',596,'马提尼克岛','馬提尼克島'),(139,'MR','MRT','Mauritania',222,'毛利塔尼亚','毛利塔尼亞'),(140,'MU','MUS','Mauritius',230,'毛里求斯','毛裏求斯'),(141,'YT','MYT','Mayotte',269,'马约特岛','馬約特島'),(142,'MX','MEX','Mexico',52,'墨西哥','墨西哥'),(143,'FM','FSM','Micronesia, Federated States of',691,'密克罗尼西亚','密克羅尼西亞'),(144,'MD','MDA','Moldova',373,'摩尔多瓦','摩爾多瓦'),(145,'MC','MCO','Monaco',377,'摩纳哥','摩納哥'),(146,'MN','MNG','Mongolia',976,' 蒙古','蒙古'),(147,'ME','MNE','Montenegro',382,'黑山共和国','黑山共和國'),(148,'MS','MSR','Montserrat',1,'蒙特塞拉特岛','蒙特塞拉特島'),(149,'MA','MAR','Morocco',212,'摩洛哥','摩洛哥'),(150,'MZ','MOZ','Mozambique',258,'莫桑比克','莫桑比克'),(151,'MM','MMR','Myanmar',95,'缅甸','緬甸'),(152,'NA','NAM','Namibia',264,'纳米比亚','納米比亞'),(153,'NR','NRU','Nauru',674,' 瑙鲁','瑙魯'),(154,'NP','NPL','Nepal',977,'尼泊尔','尼泊爾'),(155,'NL','NLD','Netherlands',31,'荷兰','荷蘭'),(156,'AN','ANT','Netherlands Antilles',599,'荷属安的列斯群岛','荷屬安的列斯群島'),(157,'NC','NCL','New Caledonia',687,'新喀里多尼亚','新喀裏多尼亞'),(158,'NZ','NZL','New Zealand',64,'新西兰','新西蘭'),(159,'NI','NIC','Nicaragua',505,'尼加拉瓜','尼加拉瓜'),(160,'NE','NER','Niger',227,'尼日尔','尼日爾'),(161,'NG','NGA','Nigeria',234,'尼日利亚','尼日利亞'),(162,'NU','NIU','Niue',683,'纽埃岛','紐埃島'),(163,'NF','NFK','Norfolk Island',0,'诺福克岛','諾福克島'),(164,'MP','MNP','Northern Mariana Islands',1,'北马里亚纳群岛','北馬裏亞納群島'),(165,'NO','NOR','Norway',47,'挪威','挪威'),(166,'OM','OMN','Oman',968,'阿曼','阿曼'),(167,'PK','PAK','Pakistan',92,'巴基斯坦','巴基斯坦'),(168,'PW','PLW','Palau',680,'帕劳群岛','帕勞群島'),(169,'PS','PSE','Palestinian Territory, Occupied',0,' 巴勒斯坦国','巴勒斯坦國'),(170,'PA','PAN','Panama',507,'巴拿马','巴拿馬'),(171,'PG','PNG','Papua New Guinea',675,'巴布亚新几内亚','巴布亞新幾內亞'),(172,'PY','PRY','Paraguay',595,'巴拉圭','巴拉圭'),(173,'PE','PER','Peru',51,'秘鲁','秘魯'),(174,'PH','PHL','Philippines',63,'菲律宾共和国','菲律賓共和國'),(175,'PN','PCN','Pitcairn',0,'皮特克恩','皮特克恩'),(176,'PL','POL','Poland',48,'波兰','波蘭'),(177,'PT','PRT','Portugal',351,'葡萄牙','葡萄牙'),(178,'PR','PRI','Puerto Rico',1,'波多黎各','波多黎各'),(179,'QA','QAT','Qatar',974,'卡塔尔','卡塔爾'),(180,'RE','REU','R閡nion',0,'','閡'),(181,'RO','ROU','Romania',40,'罗马尼亚','羅馬尼亞'),(182,'RU','RUS','Russian Federation',7,'俄罗斯联邦','俄羅斯聯邦'),(183,'RW','RWA','Rwanda',250,'卢旺达','盧旺達'),(184,'BL','BLM','Saint Barth閘emy',0,'','閘'),(185,'SH','SHN','Saint Helena',290,'圣赫勒拿','聖赫勒拿'),(186,'KN','KNA','Saint Kitts and Nevis',1,'圣克里斯多福与尼维斯岛','聖克裏斯多福與尼維斯島'),(187,'LC','LCA','Saint Lucia',1,'圣卢西亚岛','聖盧西亞島'),(188,'MF','MAF','Saint Martin (French part)',0,'法属圣马丁','法屬聖馬丁'),(189,'PM','SPM','Saint Pierre and Miquelon',508,'法属圣皮埃尔和密克隆','法屬聖皮埃爾和密克隆'),(190,'VC','VCT','Saint Vincent and the Grenadines',1,'圣文森特和格林纳丁斯','聖文森特和格林納丁斯'),(191,'WS','WSM','Samoa',685,'萨摩亚群岛','薩摩亞群島'),(192,'SM','SMR','San Marino',378,'圣马力诺','聖馬力諾'),(193,'ST','STP','Sao Tome and Principe',239,'圣多美和普林西比','聖多美和普林西比'),(194,'SA','SAU','Saudi Arabia',966,'沙特阿拉伯','沙特阿拉伯'),(195,'SN','SEN','Senegal',221,'塞内加尔','塞內加爾'),(196,'RS','SRB','Serbia',381,'塞尔维亚','塞爾維亞'),(197,'SC','SYC','Seychelles',248,'塞舌尔','塞舌爾'),(198,'SL','SLE','Sierra Leone',232,'塞拉利昂','塞拉利昂'),(199,'SG','SGP','Singapore',65,'新加坡','新加坡'),(200,'SK','SVK','Slovak',421,'斯洛伐克','斯洛伐克'),(201,'SI','SVN','Slovenia',386,'斯洛文尼亚','斯洛文尼亞'),(202,'SB','SLB','Solomon Islands',677,'所罗门群岛','所羅門群島'),(203,'SO','SOM','Somalia',252,'索马里','索馬裏'),(204,'ZA','ZAF','South Africa',27,'南非','南非'),(205,'GS','SGS','South Georgia and the South Sandwich Islands',0,' 南乔治亚与南三文治群岛','南喬治亞與南三文治群島'),(206,'ES','ESP','Spain',34,'西班牙','西班牙'),(207,'LK','LKA','Sri Lanka',94,'斯里兰卡民主社会主义共和国','斯裏蘭卡民主社會主義共和國'),(208,'SD','SDN','Sudan',249,'苏丹共和国','蘇丹共和國'),(209,'SR','SUR','Suriname',597,'苏里南共和国','蘇裏南共和國'),(210,'SJ','SJM','Svalbard and Jan Mayen',0,'斯瓦尔巴岛和扬马延岛','斯瓦爾巴島和揚馬延島'),(211,'SZ','SWZ','Swaziland',268,'斯威士兰王国','斯威士蘭王國'),(212,'SE','SWE','Sweden',46,'瑞典','瑞典'),(213,'CH','CHE','Switzerland',41,'瑞士','瑞士'),(214,'SY','SYR','Syrian Arab Republic',963,'阿拉伯叙利亚共和国','阿拉伯敘利亞共和國'),(215,'TW','TWN','Taiwan, Province of China',886,'中国台湾','中國台灣'),(216,'TJ','TJK','Tajikistan',992,'塔吉克斯坦','塔吉克斯坦'),(217,'TZ','TZA','Tanzania, United Republic of',255,'坦桑尼亚联合共和国','坦桑尼亞聯合共和國'),(218,'TH','THA','Thailand',66,'泰国','泰國'),(219,'TL','TLS','Timor-Leste',0,'东帝汶','-東帝汶'),(220,'TG','TGO','Togo',228,'多哥共和国','多哥共和國'),(221,'TK','TKL','Tokelau',690,'托克劳群岛','托克勞群島'),(222,'TO','TON','Tonga',676,'汤加王国','湯加王國'),(223,'TT','TTO','Trinidad and Tobago',1,'特立尼达和多巴哥','特立尼達和多巴哥'),(224,'TN','TUN','Tunisia',216,'突尼斯','突尼斯'),(225,'TR','TUR','Turkey',90,'土耳其','土耳其'),(226,'TM','TKM','Turkmenistan',993,'土库曼斯坦','土庫曼斯坦'),(227,'TC','TCA','Turks and Caicos Islands',1,'特克斯和凯科斯群岛','特克斯和凱科斯群島'),(228,'TV','TUV','Tuvalu',688,'图瓦卢','圖瓦盧'),(229,'UG','UGA','Uganda',256,'乌干达共和国','烏幹達共和國'),(230,'UA','UKR','Ukraine',380,'乌克兰','烏克蘭'),(231,'AE','ARE','United Arab Emirates',971,'阿拉伯联合酋长国','阿拉伯聯合酋長國'),(232,'GB','GBR','United Kingdom of Great Britain and Northern Ireland',44,'英国','英國'),(233,'US','USA','United States of America',1,'美国','美國'),(234,'UM','UMI','United States Minor Outlying Islands',0,'美国本土外小岛屿','美國本土外小島嶼'),(235,'UY','URY','Uruguay',598,'乌拉圭','烏拉圭'),(236,'UZ','UZB','Uzbekistan',998,'乌兹别克斯坦','烏茲別克斯坦'),(237,'VU','VUT','Vanuatu',678,'瓦努阿图','瓦努阿圖'),(238,'VE','VEN','Venezuela',58,'委内瑞拉','委內瑞拉'),(239,'VN','VNM','Viet Nam',84,'越南','越南'),(240,'VG','VGB','Virgin Islands, British',0,'英属维尔京群岛','英屬維爾京群島'),(241,'VI','VIR','Virgin Islands, U.S.',0,'维尔京群岛（美国）','維爾京群島（美國）'),(242,'WF','WLF','Wallis and Futuna',681,'瓦利斯群岛和富图纳群岛（法属）','瓦利斯群島和富圖納群島（法屬）'),(243,'EH','ESH','Western Sahara',0,'西撒哈拉','西撒哈拉'),(244,'YE','YEM','Yemen',967,'也门','也門'),(245,'ZM','ZMB','Zambia',260,'赞比亚','贊比亞'),(246,'ZW','ZWE','Zimbabwe',263,'津巴布韦','津巴布韋');