/*
Navicat MySQL Data Transfer
Source Server : 本地
Source Server Version : 50557
Source Host : localhost:3306
Source Database : gaokaopai
Target Server Type : MYSQL
Target Server Version : 50557
File Encoding : 65001
Date: 2018-08-17 11:36:00
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for area_data
-- ----------------------------
DROP TABLE IF EXISTS `area_data`;
CREATE TABLE `area_data` (
`id` bigint(16) NOT NULL AUTO_INCREMENT,
`parentid` varchar(300) DEFAULT NULL,
`code` varchar(300) DEFAULT NULL,
`name` varchar(300) DEFAULT NULL,
`level` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71321 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of area_data
-- ----------------------------
INSERT INTO `area_data` VALUES ('1', '0', '11', '北京市', '1');
INSERT INTO `area_data` VALUES ('2', '0', '12', '天津市', '1');
INSERT INTO `area_data` VALUES ('3', '0', '13', '河北省', '1');
INSERT INTO `area_data` VALUES ('4', '0', '14', '山西省', '1');
INSERT INTO `area_data` VALUES ('5', '0', '15', '内蒙古自治区', '1');
INSERT INTO `area_data` VALUES ('6', '0', '21', '辽宁省', '1');
INSERT INTO `area_data` VALUES ('7', '0', '22', '吉林省', '1');
INSERT INTO `area_data` VALUES ('8', '0', '23', '黑龙江省', '1');
INSERT INTO `area_data` VALUES ('9', '0', '31', '上海市', '1');
INSERT INTO `area_data` VALUES ('10', '0', '32', '江苏省', '1');
INSERT INTO `area_data` VALUES ('11', '0', '33', '浙江省', '1');
INSERT INTO `area_data` VALUES ('12', '0', '34', '安徽省', '1');
INSERT INTO `area_data` VALUES ('13', '0', '35', '福建省', '1');
INSERT INTO `area_data` VALUES ('14', '0', '36', '江西省', '1');
INSERT INTO `area_data` VALUES ('15', '0', '37', '山东省', '1');
INSERT INTO `area_data` VALUES ('16', '0', '41', '河南省', '1');
INSERT INTO `area_data` VALUES ('17', '0', '42', '湖北省', '1');
INSERT INTO `area_data` VALUES ('18', '0', '43', '湖南省', '1');
INSERT INTO `area_data` VALUES ('19', '0', '44', '广东省', '1');
INSERT INTO `area_data` VALUES ('20', '0', '45', '广西壮族自治区', '1');
INSERT INTO `area_data` VALUES ('21', '0', '46', '海南省', '1');
INSERT INTO `area_data` VALUES ('22', '0', '50', '重庆市', '1');
INSERT INTO `area_data` VALUES ('23', '0', '51', '四川省', '1');
INSERT INTO `area_data` VALUES ('24', '0', '52', '贵州省', '1');
INSERT INTO `area_data` VALUES ('25', '0', '53', '云南省', '1');
INSERT INTO `area_data` VALUES ('26', '0', '54', '西藏自治区', '1');
INSERT INTO `area_data` VALUES ('27', '0', '61', '陕西省', '1');
INSERT INTO `area_data` VALUES ('28', '0', '62', '甘肃省', '1');
INSERT INTO `area_data` VALUES ('29', '0', '63', '青海省', '1');
INSERT INTO `area_data` VALUES ('30', '0', '64', '宁夏回族自治区', '1');
INSERT INTO `area_data` VALUES ('31', '0', '65', '新疆维吾尔自治区', '1');
INSERT INTO `area_data` VALUES ('32', '11', '1101', '市辖区', '2');
INSERT INTO `area_data` VALUES ('33', '1101', '110101', '东城区', '3');
INSERT INTO `area_data` VALUES ('34', '1101', '110102', '西城区', '3');
INSERT INTO `area_data` VALUES ('35', '1101', '110105', '朝阳区', '3');
INSERT INTO `area_data` VALUES ('36', '1101', '110106', '丰台区', '3');
INSERT INTO `area_data` VALUES ('37', '1101', '110107', '石景山区', '3');
INSERT INTO `area_data` VALUES ('38', '1101', '110108', '海淀区', '3');
INSERT INTO `area_data` VALUES ('39', '1101', '110109', '门头沟区', '3');
INSERT INTO `area_data` VALUES ('40', '1101', '110111', '房山区', '3');
INSERT INTO `area_data` VALUES ('41', '1101', '110112', '通州区', '3');
INSERT INTO `area_data` VALUES ('42', '1101', '110113', '顺义区', '3');
INSERT INTO `area_data` VALUES ('43', '1101', '110114', '昌平区', '3');
INSERT INTO `area_data` VALUES ('44', '1101', '110115', '大兴区', '3');
INSERT INTO `area_data` VALUES ('45', '1101', '110116', '怀柔区', '3');
INSERT INTO `area_data` VALUES ('46', '1101', '110117', '平谷区', '3');
INSERT INTO `area_data` VALUES ('47', '1101', '110118', '密云区', '3');
INSERT INTO `area_data` VALUES ('48', '1101', '110119', '延庆区', '3');
INSERT INTO `area_data` VALUES ('49', '110101', '110101001', '东华门街道办事处', '4');
INSERT INTO `area_data` VALUES ('50', '110101', '110101002', '景山街道办事处', '4');
INSERT INTO `area_data` VALUES ('51', '110101', '110101003', '交道口街道办事处', '4');
INSERT INTO `area_data` VALUES ('52', '110101', '110101004', '安定门街道办事处', '4');
INSERT INTO `area_data` VALUES ('53', '110101', '110101005', '北新桥街道办事处', '4');
INSERT INTO `area_data` VALUES ('54', '110101', '110101006', '东四街道办事处', '4');
INSERT INTO `area_data` VALUES ('55', '110101', '110101007', '朝阳门街道办事处', '4');
INSERT INTO `area_data` VALUES ('56', '110101', '110101008', '建国门街道办事处', '4');
INSERT INTO `area_data` VALUES ('57', '110101', '110101009', '东直门街道办事处', '4');
INSERT INTO `area_data` VALUES ('58', '110101', '110101010', '和平里街道办事处', '4');
INSERT INTO `area_data` VALUES ('59', '110101', '110101011', '前门街道办事处', '4');
INSERT INTO `area_data` VALUES ('60', '110101', '110101012', '崇文门外街道办事处', '4');
INSERT INTO `area_data` VALUES ('61', '110101', '110101013', '东花市街道办事处', '4');
INSERT INTO `area_data` VALUES ('62', '110101', '110101014', '龙潭街道办事处', '4');
INSERT INTO `area_data` VALUES ('63', '110101', '110101015', '体育馆路街道办事处', '4');
INSERT INTO `area_data` VALUES ('64', '110101', '110101016', '天坛街道办事处', '4');
INSERT INTO `area_data` VALUES ('65', '110101', '110101017', '永定门外街道办事处', '4');
INSERT INTO `area_data` VALUES ('66', '110101001', '110101001001', '多福巷社区居委会', '5');
INSERT INTO `area_data` VALUES ('67', '110101001', '110101001002', '银闸社区居委会', '5');
INSERT INTO `area_data` VALUES ('68', '110101001', '110101001005', '东厂社区居委会', '5');
INSERT INTO `area_data` VALUES ('69', '110101001', '110101001006', '智德社区居委会', '5');
INSERT INTO `area_data` VALUES ('70', '110101001', '110101001007', '南池子社区居委会', '5');
INSERT INTO `area_data` VALUES ('71', '110101001', '110101001008', '黄图岗社区居委会', '5');
INSERT INTO `area_data` VALUES ('72', '110101001', '110101001009', '灯市口社区居委会', '5');
INSERT INTO `area_data` VALUES ('73', '110101001', '110101001010', '正义路社区居委会', '5');
INSERT INTO `area_data` VALUES ('74', '110101001', '110101001011', '甘雨社区居委会', '5');
INSERT INTO `area_data` VALUES ('75', '110101001', '110101001013', '台基厂社区居委会', '5');
INSERT INTO `area_data` VALUES ('76', '110101001', '110101001014', '韶九社区居委会', '5');
INSERT INTO `area_data` VALUES ('77', '110101001', '110101001015', '王府井社区居委会', '5');
INSERT INTO `area_data` VALUES ('78', '110101002', '110101002001', '隆福寺社区居委会', '5');
INSERT INTO `area_data` VALUES ('79', '110101002', '110101002002', '吉祥社区居委会', '5');
INSERT INTO `area_data` VALUES ('80', '110101002', '110101002003', '黄化门社区居委会', '5');
INSERT INTO `area_data` VALUES ('81', '110101002', '110101002004', '钟鼓社区居委会', '5');
INSERT INTO `area_data` VALUES ('82', '110101002', '110101002005', '魏家社区居委会', '5');
INSERT INTO `area_data` VALUES ('83', '110101002', '110101002006', '汪芝麻社区居委会', '5');
INSERT INTO `area_data` VALUES ('84', '110101002', '110101002008', '景山东街社区居委会', '5');
INSERT INTO `area_data` VALUES ('85', '110101002', '110101002009', '皇城根北街社区居委会', '5');
INSERT
