Android_317 基于安卓的大众点评app的设计与实现（对景点、酒店、美食、楼盘进行点评/评论）Android Studio原生开发

于 2023-11-30 13:01:36 发布
阅读量1k 收藏 19
点赞数 21
分类专栏： 毕业设计 文章标签： 毕设 毕业设计 Android 安卓 app 大众点评app android studio
本文链接：https://blog.csdn.net/Stryboy/article/details/134709617
版权

app端-用户：注册登录、搜索、浏览景点/美食/酒店/楼盘、收藏景点/美食/酒店/楼盘、评论景点/美食/酒店/楼盘、导航目的地、账户维护
web后台管理-管理员：用户管理、景点管理、酒店管理、美食管理、楼盘管理

首页app

景点列表

个人中心

详情页面

点评

我的收藏

导航目的地

数据库脚本如下：

-- ----------------------------
-- Table structure for t_city_info
-- ----------------------------
DROP TABLE IF EXISTS `t_city_info`;
CREATE TABLE `t_city_info` (
  `city_id` varchar(6) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `parent_id` varchar(6) DEFAULT NULL,
  `level` int(1) DEFAULT NULL,
  PRIMARY KEY (`city_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_city_info
-- ----------------------------
INSERT INTO `t_city_info` VALUES ('11', '北京市', null, '1');
INSERT INTO `t_city_info` VALUES ('1101', '北京市市辖区', '11', '2');
INSERT INTO `t_city_info` VALUES ('110101', '东城区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110102', '西城区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110105', '朝阳区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110106', '丰台区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110107', '石景山区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110108', '海淀区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110109', '门头沟区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110111', '房山区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110112', '通州区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110113', '顺义区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110114', '昌平区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110115', '大兴区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110116', '怀柔区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110117', '平谷区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110118', '密云区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('110119', '延庆区', '1101', '3');
INSERT INTO `t_city_info` VALUES ('12', '天津市', null, '1');
INSERT INTO `t_city_info` VALUES ('1201', '天津市市辖区', '12', '2');
INSERT INTO `t_city_info` VALUES ('120101', '和平区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120102', '河东区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120103', '河西区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120104', '南开区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120105', '河北区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120106', '红桥区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120110', '东丽区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120111', '西青区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120112', '津南区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120113', '北辰区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120114', '武清区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120115', '宝坻区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120116', '滨海新区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120117', '宁河区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120118', '静海区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('120119', '蓟州区', '1201', '3');
INSERT INTO `t_city_info` VALUES ('13', '河北省', null, '1');
INSERT INTO `t_city_info` VALUES ('1301', '石家庄市', '13', '2');
INSERT INTO `t_city_info` VALUES ('130101', '石家庄市市辖区', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130102', '长安区', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130104', '桥西区', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130105', '新华区', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130107', '井陉矿区', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130108', '裕华区', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130109', '藁城区', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130110', '鹿泉区', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130111', '栾城区', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130121', '井陉县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130123', '正定县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130125', '行唐县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130126', '灵寿县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130127', '高邑县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130128', '深泽县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130129', '赞皇县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130130', '无极县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130131', '平山县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130132', '元氏县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130133', '赵县', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130181', '辛集市', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130183', '晋州市', '1301', '3');
INSERT INTO `t_city_info` VALUES ('130184', '新乐市', '1301', '3');
INSERT INTO `t_city_info` VALUES ('1302', '唐山市', '13', '2');
INSERT INTO `t_city_info` VALUES ('130201', '唐山市市辖区', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130202', '路南区', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130203', '路北区', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130204', '古冶区', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130205', '开平区', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130207', '丰南区', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130208', '丰润区', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130209', '曹妃甸区', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130224', '滦南县', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130225', '乐亭县', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130227', '迁西县', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130229', '玉田县', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130281', '遵化市', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130283', '迁安市', '1302', '3');
INSERT INTO `t_city_info` VALUES ('130284', '滦州市', '1302', '3');
INSERT INTO `t_city_info` VALUES ('1303', '秦皇岛市', '13', '2');
INSERT INTO `t_city_info` VALUES ('130301', '秦皇岛市市辖区', '1303', '3');
INSERT INTO `t_city_info` VALUES ('130302', '海港区', '1303', '3');
INSERT INTO `t_city_info` VALUES ('130303', '山海关区', '1303', '3');
INSERT INTO `t_city_info` VALUES ('130304', '北戴河区', '1303', '3');
INSERT INTO `t_city_info` VALUES ('130306', '抚宁区', '1303', '3');
INSERT INTO `t_city_info` VALUES ('130321', '青龙满族自治县', '1303', '3');
INSERT INTO `t_city_info` VALUES ('130322', '昌黎县', '1303', '3');
INSERT INTO `t_city_info` VALUES ('130324', '卢龙县', '1303', '3');
INSERT INTO `t_city_info` VALUES ('1304', '邯郸市', '13', '2');
INSERT INTO `t_city_info` VALUES ('130401', '邯郸市市辖区', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130402', '邯山区', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130403', '丛台区', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130404', '复兴区', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130406', '峰峰矿区', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130407', '肥乡区', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130408', '永年区', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130423', '临漳县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130424', '成安县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130425', '大名县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130426', '涉县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130427', '磁县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130430', '邱县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130431', '鸡泽县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130432', '广平县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130433', '馆陶县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130434', '魏县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130435', '曲周县', '1304', '3');
INSERT INTO `t_city_info` VALUES ('130481', '武安市', '1304', '3');
INSERT INTO `t_city_info` VALUES ('1305', '邢台市', '13', '2');
INSERT INTO `t_city_info` VALUES ('130501', '邢台市市辖区', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130502', '襄都区', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130503', '信都区', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130505', '任泽区', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130506', '南和区', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130522', '临城县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130523', '内丘县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130524', '柏乡县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130525', '隆尧县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130528', '宁晋县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130529', '巨鹿县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130530', '新河县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130531', '广宗县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130532', '平乡县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130533', '威县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130534', '清河县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130535', '临西县', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130581', '南宫市', '1305', '3');
INSERT INTO `t_city_info` VALUES ('130582', '沙河市', '1305', '3');
INSERT INTO `t_city_info` VALUES ('1306', '保定市', '13', '2');
INSERT INTO `t_city_info` VALUES ('130601', '保定市市辖区', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130602', '竞秀区', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130606', '莲池区', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130607', '满城区', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130608', '清苑区', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130609', '徐水区', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130623', '涞水县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130624', '阜平县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130626', '定兴县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130627', '唐县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130628', '高阳县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130629', '容城县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130630', '涞源县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130631', '望都县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130632', '安新县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130633', '易县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130634', '曲阳县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130635', '蠡县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130636', '顺平县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130637', '博野县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130638', '雄县', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130681', '涿州市', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130682', '定州市', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130683', '安国市', '1306', '3');
INSERT INTO `t_city_info` VALUES ('130684', '高碑店市', '1306', '3');
INSERT INTO `t_city_info` VALUES ('1307', '张家口市', '13', '2');
INSERT INTO `t_city_info` VALUES ('130701', '张家口市市辖区', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130702', '桥东区', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130703', '桥西区', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130705', '宣化区', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130706', '下花园区', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130708', '万全区', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130709', '崇礼区', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130722', '张北县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130723', '康保县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130724', '沽源县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130725', '尚义县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130726', '蔚县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130727', '阳原县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130728', '怀安县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130730', '怀来县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130731', '涿鹿县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('130732', '赤城县', '1307', '3');
INSERT INTO `t_city_info` VALUES ('1308', '承德市', '13', '2');
INSERT INTO `t_city_info` VALUES ('130801', '承德市市辖区', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130802', '双桥区', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130803', '双滦区', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130804', '鹰手营子矿区', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130821', '承德县', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130822', '兴隆县', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130824', '滦平县', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130825', '隆化县', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130826', '丰宁满族自治县', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130827', '宽城满族自治县', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130828', '围场满族蒙古族自治县', '1308', '3');
INSERT INTO `t_city_info` VALUES ('130881', '平泉市', '1308', '3');
INSERT INTO `t_city_info` VALUES ('1309', '沧州市', '13', '2');
INSERT INTO `t_city_info` VALUES ('130901', '沧州市市辖区', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130902', '新华区', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130903', '运河区', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130921', '沧县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130922', '青县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130923', '东光县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130924', '海兴县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130925', '盐山县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130926', '肃宁县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130927', '南皮县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130928', '吴桥县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130929', '献县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130930', '孟村回族自治县', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130981', '泊头市', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130982', '任丘市', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130983', '黄骅市', '1309', '3');
INSERT INTO `t_city_info` VALUES ('130984', '河间市', '1309', '3');
INSERT INTO `t_city_info` VALUES ('1310', '廊坊市', '13', '2');
INSERT INTO `t_city_info` VALUES ('131001', '廊坊市市辖区', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131002', '安次区', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131003', '广阳区', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131022', '固安县', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131023', '永清县', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131024', '香河县', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131025', '大城县', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131026', '文安县', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131028', '大厂回族自治县', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131081', '霸州市', '1310', '3');
INSERT INTO `t_city_info` VALUES ('131082', '三河市', '1310', '3');
INSERT INTO `t_city_info` VALUES ('1311', '衡水市', '13', '2');
INSERT INTO `t_city_info` VALUES ('131101', '衡水市市辖区', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131102', '桃城区', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131103', '冀州区', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131121', '枣强县', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131122', '武邑县', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131123', '武强县', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131124', '饶阳县', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131125', '安平县', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131126', '故城县', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131127', '景县', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131128', '阜城县', '1311', '3');
INSERT INTO `t_city_info` VALUES ('131182', '深州市', '1311', '3');
INSERT INTO `t_city_info` VALUES ('14', '山西省', null, '1');
INSERT INTO `t_city_info` VALUES ('1401', '太原市', '14', '2');
INSERT INTO `t_city_info` VALUES ('140101', '太原市市辖区', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140105', '小店区', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140106', '迎泽区', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140107', '杏花岭区', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140108', '尖草坪区', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140109', '万柏林区', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140110', '晋源区', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140121', '清徐县', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140122', '阳曲县', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140123', '娄烦县', '1401', '3');
INSERT INTO `t_city_info` VALUES ('140181', '古交市', '1401', '3');
INSERT INTO `t_city_info` VALUES ('1402', '大同市', '14', '2');
INSERT INTO `t_city_info` VALUES ('140201', '大同市市辖区', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140212', '新荣区', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140213', '平城区', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140214', '云冈区', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140215', '云州区', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140221', '阳高县', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140222', '天镇县', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140223', '广灵县', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140224', '灵丘县', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140225', '浑源县', '1402', '3');
INSERT INTO `t_city_info` VALUES ('140226', '左云县', '1402', '3');
INSERT INTO `t_city_info` VALUES ('1403', '阳泉市', '14', '2');
INSERT INTO `t_city_info` VALUES ('140301', '阳泉市市辖区', '1403', '3');
INSERT INTO `t_city_info` VALUES ('140302', '城区', '1403', '3');
INSERT INTO `t_city_info` VALUES ('140303', '矿区', '1403', '3');
INSERT INTO `t_city_info` VALUES ('140311', '郊区', '1403', '3');
INSERT INTO `t_city_info` VALUES ('140321', '平定县', '1403', '3');
INSERT INTO `t_city_info` VALUES ('140322', '盂县', '1403', '3');
INSERT INTO `t_city_info` VALUES ('1404', '长治市', '14', '2');
INSERT INTO `t_city_info` VALUES ('140401', '长治市市辖区', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140403', '潞州区', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140404', '上党区', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140405', '屯留区', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140406', '潞城区', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140423', '襄垣县', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140425', '平顺县', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140426', '黎城县', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140427', '壶关县', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140428', '长子县', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140429', '武乡县', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140430', '沁县', '1404', '3');
INSERT INTO `t_city_info` VALUES ('140431', '沁源县', '1404', '3');
INSERT INTO `t_city_info` VALUES ('1405', '晋城市', '14', '2');
INSERT INTO `t_city_info` VALUES ('140501', '晋城市市辖区', '1405', '3');
INSERT INTO `t_city_info` VALUES ('140502', '城区', '1405', '3');
INSERT INTO `t_city_info` VALUES ('140521', '沁水县', '1405', '3');
INSERT INTO `t_city_info` VALUES ('140522', '阳城县', '1405', '3');
INSERT INTO `t_city_info` VALUES ('140524', '陵川县', '1405', '3');
INSERT INTO `t_city_info` VALUES ('140525', '泽州县', '1405', '3');
INSERT INTO `t_city_info` VALUES ('140581', '高平市', '1405', '3');
INSERT INTO `t_city_info` VALUES ('1406', '朔州市', '14', '2');
INSERT INTO `t_city_info` VALUES ('140601', '朔州市市辖区', '1406', '3');
INSERT INTO `t_city_info` VALUES ('140602', '朔城区', '1406', '3');
INSERT INTO `t_city_info` VALUES ('140603', '平鲁区', '1406', '3');
INSERT INTO `t_city_info` VALUES ('140621', '山阴县', '1406', '3');
INSERT INTO `t_city_info` VALUES ('140622', '应县', '1406', '3');
INSERT INTO `t_city_info` VALUES ('140623', '右玉县', '1406', '3');
INSERT INTO `t_city_info` VALUES ('140681', '怀仁市', '1406', '3');
INSERT INTO `t_city_info` VALUES ('1407', '晋中市', '14', '2');
INSERT INTO `t_city_info` VALUES ('140701', '晋中市市辖区', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140702', '榆次区', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140703', '太谷区', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140721', '榆社县', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140722', '左权县', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140723', '和顺县', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140724', '昔阳县', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140725', '寿阳县', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140727', '祁县', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140728', '平遥县', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140729', '灵石县', '1407', '3');
INSERT INTO `t_city_info` VALUES ('140781', '介休市', '1407', '3');
INSERT INTO `t_city_info` VALUES ('1408', '运城市', '14', '2');
INSERT INTO `t_city_info` VALUES ('140801', '运城市市辖区', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140802', '盐湖区', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140821', '临猗县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140822', '万荣县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140823', '闻喜县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140824', '稷山县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140825', '新绛县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140826', '绛县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140827', '垣曲县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140828', '夏县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140829', '平陆县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140830', '芮城县', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140881', '永济市', '1408', '3');
INSERT INTO `t_city_info` VALUES ('140882', '河津市', '1408', '3');
INSERT INTO `t_city_info` VALUES ('1409', '忻州市', '14', '2');
INSERT INTO `t_city_info` VALUES ('140901', '忻州市市辖区', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140902', '忻府区', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140921', '定襄县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140922', '五台县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140923', '代县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140924', '繁峙县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140925', '宁武县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140926', '静乐县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140927', '神池县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140928', '五寨县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140929', '岢岚县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140930', '河曲县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140931', '保德县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140932', '偏关县', '1409', '3');
INSERT INTO `t_city_info` VALUES ('140981', '原平市', '1409', '3');
INSERT INTO `t_city_info` VALUES ('1410', '临汾市', '14', '2');
INSERT INTO `t_city_info` VALUES ('141001', '临汾市市辖区', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141002', '尧都区', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141021', '曲沃县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141022', '翼城县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141023', '襄汾县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141024', '洪洞县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141025', '古县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141026', '安泽县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141027', '浮山县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141028', '吉县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141029', '乡宁县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141030', '大宁县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141031', '隰县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141032', '永和县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141033', '蒲县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141034', '汾西县', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141081', '侯马市', '1410', '3');
INSERT INTO `t_city_info` VALUES ('141082', '霍州市', '1410', '3');
INSERT INTO `t_city_info` VALUES ('1411', '吕梁市', '14', '2');
INSERT INTO `t_city_info` VALUES ('141101', '吕梁市市辖区', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141102', '离石区', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141121', '文水县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141122', '交城县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141123', '兴县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141124', '临县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141125', '柳林县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141126', '石楼县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141127', '岚县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141128', '方山县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141129', '中阳县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141130', '交口县', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141181', '孝义市', '1411', '3');
INSERT INTO `t_city_info` VALUES ('141182', '汾阳市', '1411', '3');
INSERT INTO `t_city_info` VALUES ('15', '内蒙古自治区', null, '1');
INSERT INTO `t_city_info` VALUES ('1501', '呼和浩特市', '15', '2');
INSERT INTO `t_city_info` VALUES ('150101', '呼和浩特市市辖区', '1501', '3');
INSERT INTO `t_city_info` VALUES ('150102', '新城区', '1501', '3');
INSERT INTO `t_city_info` VALUES ('150103', '回民区', '1501', '3');
INSERT INTO `t_city_info` VALUES ('150104', '玉泉区', '1501', '3');
INSERT INTO `t_city_info` VALUES ('150105', '赛罕区', '1501', '3');
INSERT INTO `t_city_info` VALUES ('150121', '土默特左旗', '1501', '3');
INSERT INTO `t_city_info` VALUES ('150122', '托克托县', '1501', '3');
INSERT INTO `t_city_info` VALUES ('150123', '和林格尔县', '1501', '3');
INSERT INTO `t_city_info` VALUES ('150124', '清水河县', '1501', '3');
INSERT INTO `t_city_info` VALUES ('150125', '武川县', '1501', '3');
INSERT INTO `t_city_info` VALUES ('1502', '包头市', '15', '2');
INSERT INTO `t_city_info` VALUES ('150201', '包头市市辖区', '1502', '3');
INSERT INTO `t_city_info` VALUES ('150202', '东河区', '1502', '3');
INSERT INTO `t_city_info` VALUES ('150203', '昆都仑区', '1502', '3');
INSERT INTO `t_city_info` VALUES ('150204', '青山区', '1502', '3');
INSERT INTO `t_city_info` VALUES ('150205', '石拐区', '1502', '3');
INSERT INTO `t_city_info` VALUES ('150206', '白云鄂博矿区', '1502', '3');
INSERT INTO `t_city_info` VALUES ('150207', '九原区', '1502', '3');
INSERT INTO `t_city_info` VALUES ('150221', '土默特右旗', '1502', '3');
INSERT INTO `t_city_info` VALUES ('150222', '固阳县', '1502', '3');
INSERT INTO `t_city_info` VALUES ('150223', '达尔罕茂明安联合旗', '1502', '3');
INSERT INTO `t_city_info` VALUES ('1503', '乌海市', '15', '2');
INSERT INTO `t_city_info` VALUES ('150301', '乌海市市辖区', '1503', '3');
INSERT INTO `t_city_info` VALUES ('150302', '海勃湾区', '1503', '3');
INSERT INTO `t_city_info` VALUES ('150303', '海南区', '1503', '3');
INSERT INTO `t_city_info` VALUES ('150304', '乌达区', '1503', '3');
INSERT INTO `t_city_info` VALUES ('1504', '赤峰市', '15', '2');
INSERT INTO `t_city_info` VALUES ('150401', '赤峰市市辖区', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150402', '红山区', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150403', '元宝山区', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150404', '松山区', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150421', '阿鲁科尔沁旗', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150422', '巴林左旗', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150423', '巴林右旗', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150424', '林西县', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150425', '克什克腾旗', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150426', '翁牛特旗', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150428', '喀喇沁旗', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150429', '宁城县', '1504', '3');
INSERT INTO `t_city_info` VALUES ('150430', '敖汉旗', '1504', '3');
INSERT INTO `t_city_info` VALUES ('1505', '通辽市', '15', '2');
INSERT INTO `t_city_info` VALUES ('150501', '通辽市市辖区', '1505', '3');
INSERT INTO `t_city_info` VALUES ('150502', '科尔沁区', '1505', '3');
INSERT INTO `t_city_info` VALUES ('150521', '科尔沁左翼中旗', '1505', '3');
INSERT INTO `t_city_info` VALUES ('150522', '科尔沁左翼后旗', '1505', '3');
INSERT INTO `t_city_info` VALUES ('150523', '开鲁县', '1505', '3');
INSERT INTO `t_city_info` VALUES ('150524', '库伦旗', '1505', '3');
INSERT INTO `t_city_info` VALUES ('150525', '奈曼旗', '1505', '3');
INSERT INTO `t_city_info` VALUES ('150526', '扎鲁特旗', '1505', '3');
INSERT INTO `t_city_info` VALUES ('150581', '霍林郭勒市', '1505', '3');
INSERT INTO `t_city_info` VALUES ('1506', '鄂尔多斯市', '15', '2');
INSERT INTO `t_city_info` VALUES ('150601', '鄂尔多斯市市辖区', '1506', '3');
INSERT INTO `t_city_info` VALUES ('150602', '东胜区', '1506', '3');
INSERT INTO `t_city_info` VALUES ('150603', '康巴什区', '1506', '3');
INSERT INTO `t_city_info` VALUES ('150621', '达拉特旗', '1506', '3');
INSERT INTO `t_city_info` VALUES ('150622', '准格尔旗', '1506', '3');
INSERT INTO `t_city_info` VALUES ('150623', '鄂托克前旗', '1506', '3');
INSERT INTO `t_city_info` VALUES ('150624', '鄂托克旗', '1506', '3');
INSERT INTO `t_city_info` VALUES ('150625', '杭锦旗', '1506', '3');
INSERT INTO `t_city_info` VALUES ('150626', '乌审旗', '1506', '3');
INSERT INTO `t_city_info` VALUES ('150627', '伊金霍洛旗', '1506', '3');
INSERT INTO `t_city_info` VALUES ('1507', '呼伦贝尔市', '15', '2');
INSERT INTO `t_city_info` VALUES ('150701', '呼伦贝尔市市辖区', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150702', '海拉尔区', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150703', '扎赉诺尔区', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150721', '阿荣旗', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150722', '莫力达瓦达斡尔族自治旗', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150723', '鄂伦春自治旗', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150724', '鄂温克族自治旗', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150725', '陈巴尔虎旗', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150726', '新巴尔虎左旗', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150727', '新巴尔虎右旗', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150781', '满洲里市', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150782', '牙克石市', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150783', '扎兰屯市', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150784', '额尔古纳市', '1507', '3');
INSERT INTO `t_city_info` VALUES ('150785', '根河市', '1507', '3');
INSERT INTO `t_city_info` VALUES ('1508', '巴彦淖尔市', '15', '2');
INSERT INTO `t_city_info` VALUES ('150801', '巴彦淖尔市市辖区', '1508', '3');
INSERT INTO `t_city_info` VALUES ('150802', '临河区', '1508', '3');
INSERT INTO `t_city_info` VALUES ('150821', '五原县', '1508', '3');
INSERT INTO `t_city_info` VALUES ('150822', '磴口县', '1508', '3');
INSERT INTO `t_city_info` VALUES ('150823', '乌拉特前旗', '1508', '3');
INSERT INTO `t_city_info` VALUES ('150824', '乌拉特中旗', '1508', '3');
INSERT INTO `t_city_info` VALUES ('150825', '乌拉特后旗', '1508', '3');
INSERT INTO `t_city_info` VALUES ('150826', '杭锦后旗', '1508', '3');
INSERT INTO `t_city_info` VALUES ('1509', '乌兰察布市', '15', '2');
INSERT INTO `t_city_info` VALUES ('150901', '乌兰察布市市辖区', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150902', '集宁区', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150921', '卓资县', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150922', '化德县', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150923', '商都县', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150924', '兴和县', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150925', '凉城县', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150926', '察哈尔右翼前旗', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150927', '察哈尔右翼中旗', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150928', '察哈尔右翼后旗', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150929', '四子王旗', '1509', '3');
INSERT INTO `t_city_info` VALUES ('150981', '丰镇市', '1509', '3');
INSERT INTO `t_city_info` VALUES ('1522', '兴安盟', '15', '2');
INSERT INTO `t_city_info` VALUES ('152201', '乌兰浩特市', '1522', '3');
INSERT INTO `t_city_info` VALUES ('152202', '阿尔山市', '1522', '3');
INSERT INTO `t_city_info` VALUES ('152221', '科尔沁右翼前旗', '1522', '3');
INSERT INTO `t_city_info` VALUES ('152222', '科尔沁右翼中旗', '1522', '3');
INSERT INTO `t_city_info` VALUES ('152223', '扎赉特旗', '1522', '3');
INSERT INTO `t_city_info` VALUES ('152224', '突泉县', '1522', '3');
INSERT INTO `t_city_info` VALUES ('1525', '锡林郭勒盟', '15', '2');
INSERT INTO `t_city_info` VALUES ('152501', '二连浩特市', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152502', '锡林浩特市', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152522', '阿巴嘎旗', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152523', '苏尼特左旗', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152524', '苏尼特右旗', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152525', '东乌珠穆沁旗', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152526', '西乌珠穆沁旗', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152527', '太仆寺旗', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152528', '镶黄旗', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152529', '正镶白旗', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152530', '正蓝旗', '1525', '3');
INSERT INTO `t_city_info` VALUES ('152531', '多伦县', '1525', '3');
INSERT INTO `t_city_info` VALUES ('1529', '阿拉善盟', '15', '2');
INSERT INTO `t_city_info` VALUES ('152921', '阿拉善左旗', '1529', '3');
INSERT INTO `t_city_info` VALUES ('152922', '阿拉善右旗', '1529', '3');
INSERT INTO `t_city_info` VALUES ('152923', '额济纳旗', '1529', '3');
INSERT INTO `t_city_info` VALUES ('21', '辽宁省', null, '1');
INSERT INTO `t_city_info` VALUES ('2101', '沈阳市', '21', '2');
INSERT INTO `t_city_info` VALUES ('210101', '沈阳市市辖区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210102', '和平区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210103', '沈河区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210104', '大东区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210105', '皇姑区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210106', '铁西区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210111', '苏家屯区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210112', '浑南区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210113', '沈北新区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210114', '于洪区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210115', '辽中区', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210123', '康平县', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210124', '法库县', '2101', '3');
INSERT INTO `t_city_info` VALUES ('210181', '新民市', '2101', '3');
INSERT INTO `t_city_info` VALUES ('2102', '大连市', '21', '2');
INSERT INTO `t_city_info` VALUES ('210201', '大连市市辖区', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210202', '中山区', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210203', '西岗区', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210204', '沙河口区', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210211', '甘井子区', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210212', '旅顺口区', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210213', '金州区', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210214', '普兰店区', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210224', '长海县', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210281', '瓦房店市', '2102', '3');
INSERT INTO `t_city_info` VALUES ('210283', '庄河市', '2102', '3');
INSERT INTO `t_city_info` VALUES ('2103', '鞍山市', '21', '2');
INSERT INTO `t_city_info` VALUES ('210301', '鞍山市市辖区', '2103', '3');
INSERT INTO `t_city_info` VALUES ('210302', '铁东区', '2103', '3');
INSERT INTO `t_city_info` VALUES ('210303', '铁西区', '2103', '3');
INSERT INTO `t_city_info` VALUES ('210304', '立山区', '2103', '3');
INSERT INTO `t_city_info` VALUES ('210311', '千山区', '2103', '3');
INSERT INTO `t_city_info` VALUES ('210321', '台安县', '2103', '3');
INSERT INTO `t_city_info` VALUES ('210323', '岫岩满族自治县', '2103', '3');
INSERT INTO `t_city_info` VALUES ('210381', '海城市', '2103', '3');
INSERT INTO `t_city_info` VALUES ('2104', '抚顺市', '21', '2');
INSERT INTO `t_city_info` VALUES ('210401', '抚顺市市辖区', '2104', '3');
INSERT INTO `t_city_info` VALUES ('210402', '新抚区', '2104', '3');
INSERT INTO `t_city_info` VALUES ('210403', '东洲区', '2104', '3');
INSERT INTO `t_city_info` VALUES ('210404', '望花区', '2104', '3');
INSERT INTO `t_city_info` VALUES ('210411', '顺城区', '2104', '3');
INSERT INTO `t_city_info` VALUES ('210421', '抚顺县', '2104', '3');
INSERT INTO `t_city_info` VALUES ('210422', '新宾满族自治县', '2104', '3');
INSERT INTO `t_city_info` VALUES ('210423', '清原满族自治县', '2104', '3');
INSERT INTO `t_city_info` VALUES ('2105', '本溪市', '21', '2');
INSERT INTO `t_city_info` VALUES ('210501', '本溪市市辖区', '2105', '3');
INSERT INTO `t_city_info` VALUES ('210502', '平山区', '2105', '3');
INSERT INTO `t_city_info` VALUES ('210503', '溪湖区', '2105', '3');
INSERT INTO `t_city_info` VALUES ('210504', '明山区', '2105', '3');
INSERT INTO `t_city_info` VALUES ('210505', '南芬区', '2105', '3');
INSERT INTO `t_city_info` VALUES ('210521', '本溪满族自治县', '2105', '3');
INSERT INTO `t_city_info` VALUES ('210522', '桓仁满族自治县', '2105', '3');
INSERT INTO `t_city_info` VALUES ('2106', '丹东市', '21', '2');
INSERT INTO `t_city_info` VALUES ('210601', '丹东市市辖区', '2106', '3');
INSERT INTO `t_city_info` VALUES ('210602', '元宝区', '2106', '3');
INSERT INTO `t_city_info` VALUES ('210603', '振兴区', '2106', '3');
INSERT INTO `t_city_info` VALUES ('210604', '振安区', '2106', '3');
INSERT INTO `t_city_info` VALUES ('210624', '宽甸满族自治县', '2106', '3');
INSERT INTO `t_city_info` VALUES ('210681', '东港市', '2106', '3');
INSERT INTO `t_city_info` VALUES ('210682', '凤城市', '2106', '3');
INSERT INTO `t_city_info` VALUES ('2107', '锦州市', '21', '2');
INSERT INTO `t_city_info` VALUES ('210701', '锦州市市辖区', '2107', '3');
INSERT INTO `t_city_info` VALUES ('210702', '古塔区', '2107', '3');
INSERT INTO `t_city_info` VALUES ('210703', '凌河区', '2107', '3');
INSERT INTO `t_city_info` VALUES ('210711', '太和区', '2107', '3');
INSERT INTO `t_city_info` VALUES ('210726', '黑山县', '2107', '3');
INSERT INTO `t_city_info` VALUES ('210727', '义县', '2107', '3');
INSERT INTO `t_city_info` VALUES ('210781', '凌海市', '2107', '3');
INSERT INTO `t_city_info` VALUES ('210782', '北镇市', '2107', '3');
INSERT INTO `t_city_info` VALUES ('2108', '营口市', '21', '2');
INSERT INTO `t_city_info` VALUES ('210801', '营口市市辖区', '2108', '3');
INSERT INTO `t_city_info` VALUES ('210802', '站前区', '2108', '3');
INSERT INTO `t_city_info` VALUES ('210803', '西市区', '2108', '3');
INSERT INTO `t_city_info` VALUES ('210804', '鲅鱼圈区', '2108', '3');
INSERT INTO `t_city_info` VALUES ('210811', '老边区', '2108', '3');
INSERT INTO `t_city_info` VALUES ('210881', '盖州市', '2108', '3');
INSERT INTO `t_city_info` VALUES ('210882', '大石桥市', '2108', '3');
INSERT INTO `t_city_info` VALUES ('2109', '阜新市', '21', '2');
INSERT INTO `t_city_info` VALUES ('210901', '阜新市市辖区', '2109', '3');
INSERT INTO `t_city_info` VALUES ('210902', '海州区', '2109', '3');
INSERT INTO `t_city_info` VALUES ('210903', '新邱区', '2109', '3');
INSERT INTO `t_city_info` VALUES ('210904', '太平区', '2109', '3');
INSERT INTO `t_city_info` VALUES ('210905', '清河门区', '2109', '3');
INSERT INTO `t_city_info` VALUES ('210911', '细河区', '2109', '3');
INSERT INTO `t_city_info` VALUES ('210921', '阜新蒙古族自治县', '2109', '3');
INSERT INTO `t_city_info` VALUES ('210922', '彰武县', '2109', '3');
INSERT INTO `t_city_info` VALUES ('2110', '辽阳市', '21', '2');
INSERT INTO `t_city_info` VALUES ('211001', '辽阳市市辖区', '2110', '3');
INSERT INTO `t_city_info` VALUES ('211002', '白塔区', '2110', '3');
INSERT INTO `t_city_info` VALUES ('211003', '文圣区', '2110', '3');
INSERT INTO `t_city_info` VALUES ('211004', '宏伟区', '2110', '3');
INSERT INTO `t_city_info` VALUES ('211005', '弓长岭区', '2110', '3');
INSERT INTO `t_city_info` VALUES ('211011', '太子河区', '2110', '3');
INSERT INTO `t_city_info` VALUES ('211021', '辽阳县', '2110', '3');
INSERT INTO `t_city_info` VALUES ('211081', '灯塔市', '2110', '3');
INSERT INTO `t_city_info` VALUES ('2111', '盘锦市', '21', '2');
INSERT INTO `t_city_info` VALUES ('211101', '盘锦市市辖区', '2111', '3');
INSERT INTO `t_city_info` VALUES ('211102', '双台子区', '2111', '3');
INSERT INTO `t_city_info` VALUES ('211103', '兴隆台区', '2111', '3');
INSERT INTO `t_city_info` VALUES ('211104', '大洼区', '2111', '3');
INSERT INTO `t_city_info` VALUES ('211122', '盘山县', '2111', '3');
INSERT INTO `t_city_info` VALUES ('2112', '铁岭市', '21', '2');
INSERT INTO `t_city_info` VALUES ('211201', '铁岭市市辖区', '2112', '3');
INSERT INTO `t_city_info` VALUES ('211202', '银州区', '2112', '3');
INSERT INTO `t_city_info` VALUES ('211204', '清河区', '2112', '3');
INSERT INTO `t_city_info` VALUES ('211221', '铁岭县', '2112', '3');
INSERT INTO `t_city_info` VALUES ('211223', '西丰县', '2112', '3');
INSERT INTO `t_city_info` VALUES ('211224', '昌图县', '2112', '3');
INSERT INTO `t_city_info` VALUES ('211281', '调兵山市', '2112', '3');
INSERT INTO `t_city_info` VALUES ('211282', '开原市', '2112', '3');
INSERT INTO `t_city_info` VALUES ('2113', '朝阳市', '21', '2');
INSERT INTO `t_city_info` VALUES ('211301', '朝阳市市辖区', '2113', '3');
INSERT INTO `t_city_info` VALUES ('211302', '双塔区', '2113', '3');
INSERT INTO `t_city_info` VALUES ('211303', '龙城区', '2113', '3');
INSERT INTO `t_city_info` VALUES ('211321', '朝阳县', '2113', '3');
INSERT INTO `t_city_info` VALUES ('211322', '建平县', '2113', '3');
INSERT INTO `t_city_info` VALUES ('211324', '喀喇沁左翼蒙古族自治县', '2113', '3');
INSERT INTO `t_city_info` VALUES ('211381', '北票市', '2113', '3');
INSERT INTO `t_city_info` VALUES ('211382', '凌源市', '2113', '3');
INSERT INTO `t_city_info` VALUES ('2114', '葫芦岛市', '21', '2');
INSERT INTO `t_city_info` VALUES ('211401', '葫芦岛市市辖区', '2114', '3');
INSERT INTO `t_city_info` VALUES ('211402', '连山区', '2114', '3');
INSERT INTO `t_city_info` VALUES ('211403', '龙港区', '2114', '3');
INSERT INTO `t_city_info` VALUES ('211404', '南票区', '2114', '3');
INSERT INTO `t_city_info` VALUES ('211421', '绥中县', '2114', '3');
INSERT INTO `t_city_info` VALUES ('211422', '建昌县', '2114', '3');
INSERT INTO `t_city_info` VALUES ('211481', '兴城市', '2114', '3');
INSERT INTO `t_city_info` VALUES ('22', '吉林省', null, '1');
INSERT INTO `t_city_info` VALUES ('2201', '长春市', '22', '2');
INSERT INTO `t_city_info` VALUES ('220101', '长春市市辖区', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220102', '南关区', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220103', '宽城区', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220104', '朝阳区', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220105', '二道区', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220106', '绿园区', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220112', '双阳区', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220113', '九台区', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220122', '农安县', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220182', '榆树市', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220183', '德惠市', '2201', '3');
INSERT INTO `t_city_info` VALUES ('220184', '公主岭市', '2201', '3');
INSERT INTO `t_city_info` VALUES ('2202', '吉林市', '22', '2');
INSERT INTO `t_city_info` VALUES ('220201', '吉林市市辖区', '2202', '3');
INSERT INTO `t_city_info` VALUES ('220202', '昌邑区', '2202', '3');
INSERT INTO `t_city_info` VALUES ('220203', '龙潭区', '2202', '3');
INSERT INTO `t_city_info` VALUES ('220204', '船营区', '2202', '3');
INSERT INTO `t_city_info` VALUES ('220211', '丰满区', '2202', '3');
INSERT INTO `t_city_info` VALUES ('220221', '永吉县', '2202', '3');
INSERT INTO `t_city_info` VALUES ('220281', '蛟河市', '2202', '3');
INSERT INTO `t_city_info` VALUES ('220282', '桦甸市', '2202', '3');
INSERT INTO `t_city_info` VALUES ('220283', '舒兰市', '2202', '3');
INSERT INTO `t_city_info` VALUES ('220284', '磐石市', '2202', '3');
INSERT INTO `t_city_info` VALUES ('2203', '四平市', '22', '2');
INSERT INTO `t_city_info` VALUES ('220301', '四平市市辖区', '2203', '3');
INSERT INTO `t_city_info` VALUES ('220302', '铁西区', '2203', '3');
INSERT INTO `t_city_info` VALUES ('220303', '铁东区', '2203', '3');
INSERT INTO `t_city_info` VALUES ('220322', '梨树县', '2203', '3');
INSERT INTO `t_city_info` VALUES ('220323', '伊通满族自治县', '2203', '3');
INSERT INTO `t_city_info` VALUES ('220382', '双辽市', '2203', '3');
INSERT INTO `t_city_info` VALUES ('2204', '辽源市', '22', '2');
INSERT INTO `t_city_info` VALUES ('220401', '辽源市市辖区', '2204', '3');
INSERT INTO `t_city_info` VALUES ('220402', '龙山区', '2204', '3');
INSERT INTO `t_city_info` VALUES ('220403', '西安区', '2204', '3');
INSERT INTO `t_city_info` VALUES ('220421', '东丰县', '2204', '3');
INSERT INTO `t_city_info` VALUES ('220422', '东辽县', '2204', '3');
INSERT INTO `t_city_info` VALUES ('2205', '通化市', '22', '2');
INSERT INTO `t_city_info` VALUES ('220501', '通化市市辖区', '2205', '3');
INSERT INTO `t_city_info` VALUES ('220502', '东昌区', '2205', '3');
INSERT INTO `t_city_info` VALUES ('220503', '二道江区', '2205', '3');
INSERT INTO `t_city_info` VALUES ('220521', '通化县', '2205', '3');
INSERT INTO `t_city_info` VALUES ('220523', '辉南县', '2205', '3');
INSERT INTO `t_city_info` VALUES ('220524', '柳河县', '2205', '3');
INSERT INTO `t_city_info` VALUES ('220581', '梅河口市', '2205', '3');
INSERT INTO `t_city_info` VALUES ('220582', '集安市', '2205', '3');
INSERT INTO `t_city_info` VALUES ('2206', '白山市', '22', '2');
INSERT INTO `t_city_info` VALUES ('220601', '白山市市辖区', '2206', '3');
INSERT INTO `t_city_info` VALUES ('220602', '浑江区', '2206', '3');
INSERT INTO `t_city_info` VALUES ('220605', '江源区', '2206', '3');
INSERT INTO `t_city_info` VALUES ('220621', '抚松县', '2206', '3');
INSERT INTO `t_city_info` VALUES ('220622', '靖宇县', '2206', '3');
INSERT INTO `t_city_info` VALUES ('220623', '长白朝鲜族自治县', '2206', '3');
INSERT INTO `t_city_info` VALUES ('220681', '临江市', '2206', '3');
INSERT INTO `t_city_info` VALUES ('2207', '松原市', '22', '2');
INSERT INTO `t_city_info` VALUES ('220701', '松原市市辖区', '2207', '3');
INSERT INTO `t_city_info` VALUES ('220702', '宁江区', '2207', '3');
INSERT INTO `t_city_info` VALUES ('220721', '前郭尔罗斯蒙古族自治县', '2207', '3');
INSERT INTO `t_city_info` VALUES ('220722', '长岭县', '2207', '3');
INSERT INTO `t_city_info` VALUES ('220723', '乾安县', '2207', '3');
INSERT INTO `t_city_info` VALUES ('220781', '扶余市', '2207', '3');
INSERT INTO `t_city_info` VALUES ('2208', '白城市', '22', '2');
INSERT INTO `t_city_info` VALUES ('220801', '白城市市辖区', '2208', '3');
INSERT INTO `t_city_info` VALUES ('220802', '洮北区', '2208', '3');
INSERT INTO `t_city_info` VALUES ('220821', '镇赉县', '2208', '3');
INSERT INTO `t_city_info` VALUES ('220822', '通榆县', '2208', '3');
INSERT INTO `t_city_info` VALUES ('220881', '洮南市', '2208', '3');
INSERT INTO `t_city_info` VALUES ('220882', '大安市', '2208', '3');
INSERT INTO `t_city_info` VALUES ('2224', '延边朝鲜族自治州', '22', '2');
INSERT INTO `t_city_info` VALUES ('222401', '延吉市', '2224', '3');
INSERT INTO `t_city_info` VALUES ('222402', '图们市', '2224', '3');
INSERT INTO `t_city_info` VALUES ('222403', '敦化市', '2224', '3');
INSERT INTO `t_city_info` VALUES ('222404', '珲春市', '2224', '3');
INSERT INTO `t_city_info` VALUES ('222405', '龙井市', '2224', '3');
INSERT INTO `t_city_info` VALUES ('222406', '和龙市', '2224', '3');
INSERT INTO `t_city_info` VALUES ('222424', '汪清县', '2224', '3');
INSERT INTO `t_city_info` VALUES ('222426', '安图县', '2224', '3');
INSERT INTO `t_city_info` VALUES ('23', '黑龙江省', null, '1');
INSERT INTO `t_city_info` VALUES ('2301', '哈尔滨市', '23', '2');
INSERT INTO `t_city_info` VALUES ('230101', '哈尔滨市市辖区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230102', '道里区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230103', '南岗区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230104', '道外区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230108', '平房区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230109', '松北区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230110', '香坊区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230111', '呼兰区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230112', '阿城区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230113', '双城区', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230123', '依兰县', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230124', '方正县', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230125', '宾县', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230126', '巴彦县', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230127', '木兰县', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230128', '通河县', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230129', '延寿县', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230183', '尚志市', '2301', '3');
INSERT INTO `t_city_info` VALUES ('230184', '五常市', '2301', '3');
INSERT INTO `t_city_info` VALUES ('2302', '齐齐哈尔市', '23', '2');
INSERT INTO `t_city_info` VALUES ('230201', '齐齐哈尔市市辖区', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230202', '龙沙区', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230203', '建华区', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230204', '铁锋区', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230205', '昂昂溪区', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230206', '富拉尔基区', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230207', '碾子山区', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230208', '梅里斯达斡尔族区', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230221', '龙江县', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230223', '依安县', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230224', '泰来县', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230225', '甘南县', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230227', '富裕县', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230229', '克山县', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230230', '克东县', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230231', '拜泉县', '2302', '3');
INSERT INTO `t_city_info` VALUES ('230281', '讷河市', '2302', '3');
INSERT INTO `t_city_info` VALUES ('2303', '鸡西市', '23', '2');
INSERT INTO `t_city_info` VALUES ('230301', '鸡西市市辖区', '2303', '3');
INSERT INTO `t_city_info` VALUES ('230302', '鸡冠区', '2303', '3');
INSERT INTO `t_city_info` VALUES ('230303', '恒山区', '2303', '3');
INSERT INTO `t_city_info` VALUES ('230304', '滴道区', '2303', '3');
INSERT INTO `t_city_info` VALUES ('230305', '梨树区', '2303', '3');
INSERT INTO `t_city_info` VALUES ('230306', '城子河区', '2303', '3');
INSERT INTO `t_city_info` VALUES ('230307', '麻山区', '2303', '3');
INSERT INTO `t_city_info` VALUES ('230321', '鸡东县', '2303', '3');
INSERT INTO `t_city_info` VALUES ('230381', '虎林市', '2303', '3');
INSERT INTO `t_city_info` VALUES ('230382', '密山市', '2303', '3');
INSERT INTO `t_city_info` VALUES ('2304', '鹤岗市', '23', '2');
INSERT INTO `t_city_info` VALUES ('230401', '鹤岗市市辖区', '2304', '3');
INSERT INTO `t_city_info` VALUES ('230402', '向阳区', '2304', '3');
INSERT INTO `t_city_info` VALUES ('230403', '工农区', '2304', '3');
INSERT INTO `t_city_info` VALUES ('230404', '南山区', '2304', '3');
INSERT INTO `t_city_info` VALUES ('230405', '兴安区', '2304', '3');
INSERT INTO `t_city_info` VALUES ('230406', '东山区', '2304', '3');
INSERT INTO `t_city_info` VALUES ('230407', '兴山区', '2304', '3');
INSERT INTO `t_city_info` VALUES ('230421', '萝北县', '2304', '3');
INSERT INTO `t_city_info` VALUES ('230422', '绥滨县', '2304', '3');
INSERT INTO `t_city_info` VALUES ('2305', '双鸭山市', '23', '2');
INSERT INTO `t_city_info` VALUES ('230501', '双鸭山市市辖区', '2305', '3');
INSERT INTO `t_city_info` VALUES ('230502', '尖山区', '2305', '3');
INSERT INTO `t_city_info` VALUES ('230503', '岭东区', '2305', '3');
INSERT INTO `t_city_info` VALUES ('230505', '四方台区', '2305', '3');
INSERT INTO `t_city_info` VALUES ('230506', '宝山区', '2305', '3');
INSERT INTO `t_city_info` VALUES ('230521', '集贤县', '2305', '3');
INSERT INTO `t_city_info` VALUES ('230522', '友谊县', '2305', '3');
INSERT INTO `t_city_info` VALUES ('230523', '宝清县', '2305', '3');
INSERT INTO `t_city_info` VALUES ('230524', '饶河县', '2305', '3');
INSERT INTO `t_city_info` VALUES ('2306', '大庆市', '23', '2');
INSERT INTO `t_city_info` VALUES ('230601', '大庆市市辖区', '2306', '3');
INSERT INTO `t_city_info` VALUES ('230602', '萨尔图区', '2306', '3');
INSERT INTO `t_city_info` VALUES ('230603', '龙凤区', '2306', '3');
INSERT INTO `t_city_info` VALUES ('230604', '让胡路区', '2306', '3');
INSERT INTO `t_city_info` VALUES ('230605', '红岗区', '2306', '3');
INSERT INTO `t_city_info` VALUES ('230606', '大同区', '2306', '3');
INSERT INTO `t_city_info` VALUES ('230621', '肇州县', '2306', '3');
INSERT INTO `t_city_info` VALUES ('230622', '肇源县', '2306', '3');
INSERT INTO `t_city_info` VALUES ('230623', '林甸县', '2306', '3');
INSERT INTO `t_city_info` VALUES ('230624', '杜尔伯特蒙古族自治县', '2306', '3');
INSERT INTO `t_city_info` VALUES ('2307', '伊春市', '23', '2');
INSERT INTO `t_city_info` VALUES ('230701', '伊春市市辖区', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230712', '汤旺河区', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230717', '伊美区', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230718', '乌翠区', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230719', '友好区', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230722', '嘉荫县', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230723', '汤旺县', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230724', '丰林县', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230725', '大箐山县', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230726', '南岔县', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230751', '金林区', '2307', '3');
INSERT INTO `t_city_info` VALUES ('230781', '铁力市', '2307', '3');
INSERT INTO `t_city_info` VALUES ('2308', '佳木斯市', '23', '2');
INSERT INTO `t_city_info` VALUES ('230801', '佳木斯市市辖区', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230803', '向阳区', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230804', '前进区', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230805', '东风区', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230811', '郊区', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230822', '桦南县', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230826', '桦川县', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230828', '汤原县', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230881', '同江市', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230882', '富锦市', '2308', '3');
INSERT INTO `t_city_info` VALUES ('230883', '抚远市', '2308', '3');
INSERT INTO `t_city_info` VALUES ('2309', '七台河市', '23', '2');
INSERT INTO `t_city_info` VALUES ('230901', '七台河市市辖区', '2309', '3');
INSERT INTO `t_city_info` VALUES ('230902', '新兴区', '2309', '3');
INSERT INTO `t_city_info` VALUES ('230903', '桃山区', '2309', '3');
INSERT INTO `t_city_info` VALUES ('230904', '茄子河区', '2309', '3');
INSERT INTO `t_city_info` VALUES ('230921', '勃利县', '2309', '3');
INSERT INTO `t_city_info` VALUES ('2310', '牡丹江市', '23', '2');
INSERT INTO `t_city_info` VALUES ('231001', '牡丹江市市辖区', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231002', '东安区', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231003', '阳明区', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231004', '爱民区', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231005', '西安区', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231025', '林口县', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231081', '绥芬河市', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231083', '海林市', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231084', '宁安市', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231085', '穆棱市', '2310', '3');
INSERT INTO `t_city_info` VALUES ('231086', '东宁市', '2310', '3');
INSERT INTO `t_city_info` VALUES ('2311', '黑河市', '23', '2');
INSERT INTO `t_city_info` VALUES ('231101', '黑河市市辖区', '2311', '3');
INSERT INTO `t_city_info` VALUES ('231102', '爱辉区', '2311', '3');
INSERT INTO `t_city_info` VALUES ('231123', '逊克县', '2311', '3');
INSERT INTO `t_city_info` VALUES ('231124', '孙吴县', '2311', '3');
INSERT INTO `t_city_info` VALUES ('231181', '北安市', '2311', '3');
INSERT INTO `t_city_info` VALUES ('231182', '五大连池市', '2311', '3');
INSERT INTO `t_city_info` VALUES ('231183', '嫩江市', '2311', '3');
INSERT INTO `t_city_info` VALUES ('2312', '绥化市', '23', '2');
INSERT INTO `t_city_info` VALUES ('231201', '绥化市市辖区', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231202', '北林区', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231221', '望奎县', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231222', '兰西县', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231223', '青冈县', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231224', '庆安县', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231225', '明水县', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231226', '绥棱县', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231281', '安达市', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231282', '肇东市', '2312', '3');
INSERT INTO `t_city_info` VALUES ('231283', '海伦市', '2312', '3');
INSERT INTO `t_city_info` VALUES ('2327', '大兴安岭地区', '23', '2');
INSERT INTO `t_city_info` VALUES ('232701', '漠河市', '2327', '3');
INSERT INTO `t_city_info` VALUES ('232718', '加格达奇区', '2327', '3');
INSERT INTO `t_city_info` VALUES ('232721', '呼玛县', '2327', '3');
INSERT INTO `t_city_info` VALUES ('232722', '塔河县', '2327', '3');
INSERT INTO `t_city_info` VALUES ('31', '上海市', null, '1');
INSERT INTO `t_city_info` VALUES ('3101', '上海市直辖市', '31', '2');
INSERT INTO `t_city_info` VALUES ('310101', '黄浦区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310104', '徐汇区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310105', '长宁区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310106', '静安区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310107', '普陀区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310109', '虹口区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310110', '杨浦区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310112', '闵行区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310113', '宝山区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310114', '嘉定区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310115', '浦东新区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310116', '金山区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310117', '松江区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310118', '青浦区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310120', '奉贤区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('310151', '崇明区', '3101', '3');
INSERT INTO `t_city_info` VALUES ('32', '江苏省', null, '1');
INSERT INTO `t_city_info` VALUES ('3201', '南京市', '32', '2');
INSERT INTO `t_city_info` VALUES ('320101', '南京市市辖区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320102', '玄武区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320104', '秦淮区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320105', '建邺区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320106', '鼓楼区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320111', '浦口区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320113', '栖霞区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320114', '雨花台区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320115', '江宁区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320116', '六合区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320117', '溧水区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('320118', '高淳区', '3201', '3');
INSERT INTO `t_city_info` VALUES ('3202', '无锡市', '32', '2');
INSERT INTO `t_city_info` VALUES ('320201', '无锡市市辖区', '3202', '3');
INSERT INTO `t_city_info` VALUES ('320205', '锡山区', '3202', '3');
INSERT INTO `t_city_info` VALUES ('320206', '惠山区', '3202', '3');
INSERT INTO `t_city_info` VALUES ('320211', '滨湖区', '3202', '3');
INSERT INTO `t_city_info` VALUES ('320213', '梁溪区', '3202', '3');
INSERT INTO `t_city_info` VALUES ('320214', '新吴区', '3202', '3');
INSERT INTO `t_city_info` VALUES ('320281', '江阴市', '3202', '3');
INSERT INTO `t_city_info` VALUES ('320282', '宜兴市', '3202', '3');
INSERT INTO `t_city_info` VALUES ('3203', '徐州市', '32', '2');
INSERT INTO `t_city_info` VALUES ('320301', '徐州市市辖区', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320302', '鼓楼区', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320303', '云龙区', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320305', '贾汪区', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320311', '泉山区', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320312', '铜山区', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320321', '丰县', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320322', '沛县', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320324', '睢宁县', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320381', '新沂市', '3203', '3');
INSERT INTO `t_city_info` VALUES ('320382', '邳州市', '3203', '3');
INSERT INTO `t_city_info` VALUES ('3204', '常州市', '32', '2');
INSERT INTO `t_city_info` VALUES ('320401', '常州市市辖区', '3204', '3');
INSERT INTO `t_city_info` VALUES ('320402', '天宁区', '3204', '3');
INSERT INTO `t_city_info` VALUES ('320404', '钟楼区', '3204', '3');
INSERT INTO `t_city_info` VALUES ('320411', '新北区', '3204', '3');
INSERT INTO `t_city_info` VALUES ('320412', '武进区', '3204', '3');
INSERT INTO `t_city_info` VALUES ('320413', '金坛区', '3204', '3');
INSERT INTO `t_city_info` VALUES ('320481', '溧阳市', '3204', '3');
INSERT INTO `t_city_info` VALUES ('3205', '苏州市', '32', '2');
INSERT INTO `t_city_info` VALUES ('320501', '苏州市市辖区', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320505', '虎丘区', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320506', '吴中区', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320507', '相城区', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320508', '姑苏区', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320509', '吴江区', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320571', '苏州工业园区', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320581', '常熟市', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320582', '张家港市', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320583', '昆山市', '3205', '3');
INSERT INTO `t_city_info` VALUES ('320585', '太仓市', '3205', '3');
INSERT INTO `t_city_info` VALUES ('3206', '南通市', '32', '2');
INSERT INTO `t_city_info` VALUES ('320601', '南通市市辖区', '3206', '3');
INSERT INTO `t_city_info` VALUES ('320602', '崇川区', '3206', '3');
INSERT INTO `t_city_info` VALUES ('320612', '通州区', '3206', '3');
INSERT INTO `t_city_info` VALUES ('320623', '如东县', '3206', '3');
INSERT INTO `t_city_info` VALUES ('320681', '启东市', '3206', '3');
INSERT INTO `t_city_info` VALUES ('320682', '如皋市', '3206', '3');
INSERT INTO `t_city_info` VALUES ('320684', '海门区', '3206', '3');
INSERT INTO `t_city_info` VALUES ('320685', '海安市', '3206', '3');
INSERT INTO `t_city_info` VALUES ('3207', '连云港市', '32', '2');
INSERT INTO `t_city_info` VALUES ('320701', '连云港市市辖区', '3207', '3');
INSERT INTO `t_city_info` VALUES ('320703', '连云区', '3207', '3');
INSERT INTO `t_city_info` VALUES ('320706', '海州区', '3207', '3');
INSERT INTO `t_city_info` VALUES ('320707', '赣榆区', '3207', '3');
INSERT INTO `t_city_info` VALUES ('320722', '东海县', '3207', '3');
INSERT INTO `t_city_info` VALUES ('320723', '灌云县', '3207', '3');
INSERT INTO `t_city_info` VALUES ('320724', '灌南县', '3207', '3');
INSERT INTO `t_city_info` VALUES ('3208', '淮安市', '32', '2');
INSERT INTO `t_city_info` VALUES ('320801', '淮安市市辖区', '3208', '3');
INSERT INTO `t_city_info` VALUES ('320803', '淮安区', '3208', '3');
INSERT INTO `t_city_info` VALUES ('320804', '淮阴区', '3208', '3');
INSERT INTO `t_city_info` VALUES ('320812', '清江浦区', '3208', '3');
INSERT INTO `t_city_info` VALUES ('320813', '洪泽区', '3208', '3');
INSERT INTO `t_city_info` VALUES ('320826', '涟水县', '3208', '3');
INSERT INTO `t_city_info` VALUES ('320830', '盱眙县', '3208', '3');
INSERT INTO `t_city_info` VALUES ('320831', '金湖县', '3208', '3');
INSERT INTO `t_city_info` VALUES ('3209', '盐城市', '32', '2');
INSERT INTO `t_city_info` VALUES ('320901', '盐城市市辖区', '3209', '3');
INSERT INTO `t_city_info` VALUES ('320902', '亭湖区', '3209', '3');
INSERT INTO `t_city_info` VALUES ('320903', '盐都区', '3209', '3');
INSERT INTO `t_city_info` VALUES ('320904', '大丰区', '3209', '3');
INSERT INTO `t_city_info` VALUES ('320921', '响水县', '3209', '3');
INSERT INTO `t_city_info` VALUES ('320922', '滨海县', '3209', '3');
INSERT INTO `t_city_info` VALUES ('320923', '阜宁县', '3209', '3');
INSERT INTO `t_city_info` VALUES ('320924', '射阳县', '3209', '3');
INSERT INTO `t_city_info` VALUES ('320925', '建湖县', '3209', '3');
INSERT INTO `t_city_info` VALUES ('320981', '东台市', '3209', '3');
INSERT INTO `t_city_info` VALUES ('3210', '扬州市', '32', '2');
INSERT INTO `t_city_info` VALUES ('321001', '扬州市市辖区', '3210', '3');
INSERT INTO `t_city_info` VALUES ('321002', '广陵区', '3210', '3');
INSERT INTO `t_city_info` VALUES ('321003', '邗江区', '3210', '3');
INSERT INTO `t_city_info` VALUES ('321012', '江都区', '3210', '3');
INSERT INTO `t_city_info` VALUES ('321023', '宝应县', '3210', '3');
INSERT INTO `t_city_info` VALUES ('321081', '仪征市', '3210', '3');
INSERT INTO `t_city_info` VALUES ('321084', '高邮市', '3210', '3');
INSERT INTO `t_city_info` VALUES ('3211', '镇江市', '32', '2');
INSERT INTO `t_city_info` VALUES ('321101', '镇江市市辖区', '3211', '3');
INSERT INTO `t_city_info` VALUES ('321102', '京口区', '3211', '3');
INSERT INTO `t_city_info` VALUES ('321111', '润州区', '3211', '3');
INSERT INTO `t_city_info` VALUES ('321112', '丹徒区', '3211', '3');
INSERT INTO `t_city_info` VALUES ('321181', '丹阳市', '3211', '3');
INSERT INTO `t_city_info` VALUES ('321182', '扬中市', '3211', '3');
INSERT INTO `t_city_info` VALUES ('321183', '句容市', '3211', '3');
INSERT INTO `t_city_info` VALUES ('3212', '泰州市', '32', '2');
INSERT INTO `t_city_info` VALUES ('321201', '泰州市市辖区', '3212', '3');
INSERT INTO `t_city_info` VALUES ('321202', '海陵区', '3212', '3');
INSERT INTO `t_city_info` VALUES ('321203', '高港区', '3212', '3');
INSERT INTO `t_city_info` VALUES ('321204', '姜堰区', '3212', '3');
INSERT INTO `t_city_info` VALUES ('321281', '兴化市', '3212', '3');
INSERT INTO `t_city_info` VALUES ('321282', '靖江市', '3212', '3');
INSERT INTO `t_city_info` VALUES ('321283', '泰兴市', '3212', '3');
INSERT INTO `t_city_info` VALUES ('3213', '宿迁市', '32', '2');
INSERT INTO `t_city_info` VALUES ('321301', '宿迁市市辖区', '3213', '3');
INSERT INTO `t_city_info` VALUES ('321302', '宿城区', '3213', '3');
INSERT INTO `t_city_info` VALUES ('321311', '宿豫区', '3213', '3');
INSERT INTO `t_city_info` VALUES ('321322', '沭阳县', '3213', '3');
INSERT INTO `t_city_info` VALUES ('321323', '泗阳县', '3213', '3');
INSERT INTO `t_city_info` VALUES ('321324', '泗洪县', '3213', '3');
INSERT INTO `t_city_info` VALUES ('33', '浙江省', null, '1');
INSERT INTO `t_city_info` VALUES ('3301', '杭州市', '33', '2');
INSERT INTO `t_city_info` VALUES ('330101', '杭州市市辖区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330102', '上城区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330103', '下城区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330104', '江干区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330105', '拱墅区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330106', '西湖区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330108', '滨江区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330109', '萧山区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330110', '余杭区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330111', '富阳区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330112', '临安区', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330122', '桐庐县', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330127', '淳安县', '3301', '3');
INSERT INTO `t_city_info` VALUES ('330182', '建德市', '3301', '3');
INSERT INTO `t_city_info` VALUES ('3302', '宁波市', '33', '2');
INSERT INTO `t_city_info` VALUES ('330201', '宁波市市辖区', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330203', '海曙区', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330205', '江北区', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330206', '北仑区', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330211', '镇海区', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330212', '鄞州区', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330213', '奉化区', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330225', '象山县', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330226', '宁海县', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330281', '余姚市', '3302', '3');
INSERT INTO `t_city_info` VALUES ('330282', '慈溪市', '3302', '3');
INSERT INTO `t_city_info` VALUES ('3303', '温州市', '33', '2');
INSERT INTO `t_city_info` VALUES ('330301', '温州市市辖区', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330302', '鹿城区', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330303', '龙湾区', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330304', '瓯海区', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330305', '洞头区', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330324', '永嘉县', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330326', '平阳县', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330327', '苍南县', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330328', '文成县', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330329', '泰顺县', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330381', '瑞安市', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330382', '乐清市', '3303', '3');
INSERT INTO `t_city_info` VALUES ('330383', '龙港市', '3303', '3');
INSERT INTO `t_city_info` VALUES ('3304', '嘉兴市', '33', '2');
INSERT INTO `t_city_info` VALUES ('330401', '嘉兴市市辖区', '3304', '3');
INSERT INTO `t_city_info` VALUES ('330402', '南湖区', '3304', '3');
INSERT INTO `t_city_info` VALUES ('330411', '秀洲区', '3304', '3');
INSERT INTO `t_city_info` VALUES ('330421', '嘉善县', '3304', '3');
INSERT INTO `t_city_info` VALUES ('330424', '海盐县', '3304', '3');
INSERT INTO `t_city_info` VALUES ('330481', '海宁市', '3304', '3');
INSERT INTO `t_city_info` VALUES ('330482', '平湖市', '3304', '3');
INSERT INTO `t_city_info` VALUES ('330483', '桐乡市', '3304', '3');
INSERT INTO `t_city_info` VALUES ('3305', '湖州市', '33', '2');
INSERT INTO `t_city_info` VALUES ('330501', '湖州市市辖区', '3305', '3');
INSERT INTO `t_city_info` VALUES ('330502', '吴兴区', '3305', '3');
INSERT INTO `t_city_info` VALUES ('330503', '南浔区', '3305', '3');
INSERT INTO `t_city_info` VALUES ('330521', '德清县', '3305', '3');
INSERT INTO `t_city_info` VALUES ('330522', '长兴县', '3305', '3');
INSERT INTO `t_city_info` VALUES ('330523', '安吉县', '3305', '3');
INSERT INTO `t_city_info` VALUES ('3306', '绍兴市', '33', '2');
INSERT INTO `t_city_info` VALUES ('330601', '绍兴市市辖区', '3306', '3');
INSERT INTO `t_city_info` VALUES ('330602', '越城区', '3306', '3');
INSERT INTO `t_city_info` VALUES ('330603', '柯桥区', '3306', '3');
INSERT INTO `t_city_info` VALUES ('330604', '上虞区', '3306', '3');
INSERT INTO `t_city_info` VALUES ('330624', '新昌县', '3306', '3');
INSERT INTO `t_city_info` VALUES ('330681', '诸暨市', '3306', '3');
INSERT INTO `t_city_info` VALUES ('330683', '嵊州市', '3306', '3');
INSERT INTO `t_city_info` VALUES ('3307', '金华市', '33', '2');
INSERT INTO `t_city_info` VALUES ('330701', '金华市市辖区', '3307', '3');
INSERT INTO `t_city_info` VALUES ('330702', '婺城区', '3307', '3');
INSERT INTO `t_city_info` VALUES ('330703', '金东区', '3307', '3');
INSERT INTO `t_city_info` VALUES ('330723', '武义县', '3307', '3');
INSERT INTO `t_city_info` VALUES ('330726', '浦江县', '3307', '3');
INSERT INTO `t_city_info` VALUES ('330727', '磐安县', '3307', '3');
INSERT INTO `t_city_info` VALUES ('330781', '兰溪市', '3307', '3');
INSERT INTO `t_city_info` VALUES ('330782', '义乌市', '3307', '3');
INSERT INTO `t_city_info` VALUES ('330783', '东阳市', '3307', '3');
INSERT INTO `t_city_info` VALUES ('330784', '永康市', '3307', '3');
INSERT INTO `t_city_info` VALUES ('3308', '衢州市', '33', '2');
INSERT INTO `t_city_info` VALUES ('330801', '衢州市市辖区', '3308', '3');
INSERT INTO `t_city_info` VALUES ('330802', '柯城区', '3308', '3');
INSERT INTO `t_city_info` VALUES ('330803', '衢江区', '3308', '3');
INSERT INTO `t_city_info` VALUES ('330822', '常山县', '3308', '3');
INSERT INTO `t_city_info` VALUES ('330824', '开化县', '3308', '3');
INSERT INTO `t_city_info` VALUES ('330825', '龙游县', '3308', '3');
INSERT INTO `t_city_info` VALUES ('330881', '江山市', '3308', '3');
INSERT INTO `t_city_info` VALUES ('3309', '舟山市', '33', '2');
INSERT INTO `t_city_info` VALUES ('330901', '舟山市市辖区', '3309', '3');
INSERT INTO `t_city_info` VALUES ('330902', '定海区', '3309', '3');
INSERT INTO `t_city_info` VALUES ('330903', '普陀区', '3309', '3');
INSERT INTO `t_city_info` VALUES ('330921', '岱山县', '3309', '3');
INSERT INTO `t_city_info` VALUES ('330922', '嵊泗县', '3309', '3');
INSERT INTO `t_city_info` VALUES ('3310', '台州市', '33', '2');
INSERT INTO `t_city_info` VALUES ('331001', '台州市市辖区', '3310', '3');
INSERT INTO `t_city_info` VALUES ('331002', '椒江区', '3310', '3');
INSERT INTO `t_city_info` VALUES ('331003', '黄岩区', '3310', '3');
INSERT INTO `t_city_info` VALUES ('331004', '路桥区', '3310', '3');
INSERT INTO `t_city_info` VALUES ('331022', '三门县', '3310', '3');
INSERT INTO `t_city_info` VALUES ('331023', '天台县', '3310', '3');
INSERT INTO `t_city_info` VALUES ('331024', '仙居县', '3310', '3');
INSERT INTO `t_city_info` VALUES ('331081', '温岭市', '3310', '3');
INSERT INTO `t_city_info` VALUES ('331082', '临海市', '3310', '3');
INSERT INTO `t_city_info` VALUES ('331083', '玉环市', '3310', '3');
INSERT INTO `t_city_info` VALUES ('3311', '丽水市', '33', '2');
INSERT INTO `t_city_info` VALUES ('331101', '丽水市市辖区', '3311', '3');
INSERT INTO `t_city_info` VALUES ('331102', '莲都区', '3311', '3');
INSERT INTO `t_city_info` VALUES ('331121', '青田县', '3311', '3');
INSERT INTO `t_city_info` VALUES ('331122', '缙云县', '3311', '3');
INSERT INTO `t_city_info` VALUES ('331123', '遂昌县', '3311', '3');
INSERT INTO `t_city_info` VALUES ('331124', '松阳县', '3311', '3');
INSERT INTO `t_city_info` VALUES ('331125', '云和县', '3311', '3');
INSERT INTO `t_city_info` VALUES ('331126', '庆元县', '3311', '3');
INSERT INTO `t_city_info` VALUES ('331127', '景宁畲族自治县', '3311', '3');
INSERT INTO `t_city_info` VALUES ('331181', '龙泉市', '3311', '3');
INSERT INTO `t_city_info` VALUES ('34', '安徽省', null, '1');
INSERT INTO `t_city_info` VALUES ('3401', '合肥市', '34', '2');
INSERT INTO `t_city_info` VALUES ('340101', '合肥市市辖区', '3401', '3');
INSERT INTO `t_city_info` VALUES ('340102', '瑶海区', '3401', '3');
INSERT INTO `t_city_info` VALUES ('340103', '庐阳区', '3401', '3');
INSERT INTO `t_city_info` VALUES ('340104', '蜀山区', '3401', '3');
INSERT INTO `t_city_info` VALUES ('340111', '包河区', '3401', '3');
INSERT INTO `t_city_info` VALUES ('340121', '长丰县', '3401', '3');
INSERT INTO `t_city_info` VALUES ('340122', '肥东县', '3401', '3');
INSERT INTO `t_city_info` VALUES ('340123', '肥西县', '3401', '3');
INSERT INTO `t_city_info` VALUES ('340124', '庐江县', '3401', '3');
INSERT INTO `t_city_info` VALUES ('340181', '巢湖市', '3401', '3');
INSERT INTO `t_city_info` VALUES ('3402', '芜湖市', '34', '2');
INSERT INTO `t_city_info` VALUES ('340201', '芜湖市市辖区', '3402', '3');
INSERT INTO `t_city_info` VALUES ('340202', '镜湖区', '3402', '3');
INSERT INTO `t_city_info` VALUES ('340203', '弋江区', '3402', '3');
INSERT INTO `t_city_info` VALUES ('340207', '鸠江区', '3402', '3');
INSERT INTO `t_city_info` VALUES ('340221', '湾沚区', '3402', '3');
INSERT INTO `t_city_info` VALUES ('340222', '繁昌区', '3402', '3');
INSERT INTO `t_city_info` VALUES ('340223', '南陵县', '3402', '3');
INSERT INTO `t_city_info` VALUES ('340281', '无为市', '3402', '3');
INSERT INTO `t_city_info` VALUES ('3403', '蚌埠市', '34', '2');
INSERT INTO `t_city_info` VALUES ('340301', '蚌埠市市辖区', '3403', '3');
INSERT INTO `t_city_info` VALUES ('340302', '龙子湖区', '3403', '3');
INSERT INTO `t_city_info` VALUES ('340303', '蚌山区', '3403', '3');
INSERT INTO `t_city_info` VALUES ('340304', '禹会区', '3403', '3');
INSERT INTO `t_city_info` VALUES ('340311', '淮上区', '3403', '3');
INSERT INTO `t_city_info` VALUES ('340321', '怀远县', '3403', '3');
INSERT INTO `t_city_info` VALUES ('340322', '五河县', '3403', '3');
INSERT INTO `t_city_info` VALUES ('340323', '固镇县', '3403', '3');
INSERT INTO `t_city_info` VALUES ('3404', '淮南市', '34', '2');
INSERT INTO `t_city_info` VALUES ('340401', '淮南市市辖区', '3404', '3');
INSERT INTO `t_city_info` VALUES ('340402', '大通区', '3404', '3');
INSERT INTO `t_city_info` VALUES ('340403', '田家庵区', '3404', '3');
INSERT INTO `t_city_info` VALUES ('340404', '谢家集区', '3404', '3');
INSERT INTO `t_city_info` VALUES ('340405', '八公山区', '3404', '3');
INSERT INTO `t_city_info` VALUES ('340406', '潘集区', '3404', '3');
INSERT INTO `t_city_info` VALUES ('340421', '凤台县', '3404', '3');
INSERT INTO `t_city_info` VALUES ('340422', '寿县', '3404', '3');
INSERT INTO `t_city_info` VALUES ('3405', '马鞍山市', '34', '2');
INSERT INTO `t_city_info` VALUES ('340501', '马鞍山市市辖区', '3405', '3');
INSERT INTO `t_city_info` VALUES ('340503', '花山区', '3405', '3');
INSERT INTO `t_city_info` VALUES ('340504', '雨山区', '3405', '3');
INSERT INTO `t_city_info` VALUES ('340506', '博望区', '3405', '3');
INSERT INTO `t_city_info` VALUES ('340521', '当涂县', '3405', '3');
INSERT INTO `t_city_info` VALUES ('340522', '含山县', '3405', '3');
INSERT INTO `t_city_info` VALUES ('340523', '和县', '3405', '3');
INSERT INTO `t_city_info` VALUES ('3406', '淮北市', '34', '2');
INSERT INTO `t_city_info` VALUES ('340601', '淮北市市辖区', '3406', '3');
INSERT INTO `t_city_info` VALUES ('340602', '杜集区', '3406', '3');
INSERT INTO `t_city_info` VALUES ('340603', '相山区', '3406', '3');
INSERT INTO `t_city_info` VALUES ('340604', '烈山区', '3406', '3');
INSERT INTO `t_city_info` VALUES ('340621', '濉溪县', '3406', '3');
INSERT INTO `t_city_info` VALUES ('3407', '铜陵市', '34', '2');
INSERT INTO `t_city_info` VALUES ('340701', '铜陵市市辖区', '3407', '3');
INSERT INTO `t_city_info` VALUES ('340705', '铜官区', '3407', '3');
INSERT INTO `t_city_info` VALUES ('340706', '义安区', '3407', '3');
INSERT INTO `t_city_info` VALUES ('340711', '郊区', '3407', '3');
INSERT INTO `t_city_info` VALUES ('340722', '枞阳县', '3407', '3');
INSERT INTO `t_city_info` VALUES ('3408', '安庆市', '34', '2');
INSERT INTO `t_city_info` VALUES ('340801', '安庆市市辖区', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340802', '迎江区', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340803', '大观区', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340811', '宜秀区', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340822', '怀宁县', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340825', '太湖县', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340826', '宿松县', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340827', '望江县', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340828', '岳西县', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340881', '桐城市', '3408', '3');
INSERT INTO `t_city_info` VALUES ('340882', '潜山市', '3408', '3');
INSERT INTO `t_city_info` VALUES ('3410', '黄山市', '34', '2');
INSERT INTO `t_city_info` VALUES ('341001', '黄山市市辖区', '3410', '3');
INSERT INTO `t_city_info` VALUES ('341002', '屯溪区', '3410', '3');
INSERT INTO `t_city_info` VALUES ('341003', '黄山区', '3410', '3');
INSERT INTO `t_city_info` VALUES ('341004', '徽州区', '3410', '3');
INSERT INTO `t_city_info` VALUES ('341021', '歙县', '3410', '3');
INSERT INTO `t_city_info` VALUES ('341022', '休宁县', '3410', '3');
INSERT INTO `t_city_info` VALUES ('341023', '黟县', '3410', '3');
INSERT INTO `t_city_info` VALUES ('341024', '祁门县', '3410', '3');
INSERT INTO `t_city_info` VALUES ('3411', '滁州市', '34', '2');
INSERT INTO `t_city_info` VALUES ('341101', '滁州市市辖区', '3411', '3');
INSERT INTO `t_city_info` VALUES ('341102', '琅琊区', '3411', '3');
INSERT INTO `t_city_info` VALUES ('341103', '南谯区', '3411', '3');
INSERT INTO `t_city_info` VALUES ('341122', '来安县', '3411', '3');
INSERT INTO `t_city_info` VALUES ('341124', '全椒县', '3411', '3');
INSERT INTO `t_city_info` VALUES ('341125', '定远县', '3411', '3');
INSERT INTO `t_city_info` VALUES ('341126', '凤阳县', '3411', '3');
INSERT INTO `t_city_info` VALUES ('341181', '天长市', '3411', '3');
INSERT INTO `t_city_info` VALUES ('341182', '明光市', '3411', '3');
INSERT INTO `t_city_info` VALUES ('3412', '阜阳市', '34', '2');
INSERT INTO `t_city_info` VALUES ('341201', '阜阳市市辖区', '3412', '3');
INSERT INTO `t_city_info` VALUES ('341202', '颍州区', '3412', '3');
INSERT INTO `t_city_info` VALUES ('341203', '颍东区', '3412', '3');
INSERT INTO `t_city_info` VALUES ('341204', '颍泉区', '3412', '3');
INSERT INTO `t_city_info` VALUES ('341221', '临泉县', '3412', '3');
INSERT INTO `t_city_info` VALUES ('341222', '太和县', '3412', '3');
INSERT INTO `t_city_info` VALUES ('341225', '阜南县', '3412', '3');
INSERT INTO `t_city_info` VALUES ('341226', '颍上县', '3412', '3');
INSERT INTO `t_city_info` VALUES ('341282', '界首市', '3412', '3');
INSERT INTO `t_city_info` VALUES ('3413', '宿州市', '34', '2');
INSERT INTO `t_city_info` VALUES ('341301', '宿州市市辖区', '3413', '3');
INSERT INTO `t_city_info` VALUES ('341302', '埇桥区', '3413', '3');
INSERT INTO `t_city_info` VALUES ('341321', '砀山县', '3413', '3');
INSERT INTO `t_city_info` VALUES ('341322', '萧县', '3413', '3');
INSERT INTO `t_city_info` VALUES ('341323', '灵璧县', '3413', '3');
INSERT INTO `t_city_info` VALUES ('341324', '泗县', '3413', '3');
INSERT INTO `t_city_info` VALUES ('3415', '六安市', '34', '2');
INSERT INTO `t_city_info` VALUES ('341501', '六安市市辖区', '3415', '3');
INSERT INTO `t_city_info` VALUES ('341502', '金安区', '3415', '3');
INSERT INTO `t_city_info` VALUES ('341503', '裕安区', '3415', '3');
INSERT INTO `t_city_info` VALUES ('341504', '叶集区', '3415', '3');
INSERT INTO `t_city_info` VALUES ('341522', '霍邱县', '3415', '3');
INSERT INTO `t_city_info` VALUES ('341523', '舒城县', '3415', '3');
INSERT INTO `t_city_info` VALUES ('341524', '金寨县', '3415', '3');
INSERT INTO `t_city_info` VALUES ('341525', '霍山县', '3415', '3');
INSERT INTO `t_city_info` VALUES ('3416', '亳州市', '34', '2');
INSERT INTO `t_city_info` VALUES ('341601', '亳州市市辖区', '3416', '3');
INSERT INTO `t_city_info` VALUES ('341602', '谯城区', '3416', '3');
INSERT INTO `t_city_info` VALUES ('341621', '涡阳县', '3416', '3');
INSERT INTO `t_city_info` VALUES ('341622', '蒙城县', '3416', '3');
INSERT INTO `t_city_info` VALUES ('341623', '利辛县', '3416', '3');
INSERT INTO `t_city_info` VALUES ('3417', '池州市', '34', '2');
INSERT INTO `t_city_info` VALUES ('341701', '池州市市辖区', '3417', '3');
INSERT INTO `t_city_info` VALUES ('341702', '贵池区', '3417', '3');
INSERT INTO `t_city_info` VALUES ('341721', '东至县', '3417', '3');
INSERT INTO `t_city_info` VALUES ('341722', '石台县', '3417', '3');
INSERT INTO `t_city_info` VALUES ('341723', '青阳县', '3417', '3');
INSERT INTO `t_city_info` VALUES ('3418', '宣城市', '34', '2');
INSERT INTO `t_city_info` VALUES ('341801', '宣城市市辖区', '3418', '3');
INSERT INTO `t_city_info` VALUES ('341802', '宣州区', '3418', '3');
INSERT INTO `t_city_info` VALUES ('341821', '郎溪县', '3418', '3');
INSERT INTO `t_city_info` VALUES ('341823', '泾县', '3418', '3');
INSERT INTO `t_city_info` VALUES ('341824', '绩溪县', '3418', '3');
INSERT INTO `t_city_info` VALUES ('341825', '旌德县', '3418', '3');
INSERT INTO `t_city_info` VALUES ('341881', '宁国市', '3418', '3');
INSERT INTO `t_city_info` VALUES ('341882', '广德市', '3418', '3');
INSERT INTO `t_city_info` VALUES ('35', '福建省', null, '1');
INSERT INTO `t_city_info` VALUES ('3501', '福州市', '35', '2');
INSERT INTO `t_city_info` VALUES ('350101', '福州市市辖区', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350102', '鼓楼区', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350103', '台江区', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350104', '仓山区', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350105', '马尾区', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350111', '晋安区', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350112', '长乐区', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350121', '闽侯县', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350122', '连江县', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350123', '罗源县', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350124', '闽清县', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350125', '永泰县', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350128', '平潭县', '3501', '3');
INSERT INTO `t_city_info` VALUES ('350181', '福清市', '3501', '3');
INSERT INTO `t_city_info` VALUES ('3502', '厦门市', '35', '2');
INSERT INTO `t_city_info` VALUES ('350201', '厦门市市辖区', '3502', '3');
INSERT INTO `t_city_info` VALUES ('350203', '思明区', '3502', '3');
INSERT INTO `t_city_info` VALUES ('350205', '海沧区', '3502', '3');
INSERT INTO `t_city_info` VALUES ('350206', '湖里区', '3502', '3');
INSERT INTO `t_city_info` VALUES ('350211', '集美区', '3502', '3');
INSERT INTO `t_city_info` VALUES ('350212', '同安区', '3502', '3');
INSERT INTO `t_city_info` VALUES ('350213', '翔安区', '3502', '3');
INSERT INTO `t_city_info` VALUES ('3503', '莆田市', '35', '2');
INSERT INTO `t_city_info` VALUES ('350301', '莆田市市辖区', '3503', '3');
INSERT INTO `t_city_info` VALUES ('350302', '城厢区', '3503', '3');
INSERT INTO `t_city_info` VALUES ('350303', '涵江区', '3503', '3');
INSERT INTO `t_city_info` VALUES ('350304', '荔城区', '3503', '3');
INSERT INTO `t_city_info` VALUES ('350305', '秀屿区', '3503', '3');
INSERT INTO `t_city_info` VALUES ('350322', '仙游县', '3503', '3');
INSERT INTO `t_city_info` VALUES ('3504', '三明市', '35', '2');
INSERT INTO `t_city_info` VALUES ('350401', '三明市市辖区', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350402', '梅列区', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350403', '三元区', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350421', '明溪县', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350423', '清流县', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350424', '宁化县', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350425', '大田县', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350426', '尤溪县', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350427', '沙县', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350428', '将乐县', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350429', '泰宁县', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350430', '建宁县', '3504', '3');
INSERT INTO `t_city_info` VALUES ('350481', '永安市', '3504', '3');
INSERT INTO `t_city_info` VALUES ('3505', '泉州市', '35', '2');
INSERT INTO `t_city_info` VALUES ('350501', '泉州市市辖区', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350502', '鲤城区', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350503', '丰泽区', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350504', '洛江区', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350505', '泉港区', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350521', '惠安县', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350524', '安溪县', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350525', '永春县', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350526', '德化县', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350527', '金门县', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350581', '石狮市', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350582', '晋江市', '3505', '3');
INSERT INTO `t_city_info` VALUES ('350583', '南安市', '3505', '3');
INSERT INTO `t_city_info` VALUES ('3506', '漳州市', '35', '2');
INSERT INTO `t_city_info` VALUES ('350601', '漳州市市辖区', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350602', '芗城区', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350603', '龙文区', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350622', '云霄县', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350623', '漳浦县', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350624', '诏安县', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350625', '长泰县', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350626', '东山县', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350627', '南靖县', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350628', '平和县', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350629', '华安县', '3506', '3');
INSERT INTO `t_city_info` VALUES ('350681', '龙海市', '3506', '3');
INSERT INTO `t_city_info` VALUES ('3507', '南平市', '35', '2');
INSERT INTO `t_city_info` VALUES ('350701', '南平市市辖区', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350702', '延平区', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350703', '建阳区', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350721', '顺昌县', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350722', '浦城县', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350723', '光泽县', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350724', '松溪县', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350725', '政和县', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350781', '邵武市', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350782', '武夷山市', '3507', '3');
INSERT INTO `t_city_info` VALUES ('350783', '建瓯市', '3507', '3');
INSERT INTO `t_city_info` VALUES ('3508', '龙岩市', '35', '2');
INSERT INTO `t_city_info` VALUES ('350801', '龙岩市市辖区', '3508', '3');
INSERT INTO `t_city_info` VALUES ('350802', '新罗区', '3508', '3');
INSERT INTO `t_city_info` VALUES ('350803', '永定区', '3508', '3');
INSERT INTO `t_city_info` VALUES ('350821', '长汀县', '3508', '3');
INSERT INTO `t_city_info` VALUES ('350823', '上杭县', '3508', '3');
INSERT INTO `t_city_info` VALUES ('350824', '武平县', '3508', '3');
INSERT INTO `t_city_info` VALUES ('350825', '连城县', '3508', '3');
INSERT INTO `t_city_info` VALUES ('350881', '漳平市', '3508', '3');
INSERT INTO `t_city_info` VALUES ('3509', '宁德市', '35', '2');
INSERT INTO `t_city_info` VALUES ('350901', '宁德市市辖区', '3509', '3');
INSERT INTO `t_city_info` VALUES ('350902', '蕉城区', '3509', '3');
INSERT INTO `t_city_info` VALUES ('350921', '霞浦县', '3509', '3');
INSERT INTO `t_city_info` VALUES ('350922', '古田县', '3509', '3');
INSERT INTO `t_city_info` VALUES ('350923', '屏南县', '3509', '3');
INSERT INTO `t_city_info` VALUES ('350924', '寿宁县', '3509', '3');
INSERT INTO `t_city_info` VALUES ('350925', '周宁县', '3509', '3');
INSERT INTO `t_city_info` VALUES ('350926', '柘荣县', '3509', '3');
INSERT INTO `t_city_info` VALUES ('350981', '福安市', '3509', '3');
INSERT INTO `t_city_info` VALUES ('350982', '福鼎市', '3509', '3');
INSERT INTO `t_city_info` VALUES ('36', '江西省', null, '1');
INSERT INTO `t_city_info` VALUES ('3601', '南昌市', '36', '2');
INSERT INTO `t_city_info` VALUES ('360101', '南昌市市辖区', '3601', '3');
INSERT INTO `t_city_info` VALUES ('360102', '东湖区', '3601', '3');
INSERT INTO `t_city_info` VALUES ('360103', '西湖区', '3601', '3');
INSERT INTO `t_city_info` VALUES ('360104', '青云谱区', '3601', '3');
INSERT INTO `t_city_info` VALUES ('360111', '青山湖区', '3601', '3');
INSERT INTO `t_city_info` VALUES ('360112', '新建区', '3601', '3');
INSERT INTO `t_city_info` VALUES ('360113', '红谷滩区', '3601', '3');
INSERT INTO `t_city_info` VALUES ('360121', '南昌县', '3601', '3');
INSERT INTO `t_city_info` VALUES ('360123', '安义县', '3601', '3');
INSERT INTO `t_city_info` VALUES ('360124', '进贤县', '3601', '3');
INSERT INTO `t_city_info` VALUES ('3602', '景德镇市', '36', '2');
INSERT INTO `t_city_info` VALUES ('360201', '景德镇市市辖区', '3602', '3');
INSERT INTO `t_city_info` VALUES ('360202', '昌江区', '3602', '3');
INSERT INTO `t_city_info` VALUES ('360203', '珠山区', '3602', '3');
INSERT INTO `t_city_info` VALUES ('360222', '浮梁县', '3602', '3');
INSERT INTO `t_city_info` VALUES ('360281', '乐平市', '3602', '3');
INSERT INTO `t_city_info` VALUES ('3603', '萍乡市', '36', '2');
INSERT INTO `t_city_info` VALUES ('360301', '萍乡市市辖区', '3603', '3');
INSERT INTO `t_city_info` VALUES ('360302', '安源区', '3603', '3');
INSERT INTO `t_city_info` VALUES ('360313', '湘东区', '3603', '3');
INSERT INTO `t_city_info` VALUES ('360321', '莲花县', '3603', '3');
INSERT INTO `t_city_info` VALUES ('360322', '上栗县', '3603', '3');
INSERT INTO `t_city_info` VALUES ('360323', '芦溪县', '3603', '3');
INSERT INTO `t_city_info` VALUES ('3604', '九江市', '36', '2');
INSERT INTO `t_city_info` VALUES ('360401', '九江市市辖区', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360402', '濂溪区', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360403', '浔阳区', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360404', '柴桑区', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360423', '武宁县', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360424', '修水县', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360425', '永修县', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360426', '德安县', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360428', '都昌县', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360429', '湖口县', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360430', '彭泽县', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360481', '瑞昌市', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360482', '共青城市', '3604', '3');
INSERT INTO `t_city_info` VALUES ('360483', '庐山市', '3604', '3');
INSERT INTO `t_city_info` VALUES ('3605', '新余市', '36', '2');
INSERT INTO `t_city_info` VALUES ('360501', '新余市市辖区', '3605', '3');
INSERT INTO `t_city_info` VALUES ('360502', '渝水区', '3605', '3');
INSERT INTO `t_city_info` VALUES ('360521', '分宜县', '3605', '3');
INSERT INTO `t_city_info` VALUES ('3606', '鹰潭市', '36', '2');
INSERT INTO `t_city_info` VALUES ('360601', '鹰潭市市辖区', '3606', '3');
INSERT INTO `t_city_info` VALUES ('360602', '月湖区', '3606', '3');
INSERT INTO `t_city_info` VALUES ('360603', '余江区', '3606', '3');
INSERT INTO `t_city_info` VALUES ('360681', '贵溪市', '3606', '3');
INSERT INTO `t_city_info` VALUES ('3607', '赣州市', '36', '2');
INSERT INTO `t_city_info` VALUES ('360701', '赣州市市辖区', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360702', '章贡区', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360703', '南康区', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360704', '赣县区', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360722', '信丰县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360723', '大余县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360724', '上犹县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360725', '崇义县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360726', '安远县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360728', '定南县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360729', '全南县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360730', '宁都县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360731', '于都县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360732', '兴国县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360733', '会昌县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360734', '寻乌县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360735', '石城县', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360781', '瑞金市', '3607', '3');
INSERT INTO `t_city_info` VALUES ('360783', '龙南市', '3607', '3');
INSERT INTO `t_city_info` VALUES ('3608', '吉安市', '36', '2');
INSERT INTO `t_city_info` VALUES ('360801', '吉安市市辖区', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360802', '吉州区', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360803', '青原区', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360821', '吉安县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360822', '吉水县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360823', '峡江县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360824', '新干县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360825', '永丰县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360826', '泰和县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360827', '遂川县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360828', '万安县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360829', '安福县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360830', '永新县', '3608', '3');
INSERT INTO `t_city_info` VALUES ('360881', '井冈山市', '3608', '3');
INSERT INTO `t_city_info` VALUES ('3609', '宜春市', '36', '2');
INSERT INTO `t_city_info` VALUES ('360901', '宜春市市辖区', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360902', '袁州区', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360921', '奉新县', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360922', '万载县', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360923', '上高县', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360924', '宜丰县', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360925', '靖安县', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360926', '铜鼓县', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360981', '丰城市', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360982', '樟树市', '3609', '3');
INSERT INTO `t_city_info` VALUES ('360983', '高安市', '3609', '3');
INSERT INTO `t_city_info` VALUES ('3610', '抚州市', '36', '2');
INSERT INTO `t_city_info` VALUES ('361001', '抚州市市辖区', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361002', '临川区', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361003', '东乡区', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361021', '南城县', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361022', '黎川县', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361023', '南丰县', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361024', '崇仁县', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361025', '乐安县', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361026', '宜黄县', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361027', '金溪县', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361028', '资溪县', '3610', '3');
INSERT INTO `t_city_info` VALUES ('361030', '广昌县', '3610', '3');
INSERT INTO `t_city_info` VALUES ('3611', '上饶市', '36', '2');
INSERT INTO `t_city_info` VALUES ('361101', '上饶市市辖区', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361102', '信州区', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361103', '广丰区', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361104', '广信区', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361123', '玉山县', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361124', '铅山县', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361125', '横峰县', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361126', '弋阳县', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361127', '余干县', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361128', '鄱阳县', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361129', '万年县', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361130', '婺源县', '3611', '3');
INSERT INTO `t_city_info` VALUES ('361181', '德兴市', '3611', '3');
INSERT INTO `t_city_info` VALUES ('37', '山东省', null, '1');
INSERT INTO `t_city_info` VALUES ('3701', '济南市', '37', '2');
INSERT INTO `t_city_info` VALUES ('370101', '济南市市辖区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370102', '历下区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370103', '市中区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370104', '槐荫区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370105', '天桥区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370112', '历城区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370113', '长清区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370114', '章丘区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370115', '济阳区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370116', '莱芜区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370117', '钢城区', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370124', '平阴县', '3701', '3');
INSERT INTO `t_city_info` VALUES ('370126', '商河县', '3701', '3');
INSERT INTO `t_city_info` VALUES ('3702', '青岛市', '37', '2');
INSERT INTO `t_city_info` VALUES ('370201', '青岛市市辖区', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370202', '市南区', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370203', '市北区', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370211', '黄岛区', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370212', '崂山区', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370213', '李沧区', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370214', '城阳区', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370215', '即墨区', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370281', '胶州市', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370283', '平度市', '3702', '3');
INSERT INTO `t_city_info` VALUES ('370285', '莱西市', '3702', '3');
INSERT INTO `t_city_info` VALUES ('3703', '淄博市', '37', '2');
INSERT INTO `t_city_info` VALUES ('370301', '淄博市市辖区', '3703', '3');
INSERT INTO `t_city_info` VALUES ('370302', '淄川区', '3703', '3');
INSERT INTO `t_city_info` VALUES ('370303', '张店区', '3703', '3');
INSERT INTO `t_city_info` VALUES ('370304', '博山区', '3703', '3');
INSERT INTO `t_city_info` VALUES ('370305', '临淄区', '3703', '3');
INSERT INTO `t_city_info` VALUES ('370306', '周村区', '3703', '3');
INSERT INTO `t_city_info` VALUES ('370321', '桓台县', '3703', '3');
INSERT INTO `t_city_info` VALUES ('370322', '高青县', '3703', '3');
INSERT INTO `t_city_info` VALUES ('370323', '沂源县', '3703', '3');
INSERT INTO `t_city_info` VALUES ('3704', '枣庄市', '37', '2');
INSERT INTO `t_city_info` VALUES ('370401', '枣庄市市辖区', '3704', '3');
INSERT INTO `t_city_info` VALUES ('370402', '市中区', '3704', '3');
INSERT INTO `t_city_info` VALUES ('370403', '薛城区', '3704', '3');
INSERT INTO `t_city_info` VALUES ('370404', '峄城区', '3704', '3');
INSERT INTO `t_city_info` VALUES ('370405', '台儿庄区', '3704', '3');
INSERT INTO `t_city_info` VALUES ('370406', '山亭区', '3704', '3');
INSERT INTO `t_city_info` VALUES ('370481', '滕州市', '3704', '3');
INSERT INTO `t_city_info` VALUES ('3705', '东营市', '37', '2');
INSERT INTO `t_city_info` VALUES ('370501', '东营市市辖区', '3705', '3');
INSERT INTO `t_city_info` VALUES ('370502', '东营区', '3705', '3');
INSERT INTO `t_city_info` VALUES ('370503', '河口区', '3705', '3');
INSERT INTO `t_city_info` VALUES ('370505', '垦利区', '3705', '3');
INSERT INTO `t_city_info` VALUES ('370522', '利津县', '3705', '3');
INSERT INTO `t_city_info` VALUES ('370523', '广饶县', '3705', '3');
INSERT INTO `t_city_info` VALUES ('3706', '烟台市', '37', '2');
INSERT INTO `t_city_info` VALUES ('370601', '烟台市市辖区', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370602', '芝罘区', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370611', '福山区', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370612', '牟平区', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370613', '莱山区', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370614', '蓬莱区', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370681', '龙口市', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370682', '莱阳市', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370683', '莱州市', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370685', '招远市', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370686', '栖霞市', '3706', '3');
INSERT INTO `t_city_info` VALUES ('370687', '海阳市', '3706', '3');
INSERT INTO `t_city_info` VALUES ('3707', '潍坊市', '37', '2');
INSERT INTO `t_city_info` VALUES ('370701', '潍坊市市辖区', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370702', '潍城区', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370703', '寒亭区', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370704', '坊子区', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370705', '奎文区', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370724', '临朐县', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370725', '昌乐县', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370781', '青州市', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370782', '诸城市', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370783', '寿光市', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370784', '安丘市', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370785', '高密市', '3707', '3');
INSERT INTO `t_city_info` VALUES ('370786', '昌邑市', '3707', '3');
INSERT INTO `t_city_info` VALUES ('3708', '济宁市', '37', '2');
INSERT INTO `t_city_info` VALUES ('370801', '济宁市市辖区', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370811', '任城区', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370812', '兖州区', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370826', '微山县', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370827', '鱼台县', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370828', '金乡县', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370829', '嘉祥县', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370830', '汶上县', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370831', '泗水县', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370832', '梁山县', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370881', '曲阜市', '3708', '3');
INSERT INTO `t_city_info` VALUES ('370883', '邹城市', '3708', '3');
INSERT INTO `t_city_info` VALUES ('3709', '泰安市', '37', '2');
INSERT INTO `t_city_info` VALUES ('370901', '泰安市市辖区', '3709', '3');
INSERT INTO `t_city_info` VALUES ('370902', '泰山区', '3709', '3');
INSERT INTO `t_city_info` VALUES ('370911', '岱岳区', '3709', '3');
INSERT INTO `t_city_info` VALUES ('370921', '宁阳县', '3709', '3');
INSERT INTO `t_city_info` VALUES ('370923', '东平县', '3709', '3');
INSERT INTO `t_city_info` VALUES ('370982', '新泰市', '3709', '3');
INSERT INTO `t_city_info` VALUES ('370983', '肥城市', '3709', '3');
INSERT INTO `t_city_info` VALUES ('3710', '威海市', '37', '2');
INSERT INTO `t_city_info` VALUES ('371001', '威海市市辖区', '3710', '3');
INSERT INTO `t_city_info` VALUES ('371002', '环翠区', '3710', '3');
INSERT INTO `t_city_info` VALUES ('371003', '文登区', '3710', '3');
INSERT INTO `t_city_info` VALUES ('371082', '荣成市', '3710', '3');
INSERT INTO `t_city_info` VALUES ('371083', '乳山市', '3710', '3');
INSERT INTO `t_city_info` VALUES ('3711', '日照市', '37', '2');
INSERT INTO `t_city_info` VALUES ('371101', '日照市市辖区', '3711', '3');
INSERT INTO `t_city_info` VALUES ('371102', '东港区', '3711', '3');
INSERT INTO `t_city_info` VALUES ('371103', '岚山区', '3711', '3');
INSERT INTO `t_city_info` VALUES ('371121', '五莲县', '3711', '3');
INSERT INTO `t_city_info` VALUES ('371122', '莒县', '3711', '3');
INSERT INTO `t_city_info` VALUES ('3713', '临沂市', '37', '2');
INSERT INTO `t_city_info` VALUES ('371301', '临沂市市辖区', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371302', '兰山区', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371311', '罗庄区', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371312', '河东区', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371321', '沂南县', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371322', '郯城县', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371323', '沂水县', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371324', '兰陵县', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371325', '费县', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371326', '平邑县', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371327', '莒南县', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371328', '蒙阴县', '3713', '3');
INSERT INTO `t_city_info` VALUES ('371329', '临沭县', '3713', '3');
INSERT INTO `t_city_info` VALUES ('3714', '德州市', '37', '2');
INSERT INTO `t_city_info` VALUES ('371401', '德州市市辖区', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371402', '德城区', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371403', '陵城区', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371422', '宁津县', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371423', '庆云县', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371424', '临邑县', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371425', '齐河县', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371426', '平原县', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371427', '夏津县', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371428', '武城县', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371481', '乐陵市', '3714', '3');
INSERT INTO `t_city_info` VALUES ('371482', '禹城市', '3714', '3');
INSERT INTO `t_city_info` VALUES ('3715', '聊城市', '37', '2');
INSERT INTO `t_city_info` VALUES ('371501', '聊城市市辖区', '3715', '3');
INSERT INTO `t_city_info` VALUES ('371502', '东昌府区', '3715', '3');
INSERT INTO `t_city_info` VALUES ('371503', '茌平区', '3715', '3');
INSERT INTO `t_city_info` VALUES ('371521', '阳谷县', '3715', '3');
INSERT INTO `t_city_info` VALUES ('371522', '莘县', '3715', '3');
INSERT INTO `t_city_info` VALUES ('371524', '东阿县', '3715', '3');
INSERT INTO `t_city_info` VALUES ('371525', '冠县', '3715', '3');
INSERT INTO `t_city_info` VALUES ('371526', '高唐县', '3715', '3');
INSERT INTO `t_city_info` VALUES ('371581', '临清市', '3715', '3');
INSERT INTO `t_city_info` VALUES ('3716', '滨州市', '37', '2');
INSERT INTO `t_city_info` VALUES ('371601', '滨州市市辖区', '3716', '3');
INSERT INTO `t_city_info` VALUES ('371602', '滨城区', '3716', '3');
INSERT INTO `t_city_info` VALUES ('371603', '沾化区', '3716', '3');
INSERT INTO `t_city_info` VALUES ('371621', '惠民县', '3716', '3');
INSERT INTO `t_city_info` VALUES ('371622', '阳信县', '3716', '3');
INSERT INTO `t_city_info` VALUES ('371623', '无棣县', '3716', '3');
INSERT INTO `t_city_info` VALUES ('371625', '博兴县', '3716', '3');
INSERT INTO `t_city_info` VALUES ('371681', '邹平市', '3716', '3');
INSERT INTO `t_city_info` VALUES ('3717', '菏泽市', '37', '2');
INSERT INTO `t_city_info` VALUES ('371701', '菏泽市市辖区', '3717', '3');
INSERT INTO `t_city_info` VALUES ('371702', '牡丹区', '3717', '3');
INSERT INTO `t_city_info` VALUES ('371703', '定陶区', '3717', '3');
INSERT INTO `t_city_info` VALUES ('371721', '曹县', '3717', '3');
INSERT INTO `t_city_info` VALUES ('371722', '单县', '3717', '3');
INSERT INTO `t_city_info` VALUES ('371723', '成武县', '3717', '3');
INSERT INTO `t_city_info` VALUES ('371724', '巨野县', '3717', '3');
INSERT INTO `t_city_info` VALUES ('371725', '郓城县', '3717', '3');
INSERT INTO `t_city_info` VALUES ('371726', '鄄城县', '3717', '3');
INSERT INTO `t_city_info` VALUES ('371728', '东明县', '3717', '3');
INSERT INTO `t_city_info` VALUES ('41', '河南省', null, '1');
INSERT INTO `t_city_info` VALUES ('4101', '郑州市', '41', '2');
INSERT INTO `t_city_info` VALUES ('410101', '郑州市市辖区', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410102', '中原区', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410103', '二七区', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410104', '管城回族区', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410105', '金水区', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410106', '上街区', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410108', '惠济区', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410122', '中牟县', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410181', '巩义市', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410182', '荥阳市', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410183', '新密市', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410184', '新郑市', '4101', '3');
INSERT INTO `t_city_info` VALUES ('410185', '登封市', '4101', '3');
INSERT INTO `t_city_info` VALUES ('4102', '开封市', '41', '2');
INSERT INTO `t_city_info` VALUES ('410201', '开封市市辖区', '4102', '3');
INSERT INTO `t_city_info` VALUES ('410202', '龙亭区', '4102', '3');
INSERT INTO `t_city_info` VALUES ('410203', '顺河回族区', '4102', '3');
INSERT INTO `t_city_info` VALUES ('410204', '鼓楼区', '4102', '3');
INSERT INTO `t_city_info` VALUES ('410205', '禹王台区', '4102', '3');
INSERT INTO `t_city_info` VALUES ('410212', '祥符区', '4102', '3');
INSERT INTO `t_city_info` VALUES ('410221', '杞县', '4102', '3');
INSERT INTO `t_city_info` VALUES ('410222', '通许县', '4102', '3');
INSERT INTO `t_city_info` VALUES ('410223', '尉氏县', '4102', '3');
INSERT INTO `t_city_info` VALUES ('410225', '兰考县', '4102', '3');
INSERT INTO `t_city_info` VALUES ('4103', '洛阳市', '41', '2');
INSERT INTO `t_city_info` VALUES ('410301', '洛阳市市辖区', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410302', '老城区', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410303', '西工区', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410304', '瀍河回族区', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410305', '涧西区', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410306', '吉利区', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410311', '洛龙区', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410322', '孟津县', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410323', '新安县', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410324', '栾川县', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410325', '嵩县', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410326', '汝阳县', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410327', '宜阳县', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410328', '洛宁县', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410329', '伊川县', '4103', '3');
INSERT INTO `t_city_info` VALUES ('410381', '偃师市', '4103', '3');
INSERT INTO `t_city_info` VALUES ('4104', '平顶山市', '41', '2');
INSERT INTO `t_city_info` VALUES ('410401', '平顶山市市辖区', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410402', '新华区', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410403', '卫东区', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410404', '石龙区', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410411', '湛河区', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410421', '宝丰县', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410422', '叶县', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410423', '鲁山县', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410425', '郏县', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410481', '舞钢市', '4104', '3');
INSERT INTO `t_city_info` VALUES ('410482', '汝州市', '4104', '3');
INSERT INTO `t_city_info` VALUES ('4105', '安阳市', '41', '2');
INSERT INTO `t_city_info` VALUES ('410501', '安阳市市辖区', '4105', '3');
INSERT INTO `t_city_info` VALUES ('410502', '文峰区', '4105', '3');
INSERT INTO `t_city_info` VALUES ('410503', '北关区', '4105', '3');
INSERT INTO `t_city_info` VALUES ('410505', '殷都区', '4105', '3');
INSERT INTO `t_city_info` VALUES ('410506', '龙安区', '4105', '3');
INSERT INTO `t_city_info` VALUES ('410522', '安阳县', '4105', '3');
INSERT INTO `t_city_info` VALUES ('410523', '汤阴县', '4105', '3');
INSERT INTO `t_city_info` VALUES ('410526', '滑县', '4105', '3');
INSERT INTO `t_city_info` VALUES ('410527', '内黄县', '4105', '3');
INSERT INTO `t_city_info` VALUES ('410581', '林州市', '4105', '3');
INSERT INTO `t_city_info` VALUES ('4106', '鹤壁市', '41', '2');
INSERT INTO `t_city_info` VALUES ('410601', '鹤壁市市辖区', '4106', '3');
INSERT INTO `t_city_info` VALUES ('410602', '鹤山区', '4106', '3');
INSERT INTO `t_city_info` VALUES ('410603', '山城区', '4106', '3');
INSERT INTO `t_city_info` VALUES ('410611', '淇滨区', '4106', '3');
INSERT INTO `t_city_info` VALUES ('410621', '浚县', '4106', '3');
INSERT INTO `t_city_info` VALUES ('410622', '淇县', '4106', '3');
INSERT INTO `t_city_info` VALUES ('4107', '新乡市', '41', '2');
INSERT INTO `t_city_info` VALUES ('410701', '新乡市市辖区', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410702', '红旗区', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410703', '卫滨区', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410704', '凤泉区', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410711', '牧野区', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410721', '新乡县', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410724', '获嘉县', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410725', '原阳县', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410726', '延津县', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410727', '封丘县', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410781', '卫辉市', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410782', '辉县市', '4107', '3');
INSERT INTO `t_city_info` VALUES ('410783', '长垣市', '4107', '3');
INSERT INTO `t_city_info` VALUES ('4108', '焦作市', '41', '2');
INSERT INTO `t_city_info` VALUES ('410801', '焦作市市辖区', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410802', '解放区', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410803', '中站区', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410804', '马村区', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410811', '山阳区', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410821', '修武县', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410822', '博爱县', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410823', '武陟县', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410825', '温县', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410882', '沁阳市', '4108', '3');
INSERT INTO `t_city_info` VALUES ('410883', '孟州市', '4108', '3');
INSERT INTO `t_city_info` VALUES ('4109', '濮阳市', '41', '2');
INSERT INTO `t_city_info` VALUES ('410901', '濮阳市市辖区', '4109', '3');
INSERT INTO `t_city_info` VALUES ('410902', '华龙区', '4109', '3');
INSERT INTO `t_city_info` VALUES ('410922', '清丰县', '4109', '3');
INSERT INTO `t_city_info` VALUES ('410923', '南乐县', '4109', '3');
INSERT INTO `t_city_info` VALUES ('410926', '范县', '4109', '3');
INSERT INTO `t_city_info` VALUES ('410927', '台前县', '4109', '3');
INSERT INTO `t_city_info` VALUES ('410928', '濮阳县', '4109', '3');
INSERT INTO `t_city_info` VALUES ('4110', '许昌市', '41', '2');
INSERT INTO `t_city_info` VALUES ('411001', '许昌市市辖区', '4110', '3');
INSERT INTO `t_city_info` VALUES ('411002', '魏都区', '4110', '3');
INSERT INTO `t_city_info` VALUES ('411003', '建安区', '4110', '3');
INSERT INTO `t_city_info` VALUES ('411024', '鄢陵县', '4110', '3');
INSERT INTO `t_city_info` VALUES ('411025', '襄城县', '4110', '3');
INSERT INTO `t_city_info` VALUES ('411081', '禹州市', '4110', '3');
INSERT INTO `t_city_info` VALUES ('411082', '长葛市', '4110', '3');
INSERT INTO `t_city_info` VALUES ('4111', '漯河市', '41', '2');
INSERT INTO `t_city_info` VALUES ('411101', '漯河市市辖区', '4111', '3');
INSERT INTO `t_city_info` VALUES ('411102', '源汇区', '4111', '3');
INSERT INTO `t_city_info` VALUES ('411103', '郾城区', '4111', '3');
INSERT INTO `t_city_info` VALUES ('411104', '召陵区', '4111', '3');
INSERT INTO `t_city_info` VALUES ('411121', '舞阳县', '4111', '3');
INSERT INTO `t_city_info` VALUES ('411122', '临颍县', '4111', '3');
INSERT INTO `t_city_info` VALUES ('4112', '三门峡市', '41', '2');
INSERT INTO `t_city_info` VALUES ('411201', '三门峡市市辖区', '4112', '3');
INSERT INTO `t_city_info` VALUES ('411202', '湖滨区', '4112', '3');
INSERT INTO `t_city_info` VALUES ('411203', '陕州区', '4112', '3');
INSERT INTO `t_city_info` VALUES ('411221', '渑池县', '4112', '3');
INSERT INTO `t_city_info` VALUES ('411224', '卢氏县', '4112', '3');
INSERT INTO `t_city_info` VALUES ('411281', '义马市', '4112', '3');
INSERT INTO `t_city_info` VALUES ('411282', '灵宝市', '4112', '3');
INSERT INTO `t_city_info` VALUES ('4113', '南阳市', '41', '2');
INSERT INTO `t_city_info` VALUES ('411301', '南阳市市辖区', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411302', '宛城区', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411303', '卧龙区', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411321', '南召县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411322', '方城县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411323', '西峡县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411324', '镇平县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411325', '内乡县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411326', '淅川县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411327', '社旗县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411328', '唐河县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411329', '新野县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411330', '桐柏县', '4113', '3');
INSERT INTO `t_city_info` VALUES ('411381', '邓州市', '4113', '3');
INSERT INTO `t_city_info` VALUES ('4114', '商丘市', '41', '2');
INSERT INTO `t_city_info` VALUES ('411401', '商丘市市辖区', '4114', '3');
INSERT INTO `t_city_info` VALUES ('411402', '梁园区', '4114', '3');
INSERT INTO `t_city_info` VALUES ('411403', '睢阳区', '4114', '3');
INSERT INTO `t_city_info` VALUES ('411421', '民权县', '4114', '3');
INSERT INTO `t_city_info` VALUES ('411422', '睢县', '4114', '3');
INSERT INTO `t_city_info` VALUES ('411423', '宁陵县', '4114', '3');
INSERT INTO `t_city_info` VALUES ('411424', '柘城县', '4114', '3');
INSERT INTO `t_city_info` VALUES ('411425', '虞城县', '4114', '3');
INSERT INTO `t_city_info` VALUES ('411426', '夏邑县', '4114', '3');
INSERT INTO `t_city_info` VALUES ('411481', '永城市', '4114', '3');
INSERT INTO `t_city_info` VALUES ('4115', '信阳市', '41', '2');
INSERT INTO `t_city_info` VALUES ('411501', '信阳市市辖区', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411502', '浉河区', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411503', '平桥区', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411521', '罗山县', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411522', '光山县', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411523', '新县', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411524', '商城县', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411525', '固始县', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411526', '潢川县', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411527', '淮滨县', '4115', '3');
INSERT INTO `t_city_info` VALUES ('411528', '息县', '4115', '3');
INSERT INTO `t_city_info` VALUES ('4116', '周口市', '41', '2');
INSERT INTO `t_city_info` VALUES ('411601', '周口市市辖区', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411602', '川汇区', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411603', '淮阳区', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411621', '扶沟县', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411622', '西华县', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411623', '商水县', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411624', '沈丘县', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411625', '郸城县', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411627', '太康县', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411628', '鹿邑县', '4116', '3');
INSERT INTO `t_city_info` VALUES ('411681', '项城市', '4116', '3');
INSERT INTO `t_city_info` VALUES ('4117', '驻马店市', '41', '2');
INSERT INTO `t_city_info` VALUES ('411701', '驻马店市市辖区', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411702', '驿城区', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411721', '西平县', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411722', '上蔡县', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411723', '平舆县', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411724', '正阳县', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411725', '确山县', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411726', '泌阳县', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411727', '汝南县', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411728', '遂平县', '4117', '3');
INSERT INTO `t_city_info` VALUES ('411729', '新蔡县', '4117', '3');
INSERT INTO `t_city_info` VALUES ('419001', '济源市', '4190', '3');
INSERT INTO `t_city_info` VALUES ('42', '湖北省', null, '1');
INSERT INTO `t_city_info` VALUES ('4201', '武汉市', '42', '2');
INSERT INTO `t_city_info` VALUES ('420101', '武汉市市辖区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420102', '江岸区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420103', '江汉区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420104', '硚口区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420105', '汉阳区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420106', '武昌区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420107', '青山区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420111', '洪山区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420112', '东西湖区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420113', '汉南区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420114', '蔡甸区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420115', '江夏区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420116', '黄陂区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('420117', '新洲区', '4201', '3');
INSERT INTO `t_city_info` VALUES ('4202', '黄石市', '42', '2');
INSERT INTO `t_city_info` VALUES ('420201', '黄石市市辖区', '4202', '3');
INSERT INTO `t_city_info` VALUES ('420202', '黄石港区', '4202', '3');
INSERT INTO `t_city_info` VALUES ('420203', '西塞山区', '4202', '3');
INSERT INTO `t_city_info` VALUES ('420204', '下陆区', '4202', '3');
INSERT INTO `t_city_info` VALUES ('420205', '铁山区', '4202', '3');
INSERT INTO `t_city_info` VALUES ('420222', '阳新县', '4202', '3');
INSERT INTO `t_city_info` VALUES ('420281', '大冶市', '4202', '3');
INSERT INTO `t_city_info` VALUES ('4203', '十堰市', '42', '2');
INSERT INTO `t_city_info` VALUES ('420301', '十堰市市辖区', '4203', '3');
INSERT INTO `t_city_info` VALUES ('420302', '茅箭区', '4203', '3');
INSERT INTO `t_city_info` VALUES ('420303', '张湾区', '4203', '3');
INSERT INTO `t_city_info` VALUES ('420304', '郧阳区', '4203', '3');
INSERT INTO `t_city_info` VALUES ('420322', '郧西县', '4203', '3');
INSERT INTO `t_city_info` VALUES ('420323', '竹山县', '4203', '3');
INSERT INTO `t_city_info` VALUES ('420324', '竹溪县', '4203', '3');
INSERT INTO `t_city_info` VALUES ('420325', '房县', '4203', '3');
INSERT INTO `t_city_info` VALUES ('420381', '丹江口市', '4203', '3');
INSERT INTO `t_city_info` VALUES ('4205', '宜昌市', '42', '2');
INSERT INTO `t_city_info` VALUES ('420501', '宜昌市市辖区', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420502', '西陵区', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420503', '伍家岗区', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420504', '点军区', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420505', '猇亭区', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420506', '夷陵区', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420525', '远安县', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420526', '兴山县', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420527', '秭归县', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420528', '长阳土家族自治县', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420529', '五峰土家族自治县', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420581', '宜都市', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420582', '当阳市', '4205', '3');
INSERT INTO `t_city_info` VALUES ('420583', '枝江市', '4205', '3');
INSERT INTO `t_city_info` VALUES ('4206', '襄阳市', '42', '2');
INSERT INTO `t_city_info` VALUES ('420601', '襄阳市市辖区', '4206', '3');
INSERT INTO `t_city_info` VALUES ('420602', '襄城区', '4206', '3');
INSERT INTO `t_city_info` VALUES ('420606', '樊城区', '4206', '3');
INSERT INTO `t_city_info` VALUES ('420607', '襄州区', '4206', '3');
INSERT INTO `t_city_info` VALUES ('420624', '南漳县', '4206', '3');
INSERT INTO `t_city_info` VALUES ('420625', '谷城县', '4206', '3');
INSERT INTO `t_city_info` VALUES ('420626', '保康县', '4206', '3');
INSERT INTO `t_city_info` VALUES ('420682', '老河口市', '4206', '3');
INSERT INTO `t_city_info` VALUES ('420683', '枣阳市', '4206', '3');
INSERT INTO `t_city_info` VALUES ('420684', '宜城市', '4206', '3');
INSERT INTO `t_city_info` VALUES ('4207', '鄂州市', '42', '2');
INSERT INTO `t_city_info` VALUES ('420701', '鄂州市市辖区', '4207', '3');
INSERT INTO `t_city_info` VALUES ('420702', '梁子湖区', '4207', '3');
INSERT INTO `t_city_info` VALUES ('420703', '华容区', '4207', '3');
INSERT INTO `t_city_info` VALUES ('420704', '鄂城区', '4207', '3');
INSERT INTO `t_city_info` VALUES ('4208', '荆门市', '42', '2');
INSERT INTO `t_city_info` VALUES ('420801', '荆门市市辖区', '4208', '3');
INSERT INTO `t_city_info` VALUES ('420802', '东宝区', '4208', '3');
INSERT INTO `t_city_info` VALUES ('420804', '掇刀区', '4208', '3');
INSERT INTO `t_city_info` VALUES ('420822', '沙洋县', '4208', '3');
INSERT INTO `t_city_info` VALUES ('420881', '钟祥市', '4208', '3');
INSERT INTO `t_city_info` VALUES ('420882', '京山市', '4208', '3');
INSERT INTO `t_city_info` VALUES ('4209', '孝感市', '42', '2');
INSERT INTO `t_city_info` VALUES ('420901', '孝感市市辖区', '4209', '3');
INSERT INTO `t_city_info` VALUES ('420902', '孝南区', '4209', '3');
INSERT INTO `t_city_info` VALUES ('420921', '孝昌县', '4209', '3');
INSERT INTO `t_city_info` VALUES ('420922', '大悟县', '4209', '3');
INSERT INTO `t_city_info` VALUES ('420923', '云梦县', '4209', '3');
INSERT INTO `t_city_info` VALUES ('420981', '应城市', '4209', '3');
INSERT INTO `t_city_info` VALUES ('420982', '安陆市', '4209', '3');
INSERT INTO `t_city_info` VALUES ('420984', '汉川市', '4209', '3');
INSERT INTO `t_city_info` VALUES ('4210', '荆州市', '42', '2');
INSERT INTO `t_city_info` VALUES ('421001', '荆州市市辖区', '4210', '3');
INSERT INTO `t_city_info` VALUES ('421002', '沙市区', '4210', '3');
INSERT INTO `t_city_info` VALUES ('421003', '荆州区', '4210', '3');
INSERT INTO `t_city_info` VALUES ('421022', '公安县', '4210', '3');
INSERT INTO `t_city_info` VALUES ('421023', '监利市', '4210', '3');
INSERT INTO `t_city_info` VALUES ('421024', '江陵县', '4210', '3');
INSERT INTO `t_city_info` VALUES ('421081', '石首市', '4210', '3');
INSERT INTO `t_city_info` VALUES ('421083', '洪湖市', '4210', '3');
INSERT INTO `t_city_info` VALUES ('421087', '松滋市', '4210', '3');
INSERT INTO `t_city_info` VALUES ('4211', '黄冈市', '42', '2');
INSERT INTO `t_city_info` VALUES ('421101', '黄冈市市辖区', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421102', '黄州区', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421121', '团风县', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421122', '红安县', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421123', '罗田县', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421124', '英山县', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421125', '浠水县', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421126', '蕲春县', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421127', '黄梅县', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421181', '麻城市', '4211', '3');
INSERT INTO `t_city_info` VALUES ('421182', '武穴市', '4211', '3');
INSERT INTO `t_city_info` VALUES ('4212', '咸宁市', '42', '2');
INSERT INTO `t_city_info` VALUES ('421201', '咸宁市市辖区', '4212', '3');
INSERT INTO `t_city_info` VALUES ('421202', '咸安区', '4212', '3');
INSERT INTO `t_city_info` VALUES ('421221', '嘉鱼县', '4212', '3');
INSERT INTO `t_city_info` VALUES ('421222', '通城县', '4212', '3');
INSERT INTO `t_city_info` VALUES ('421223', '崇阳县', '4212', '3');
INSERT INTO `t_city_info` VALUES ('421224', '通山县', '4212', '3');
INSERT INTO `t_city_info` VALUES ('421281', '赤壁市', '4212', '3');
INSERT INTO `t_city_info` VALUES ('4213', '随州市', '42', '2');
INSERT INTO `t_city_info` VALUES ('421301', '随州市市辖区', '4213', '3');
INSERT INTO `t_city_info` VALUES ('421303', '曾都区', '4213', '3');
INSERT INTO `t_city_info` VALUES ('421321', '随县', '4213', '3');
INSERT INTO `t_city_info` VALUES ('421381', '广水市', '4213', '3');
INSERT INTO `t_city_info` VALUES ('4228', '恩施土家族苗族自治州', '42', '2');
INSERT INTO `t_city_info` VALUES ('422801', '恩施市', '4228', '3');
INSERT INTO `t_city_info` VALUES ('422802', '利川市', '4228', '3');
INSERT INTO `t_city_info` VALUES ('422822', '建始县', '4228', '3');
INSERT INTO `t_city_info` VALUES ('422823', '巴东县', '4228', '3');
INSERT INTO `t_city_info` VALUES ('422825', '宣恩县', '4228', '3');
INSERT INTO `t_city_info` VALUES ('422826', '咸丰县', '4228', '3');
INSERT INTO `t_city_info` VALUES ('422827', '来凤县', '4228', '3');
INSERT INTO `t_city_info` VALUES ('422828', '鹤峰县', '4228', '3');
INSERT INTO `t_city_info` VALUES ('429004', '仙桃市', '4290', '3');
INSERT INTO `t_city_info` VALUES ('429005', '潜江市', '4290', '3');
INSERT INTO `t_city_info` VALUES ('429006', '天门市', '4290', '3');
INSERT INTO `t_city_info` VALUES ('429021', '神农架林区', '4290', '3');
INSERT INTO `t_city_info` VALUES ('43', '湖南省', null, '1');
INSERT INTO `t_city_info` VALUES ('4301', '长沙市', '43', '2');
INSERT INTO `t_city_info` VALUES ('430101', '长沙市市辖区', '4301', '3');
INSERT INTO `t_city_info` VALUES ('430102', '芙蓉区', '4301', '3');
INSERT INTO `t_city_info` VALUES ('430103', '天心区', '4301', '3');
INSERT INTO `t_city_info` VALUES ('430104', '岳麓区', '4301', '3');
INSERT INTO `t_city_info` VALUES ('430105', '开福区', '4301', '3');
INSERT INTO `t_city_info` VALUES ('430111', '雨花区', '4301', '3');
INSERT INTO `t_city_info` VALUES ('430112', '望城区', '4301', '3');
INSERT INTO `t_city_info` VALUES ('430121', '长沙县', '4301', '3');
INSERT INTO `t_city_info` VALUES ('430181', '浏阳市', '4301', '3');
INSERT INTO `t_city_info` VALUES ('430182', '宁乡市', '4301', '3');
INSERT INTO `t_city_info` VALUES ('4302', '株洲市', '43', '2');
INSERT INTO `t_city_info` VALUES ('430201', '株洲市市辖区', '4302', '3');
INSERT INTO `t_city_info` VALUES ('430202', '荷塘区', '4302', '3');
INSERT INTO `t_city_info` VALUES ('430203', '芦淞区', '4302', '3');
INSERT INTO `t_city_info` VALUES ('430204', '石峰区', '4302', '3');
INSERT INTO `t_city_info` VALUES ('430211', '天元区', '4302', '3');
INSERT INTO `t_city_info` VALUES ('430212', '渌口区', '4302', '3');
INSERT INTO `t_city_info` VALUES ('430223', '攸县', '4302', '3');
INSERT INTO `t_city_info` VALUES ('430224', '茶陵县', '4302', '3');
INSERT INTO `t_city_info` VALUES ('430225', '炎陵县', '4302', '3');
INSERT INTO `t_city_info` VALUES ('430281', '醴陵市', '4302', '3');
INSERT INTO `t_city_info` VALUES ('4303', '湘潭市', '43', '2');
INSERT INTO `t_city_info` VALUES ('430301', '湘潭市市辖区', '4303', '3');
INSERT INTO `t_city_info` VALUES ('430302', '雨湖区', '4303', '3');
INSERT INTO `t_city_info` VALUES ('430304', '岳塘区', '4303', '3');
INSERT INTO `t_city_info` VALUES ('430321', '湘潭县', '4303', '3');
INSERT INTO `t_city_info` VALUES ('430381', '湘乡市', '4303', '3');
INSERT INTO `t_city_info` VALUES ('430382', '韶山市', '4303', '3');
INSERT INTO `t_city_info` VALUES ('4304', '衡阳市', '43', '2');
INSERT INTO `t_city_info` VALUES ('430401', '衡阳市市辖区', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430405', '珠晖区', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430406', '雁峰区', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430407', '石鼓区', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430408', '蒸湘区', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430412', '南岳区', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430421', '衡阳县', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430422', '衡南县', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430423', '衡山县', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430424', '衡东县', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430426', '祁东县', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430481', '耒阳市', '4304', '3');
INSERT INTO `t_city_info` VALUES ('430482', '常宁市', '4304', '3');
INSERT INTO `t_city_info` VALUES ('4305', '邵阳市', '43', '2');
INSERT INTO `t_city_info` VALUES ('430501', '邵阳市市辖区', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430502', '双清区', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430503', '大祥区', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430511', '北塔区', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430522', '新邵县', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430523', '邵阳县', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430524', '隆回县', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430525', '洞口县', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430527', '绥宁县', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430528', '新宁县', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430529', '城步苗族自治县', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430581', '武冈市', '4305', '3');
INSERT INTO `t_city_info` VALUES ('430582', '邵东市', '4305', '3');
INSERT INTO `t_city_info` VALUES ('4306', '岳阳市', '43', '2');
INSERT INTO `t_city_info` VALUES ('430601', '岳阳市市辖区', '4306', '3');
INSERT INTO `t_city_info` VALUES ('430602', '岳阳楼区', '4306', '3');
INSERT INTO `t_city_info` VALUES ('430603', '云溪区', '4306', '3');
INSERT INTO `t_city_info` VALUES ('430611', '君山区', '4306', '3');
INSERT INTO `t_city_info` VALUES ('430621', '岳阳县', '4306', '3');
INSERT INTO `t_city_info` VALUES ('430623', '华容县', '4306', '3');
INSERT INTO `t_city_info` VALUES ('430624', '湘阴县', '4306', '3');
INSERT INTO `t_city_info` VALUES ('430626', '平江县', '4306', '3');
INSERT INTO `t_city_info` VALUES ('430681', '汨罗市', '4306', '3');
INSERT INTO `t_city_info` VALUES ('430682', '临湘市', '4306', '3');
INSERT INTO `t_city_info` VALUES ('4307', '常德市', '43', '2');
INSERT INTO `t_city_info` VALUES ('430701', '常德市市辖区', '4307', '3');
INSERT INTO `t_city_info` VALUES ('430702', '武陵区', '4307', '3');
INSERT INTO `t_city_info` VALUES ('430703', '鼎城区', '4307', '3');
INSERT INTO `t_city_info` VALUES ('430721', '安乡县', '4307', '3');
INSERT INTO `t_city_info` VALUES ('430722', '汉寿县', '4307', '3');
INSERT INTO `t_city_info` VALUES ('430723', '澧县', '4307', '3');
INSERT INTO `t_city_info` VALUES ('430724', '临澧县', '4307', '3');
INSERT INTO `t_city_info` VALUES ('430725', '桃源县', '4307', '3');
INSERT INTO `t_city_info` VALUES ('430726', '石门县', '4307', '3');
INSERT INTO `t_city_info` VALUES ('430781', '津市市', '4307', '3');
INSERT INTO `t_city_info` VALUES ('4308', '张家界市', '43', '2');
INSERT INTO `t_city_info` VALUES ('430801', '张家界市市辖区', '4308', '3');
INSERT INTO `t_city_info` VALUES ('430802', '永定区', '4308', '3');
INSERT INTO `t_city_info` VALUES ('430811', '武陵源区', '4308', '3');
INSERT INTO `t_city_info` VALUES ('430821', '慈利县', '4308', '3');
INSERT INTO `t_city_info` VALUES ('430822', '桑植县', '4308', '3');
INSERT INTO `t_city_info` VALUES ('4309', '益阳市', '43', '2');
INSERT INTO `t_city_info` VALUES ('430901', '益阳市市辖区', '4309', '3');
INSERT INTO `t_city_info` VALUES ('430902', '资阳区', '4309', '3');
INSERT INTO `t_city_info` VALUES ('430903', '赫山区', '4309', '3');
INSERT INTO `t_city_info` VALUES ('430921', '南县', '4309', '3');
INSERT INTO `t_city_info` VALUES ('430922', '桃江县', '4309', '3');
INSERT INTO `t_city_info` VALUES ('430923', '安化县', '4309', '3');
INSERT INTO `t_city_info` VALUES ('430981', '沅江市', '4309', '3');
INSERT INTO `t_city_info` VALUES ('4310', '郴州市', '43', '2');
INSERT INTO `t_city_info` VALUES ('431001', '郴州市市辖区', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431002', '北湖区', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431003', '苏仙区', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431021', '桂阳县', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431022', '宜章县', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431023', '永兴县', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431024', '嘉禾县', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431025', '临武县', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431026', '汝城县', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431027', '桂东县', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431028', '安仁县', '4310', '3');
INSERT INTO `t_city_info` VALUES ('431081', '资兴市', '4310', '3');
INSERT INTO `t_city_info` VALUES ('4311', '永州市', '43', '2');
INSERT INTO `t_city_info` VALUES ('431101', '永州市市辖区', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431102', '零陵区', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431103', '冷水滩区', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431121', '祁阳县', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431122', '东安县', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431123', '双牌县', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431124', '道县', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431125', '江永县', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431126', '宁远县', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431127', '蓝山县', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431128', '新田县', '4311', '3');
INSERT INTO `t_city_info` VALUES ('431129', '江华瑶族自治县', '4311', '3');
INSERT INTO `t_city_info` VALUES ('4312', '怀化市', '43', '2');
INSERT INTO `t_city_info` VALUES ('431201', '怀化市市辖区', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431202', '鹤城区', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431221', '中方县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431222', '沅陵县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431223', '辰溪县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431224', '溆浦县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431225', '会同县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431226', '麻阳苗族自治县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431227', '新晃侗族自治县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431228', '芷江侗族自治县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431229', '靖州苗族侗族自治县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431230', '通道侗族自治县', '4312', '3');
INSERT INTO `t_city_info` VALUES ('431281', '洪江市', '4312', '3');
INSERT INTO `t_city_info` VALUES ('4313', '娄底市', '43', '2');
INSERT INTO `t_city_info` VALUES ('431301', '娄底市市辖区', '4313', '3');
INSERT INTO `t_city_info` VALUES ('431302', '娄星区', '4313', '3');
INSERT INTO `t_city_info` VALUES ('431321', '双峰县', '4313', '3');
INSERT INTO `t_city_info` VALUES ('431322', '新化县', '4313', '3');
INSERT INTO `t_city_info` VALUES ('431381', '冷水江市', '4313', '3');
INSERT INTO `t_city_info` VALUES ('431382', '涟源市', '4313', '3');
INSERT INTO `t_city_info` VALUES ('4331', '湘西土家族苗族自治州', '43', '2');
INSERT INTO `t_city_info` VALUES ('433101', '吉首市', '4331', '3');
INSERT INTO `t_city_info` VALUES ('433122', '泸溪县', '4331', '3');
INSERT INTO `t_city_info` VALUES ('433123', '凤凰县', '4331', '3');
INSERT INTO `t_city_info` VALUES ('433124', '花垣县', '4331', '3');
INSERT INTO `t_city_info` VALUES ('433125', '保靖县', '4331', '3');
INSERT INTO `t_city_info` VALUES ('433126', '古丈县', '4331', '3');
INSERT INTO `t_city_info` VALUES ('433127', '永顺县', '4331', '3');
INSERT INTO `t_city_info` VALUES ('433130', '龙山县', '4331', '3');
INSERT INTO `t_city_info` VALUES ('44', '广东省', null, '1');
INSERT INTO `t_city_info` VALUES ('4401', '广州市', '44', '2');
INSERT INTO `t_city_info` VALUES ('440101', '广州市市辖区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440103', '荔湾区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440104', '越秀区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440105', '海珠区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440106', '天河区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440111', '白云区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440112', '黄埔区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440113', '番禺区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440114', '花都区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440115', '南沙区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440117', '从化区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('440118', '增城区', '4401', '3');
INSERT INTO `t_city_info` VALUES ('4402', '韶关市', '44', '2');
INSERT INTO `t_city_info` VALUES ('440201', '韶关市市辖区', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440203', '武江区', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440204', '浈江区', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440205', '曲江区', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440222', '始兴县', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440224', '仁化县', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440229', '翁源县', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440232', '乳源瑶族自治县', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440233', '新丰县', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440281', '乐昌市', '4402', '3');
INSERT INTO `t_city_info` VALUES ('440282', '南雄市', '4402', '3');
INSERT INTO `t_city_info` VALUES ('4403', '深圳市', '44', '2');
INSERT INTO `t_city_info` VALUES ('440301', '深圳市市辖区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('440303', '罗湖区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('440304', '福田区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('440305', '南山区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('440306', '宝安区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('440307', '龙岗区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('440308', '盐田区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('440309', '龙华区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('440310', '坪山区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('440311', '光明区', '4403', '3');
INSERT INTO `t_city_info` VALUES ('4404', '珠海市', '44', '2');
INSERT INTO `t_city_info` VALUES ('440401', '珠海市市辖区', '4404', '3');
INSERT INTO `t_city_info` VALUES ('440402', '香洲区', '4404', '3');
INSERT INTO `t_city_info` VALUES ('440403', '斗门区', '4404', '3');
INSERT INTO `t_city_info` VALUES ('440404', '金湾区', '4404', '3');
INSERT INTO `t_city_info` VALUES ('4405', '汕头市', '44', '2');
INSERT INTO `t_city_info` VALUES ('440501', '汕头市市辖区', '4405', '3');
INSERT INTO `t_city_info` VALUES ('440507', '龙湖区', '4405', '3');
INSERT INTO `t_city_info` VALUES ('440511', '金平区', '4405', '3');
INSERT INTO `t_city_info` VALUES ('440512', '濠江区', '4405', '3');
INSERT INTO `t_city_info` VALUES ('440513', '潮阳区', '4405', '3');
INSERT INTO `t_city_info` VALUES ('440514', '潮南区', '4405', '3');
INSERT INTO `t_city_info` VALUES ('440515', '澄海区', '4405', '3');
INSERT INTO `t_city_info` VALUES ('440523', '南澳县', '4405', '3');
INSERT INTO `t_city_info` VALUES ('4406', '佛山市', '44', '2');
INSERT INTO `t_city_info` VALUES ('440601', '佛山市市辖区', '4406', '3');
INSERT INTO `t_city_info` VALUES ('440604', '禅城区', '4406', '3');
INSERT INTO `t_city_info` VALUES ('440605', '南海区', '4406', '3');
INSERT INTO `t_city_info` VALUES ('440606', '顺德区', '4406', '3');
INSERT INTO `t_city_info` VALUES ('440607', '三水区', '4406', '3');
INSERT INTO `t_city_info` VALUES ('440608', '高明区', '4406', '3');
INSERT INTO `t_city_info` VALUES ('4407', '江门市', '44', '2');
INSERT INTO `t_city_info` VALUES ('440701', '江门市市辖区', '4407', '3');
INSERT INTO `t_city_info` VALUES ('440703', '蓬江区', '4407', '3');
INSERT INTO `t_city_info` VALUES ('440704', '江海区', '4407', '3');
INSERT INTO `t_city_info` VALUES ('440705', '新会区', '4407', '3');
INSERT INTO `t_city_info` VALUES ('440781', '台山市', '4407', '3');
INSERT INTO `t_city_info` VALUES ('440783', '开平市', '4407', '3');
INSERT INTO `t_city_info` VALUES ('440784', '鹤山市', '4407', '3');
INSERT INTO `t_city_info` VALUES ('440785', '恩平市', '4407', '3');
INSERT INTO `t_city_info` VALUES ('4408', '湛江市', '44', '2');
INSERT INTO `t_city_info` VALUES ('440801', '湛江市市辖区', '4408', '3');
INSERT INTO `t_city_info` VALUES ('440802', '赤坎区', '4408', '3');
INSERT INTO `t_city_info` VALUES ('440803', '霞山区', '4408', '3');
INSERT INTO `t_city_info` VALUES ('440804', '坡头区', '4408', '3');
INSERT INTO `t_city_info` VALUES ('440811', '麻章区', '4408', '3');
INSERT INTO `t_city_info` VALUES ('440823', '遂溪县', '4408', '3');
INSERT INTO `t_city_info` VALUES ('440825', '徐闻县', '4408', '3');
INSERT INTO `t_city_info` VALUES ('440881', '廉江市', '4408', '3');
INSERT INTO `t_city_info` VALUES ('440882', '雷州市', '4408', '3');
INSERT INTO `t_city_info` VALUES ('440883', '吴川市', '4408', '3');
INSERT INTO `t_city_info` VALUES ('4409', '茂名市', '44', '2');
INSERT INTO `t_city_info` VALUES ('440901', '茂名市市辖区', '4409', '3');
INSERT INTO `t_city_info` VALUES ('440902', '茂南区', '4409', '3');
INSERT INTO `t_city_info` VALUES ('440904', '电白区', '4409', '3');
INSERT INTO `t_city_info` VALUES ('440981', '高州市', '4409', '3');
INSERT INTO `t_city_info` VALUES ('440982', '化州市', '4409', '3');
INSERT INTO `t_city_info` VALUES ('440983', '信宜市', '4409', '3');
INSERT INTO `t_city_info` VALUES ('4412', '肇庆市', '44', '2');
INSERT INTO `t_city_info` VALUES ('441201', '肇庆市市辖区', '4412', '3');
INSERT INTO `t_city_info` VALUES ('441202', '端州区', '4412', '3');
INSERT INTO `t_city_info` VALUES ('441203', '鼎湖区', '4412', '3');
INSERT INTO `t_city_info` VALUES ('441204', '高要区', '4412', '3');
INSERT INTO `t_city_info` VALUES ('441223', '广宁县', '4412', '3');
INSERT INTO `t_city_info` VALUES ('441224', '怀集县', '4412', '3');
INSERT INTO `t_city_info` VALUES ('441225', '封开县', '4412', '3');
INSERT INTO `t_city_info` VALUES ('441226', '德庆县', '4412', '3');
INSERT INTO `t_city_info` VALUES ('441284', '四会市', '4412', '3');
INSERT INTO `t_city_info` VALUES ('4413', '惠州市', '44', '2');
INSERT INTO `t_city_info` VALUES ('441301', '惠州市市辖区', '4413', '3');
INSERT INTO `t_city_info` VALUES ('441302', '惠城区', '4413', '3');
INSERT INTO `t_city_info` VALUES ('441303', '惠阳区', '4413', '3');
INSERT INTO `t_city_info` VALUES ('441322', '博罗县', '4413', '3');
INSERT INTO `t_city_info` VALUES ('441323', '惠东县', '4413', '3');
INSERT INTO `t_city_info` VALUES ('441324', '龙门县', '4413', '3');
INSERT INTO `t_city_info` VALUES ('4414', '梅州市', '44', '2');
INSERT INTO `t_city_info` VALUES ('441401', '梅州市市辖区', '4414', '3');
INSERT INTO `t_city_info` VALUES ('441402', '梅江区', '4414', '3');
INSERT INTO `t_city_info` VALUES ('441403', '梅县区', '4414', '3');
INSERT INTO `t_city_info` VALUES ('441422', '大埔县', '4414', '3');
INSERT INTO `t_city_info` VALUES ('441423', '丰顺县', '4414', '3');
INSERT INTO `t_city_info` VALUES ('441424', '五华县', '4414', '3');
INSERT INTO `t_city_info` VALUES ('441426', '平远县', '4414', '3');
INSERT INTO `t_city_info` VALUES ('441427', '蕉岭县', '4414', '3');
INSERT INTO `t_city_info` VALUES ('441481', '兴宁市', '4414', '3');
INSERT INTO `t_city_info` VALUES ('4415', '汕尾市', '44', '2');
INSERT INTO `t_city_info` VALUES ('441501', '汕尾市市辖区', '4415', '3');
INSERT INTO `t_city_info` VALUES ('441502', '城区', '4415', '3');
INSERT INTO `t_city_info` VALUES ('441521', '海丰县', '4415', '3');
INSERT INTO `t_city_info` VALUES ('441523', '陆河县', '4415', '3');
INSERT INTO `t_city_info` VALUES ('441581', '陆丰市', '4415', '3');
INSERT INTO `t_city_info` VALUES ('4416', '河源市', '44', '2');
INSERT INTO `t_city_info` VALUES ('441601', '河源市市辖区', '4416', '3');
INSERT INTO `t_city_info` VALUES ('441602', '源城区', '4416', '3');
INSERT INTO `t_city_info` VALUES ('441621', '紫金县', '4416', '3');
INSERT INTO `t_city_info` VALUES ('441622', '龙川县', '4416', '3');
INSERT INTO `t_city_info` VALUES ('441623', '连平县', '4416', '3');
INSERT INTO `t_city_info` VALUES ('441624', '和平县', '4416', '3');
INSERT INTO `t_city_info` VALUES ('441625', '东源县', '4416', '3');
INSERT INTO `t_city_info` VALUES ('4417', '阳江市', '44', '2');
INSERT INTO `t_city_info` VALUES ('441701', '阳江市市辖区', '4417', '3');
INSERT INTO `t_city_info` VALUES ('441702', '江城区', '4417', '3');
INSERT INTO `t_city_info` VALUES ('441704', '阳东区', '4417', '3');
INSERT INTO `t_city_info` VALUES ('441721', '阳西县', '4417', '3');
INSERT INTO `t_city_info` VALUES ('441781', '阳春市', '4417', '3');
INSERT INTO `t_city_info` VALUES ('4418', '清远市', '44', '2');
INSERT INTO `t_city_info` VALUES ('441801', '清远市市辖区', '4418', '3');
INSERT INTO `t_city_info` VALUES ('441802', '清城区', '4418', '3');
INSERT INTO `t_city_info` VALUES ('441803', '清新区', '4418', '3');
INSERT INTO `t_city_info` VALUES ('441821', '佛冈县', '4418', '3');
INSERT INTO `t_city_info` VALUES ('441823', '阳山县', '4418', '3');
INSERT INTO `t_city_info` VALUES ('441825', '连山壮族瑶族自治县', '4418', '3');
INSERT INTO `t_city_info` VALUES ('441826', '连南瑶族自治县', '4418', '3');
INSERT INTO `t_city_info` VALUES ('441881', '英德市', '4418', '3');
INSERT INTO `t_city_info` VALUES ('441882', '连州市', '4418', '3');
INSERT INTO `t_city_info` VALUES ('4419', '东莞市', '44', '2');
INSERT INTO `t_city_info` VALUES ('4420', '中山市', '44', '2');
INSERT INTO `t_city_info` VALUES ('442101', '东沙群岛', '4421', '3');
INSERT INTO `t_city_info` VALUES ('4451', '潮州市', '44', '2');
INSERT INTO `t_city_info` VALUES ('445101', '潮州市市辖区', '4451', '3');
INSERT INTO `t_city_info` VALUES ('445102', '湘桥区', '4451', '3');
INSERT INTO `t_city_info` VALUES ('445103', '潮安区', '4451', '3');
INSERT INTO `t_city_info` VALUES ('445122', '饶平县', '4451', '3');
INSERT INTO `t_city_info` VALUES ('4452', '揭阳市', '44', '2');
INSERT INTO `t_city_info` VALUES ('445201', '揭阳市市辖区', '4452', '3');
INSERT INTO `t_city_info` VALUES ('445202', '榕城区', '4452', '3');
INSERT INTO `t_city_info` VALUES ('445203', '揭东区', '4452', '3');
INSERT INTO `t_city_info` VALUES ('445222', '揭西县', '4452', '3');
INSERT INTO `t_city_info` VALUES ('445224', '惠来县', '4452', '3');
INSERT INTO `t_city_info` VALUES ('445281', '普宁市', '4452', '3');
INSERT INTO `t_city_info` VALUES ('4453', '云浮市', '44', '2');
INSERT INTO `t_city_info` VALUES ('445301', '云浮市市辖区', '4453', '3');
INSERT INTO `t_city_info` VALUES ('445302', '云城区', '4453', '3');
INSERT INTO `t_city_info` VALUES ('445303', '云安区', '4453', '3');
INSERT INTO `t_city_info` VALUES ('445321', '新兴县', '4453', '3');
INSERT INTO `t_city_info` VALUES ('445322', '郁南县', '4453', '3');
INSERT INTO `t_city_info` VALUES ('445381', '罗定市', '4453', '3');
INSERT INTO `t_city_info` VALUES ('45', '广西壮族自治区', null, '1');
INSERT INTO `t_city_info` VALUES ('4501', '南宁市', '45', '2');
INSERT INTO `t_city_info` VALUES ('450101', '南宁市市辖区', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450102', '兴宁区', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450103', '青秀区', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450105', '江南区', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450107', '西乡塘区', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450108', '良庆区', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450109', '邕宁区', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450110', '武鸣区', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450123', '隆安县', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450124', '马山县', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450125', '上林县', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450126', '宾阳县', '4501', '3');
INSERT INTO `t_city_info` VALUES ('450127', '横县', '4501', '3');
INSERT INTO `t_city_info` VALUES ('4502', '柳州市', '45', '2');
INSERT INTO `t_city_info` VALUES ('450201', '柳州市市辖区', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450202', '城中区', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450203', '鱼峰区', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450204', '柳南区', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450205', '柳北区', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450206', '柳江区', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450222', '柳城县', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450223', '鹿寨县', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450224', '融安县', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450225', '融水苗族自治县', '4502', '3');
INSERT INTO `t_city_info` VALUES ('450226', '三江侗族自治县', '4502', '3');
INSERT INTO `t_city_info` VALUES ('4503', '桂林市', '45', '2');
INSERT INTO `t_city_info` VALUES ('450301', '桂林市市辖区', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450302', '秀峰区', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450303', '叠彩区', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450304', '象山区', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450305', '七星区', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450311', '雁山区', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450312', '临桂区', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450321', '阳朔县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450323', '灵川县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450324', '全州县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450325', '兴安县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450326', '永福县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450327', '灌阳县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450328', '龙胜各族自治县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450329', '资源县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450330', '平乐县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450332', '恭城瑶族自治县', '4503', '3');
INSERT INTO `t_city_info` VALUES ('450381', '荔浦市', '4503', '3');
INSERT INTO `t_city_info` VALUES ('4504', '梧州市', '45', '2');
INSERT INTO `t_city_info` VALUES ('450401', '梧州市市辖区', '4504', '3');
INSERT INTO `t_city_info` VALUES ('450403', '万秀区', '4504', '3');
INSERT INTO `t_city_info` VALUES ('450405', '长洲区', '4504', '3');
INSERT INTO `t_city_info` VALUES ('450406', '龙圩区', '4504', '3');
INSERT INTO `t_city_info` VALUES ('450421', '苍梧县', '4504', '3');
INSERT INTO `t_city_info` VALUES ('450422', '藤县', '4504', '3');
INSERT INTO `t_city_info` VALUES ('450423', '蒙山县', '4504', '3');
INSERT INTO `t_city_info` VALUES ('450481', '岑溪市', '4504', '3');
INSERT INTO `t_city_info` VALUES ('4505', '北海市', '45', '2');
INSERT INTO `t_city_info` VALUES ('450501', '北海市市辖区', '4505', '3');
INSERT INTO `t_city_info` VALUES ('450502', '海城区', '4505', '3');
INSERT INTO `t_city_info` VALUES ('450503', '银海区', '4505', '3');
INSERT INTO `t_city_info` VALUES ('450512', '铁山港区', '4505', '3');
INSERT INTO `t_city_info` VALUES ('450521', '合浦县', '4505', '3');
INSERT INTO `t_city_info` VALUES ('4506', '防城港市', '45', '2');
INSERT INTO `t_city_info` VALUES ('450601', '防城港市市辖区', '4506', '3');
INSERT INTO `t_city_info` VALUES ('450602', '港口区', '4506', '3');
INSERT INTO `t_city_info` VALUES ('450603', '防城区', '4506', '3');
INSERT INTO `t_city_info` VALUES ('450621', '上思县', '4506', '3');
INSERT INTO `t_city_info` VALUES ('450681', '东兴市', '4506', '3');
INSERT INTO `t_city_info` VALUES ('4507', '钦州市', '45', '2');
INSERT INTO `t_city_info` VALUES ('450701', '钦州市市辖区', '4507', '3');
INSERT INTO `t_city_info` VALUES ('450702', '钦南区', '4507', '3');
INSERT INTO `t_city_info` VALUES ('450703', '钦北区', '4507', '3');
INSERT INTO `t_city_info` VALUES ('450721', '灵山县', '4507', '3');
INSERT INTO `t_city_info` VALUES ('450722', '浦北县', '4507', '3');
INSERT INTO `t_city_info` VALUES ('4508', '贵港市', '45', '2');
INSERT INTO `t_city_info` VALUES ('450801', '贵港市市辖区', '4508', '3');
INSERT INTO `t_city_info` VALUES ('450802', '港北区', '4508', '3');
INSERT INTO `t_city_info` VALUES ('450803', '港南区', '4508', '3');
INSERT INTO `t_city_info` VALUES ('450804', '覃塘区', '4508', '3');
INSERT INTO `t_city_info` VALUES ('450821', '平南县', '4508', '3');
INSERT INTO `t_city_info` VALUES ('450881', '桂平市', '4508', '3');
INSERT INTO `t_city_info` VALUES ('4509', '玉林市', '45', '2');
INSERT INTO `t_city_info` VALUES ('450901', '玉林市市辖区', '4509', '3');
INSERT INTO `t_city_info` VALUES ('450902', '玉州区', '4509', '3');
INSERT INTO `t_city_info` VALUES ('450903', '福绵区', '4509', '3');
INSERT INTO `t_city_info` VALUES ('450921', '容县', '4509', '3');
INSERT INTO `t_city_info` VALUES ('450922', '陆川县', '4509', '3');
INSERT INTO `t_city_info` VALUES ('450923', '博白县', '4509', '3');
INSERT INTO `t_city_info` VALUES ('450924', '兴业县', '4509', '3');
INSERT INTO `t_city_info` VALUES ('450981', '北流市', '4509', '3');
INSERT INTO `t_city_info` VALUES ('4510', '百色市', '45', '2');
INSERT INTO `t_city_info` VALUES ('451001', '百色市市辖区', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451002', '右江区', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451003', '田阳区', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451022', '田东县', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451024', '德保县', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451026', '那坡县', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451027', '凌云县', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451028', '乐业县', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451029', '田林县', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451030', '西林县', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451031', '隆林各族自治县', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451081', '靖西市', '4510', '3');
INSERT INTO `t_city_info` VALUES ('451082', '平果市', '4510', '3');
INSERT INTO `t_city_info` VALUES ('4511', '贺州市', '45', '2');
INSERT INTO `t_city_info` VALUES ('451101', '贺州市市辖区', '4511', '3');
INSERT INTO `t_city_info` VALUES ('451102', '八步区', '4511', '3');
INSERT INTO `t_city_info` VALUES ('451103', '平桂区', '4511', '3');
INSERT INTO `t_city_info` VALUES ('451121', '昭平县', '4511', '3');
INSERT INTO `t_city_info` VALUES ('451122', '钟山县', '4511', '3');
INSERT INTO `t_city_info` VALUES ('451123', '富川瑶族自治县', '4511', '3');
INSERT INTO `t_city_info` VALUES ('4512', '河池市', '45', '2');
INSERT INTO `t_city_info` VALUES ('451201', '河池市市辖区', '4512', '3');
 

-- ----------------------------
-- Table structure for t_comment_images
-- ----------------------------
DROP TABLE IF EXISTS `t_comment_images`;
CREATE TABLE `t_comment_images` (
  `images_id` varchar(32) NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `comment_id` varchar(32) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  PRIMARY KEY (`images_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_comment_images
-- ----------------------------

-- ----------------------------
-- Table structure for t_comment_info
-- ----------------------------
DROP TABLE IF EXISTS `t_comment_info`;
CREATE TABLE `t_comment_info` (
  `id` varchar(32) NOT NULL,
  `currency_id` varchar(32) DEFAULT NULL,
  `sys_user_id` varchar(32) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for t_dictionary_info
-- ----------------------------
DROP TABLE IF EXISTS `t_dictionary_info`;
CREATE TABLE `t_dictionary_info` (
  `dictionary_id` varchar(32) NOT NULL,
  `code` varchar(50) DEFAULT NULL COMMENT '字典编号',
  `title` varchar(255) DEFAULT NULL COMMENT '字典标题',
  `icon` varchar(255) DEFAULT NULL,
  `parent_id` varchar(32) DEFAULT NULL COMMENT '所属上级',
  `classify` varchar(32) DEFAULT NULL COMMENT '字典分类',
  `level` int(1) DEFAULT NULL COMMENT '字典等级',
  `status` int(1) DEFAULT NULL COMMENT '状态：0、禁用，1、启用',
  `create_time` datetime DEFAULT NULL,
  `create_date` int(8) DEFAULT NULL,
  PRIMARY KEY (`dictionary_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典表';

-- ----------------------------
-- Records of t_dictionary_info
-- ----------------------------

-- ----------------------------
-- Table structure for t_floor_info
-- ----------------------------
DROP TABLE IF EXISTS `t_floor_info`;
CREATE TABLE `t_floor_info` (
  `floor_id` varchar(32) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `price` double(8,2) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `p_id` varchar(32) DEFAULT NULL,
  `c_id` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `content` longtext,
  `cover` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`floor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='楼盘信息表';

-- ----------------------------
-- Records of t_floor_info
-- ----------------------------
INSERT INTO `t_floor_info` VALUES ('4d4a9ef3b99cad1791ed411450e7dc76', 'fghfghfghf', '534534534,顺丰大酒店,御花园', '345.00', '43534534', '31', '3101', '3gdfgdfgfdgfdgdfgd', 'dfgdfgdfgdfgdfgdfgdf', '1616674419391.jpg.jpg', '2021-03-25 20:13:39');

-- ----------------------------
-- Table structure for t_food_info
-- ----------------------------
DROP TABLE IF EXISTS `t_food_info`;
CREATE TABLE `t_food_info` (
  `food_id` varchar(32) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `price` double(8,2) DEFAULT NULL,
  `level` int(1) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `p_id` varchar(32) DEFAULT NULL,
  `c_id` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `characteristic` varchar(255) DEFAULT NULL,
  `content` longtext,
  `cover` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`food_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='饮食信息表';

-- ----------------------------
-- Table structure for t_hotel_info
-- ----------------------------
DROP TABLE IF EXISTS `t_hotel_info`;
CREATE TABLE `t_hotel_info` (
  `hotel_id` varchar(32) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `price` double(8,2) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `level` int(1) DEFAULT NULL,
  `p_id` varchar(32) DEFAULT NULL,
  `c_id` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `content` longtext,
  `cover` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`hotel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='酒店信息表';

-- ----------------------------
-- Table structure for t_scenic_images
-- ----------------------------
DROP TABLE IF EXISTS `t_scenic_images`;
CREATE TABLE `t_scenic_images` (
  `image_id` varchar(32) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `scenic_id` varchar(32) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for t_scenic_info
-- ----------------------------
DROP TABLE IF EXISTS `t_scenic_info`;
CREATE TABLE `t_scenic_info` (
  `scenic_id` varchar(32) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `price` double(8,2) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `level` int(1) DEFAULT NULL,
  `p_id` varchar(32) DEFAULT NULL,
  `c_id` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `begin_time` varchar(255) DEFAULT NULL COMMENT '开园开始时间',
  `end_time` varchar(255) DEFAULT NULL COMMENT '开园结束时间',
  `content` longtext,
  `cover` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`scenic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='景点信息表';

-- ----------------------------
-- Table structure for t_sys_resources
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_resources`;
CREATE TABLE `t_sys_resources` (
  `resource_id` varchar(32) NOT NULL,
  `title` varchar(10) DEFAULT NULL COMMENT '标题',
  `url` varchar(50) DEFAULT NULL COMMENT '请求地址',
  `perms` varchar(255) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(20) DEFAULT NULL COMMENT '图标',
  `visible` bit(1) DEFAULT NULL COMMENT '是否可见',
  `style` varchar(255) DEFAULT NULL,
  `parent_id` varchar(32) DEFAULT NULL COMMENT '父类编号',
  `type` int(1) DEFAULT NULL COMMENT '按钮类型，0、工具栏，1、操作条',
  `classify` varchar(255) DEFAULT NULL COMMENT '资源分类，目录、菜单、按钮',
  `sort` int(4) DEFAULT NULL COMMENT '排序',
  `ascription` int(2) DEFAULT NULL COMMENT '资源归属，1、后台，2、app，3、其他',
  `grouping` varchar(255) DEFAULT NULL COMMENT '目录分组',
  `status` int(1) DEFAULT NULL COMMENT '状态，0、禁用，1、启用，-1、删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`resource_id`) USING BTREE,
  KEY `parent_id` (`parent_id`),
  KEY `classify` (`classify`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统资源表';

-- ----------------------------
-- Table structure for t_sys_role_authority
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role_authority`;
CREATE TABLE `t_sys_role_authority` (
  `authority_id` varchar(32) NOT NULL COMMENT '权限号',
  `resource_id` varchar(32) DEFAULT NULL COMMENT '资源号',
  `role_id` varchar(32) DEFAULT NULL COMMENT '角色号',
  PRIMARY KEY (`authority_id`) USING BTREE,
  KEY `index_authority_menu_id` (`resource_id`) USING BTREE,
  KEY `index_authority_role_id` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统用户权限表';

-- ----------------------------
-- Table structure for t_sys_role_info
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role_info`;
CREATE TABLE `t_sys_role_info` (
  `role_id` varchar(32) NOT NULL COMMENT '角色号',
  `code` varchar(255) DEFAULT NULL COMMENT '角色编码',
  `title` varchar(255) DEFAULT NULL COMMENT '角色标题',
  `detail` varchar(255) DEFAULT NULL COMMENT '角色备注',
  `status` int(1) DEFAULT NULL COMMENT '状态：1：启用、0：禁用、-1：删除',
  PRIMARY KEY (`role_id`) USING BTREE,
  KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统用户角色表';

-- ----------------------------
-- Records of t_sys_role_info
-- ----------------------------
INSERT INTO `t_sys_role_info` VALUES ('c00e88466147697e63781dfdd1cb8efd', 'app', 'App用户', '', '1');
INSERT INTO `t_sys_role_info` VALUES ('dadd65d82a694cc49288c930fd5527f5', 'dev', '开发者', '', '1');

-- ----------------------------
-- Table structure for t_sys_user_basic_info
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_basic_info`;
CREATE TABLE `t_sys_user_basic_info` (
  `sys_user_id` varchar(32) NOT NULL,
  `code` varchar(32) DEFAULT NULL COMMENT '用户编码',
  `nice` varchar(50) DEFAULT NULL COMMENT '昵称',
  `face` varchar(255) DEFAULT NULL COMMENT '头像',
  `sex` int(1) DEFAULT NULL COMMENT '性别',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `phone` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `province_id` varchar(32) DEFAULT NULL COMMENT '省编号',
  `city_id` varchar(32) DEFAULT NULL COMMENT '市编号',
  `area_id` varchar(32) DEFAULT NULL COMMENT '区县编号',
  `address` varchar(100) DEFAULT NULL COMMENT '地址',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱地址',
  `type` int(1) DEFAULT NULL COMMENT '用户类型，0：后台、1：小程序',
  `qq` varchar(255) DEFAULT NULL,
  `weixin` varchar(255) DEFAULT NULL,
  `sign` varchar(1) DEFAULT NULL COMMENT '雷达标记',
  `online` int(1) DEFAULT NULL COMMENT '在线状态',
  `balance` double(8,4) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL COMMENT '设备指纹',
  `position_id` varchar(32) DEFAULT NULL COMMENT '职位号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_date` int(8) DEFAULT NULL COMMENT '创建日期',
  `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
  `last_update_date` int(8) DEFAULT NULL COMMENT '最后更新日期',
  PRIMARY KEY (`sys_user_id`) USING BTREE,
  KEY `code` (`code`),
  KEY `type` (`type`),
  KEY `sign` (`sign`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统用户基本信息表';

-- ----------------------------
-- Table structure for t_sys_user_info
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_info`;
CREATE TABLE `t_sys_user_info` (
  `sys_user_id` varchar(32) NOT NULL,
  `account` varchar(30) NOT NULL COMMENT '账号',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `roles` varchar(32) DEFAULT NULL COMMENT '用户角色列表',
  `status` int(2) DEFAULT NULL COMMENT '状态：1：启用、0：禁用、-1：删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_date` int(8) DEFAULT NULL COMMENT '创建日期',
  `last_update_time` datetime DEFAULT NULL COMMENT '最后修改时间',
  `last_update_date` int(8) DEFAULT NULL COMMENT '最后更新日期',
  PRIMARY KEY (`sys_user_id`) USING BTREE,
  KEY `index_sys_user_account` (`account`) USING BTREE,
  KEY `index_sys_user_password` (`password`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统用户账号表';

-- ----------------------------
-- Table structure for t_user_collection
-- ----------------------------
DROP TABLE IF EXISTS `t_user_collection`;
CREATE TABLE `t_user_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key_id` varchar(255) DEFAULT NULL,
  `type` int(1) DEFAULT NULL,
  `sys_user_id` varchar(32) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_user_collection
-- ----------------------------
INSERT INTO `t_user_collection` VALUES ('16', '166d808a4e953bdfe020487f71936e1f', '2', 'c72cc392547321475ab63cb449596a76', '2021-03-26 00:14:45');
 

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

毕设之家

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值