/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50724
Source Host : localhost:3306
Source Schema : demo
Target Server Type : MySQL
Target Server Version : 50724
File Encoding : 65001
Date: 20/02/2019 13:52:58
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for region
-- ----------------------------
DROP TABLE IF EXISTS `region`;
CREATE TABLE `region` (
`id` int(11) NOT NULL COMMENT '行政区ID',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`parent_id` int(11) NULL DEFAULT NULL COMMENT '父id',
`short_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
`merger_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全称',
`level_type` tinyint(4) NULL DEFAULT NULL COMMENT '层级 0 国家/ 1省/ 2市/ 3区(县)',
`pinyin` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拼音',
`city_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市长途区号',
`zip_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮编',
`lng` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经度',
`lat` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纬度',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '行政区表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of region
-- ----------------------------
INSERT INTO `region` VALUES (100000, '中国', 0, '中国', '中国', 0, 'China', NULL, NULL, '116.3683244', '39.915085');
INSERT INTO `region` VALUES (110000, '北京', 100000, '北京', '中国,北京', 1, 'Beijing', NULL, NULL, '116.405285', '39.904989');
INSERT INTO `region` VALUES (110100, '北京市', 110000, '北京', '中国,北京,北京市', 2, 'Beijing', '010', '100000', '116.405285', '39.904989');
INSERT INTO `region` VALUES (110101, '东城区', 110100, '东城', '中国,北京,北京市,东城区', 3, 'Dongcheng', '010', '100010', '116.41005', '39.93157');
INSERT INTO `region` VALUES (110102, '西城区', 110100, '西城', '中国,北京,北京市,西城区', 3, 'Xicheng', '010', '100032', '116.36003', '39.9305');
INSERT INTO `region` VALUES (110105, '朝阳区', 110100, '朝阳', '中国,北京,北京市,朝阳区', 3, 'Chaoyang', '010', '100020', '116.48548', '39.9484');
INSERT INTO `region` VALUES (110106, '丰台区', 110100, '丰台', '中国,北京,北京市,丰台区', 3, 'Fengtai', '010', '100071', '116.28625', '39.8585');
INSERT INTO `region` VALUES (110107, '石景山区', 110100, '石景山', '中国,北京,北京市,石景山区', 3, 'Shijingshan', '010', '100043', '116.2229', '39.90564');
INSERT INTO `region` VALUES (110108, '海淀区', 110100, '海淀', '中国,北京,北京市,海淀区', 3, 'Haidian', '010', '100089', '116.29812', '39.95931');
INSERT INTO `region` VALUES (110109, '门头沟区', 110100, '门头沟', '中国,北京,北京市,门头沟区', 3, 'Mentougou', '010', '102300', '116.10137', '39.94043');
INSERT INTO `region` VALUES (110111, '房山区', 110100, '房山', '中国,北京,北京市,房山区', 3, 'Fangshan', '010', '102488', '116.14257', '39.74786');
INSERT INTO `region` VALUES (110112, '通州区', 110100, '通州', '中国,北京,北京市,通州区', 3, 'Tongzhou', '010', '101149', '116.65716', '39.90966');
INSERT INTO `region` VALUES (110113, '顺义区', 110100, '顺义', '中国,北京,北京市,顺义区', 3, 'Shunyi', '010', '101300', '116.65417', '40.1302');
INSERT INTO `region` VALUES (110114, '昌平区', 110100, '昌平', '中国,北京,北京市,昌平区', 3, 'Changping', '010', '102200', '116.2312', '40.22072');
INSERT INTO `region` VALUES (110115, '大兴区', 110100, '大兴', '中国,北京,北京市,大兴区', 3, 'Daxing', '010', '102600', '116.34149', '39.72668');
INSERT INTO `region` VALUES (110116, '怀柔区', 110100, '怀柔', '中国,北京,北京市,怀柔区', 3, 'Huairou', '010', '101400', '116.63168', '40.31602');
INSERT INTO `region` VALUES (110117, '平谷区', 110100, '平谷', '中国,北京,北京市,平谷区', 3, 'Pinggu', '010', '101200', '117.12133', '40.14056');
INSERT INTO `region` VALUES (110228, '密云县', 110100, '密云', '中国,北京,北京市,密云县', 3, 'Miyun', '010', '101500', '116.84295', '40.37618');
INSERT INTO `region` VALUES (110229, '延庆县', 110100, '延庆', '中国,北京,北京市,延庆县', 3, 'Yanqing', '010', '102100', '115.97494', '40.45672');
INSERT INTO `region` VALUES (120000, '天津', 100000, '天津', '中国,天津', 1, 'Tianjin', NULL, NULL, '117.190182', '39.125596');
INSERT INTO `region` VALUES (120100, '天津市', 120000, '天津', '中国,天津,天津市', 2, 'Tianjin', '022', '300000', '117.190182', '39.125596');
INSERT INTO `region` VALUES (120101, '和平区', 120100, '和平', '中国,天津,天津市,和平区', 3, 'Heping', '022', '300041', '117.21456', '39.11718');
INSERT INTO `region` VALUES (120102, '河东区', 120100, '河东', '中国,天津,天津市,河东区', 3, 'Hedong', '022', '300171', '117.22562', '39.12318');
INSERT INTO `region` VALUES (120103, '河西区', 120100, '河西', '中国,天津,天津市,河西区', 3, 'Hexi', '022', '300202', '117.22327', '39.10959');
INSERT INTO `region` VALUES (120104, '南开区', 120100, '南开', '中国,天津,天津市,南开区', 3, 'Nankai', '022', '300110', '117.15074', '39.13821');
INSERT INTO `region` VALUES (120105, '河北区', 120100, '河北', '中国,天津,天津市,河北区', 3, 'Hebei', '022', '300143', '117.19697', '39.14816');
INSERT INTO `region` VALUES (120106, '红桥区', 120100, '红桥', '中国,天津,天津市,红桥区', 3, 'Hongqiao', '022', '300131', '117.15145', '39.16715');
INSERT INTO `region` VALUES (120110, '东丽区', 120100, '东丽', '中国,天津,天津市,东丽区', 3, 'Dongli', '022', '300300', '117.31436', '39.0863');
INSERT INTO `region` VALUES (120111, '西青区', 120100, '西青', '中国,天津,天津市,西青区', 3, 'Xiqing', '022', '300380', '117.00927', '39.14123');
INSERT INTO `region` VALUES (120112, '津南区', 120100, '津南', '中国,天津,天津市,津南区', 3, 'Jinnan', '022', '300350', '117.38537', '38.99139');
INSERT INTO `region` VALUES (120113, '北辰区', 120100, '北辰', '中国,天津,天津市,北辰区', 3, 'Beichen', '022', '300400', '117.13217', '39.22131');
INSERT INTO `region` VALUES (120114, '武清区', 120100, '武清', '中国,天津,天津市,武清区', 3, 'Wuqing', '022', '301700', '117.04443', '39.38415');
INSERT INTO `region` VALUES (120115, '宝坻区', 120100, '宝坻', '中国,天津,天津市,宝坻区', 3, 'Baodi', '022', '301800', '117.3103', '39.71761');
INSERT INTO `region` VALUES (120116, '滨海新区', 120100, '滨海新区', '中国,天津,天津市,滨海新区', 3, 'Binhaixinqu', '022', '300451', '117.70162', '39.02668');
INSERT INTO `region` VALUES (120221, '宁河县', 120100, '宁河', '中国,天津,天津市,宁河县', 3, 'Ninghe', '022', '301500', '117.8255', '39.33048');
INSERT INTO `region` VALUES (120223, '静海县', 120100, '静海', '中国,天津,天津市,静海县', 3, 'Jinghai', '022', '301600', '116.97436', '38.94582');
INSERT INTO `region` VALUES (120225, '蓟县', 120100, '蓟县', '中国,天津,天津市,蓟县', 3, 'Jixian', '022', '301900', '117.40799', '40.04567');
INSERT INTO `region` VALUES (130000, '河北省', 100000, '河北', '中国,河北省', 1, 'Hebei', NULL, NULL, '114.502461', '38.045474');
INSERT INTO `region` VALUES (130100, '石家庄市', 130000, '石家庄', '中国,河�