/*
Navicat MySQL Data Transfer
Source Server : 本地-phpstudy
Source Server Version : 50553
Source Host : localhost:3306
Source Database : city
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2017-12-12 10:12:58
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for app_region_area
-- ----------------------------
DROP TABLE IF EXISTS `app_region_area`;
CREATE TABLE `app_region_area` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`code` int(10) unsigned NOT NULL COMMENT '编号',
`name` varchar(16) NOT NULL DEFAULT '0' COMMENT '区县',
`level` int(10) unsigned NOT NULL DEFAULT '3' COMMENT '级别',
`parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所在城市',
PRIMARY KEY (`id`),
UNIQUE KEY `code_UNIQUE` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4208 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='区县表';
-- ----------------------------
-- Records of app_region_area
-- ----------------------------
INSERT INTO `app_region_area` VALUES ('1', '410881', '济源市', '2', '4190');
INSERT INTO `app_region_area` VALUES ('2', '429004', '仙桃市', '2', '4290');
INSERT INTO `app_region_area` VALUES ('3', '429005', '潜江市', '2', '4290');
INSERT INTO `app_region_area` VALUES ('4', '429006', '天门市', '2', '4290');
INSERT INTO `app_region_area` VALUES ('5', '429021', '神农架林区', '2', '4290');
INSERT INTO `app_region_area` VALUES ('6', '442101', '东沙群岛', '2', '4421');
INSERT INTO `app_region_area` VALUES ('7', '469001', '五指山市', '2', '4690');
INSERT INTO `app_region_area` VALUES ('8', '469002', '琼海市', '2', '4690');
INSERT INTO `app_region_area` VALUES ('9', '469003', '儋州市', '2', '4690');
INSERT INTO `app_region_area` VALUES ('10', '469005', '文昌市', '2', '4690');
INSERT INTO `app_region_area` VALUES ('11', '469006', '万宁市', '2', '4690');
INSERT INTO `app_region_area` VALUES ('12', '469007', '东方市', '2', '4690');
INSERT INTO `app_region_area` VALUES ('13', '469025', '定安县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('14', '469026', '屯昌县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('15', '469027', '澄迈县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('16', '469028', '临高县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('17', '469030', '白沙黎族自治县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('18', '469031', '昌江黎族自治县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('19', '469033', '乐东黎族自治县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('20', '469034', '陵水黎族自治县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('21', '469035', '保亭黎族苗族自治县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('22', '469036', '琼中黎族苗族自治县', '2', '4690');
INSERT INTO `app_region_area` VALUES ('23', '659001', '石河子市', '2', '6590');
INSERT INTO `app_region_area` VALUES ('24', '659002', '阿拉尔市', '2', '6590');
INSERT INTO `app_region_area` VALUES ('25', '659003', '图木舒克市', '2', '6590');
INSERT INTO `app_region_area` VALUES ('26', '659004', '五家渠市', '2', '6590');
INSERT INTO `app_region_area` VALUES ('32', '110101', '东城区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('33', '110102', '西城区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('34', '110105', '朝阳区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('35', '110106', '丰台区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('36', '110107', '石景山区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('37', '110108', '海淀区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('38', '110109', '门头沟区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('39', '110111', '房山区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('40', '110112', '通州区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('41', '110113', '顺义区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('42', '110114', '昌平区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('43', '110115', '大兴区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('44', '110116', '怀柔区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('45', '110117', '平谷区', '3', '1101');
INSERT INTO `app_region_area` VALUES ('46', '110228', '密云县', '3', '1101');
INSERT INTO `app_region_area` VALUES ('47', '110229', '延庆县', '3', '1101');
INSERT INTO `app_region_area` VALUES ('48', '120101', '和平区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('49', '120102', '河东区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('50', '120103', '河西区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('51', '120104', '南开区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('52', '120105', '河北区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('53', '120106', '红桥区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('54', '120110', '东丽区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('55', '120111', '西青区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('56', '120112', '津南区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('57', '120113', '北辰区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('58', '120114', '武清区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('59', '120115', '宝坻区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('60', '120116', '滨海新区', '3', '1201');
INSERT INTO `app_region_area` VALUES ('61', '120221', '宁河县', '3', '1201');
INSERT INTO `app_region_area` VALUES ('62', '120223', '静海县', '3', '1201');
INSERT INTO `app_region_area` VALUES ('63', '120225', '蓟县', '3', '1201');
INSERT INTO `app_region_area` VALUES ('64', '130102', '长安区', '3', '1301');
INSERT INTO `app_region_area` VALUES ('65', '130103', '桥东区', '3', '1301');
INSERT INTO `app_region_area` VALUES ('66', '130104', '桥西区', '3', '1301');
INSERT INTO `app_region_area` VALUES ('67', '130105', '新华区', '3', '1301');
INSERT INTO `app_region_area` VALUES ('68', '130107', '井陉矿区', '3', '1301');
INSERT INTO `app_region_area` VALUES ('69', '130108', '裕华区', '3', '1301');
INSERT INTO `app_region_area` VALUES ('70', '130121', '井陉县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('71', '130123', '正定县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('72', '130124', '栾城县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('73', '130125', '行唐县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('74', '130126', '灵寿县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('75', '130127', '高邑县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('76', '130128', '深泽县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('77', '130129', '赞皇县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('78', '130130', '无极县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('79', '130131', '平山县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('80', '130132', '元氏县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('81', '130133', '赵县', '3', '1301');
INSERT INTO `app_region_area` VALUES ('82', '130181', '辛集市', '3', '1301');
INSERT INTO `app_region_area` VALUES ('83', '130182', '藁城市', '3', '1301');
INSERT INTO `app_region_area` VALUES ('84', '130183', '晋州市', '3', '1301');
INSERT INTO `app_region_area` VALUES ('85', '130184', '新乐市', '3', '1301');
INSERT INTO `app_region_area` VALUES ('86', '130185', '鹿泉市', '3', '1301');
INSERT INTO `app_region_area` VALUES ('87', '130202', '路南区', '3', '1302');
INSERT INTO `app_region_area` VALUES ('88', '130203', '路北区',
评论0
最新资源