/*
Navicat Premium Data Transfer
Source Server : 42.193.247.61-TEST-ROOT
Source Server Type : MySQL
Source Server Version : 50736
Source Host : 42.193.247.61:3307
Source Schema : nfbtest
Target Server Type : MySQL
Target Server Version : 50736
File Encoding : 65001
Date: 24/02/2022 12:21:30
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for nfb_tree_town
-- ----------------------------
DROP TABLE IF EXISTS `nfb_tree_town`;
CREATE TABLE `nfb_tree_town` (
`id` int(11) NOT NULL,
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`town_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`area_id` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of nfb_tree_town
-- ----------------------------
INSERT INTO `nfb_tree_town` VALUES (5008, '辛集镇', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5009, '旧城镇', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5010, '张古庄镇', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5011, '位伯镇', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5012, '新垒头镇', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5013, '新城镇', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5014, '南智邱镇', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5015, '王口镇', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5016, '天宫营乡', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5017, '前营乡', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5018, '马庄乡', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5019, '和睦井乡', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5020, '田家庄乡', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5021, '中里厢乡', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5022, '小辛庄乡', NULL, 143);
INSERT INTO `nfb_tree_town` VALUES (5037, '晋州镇', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5038, '总十庄镇', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5039, '营里镇', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5040, '桃园镇', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5041, '东卓宿镇', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5042, '马于镇', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5043, '小樵镇', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5044, '槐树镇', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5045, '东里庄镇', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5046, '周家庄乡', NULL, 145);
INSERT INTO `nfb_tree_town` VALUES (5048, '化皮镇', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5049, '承安镇', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5050, '正莫镇', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5051, '南大岳镇', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5052, '杜固镇', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5053, '邯邰镇', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5054, '东王镇', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5055, '马头铺镇', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5056, '协神乡', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5057, '木村乡', NULL, 146);
INSERT INTO `nfb_tree_town` VALUES (5071, '遵化镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5072, '堡子店镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5073, '马兰峪镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5074, '平安城镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5075, '东新庄镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5076, '新店子镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5077, '党峪镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5078, '地北头镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5079, '东旧寨镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5080, '铁厂镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5081, '苏家洼镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5082, '建明镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5083, '石门镇', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5084, '崔家庄乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5085, '西留村乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5086, '西下营满族乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5087, '汤泉满族乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5088, '兴旺寨乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5089, '东陵满族乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5090, '刘备寨乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5091, '团瓢庄乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5092, '娘娘庄乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5093, '西三里乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5094, '侯家寨乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5095, '小厂乡', NULL, 2756);
INSERT INTO `nfb_tree_town` VALUES (5118, '泊镇', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5119, '交河镇', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5120, '齐桥镇', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5121, '寺门村镇', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5122, '郝村镇', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5123, '富镇镇', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5124, '文庙镇', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5125, '洼里王镇', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5126, '王武镇', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5127, '营子乡', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5128, '四营乡', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5129, '西辛店乡', NULL, 266);
INSERT INTO `nfb_tree_town` VALUES (5130, '瀛州路街道', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5131, '米各庄镇', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5132, '景和镇', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5133, '卧佛堂镇', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5134, '束城镇', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5135, '留古寺镇', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5136, '沙河桥镇', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5137, '故仙乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5138, '黎民居乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5139, '兴村镇', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5140, '沙洼乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5141, '西九吉乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5142, '北石槽乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5143, '诗经村镇', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5144, '郭家村乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5145, '时村乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5146, '行别营乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5147, '尊祖庄镇', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5148, '龙华店乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5149, '果子洼回族乡', NULL, 268);
INSERT INTO `nfb_tree_town` VALUES (5186, '冀州镇', NULL, 291);
INSERT INTO `nfb_tree_town` VALUES (5187, '魏家屯镇', NULL, 291);
INSERT INTO `nfb_tree_town` VALUES (5188, '官道李镇', NULL, 291);
INSERT INTO `nfb_tree_town` VALUES (5189, '南午村镇', NULL, 291);
INSERT INTO `nfb_tree_town` VALUES (5190, '周村镇', NULL, 291);
INSERT INTO `nfb_tree_town` VALUES (5191, '码头李镇', NULL, 291);
INSERT INTO `nfb_tree_town` VALUES (5192, '西王镇', NULL, 291);
INSERT INTO `nfb
评论0