/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 5.7.17
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
create table `admin_divi` (
`level` Decimal (8),
`level_name` varchar (192),
`code` varchar (384),
`name` varchar (384),
`parent_code` varchar (96)
);
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','110000000000','北京市','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','120000000000','天津市','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','130000000000','河北省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','140000000000','山西省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','150000000000','内蒙古自治区','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','210000000000','辽宁省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','220000000000','吉林省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','230000000000','黑龙江省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','310000000000','上海市','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','320000000000','江苏省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','330000000000','浙江省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','340000000000','安徽省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','350000000000','福建省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','360000000000','江西省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','370000000000','山东省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','410000000000','河南省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','420000000000','湖北省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','430000000000','湖南省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','440000000000','广东省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','450000000000','广西壮族自治区','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','460000000000','海南省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','500000000000','重庆市','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','510000000000','四川省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','520000000000','贵州省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','530000000000','云南省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','540000000000','西藏自治区','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','610000000000','陕西省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','620000000000','甘肃省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','630000000000','青海省','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','640000000000','宁夏回族自治区','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('1','省份','650000000000','新疆维吾尔自治区','0');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('2','地市','110100000000','市辖区','110000000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110101000000','东城区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110102000000','西城区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110105000000','朝阳区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110106000000','丰台区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110107000000','石景山区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110108000000','海淀区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110109000000','门头沟区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110111000000','房山区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110112000000','通州区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110113000000','顺义区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110114000000','昌平区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110115000000','大兴区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110116000000','怀柔区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110117000000','平谷区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110118000000','密云区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('3','县市','110119000000','延庆区','110100000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('4','乡镇','110101001000','东华门街道','110101000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('4','乡镇','110101002000','景山街道','110101000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('4','乡镇','110101003000','交道口街道','110101000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('4','乡镇','110101004000','安定门街道','110101000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('4','乡镇','110101005000','北新桥街道','110101000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('4','乡镇','110101006000','东四街道','110101000000');
insert into `admin_divi` (`level`, `level_name`, `code`, `name`, `parent_code`) values('4','乡