世界各国城市级联数据库，有英文，精确到区域

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50540 Source Host : localhost:3306 Source Database : travel Target Server Type : MYSQL Target Server Version : 50540 File Encoding : 65001 Date: 2016-09-07 10:43:50 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for travel_area -- ---------------------------- DROP TABLE IF EXISTS `travel_area`; CREATE TABLE `travel_area` ( `area_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', `area_parent_id` int(11) unsigned DEFAULT '0' COMMENT '父ID', `path` varchar(255) DEFAULT NULL COMMENT '路径', `area_deep` int(11) unsigned DEFAULT NULL COMMENT '层级', `area_name` varchar(255) DEFAULT NULL COMMENT '中文名称', `name_en` varchar(255) DEFAULT NULL COMMENT '英文名称', `name_pinyin` varchar(255) DEFAULT NULL COMMENT '中文拼音', `code` varchar(50) DEFAULT NULL COMMENT '代码', PRIMARY KEY (`area_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6931 DEFAULT CHARSET=utf8 COMMENT='全球地区库，采集自腾讯QQ国内+国际版.ADD.JENA.20141221'; -- ---------------------------- -- Records of travel_area -- ---------------------------- INSERT INTO `travel_area` VALUES ('1', '0', ',1,', '1', '亚洲', 'Asia', 'yazhou', null); INSERT INTO `travel_area` VALUES ('2', '0', ',2,', '1', '欧洲', 'Europe', 'ouzhou', null); INSERT INTO `travel_area` VALUES ('3', '0', ',3,', '1', '非洲', 'Africa', 'feizhou', null); INSERT INTO `travel_area` VALUES ('4', '0', ',4,', '1', '北美', 'North America', 'beimei', null); INSERT INTO `travel_area` VALUES ('5', '0', ',5,', '1', '南美', 'South America', 'nanmei', null); INSERT INTO `travel_area` VALUES ('6', '0', ',6,', '1', '大洋洲', 'Oceania', 'dayangzhou', null); INSERT INTO `travel_area` VALUES ('7', '1', ',1,7,', '2', '中国', 'China', 'zhongguo', 'CN'); INSERT INTO `travel_area` VALUES ('8', '2', ',2,8,', '2', '阿尔巴尼亚', 'Albania', 'aerbaniya', 'ALB'); INSERT INTO `travel_area` VALUES ('9', '3', ',3,9,', '2', '阿尔及利亚', 'Algeria', 'aerjiliya', 'DZA'); INSERT INTO `travel_area` VALUES ('10', '1', ',1,10,', '2', '阿富汗', 'Afghanistan', 'afuhan', 'AFG'); INSERT INTO `travel_area` VALUES ('11', '5', ',5,11,', '2', '阿根廷', 'Argentina', 'agenting', 'ARG'); INSERT INTO `travel_area` VALUES ('12', '1', ',1,12,', '2', '阿拉伯联合酋长国', 'United Arab Emirates', 'alabolianheqiuchangguo', 'ARE'); INSERT INTO `travel_area` VALUES ('13', '5', ',5,13,', '2', '阿鲁巴', 'Aruba', 'aluba', 'ABW'); INSERT INTO `travel_area` VALUES ('14', '1', ',1,14,', '2', '阿曼', 'Oman', 'aman', 'OMN'); INSERT INTO `travel_area` VALUES ('15', '1', ',1,15,', '2', '阿塞拜疆', 'Azerbaijan', 'asaibaijiang', 'AZE'); INSERT INTO `travel_area` VALUES ('16', '3', ',3,16,', '2', '阿森松岛', 'Ascension Island', 'asensongdao', 'ASC'); INSERT INTO `travel_area` VALUES ('17', '3', ',3,17,', '2', '埃及', 'Egypt', 'aiji', 'EGY'); INSERT INTO `travel_area` VALUES ('18', '3', ',3,18,', '2', '埃塞俄比亚', 'Ethiopia', 'aisaiebiya', 'ETH'); INSERT INTO `travel_area` VALUES ('19', '2', ',2,19,', '2', '爱尔兰', 'Ireland', 'aierlan', 'IRL'); INSERT INTO `travel_area` VALUES ('20', '2', ',2,20,', '2', '爱沙尼亚', 'Estonia', 'aishaniya', 'EST'); INSERT INTO `travel_area` VALUES ('21', '2', ',2,21,', '2', '安道尔', 'Andorra', 'andaoer', 'AND'); INSERT INTO `travel_area` VALUES ('22', '3', ',3,22,', '2', '安哥拉', 'Angola', 'angela', 'AGO'); INSERT INTO `travel_area` VALUES ('23', '5', ',5,23,', '2', '安圭拉', 'Anguilla', 'anguila', 'AIA'); INSERT INTO `travel_area` VALUES ('24', '4', ',4,24,', '2', '安提瓜岛和巴布达', 'Antigua and Barbuda', 'antiguadaohebabuda', 'ATG'); INSERT INTO `travel_area` VALUES ('25', '6', ',6,25,', '2', '澳大利亚', 'Australia', 'aodaliya', 'AUS'); INSERT INTO `travel_area` VALUES ('26', '2', ',2,26,', '2', '奥地利', 'Austria', 'aodili', 'AUT'); INSERT INTO `travel_area` VALUES ('27', '2', ',2,27,', '2', '奥兰群岛', 'Aland lslands', 'aolanqundao', 'ALA'); INSERT INTO `travel_area` VALUES ('28', '5', ',5,28,', '2', '巴巴多斯岛', 'Barbados', 'babaduosidao', 'BRB'); INSERT INTO `travel_area` VALUES ('29', '6', ',6,29,', '2', '巴布亚新几内亚', 'Papua New Guinea', 'babuyaxinjineiya', 'PNG'); INSERT INTO `travel_area` VALUES ('30', '4', ',4,30,', '2', '巴哈马', 'Bahamas', 'bahama', 'BHS'); INSERT INTO `travel_area` VALUES ('31', '1', ',1,31,', '2', '巴基斯坦', 'Pakistan', 'bajisitan', 'PAK'); INSERT INTO `travel_area` VALUES ('32', '5', ',5,32,', '2', '巴拉圭', 'Paraguay', 'balagui', 'PRY'); INSERT INTO `travel_area` VALUES ('33', '1', ',1,33,', '2', '巴勒斯坦', 'Palestinian Authority', 'balesitan', 'PSE'); INSERT INTO `travel_area` VALUES ('34', '1', ',1,34,', '2', '巴林', 'Bahrain', 'balin', 'BHR'); INSERT INTO `travel_area` VALUES ('35', '4', ',4,35,', '2', '巴拿马', 'Panama', 'banama', 'PAN'); INSERT INTO `travel_area` VALUES ('36', '5', ',5,36,', '2', '巴西', 'Brazil', 'baxi', 'BRA'); INSERT INTO `travel_area` VALUES ('37', '2', ',2,37,', '2', '白俄罗斯', 'White Russia', 'baieluosi', 'BLR'); INSERT INTO `travel_area` VALUES ('38', '4', ',4,38,', '2', '百慕大', 'Bermuda', 'baimuda', 'BMU'); INSERT INTO `travel_area` VALUES ('39', '2', ',2,39,', '2', '保加利亚', 'Bulgaria', 'baojialiya', 'BGR'); INSERT INTO `travel_area` VALUES ('40', '4', ',4,40,', '2', '北马里亚纳群岛', 'Northern Mariana Islands', 'beimaliyanaqundao', 'MNP'); INSERT INTO `travel_area` VALUES ('41', '3', ',3,41,', '2', '贝宁', 'Benin', 'beining', 'BEN'); INSERT INTO `travel_area` VALUES ('42', '2', ',2,42,', '2', '比利时', 'Belgium', 'bilishi', 'BEL'); INSERT INTO `travel_area` VALUES ('43', '2', ',2,43,', '2', '冰岛', 'Iceland', 'bingdao', 'ISL'); INSERT INTO `travel_area` VALUES ('44', '4', ',4,44,', '2', '波多黎各', 'Puerto Rico', 'boduolige', 'PRI'); INSERT INTO `travel_area` VALUES ('45', '2', ',2,45,', '2', '波兰', 'Poland', 'bolan', 'POL'); INSERT INTO `travel_area` VALUES ('46', '5', ',5,46,', '2', '玻利维亚', 'Bolivia', 'boliweiya', 'BOL'); INSERT INTO `travel_area` VALUES ('47', '2', ',2,47,', '2', '波斯尼亚和黑塞哥维那', 'Bosnia and Herzegovina', 'bosiniyaheheisaigeweina', 'BIH'); INSERT INTO `travel_area` VALUES ('48', '3', ',3,48,', '2', '博茨瓦纳', 'Botswana', 'bociwana', 'BWA'); INSERT INTO `travel_area` VALUES ('49', '4', ',4,49,', '2', '伯利兹', 'Belize', 'bolizi', 'BLZ'); INSERT INTO `travel_area` VALUES ('50', '1', ',1,50,', '2', '不丹', 'Bhutan', 'budan', 'BTN'); INSERT INTO `travel_area` VALUES ('51', '3', ',3,51,', '2', '布基纳法索', 'Burkina Faso', 'bujinafasuo', 'BFA'); INSERT INTO `travel_area` VALUES ('52', '3', ',3,52,', '2', '布隆迪', 'Burundi', 'bulongdi', 'BDI'); INSERT INTO `travel_area` VALUES ('53', '2', ',2,53,', '2', '布韦岛', 'Bouvet Island', 'buweidao', 'BVT'); INSERT INTO `travel_area` VALUES ('54', '1', ',1,54,', '2', '朝鲜', 'North Korea', 'chaoxian', 'PRK'); INSERT INTO `travel_area` VALUES ('55', '2', ',2,55,', '2', '丹麦', 'Denmark', 'danmai', 'DNK'); INSERT INTO `travel_area` VALUES ('56', '2', ',2,56,', '2', '德国', 'Germany', 'deguo', 'DEU'); INSERT INTO `travel_area` VALUES ('57', '1', ',1,57,', '2', '东帝汶', 'Timor-Leste', 'dongdi', 'TLS'); INSERT INTO `travel_area` VALUES ('58', '3', ',3,58,', '2', '多哥', 'Togo', 'duoge', 'TGO'); INSERT INTO `travel_area` VALUES ('59', '4', ',4,59,', '2', '多米尼加', 'Dominica', 'duominijia', 'DMA'); INSERT INTO `travel_area` VALUES ('60', '4', ',4,60,', '2', '多米尼加共和国', 'Dominican Republic', 'duominijiagongheguo', 'DOM'); INSERT INTO `travel_area` VALUES ('61', '2', ',2,61,', '2', '俄罗斯', 'Russia', 'eluosi', 'RUS'); INSERT INTO `travel_area` VALUES ('62', '5', ',5,62,', '2', '厄瓜多尔',