/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50721
Source Host : localhost:3306
Source Database : aid2018
Target Server Type : MYSQL
Target Server Version : 50721
File Encoding : 65001
Date: 2018-06-25 15:04:46
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for aid2018
-- ----------------------------
DROP TABLE IF EXISTS `aid2018`;
CREATE TABLE `aid2018` (
`code` char(12) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`level` char(10) DEFAULT NULL,
`parent` char(12) DEFAULT NULL,
`code_short` char(12) DEFAULT NULL,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aid2018
-- ----------------------------
INSERT INTO `aid2018` VALUES ('110000000000', '北京市', 'province', '0', '11');
INSERT INTO `aid2018` VALUES ('110100000000', '市辖区', 'city', '110000000000', '1101');
INSERT INTO `aid2018` VALUES ('110101000000', '东城区', 'country', '110100000000', '110101');
INSERT INTO `aid2018` VALUES ('110101001000', '东华门街道办事处', 'town', '110101000000', '110101001');
INSERT INTO `aid2018` VALUES ('110101001001', '多福巷社区居委会', 'village', '110101001000', '110101001001');
INSERT INTO `aid2018` VALUES ('110101001002', '银闸社区居委会', 'village', '110101001000', '110101001002');
INSERT INTO `aid2018` VALUES ('110101001005', '东厂社区居委会', 'village', '110101001000', '110101001005');
INSERT INTO `aid2018` VALUES ('110101001006', '智德社区居委会', 'village', '110101001000', '110101001006');
INSERT INTO `aid2018` VALUES ('110101001007', '南池子社区居委会', 'village', '110101001000', '110101001007');
INSERT INTO `aid2018` VALUES ('110101001008', '黄图岗社区居委会', 'village', '110101001000', '110101001008');
INSERT INTO `aid2018` VALUES ('110101001009', '灯市口社区居委会', 'village', '110101001000', '110101001009');
INSERT INTO `aid2018` VALUES ('110101001010', '正义路社区居委会', 'village', '110101001000', '110101001010');
INSERT INTO `aid2018` VALUES ('110101001011', '甘雨社区居委会', 'village', '110101001000', '110101001011');
INSERT INTO `aid2018` VALUES ('110101001013', '台基厂社区居委会', 'village', '110101001000', '110101001013');
INSERT INTO `aid2018` VALUES ('110101001014', '韶九社区居委会', 'village', '110101001000', '110101001014');
INSERT INTO `aid2018` VALUES ('110101001015', '王府井社区居委会', 'village', '110101001000', '110101001015');
INSERT INTO `aid2018` VALUES ('110101002000', '景山街道办事处', 'town', '110101000000', '110101002');
INSERT INTO `aid2018` VALUES ('110101002001', '隆福寺社区居委会', 'village', '110101002000', '110101002001');
INSERT INTO `aid2018` VALUES ('110101002002', '吉祥社区居委会', 'village', '110101002000', '110101002002');
INSERT INTO `aid2018` VALUES ('110101002003', '黄化门社区居委会', 'village', '110101002000', '110101002003');
INSERT INTO `aid2018` VALUES ('110101002004', '钟鼓社区居委会', 'village', '110101002000', '110101002004');
INSERT INTO `aid2018` VALUES ('110101002005', '魏家社区居委会', 'village', '110101002000', '110101002005');
INSERT INTO `aid2018` VALUES ('110101002006', '汪芝麻社区居委会', 'village', '110101002000', '110101002006');
INSERT INTO `aid2018` VALUES ('110101002008', '景山东街社区居委会', 'village', '110101002000', '110101002008');
INSERT INTO `aid2018` VALUES ('110101002009', '皇城根北街社区居委会', 'village', '110101002000', '110101002009');
INSERT INTO `aid2018` VALUES ('110101003000', '交道口街道办事处', 'town', '110101000000', '110101003');
INSERT INTO `aid2018` VALUES ('110101003001', '交东社区居委会', 'village', '110101003000', '110101003001');
INSERT INTO `aid2018` VALUES ('110101003002', '福祥社区居委会', 'village', '110101003000', '110101003002');
INSERT INTO `aid2018` VALUES ('110101003003', '大兴社区居委会', 'village', '110101003000', '110101003003');
INSERT INTO `aid2018` VALUES ('110101003005', '府学社区居委会', 'village', '110101003000', '110101003005');
INSERT INTO `aid2018` VALUES ('110101003007', '鼓楼苑社区居委会', 'village', '110101003000', '110101003007');
INSERT INTO `aid2018` VALUES ('110101003008', '菊儿社区居委会', 'village', '110101003000', '110101003008');
INSERT INTO `aid2018` VALUES ('110101003009', '南锣鼓巷社区居委会', 'village', '110101003000', '110101003009');
INSERT INTO `aid2018` VALUES ('110101004000', '安定门街道办事处', 'town', '110101000000', '110101004');
INSERT INTO `aid2018` VALUES ('110101004001', '交北头条社区居委会', 'village', '110101004000', '110101004001');
INSERT INTO `aid2018` VALUES ('110101004002', '北锣鼓巷社区居委会', 'village', '110101004000', '110101004002');
INSERT INTO `aid2018` VALUES ('110101004003', '国子监社区居委会', 'village', '110101004000', '110101004003');
INSERT INTO `aid2018` VALUES ('110101004004', '钟楼湾社区居委会', 'village', '110101004000', '110101004004');
INSERT INTO `aid2018` VALUES ('110101004005', '宝钞南社区居委会', 'village', '110101004000', '110101004005');
INSERT INTO `aid2018` VALUES ('110101004006', '五道营社区居委会', 'village', '110101004000', '110101004006');
INSERT INTO `aid2018` VALUES ('110101004009', '分司厅社区居委会', 'village', '110101004000', '110101004009');
INSERT INTO `aid2018` VALUES ('110101004011', '国旺社区居委会', 'village', '110101004000', '110101004011');
INSERT INTO `aid2018` VALUES ('110101004012', '花园社区居委会', 'village', '110101004000', '110101004012');
INSERT INTO `aid2018` VALUES ('110101005000', '北新桥街道办事处', 'town', '110101000000', '110101005');
INSERT INTO `aid2018` VALUES ('110101005001', '海运仓社区居委会', 'village', '110101005000', '110101005001');
INSERT INTO `aid2018` VALUES ('110101005002', '北新仓社区居委会', 'village', '110101005000', '110101005002');
INSERT INTO `aid2018` VALUES ('110101005004', '门楼社区居委会', 'village', '110101005000', '110101005004');
INSERT INTO `aid2018` VALUES ('110101005005', '十三条社区居委会', 'village', '110101005000', '110101005005');
INSERT INTO `aid2018` VALUES ('110101005006', '民安社区居委会', 'village', '110101005000', '110101005006');
INSERT INTO `aid2018` VALUES ('110101005008', '九道湾社区居委会', 'village', '110101005000', '110101005008');
INSERT INTO `aid2018` VALUES ('110101005009', '北官厅社区居委会', 'village', '110101005000', '110101005009');
INSERT INTO `aid2018` VALUES ('110101005010', '青龙社区居委会', 'village', '110101005000', '110101005010');
INSERT INTO `aid2018` VALUES ('110101005011', '小菊社区居委会', 'village', '110101005000', '110101005011');
INSERT INTO `aid2018` VALUES ('110101005012', '藏经馆社区居委会', 'village', '110101005000', '110101005012');
INSERT INTO `aid2018` VALUES ('110101005014', '草园社区居委会', 'village', '110101005000', '110101005014');
INSERT INTO `aid2018` VALUES ('110101005016', '前永康社区居委会', 'village', '110101005000', '110101005016');
INSERT INTO `aid2018` VALUES ('110101006000', '东四街道办事处', 'town', '110101000000', '110101006');
INSERT INTO `aid2018` VALUES ('110101006001', '南门仓社区居委会', 'village', '110101006000', '110101006001');
INSERT INTO `aid2018` VALUES ('110101006002', '七条社区居委会', 'village', '110101006000', '110101006002');
INSERT INTO `aid2018` VALUES ('110101006003', '二条社区居委会', 'village', '110101006000', '110101006003');
INSERT INTO `aid2018` VALUES ('110101006006', '六条社区居委会', 'village', '110101006000', '110101006006');
INSERT INTO `aid2018` VALUES ('110101006007', '豆瓣社区居委会', 'village', '110101006000'
