• steven_dd
    了解作者
  • PHP-PERL
    开发工具
  • 51KB
    文件大小
  • rar
    文件格式
  • 0
    收藏次数
  • 1 积分
    下载积分
  • 1
    下载次数
  • 2018-09-18 17:30
    上传日期
全国省市地区三级联动的mysql数据, 精确到中国城市区
area.rar
  • area.sql
    361.1KB
内容介绍
/* Navicat MySQL Data Transfer Source Server : 本地mysql Source Server Version : 50624 Source Host : localhost:3306 Source Database : cdplife Target Server Type : MYSQL Target Server Version : 50624 File Encoding : 65001 Date: 2018-09-18 17:35:17 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for shopnc_area -- ---------------------------- DROP TABLE IF EXISTS `shopnc_area`; CREATE TABLE `shopnc_area` ( `area_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID', `area_code` varchar(6) DEFAULT NULL COMMENT '区号', `area_name` varchar(50) NOT NULL COMMENT '地区名称', `area_parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '地区父ID', `area_sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `area_deep` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '地区深度,从1开始', `area_region` varchar(3) DEFAULT NULL COMMENT '大区名称', `area_name_en_US` varchar(100) DEFAULT NULL COMMENT '英文地名', `area_region_en_US` varchar(100) DEFAULT NULL COMMENT '英文区域名称', PRIMARY KEY (`area_id`), KEY `area_parent_id` (`area_parent_id`) ) ENGINE=InnoDB AUTO_INCREMENT=45056 DEFAULT CHARSET=utf8 COMMENT='地区表'; -- ---------------------------- -- Records of shopnc_area -- ---------------------------- INSERT INTO `shopnc_area` VALUES ('1', null, '北京', '0', '0', '1', '华北', 'Peking', 'North China'); INSERT INTO `shopnc_area` VALUES ('2', null, '天津', '0', '0', '1', '华北', 'Tianjin', 'North China'); INSERT INTO `shopnc_area` VALUES ('3', null, '河北', '0', '0', '1', '华北', 'Hebei (Province)', 'North China'); INSERT INTO `shopnc_area` VALUES ('4', null, '山西', '0', '0', '1', '华北', 'Shanxi', 'North China'); INSERT INTO `shopnc_area` VALUES ('5', null, '内蒙古', '0', '0', '1', '华北', 'Inner Mongolia', 'North China'); INSERT INTO `shopnc_area` VALUES ('6', null, '辽宁', '0', '0', '1', '东北', 'Liaoning (Province)', 'Northease China'); INSERT INTO `shopnc_area` VALUES ('7', null, '吉林', '0', '0', '1', '东北', 'Jilin (Province)', 'Northease China'); INSERT INTO `shopnc_area` VALUES ('8', null, '黑龙江', '0', '0', '1', '东北', 'Amur River', 'Northease China'); INSERT INTO `shopnc_area` VALUES ('9', null, '上海', '0', '0', '1', '华东', 'Shanghai', 'East China'); INSERT INTO `shopnc_area` VALUES ('10', null, '江苏', '0', '0', '1', '华东', 'Jiangsu (Province)', 'East China'); INSERT INTO `shopnc_area` VALUES ('11', null, '浙江', '0', '0', '1', '华东', 'Zhejiang (Province)', 'East China'); INSERT INTO `shopnc_area` VALUES ('12', null, '安徽', '0', '0', '1', '华东', 'Anhui (Province)', 'East China'); INSERT INTO `shopnc_area` VALUES ('13', null, '福建', '0', '0', '1', '华南', 'Fujian', 'South China'); INSERT INTO `shopnc_area` VALUES ('14', null, '江西', '0', '0', '1', '华东', 'Jiangxi (Province)', 'East China'); INSERT INTO `shopnc_area` VALUES ('15', null, '山东', '0', '0', '1', '华东', 'Shandong', 'East China'); INSERT INTO `shopnc_area` VALUES ('16', null, '河南', '0', '0', '1', '华中', 'Henan (Province)', 'Central China'); INSERT INTO `shopnc_area` VALUES ('17', null, '湖北', '0', '0', '1', '华中', 'Hubei (Province)', 'Central China'); INSERT INTO `shopnc_area` VALUES ('18', null, '湖南', '0', '0', '1', '华中', 'Hunan (Province)', 'Central China'); INSERT INTO `shopnc_area` VALUES ('19', null, '广东', '0', '0', '1', '华南', 'Guangdong', 'South China'); INSERT INTO `shopnc_area` VALUES ('20', null, '广西', '0', '0', '1', '华南', 'Guangxi', 'South China'); INSERT INTO `shopnc_area` VALUES ('21', null, '海南', '0', '0', '1', '华南', 'Hainan (Province)', 'South China'); INSERT INTO `shopnc_area` VALUES ('22', null, '重庆', '0', '0', '1', '西南', 'Chongqing', 'Southwest China'); INSERT INTO `shopnc_area` VALUES ('23', null, '四川', '0', '0', '1', '西南', 'Szechwan', 'Southwest China'); INSERT INTO `shopnc_area` VALUES ('24', null, '贵州', '0', '0', '1', '西南', 'Guizhou (Province)', 'Southwest China'); INSERT INTO `shopnc_area` VALUES ('25', null, '云南', '0', '0', '1', '西南', 'Yunnan', 'Southwest China'); INSERT INTO `shopnc_area` VALUES ('26', null, '西藏', '0', '0', '1', '西南', 'Tibet', 'Southwest China'); INSERT INTO `shopnc_area` VALUES ('27', null, '陕西', '0', '0', '1', '西北', 'Shaanxi', 'Northwest China'); INSERT INTO `shopnc_area` VALUES ('28', null, '甘肃', '0', '0', '1', '西北', 'Gansu (Province)', 'Northwest China'); INSERT INTO `shopnc_area` VALUES ('29', null, '青海', '0', '0', '1', '西北', 'Qinghai (Province)', 'Northwest China'); INSERT INTO `shopnc_area` VALUES ('30', null, '宁夏', '0', '0', '1', '西北', 'Ningxia', 'Northwest China'); INSERT INTO `shopnc_area` VALUES ('31', null, '新疆', '0', '0', '1', '西北', 'Sinkiang', 'Northwest China'); INSERT INTO `shopnc_area` VALUES ('32', null, '台湾', '0', '0', '1', '港澳台', 'Taiwan', 'Hong Kong, Macao and Taiwan'); INSERT INTO `shopnc_area` VALUES ('33', null, '香港', '0', '0', '1', '港澳台', 'Hong Kong', 'Hong Kong, Macao and Taiwan'); INSERT INTO `shopnc_area` VALUES ('34', null, '澳门', '0', '0', '1', '港澳台', 'Macao', 'Hong Kong, Macao and Taiwan'); INSERT INTO `shopnc_area` VALUES ('35', null, '海外', '0', '0', '1', '海外', 'overseas', 'Overseas'); INSERT INTO `shopnc_area` VALUES ('36', '010', '北京市', '1', '0', '2', null, 'Beijing', null); INSERT INTO `shopnc_area` VALUES ('37', null, '东城区', '36', '0', '3', null, 'Dongcheng District', null); INSERT INTO `shopnc_area` VALUES ('38', null, '西城区', '36', '0', '3', null, 'Xicheng District', null); INSERT INTO `shopnc_area` VALUES ('39', '021', '上海市', '9', '0', '2', null, 'Shanghai', null); INSERT INTO `shopnc_area` VALUES ('40', '022', '天津市', '2', '0', '2', null, 'Tianjin', null); INSERT INTO `shopnc_area` VALUES ('41', null, '朝阳区', '36', '0', '3', null, 'Chaoyang District', null); INSERT INTO `shopnc_area` VALUES ('42', null, '丰台区', '36', '0', '3', null, 'Fengtai District', null); INSERT INTO `shopnc_area` VALUES ('43', null, '石景山区', '36', '0', '3', null, 'Shijingshan District', null); INSERT INTO `shopnc_area` VALUES ('44', null, '海淀区', '36', '0', '3', null, 'Haidian District', null); INSERT INTO `shopnc_area` VALUES ('45', null, '门头沟区', '36', '0', '3', null, 'Mentougou District', null); INSERT INTO `shopnc_area` VALUES ('46', null, '房山区', '36', '0', '3', null, 'Fangshan District', null); INSERT INTO `shopnc_area` VALUES ('47', null, '通州区', '36', '0', '3', null, 'Tongzhou District', null); INSERT INTO `shopnc_area` VALUES ('48', null, '顺义区', '36', '0', '3', null, 'Shunyi District', null); INSERT INTO `shopnc_area` VALUES ('49', null, '昌平区', '36', '0', '3', null, 'Changping District', null); INSERT INTO `shopnc_area` VALUES ('50', null, '大兴区', '36', '0', '3', null, 'Daxing District', null); INSERT INTO `shopnc_area` VALUES ('51', null, '怀柔区', '36', '0', '3', null, 'Huairou District', null); INSERT INTO `shopnc_area` VALUES ('52', null, '平谷区', '36', '0', '3', null, 'Pinggu District', null); INSERT INTO `shopnc_area` VALUES ('53', null, '密云县', '36', '0', '3', null, 'Miyun County', null); INSERT INTO `shopnc_area` VALUES ('54', null, '延庆县', '36', '0', '3', null, 'Yanqing County', null); INSERT INTO `shopnc_area` VALUES ('55', null, '和平区', '40', '0', '3', null, 'Heping District', null); INSERT INTO `shopnc_area` VALUES ('56', null, '河东区', '40', '0', '3', null, 'Hedong District', null); INSERT INTO `shopnc_area` VALUES ('57', null, '河西区', '40', '0', '3', null, 'Hexi District', null); INSERT INTO `shopnc_area` VALUES ('58', null, '南开区', '40', '0', '3', null, 'Nankai District', null); INSERT INTO `shopnc_area` VALUES ('59', n
评论
    相关推荐