/*
Navicat MySQL Data Transfer
Source Server : spzx_server
Source Server Version : 50718
Source Host : 221.236.16.233:23306
Source Database : spzx123
Target Server Type : MYSQL
Target Server Version : 50718
File Encoding : 65001
Date: 2017-08-31 12:50:10
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for spzx_business_position_all
-- ----------------------------
DROP TABLE IF EXISTS `spzx_business_position_all`;
CREATE TABLE `spzx_business_position_all` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`province_id` bigint(20) unsigned NOT NULL,
`province_name` char(64) NOT NULL,
`city_id` bigint(20) unsigned NOT NULL,
`city_name` char(64) NOT NULL,
`county_id` bigint(20) unsigned NOT NULL,
`county_name` char(64) NOT NULL,
`town_id` bigint(20) unsigned NOT NULL,
`town_name` char(64) NOT NULL,
`village_id` bigint(20) unsigned NOT NULL,
`village_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `village_id` (`village_id`)
) ENGINE=InnoDB AUTO_INCREMENT=693338 DEFAULT CHARSET=utf8 COMMENT='省市县镇村数据';
-- ----------------------------
-- Records of spzx_business_position_all
-- ----------------------------
INSERT INTO `spzx_business_position_all` VALUES ('1', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001001', '多福巷社区');
INSERT INTO `spzx_business_position_all` VALUES ('2', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001002', '银闸社区');
INSERT INTO `spzx_business_position_all` VALUES ('3', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001005', '东厂社区');
INSERT INTO `spzx_business_position_all` VALUES ('4', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001006', '智德社区');
INSERT INTO `spzx_business_position_all` VALUES ('5', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001007', '南池子社区');
INSERT INTO `spzx_business_position_all` VALUES ('6', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001008', '黄图岗社区');
INSERT INTO `spzx_business_position_all` VALUES ('7', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001009', '灯市口社区');
INSERT INTO `spzx_business_position_all` VALUES ('8', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001010', '正义路社区');
INSERT INTO `spzx_business_position_all` VALUES ('9', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001011', '甘雨社区');
INSERT INTO `spzx_business_position_all` VALUES ('10', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001013', '台基厂社区');
INSERT INTO `spzx_business_position_all` VALUES ('11', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001014', '韶九社区');
INSERT INTO `spzx_business_position_all` VALUES ('12', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001015', '王府井社区');
INSERT INTO `spzx_business_position_all` VALUES ('13', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002001', '隆福寺社区');
INSERT INTO `spzx_business_position_all` VALUES ('14', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002002', '吉祥社区');
INSERT INTO `spzx_business_position_all` VALUES ('15', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002003', '黄化门社区');
INSERT INTO `spzx_business_position_all` VALUES ('16', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002004', '钟鼓社区');
INSERT INTO `spzx_business_position_all` VALUES ('17', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002005', '魏家社区');
INSERT INTO `spzx_business_position_all` VALUES ('18', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002006', '汪芝麻社区');
INSERT INTO `spzx_business_position_all` VALUES ('19', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002008', '景山东街社区');
INSERT INTO `spzx_business_position_all` VALUES ('20', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002009', '皇城根北街社区');
INSERT INTO `spzx_business_position_all` VALUES ('21', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003001', '交东社区');
INSERT INTO `spzx_business_position_all` VALUES ('22', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003002', '福祥社区');
INSERT INTO `spzx_business_position_all` VALUES ('23', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003003', '大兴社区');
INSERT INTO `spzx_business_position_all` VALUES ('24', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003005', '府学社区');
INSERT INTO `spzx_business_position_all` VALUES ('25', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003007', '鼓楼苑社区');
INSERT INTO `spzx_business_position_all` VALUES ('26', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003008', '菊儿社区');
INSERT INTO `spzx_business_position_all` VALUES ('27', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003009', '南锣鼓巷社区');
INSERT INTO `spzx_business_position_all` VALUES ('28', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办事处', '110101004001', '交北头条社区');
INSERT INTO `spzx_business_position_all` VALUES ('29', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办事处', '110101004002', '北锣鼓巷社区');
INSERT INTO `spzx_business_position_all` VALUES ('30', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办事处', '110101004003', '国子监社区');
INSERT INTO `spzx_business_position_all` VALUES ('31', '110000000000', '北京市', '110100000000'