全世界各个国家地区城市 数据库

-- phpMyAdmin SQL Dump -- version 4.1.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: 2014-12-21 07:24:14 -- 服务器版本： 5.5.29 -- PHP Version: 5.3.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: 'huateng' -- -- -------------------------------------------------------- -- -- 表的结构 'shp_location' -- DROP TABLE IF EXISTS 'shp_location'; CREATE TABLE IF NOT EXISTS 'shp_location' ( 'id' int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', 'pid' int(11) unsigned DEFAULT '0' COMMENT '父ID', 'path' varchar(255) DEFAULT NULL COMMENT '路径', 'level' int(11) unsigned DEFAULT NULL COMMENT '层级', '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 ('id') ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全球地区库，采集自腾讯QQ国内+国际版.ADD.JENA.20141221'; -- -- 转存表中的数据 'shp_location' -- INSERT INTO 'shp_location' ('id', 'pid', 'path', 'level', 'name', 'name_en', 'name_pinyin', 'code') VALUES (1, 0, ',1,', 1, '亚洲', 'Asia', 'yazhou', ''), (2, 0, ',2,', 1, '欧洲', 'Europe', 'ouzhou', ''), (3, 0, ',3,', 1, '非洲', 'Africa', 'feizhou', ''), (4, 0, ',4,', 1, '北美', 'North America', 'beimei', ''), (5, 0, ',5,', 1, '南美', 'South America', 'nanmei', ''), (6, 0, ',6,', 1, '大洋洲', 'Oceania', 'dayangzhou', ''), (7, 1, ',1,7,', 2, '中国', 'China', 'zhongguo', 'CN'), (8, 2, ',2,8,', 2, '阿尔巴尼亚', 'Albania', 'aerbaniya', 'ALB'), (9, 3, ',3,9,', 2, '阿尔及利亚', 'Algeria', 'aerjiliya', 'DZA'), (10, 1, ',1,10,', 2, '阿富汗', 'Afghanistan', 'afuhan', 'AFG'), (11, 5, ',5,11,', 2, '阿根廷', 'Argentina', 'agenting', 'ARG'), (12, 1, ',1,12,', 2, '阿拉伯联合酋长国', 'United Arab Emirates', 'alabolianheqiuchangguo', 'ARE'), (13, 5, ',5,13,', 2, '阿鲁巴', 'Aruba', 'aluba', 'ABW'), (14, 1, ',1,14,', 2, '阿曼', 'Oman', 'aman', 'OMN'), (15, 1, ',1,15,', 2, '阿塞拜疆', 'Azerbaijan', 'asaibaijiang', 'AZE'), (16, 3, ',3,16,', 2, '阿森松岛', 'Ascension Island', 'asensongdao', 'ASC'), (17, 3, ',3,17,', 2, '埃及', 'Egypt', 'aiji', 'EGY'), (18, 3, ',3,18,', 2, '埃塞俄比亚', 'Ethiopia', 'aisaiebiya', 'ETH'), (19, 2, ',2,19,', 2, '爱尔兰', 'Ireland', 'aierlan', 'IRL'), (20, 2, ',2,20,', 2, '爱沙尼亚', 'Estonia', 'aishaniya', 'EST'), (21, 2, ',2,21,', 2, '安道尔', 'Andorra', 'andaoer', 'AND'), (22, 3, ',3,22,', 2, '安哥拉', 'Angola', 'angela', 'AGO'), (23, 5, ',5,23,', 2, '安圭拉', 'Anguilla', 'anguila', 'AIA'), (24, 4, ',4,24,', 2, '安提瓜岛和巴布达', 'Antigua and Barbuda', 'antiguadaohebabuda', 'ATG'), (25, 6, ',6,25,', 2, '澳大利亚', 'Australia', 'aodaliya', 'AUS'), (26, 2, ',2,26,', 2, '奥地利', 'Austria', 'aodili', 'AUT'), (27, 2, ',2,27,', 2, '奥兰群岛', 'Aland lslands', 'aolanqundao', 'ALA'), (28, 5, ',5,28,', 2, '巴巴多斯岛', 'Barbados', 'babaduosidao', 'BRB'), (29, 6, ',6,29,', 2, '巴布亚新几内亚', 'Papua New Guinea', 'babuyaxinjineiya', 'PNG'), (30, 4, ',4,30,', 2, '巴哈马', 'Bahamas', 'bahama', 'BHS'), (31, 1, ',1,31,', 2, '巴基斯坦', 'Pakistan', 'bajisitan', 'PAK'), (32, 5, ',5,32,', 2, '巴拉圭', 'Paraguay', 'balagui', 'PRY'), (33, 1, ',1,33,', 2, '巴勒斯坦', 'Palestinian Authority', 'balesitan', 'PSE'), (34, 1, ',1,34,', 2, '巴林', 'Bahrain', 'balin', 'BHR'), (35, 4, ',4,35,', 2, '巴拿马', 'Panama', 'banama', 'PAN'), (36, 5, ',5,36,', 2, '巴西', 'Brazil', 'baxi', 'BRA'), (37, 2, ',2,37,', 2, '白俄罗斯', 'White Russia', 'baieluosi', 'BLR'), (38, 4, ',4,38,', 2, '百慕大', 'Bermuda', 'baimuda', 'BMU'), (39, 2, ',2,39,', 2, '保加利亚', 'Bulgaria', 'baojialiya', 'BGR'), (40, 4, ',4,40,', 2, '北马里亚纳群岛', 'Northern Mariana Islands', 'beimaliyanaqundao', 'MNP'), (41, 3, ',3,41,', 2, '贝宁', 'Benin', 'beining', 'BEN'), (42, 2, ',2,42,', 2, '比利时', 'Belgium', 'bilishi', 'BEL'), (43, 2, ',2,43,', 2, '冰岛', 'Iceland', 'bingdao', 'ISL'), (44, 4, ',4,44,', 2, '波多黎各', 'Puerto Rico', 'boduolige', 'PRI'), (45, 2, ',2,45,', 2, '波兰', 'Poland', 'bolan', 'POL'), (46, 5, ',5,46,', 2, '玻利维亚', 'Bolivia', 'boliweiya', 'BOL'), (47, 2, ',2,47,', 2, '波斯尼亚和黑塞哥维那', 'Bosnia and Herzegovina', 'bosiniyaheheisaigeweina', 'BIH'), (48, 3, ',3,48,', 2, '博茨瓦纳', 'Botswana', 'bociwana', 'BWA'), (49, 4, ',4,49,', 2, '伯利兹', 'Belize', 'bolizi', 'BLZ'), (50, 1, ',1,50,', 2, '不丹', 'Bhutan', 'budan', 'BTN'), (51, 3, ',3,51,', 2, '布基纳法索', 'Burkina Faso', 'bujinafasuo', 'BFA'), (52, 3, ',3,52,', 2, '布隆迪', 'Burundi', 'bulongdi', 'BDI'), (53, 2, ',2,53,', 2, '布韦岛', 'Bouvet Island', 'buweidao', 'BVT'), (54, 1, ',1,54,', 2, '朝鲜', 'North Korea', 'chaoxian', 'PRK'), (55, 2, ',2,55,', 2, '丹麦', 'Denmark', 'danmai', 'DNK'), (56, 2, ',2,56,', 2, '德国', 'Germany', 'deguo', 'DEU'), (57, 1, ',1,57,', 2, '东帝汶', 'Timor-Leste', 'dongdi', 'TLS'), (58, 3, ',3,58,', 2, '多哥', 'Togo', 'duoge', 'TGO'), (59, 4, ',4,59,', 2, '多米尼加', 'Dominica', 'duominijia', 'DMA'), (60, 4, ',4,60,', 2, '多米尼加共和国', 'Dominican Republic', 'duominijiagongheguo', 'DOM'), (61, 2, ',2,61,', 2, '俄罗斯', 'Russia', 'eluosi', 'RUS'), (62, 5, ',5,62,', 2, '厄瓜多尔', 'Ecuador', 'eguaduoer', 'ECU'), (63, 3, ',3,63,', 2, '厄立特里亚', 'Eritrea', 'eliteliya', 'ERI'), (64, 2, ',2,64,', 2, '法国', 'France', 'faguo', 'FRA'), (65, 2, ',2,65,', 2, '法罗群岛', 'Faroe Islands', 'faluoqundao', 'FRO'), (66, 6, ',6,66,', 2, '法属波利尼西亚', 'Frech Polynesia', 'fashubolinixiya', 'PYF'), (67, 5, ',5,67,', 2, '法属圭亚那', 'French Guiana', 'fashuguiyana', 'GUF'), (68, 2, ',2,68,', 2, '法属南部领地', 'French Southern and Antarctic Lands', 'fashunanbulingdi', 'ATF'), (69, 2, ',2,69,', 2, '梵蒂冈', 'Vatican City', 'digang', 'VAT'), (70, 1, ',1,70,', 2, '菲律宾', 'Philippines', 'feilvbin', 'PHL'), (71, 6, ',6,71,', 2, '斐济', 'Fiji Islands', 'ji', 'FJI'), (72, 2, ',2,72,', 2, '芬兰', 'Finland', 'fenlan', 'FIN'), (73, 3, ',3,73,', 2, '佛得角', 'Cape Verde', 'fodejiao', 'CPV'), (74, 2, ',2,74,', 2, '弗兰克群岛', 'Falkland Islands', 'fulankequndao', 'FLK'), (75, 3, ',3,75,', 2, '冈比亚', 'Gambia', 'gangbiya', 'GMB'), (76, 3, ',3,76,', 2, '刚果', 'Congo', 'gangguo', 'COG'), (77, 3, ',3,77,', 2, '刚果民主共和国', 'Congo(DRC)', 'gangguominzhugongheguo', 'COD'), (78, 5, ',5,78,', 2, '哥伦比亚', 'Colombia', 'gelunbiya', 'COL'), (79, 4, ',4,79,', 2, '哥斯达黎加', 'Costa Rica', 'gesidalijia', 'CRI'), (80, 2, ',2,80,', 2, '格恩西岛', 'Guernsey', 'geenxidao', 'GGY'), (81, 4, ',4,81,', 2, '格林纳达', 'Grenada', 'gelinnada', 'GRD'), (82, 4, ',4,82,', 2, '格陵兰', 'Greenland', 'gelinglan', 'GRL'), (83, 4, ',4,83,', 2, '古巴', 'Cuba', 'guba', 'CUB'), (84, 4, ',4,84,', 2, '瓜德罗普', 'Guadeloupe', 'guadeluopu', 'GLP'), (85, 6, ',6,85,', 2, '关岛', 'Guam', 'guandao', 'GUM'), (86, 5, ',5,86,', 2, '圭亚那', 'Guyana', 'guiyana', 'GUY'), (87, 1, ',1,87,', 2, '哈萨克斯坦', 'Kazakhstan', 'hasakesitan', 'KAZ'), (88, 4, ',4,88,', 2, '海地', 'Haiti', 'haidi', 'HTI'), (89, 1, ',1,89,', 2, '韩国', 'Korea', 'hanguo', 'KOR'), (90, 2, ',2,90,', 2, '荷兰', 'Netherlands', 'helan', 'NLD'), (91, 5, ',5,91,', 2, '荷属安地列斯', 'Netherlands Antilles', 'heshuandiliesi', 'ANT'), (92, 6, ',6,92,', 2, '赫德和麦克唐纳群岛', 'Heard Island and McDonald Islands', 'hedehemaiketangnaqundao', 'HMD'), (93, 4, ',4,93,', 2, '洪都拉斯', 'Honduras', 'hongdulasi', 'HND'), (94, 6, ',6,94,', 2,