/*
Navicat MySQL Data Transfer
Target Server Type : MYSQL
Target Server Version : 50718
File Encoding : 65001
Date: 2017-10-17 09:45:19
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for dt_areas
-- ----------------------------
DROP TABLE IF EXISTS `dt_areas`;
CREATE TABLE `dt_areas` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(16) NOT NULL,
`parent_id` int(10) unsigned NOT NULL DEFAULT '0',
`type` tinyint(1) DEFAULT '3' COMMENT '类型 1省 2市 3区/县',
`sort` int(10) unsigned DEFAULT '99',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=820001 DEFAULT CHARSET=utf8mb4 COMMENT='地区表';
-- ----------------------------
-- Records of dt_areas
-- ----------------------------
INSERT INTO `dt_areas` VALUES ('110000', '北京市', '0', '1', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110100', '市辖区', '110000', '2', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110101', '东城区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110102', '西城区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110105', '朝阳区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110106', '丰台区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110107', '石景山区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110108', '海淀区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110109', '门头沟区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110111', '房山区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110112', '通州区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110113', '顺义区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110114', '昌平区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110115', '大兴区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110116', '怀柔区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110117', '平谷区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110118', '密云区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('110119', '延庆区', '110100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120000', '天津市', '0', '1', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120100', '市辖区', '120000', '2', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120101', '和平区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120102', '河东区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120103', '河西区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120104', '南开区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120105', '河北区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120106', '红桥区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120110', '东丽区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120111', '西青区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120112', '津南区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120113', '北辰区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120114', '武清区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120115', '宝坻区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120116', '滨海新区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120117', '宁河区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120118', '静海区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('120119', '蓟州区', '120100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130000', '河北省', '0', '1', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130100', '石家庄市', '130000', '2', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130101', '市辖区', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130102', '长安区', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130104', '桥西区', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130105', '新华区', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130107', '井陉矿区', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130108', '裕华区', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130109', '藁城区', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130110', '鹿泉区', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130111', '栾城区', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130121', '井陉县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130123', '正定县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130125', '行唐县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130126', '灵寿县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130127', '高邑县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130128', '深泽县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130129', '赞皇县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130130', '无极县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130131', '平山县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130132', '元氏县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130133', '赵县', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130183', '晋州市', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130184', '新乐市', '130100', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130200', '唐山市', '130000', '2', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130201', '市辖区', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130202', '路南区', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130203', '路北区', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130204', '古冶区', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130205', '开平区', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130207', '丰南区', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130208', '丰润区', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130209', '曹妃甸区', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130223', '滦县', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130224', '滦南县', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130225', '乐亭县', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130227', '迁西县', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130229', '玉田县', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130281', '遵化市', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130283', '迁安市', '130200', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130300', '秦皇岛市', '130000', '2', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130301', '市辖区', '130300', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130302', '海港区', '130300', '3', '99', null, null);
INSERT INTO `dt_areas` VALUES ('130303', '山海关区', '130300', '3', '99', null,