think_api_admin_sqlyog.sql

/*
SQLyog Professional v10.42 
MySQL - 8.0.12 : Database - think_api_admin
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`think_api_admin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */;

USE `think_api_admin`;

/*Table structure for table `api_app` */

DROP TABLE IF EXISTS `api_app`;

CREATE TABLE `api_app` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `app_id` varchar(50) NOT NULL DEFAULT '' COMMENT '应用id',
  `app_secret` varchar(50) NOT NULL DEFAULT '' COMMENT '应用密码',
  `app_name` varchar(50) NOT NULL DEFAULT '' COMMENT '应用名称',
  `app_status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '应用状态：0表示禁用，1表示启用',
  `app_info` tinytext NOT NULL COMMENT '应用说明',
  `handler` varchar(32) NOT NULL DEFAULT '10000' COMMENT '操作者id',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `app_api` text COMMENT '当前应用允许请求的全部API接口',
  PRIMARY KEY (`id`),
  UNIQUE KEY `app_id` (`app_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='appId和appSecret表';

/*Data for the table `api_app` */

insert  into `api_app`(`id`,`app_id`,`app_secret`,`app_name`,`app_status`,`app_info`,`handler`,`create_at`,`update_at`,`app_api`) values (1,'69920173','SVRZKjiXaLnaIGaqCqjsCloazWRfOUdl','测试账号',1,'获取api使用的密钥','10000','2018-04-09 23:09:03','2018-04-09 23:09:03',NULL),(2,'72706061','OZswbfqtJHWTSehfGIFSydLzvxhpQWDy','生产账号',0,'应用上线用账号','10000','2018-04-09 23:09:03','2018-04-11 22:47:30',NULL),(3,'48770236','YsOHpGNNdyTirlXBvLsHlIaGHBFLcLzc','Demo',1,'我是呆萌666','10000','2018-04-11 23:19:24','2018-04-11 23:22:30',NULL);

/*Table structure for table `api_document` */

DROP TABLE IF EXISTS `api_document`;

CREATE TABLE `api_document` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(50) NOT NULL DEFAULT '' COMMENT '授权秘钥',
  `endTime` int(11) NOT NULL DEFAULT '0' COMMENT '失效时间戳',
  `times` int(11) NOT NULL DEFAULT '0' COMMENT '访问次数',
  `lastTime` int(11) NOT NULL DEFAULT '0' COMMENT '最后访问时间',
  `lastIp` varchar(50) NOT NULL DEFAULT '' COMMENT '最后访问IP',
  `createTime` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1生效，0失效',
  `handler` varchar(32) NOT NULL DEFAULT '10000' COMMENT '操作者id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='文档访问秘钥';

/*Data for the table `api_document` */

insert  into `api_document`(`id`,`key`,`endTime`,`times`,`lastTime`,`lastIp`,`createTime`,`status`,`handler`) values (1,'120243761017e3fd94f1210564ff6229',1550764800,0,1516512958,'60.176.30.146',1523462676,1,'10000'),(2,'jm12345',1524153600,6,1524016731,'127.0.0.1',1523462659,1,'10000'),(3,'demo666',1525017600,0,0,'',1523461842,1,'10000');

/*Table structure for table `api_fields` */

DROP TABLE IF EXISTS `api_fields`;

CREATE TABLE `api_fields` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fieldName` varchar(50) NOT NULL DEFAULT '' COMMENT '字段名称',
  `hash` varchar(50) NOT NULL DEFAULT '' COMMENT '对应接口的唯一标识',
  `dataType` tinyint(2) NOT NULL DEFAULT '0' COMMENT '数据类型，来源于DataType类库',
  `default` varchar(500) NOT NULL DEFAULT '' COMMENT '默认值',
  `isMust` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否必须 0为不必须，1为必须',
  `range` varchar(500) NOT NULL DEFAULT '' COMMENT '范围，Json字符串，根据数据类型有不一样的含义',
  `info` varchar(500) NOT NULL DEFAULT '' COMMENT '字段说明',
  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '字段用处：0为request，1为response',
  `showName` varchar(50) NOT NULL DEFAULT '' COMMENT 'wiki显示用字段',
  `handler` varchar(32) NOT NULL DEFAULT '10000' COMMENT '操作者id',
  PRIMARY KEY (`id`),
  KEY `hash` (`hash`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='用于保存各个API的请求和返回字段规则';

/*Data for the table `api_fields` */

insert  into `api_fields`(`id`,`fieldName`,`hash`,`dataType`,`default`,`isMust`,`range`,`info`,`type`,`showName`,`handler`) values (1,'timestamp','5a60c77b79875',1,'1514736000',1,'','当前时间戳，精确到秒十位整型数据',0,'timestamp','10000'),(2,'app_id','5a60c77b79875',2,'69920173',1,'','服务器分配的应用ID',0,'app_id','10000'),(3,'rand_str','5a60c77b79875',2,'CJbHN4oIRT2L',1,'','随机字符串，由客户端生成，建议长度为12~16位，只允许大小写字母+数字',0,'rand_str','10000'),(4,'signature','5a60c77b79875',2,'',1,'','客户端根据约定算法计算出的身份标识',0,'signature','10000'),(5,'device_id','5a60c77b79875',1,'668668',1,'','设备ID，必填，没有的可以自己随便写个就可以',0,'device_id','10000'),(6,'data','5a60c77b79875',9,'',1,'','数据对象',1,'data','10000'),(7,'data{}access_token','5a60c77b79875',2,'',1,'','应用身份令牌',1,'data{}access_token','10000'),(8,'data{}expires_in','5a60c77b79875',1,'',1,'','access_token剩余有效期时间，单位秒（S）',1,'data{}expires_in','10000'),(9,'data{}Product','5a570d64428ca',2,'',1,'','产品',1,'data{}Product','10000'),(10,'data{}Version','5a570d64428ca',2,'',1,'','接口版本',1,'data{}Version','10000'),(11,'data{}Company','5a570d64428ca',2,'',1,'','开发团队',1,'data{}Company','10000'),(12,'data{}ToYou','5a570d64428ca',2,'',1,'','欢迎词',1,'data{}ToYou','10000'),(13,'data','5a570d64428ca',9,'',1,'','数据对象',1,'data','10000'),(14,'img','5a64a01c9ed67',2,'',1,'','图片进行base64编码后的字符串',0,'img','10000'),(15,'uptype','5a64a01c9ed67',2,'oss',0,'','uptype 指定上传文件存储方式，可选择( local | qiniu | oss ) 为空跟随总后台设置',0,'uptype','10000'),(16,'data','5a64a01c9ed67',9,'',1,'','返回数据对象',1,'data','10000'),(17,'data{}Url','5a64a01c9ed67',2,'',1,'','图片上传成功后的URL地址',1,'data{}Url','10000'),(18,'file','5a63444c41b45',6,'',1,'','要上传的文件(类型:文本,图片,压缩包等...20M以内)',0,'file','10000'),(19,'data','5a63444c41b45',9,'',1,'','返回data数据对象',1,'data','10000'),(20,'data{}Url','5a63444c41b45',2,'',1,'','文件上传成功后的URL地址',1,'data{}Url','10000'),(21,'file','5acce4ff98111',6,'',1,'','要上传的文件(类型:文本,图片,压缩包等...20M以内)',0,'file','10000'),(22,'data','5acce4ff98111',9,'',1,'','返回数据对象',1,'data','10000'),(23,'info','5acce4ff98111',3,'',1,'','返回结果信息',1,'data{}info','10000'),(24,'data','5acce4ff98111',9,'',1,'','返回data数据对象',1,'data{}info[]','10000'),(25,'data{}info[]{}code','5acce4ff98111',1,'',1,'','状态码',1,'data{}info[]{}code','10000'),(26,'data{}info[]{}url','5acce4ff98111',2,'',1,'','文件上传后url地址',1,'data{}info[]{}url','10000'),(27,'data{}info[]{}file_name','5acce4ff98111',2,'',1,'','源文件名称',1,'data{}info[]{}file_name','10000'),(28,'mobile','5acd9f48bb275',8,'',1,'','正确的手机号',0,'mobile','10000'),(29,'signame','5acd9f48bb275',2,'ThinkApiAdmin',0,'','短信模板签名',0,'signame','10000'),(30,'email','5acdaf03ae160',2,'',1,'','正确的收件人邮件地址',0,'email','10000'),(31,'data','5acd9f48bb275',9,'',1,'','数据对象',1,'data','10000'),(32,'data{}SmsMsg','5acd9f48bb275',2,'',1,'','短信发送成功提示',1,'data{}SmsMsg','10000'),(33,'data','5a6ad33cd8b30',9,'',1,'','返回data数据对象',1,'data','10000'),(34,'data{}Result','5a6ad33cd8b30',3,'',1,'','操作结果说明',1,'data{}Result','10000'),(35,'data{}Result[]','5a6ad33cd8b30',9,'',1,'','操作结果数组',1,'data{}Result[]','10000'),(36,'data{}Result[]{}id','5a6ad33cd8b30',1,'',1,'','省份ID',1,'data{}Result[]{}id','10000'),(37,'data{}Result[]{}parent_id','5a6ad33cd8b30',1,'',1,'','国家ID(pid)',1,'data{}Result[]{}parent_id','10000'),(38,'data{}Result[]{}name','5a6ad33cd8b30',2,'',1,'','省份名称',1,'data{}Result[]{}name','10000'),(39,'data{}Result[]{}type','5a6ad33cd8b30',1,'',1,'','地区类型(1:省份,2:城市,3:县区)',1,'data{}Result[]{}type','10000'),(40,'pid','5a6ad3bc9c27e',1,'',1,'','省份ID',0,'pid','10000'),(41,'data','5a6ad3bc9c27e',9,'',1,'','返回data数据对象',1,'data','10000'),(42,'data{}Result','5a6ad3bc9c27e',3,'',1,'','操作结果说明',1,'data{}Result','10000'),(43,'data{}Result[]','5a6ad3bc9c27e',9,'',1,'','操作结果数组',1,'data{}Result[]','10000'),(44,'data{}Result[]{}id','5a6ad3bc9c27e',1,'',1,'','城市ID',1,'data{}Result[]{}id','10000'),(45,'data{}Result[]{}parent_id','5a6ad3bc9c27e',1,'',1,'','省份ID(pid)',1,'data{}Result[]{}parent_id','10000'),(46,'data{}Result[]{}name','5a6ad3bc9c27e',2,'',1,'','城市名称',1,'data{}Result[]{}name','10000'),(47,'data{}Result[]{}type','5a6ad3bc9c27e',1,'',1,'','地区类型(1:省份,2:城市,3:县区)',1,'data{}Result[]{}type','10000'),(48,'cid','5a6ad401210c7',1,'',1,'','城市ID',0,'cid','10000'),(49,'data','5a6ad401210c7',9,'',1,'','返回data数据对象',1,'data','10000'),(50,'data{}Result','5a6ad401210c7',3,'',1,'','操作结果说明',1,'data{}Result','10000'),(51,'data{}Result[]','5a6ad401210c7',9,'',1,'','操作结果数组',1,'data{}Result[]','10000'),(52,'data{}Result[]{}id','5a6ad401210c7',1,'',1,'','县区ID',1,'data{}Result[]{}id','10000'),(53,'data{}Result[]{}parent_id','5a6ad401210c7',1,'',1,'','城市ID(pid)',1,'data{}Result[]{}parent_id','10000'),(54,'data{}Result[]{}name','5a6ad401210c7',2,'',1,'','县区名称',1,'data{}Result[]{}name','10000'),(55,'data{}Result[]{}type','5a6ad401210c7',1,'',1,'','地区类型(1:省份,2:城市,3:县区)',1,'data{}Result[]{}type','10000'),(56,'hello','5a570d64428ca',2,'',1,'','',0,'hello','10000');

/*Table structure for table `api_group` */

DROP TABLE IF EXISTS `api_group`;

CREATE TABLE `api_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '组名称',
  `img` varchar(255) NOT NULL DEFAULT '' COMMENT '组缩略图',
  `description` varchar(60) NOT NULL COMMENT '组描述',
  `detail` varchar(60) NOT NULL DEFAULT '' COMMENT '组额外细节',
  `hot_num` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '组热度,点击率',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '组状态：为1正常，为0禁用',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除状态(1:删除,0:未删)',
  `handler` varchar(32) NOT NULL DEFAULT '10000' COMMENT '操作者id',
  `sort` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='接口API组';

/*Data for the table `api_group` */

insert  into `api_group`(`id`,`name`,`img`,`description`,`detail`,`hot_num`,`status`,`create_at`,`update_at`,`is_deleted`,`handler`,`sort`) values (1,'公共api组','','公共通用系列api接口','Tools',563,1,'2018-01-17 09:45:07','2018-04-18 11:45:50',0,'10000',2),(2,'Debug分组','','测试,问题接口','待修复接口',12,1,'2018-04-09 16:07:18','2018-04-18 11:02:38',0,'10000',3);

/*Table structure for table `api_list` */

DROP TABLE IF EXISTS `api_list`;

CREATE TABLE `api_list` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `gid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接口组id(可多个)',
  `apiName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'api索引，保存了类和方法',
  `hash` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'api唯一标识',
  `accessToken` tinyint(2) NOT NULL DEFAULT '1' COMMENT '是否需要认证AccessToken 1：需要，0：不需要',
  `needLogin` tinyint(2) NOT NULL DEFAULT '1' COMMENT '是否需要认证用户token  1：需要 0：不需要',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT 'API状态：0表示禁用，1表示启用',
  `method` tinyint(2) NOT NULL DEFAULT '2' COMMENT '请求方式0：不限1：Post，2：Get',
  `info` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'api中文说明',
  `isTest` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否是测试模式：0:生产模式，1：测试模式',
  `returnStr` text COMMENT '返回数据示例',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除状态(1:删除,0:未删)',
  `handler` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '10000' COMMENT '操作者id',
  `sort` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `hash` (`hash`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='接口列表';

/*Data for the table `api_list` */

insert  into `api_list`(`id`,`gid`,`apiName`,`hash`,`accessToken`,`needLogin`,`status`,`method`,`info`,`isTest`,`returnStr`,`create_at`,`update_at`,`is_deleted`,`handler`,`sort`) values (1,'1,2','Index/index','5a570d64428ca',1,0,1,2,'欢迎使用ThinkApiAdmin v4.0',1,'{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Product\":\"ThinkApiAdmin\",\"Version\":\"v4.0\",\"Company\":\"ThinkApiAdmin \\u00a9 2018\",\"ToYou\":\"I\\\'m glad to meet you\\uff08\\u7ec8\\u4e8e\\u7b49\\u5230\\u4f60\\uff01\\uff09\"},\"debug\":[{\"ThinkPHPVersion\":\"5.0.17\",\"PHPVersion\":\"7.2.0\"}]}','2018-01-16 23:27:11','2018-04-18 10:55:55',0,'10000',1),(2,'1','Buildtoken/getAccessToken','5a60c77b79875',1,0,1,1,'获取AccessToken',1,'{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"access_token\":\"00051a2e44df61d69ae1421a5f489885\",\"expires_in\":7200}}','2018-01-16 23:27:11','2018-04-11 14:44:49',0,'10000',2),(3,'1','Tool/uploadImage','5a64a01c9ed67',1,1,1,1,'图片上传接口(单文件,支持云存储)base64加密传输',1,'{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Url\":\"http:\\/\\/asscdn.zwt520.com\\/1xdig8j7tw4zr1on\\/5a656240eb1f5.png\"}}','2018-01-21 22:14:58','2018-04-09 16:49:27',0,'10000',3),(4,'1','Tool/uploadFile','5a63444c41b45',1,1,1,1,'文件上传接口(单文件,云存储)模拟HTTP的Post请求方式',1,'{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Url\":\"https:\\/\\/www.zwt520.com\\/jmnp\\/static\\/upload\\/1xdig8j7tw4zr1on\\/5a64a1b28aeb7.png\"}}','2018-01-20 21:33:59','2018-04-09 17:27:40',0,'10000',4),(6,'1','Tool/uploadFiles','5acce4ff98111',1,1,1,1,'文件上传接口(支持多文件文件,本地存储)模拟HTTP的Post请求方式',1,'{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"info\":[{\"code\":1,\"url\":\"https:\\/\\/zhushixtb.oss-cn-hangzhou.aliyuncs.com\\/1\\/5acce1ea9d34c.jpg\",\"file_name\":\"27.jpg\"},{\"code\":1,\"url\":\"https:\\/\\/zhushixtb.oss-cn-hangzhou.aliyuncs.com\\/1\\/5acce1eae18dc.jpg\",\"file_name\":\"28.jpg\"}]},\"debug\":[{\"Time\":\"2018-04-11 00:10:19\"}]}','2018-04-11 00:24:05','2018-04-11 14:45:07',0,'10000',5),(7,'1','Tool/getVcodeByMobile','5acd9f48bb275',1,0,1,2,'根据手机号获取验证码 (短信签名)',1,NULL,'2018-04-11 14:44:27','2018-04-11 14:47:01',0,'10000',6),(8,'1','Tool/getVcodeByEmail','5acdaf03ae160',1,0,1,2,'根据Email获取验证码',1,NULL,'2018-04-11 14:46:11','2018-04-11 14:47:05',0,'10000',7),(9,'1','Tool/getProvinceList','5a6ad33cd8b30',1,0,1,2,'获取省份名称和ID',1,'{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Result\":[{\"id\":2,\"parent_id\":1,\"name\":\"\\u5317\\u4eac\",\"type\":1},{\"id\":3,\"parent_id\":1,\"name\":\"\\u5929\\u6d25\",\"type\":1},{\"id\":4,\"parent_id\":1,\"name\":\"\\u6cb3\\u5317\\u7701\",\"type\":1},{\"id\":5,\"parent_id\":1,\"name\":\"\\u5c71\\u897f\\u7701\",\"type\":1},{\"\\u7701\\u7565\":\"...\"}]}}','2018-01-26 15:07:02','2018-04-11 16:26:12',0,'10000',8),(10,'1','Tool/getCityListByPid','5a6ad3bc9c27e',1,0,1,2,'获取城市名称和ID通过省份ID',1,'{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Result\":[{\"id\":123,\"parent_id\":12,\"name\":\"\\u676d\\u5dde\\u5e02\",\"type\":2},{\"id\":124,\"parent_id\":12,\"name\":\"\\u5b81\\u6ce2\\u5e02\",\"type\":2},{\"id\":125,\"parent_id\":12,\"name\":\"\\u6e29\\u5dde\\u5e02\",\"type\":2},{\"\\u7701\\u7565\":\"...\"}]}}','2018-01-26 15:08:47','2018-01-26 15:08:47',0,'10000',9),(11,'1','Tool/getDistrictListByCid','5a6ad401210c7',1,0,1,2,'获取县区名称和ID通过城市ID',1,'{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Result\":[{\"id\":1362,\"parent_id\":123,\"name\":\"\\u4e0a\\u57ce\\u533a\",\"type\":3},{\"id\":1363,\"parent_id\":123,\"name\":\"\\u4e0b\\u57ce\\u533a\",\"type\":3},{\"id\":1364,\"parent_id\":123,\"name\":\"\\u6c5f\\u5e72\\u533a\",\"type\":3},{\"\\u7701\\u7565\":\"...\"}]}}','2018-01-26 15:09:40','2018-01-26 15:09:40',0,'10000',10);

/*Table structure for table `data_region` */

DROP TABLE IF EXISTS `data_region`;

CREATE TABLE `data_region` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '上级id',
  `name` varchar(120) NOT NULL DEFAULT '' COMMENT '地区名称',
  `type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '地区类型',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `region_type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=4044 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='基础数据-地区表';

/*Data for the table `data_region` */

insert  into `data_region`(`id`,`parent_id`,`name`,`type`) values (1,0,'中国',0),(2,1,'北京',1),(3,1,'天津',1),(4,1,'河北省',1),(5,1,'山西省',1),(6,1,'内蒙古自治区',1),(7,1,'辽宁省',1),(8,1,'吉林省',1),(9,1,'黑龙江省',1),(10,1,'上海',1),(11,1,'江苏省',1),(12,1,'浙江省',1),(13,1,'安徽省',1),(14,1,'福建省',1),(15,1,'江西省',1),(16,1,'山东省',1),(17,1,'河南省',1),(18,1,'湖北省',1),(19,1,'湖南省',1),(20,1,'广东省',1),(21,1,'广西壮族自治区',1),(22,1,'海南省',1),(23,1,'重庆',1),(24,1,'四川省',1),(25,1,'贵州省',1),(26,1,'云南省',1),(27,1,'西藏自治区',1),(28,1,'陕西省',1),(29,1,'甘肃省',1),(30,1,'青海省',1),(31,1,'宁夏回族自治区',1),(32,1,'新疆维吾尔自治区',1),(33,1,'台湾',1),(34,1,'香港特别行政区',1),(35,1,'澳门特别行政区',1),(36,1,'海外',1),(37,2,'北京市',2),(38,3,'天津市',2),(39,4,'石家庄市',2),(40,4,'唐山市',2),(41,4,'秦皇岛市',2),(42,4,'邯郸市',2),(43,4,'邢台市',2),(44,4,'保定市',2),(45,4,'张家口市',2),(46,4,'承德市',2),(47,4,'沧州市',2),(48,4,'廊坊市',2),(49,4,'衡水市',2),(50,5,'太原市',2),(51,5,'大同市',2),(52,5,'阳泉市',2),(53,5,'长治市',2),(54,5,'晋城市',2),(55,5,'朔州市',2),(56,5,'晋中市',2),(57,5,'运城市',2),(58,5,'忻州市',2),(59,5,'临汾市',2),(60,5,'吕梁市',2),(61,6,'呼和浩特市',2),(62,6,'包头市',2),(63,6,'乌海市',2),(64,6,'赤峰市',2),(65,6,'通辽市',2),(66,6,'鄂尔多斯市',2),(67,6,'呼伦贝尔市',2),(68,6,'巴彦淖尔市',2),(69,6,'乌兰察布市',2),(70,6,'兴安盟',2),(71,6,'锡林郭勒盟',2),(72,6,'阿拉善盟',2),(73,7,'沈阳市',2),(74,7,'大连市',2),(75,7,'鞍山市',2),(76,7,'抚顺市',2),(77,7,'本溪市',2),(78,7,'丹东市',2),(79,7,'锦州市',2),(80,7,'营口市',2),(81,7,'阜新市',2),(82,7,'辽阳市',2),(83,7,'盘锦市',2),(84,7,'铁岭市',2),(85,7,'朝阳市',2),(86,7,'葫芦岛市',2),(87,8,'长春市',2),(88,8,'吉林市',2),(89,8,'四平市',2),(90,8,'辽源市',2),(91,8,'通化市',2),(92,8,'白山市',2),(93,8,'松原市',2),(94,8,'白城市',2),(95,8,'延边朝鲜族自治州',2),(96,9,'哈尔滨市',2),(97,9,'齐齐哈尔市',2),(98,9,'鸡西市',2),(99,9,'鹤岗市',2),(100,9,'双鸭山市',2),(101,9,'大庆市',2),(102,9,'伊春市',2),(103,9,'佳木斯市',2),(104,9,'七台河市',2),(105,9,'牡丹江市',2),(106,9,'黑河市',2),(107,9,'绥化市',2),(108,9,'大兴安岭地区',2),(109,10,'上海市',2),(110,11,'南京市',2),(111,11,'无锡市',2),(112,11,'徐州市',2),(113,11,'常州市',2),(114,11,'苏州市',2),(115,11,'南通市',2),(116,11,'连云港市',2),(117,11,'淮安市',2),(118,11,'盐城市',2),(119,11,'扬州市',2),(120,11,'镇江市',2),(121,11,'泰州市',2),(122,11,'宿迁市',2),(123,12,'杭州市',2),(124,12,'宁波市',2),(125,12,'温州市',2),(126,12,'嘉兴市',2),(127,12,'湖州市',2),(128,12,'绍兴市',2),(129,12,'金华市',2),(130,12,'衢州市',2),(131,12,'舟山市',2),(132,12,'台州市',2),(133,12,'丽水市',2),(134,13,'合肥市',2),(135,13,'芜湖市',2),(136,13,'蚌埠市',2),(137,13,'淮南市',2),(138,13,'马鞍山市',2),(139,13,'淮北市',2),(140,13,'铜陵市',2),(141,13,'安庆市',2),(142,13,'黄山市',2),(143,13,'滁州市',2),(144,13,'阜阳市',2),(145,13,'宿州市',2),(146,13,'六安市',2),(147,13,'亳州市',2),(148,13,'池州市',2),(149,13,'宣城市',2),(150,14,'福州市',2),(151,14,'厦门市',2),(152,14,'莆田市',2),(153,14,'三明市',2),(154,14,'泉州市',2),(155,14,'漳州市',2),(156,14,'南平市',2),(157,14,'龙岩市',2),(158,14,'宁德市',2),(159,15,'南昌市',2),(160,15,'景德镇市',2),(161,15,'萍乡市',2),(162,15,'九江市',2),(163,15,'新余市',2),(164,15,'鹰潭市',2),(165,15,'赣州市',2),(166,15,'吉安市',2),(167,15,'宜春市',2),(168,15,'抚州市',2),(169,15,'上饶市',2),(170,16,'济南市',2),(171,16,'青岛市',2),(172,16,'淄博市',2),(173,16,'枣庄市',2),(174,16,'东营市',2),(175,16,'烟台市',2),(176,16,'潍坊市',2),(177,16,'济宁市',2),(178,16,'泰安市',2),(179,16,'威海市',2),(180,16,'日照市',2),(181,16,'莱芜市',2),(182,16,'临沂市',2),(183,16,'德州市',2),(184,16,'聊城市',2),(185,16,'滨州市',2),(186,16,'菏泽市',2),(187,17,'郑州市',2),(188,17,'开封市',2),(189,17,'洛阳市',2),(190,17,'平顶山市',2),(191,17,'安阳市',2),(192,17,'鹤壁市',2),(193,17,'新乡市',2),(194,17,'焦作市',2),(195,17,'濮阳市',2),(196,17,'许昌市',2),(197,17,'漯河市',2),(198,17,'三门峡市',2),(199,17,'南阳市',2),(200,17,'商丘市',2),(201,17,'信阳市',2),(202,17,'周口市',2),(203,17,'驻马店市',2),(204,18,'武汉市',2),(205,18,'黄石市',2),(206,18,'十堰市',2),(207,18,'宜昌市',2),(208,18,'襄阳市',2),(209,18,'鄂州市',2),(210,18,'荆门市',2),(211,18,'孝感市',2),(212,18,'荆州市',2),(213,18,'黄冈市',2),(214,18,'咸宁市',2),(215,18,'随州市',2),(216,18,'恩施土家族苗族自治州',2),(217,19,'长沙市',2),(218,19,'株洲市',2),(219,19,'湘潭市',2),(220,19,'衡阳市',2),(221,19,'邵阳市',2),(222,19,'岳阳市',2),(223,19,'常德市',2),(224,19,'张家界市',2),(225,19,'益阳市',2),(226,19,'郴州市',2),(227,19,'永州市',2),(228,19,'怀化市',2),(229,19,'娄底市',2),(230,19,'湘西土家族苗族自治州',2),(231,20,'广州市',2),(232,20,'韶关市',2),(233,20,'深圳市',2),(234,20,'珠海市',2),(235,20,'汕头市',2),(236,20,'佛山市',2),(237,20,'江门市',2),(238,20,'湛江市',2),(239,20,'茂名市',2),(240,20,'肇庆市',2),(241,20,'惠州市',2),(242,20,'梅州市',2),(243,20,'汕尾市',2),(244,20,'河源市',2),(245,20,'阳江市',2),(246,20,'清远市',2),(247,20,'东莞市',2),(248,20,'中山市',2),(249,20,'东沙群岛',2),(250,20,'潮州市',2),(251,20,'揭阳市',2),(252,20,'云浮市',2),(253,21,'南宁市',2),(254,21,'柳州市',2),(255,21,'桂林市',2),(256,21,'梧州市',2),(257,21,'北海市',2),(258,21,'防城港市',2),(259,21,'钦州市',2),(260,21,'贵港市',2),(261,21,'玉林市',2),(262,21,'百色市',2),(263,21,'贺州市',2),(264,21,'河池市',2),(265,21,'来宾市',2),(266,21,'崇左市',2),(267,22,'海口市',2),(268,22,'三亚市',2),(269,22,'三沙市',2),(270,23,'重庆市',2),(271,24,'成都市',2),(272,24,'自贡市',2),(273,24,'攀枝花市',2),(274,24,'泸州市',2),(275,24,'德阳市',2),(276,24,'绵阳市',2),(277,24,'广元市',2),(278,24,'遂宁市',2),(279,24,'内江市',2),(280,24,'乐山市',2),(281,24,'南充市',2),(282,24,'眉山市',2),(283,24,'宜宾市',2),(284,24,'广安市',2),(285,24,'达州市',2),(286,24,'雅安市',2),(287,24,'巴中市',2),(288,24,'资阳市',2),(289,24,'阿坝藏族羌族自治州',2),(290,24,'甘孜藏族自治州',2),(291,24,'凉山彝族自治州',2),(292,25,'贵阳市',2),(293,25,'六盘水市',2),(294,25,'遵义市',2),(295,25,'安顺市',2),(296,25,'铜仁市',2),(297,25,'黔西南布依族苗族自治州',2),(298,25,'毕节市',2),(299,25,'黔东南苗族侗族自治州',2),(300,25,'黔南布依族苗族自治州',2),(301,26,'昆明市',2),(302,26,'曲靖市',2),(303,26,'玉溪市',2),(304,26,'保山市',2),(305,26,'昭通市',2),(306,26,'丽江市',2),(307,26,'普洱市',2),(308,26,'临沧市',2),(309,26,'楚雄彝族自治州',2),(310,26,'红河哈尼族彝族自治州',2),(311,26,'文山壮族苗族自治州',2),(312,26,'西双版纳傣族自治州',2),(313,26,'大理白族自治州',2),(314,26,'德宏傣族景颇族自治州',2),(315,26,'怒江傈僳族自治州',2),(316,26,'迪庆藏族自治州',2),(317,27,'拉萨市',2),(318,27,'昌都市',2),(319,27,'山南地区',2),(320,27,'日喀则市',2),(321,27,'那曲地区',2),(322,27,'阿里地区',2),(323,27,'林芝市',2),(324,28,'西安市',2),(325,28,'铜川市',2),(326,28,'宝鸡市',2),(327,28,'咸阳市',2),(328,28,'渭南市',2),(329,28,'延安市',2),(330,28,'汉中市',2),(331,28,'榆林市',2),(332,28,'安康市',2),(333,28,'商洛市',2),(334,29,'兰州市',2),(335,29,'嘉峪关市',2),(336,29,'金昌市',2),(337,29,'白银市',2),(338,29,'天水市',2),(339,29,'武威市',2),(340,29,'张掖市',2),(341,29,'平凉市',2),(342,29,'酒泉市',2),(343,29,'庆阳市',2),(344,29,'定西市',2),(345,29,'陇南市',2),(346,29,'临夏回族自治州',2),(347,29,'甘南藏族自治州',2),(348,30,'西宁市',2),(349,30,'海东市',2),(350,30,'海北藏族自治州',2),(351,30,'黄南藏族自治州',2),(352,30,'海南藏族自治州',2),(353,30,'果洛藏族自治州',2),(354,30,'玉树藏族自治州',2),(355,30,'海西蒙古族藏族自治州',2),(356,31,'银川市',2),(357,31,'石嘴山市',2),(358,31,'吴忠市',2),(359,31,'固原市',2),(360,31,'中卫市',2),(361,32,'乌鲁木齐市',2),(362,32,'克拉玛依市',2),(363,32,'吐鲁番市',2),(364,32,'哈密地区',2),(365,32,'昌吉回族自治州',2),(366,32,'博尔塔拉蒙古自治州',2),(367,32,'巴音郭楞蒙古自治州',2),(368,32,'阿克苏地区',2),(369,32,'克孜勒苏柯尔克孜自治州',2),(370,32,'喀什地区',2),(371,32,'和田地区',2),(372,32,'伊犁哈萨克自治州',2),(373,32,'塔城地区',2),(374,32,'阿勒泰地区',2),(375,33,'台北市',2),(376,33,'高雄市',2),(377,33,'台南市',2),(378,33,'台中市',2),(379,33,'金门县',2),(380,33,'南投县',2),(381,33,'基隆市',2),(382,33,'新竹市',2),(383,33,'嘉义市',2),(384,33,'新北市',2),(385,33,'宜兰县',2),(386,33,'新竹县',2),(387,33,'桃园县',2),(388,33,'苗栗县',2),(389,33,'彰化县',2),(390,33,'嘉义县',2),(391,33,'云林县',2),(392,33,'屏东县',2),(393,33,'台东县',2),(394,33,'花莲县',2),(395,33,'澎湖县',2),(396,33,'连江县',2),(397,34,'香港岛',2),(398,34,'九龙',2),(399,34,'新界',2),(400,35,'澳门半岛',2),(401,35,'离岛',2),(402,36,'海外',2),(403,37,'东城区',3),(404,37,'西城区',3),(405,37,'崇文区',3),(406,37,'宣武区',3),(407,37,'朝阳区',3),(408,37,'丰台区',3),(409,37,'石景山区',3),(410,37,'海淀区',3),(411,37,'门头沟区',3),(412,37,'房山区',3),(413,37,'通州区',3),(414,37,'顺义区',3),(415,37,'昌平区',3),(416,37,'大兴区',3),(417,37,'怀柔区',3),(418,37,'平谷区',3),(419,37,'密云县',3),(420,37,'延庆县',3),(421,37,'其它区',3),(422,38,'和平区',3),(423,38,'河东区',3),(424,38,'河西区',3),(425,38,'南开区',3),(426,38,'河北区',3),(427,38,'红桥区',3),(428,38,'塘沽区',3),(429,38,'汉沽区',3),(430,38,'大港区',3),(431,38,'东丽区',3),(432,38,'西青区',3),(433,38,'津南区',3),(434,38,'北辰区',3),(435,38,'武清区',3),(436,38,'宝坻区',3),(437,38,'滨海新区',3),(438,38,'宁河县',3),(439,38,'静海县',3),(440,38,'蓟县',3),(441,38,'其它区',3),(442,39,'长安区',3),(443,39,'桥东区',3),(444,39,'桥西区',3),(445,39,'新华区',3),(446,39,'井陉矿区',3),(447,39,'裕华区',3),(448,39,'井陉县',3),(449,39,'正定县',3),(450,39,'栾城区',3),(451,39,'行唐县',3),(452,39,'灵寿县',3),(453,39,'高邑县',3),(454,39,'深泽县',3),(455,39,'赞皇县',3),(456,39,'无极县',3),(457,39,'平山县',3),(458,39,'元氏县',3),(459,39,'赵县',3),(460,39,'辛集市',3),(461,39,'藁城区',3),(462,39,'晋州市',3),(463,39,'新乐市',3),(464,39,'鹿泉区',3),(465,39,'其它区',3),(466,40,'路南区',3),(467,40,'路北区',3),(468,40,'古冶区',3),(469,40,'开平区',3),(470,40,'丰南区',3),(471,40,'丰润区',3),(472,40,'滦县',3),(473,40,'滦南县',3),(474,40,'乐亭县',3),(475,40,'迁西县',3),(476,40,'玉田县',3),(477,40,'曹妃甸区',3),(478,40,'遵化市',3),(479,40,'迁安市',3),(480,40,'其它区',3),(481,41,'海港区',3),(482,41,'山海关区',3),(483,41,'北戴河区',3),(484,41,'青龙满族自治县',3),(485,41,'昌黎县',3),(486,41,'抚宁县',3),(487,41,'卢龙县',3),(488,41,'其它区',3),(489,41,'经济技术开发区',3),(490,42,'邯山区',3),(491,42,'丛台区',3),(492,42,'复兴区',3),(493,42,'峰峰矿区',3),(494,42,'邯郸县',3),(495,42,'临漳县',3),(496,42,'成安县',3),(497,42,'大名县',3),(498,42,'涉县',3),(499,42,'磁县',3),(500,42,'肥乡县',3),(501,42,'永年县',3),(502,42,'邱县',3),(503,42,'鸡泽县',3),(504,42,'广平县',3),(505,42,'馆陶县',3),(506,42,'魏县',3),(507,42,'曲周县',3),(508,42,'武安市',3),(509,42,'其它区',3),(510,43,'桥东区',3),(511,43,'桥西区',3),(512,43,'邢台县',3),(513,43,'临城县',3),(514,43,'内丘县',3),(515,43,'柏乡县',3),(516,43,'隆尧县',3),(517,43,'任县',3),(518,43,'南和县',3),(519,43,'宁晋县',3),(520,43,'巨鹿县',3),(521,43,'新河县',3),(522,43,'广宗县',3),(523,43,'平乡县',3),(524,43,'威县',3),(525,43,'清河县',3),(526,43,'临西县',3),(527,43,'南宫市',3),(528,43,'沙河市',3),(529,43,'其它区',3),(530,44,'新市区',3),(531,44,'北市区',3),(532,44,'南市区',3),(533,44,'满城县',3),(534,44,'清苑县',3),(535,44,'涞水县',3),(536,44,'阜平县',3),(537,44,'徐水县',3),(538,44,'定兴县',3),(539,44,'唐县',3),(540,44,'高阳县',3),(541,44,'容城县',3),(542,44,'涞源县',3),(543,44,'望都县',3),(544,44,'安新县',3),(545,44,'易县',3),(546,44,'曲阳县',3),(547,44,'蠡县',3),(548,44,'顺平县',3),(549,44,'博野县',3),(550,44,'雄县',3),(551,44,'涿州市',3),(552,44,'定州市',3),(553,44,'安国市',3),(554,44,'高碑店市',3),(555,44,'高开区',3),(556,44,'其它区',3),(557,45,'桥东区',3),(558,45,'桥西区',3),(559,45,'宣化区',3),(560,45,'下花园区',3),(561,45,'宣化县',3),(562,45,'张北县',3),(563,45,'康保县',3),(564,45,'沽源县',3),(565,45,'尚义县',3),(566,45,'蔚县',3),(567,45,'阳原县',3),(568,45,'怀安县',3),(569,45,'万全县',3),(570,45,'怀来县',3),(571,45,'涿鹿县',3),(572,45,'赤城县',3),(573,45,'崇礼县',3),(574,45,'其它区',3),(575,46,'双桥区',3),(576,46,'双滦区',3),(577,46,'鹰手营子矿区',3),(578,46,'承德县',3),(579,46,'兴隆县',3),(580,46,'平泉县',3),(581,46,'滦平县',3),(582,46,'隆化县',3),(583,46,'丰宁满族自治县',3),(584,46,'宽城满族自治县',3),(585,46,'围场满族蒙古族自治县',3),(586,46,'其它区',3),(587,47,'新华区',3),(588,47,'运河区',3),(589,47,'沧县',3),(590,47,'青县',3),(591,47,'东光县',3),(592,47,'海兴县',3),(593,47,'盐山县',3),(594,47,'肃宁县',3),(595,47,'南皮县',3),(596,47,'吴桥县',3),(597,47,'献县',3),(598,47,'孟村回族自治县',3),(599,47,'泊头市',3),(600,47,'任丘市',3),(601,47,'黄骅市',3),(602,47,'河间市',3),(603,47,'其它区',3),(604,48,'安次区',3),(605,48,'广阳区',3),(606,48,'固安县',3),(607,48,'永清县',3),(608,48,'香河县',3),(609,48,'大城县',3),(610,48,'文安县',3),(611,48,'大厂回族自治县',3),(612,48,'开发区',3),(613,48,'燕郊经济技术开发区',3),(614,48,'霸州市',3),(615,48,'三河市',3),(616,48,'其它区',3),(617,49,'桃城区',3),(618,49,'枣强县',3),(619,49,'武邑县',3),(620,49,'武强县',3),(621,49,'饶阳县',3),(622,49,'安平县',3),(623,49,'故城县',3),(624,49,'景县',3),(625,49,'阜城县',3),(626,49,'冀州市',3),(627,49,'深州市',3),(628,49,'其它区',3),(629,50,'小店区',3),(630,50,'迎泽区',3),(631,50,'杏花岭区',3),(632,50,'尖草坪区',3),(633,50,'万柏林区',3),(634,50,'晋源区',3),(635,50,'清徐县',3),(636,50,'阳曲县',3),(637,50,'娄烦县',3),(638,50,'古交市',3),(639,50,'其它区',3),(640,51,'城区',3),(641,51,'矿区',3),(642,51,'南郊区',3),(643,51,'新荣区',3),(644,51,'阳高县',3),(645,51,'天镇县',3),(646,51,'广灵县',3),(647,51,'灵丘县',3),(648,51,'浑源县',3),(649,51,'左云县',3),(650,51,'大同县',3),(651,51,'其它区',3),(652,52,'城区',3),(653,52,'矿区',3),(654,52,'郊区',3),(655,52,'平定县',3),(656,52,'盂县',3),(657,52,'其它区',3),(658,53,'长治县',3),(659,53,'襄垣县',3),(660,53,'屯留县',3),(661,53,'平顺县',3),(662,53,'黎城县',3),(663,53,'壶关县',3),(664,53,'长子县',3),(665,53,'武乡县',3),(666,53,'沁县',3),(667,53,'沁源县',3),(668,53,'潞城市',3),(669,53,'城区',3),(670,53,'郊区',3),(671,53,'高新区',3),(672,53,'其它区',3),(673,54,'城区',3),(674,54,'沁水县',3),(675,54,'阳城县',3),(676,54,'陵川县',3),(677,54,'泽州县',3),(678,54,'高平市',3),(679,54,'其它区',3),(680,55,'朔城区',3),(681,55,'平鲁区',3),(682,55,'山阴县',3),(683,55,'应县',3),(684,55,'右玉县',3),(685,55,'怀仁县',3),(686,55,'其它区',3),(687,56,'榆次区',3),(688,56,'榆社县',3),(689,56,'左权县',3),(690,56,'和顺县',3),(691,56,'昔阳县',3),(692,56,'寿阳县',3),(693,56,'太谷县',3),(694,56,'祁县',3),(695,56,'平遥县',3),(696,56,'灵石县',3),(697,56,'介休市',3),(698,56,'其它区',3),(699,57,'盐湖区',3),(700,57,'临猗县',3),(701,57,'万荣县',3),(702,57,'闻喜县',3),(703,57,'稷山县',3),(704,57,'新绛县',3),(705,57,'绛县',3),(706,57,'垣曲县',3),(707,57,'夏县',3),(708,57,'平陆县',3),(709,57,'芮城县',3),(710,57,'永济市',3),(711,57,'河津市',3),(712,57,'其它区',3),(713,58,'忻府区',3),(714,58,'定襄县',3),(715,58,'五台县',3),(716,58,'代县',3),(717,58,'繁峙县',3),(718,58,'宁武县',3),(719,58,'静乐县',3),(720,58,'神池县',3),(721,58,'五寨县',3),(722,58,'岢岚县',3),(723,58,'河曲县',3),(724,58,'保德县',3),(725,58,'偏关县',3),(726,58,'原平市',3),(727,58,'其它区',3),(728,59,'尧都区',3),(729,59,'曲沃县',3),(730,59,'翼城县',3),(731,59,'襄汾县',3),(732,59,'洪洞县',3),(733,59,'古县',3),(734,59,'安泽县',3),(735,59,'浮山县',3),(736,59,'吉县',3),(737,59,'乡宁县',3),(738,59,'大宁县',3),(739,59,'隰县',3),(740,59,'永和县',3),(741,59,'蒲县',3),(742,59,'汾西县',3),(743,59,'侯马市',3),(744,59,'霍州市',3),(745,59,'其它区',3),(746,60,'离石区',3),(747,60,'文水县',3),(748,60,'交城县',3),(749,60,'兴县',3),(750,60,'临县',3),(751,60,'柳林县',3),(752,60,'石楼县',3),(753,60,'岚县',3),(754,60,'方山县',3),(755,60,'中阳县',3),(756,60,'交口县',3),(757,60,'孝义市',3),(758,60,'汾阳市',3),(759,60,'其它区',3),(760,61,'新城区',3),(761,61,'回民区',3),(762,61,'玉泉区',3),(763,61,'赛罕区',3),(764,61,'土默特左旗',3),(765,61,'托克托县',3),(766,61,'和林格尔县',3),(767,61,'清水河县',3),(768,61,'武川县',3),(769,61,'其它区',3),(770,62,'东河区',3),(771,62,'昆都仑区',3),(772,62,'青山区',3),(773,62,'石拐区',3),(774,62,'白云鄂博矿区',3),(775,62,'九原区',3),(776,62,'土默特右旗',3),(777,62,'固阳县',3),(778,62,'达尔罕茂明安联合旗',3),(779,62,'其它区',3),(780,63,'海勃湾区',3),(781,63,'海南区',3),(782,63,'乌达区',3),(783,63,'其它区',3),(784,64,'红山区',3),(785,64,'元宝山区',3),(786,64,'松山区',3),(787,64,'阿鲁科尔沁旗',3),(788,64,'巴林左旗',3),(789,64,'巴林右旗',3),(790,64,'林西县',3),(791,64,'克什克腾旗',3),(792,64,'翁牛特旗',3),(793,64,'喀喇沁旗',3),(794,64,'宁城县',3),(795,64,'敖汉旗',3),(796,64,'其它区',3),(797,65,'科尔沁区',3),(798,65,'科尔沁左翼中旗',3),(799,65,'科尔沁左翼后旗',3),(800,65,'开鲁县',3),(801,65,'库伦旗',3),(802,65,'奈曼旗',3),(803,65,'扎鲁特旗',3),(804,65,'霍林郭勒市',3),(805,65,'其它区',3),(806,66,'东胜区',3),(807,66,'达拉特旗',3),(808,66,'准格尔旗',3),(809,66,'鄂托克前旗',3),(810,66,'鄂托克旗',3),(811,66,'杭锦旗',3),(812,66,'乌审旗',3),(813,66,'伊金霍洛旗',3),(814,66,'其它区',3),(815,67,'海拉尔区',3),(816,67,'扎赉诺尔区',3),(817,67,'阿荣旗',3),(818,67,'莫力达瓦达斡尔族自治旗',3),(819,67,'鄂伦春自治旗',3),(820,67,'鄂温克族自治旗',3),(821,67,'陈巴尔虎旗',3),(822,67,'新巴尔虎左旗',3),(823,67,'新巴尔虎右旗',3),(824,67,'满洲里市',3),(825,67,'牙克石市',3),(826,67,'扎兰屯市',3),(827,67,'额尔古纳市',3),(828,67,'根河市',3),(829,67,'其它区',3),(830,68,'临河区',3),(831,68,'五原县',3),(832,68,'磴口县',3),(833,68,'乌拉特前旗',3),(834,68,'乌拉特中旗',3),(835,68,'乌拉特后旗',3),(836,68,'杭锦后旗',3),(837,68,'其它区',3),(838,69,'集宁区',3),(839,69,'卓资县',3),(840,69,'化德县',3),(841,69,'商都县',3),(842,69,'兴和县',3),(843,69,'凉城县',3),(844,69,'察哈尔右翼前旗',3),(845,69,'察哈尔右翼中旗',3),(846,69,'察哈尔右翼后旗',3),(847,69,'四子王旗',3),(848,69,'丰镇市',3),(849,69,'其它区',3),(850,70,'乌兰浩特市',3),(851,70,'阿尔山市',3),(852,70,'科尔沁右翼前旗',3),(853,70,'科尔沁右翼中旗',3),(854,70,'扎赉特旗',3),(855,70,'突泉县',3),(856,70,'其它区',3),(857,71,'二连浩特市',3),(858,71,'锡林浩特市',3),(859,71,'阿巴嘎旗',3),(860,71,'苏尼特左旗',3),(861,71,'苏尼特右旗',3),(862,71,'东乌珠穆沁旗',3),(863,71,'西乌珠穆沁旗',3),(864,71,'太仆寺旗',3),(865,71,'镶黄旗',3),(866,71,'正镶白旗',3),(867,71,'正蓝旗',3),(868,71,'多伦县',3),(869,71,'其它区',3),(870,72,'阿拉善左旗',3),(871,72,'阿拉善右旗',3),(872,72,'额济纳旗',3),(873,72,'其它区',3),(874,73,'和平区',3),(875,73,'沈河区',3),(876,73,'大东区',3),(877,73,'皇姑区',3),(878,73,'铁西区',3),(879,73,'苏家屯区',3),(880,73,'浑南区',3),(881,73,'新城子区',3),(882,73,'于洪区',3),(883,73,'辽中县',3),(884,73,'康平县',3),(885,73,'法库县',3),(886,73,'新民市',3),(887,73,'浑南新区',3),(888,73,'张士开发区',3),(889,73,'沈北新区',3),(890,73,'其它区',3),(891,74,'中山区',3),(892,74,'西岗区',3),(893,74,'沙河口区',3),(894,74,'甘井子区',3),(895,74,'旅顺口区',3),(896,74,'金州区',3),(897,74,'长海县',3),(898,74,'开发区',3),(899,74,'瓦房店市',3),(900,74,'普兰店市',3),(901,74,'庄河市',3),(902,74,'岭前区',3),(903,74,'其它区',3),(904,75,'铁东区',3),(905,75,'铁西区',3),(906,75,'立山区',3),(907,75,'千山区',3),(908,75,'台安县',3),(909,75,'岫岩满族自治县',3),(910,75,'高新区',3),(911,75,'海城市',3),(912,75,'其它区',3),(913,76,'新抚区',3),(914,76,'东洲区',3),(915,76,'望花区',3),(916,76,'顺城区',3),(917,76,'抚顺县',3),(918,76,'新宾满族自治县',3),(919,76,'清原满族自治县',3),(920,76,'其它区',3),(921,77,'平山区',3),(922,77,'溪湖区',3),(923,77,'明山区',3),(924,77,'南芬区',3),(925,77,'本溪满族自治县',3),(926,77,'桓仁满族自治县',3),(927,77,'其它区',3),(928,78,'元宝区',3),(929,78,'振兴区',3),(930,78,'振安区',3),(931,78,'宽甸满族自治县',3),(932,78,'东港市',3),(933,78,'凤城市',3),(934,78,'其它区',3),(935,79,'古塔区',3),(936,79,'凌河区',3),(937,79,'太和区',3),(938,79,'黑山县',3),(939,79,'义县',3),(940,79,'凌海市',3),(941,79,'北镇市',3),(942,79,'其它区',3),(943,80,'站前区',3),(944,80,'西市区',3),(945,80,'鲅鱼圈区',3),(946,80,'老边区',3),(947,80,'盖州市',3),(948,80,'大石桥市',3),(949,80,'其它区',3),(950,81,'海州区',3),(951,81,'新邱区',3),(952,81,'太平区',3),(953,81,'清河门区',3),(954,81,'细河区',3),(955,81,'阜新蒙古族自治县',3),(956,81,'彰武县',3),(957,81,'其它区',3),(958,82,'白塔区',3),(959,82,'文圣区',3),(960,82,'宏伟区',3),(961,82,'弓长岭区',3),(962,82,'太子河区',3),(963,82,'辽阳县',3),(964,82,'灯塔市',3),(965,82,'其它区',3),(966,83,'双台子区',3),(967,83,'兴隆台区',3),(968,83,'大洼县',3),(969,83,'盘山县',3),(970,83,'其它区',3),(971,84,'银州区',3),(972,84,'清河区',3),(973,84,'铁岭县',3),(974,84,'西丰县',3),(975,84,'昌图县',3),(976,84,'调兵山市',3),(977,84,'开原市',3),(978,84,'其它区',3),(979,85,'双塔区',3),(980,85,'龙城区',3),(981,85,'朝阳县',3),(982,85,'建平县',3),(983,85,'喀喇沁左翼蒙古族自治县',3),(984,85,'北票市',3),(985,85,'凌源市',3),(986,85,'其它区',3),(987,86,'连山区',3),(988,86,'龙港区',3),(989,86,'南票区',3),(990,86,'绥中县',3),(991,86,'建昌县',3),(992,86,'兴城市',3),(993,86,'其它区',3),(994,87,'南关区',3),(995,87,'宽城区',3),(996,87,'朝阳区',3),(997,87,'二道区',3),(998,87,'绿园区',3),(999,87,'双阳区',3),(1000,87,'农安县',3),(1001,87,'九台区',3),(1002,87,'榆树市',3),(1003,87,'德惠市',3),(1004,87,'高新技术产业开发区',3),(1005,87,'汽车产业开发区',3),(1006,87,'经济技术开发区',3),(1007,87,'净月旅游开发区',3),(1008,87,'其它区',3),(1009,88,'昌邑区',3),(1010,88,'龙潭区',3),(1011,88,'船营区',3),(1012,88,'丰满区',3),(1013,88,'永吉县',3),(1014,88,'蛟河市',3),(1015,88,'桦甸市',3),(1016,88,'舒兰市',3),(1017,88,'磐石市',3),(1018,88,'其它区',3),(1019,89,'铁西区',3),(1020,89,'铁东区',3),(1021,89,'梨树县',3),(1022,89,'伊通满族自治县',3),(1023,89,'公主岭市',3),(1024,89,'双辽市',3),(1025,89,'其它区',3),(1026,90,'龙山区',3),(1027,90,'西安区',3),(1028,90,'东丰县',3),(1029,90,'东辽县',3),(1030,90,'其它区',3),(1031,91,'东昌区',3),(1032,91,'二道江区',3),(1033,91,'通化县',3),(1034,91,'辉南县',3),(1035,91,'柳河县',3),(1036,91,'梅河口市',3),(1037,91,'集安市',3),(1038,91,'其它区',3),(1039,92,'浑江区',3),(1040,92,'抚松县',3),(1041,92,'靖宇县',3),(1042,92,'长白朝鲜族自治县',3),(1043,92,'江源区',3),(1044,92,'临江市',3),(1045,92,'其它区',3),(1046,93,'宁江区',3),(1047,93,'前郭尔罗斯蒙古族自治县',3),(1048,93,'长岭县',3),(1049,93,'乾安县',3),(1050,93,'扶余市',3),(1051,93,'其它区',3),(1052,94,'洮北区',3),(1053,94,'镇赉县',3),(1054,94,'通榆县',3),(1055,94,'洮南市',3),(1056,94,'大安市',3),(1057,94,'其它区',3),(1058,95,'延吉市',3),(1059,95,'图们市',3),(1060,95,'敦化市',3),(1061,95,'珲春市',3),(1062,95,'龙井市',3),(1063,95,'和龙市',3),(1064,95,'汪清县',3),(1065,95,'安图县',3),(1066,95,'其它区',3),(1067,96,'道里区',3),(1068,96,'南岗区',3),(1069,96,'道外区',3),(1070,96,'香坊区',3),(1071,96,'动力区',3),(1072,96,'平房区',3),(1073,96,'松北区',3),(1074,96,'呼兰区',3),(1075,96,'依兰县',3),(1076,96,'方正县',3),(1077,96,'宾县',3),(1078,96,'巴彦县',3),(1079,96,'木兰县',3),(1080,96,'通河县',3),(1081,96,'延寿县',3),(1082,96,'阿城区',3),(1083,96,'双城区',3),(1084,96,'尚志市',3),(1085,96,'五常市',3),(1086,96,'阿城市',3),(1087,96,'其它区',3),(1088,97,'龙沙区',3),(1089,97,'建华区',3),(1090,97,'铁锋区',3),(1091,97,'昂昂溪区',3),(1092,97,'富拉尔基区',3),(1093,97,'碾子山区',3),(1094,97,'梅里斯达斡尔族区',3),(1095,97,'龙江县',3),(1096,97,'依安县',3),(1097,97,'泰来县',3),(1098,97,'甘南县',3),(1099,97,'富裕县',3),(1100,97,'克山县',3),(1101,97,'克东县',3),(1102,97,'拜泉县',3),(1103,97,'讷河市',3),(1104,97,'其它区',3),(1105,98,'鸡冠区',3),(1106,98,'恒山区',3),(1107,98,'滴道区',3),(1108,98,'梨树区',3),(1109,98,'城子河区',3),(1110,98,'麻山区',3),(1111,98,'鸡东县',3),(1112,98,'虎林市',3),(1113,98,'密山市',3),(1114,98,'其它区',3),(1115,99,'向阳区',3),(1116,99,'工农区',3),(1117,99,'南山区',3),(1118,99,'兴安区',3),(1119,99,'东山区',3),(1120,99,'兴山区',3),(1121,99,'萝北县',3),(1122,99,'绥滨县',3),(1123,99,'其它区',3),(1124,100,'尖山区',3),(1125,100,'岭东区',3),(1126,100,'四方台区',3),(1127,100,'宝山区',3),(1128,100,'集贤县',3),(1129,100,'友谊县',3),(1130,100,'宝清县',3),(1131,100,'饶河县',3),(1132,100,'其它区',3),(1133,101,'萨尔图区',3),(1134,101,'龙凤区',3),(1135,101,'让胡路区',3),(1136,101,'红岗区',3),(1137,101,'大同区',3),(1138,101,'肇州县',3),(1139,101,'肇源县',3),(1140,101,'林甸县',3),(1141,101,'杜尔伯特蒙古族自治县',3),(1142,101,'其它区',3),(1143,102,'伊春区',3),(1144,102,'南岔区',3),(1145,102,'友好区',3),(1146,102,'西林区',3),(1147,102,'翠峦区',3),(1148,102,'新青区',3),(1149,102,'美溪区',3),(1150,102,'金山屯区',3),(1151,102,'五营区',3),(1152,102,'乌马河区',3),(1153,102,'汤旺河区',3),(1154,102,'带岭区',3),(1155,102,'乌伊岭区',3),(1156,102,'红星区',3),(1157,102,'上甘岭区',3),(1158,102,'嘉荫县',3),(1159,102,'铁力市',3),(1160,102,'其它区',3),(1161,103,'永红区',3),(1162,103,'向阳区',3),(1163,103,'前进区',3),(1164,103,'东风区',3),(1165,103,'郊区',3),(1166,103,'桦南县',3),(1167,103,'桦川县',3),(1168,103,'汤原县',3),(1169,103,'抚远县',3),(1170,103,'同江市',3),(1171,103,'富锦市',3),(1172,103,'其它区',3),(1173,104,'新兴区',3),(1174,104,'桃山区',3),(1175,104,'茄子河区',3),(1176,104,'勃利县',3),(1177,104,'其它区',3),(1178,105,'东安区',3),(1179,105,'阳明区',3),(1180,105,'爱民区',3),(1181,105,'西安区',3),(1182,105,'东宁县',3),(1183,105,'林口县',3),(1184,105,'绥芬河市',3),(1185,105,'海林市',3),(1186,105,'宁安市',3),(1187,105,'穆棱市',3),(1188,105,'其它区',3),(1189,106,'爱辉区',3),(1190,106,'嫩江县',3),(1191,106,'逊克县',3),(1192,106,'孙吴县',3),(1193,106,'北安市',3),(1194,106,'五大连池市',3),(1195,106,'其它区',3),(1196,107,'北林区',3),(1197,107,'望奎县',3),(1198,107,'兰西县',3),(1199,107,'青冈县',3),(1200,107,'庆安县',3),(1201,107,'明水县',3),(1202,107,'绥棱县',3),(1203,107,'安达市',3),(1204,107,'肇东市',3),(1205,107,'海伦市',3),(1206,107,'其它区',3),(1207,108,'松岭区',3),(1208,108,'新林区',3),(1209,108,'呼中区',3),(1210,108,'呼玛县',3),(1211,108,'塔河县',3),(1212,108,'漠河县',3),(1213,108,'加格达奇区',3),(1214,108,'其它区',3),(1215,109,'黄浦区',3),(1216,109,'卢湾区',3),(1217,109,'徐汇区',3),(1218,109,'长宁区',3),(1219,109,'静安区',3),(1220,109,'普陀区',3),(1221,109,'闸北区',3),(1222,109,'虹口区',3),(1223,109,'杨浦区',3),(1224,109,'闵行区',3),(1225,109,'宝山区',3),(1226,109,'嘉定区',3),(1227,109,'浦东新区',3),(1228,109,'金山区',3),(1229,109,'松江区',3),(1230,109,'青浦区',3),(1231,109,'南汇区',3),(1232,109,'奉贤区',3),(1233,109,'川沙区',3),(1234,109,'崇明县',3),(1235,109,'其它区',3),(1236,110,'玄武区',3),(1237,110,'白下区',3),(1238,110,'秦淮区',3),(1239,110,'建邺区',3),(1240,110,'鼓楼区',3),(1241,110,'下关区',3),(1242,110,'浦口区',3),(1243,110,'栖霞区',3),(1244,110,'雨花台区',3),(1245,110,'江宁区',3),(1246,110,'六合区',3),(1247,110,'溧水区',3),(1248,110,'高淳区',3),(1249,110,'其它区',3),(1250,111,'崇安区',3),(1251,111,'南长区',3),(1252,111,'北塘区',3),(1253,111,'锡山区',3),(1254,111,'惠山区',3),(1255,111,'滨湖区',3),(1256,111,'江阴市',3),(1257,111,'宜兴市',3),(1258,111,'新区',3),(1259,111,'其它区',3),(1260,112,'鼓楼区',3),(1261,112,'云龙区',3),(1262,112,'九里区',3),(1263,112,'贾汪区',3),(1264,112,'泉山区',3),(1265,112,'丰县',3),(1266,112,'沛县',3),(1267,112,'铜山区',3),(1268,112,'睢宁县',3),(1269,112,'新沂市',3),(1270,112,'邳州市',3),(1271,112,'其它区',3),(1272,113,'天宁区',3),(1273,113,'钟楼区',3),(1274,113,'戚墅堰区',3),(1275,113,'新北区',3),(1276,113,'武进区',3),(1277,113,'溧阳市',3),(1278,113,'金坛市',3),(1279,113,'其它区',3),(1280,114,'沧浪区',3),(1281,114,'平江区',3),(1282,114,'金阊区',3),(1283,114,'虎丘区',3),(1284,114,'吴中区',3),(1285,114,'相城区',3),(1286,114,'姑苏区',3),(1287,114,'常熟市',3),(1288,114,'张家港市',3),(1289,114,'昆山市',3),(1290,114,'吴江区',3),(1291,114,'太仓市',3),(1292,114,'新区',3),(1293,114,'园区',3),(1294,114,'其它区',3),(1295,115,'崇川区',3),(1296,115,'港闸区',3),(1297,115,'通州区',3),(1298,115,'海安县',3),(1299,115,'如东县',3),(1300,115,'启东市',3),(1301,115,'如皋市',3),(1302,115,'通州市',3),(1303,115,'海门市',3),(1304,115,'开发区',3),(1305,115,'其它区',3),(1306,116,'连云区',3),(1307,116,'新浦区',3),(1308,116,'海州区',3),(1309,116,'赣榆区',3),(1310,116,'东海县',3),(1311,116,'灌云县',3),(1312,116,'灌南县',3),(1313,116,'其它区',3),(1314,117,'清河区',3),(1315,117,'淮安区',3),(1316,117,'淮阴区',3),(1317,117,'清浦区',3),(1318,117,'涟水县',3),(1319,117,'洪泽县',3),(1320,117,'盱眙县',3),(1321,117,'金湖县',3),(1322,117,'其它区',3),(1323,118,'亭湖区',3),(1324,118,'盐都区',3),(1325,118,'响水县',3),(1326,118,'滨海县',3),(1327,118,'阜宁县',3),(1328,118,'射阳县',3),(1329,118,'建湖县',3),(1330,118,'东台市',3),(1331,118,'大丰市',3),(1332,118,'其它区',3),(1333,119,'广陵区',3),(1334,119,'邗江区',3),(1335,119,'维扬区',3),(1336,119,'宝应县',3),(1337,119,'仪征市',3),(1338,119,'高邮市',3),(1339,119,'江都区',3),(1340,119,'经济开发区',3),(1341,119,'其它区',3),(1342,120,'京口区',3),(1343,120,'润州区',3),(1344,120,'丹徒区',3),(1345,120,'丹阳市',3),(1346,120,'扬中市',3),(1347,120,'句容市',3),(1348,120,'其它区',3),(1349,121,'海陵区',3),(1350,121,'高港区',3),(1351,121,'兴化市',3),(1352,121,'靖江市',3),(1353,121,'泰兴市',3),(1354,121,'姜堰区',3),(1355,121,'其它区',3),(1356,122,'宿城区',3),(1357,122,'宿豫区',3),(1358,122,'沭阳县',3),(1359,122,'泗阳县',3),(1360,122,'泗洪县',3),(1361,122,'其它区',3),(1362,123,'上城区',3),(1363,123,'下城区',3),(1364,123,'江干区',3),(1365,123,'拱墅区',3),(1366,123,'西湖区',3),(1367,123,'滨江区',3),(1368,123,'萧山区',3),(1369,123,'余杭区',3),(1370,123,'桐庐县',3),(1371,123,'淳安县',3),(1372,123,'建德市',3),(1373,123,'富阳区',3),(1374,123,'临安市',3),(1375,123,'其它区',3),(1376,124,'海曙区',3),(1377,124,'江东区',3),(1378,124,'江北区',3),(1379,124,'北仑区',3),(1380,124,'镇海区',3),(1381,124,'鄞州区',3),(1382,124,'象山县',3),(1383,124,'宁海县',3),(1384,124,'余姚市',3),(1385,124,'慈溪市',3),(1386,124,'奉化市',3),(1387,124,'其它区',3),(1388,125,'鹿城区',3),(1389,125,'龙湾区',3),(1390,125,'瓯海区',3),(1391,125,'洞头县',3),(1392,125,'永嘉县',3),(1393,125,'平阳县',3),(1394,125,'苍南县',3),(1395,125,'文成县',3),(1396,125,'泰顺县',3),(1397,125,'瑞安市',3),(1398,125,'乐清市',3),(1399,125,'其它区',3),(1400,126,'南湖区',3),(1401,126,'秀洲区',3),(1402,126,'嘉善县',3),(1403,126,'海盐县',3),(1404,126,'海宁市',3),(1405,126,'平湖市',3),(1406,126,'桐乡市',3),(1407,126,'其它区',3),(1408,127,'吴兴区',3),(1409,127,'南浔区',3),(1410,127,'德清县',3),(1411,127,'长兴县',3),(1412,127,'安吉县',3),(1413,127,'其它区',3),(1414,128,'越城区',3),(1415,128,'柯桥区',3),(1416,128,'新昌县',3),(1417,128,'诸暨市',3),(1418,128,'上虞区',3),(1419,128,'嵊州市',3),(1420,128,'其它区',3),(1421,129,'婺城区',3),(1422,129,'金东区',3),(1423,129,'武义县',3),(1424,129,'浦江县',3),(1425,129,'磐安县',3),(1426,129,'兰溪市',3),(1427,129,'义乌市',3),(1428,129,'东阳市',3),(1429,129,'永康市',3),(1430,129,'其它区',3),(1431,130,'柯城区',3),(1432,130,'衢江区',3),(1433,130,'常山县',3),(1434,130,'开化县',3),(1435,130,'龙游县',3),(1436,130,'江山市',3),(1437,130,'其它区',3),(1438,131,'定海区',3),(1439,131,'普陀区',3),(1440,131,'岱山县',3),(1441,131,'嵊泗县',3),(1442,131,'其它区',3),(1443,132,'椒江区',3),(1444,132,'黄岩区',3),(1445,132,'路桥区',3),(1446,132,'玉环县',3),(1447,132,'三门县',3),(1448,132,'天台县',3),(1449,132,'仙居县',3),(1450,132,'温岭市',3),(1451,132,'临海市',3),(1452,132,'其它区',3),(1453,133,'莲都区',3),(1454,133,'青田县',3),(1455,133,'缙云县',3),(1456,133,'遂昌县',3),(1457,133,'松阳县',3),(1458,133,'云和县',3),(1459,133,'庆元县',3),(1460,133,'景宁畲族自治县',3),(1461,133,'龙泉市',3),(1462,133,'其它区',3),(1463,134,'瑶海区',3),(1464,134,'庐阳区',3),(1465,134,'蜀山区',3),(1466,134,'包河区',3),(1467,134,'长丰县',3),(1468,134,'肥东县',3),(1469,134,'肥西县',3),(1470,134,'高新区',3),(1471,134,'中区',3),(1472,134,'其它区',3),(1473,135,'镜湖区',3),(1474,135,'弋江区',3),(1475,135,'鸠江区',3),(1476,135,'三山区',3),(1477,135,'芜湖县',3),(1478,135,'繁昌县',3),(1479,135,'南陵县',3),(1480,135,'其它区',3),(1481,136,'龙子湖区',3),(1482,136,'蚌山区',3),(1483,136,'禹会区',3),(1484,136,'淮上区',3),(1485,136,'怀远县',3),(1486,136,'五河县',3),(1487,136,'固镇县',3),(1488,136,'其它区',3),(1489,137,'大通区',3),(1490,137,'田家庵区',3),(1491,137,'谢家集区',3),(1492,137,'八公山区',3),(1493,137,'潘集区',3),(1494,137,'凤台县',3),(1495,137,'其它区',3),(1496,138,'金家庄区',3),(1497,138,'花山区',3),(1498,138,'雨山区',3),(1499,138,'博望区',3),(1500,138,'当涂县',3),(1501,138,'其它区',3),(1502,139,'杜集区',3),(1503,139,'相山区',3),(1504,139,'烈山区',3),(1505,139,'濉溪县',3),(1506,139,'其它区',3),(1507,140,'铜官山区',3),(1508,140,'狮子山区',3),(1509,140,'郊区',3),(1510,140,'铜陵县',3),(1511,140,'其它区',3),(1512,141,'迎江区',3),(1513,141,'大观区',3),(1514,141,'宜秀区',3),(1515,141,'怀宁县',3),(1516,141,'枞阳县',3),(1517,141,'潜山县',3),(1518,141,'太湖县',3),(1519,141,'宿松县',3),(1520,141,'望江县',3),(1521,141,'岳西县',3),(1522,141,'桐城市',3),(1523,141,'其它区',3),(1524,142,'屯溪区',3),(1525,142,'黄山区',3),(1526,142,'徽州区',3),(1527,142,'歙县',3),(1528,142,'休宁县',3),(1529,142,'黟县',3),(1530,142,'祁门县',3),(1531,142,'其它区',3),(1532,143,'琅琊区',3),(1533,143,'南谯区',3),(1534,143,'来安县',3),(1535,143,'全椒县',3),(1536,143,'定远县',3),(1537,143,'凤阳县',3),(1538,143,'天长市',3),(1539,143,'明光市',3),(1540,143,'其它区',3),(1541,144,'颍州区',3),(1542,144,'颍东区',3),(1543,144,'颍泉区',3),(1544,144,'临泉县',3),(1545,144,'太和县',3),(1546,144,'阜南县',3),(1547,144,'颍上县',3),(1548,144,'界首市',3),(1549,144,'其它区',3),(1550,145,'埇桥区',3),(1551,145,'砀山县',3),(1552,145,'萧县',3),(1553,145,'灵璧县',3),(1554,145,'泗县',3),(1555,145,'其它区',3),(1556,134,'巢湖市',3),(1557,134,'居巢区',3),(1558,134,'庐江县',3),(1559,135,'无为县',3),(1560,138,'含山县',3),(1561,138,'和县',3),(1562,146,'金安区',3),(1563,146,'裕安区',3),(1564,146,'寿县',3),(1565,146,'霍邱县',3),(1566,146,'舒城县',3),(1567,146,'金寨县',3),(1568,146,'霍山县',3),(1569,146,'其它区',3),(1570,147,'谯城区',3),(1571,147,'涡阳县',3),(1572,147,'蒙城县',3),(1573,147,'利辛县',3),(1574,147,'其它区',3),(1575,148,'贵池区',3),(1576,148,'东至县',3),(1577,148,'石台县',3),(1578,148,'青阳县',3),(1579,148,'其它区',3),(1580,149,'宣州区',3),(1581,149,'郎溪县',3),(1582,149,'广德县',3),(1583,149,'泾县',3),(1584,149,'绩溪县',3),(1585,149,'旌德县',3),(1586,149,'宁国市',3),(1587,149,'其它区',3),(1588,150,'鼓楼区',3),(1589,150,'台江区',3),(1590,150,'仓山区',3),(1591,150,'马尾区',3),(1592,150,'晋安区',3),(1593,150,'闽侯县',3),(1594,150,'连江县',3),(1595,150,'罗源县',3),(1596,150,'闽清县',3),(1597,150,'永泰县',3),(1598,150,'平潭县',3),(1599,150,'福清市',3),(1600,150,'长乐市',3),(1601,150,'其它区',3),(1602,151,'思明区',3),(1603,151,'海沧区',3),(1604,151,'湖里区',3),(1605,151,'集美区',3),(1606,151,'同安区',3),(1607,151,'翔安区',3),(1608,151,'其它区',3),(1609,152,'城厢区',3),(1610,152,'涵江区',3),(1611,152,'荔城区',3),(1612,152,'秀屿区',3),(1613,152,'仙游县',3),(1614,152,'其它区',3),(1615,153,'梅列区',3),(1616,153,'三元区',3),(1617,153,'明溪县',3),(1618,153,'清流县',3),(1619,153,'宁化县',3),(1620,153,'大田县',3),(1621,153,'尤溪县',3),(1622,153,'沙县',3),(1623,153,'将乐县',3),(1624,153,'泰宁县',3),(1625,153,'建宁县',3),(1626,153,'永安市',3),(1627,153,'其它区',3),(1628,154,'鲤城区',3),(1629,154,'丰泽区',3),(1630,154,'洛江区',3),(1631,154,'泉港区',3),(1632,154,'惠安县',3),(1633,154,'安溪县',3),(1634,154,'永春县',3),(1635,154,'德化县',3),(1636,154,'金门县',3),(1637,154,'石狮市',3),(1638,154,'晋江市',3),(1639,154,'南安市',3),(1640,154,'其它区',3),(1641,155,'芗城区',3),(1642,155,'龙文区',3),(1643,155,'云霄县',3),(1644,155,'漳浦县',3),(1645,155,'诏安县',3),(1646,155,'长泰县',3),(1647,155,'东山县',3),(1648,155,'南靖县',3),(1649,155,'平和县',3),(1650,155,'华安县',3),(1651,155,'龙海市',3),(1652,155,'其它区',3),(1653,156,'延平区',3),(1654,156,'顺昌县',3),(1655,156,'浦城县',3),(1656,156,'光泽县',3),(1657,156,'松溪县',3),(1658,156,'政和县',3),(1659,156,'邵武市',3),(1660,156,'武夷山市',3),(1661,156,'建瓯市',3),(1662,156,'建阳区',3),(1663,156,'其它区',3),(1664,157,'新罗区',3),(1665,157,'长汀县',3),(1666,157,'永定区',3),(1667,157,'上杭县',3),(1668,157,'武平县',3),(1669,157,'连城县',3),(1670,157,'漳平市',3),(1671,157,'其它区',3),(1672,158,'蕉城区',3),(1673,158,'霞浦县',3),(1674,158,'古田县',3),(1675,158,'屏南县',3),(1676,158,'寿宁县',3),(1677,158,'周宁县',3),(1678,158,'柘荣县',3),(1679,158,'福安市',3),(1680,158,'福鼎市',3),(1681,158,'其它区',3),(1682,159,'东湖区',3),(1683,159,'西湖区',3),(1684,159,'青云谱区',3),(1685,159,'湾里区',3),(1686,159,'青山湖区',3),(1687,159,'南昌县',3),(1688,159,'新建县',3),(1689,159,'安义县',3),(1690,159,'进贤县',3),(1691,159,'红谷滩新区',3),(1692,159,'经济技术开发区',3),(1693,159,'昌北区',3),(1694,159,'其它区',3),(1695,160,'昌江区',3),(1696,160,'珠山区',3),(1697,160,'浮梁县',3),(1698,160,'乐平市',3),(1699,160,'其它区',3),(1700,161,'安源区',3),(1701,161,'湘东区',3),(1702,161,'莲花县',3),(1703,161,'上栗县',3),(1704,161,'芦溪县',3),(1705,161,'其它区',3),(1706,162,'庐山区',3),(1707,162,'浔阳区',3),(1708,162,'九江县',3),(1709,162,'武宁县',3),(1710,162,'修水县',3),(1711,162,'永修县',3),(1712,162,'德安县',3),(1713,162,'星子县',3),(1714,162,'都昌县',3),(1715,162,'湖口县',3),(1716,162,'彭泽县',3),(1717,162,'瑞昌市',3),(1718,162,'其它区',3),(1719,162,'共青城市',3),(1720,163,'渝水区',3),(1721,163,'分宜县',3),(1722,163,'其它区',3),(1723,164,'月湖区',3),(1724,164,'余江县',3),(1725,164,'贵溪市',3),(1726,164,'其它区',3),(1727,165,'章贡区',3),(1728,165,'赣县',3),(1729,165,'信丰县',3),(1730,165,'大余县',3),(1731,165,'上犹县',3),(1732,165,'崇义县',3),(1733,165,'安远县',3),(1734,165,'龙南县',3),(1735,165,'定南县',3),(1736,165,'全南县',3),(1737,165,'宁都县',3),(1738,165,'于都县',3),(1739,165,'兴国县',3),(1740,165,'会昌县',3),(1741,165,'寻乌县',3),(1742,165,'石城县',3),(1743,165,'黄金区',3),(1744,165,'瑞金市',3),(1745,165,'南康区',3),(1746,165,'其它区',3),(1747,166,'吉州区',3),(1748,166,'青原区',3),(1749,166,'吉安县',3),(1750,166,'吉水县',3),(1751,166,'峡江县',3),(1752,166,'新干县',3),(1753,166,'永丰县',3),(1754,166,'泰和县',3),(1755,166,'遂川县',3),(1756,166,'万安县',3),(1757,166,'安福县',3),(1758,166,'永新县',3),(1759,166,'井冈山市',3),(1760,166,'其它区',3),(1761,167,'袁州区',3),(1762,167,'奉新县',3),(1763,167,'万载县',3),(1764,167,'上高县',3),(1765,167,'宜丰县',3),(1766,167,'靖安县',3),(1767,167,'铜鼓县',3),(1768,167,'丰城市',3),(1769,167,'樟树市',3),(1770,167,'高安市',3),(1771,167,'其它区',3),(1772,168,'临川区',3),(1773,168,'南城县',3),(1774,168,'黎川县',3),(1775,168,'南丰县',3),(1776,168,'崇仁县',3),(1777,168,'乐安县',3),(1778,168,'宜黄县',3),(1779,168,'金溪县',3),(1780,168,'资溪县',3),(1781,168,'东乡县',3),(1782,168,'广昌县',3),(1783,168,'其它区',3),(1784,169,'信州区',3),(1785,169,'上饶县',3),(1786,169,'广丰区',3),(1787,169,'玉山县',3),(1788,169,'铅山县',3),(1789,169,'横峰县',3),(1790,169,'弋阳县',3),(1791,169,'余干县',3),(1792,169,'鄱阳县',3),(1793,169,'万年县',3),(1794,169,'婺源县',3),(1795,169,'德兴市',3),(1796,169,'其它区',3),(1797,170,'历下区',3),(1798,170,'市中区',3),(1799,170,'槐荫区',3),(1800,170,'天桥区',3),(1801,170,'历城区',3),(1802,170,'长清区',3),(1803,170,'平阴县',3),(1804,170,'济阳县',3),(1805,170,'商河县',3),(1806,170,'章丘市',3),(1807,170,'其它区',3),(1808,171,'市南区',3),(1809,171,'市北区',3),(1810,171,'四方区',3),(1811,171,'黄岛区',3),(1812,171,'崂山区',3),(1813,171,'李沧区',3),(1814,171,'城阳区',3),(1815,171,'开发区',3),(1816,171,'胶州市',3),(1817,171,'即墨市',3),(1818,171,'平度市',3),(1819,171,'胶南市',3),(1820,171,'莱西市',3),(1821,171,'其它区',3),(1822,172,'淄川区',3),(1823,172,'张店区',3),(1824,172,'博山区',3),(1825,172,'临淄区',3),(1826,172,'周村区',3),(1827,172,'桓台县',3),(1828,172,'高青县',3),(1829,172,'沂源县',3),(1830,172,'其它区',3),(1831,173,'市中区',3),(1832,173,'薛城区',3),(1833,173,'峄城区',3),(1834,173,'台儿庄区',3),(1835,173,'山亭区',3),(1836,173,'滕州市',3),(1837,173,'其它区',3),(1838,174,'东营区',3),(1839,174,'河口区',3),(1840,174,'垦利县',3),(1841,174,'利津县',3),(1842,174,'广饶县',3),(1843,174,'西城区',3),(1844,174,'东城区',3),(1845,174,'其它区',3),(1846,175,'芝罘区',3),(1847,175,'福山区',3),(1848,175,'牟平区',3),(1849,175,'莱山区',3),(1850,175,'长岛县',3),(1851,175,'龙口市',3),(1852,175,'莱阳市',3),(1853,175,'莱州市',3),(1854,175,'蓬莱市',3),(1855,175,'招远市',3),(1856,175,'栖霞市',3),(1857,175,'海阳市',3),(1858,175,'其它区',3),(1859,176,'潍城区',3),(1860,176,'寒亭区',3),(1861,176,'坊子区',3),(1862,176,'奎文区',3),(1863,176,'临朐县',3),(1864,176,'昌乐县',3),(1865,176,'开发区',3),(1866,176,'青州市',3),(1867,176,'诸城市',3),(1868,176,'寿光市',3),(1869,176,'安丘市',3),(1870,176,'高密市',3),(1871,176,'昌邑市',3),(1872,176,'其它区',3),(1873,177,'市中区',3),(1874,177,'任城区',3),(1875,177,'微山县',3),(1876,177,'鱼台县',3),(1877,177,'金乡县',3),(1878,177,'嘉祥县',3),(1879,177,'汶上县',3),(1880,177,'泗水县',3),(1881,177,'梁山县',3),(1882,177,'曲阜市',3),(1883,177,'兖州区',3),(1884,177,'邹城市',3),(1885,177,'其它区',3),(1886,178,'泰山区',3),(1887,178,'岱岳区',3),(1888,178,'宁阳县',3),(1889,178,'东平县',3),(1890,178,'新泰市',3),(1891,178,'肥城市',3),(1892,178,'其它区',3),(1893,179,'环翠区',3),(1894,179,'文登区',3),(1895,179,'荣成市',3),(1896,179,'乳山市',3),(1897,179,'其它区',3),(1898,180,'东港区',3),(1899,180,'岚山区',3),(1900,180,'五莲县',3),(1901,180,'莒县',3),(1902,180,'其它区',3),(1903,181,'莱城区',3),(1904,181,'钢城区',3),(1905,181,'其它区',3),(1906,182,'兰山区',3),(1907,182,'罗庄区',3),(1908,182,'河东区',3),(1909,182,'沂南县',3),(1910,182,'郯城县',3),(1911,182,'沂水县',3),(1912,182,'兰陵县',3),(1913,182,'费县',3),(1914,182,'平邑县',3),(1915,182,'莒南县',3),(1916,182,'蒙阴县',3),(1917,182,'临沭县',3),(1918,182,'其它区',3),(1919,183,'德城区',3),(1920,183,'陵城区',3),(1921,183,'宁津县',3),(1922,183,'庆云县',3),(1923,183,'临邑县',3),(1924,183,'齐河县',3),(1925,183,'平原县',3),(1926,183,'夏津县',3),(1927,183,'武城县',3),(1928,183,'开发区',3),(1929,183,'乐陵市',3),(1930,183,'禹城市',3),(1931,183,'其它区',3),(1932,184,'东昌府区',3),(1933,184,'阳谷县',3),(1934,184,'莘县',3),(1935,184,'茌平县',3),(1936,184,'东阿县',3),(1937,184,'冠县',3),(1938,184,'高唐县',3),(1939,184,'临清市',3),(1940,184,'其它区',3),(1941,185,'滨城区',3),(1942,185,'惠民县',3),(1943,185,'阳信县',3),(1944,185,'无棣县',3),(1945,185,'沾化区',3),(1946,185,'博兴县',3),(1947,185,'邹平县',3),(1948,185,'其它区',3),(1949,186,'牡丹区',3),(1950,186,'曹县',3),(1951,186,'单县',3),(1952,186,'成武县',3),(1953,186,'巨野县',3),(1954,186,'郓城县',3),(1955,186,'鄄城县',3),(1956,186,'定陶县',3),(1957,186,'东明县',3),(1958,186,'其它区',3),(1959,187,'中原区',3),(1960,187,'二七区',3),(1961,187,'管城回族区',3),(1962,187,'金水区',3),(1963,187,'上街区',3),(1964,187,'惠济区',3),(1965,187,'中牟县',3),(1966,187,'巩义市',3),(1967,187,'荥阳市',3),(1968,187,'新密市',3),(1969,187,'新郑市',3),(1970,187,'登封市',3),(1971,187,'郑东新区',3),(1972,187,'高新区',3),(1973,187,'其它区',3),(1974,188,'龙亭区',3),(1975,188,'顺河回族区',3),(1976,188,'鼓楼区',3),(1977,188,'禹王台区',3),(1978,188,'金明区',3),(1979,188,'杞县',3),(1980,188,'通许县',3),(1981,188,'尉氏县',3),(1982,188,'祥符区',3),(1983,188,'兰考县',3),(1984,188,'其它区',3),(1985,189,'老城区',3),(1986,189,'西工区',3),(1987,189,'瀍河回族区',3),(1988,189,'涧西区',3),(1989,189,'吉利区',3),(1990,189,'洛龙区',3),(1991,189,'孟津县',3),(1992,189,'新安县',3),(1993,189,'栾川县',3),(1994,189,'嵩县',3),(1995,189,'汝阳县',3),(1996,189,'宜阳县',3),(1997,189,'洛宁县',3),(1998,189,'伊川县',3),(1999,189,'偃师市',3),(2000,190,'新华区',3),(2001,190,'卫东区',3),(2002,190,'石龙区',3),(2003,190,'湛河区',3),(2004,190,'宝丰县',3),(2005,190,'叶县',3),(2006,190,'鲁山县',3),(2007,190,'郏县',3),(2008,190,'舞钢市',3),(2009,190,'汝州市',3),(2010,190,'其它区',3),(2011,191,'文峰区',3),(2012,191,'北关区',3),(2013,191,'殷都区',3),(2014,191,'龙安区',3),(2015,191,'安阳县',3),(2016,191,'汤阴县',3),(2017,191,'滑县',3),(2018,191,'内黄县',3),(2019,191,'林州市',3),(2020,191,'其它区',3),(2021,192,'鹤山区',3),(2022,192,'山城区',3),(2023,192,'淇滨区',3),(2024,192,'浚县',3),(2025,192,'淇县',3),(2026,192,'其它区',3),(2027,193,'红旗区',3),(2028,193,'卫滨区',3),(2029,193,'凤泉区',3),(2030,193,'牧野区',3),(2031,193,'新乡县',3),(2032,193,'获嘉县',3),(2033,193,'原阳县',3),(2034,193,'延津县',3),(2035,193,'封丘县',3),(2036,193,'长垣县',3),(2037,193,'卫辉市',3),(2038,193,'辉县市',3),(2039,193,'其它区',3),(2040,194,'解放区',3),(2041,194,'中站区',3),(2042,194,'马村区',3),(2043,194,'山阳区',3),(2044,194,'修武县',3),(2045,194,'博爱县',3),(2046,194,'武陟县',3),(2047,194,'温县',3),(2048,194,'沁阳市',3),(2049,194,'孟州市',3),(2050,194,'其它区',3),(2051,195,'华龙区',3),(2052,195,'清丰县',3),(2053,195,'南乐县',3),(2054,195,'范县',3),(2055,195,'台前县',3),(2056,195,'濮阳县',3),(2057,195,'其它区',3),(2058,196,'魏都区',3),(2059,196,'许昌县',3),(2060,196,'鄢陵县',3),(2061,196,'襄城县',3),(2062,196,'禹州市',3),(2063,196,'长葛市',3),(2064,196,'其它区',3),(2065,197,'源汇区',3),(2066,197,'郾城区',3),(2067,197,'召陵区',3),(2068,197,'舞阳县',3),(2069,197,'临颍县',3),(2070,197,'其它区',3),(2071,198,'湖滨区',3),(2072,198,'渑池县',3),(2073,198,'陕州区',3),(2074,198,'卢氏县',3),(2075,198,'义马市',3),(2076,198,'灵宝市',3),(2077,198,'其它区',3),(2078,199,'宛城区',3),(2079,199,'卧龙区',3),(2080,199,'南召县',3),(2081,199,'方城县',3),(2082,199,'西峡县',3),(2083,199,'镇平县',3),(2084,199,'内乡县',3),(2085,199,'淅川县',3),(2086,199,'社旗县',3),(2087,199,'唐河县',3),(2088,199,'新野县',3),(2089,199,'桐柏县',3),(2090,199,'邓州市',3),(2091,199,'其它区',3),(2092,200,'梁园区',3),(2093,200,'睢阳区',3),(2094,200,'民权县',3),(2095,200,'睢县',3),(2096,200,'宁陵县',3),(2097,200,'柘城县',3),(2098,200,'虞城县',3),(2099,200,'夏邑县',3),(2100,200,'永城市',3),(2101,200,'其它区',3),(2102,201,'浉河区',3),(2103,201,'平桥区',3),(2104,201,'罗山县',3),(2105,201,'光山县',3),(2106,201,'新县',3),(2107,201,'商城县',3),(2108,201,'固始县',3),(2109,201,'潢川县',3),(2110,201,'淮滨县',3),(2111,201,'息县',3),(2112,201,'其它区',3),(2113,202,'川汇区',3),(2114,202,'扶沟县',3),(2115,202,'西华县',3),(2116,202,'商水县',3),(2117,202,'沈丘县',3),(2118,202,'郸城县',3),(2119,202,'淮阳县',3),(2120,202,'太康县',3),(2121,202,'鹿邑县',3),(2122,202,'项城市',3),(2123,202,'其它区',3),(2124,203,'驿城区',3),(2125,203,'西平县',3),(2126,203,'上蔡县',3),(2127,203,'平舆县',3),(2128,203,'正阳县',3),(2129,203,'确山县',3),(2130,203,'泌阳县',3),(2131,203,'汝南县',3),(2132,203,'遂平县',3),(2133,203,'新蔡县',3),(2134,203,'其它区',3),(2135,204,'江岸区',3),(2136,204,'江汉区',3),(2137,204,'硚口区',3),(2138,204,'汉阳区',3),(2139,204,'武昌区',3),(2140,204,'青山区',3),(2141,204,'洪山区',3),(2142,204,'东西湖区',3),(2143,204,'汉南区',3),(2144,204,'蔡甸区',3),(2145,204,'江夏区',3),(2146,204,'黄陂区',3),(2147,204,'新洲区',3),(2148,204,'其它区',3),(2149,205,'黄石港区',3),(2150,205,'西塞山区',3),(2151,205,'下陆区',3),(2152,205,'铁山区',3),(2153,205,'阳新县',3),(2154,205,'大冶市',3),(2155,205,'其它区',3),(2156,206,'茅箭区',3),(2157,206,'张湾区',3),(2158,206,'郧阳区',3),(2159,206,'郧西县',3),(2160,206,'竹山县',3),(2161,206,'竹溪县',3),(2162,206,'房县',3),(2163,206,'丹江口市',3),(2164,206,'城区',3),(2165,206,'其它区',3),(2166,207,'西陵区',3),(2167,207,'伍家岗区',3),(2168,207,'点军区',3),(2169,207,'猇亭区',3),(2170,207,'夷陵区',3),(2171,207,'远安县',3),(2172,207,'兴山县',3),(2173,207,'秭归县',3),(2174,207,'长阳土家族自治县',3),(2175,207,'五峰土家族自治县',3),(2176,207,'葛洲坝区',3),(2177,207,'开发区',3),(2178,207,'宜都市',3),(2179,207,'当阳市',3),(2180,207,'枝江市',3),(2181,207,'其它区',3),(2182,208,'襄城区',3),(2183,208,'樊城区',3),(2184,208,'襄州区',3),(2185,208,'南漳县',3),(2186,208,'谷城县',3),(2187,208,'保康县',3),(2188,208,'老河口市',3),(2189,208,'枣阳市',3),(2190,208,'宜城市',3),(2191,208,'其它区',3),(2192,209,'梁子湖区',3),(2193,209,'华容区',3),(2194,209,'鄂城区',3),(2195,209,'其它区',3),(2196,210,'东宝区',3),(2197,210,'掇刀区',3),(2198,210,'京山县',3),(2199,210,'沙洋县',3),(2200,210,'钟祥市',3),(2201,210,'其它区',3),(2202,211,'孝南区',3),(2203,211,'孝昌县',3),(2204,211,'大悟县',3),(2205,211,'云梦县',3),(2206,211,'应城市',3),(2207,211,'安陆市',3),(2208,211,'汉川市',3),(2209,211,'其它区',3),(2210,212,'沙市区',3),(2211,212,'荆州区',3),(2212,212,'公安县',3),(2213,212,'监利县',3),(2214,212,'江陵县',3),(2215,212,'石首市',3),(2216,212,'洪湖市',3),(2217,212,'松滋市',3),(2218,212,'其它区',3),(2219,213,'黄州区',3),(2220,213,'团风县',3),(2221,213,'红安县',3),(2222,213,'罗田县',3),(2223,213,'英山县',3),(2224,213,'浠水县',3),(2225,213,'蕲春县',3),(2226,213,'黄梅县',3),(2227,213,'麻城市',3),(2228,213,'武穴市',3),(2229,213,'其它区',3),(2230,214,'咸安区',3),(2231,214,'嘉鱼县',3),(2232,214,'通城县',3),(2233,214,'崇阳县',3),(2234,214,'通山县',3),(2235,214,'赤壁市',3),(2236,214,'温泉城区',3),(2237,214,'其它区',3),(2238,215,'曾都区',3),(2239,215,'随县',3),(2240,215,'广水市',3),(2241,215,'其它区',3),(2242,216,'恩施市',3),(2243,216,'利川市',3),(2244,216,'建始县',3),(2245,216,'巴东县',3),(2246,216,'宣恩县',3),(2247,216,'咸丰县',3),(2248,216,'来凤县',3),(2249,216,'鹤峰县',3),(2250,216,'其它区',3),(2251,217,'芙蓉区',3),(2252,217,'天心区',3),(2253,217,'岳麓区',3),(2254,217,'开福区',3),(2255,217,'雨花区',3),(2256,217,'长沙县',3),(2257,217,'望城区',3),(2258,217,'宁乡县',3),(2259,217,'浏阳市',3),(2260,217,'其它区',3),(2261,218,'荷塘区',3),(2262,218,'芦淞区',3),(2263,218,'石峰区',3),(2264,218,'天元区',3),(2265,218,'株洲县',3),(2266,218,'攸县',3),(2267,218,'茶陵县',3),(2268,218,'炎陵县',3),(2269,218,'醴陵市',3),(2270,218,'其它区',3),(2271,219,'雨湖区',3),(2272,219,'岳塘区',3),(2273,219,'湘潭县',3),(2274,219,'湘乡市',3),(2275,219,'韶山市',3),(2276,219,'其它区',3),(2277,220,'珠晖区',3),(2278,220,'雁峰区',3),(2279,220,'石鼓区',3),(2280,220,'蒸湘区',3),(2281,220,'南岳区',3),(2282,220,'衡阳县',3),(2283,220,'衡南县',3),(2284,220,'衡山县',3),(2285,220,'衡东县',3),(2286,220,'祁东县',3),(2287,220,'耒阳市',3),(2288,220,'常宁市',3),(2289,220,'其它区',3),(2290,221,'双清区',3),(2291,221,'大祥区',3),(2292,221,'北塔区',3),(2293,221,'邵东县',3),(2294,221,'新邵县',3),(2295,221,'邵阳县',3),(2296,221,'隆回县',3),(2297,221,'洞口县',3),(2298,221,'绥宁县',3),(2299,221,'新宁县',3),(2300,221,'城步苗族自治县',3),(2301,221,'武冈市',3),(2302,221,'其它区',3),(2303,222,'岳阳楼区',3),(2304,222,'云溪区',3),(2305,222,'君山区',3),(2306,222,'岳阳县',3),(2307,222,'华容县',3),(2308,222,'湘阴县',3),(2309,222,'平江县',3),(2310,222,'汨罗市',3),(2311,222,'临湘市',3),(2312,222,'其它区',3),(2313,223,'武陵区',3),(2314,223,'鼎城区',3),(2315,223,'安乡县',3),(2316,223,'汉寿县',3),(2317,223,'澧县',3),(2318,223,'临澧县',3),(2319,223,'桃源县',3),(2320,223,'石门县',3),(2321,223,'津市市',3),(2322,223,'其它区',3),(2323,224,'永定区',3),(2324,224,'武陵源区',3),(2325,224,'慈利县',3),(2326,224,'桑植县',3),(2327,224,'其它区',3),(2328,225,'资阳区',3),(2329,225,'赫山区',3),(2330,225,'南县',3),(2331,225,'桃江县',3),(2332,225,'安化县',3),(2333,225,'沅江市',3),(2334,225,'其它区',3),(2335,226,'北湖区',3),(2336,226,'苏仙区',3),(2337,226,'桂阳县',3),(2338,226,'宜章县',3),(2339,226,'永兴县',3),(2340,226,'嘉禾县',3),(2341,226,'临武县',3),(2342,226,'汝城县',3),(2343,226,'桂东县',3),(2344,226,'安仁县',3),(2345,226,'资兴市',3),(2346,226,'其它区',3),(2347,227,'零陵区',3),(2348,227,'冷水滩区',3),(2349,227,'祁阳县',3),(2350,227,'东安县',3),(2351,227,'双牌县',3),(2352,227,'道县',3),(2353,227,'江永县',3),(2354,227,'宁远县',3),(2355,227,'蓝山县',3),(2356,227,'新田县',3),(2357,227,'江华瑶族自治县',3),(2358,227,'其它区',3),(2359,228,'鹤城区',3),(2360,228,'中方县',3),(2361,228,'沅陵县',3),(2362,228,'辰溪县',3),(2363,228,'溆浦县',3),(2364,228,'会同县',3),(2365,228,'麻阳苗族自治县',3),(2366,228,'新晃侗族自治县',3),(2367,228,'芷江侗族自治县',3),(2368,228,'靖州苗族侗族自治县',3),(2369,228,'通道侗族自治县',3),(2370,228,'洪江市',3),(2371,228,'其它区',3),(2372,229,'娄星区',3),(2373,229,'双峰县',3),(2374,229,'新化县',3),(2375,229,'冷水江市',3),(2376,229,'涟源市',3),(2377,229,'其它区',3),(2378,230,'吉首市',3),(2379,230,'泸溪县',3),(2380,230,'凤凰县',3),(2381,230,'花垣县',3),(2382,230,'保靖县',3),(2383,230,'古丈县',3),(2384,230,'永顺县',3),(2385,230,'龙山县',3),(2386,230,'其它区',3),(2387,231,'荔湾区',3),(2388,231,'越秀区',3),(2389,231,'海珠区',3),(2390,231,'天河区',3),(2391,231,'白云区',3),(2392,231,'黄埔区',3),(2393,231,'番禺区',3),(2394,231,'花都区',3),(2395,231,'南沙区',3),(2396,231,'萝岗区',3),(2397,231,'增城区',3),(2398,231,'从化区',3),(2399,231,'东山区',3),(2400,231,'其它区',3),(2401,232,'武江区',3),(2402,232,'浈江区',3),(2403,232,'曲江区',3),(2404,232,'始兴县',3),(2405,232,'仁化县',3),(2406,232,'翁源县',3),(2407,232,'乳源瑶族自治县',3),(2408,232,'新丰县',3),(2409,232,'乐昌市',3),(2410,232,'南雄市',3),(2411,232,'其它区',3),(2412,233,'罗湖区',3),(2413,233,'福田区',3),(2414,233,'南山区',3),(2415,233,'宝安区',3),(2416,233,'龙岗区',3),(2417,233,'盐田区',3),(2418,233,'其它区',3),(2419,233,'光明新区',3),(2420,233,'坪山新区',3),(2421,233,'大鹏新区',3),(2422,233,'龙华新区',3),(2423,234,'香洲区',3),(2424,234,'斗门区',3),(2425,234,'金湾区',3),(2426,234,'金唐区',3),(2427,234,'南湾区',3),(2428,234,'其它区',3),(2429,235,'龙湖区',3),(2430,235,'金平区',3),(2431,235,'濠江区',3),(2432,235,'潮阳区',3),(2433,235,'潮南区',3),(2434,235,'澄海区',3),(2435,235,'南澳县',3),(2436,235,'其它区',3),(2437,236,'禅城区',3),(2438,236,'南海区',3),(2439,236,'顺德区',3),(2440,236,'三水区',3),(2441,236,'高明区',3),(2442,236,'其它区',3),(2443,237,'蓬江区',3),(2444,237,'江海区',3),(2445,237,'新会区',3),(2446,237,'台山市',3),(2447,237,'开平市',3),(2448,237,'鹤山市',3),(2449,237,'恩平市',3),(2450,237,'其它区',3),(2451,238,'赤坎区',3),(2452,238,'霞山区',3),(2453,238,'坡头区',3),(2454,238,'麻章区',3),(2455,238,'遂溪县',3),(2456,238,'徐闻县',3),(2457,238,'廉江市',3),(2458,238,'雷州市',3),(2459,238,'吴川市',3),(2460,238,'其它区',3),(2461,239,'茂南区',3),(2462,239,'电白区',3),(2463,239,'电白县',3),(2464,239,'高州市',3),(2465,239,'化州市',3),(2466,239,'信宜市',3),(2467,239,'其它区',3),(2468,240,'端州区',3),(2469,240,'鼎湖区',3),(2470,240,'广宁县',3),(2471,240,'怀集县',3),(2472,240,'封开县',3),(2473,240,'德庆县',3),(2474,240,'高要市',3),(2475,240,'四会市',3),(2476,240,'其它区',3),(2477,241,'惠城区',3),(2478,241,'惠阳区',3),(2479,241,'博罗县',3),(2480,241,'惠东县',3),(2481,241,'龙门县',3),(2482,241,'其它区',3),(2483,242,'梅江区',3),(2484,242,'梅县区',3),(2485,242,'大埔县',3),(2486,242,'丰顺县',3),(2487,242,'五华县',3),(2488,242,'平远县',3),(2489,242,'蕉岭县',3),(2490,242,'兴宁市',3),(2491,242,'其它区',3),(2492,243,'城区',3),(2493,243,'海丰县',3),(2494,243,'陆河县',3),(2495,243,'陆丰市',3),(2496,243,'其它区',3),(2497,244,'源城区',3),(2498,244,'紫金县',3),(2499,244,'龙川县',3),(2500,244,'连平县',3),(2501,244,'和平县',3),(2502,244,'东源县',3),(2503,244,'其它区',3),(2504,245,'江城区',3),(2505,245,'阳西县',3),(2506,245,'阳东区',3),(2507,245,'阳春市',3),(2508,245,'其它区',3),(2509,246,'清城区',3),(2510,246,'佛冈县',3),(2511,246,'阳山县',3),(2512,246,'连山壮族瑶族自治县',3),(2513,246,'连南瑶族自治县',3),(2514,246,'清新区',3),(2515,246,'英德市',3),(2516,246,'连州市',3),(2517,246,'其它区',3),(2518,250,'湘桥区',3),(2519,250,'潮安区',3),(2520,250,'饶平县',3),(2521,250,'枫溪区',3),(2522,250,'其它区',3),(2523,251,'榕城区',3),(2524,251,'揭东区',3),(2525,251,'揭西县',3),(2526,251,'惠来县',3),(2527,251,'普宁市',3),(2528,251,'东山区',3),(2529,251,'其它区',3),(2530,252,'云城区',3),(2531,252,'新兴县',3),(2532,252,'郁南县',3),(2533,252,'云安区',3),(2534,252,'罗定市',3),(2535,252,'其它区',3),(2536,253,'兴宁区',3),(2537,253,'青秀区',3),(2538,253,'江南区',3),(2539,253,'西乡塘区',3),(2540,253,'良庆区',3),(2541,253,'邕宁区',3),(2542,253,'武鸣区',3),(2543,253,'隆安县',3),(2544,253,'马山县',3),(2545,253,'上林县',3),(2546,253,'宾阳县',3),(2547,253,'横县',3),(2548,253,'其它区',3),(2549,254,'城中区',3),(2550,254,'鱼峰区',3),(2551,254,'柳南区',3),(2552,254,'柳北区',3),(2553,254,'柳江县',3),(2554,254,'柳城县',3),(2555,254,'鹿寨县',3),(2556,254,'融安县',3),(2557,254,'融水苗族自治县',3),(2558,254,'三江侗族自治县',3),(2559,254,'其它区',3),(2560,255,'秀峰区',3),(2561,255,'叠彩区',3),(2562,255,'象山区',3),(2563,255,'七星区',3),(2564,255,'雁山区',3),(2565,255,'阳朔县',3),(2566,255,'临桂区',3),(2567,255,'灵川县',3),(2568,255,'全州县',3),(2569,255,'兴安县',3),(2570,255,'永福县',3),(2571,255,'灌阳县',3),(2572,255,'龙胜各族自治县',3),(2573,255,'资源县',3),(2574,255,'平乐县',3),(2575,255,'荔浦县',3),(2576,255,'恭城瑶族自治县',3),(2577,255,'其它区',3),(2578,256,'万秀区',3),(2579,256,'蝶山区',3),(2580,256,'长洲区',3),(2581,256,'龙圩区',3),(2582,256,'苍梧县',3),(2583,256,'藤县',3),(2584,256,'蒙山县',3),(2585,256,'岑溪市',3),(2586,256,'其它区',3),(2587,257,'海城区',3),(2588,257,'银海区',3),(2589,257,'铁山港区',3),(2590,257,'合浦县',3),(2591,257,'其它区',3),(2592,258,'港口区',3),(2593,258,'防城区',3),(2594,258,'上思县',3),(2595,258,'东兴市',3),(2596,258,'其它区',3),(2597,259,'钦南区',3),(2598,259,'钦北区',3),(2599,259,'灵山县',3),(2600,259,'浦北县',3),(2601,259,'其它区',3),(2602,260,'港北区',3),(2603,260,'港南区',3),(2604,260,'覃塘区',3),(2605,260,'平南县',3),(2606,260,'桂平市',3),(2607,260,'其它区',3),(2608,261,'玉州区',3),(2609,261,'福绵区',3),(2610,261,'容县',3),(2611,261,'陆川县',3),(2612,261,'博白县',3),(2613,261,'兴业县',3),(2614,261,'北流市',3),(2615,261,'其它区',3),(2616,262,'右江区',3),(2617,262,'田阳县',3),(2618,262,'田东县',3),(2619,262,'平果县',3),(2620,262,'德保县',3),(2621,262,'靖西县',3),(2622,262,'那坡县',3),(2623,262,'凌云县',3),(2624,262,'乐业县',3),(2625,262,'田林县',3),(2626,262,'西林县',3),(2627,262,'隆林各族自治县',3),(2628,262,'其它区',3),(2629,263,'八步区',3),(2630,263,'平桂管理区',3),(2631,263,'昭平县',3),(2632,263,'钟山县',3),(2633,263,'富川瑶族自治县',3),(2634,263,'其它区',3),(2635,264,'金城江区',3),(2636,264,'南丹县',3),(2637,264,'天峨县',3),(2638,264,'凤山县',3),(2639,264,'东兰县',3),(2640,264,'罗城仫佬族自治县',3),(2641,264,'环江毛南族自治县',3),(2642,264,'巴马瑶族自治县',3),(2643,264,'都安瑶族自治县',3),(2644,264,'大化瑶族自治县',3),(2645,264,'宜州市',3),(2646,264,'其它区',3),(2647,265,'兴宾区',3),(2648,265,'忻城县',3),(2649,265,'象州县',3),(2650,265,'武宣县',3),(2651,265,'金秀瑶族自治县',3),(2652,265,'合山市',3),(2653,265,'其它区',3),(2654,266,'江州区',3),(2655,266,'扶绥县',3),(2656,266,'宁明县',3),(2657,266,'龙州县',3),(2658,266,'大新县',3),(2659,266,'天等县',3),(2660,266,'凭祥市',3),(2661,266,'其它区',3),(2662,267,'秀英区',3),(2663,267,'龙华区',3),(2664,267,'琼山区',3),(2665,267,'美兰区',3),(2666,267,'其它区',3),(2667,269,'西沙群岛',3),(2668,269,'南沙群岛',3),(2669,269,'中沙群岛的岛礁及其海域',3),(2670,189,'高新区',3),(2671,189,'其它区',3),(2672,270,'万州区',3),(2673,270,'涪陵区',3),(2674,270,'渝中区',3),(2675,270,'大渡口区',3),(2676,270,'江北区',3),(2677,270,'沙坪坝区',3),(2678,270,'九龙坡区',3),(2679,270,'南岸区',3),(2680,270,'北碚区',3),(2681,270,'万盛区',3),(2682,270,'双桥区',3),(2683,270,'渝北区',3),(2684,270,'巴南区',3),(2685,270,'黔江区',3),(2686,270,'长寿区',3),(2687,270,'綦江区',3),(2688,270,'潼南县',3),(2689,270,'铜梁区',3),(2690,270,'大足区',3),(2691,270,'荣昌县',3),(2692,270,'璧山区',3),(2693,270,'梁平县',3),(2694,270,'城口县',3),(2695,270,'丰都县',3),(2696,270,'垫江县',3),(2697,270,'武隆县',3),(2698,270,'忠县',3),(2699,270,'开县',3),(2700,270,'云阳县',3),(2701,270,'奉节县',3),(2702,270,'巫山县',3),(2703,270,'巫溪县',3),(2704,270,'石柱土家族自治县',3),(2705,270,'秀山土家族苗族自治县',3),(2706,270,'酉阳土家族苗族自治县',3),(2707,270,'彭水苗族土家族自治县',3),(2708,270,'江津区',3),(2709,270,'合川区',3),(2710,270,'永川区',3),(2711,270,'南川区',3),(2712,270,'其它区',3),(2713,271,'锦江区',3),(2714,271,'青羊区',3),(2715,271,'金牛区',3),(2716,271,'武侯区',3),(2717,271,'成华区',3),(2718,271,'龙泉驿区',3),(2719,271,'青白江区',3),(2720,271,'新都区',3),(2721,271,'温江区',3),(2722,271,'金堂县',3),(2723,271,'双流县',3),(2724,271,'郫县',3),(2725,271,'大邑县',3),(2726,271,'蒲江县',3),(2727,271,'新津县',3),(2728,271,'都江堰市',3),(2729,271,'彭州市',3),(2730,271,'邛崃市',3),(2731,271,'崇州市',3),(2732,271,'其它区',3),(2733,272,'自流井区',3),(2734,272,'贡井区',3),(2735,272,'大安区',3),(2736,272,'沿滩区',3),(2737,272,'荣县',3),(2738,272,'富顺县',3),(2739,272,'其它区',3),(2740,273,'东区',3),(2741,273,'西区',3),(2742,273,'仁和区',3),(2743,273,'米易县',3),(2744,273,'盐边县',3),(2745,273,'其它区',3),(2746,274,'江阳区',3),(2747,274,'纳溪区',3),(2748,274,'龙马潭区',3),(2749,274,'泸县',3),(2750,274,'合江县',3),(2751,274,'叙永县',3),(2752,274,'古蔺县',3),(2753,274,'其它区',3),(2754,275,'旌阳区',3),(2755,275,'中江县',3),(2756,275,'罗江县',3),(2757,275,'广汉市',3),(2758,275,'什邡市',3),(2759,275,'绵竹市',3),(2760,275,'其它区',3),(2761,276,'涪城区',3),(2762,276,'游仙区',3),(2763,276,'三台县',3),(2764,276,'盐亭县',3),(2765,276,'安县',3),(2766,276,'梓潼县',3),(2767,276,'北川羌族自治县',3),(2768,276,'平武县',3),(2769,276,'高新区',3),(2770,276,'江油市',3),(2771,276,'其它区',3),(2772,277,'利州区',3),(2773,277,'昭化区',3),(2774,277,'朝天区',3),(2775,277,'旺苍县',3),(2776,277,'青川县',3),(2777,277,'剑阁县',3),(2778,277,'苍溪县',3),(2779,277,'其它区',3),(2780,278,'船山区',3),(2781,278,'安居区',3),(2782,278,'蓬溪县',3),(2783,278,'射洪县',3),(2784,278,'大英县',3),(2785,278,'其它区',3),(2786,279,'市中区',3),(2787,279,'东兴区',3),(2788,279,'威远县',3),(2789,279,'资中县',3),(2790,279,'隆昌县',3),(2791,279,'其它区',3),(2792,280,'市中区',3),(2793,280,'沙湾区',3),(2794,280,'五通桥区',3),(2795,280,'金口河区',3),(2796,280,'犍为县',3),(2797,280,'井研县',3),(2798,280,'夹江县',3),(2799,280,'沐川县',3),(2800,280,'峨边彝族自治县',3),(2801,280,'马边彝族自治县',3),(2802,280,'峨眉山市',3),(2803,280,'其它区',3),(2804,281,'顺庆区',3),(2805,281,'高坪区',3),(2806,281,'嘉陵区',3),(2807,281,'南部县',3),(2808,281,'营山县',3),(2809,281,'蓬安县',3),(2810,281,'仪陇县',3),(2811,281,'西充县',3),(2812,281,'阆中市',3),(2813,281,'其它区',3),(2814,282,'东坡区',3),(2815,282,'仁寿县',3),(2816,282,'彭山区',3),(2817,282,'洪雅县',3),(2818,282,'丹棱县',3),(2819,282,'青神县',3),(2820,282,'其它区',3),(2821,283,'翠屏区',3),(2822,283,'宜宾县',3),(2823,283,'南溪区',3),(2824,283,'江安县',3),(2825,283,'长宁县',3),(2826,283,'高县',3),(2827,283,'珙县',3),(2828,283,'筠连县',3),(2829,283,'兴文县',3),(2830,283,'屏山县',3),(2831,283,'其它区',3),(2832,284,'广安区',3),(2833,284,'前锋区',3),(2834,284,'岳池县',3),(2835,284,'武胜县',3),(2836,284,'邻水县',3),(2837,284,'华蓥市',3),(2838,284,'市辖区',3),(2839,284,'其它区',3),(2840,285,'通川区',3),(2841,285,'达川区',3),(2842,285,'宣汉县',3),(2843,285,'开江县',3),(2844,285,'大竹县',3),(2845,285,'渠县',3),(2846,285,'万源市',3),(2847,285,'其它区',3),(2848,286,'雨城区',3),(2849,286,'名山区',3),(2850,286,'荥经县',3),(2851,286,'汉源县',3),(2852,286,'石棉县',3),(2853,286,'天全县',3),(2854,286,'芦山县',3),(2855,286,'宝兴县',3),(2856,286,'其它区',3),(2857,287,'巴州区',3),(2858,287,'恩阳区',3),(2859,287,'通江县',3),(2860,287,'南江县',3),(2861,287,'平昌县',3),(2862,287,'其它区',3),(2863,288,'雁江区',3),(2864,288,'安岳县',3),(2865,288,'乐至县',3),(2866,288,'简阳市',3),(2867,288,'其它区',3),(2868,289,'汶川县',3),(2869,289,'理县',3),(2870,289,'茂县',3),(2871,289,'松潘县',3),(2872,289,'九寨沟县',3),(2873,289,'金川县',3),(2874,289,'小金县',3),(2875,289,'黑水县',3),(2876,289,'马尔康县',3),(2877,289,'壤塘县',3),(2878,289,'阿坝县',3),(2879,289,'若尔盖县',3),(2880,289,'红原县',3),(2881,289,'其它区',3),(2882,290,'康定市',3),(2883,290,'泸定县',3),(2884,290,'丹巴县',3),(2885,290,'九龙县',3),(2886,290,'雅江县',3),(2887,290,'道孚县',3),(2888,290,'炉霍县',3),(2889,290,'甘孜县',3),(2890,290,'新龙县',3),(2891,290,'德格县',3),(2892,290,'白玉县',3),(2893,290,'石渠县',3),(2894,290,'色达县',3),(2895,290,'理塘县',3),(2896,290,'巴塘县',3),(2897,290,'乡城县',3),(2898,290,'稻城县',3),(2899,290,'得荣县',3),(2900,290,'其它区',3),(2901,291,'西昌市',3),(2902,291,'木里藏族自治县',3),(2903,291,'盐源县',3),(2904,291,'德昌县',3),(2905,291,'会理县',3),(2906,291,'会东县',3),(2907,291,'宁南县',3),(2908,291,'普格县',3),(2909,291,'布拖县',3),(2910,291,'金阳县',3),(2911,291,'昭觉县',3),(2912,291,'喜德县',3),(2913,291,'冕宁县',3),(2914,291,'越西县',3),(2915,291,'甘洛县',3),(2916,291,'美姑县',3),(2917,291,'雷波县',3),(2918,291,'其它区',3),(2919,292,'南明区',3),(2920,292,'云岩区',3),(2921,292,'花溪区',3),(2922,292,'乌当区',3),(2923,292,'白云区',3),(2924,292,'小河区',3),(2925,292,'开阳县',3),(2926,292,'息烽县',3),(2927,292,'修文县',3),(2928,292,'观山湖区',3),(2929,292,'清镇市',3),(2930,292,'其它区',3),(2931,293,'钟山区',3),(2932,293,'六枝特区',3),(2933,293,'水城县',3),(2934,293,'盘县',3),(2935,293,'其它区',3),(2936,294,'红花岗区',3),(2937,294,'汇川区',3),(2938,294,'遵义县',3),(2939,294,'桐梓县',3),(2940,294,'绥阳县',3),(2941,294,'正安县',3),(2942,294,'道真仡佬族苗族自治县',3),(2943,294,'务川仡佬族苗族自治县',3),(2944,294,'凤冈县',3),(2945,294,'湄潭县',3),(2946,294,'余庆县',3),(2947,294,'习水县',3),(2948,294,'赤水市',3),(2949,294,'仁怀市',3),(2950,294,'其它区',3),(2951,295,'西秀区',3),(2952,295,'平坝区',3),(2953,295,'普定县',3),(2954,295,'镇宁布依族苗族自治县',3),(2955,295,'关岭布依族苗族自治县',3),(2956,295,'紫云苗族布依族自治县',3),(2957,295,'其它区',3),(2958,296,'碧江区',3),(2959,296,'江口县',3),(2960,296,'玉屏侗族自治县',3),(2961,296,'石阡县',3),(2962,296,'思南县',3),(2963,296,'印江土家族苗族自治县',3),(2964,296,'德江县',3),(2965,296,'沿河土家族自治县',3),(2966,296,'松桃苗族自治县',3),(2967,296,'万山区',3),(2968,296,'其它区',3),(2969,297,'兴义市',3),(2970,297,'兴仁县',3),(2971,297,'普安县',3),(2972,297,'晴隆县',3),(2973,297,'贞丰县',3),(2974,297,'望谟县',3),(2975,297,'册亨县',3),(2976,297,'安龙县',3),(2977,297,'其它区',3),(2978,298,'七星关区',3),(2979,298,'大方县',3),(2980,298,'黔西县',3),(2981,298,'金沙县',3),(2982,298,'织金县',3),(2983,298,'纳雍县',3),(2984,298,'威宁彝族回族苗族自治县',3),(2985,298,'赫章县',3),(2986,298,'其它区',3),(2987,299,'凯里市',3),(2988,299,'黄平县',3),(2989,299,'施秉县',3),(2990,299,'三穗县',3),(2991,299,'镇远县',3),(2992,299,'岑巩县',3),(2993,299,'天柱县',3),(2994,299,'锦屏县',3),(2995,299,'剑河县',3),(2996,299,'台江县',3),(2997,299,'黎平县',3),(2998,299,'榕江县',3),(2999,299,'从江县',3),(3000,299,'雷山县',3),(3001,299,'麻江县',3),(3002,299,'丹寨县',3),(3003,299,'其它区',3),(3004,300,'都匀市',3),(3005,300,'福泉市',3),(3006,300,'荔波县',3),(3007,300,'贵定县',3),(3008,300,'瓮安县',3),(3009,300,'独山县',3),(3010,300,'平塘县',3),(3011,300,'罗甸县',3),(3012,300,'长顺县',3),(3013,300,'龙里县',3),(3014,300,'惠水县',3),(3015,300,'三都水族自治县',3),(3016,300,'其它区',3),(3017,301,'五华区',3),(3018,301,'盘龙区',3),(3019,301,'官渡区',3),(3020,301,'西山区',3),(3021,301,'东川区',3),(3022,301,'呈贡区',3),(3023,301,'晋宁县',3),(3024,301,'富民县',3),(3025,301,'宜良县',3),(3026,301,'石林彝族自治县',3),(3027,301,'嵩明县',3),(3028,301,'禄劝彝族苗族自治县',3),(3029,301,'寻甸回族彝族自治县',3),(3030,301,'安宁市',3),(3031,301,'其它区',3),(3032,302,'麒麟区',3),(3033,302,'马龙县',3),(3034,302,'陆良县',3),(3035,302,'师宗县',3),(3036,302,'罗平县',3),(3037,302,'富源县',3),(3038,302,'会泽县',3),(3039,302,'沾益县',3),(3040,302,'宣威市',3),(3041,302,'其它区',3),(3042,303,'红塔区',3),(3043,303,'江川县',3),(3044,303,'澄江县',3),(3045,303,'通海县',3),(3046,303,'华宁县',3),(3047,303,'易门县',3),(3048,303,'峨山彝族自治县',3),(3049,303,'新平彝族傣族自治县',3),(3050,303,'元江哈尼族彝族傣族自治县',3),(3051,303,'其它区',3),(3052,304,'隆阳区',3),(3053,304,'施甸县',3),(3054,304,'腾冲县',3),(3055,304,'龙陵县',3),(3056,304,'昌宁县',3),(3057,304,'其它区',3),(3058,305,'昭阳区',3),(3059,305,'鲁甸县',3),(3060,305,'巧家县',3),(3061,305,'盐津县',3),(3062,305,'大关县',3),(3063,305,'永善县',3),(3064,305,'绥江县',3),(3065,305,'镇雄县',3),(3066,305,'彝良县',3),(3067,305,'威信县',3),(3068,305,'水富县',3),(3069,305,'其它区',3),(3070,306,'古城区',3),(3071,306,'玉龙纳西族自治县',3),(3072,306,'永胜县',3),(3073,306,'华坪县',3),(3074,306,'宁蒗彝族自治县',3),(3075,306,'其它区',3),(3076,307,'思茅区',3),(3077,307,'宁洱哈尼族彝族自治县',3),(3078,307,'墨江哈尼族自治县',3),(3079,307,'景东彝族自治县',3),(3080,307,'景谷傣族彝族自治县',3),(3081,307,'镇沅彝族哈尼族拉祜族自治县',3),(3082,307,'江城哈尼族彝族自治县',3),(3083,307,'孟连傣族拉祜族佤族自治县',3),(3084,307,'澜沧拉祜族自治县',3),(3085,307,'西盟佤族自治县',3),(3086,307,'其它区',3),(3087,308,'临翔区',3),(3088,308,'凤庆县',3),(3089,308,'云县',3),(3090,308,'永德县',3),(3091,308,'镇康县',3),(3092,308,'双江拉祜族佤族布朗族傣族自治县',3),(3093,308,'耿马傣族佤族自治县',3),(3094,308,'沧源佤族自治县',3),(3095,308,'其它区',3),(3096,309,'楚雄市',3),(3097,309,'双柏县',3),(3098,309,'牟定县',3),(3099,309,'南华县',3),(3100,309,'姚安县',3),(3101,309,'大姚县',3),(3102,309,'永仁县',3),(3103,309,'元谋县',3),(3104,309,'武定县',3),(3105,309,'禄丰县',3),(3106,309,'其它区',3),(3107,310,'个旧市',3),(3108,310,'开远市',3),(3109,310,'蒙自市',3),(3110,310,'屏边苗族自治县',3),(3111,310,'建水县',3),(3112,310,'石屏县',3),(3113,310,'弥勒市',3),(3114,310,'泸西县',3),(3115,310,'元阳县',3),(3116,310,'红河县',3),(3117,310,'金平苗族瑶族傣族自治县',3),(3118,310,'绿春县',3),(3119,310,'河口瑶族自治县',3),(3120,310,'其它区',3),(3121,311,'文山市',3),(3122,311,'砚山县',3),(3123,311,'西畴县',3),(3124,311,'麻栗坡县',3),(3125,311,'马关县',3),(3126,311,'丘北县',3),(3127,311,'广南县',3),(3128,311,'富宁县',3),(3129,311,'其它区',3),(3130,312,'景洪市',3),(3131,312,'勐海县',3),(3132,312,'勐腊县',3),(3133,312,'其它区',3),(3134,313,'大理市',3),(3135,313,'漾濞彝族自治县',3),(3136,313,'祥云县',3),(3137,313,'宾川县',3),(3138,313,'弥渡县',3),(3139,313,'南涧彝族自治县',3),(3140,313,'巍山彝族回族自治县',3),(3141,313,'永平县',3),(3142,313,'云龙县',3),(3143,313,'洱源县',3),(3144,313,'剑川县',3),(3145,313,'鹤庆县',3),(3146,313,'其它区',3),(3147,314,'瑞丽市',3),(3148,314,'芒市',3),(3149,314,'梁河县',3),(3150,314,'盈江县',3),(3151,314,'陇川县',3),(3152,314,'其它区',3),(3153,315,'泸水县',3),(3154,315,'福贡县',3),(3155,315,'贡山独龙族怒族自治县',3),(3156,315,'兰坪白族普米族自治县',3),(3157,315,'其它区',3),(3158,316,'香格里拉市',3),(3159,316,'德钦县',3),(3160,316,'维西傈僳族自治县',3),(3161,316,'其它区',3),(3162,317,'城关区',3),(3163,317,'林周县',3),(3164,317,'当雄县',3),(3165,317,'尼木县',3),(3166,317,'曲水县',3),(3167,317,'堆龙德庆县',3),(3168,317,'达孜县',3),(3169,317,'墨竹工卡县',3),(3170,317,'其它区',3),(3171,318,'卡若区',3),(3172,318,'江达县',3),(3173,318,'贡觉县',3),(3174,318,'类乌齐县',3),(3175,318,'丁青县',3),(3176,318,'察雅县',3),(3177,318,'八宿县',3),(3178,318,'左贡县',3),(3179,318,'芒康县',3),(3180,318,'洛隆县',3),(3181,318,'边坝县',3),(3182,318,'其它区',3),(3183,319,'乃东县',3),(3184,319,'扎囊县',3),(3185,319,'贡嘎县',3),(3186,319,'桑日县',3),(3187,319,'琼结县',3),(3188,319,'曲松县',3),(3189,319,'措美县',3),(3190,319,'洛扎县',3),(3191,319,'加查县',3),(3192,319,'隆子县',3),(3193,319,'错那县',3),(3194,319,'浪卡子县',3),(3195,319,'其它区',3),(3196,320,'桑珠孜区',3),(3197,320,'南木林县',3),(3198,320,'江孜县',3),(3199,320,'定日县',3),(3200,320,'萨迦县',3),(3201,320,'拉孜县',3),(3202,320,'昂仁县',3),(3203,320,'谢通门县',3),(3204,320,'白朗县',3),(3205,320,'仁布县',3),(3206,320,'康马县',3),(3207,320,'定结县',3),(3208,320,'仲巴县',3),(3209,320,'亚东县',3),(3210,320,'吉隆县',3),(3211,320,'聂拉木县',3),(3212,320,'萨嘎县',3),(3213,320,'岗巴县',3),(3214,320,'其它区',3),(3215,321,'那曲县',3),(3216,321,'嘉黎县',3),(3217,321,'比如县',3),(3218,321,'聂荣县',3),(3219,321,'安多县',3),(3220,321,'申扎县',3),(3221,321,'索县',3),(3222,321,'班戈县',3),(3223,321,'巴青县',3),(3224,321,'尼玛县',3),(3225,321,'其它区',3),(3226,321,'双湖县',3),(3227,322,'普兰县',3),(3228,322,'札达县',3),(3229,322,'噶尔县',3),(3230,322,'日土县',3),(3231,322,'革吉县',3),(3232,322,'改则县',3),(3233,322,'措勤县',3),(3234,322,'其它区',3),(3235,323,'巴宜区',3),(3236,323,'工布江达县',3),(3237,323,'米林县',3),(3238,323,'墨脱县',3),(3239,323,'波密县',3),(3240,323,'察隅县',3),(3241,323,'朗县',3),(3242,323,'其它区',3),(3243,324,'新城区',3),(3244,324,'碑林区',3),(3245,324,'莲湖区',3),(3246,324,'灞桥区',3),(3247,324,'未央区',3),(3248,324,'雁塔区',3),(3249,324,'阎良区',3),(3250,324,'临潼区',3),(3251,324,'长安区',3),(3252,324,'蓝田县',3),(3253,324,'周至县',3),(3254,324,'户县',3),(3255,324,'高陵区',3),(3256,324,'其它区',3),(3257,325,'王益区',3),(3258,325,'印台区',3),(3259,325,'耀州区',3),(3260,325,'宜君县',3),(3261,325,'其它区',3),(3262,326,'渭滨区',3),(3263,326,'金台区',3),(3264,326,'陈仓区',3),(3265,326,'凤翔县',3),(3266,326,'岐山县',3),(3267,326,'扶风县',3),(3268,326,'眉县',3),(3269,326,'陇县',3),(3270,326,'千阳县',3),(3271,326,'麟游县',3),(3272,326,'凤县',3),(3273,326,'太白县',3),(3274,326,'其它区',3),(3275,327,'秦都区',3),(3276,327,'杨陵区',3),(3277,327,'渭城区',3),(3278,327,'三原县',3),(3279,327,'泾阳县',3),(3280,327,'乾县',3),(3281,327,'礼泉县',3),(3282,327,'永寿县',3),(3283,327,'彬县',3),(3284,327,'长武县',3),(3285,327,'旬邑县',3),(3286,327,'淳化县',3),(3287,327,'武功县',3),(3288,327,'兴平市',3),(3289,327,'其它区',3),(3290,328,'临渭区',3),(3291,328,'华县',3),(3292,328,'潼关县',3),(3293,328,'大荔县',3),(3294,328,'合阳县',3),(3295,328,'澄城县',3),(3296,328,'蒲城县',3),(3297,328,'白水县',3),(3298,328,'富平县',3),(3299,328,'韩城市',3),(3300,328,'华阴市',3),(3301,328,'其它区',3),(3302,329,'宝塔区',3),(3303,329,'延长县',3),(3304,329,'延川县',3),(3305,329,'子长县',3),(3306,329,'安塞县',3),(3307,329,'志丹县',3),(3308,329,'吴起县',3),(3309,329,'甘泉县',3),(3310,329,'富县',3),(3311,329,'洛川县',3),(3312,329,'宜川县',3),(3313,329,'黄龙县',3),(3314,329,'黄陵县',3),(3315,329,'其它区',3),(3316,330,'汉台区',3),(3317,330,'南郑县',3),(3318,330,'城固县',3),(3319,330,'洋县',3),(3320,330,'西乡县',3),(3321,330,'勉县',3),(3322,330,'宁强县',3),(3323,330,'略阳县',3),(3324,330,'镇巴县',3),(3325,330,'留坝县',3),(3326,330,'佛坪县',3),(3327,330,'其它区',3),(3328,331,'榆阳区',3),(3329,331,'神木县',3),(3330,331,'府谷县',3),(3331,331,'横山县',3),(3332,331,'靖边县',3),(3333,331,'定边县',3),(3334,331,'绥德县',3),(3335,331,'米脂县',3),(3336,331,'佳县',3),(3337,331,'吴堡县',3),(3338,331,'清涧县',3),(3339,331,'子洲县',3),(3340,331,'其它区',3),(3341,332,'汉滨区',3),(3342,332,'汉阴县',3),(3343,332,'石泉县',3),(3344,332,'宁陕县',3),(3345,332,'紫阳县',3),(3346,332,'岚皋县',3),(3347,332,'平利县',3),(3348,332,'镇坪县',3),(3349,332,'旬阳县',3),(3350,332,'白河县',3),(3351,332,'其它区',3),(3352,333,'商州区',3),(3353,333,'洛南县',3),(3354,333,'丹凤县',3),(3355,333,'商南县',3),(3356,333,'山阳县',3),(3357,333,'镇安县',3),(3358,333,'柞水县',3),(3359,333,'其它区',3),(3360,334,'城关区',3),(3361,334,'七里河区',3),(3362,334,'西固区',3),(3363,334,'安宁区',3),(3364,334,'红古区',3),(3365,334,'永登县',3),(3366,334,'皋兰县',3),(3367,334,'榆中县',3),(3368,334,'其它区',3),(3369,336,'金川区',3),(3370,336,'永昌县',3),(3371,336,'其它区',3),(3372,337,'白银区',3),(3373,337,'平川区',3),(3374,337,'靖远县',3),(3375,337,'会宁县',3),(3376,337,'景泰县',3),(3377,337,'其它区',3),(3378,338,'秦州区',3),(3379,338,'麦积区',3),(3380,338,'清水县',3),(3381,338,'秦安县',3),(3382,338,'甘谷县',3),(3383,338,'武山县',3),(3384,338,'张家川回族自治县',3),(3385,338,'其它区',3),(3386,339,'凉州区',3),(3387,339,'民勤县',3),(3388,339,'古浪县',3),(3389,339,'天祝藏族自治县',3),(3390,339,'其它区',3),(3391,340,'甘州区',3),(3392,340,'肃南裕固族自治县',3),(3393,340,'民乐县',3),(3394,340,'临泽县',3),(3395,340,'高台县',3),(3396,340,'山丹县',3),(3397,340,'其它区',3),(3398,341,'崆峒区',3),(3399,341,'泾川县',3),(3400,341,'灵台县',3),(3401,341,'崇信县',3),(3402,341,'华亭县',3),(3403,341,'庄浪县',3),(3404,341,'静宁县',3),(3405,341,'其它区',3),(3406,342,'肃州区',3),(3407,342,'金塔县',3),(3408,342,'瓜州县',3),(3409,342,'肃北蒙古族自治县',3),(3410,342,'阿克塞哈萨克族自治县',3),(3411,342,'玉门市',3),(3412,342,'敦煌市',3),(3413,342,'其它区',3),(3414,343,'西峰区',3),(3415,343,'庆城县',3),(3416,343,'环县',3),(3417,343,'华池县',3),(3418,343,'合水县',3),(3419,343,'正宁县',3),(3420,343,'宁县',3),(3421,343,'镇原县',3),(3422,343,'其它区',3),(3423,344,'安定区',3),(3424,344,'通渭县',3),(3425,344,'陇西县',3),(3426,344,'渭源县',3),(3427,344,'临洮县',3),(3428,344,'漳县',3),(3429,344,'岷县',3),(3430,344,'其它区',3),(3431,345,'武都区',3),(3432,345,'成县',3),(3433,345,'文县',3),(3434,345,'宕昌县',3),(3435,345,'康县',3),(3436,345,'西和县',3),(3437,345,'礼县',3),(3438,345,'徽县',3),(3439,345,'两当县',3),(3440,345,'其它区',3),(3441,346,'临夏市',3),(3442,346,'临夏县',3),(3443,346,'康乐县',3),(3444,346,'永靖县',3),(3445,346,'广河县',3),(3446,346,'和政县',3),(3447,346,'东乡族自治县',3),(3448,346,'积石山保安族东乡族撒拉族自治县',3),(3449,346,'其它区',3),(3450,347,'合作市',3),(3451,347,'临潭县',3),(3452,347,'卓尼县',3),(3453,347,'舟曲县',3),(3454,347,'迭部县',3),(3455,347,'玛曲县',3),(3456,347,'碌曲县',3),(3457,347,'夏河县',3),(3458,347,'其它区',3),(3459,348,'城东区',3),(3460,348,'城中区',3),(3461,348,'城西区',3),(3462,348,'城北区',3),(3463,348,'大通回族土族自治县',3),(3464,348,'湟中县',3),(3465,348,'湟源县',3),(3466,348,'其它区',3),(3467,349,'平安区',3),(3468,349,'民和回族土族自治县',3),(3469,349,'乐都区',3),(3470,349,'互助土族自治县',3),(3471,349,'化隆回族自治县',3),(3472,349,'循化撒拉族自治县',3),(3473,349,'其它区',3),(3474,350,'门源回族自治县',3),(3475,350,'祁连县',3),(3476,350,'海晏县',3),(3477,350,'刚察县',3),(3478,350,'其它区',3),(3479,351,'同仁县',3),(3480,351,'尖扎县',3),(3481,351,'泽库县',3),(3482,351,'河南蒙古族自治县',3),(3483,351,'其它区',3),(3484,352,'共和县',3),(3485,352,'同德县',3),(3486,352,'贵德县',3),(3487,352,'兴海县',3),(3488,352,'贵南县',3),(3489,352,'其它区',3),(3490,353,'玛沁县',3),(3491,353,'班玛县',3),(3492,353,'甘德县',3),(3493,353,'达日县',3),(3494,353,'久治县',3),(3495,353,'玛多县',3),(3496,353,'其它区',3),(3497,354,'玉树市',3),(3498,354,'杂多县',3),(3499,354,'称多县',3),(3500,354,'治多县',3),(3501,354,'囊谦县',3),(3502,354,'曲麻莱县',3),(3503,354,'其它区',3),(3504,355,'格尔木市',3),(3505,355,'德令哈市',3),(3506,355,'乌兰县',3),(3507,355,'都兰县',3),(3508,355,'天峻县',3),(3509,355,'其它区',3),(3510,356,'兴庆区',3),(3511,356,'西夏区',3),(3512,356,'金凤区',3),(3513,356,'永宁县',3),(3514,356,'贺兰县',3),(3515,356,'灵武市',3),(3516,356,'其它区',3),(3517,357,'大武口区',3),(3518,357,'惠农区',3),(3519,357,'平罗县',3),(3520,357,'其它区',3),(3521,358,'利通区',3),(3522,358,'红寺堡区',3),(3523,358,'盐池县',3),(3524,358,'同心县',3),(3525,358,'青铜峡市',3),(3526,358,'其它区',3),(3527,359,'原州区',3),(3528,359,'西吉县',3),(3529,359,'隆德县',3),(3530,359,'泾源县',3),(3531,359,'彭阳县',3),(3532,359,'其它区',3),(3533,360,'沙坡头区',3),(3534,360,'中宁县',3),(3535,360,'海原县',3),(3536,360,'其它区',3),(3537,361,'天山区',3),(3538,361,'沙依巴克区',3),(3539,361,'新市区',3),(3540,361,'水磨沟区',3),(3541,361,'头屯河区',3),(3542,361,'达坂城区',3),(3543,361,'东山区',3),(3544,361,'米东区',3),(3545,361,'乌鲁木齐县',3),(3546,361,'其它区',3),(3547,362,'独山子区',3),(3548,362,'克拉玛依区',3),(3549,362,'白碱滩区',3),(3550,362,'乌尔禾区',3),(3551,362,'其它区',3),(3552,363,'高昌区',3),(3553,363,'鄯善县',3),(3554,363,'托克逊县',3),(3555,363,'其它区',3),(3556,364,'哈密市',3),(3557,364,'巴里坤哈萨克自治县',3),(3558,364,'伊吾县',3),(3559,364,'其它区',3),(3560,365,'昌吉市',3),(3561,365,'阜康市',3),(3562,365,'米泉市',3),(3563,365,'呼图壁县',3),(3564,365,'玛纳斯县',3),(3565,365,'奇台县',3),(3566,365,'吉木萨尔县',3),(3567,365,'木垒哈萨克自治县',3),(3568,365,'其它区',3),(3569,366,'博乐市',3),(3570,366,'阿拉山口市',3),(3571,366,'精河县',3),(3572,366,'温泉县',3),(3573,366,'其它区',3),(3574,367,'库尔勒市',3),(3575,367,'轮台县',3),(3576,367,'尉犁县',3),(3577,367,'若羌县',3),(3578,367,'且末县',3),(3579,367,'焉耆回族自治县',3),(3580,367,'和静县',3),(3581,367,'和硕县',3),(3582,367,'博湖县',3),(3583,367,'其它区',3),(3584,368,'阿克苏市',3),(3585,368,'温宿县',3),(3586,368,'库车县',3),(3587,368,'沙雅县',3),(3588,368,'新和县',3),(3589,368,'拜城县',3),(3590,368,'乌什县',3),(3591,368,'阿瓦提县',3),(3592,368,'柯坪县',3),(3593,368,'其它区',3),(3594,369,'阿图什市',3),(3595,369,'阿克陶县',3),(3596,369,'阿合奇县',3),(3597,369,'乌恰县',3),(3598,369,'其它区',3),(3599,370,'喀什市',3),(3600,370,'疏附县',3),(3601,370,'疏勒县',3),(3602,370,'英吉沙县',3),(3603,370,'泽普县',3),(3604,370,'莎车县',3),(3605,370,'叶城县',3),(3606,370,'麦盖提县',3),(3607,370,'岳普湖县',3),(3608,370,'伽师县',3),(3609,370,'巴楚县',3),(3610,370,'塔什库尔干塔吉克自治县',3),(3611,370,'其它区',3),(3612,371,'和田市',3),(3613,371,'和田县',3),(3614,371,'墨玉县',3),(3615,371,'皮山县',3),(3616,371,'洛浦县',3),(3617,371,'策勒县',3),(3618,371,'于田县',3),(3619,371,'民丰县',3),(3620,371,'其它区',3),(3621,372,'伊宁市',3),(3622,372,'奎屯市',3),(3623,372,'伊宁县',3),(3624,372,'察布查尔锡伯自治县',3),(3625,372,'霍城县',3),(3626,372,'巩留县',3),(3627,372,'新源县',3),(3628,372,'昭苏县',3),(3629,372,'特克斯县',3),(3630,372,'尼勒克县',3),(3631,372,'其它区',3),(3632,373,'塔城市',3),(3633,373,'乌苏市',3),(3634,373,'额敏县',3),(3635,373,'沙湾县',3),(3636,373,'托里县',3),(3637,373,'裕民县',3),(3638,373,'和布克赛尔蒙古自治县',3),(3639,373,'其它区',3),(3640,374,'阿勒泰市',3),(3641,374,'布尔津县',3),(3642,374,'富蕴县',3),(3643,374,'福海县',3),(3644,374,'哈巴河县',3),(3645,374,'青河县',3),(3646,374,'吉木乃县',3),(3647,374,'其它区',3),(3648,375,'中正区',3),(3649,375,'大同区',3),(3650,375,'中山区',3),(3651,375,'松山区',3),(3652,375,'大安区',3),(3653,375,'万华区',3),(3654,375,'信义区',3),(3655,375,'士林区',3),(3656,375,'北投区',3),(3657,375,'内湖区',3),(3658,375,'南港区',3),(3659,375,'文山区',3),(3660,375,'其它区',3),(3661,376,'新兴区',3),(3662,376,'前金区',3),(3663,376,'芩雅区',3),(3664,376,'盐埕区',3),(3665,376,'鼓山区',3),(3666,376,'旗津区',3),(3667,376,'前镇区',3),(3668,376,'三民区',3),(3669,376,'左营区',3),(3670,376,'楠梓区',3),(3671,376,'小港区',3),(3672,376,'其它区',3),(3673,376,'苓雅区',3),(3674,376,'仁武区',3),(3675,376,'大社区',3),(3676,376,'冈山区',3),(3677,376,'路竹区',3),(3678,376,'阿莲区',3),(3679,376,'田寮区',3),(3680,376,'燕巢区',3),(3681,376,'桥头区',3),(3682,376,'梓官区',3),(3683,376,'弥陀区',3),(3684,376,'永安区',3),(3685,376,'湖内区',3),(3686,376,'凤山区',3),(3687,376,'大寮区',3),(3688,376,'林园区',3),(3689,376,'鸟松区',3),(3690,376,'大树区',3),(3691,376,'旗山区',3),(3692,376,'美浓区',3),(3693,376,'六龟区',3),(3694,376,'内门区',3),(3695,376,'杉林区',3),(3696,376,'甲仙区',3),(3697,376,'桃源区',3),(3698,376,'那玛夏区',3),(3699,376,'茂林区',3),(3700,376,'茄萣区',3),(3701,377,'中西区',3),(3702,377,'东区',3),(3703,377,'南区',3),(3704,377,'北区',3),(3705,377,'安平区',3),(3706,377,'安南区',3),(3707,377,'其它区',3),(3708,377,'永康区',3),(3709,377,'归仁区',3),(3710,377,'新化区',3),(3711,377,'左镇区',3),(3712,377,'玉井区',3),(3713,377,'楠西区',3),(3714,377,'南化区',3),(3715,377,'仁德区',3),(3716,377,'关庙区',3),(3717,377,'龙崎区',3),(3718,377,'官田区',3),(3719,377,'麻豆区',3),(3720,377,'佳里区',3),(3721,377,'西港区',3),(3722,377,'七股区',3),(3723,377,'将军区',3),(3724,377,'学甲区',3),(3725,377,'北门区',3),(3726,377,'新营区',3),(3727,377,'后壁区',3),(3728,377,'白河区',3),(3729,377,'东山区',3),(3730,377,'六甲区',3),(3731,377,'下营区',3),(3732,377,'柳营区',3),(3733,377,'盐水区',3),(3734,377,'善化区',3),(3735,377,'大内区',3),(3736,377,'山上区',3),(3737,377,'新市区',3),(3738,377,'安定区',3),(3739,378,'中区',3),(3740,378,'东区',3),(3741,378,'南区',3),(3742,378,'西区',3),(3743,378,'北区',3),(3744,378,'北屯区',3),(3745,378,'西屯区',3),(3746,378,'南屯区',3),(3747,378,'其它区',3),(3748,378,'太平区',3),(3749,378,'大里区',3),(3750,378,'雾峰区',3),(3751,378,'乌日区',3),(3752,378,'丰原区',3),(3753,378,'后里区',3),(3754,378,'石冈区',3),(3755,378,'东势区',3),(3756,378,'和平区',3),(3757,378,'新社区',3),(3758,378,'潭子区',3),(3759,378,'大雅区',3),(3760,378,'神冈区',3),(3761,378,'大肚区',3),(3762,378,'沙鹿区',3),(3763,378,'龙井区',3),(3764,378,'梧栖区',3),(3765,378,'清水区',3),(3766,378,'大甲区',3),(3767,378,'外埔区',3),(3768,378,'大安区',3),(3769,379,'金沙镇',3),(3770,379,'金湖镇',3),(3771,379,'金宁乡',3),(3772,379,'金城镇',3),(3773,379,'烈屿乡',3),(3774,379,'乌坵乡',3),(3775,380,'南投市',3),(3776,380,'中寮乡',3),(3777,380,'草屯镇',3),(3778,380,'国姓乡',3),(3779,380,'埔里镇',3),(3780,380,'仁爱乡',3),(3781,380,'名间乡',3),(3782,380,'集集镇',3),(3783,380,'水里乡',3),(3784,380,'鱼池乡',3),(3785,380,'信义乡',3),(3786,380,'竹山镇',3),(3787,380,'鹿谷乡',3),(3788,381,'仁爱区',3),(3789,381,'信义区',3),(3790,381,'中正区',3),(3791,381,'中山区',3),(3792,381,'安乐区',3),(3793,381,'暖暖区',3),(3794,381,'七堵区',3),(3795,381,'其它区',3),(3796,382,'东区',3),(3797,382,'北区',3),(3798,382,'香山区',3),(3799,382,'其它区',3),(3800,383,'东区',3),(3801,383,'西区',3),(3802,383,'其它区',3),(3803,384,'万里区',3),(3804,384,'金山区',3),(3805,384,'板桥区',3),(3806,384,'汐止区',3),(3807,384,'深坑区',3),(3808,384,'石碇区',3),(3809,384,'瑞芳区',3),(3810,384,'平溪区',3),(3811,384,'双溪区',3),(3812,384,'贡寮区',3),(3813,384,'新店区',3),(3814,384,'坪林区',3),(3815,384,'乌来区',3),(3816,384,'永和区',3),(3817,384,'中和区',3),(3818,384,'土城区',3),(3819,384,'三峡区',3),(3820,384,'树林区',3),(3821,384,'莺歌区',3),(3822,384,'三重区',3),(3823,384,'新庄区',3),(3824,384,'泰山区',3),(3825,384,'林口区',3),(3826,384,'芦洲区',3),(3827,384,'五股区',3),(3828,384,'八里区',3),(3829,384,'淡水区',3),(3830,384,'三芝区',3),(3831,384,'石门区',3),(3832,385,'宜兰市',3),(3833,385,'头城镇',3),(3834,385,'礁溪乡',3),(3835,385,'壮围乡',3),(3836,385,'员山乡',3),(3837,385,'罗东镇',3),(3838,385,'三星乡',3),(3839,385,'大同乡',3),(3840,385,'五结乡',3),(3841,385,'冬山乡',3),(3842,385,'苏澳镇',3),(3843,385,'南澳乡',3),(3844,385,'钓鱼台',3),(3845,386,'竹北市',3),(3846,386,'湖口乡',3),(3847,386,'新丰乡',3),(3848,386,'新埔镇',3),(3849,386,'关西镇',3),(3850,386,'芎林乡',3),(3851,386,'宝山乡',3),(3852,386,'竹东镇',3),(3853,386,'五峰乡',3),(3854,386,'横山乡',3),(3855,386,'尖石乡',3),(3856,386,'北埔乡',3),(3857,386,'峨眉乡',3),(3858,387,'中坜市',3),(3859,387,'平镇市',3),(3860,387,'龙潭乡',3),(3861,387,'杨梅市',3),(3862,387,'新屋乡',3),(3863,387,'观音乡',3),(3864,387,'桃园市',3),(3865,387,'龟山乡',3),(3866,387,'八德市',3),(3867,387,'大溪镇',3),(3868,387,'复兴乡',3),(3869,387,'大园乡',3),(3870,387,'芦竹乡',3),(3871,388,'竹南镇',3),(3872,388,'头份镇',3),(3873,388,'三湾乡',3),(3874,388,'南庄乡',3),(3875,388,'狮潭乡',3),(3876,388,'后龙镇',3),(3877,388,'通霄镇',3),(3878,388,'苑里镇',3),(3879,388,'苗栗市',3),(3880,388,'造桥乡',3),(3881,388,'头屋乡',3),(3882,388,'公馆乡',3),(3883,388,'大湖乡',3),(3884,388,'泰安乡',3),(3885,388,'铜锣乡',3),(3886,388,'三义乡',3),(3887,388,'西湖乡',3),(3888,388,'卓兰镇',3),(3889,389,'彰化市',3),(3890,389,'芬园乡',3),(3891,389,'花坛乡',3),(3892,389,'秀水乡',3),(3893,389,'鹿港镇',3),(3894,389,'福兴乡',3),(3895,389,'线西乡',3),(3896,389,'和美镇',3),(3897,389,'伸港乡',3),(3898,389,'员林镇',3),(3899,389,'社头乡',3),(3900,389,'永靖乡',3),(3901,389,'埔心乡',3),(3902,389,'溪湖镇',3),(3903,389,'大村乡',3),(3904,389,'埔盐乡',3),(3905,389,'田中镇',3),(3906,389,'北斗镇',3),(3907,389,'田尾乡',3),(3908,389,'埤头乡',3),(3909,389,'溪州乡',3),(3910,389,'竹塘乡',3),(3911,389,'二林镇',3),(3912,389,'大城乡',3),(3913,389,'芳苑乡',3),(3914,389,'二水乡',3),(3915,390,'番路乡',3),(3916,390,'梅山乡',3),(3917,390,'竹崎乡',3),(3918,390,'阿里山乡',3),(3919,390,'中埔乡',3),(3920,390,'大埔乡',3),(3921,390,'水上乡',3),(3922,390,'鹿草乡',3),(3923,390,'太保市',3),(3924,390,'朴子市',3),(3925,390,'东石乡',3),(3926,390,'六脚乡',3),(3927,390,'新港乡',3),(3928,390,'民雄乡',3),(3929,390,'大林镇',3),(3930,390,'溪口乡',3),(3931,390,'义竹乡',3),(3932,390,'布袋镇',3),(3933,391,'斗南镇',3),(3934,391,'大埤乡',3),(3935,391,'虎尾镇',3),(3936,391,'土库镇',3),(3937,391,'褒忠乡',3),(3938,391,'东势乡',3),(3939,391,'台西乡',3),(3940,391,'仑背乡',3),(3941,391,'麦寮乡',3),(3942,391,'斗六市',3),(3943,391,'林内乡',3),(3944,391,'古坑乡',3),(3945,391,'莿桐乡',3),(3946,391,'西螺镇',3),(3947,391,'二仑乡',3),(3948,391,'北港镇',3),(3949,391,'水林乡',3),(3950,391,'口湖乡',3),(3951,391,'四湖乡',3),(3952,391,'元长乡',3),(3953,392,'屏东市',3),(3954,392,'三地门乡',3),(3955,392,'雾台乡',3),(3956,392,'玛家乡',3),(3957,392,'九如乡',3),(3958,392,'里港乡',3),(3959,392,'高树乡',3),(3960,392,'盐埔乡',3),(3961,392,'长治乡',3),(3962,392,'麟洛乡',3),(3963,392,'竹田乡',3),(3964,392,'内埔乡',3),(3965,392,'万丹乡',3),(3966,392,'潮州镇',3),(3967,392,'泰武乡',3),(3968,392,'来义乡',3),(3969,392,'万峦乡',3),(3970,392,'崁顶乡',3),(3971,392,'新埤乡',3),(3972,392,'南州乡',3),(3973,392,'林边乡',3),(3974,392,'东港镇',3),(3975,392,'琉球乡',3),(3976,392,'佳冬乡',3),(3977,392,'新园乡',3),(3978,392,'枋寮乡',3),(3979,392,'枋山乡',3),(3980,392,'春日乡',3),(3981,392,'狮子乡',3),(3982,392,'车城乡',3),(3983,392,'牡丹乡',3),(3984,392,'恒春镇',3),(3985,392,'满州乡',3),(3986,393,'台东市',3),(3987,393,'绿岛乡',3),(3988,393,'兰屿乡',3),(3989,393,'延平乡',3),(3990,393,'卑南乡',3),(3991,393,'鹿野乡',3),(3992,393,'关山镇',3),(3993,393,'海端乡',3),(3994,393,'池上乡',3),(3995,393,'东河乡',3),(3996,393,'成功镇',3),(3997,393,'长滨乡',3),(3998,393,'金峰乡',3),(3999,393,'大武乡',3),(4000,393,'达仁乡',3),(4001,393,'太麻里乡',3),(4002,394,'花莲市',3),(4003,394,'新城乡',3),(4004,394,'太鲁阁',3),(4005,394,'秀林乡',3),(4006,394,'吉安乡',3),(4007,394,'寿丰乡',3),(4008,394,'凤林镇',3),(4009,394,'光复乡',3),(4010,394,'丰滨乡',3),(4011,394,'瑞穗乡',3),(4012,394,'万荣乡',3),(4013,394,'玉里镇',3),(4014,394,'卓溪乡',3),(4015,394,'富里乡',3),(4016,395,'马公市',3),(4017,395,'西屿乡',3),(4018,395,'望安乡',3),(4019,395,'七美乡',3),(4020,395,'白沙乡',3),(4021,395,'湖西乡',3),(4022,396,'南竿乡',3),(4023,396,'北竿乡',3),(4024,396,'莒光乡',3),(4025,396,'东引乡',3),(4026,397,'中西区',3),(4027,397,'湾仔',3),(4028,397,'东区',3),(4029,397,'南区',3),(4030,398,'九龙城区',3),(4031,398,'油尖旺区',3),(4032,398,'深水埗区',3),(4033,398,'黄大仙区',3),(4034,398,'观塘区',3),(4035,399,'北区',3),(4036,399,'大埔区',3),(4037,399,'沙田区',3),(4038,399,'西贡区',3),(4039,399,'元朗区',3),(4040,399,'屯门区',3),(4041,399,'荃湾区',3),(4042,399,'葵青区',3),(4043,399,'离岛区',3);

/*Table structure for table `system_auth` */

DROP TABLE IF EXISTS `system_auth`;

CREATE TABLE `system_auth` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL COMMENT '权限名称',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
  `sort` smallint(6) unsigned DEFAULT '0' COMMENT '排序权重',
  `desc` varchar(255) DEFAULT NULL COMMENT '备注说明',
  `create_by` bigint(11) unsigned DEFAULT '0' COMMENT '创建人',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_system_auth_title` (`title`) USING BTREE,
  KEY `index_system_auth_status` (`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统权限表';

/*Data for the table `system_auth` */

/*Table structure for table `system_auth_node` */

DROP TABLE IF EXISTS `system_auth_node`;

CREATE TABLE `system_auth_node` (
  `auth` bigint(20) unsigned DEFAULT NULL COMMENT '角色ID',
  `node` varchar(200) DEFAULT NULL COMMENT '节点路径',
  KEY `index_system_auth_auth` (`auth`) USING BTREE,
  KEY `index_system_auth_node` (`node`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色与节点关系表';

/*Data for the table `system_auth_node` */

/*Table structure for table `system_config` */

DROP TABLE IF EXISTS `system_config`;

CREATE TABLE `system_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '配置编码',
  `value` varchar(500) DEFAULT NULL COMMENT '配置值',
  PRIMARY KEY (`id`),
  KEY `index_system_config_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统参数配置';

/*Data for the table `system_config` */

insert  into `system_config`(`id`,`name`,`value`) values (1,'site_name','ThinkApiAdmin'),(2,'site_copy','ThinkApiAdmin © 2018'),(3,'storage_type','local'),(4,'storage_qiniu_is_https','1'),(5,'storage_qiniu_bucket',''),(6,'storage_qiniu_domain',''),(7,'storage_qiniu_access_key',''),(8,'storage_qiniu_secret_key',''),(9,'storage_qiniu_region','华东'),(10,'app_name','ThinkApiAdmin'),(11,'app_version','v4.0'),(12,'browser_icon',''),(13,'wechat_appid',NULL),(14,'wechat_appsecret',NULL),(15,'wechat_token',NULL),(16,'wechat_encodingaeskey',NULL),(17,'wechat_mch_id',NULL),(18,'wechat_partnerkey',NULL),(19,'wechat_cert_key',NULL),(20,'wechat_cert_cert',NULL),(21,'tongji_baidu_key',''),(22,'tongji_cnzz_key',NULL),(23,'storage_oss_bucket',NULL),(24,'storage_oss_keyid',NULL),(25,'storage_oss_secret',NULL),(26,'storage_oss_domain',NULL),(27,'storage_oss_is_https','0'),(28,'storage_local_exts','png,jpg,rar,doc,icon,mp4,mp3,pem'),(29,'sms_status','0'),(30,'sms_dayu_keyid',''),(31,'sms_dayu_secret','');

/*Table structure for table `system_log` */

DROP TABLE IF EXISTS `system_log`;

CREATE TABLE `system_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ip` char(15) NOT NULL DEFAULT '' COMMENT '操作者IP地址',
  `node` char(200) NOT NULL DEFAULT '' COMMENT '当前操作节点',
  `username` varchar(32) NOT NULL DEFAULT '' COMMENT '操作人用户名',
  `action` varchar(200) NOT NULL DEFAULT '' COMMENT '操作行为',
  `content` text NOT NULL COMMENT '操作内容描述',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8 COMMENT='系统操作日志表';

/*Data for the table `system_log` */

insert  into `system_log`(`id`,`ip`,`node`,`username`,`action`,`content`,`create_at`) values (1,'192.168.0.134','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-08 12:30:45'),(2,'192.168.0.134','admin/login/out','admin','系统管理','用户退出系统成功','2018-04-08 13:12:52'),(3,'192.168.0.134','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-08 13:14:25'),(4,'192.168.0.134','admin/login/out','admin','系统管理','用户退出系统成功','2018-04-08 13:14:46'),(5,'192.168.0.134','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-08 13:16:15'),(6,'192.168.0.134','admin/login/out','admin','系统管理','用户退出系统成功','2018-04-08 13:16:55'),(7,'192.168.0.134','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-08 13:31:50'),(8,'192.168.0.134','admin/login/out','admin','系统管理','用户退出系统成功','2018-04-08 13:34:52'),(9,'192.168.0.134','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-08 13:35:11'),(10,'192.168.0.134','admin/config/index','admin','系统管理','系统参数配置成功','2018-04-08 13:36:43'),(11,'192.168.0.134','admin/config/file','admin','系统管理','系统参数配置成功','2018-04-08 13:40:20'),(12,'192.168.0.134','admin/config/index','admin','系统管理','系统参数配置成功','2018-04-08 13:51:48'),(13,'192.168.0.134','admin/config/index','admin','系统管理','系统参数配置成功','2018-04-08 13:51:56'),(14,'192.168.0.134','port/group/del','admin','API接口管理','API接口分组删除成功','2018-04-08 15:48:11'),(15,'192.168.0.134','port/group/restore','admin','API接口管理','还原接口分组成功','2018-04-08 15:48:19'),(16,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-08 22:02:24'),(17,'127.0.0.1','admin/login/out','admin','系统管理','用户退出系统成功','2018-04-08 22:02:43'),(18,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-08 22:03:38'),(19,'127.0.0.1','admin/login/out','admin','系统管理','用户退出系统成功','2018-04-08 22:09:31'),(20,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-08 22:09:40'),(21,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 22:59:26'),(22,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:03:26'),(23,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:06:09'),(24,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:06:42'),(25,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:08:00'),(26,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:10:02'),(27,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:10:05'),(28,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:10:09'),(29,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:10:12'),(30,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:12:51'),(31,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:12:55'),(32,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:12:58'),(33,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:13:01'),(34,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:13:04'),(35,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:15:35'),(36,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:16:05'),(37,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:20:06'),(38,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:22:26'),(39,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:22:30'),(40,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:22:33'),(41,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:26:32'),(42,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:26:37'),(43,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-08 23:28:33'),(44,'192.168.0.134','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-09 11:44:56'),(45,'192.168.0.134','admin/login/out','admin','系统管理','用户退出系统成功','2018-04-09 11:46:03'),(46,'192.168.0.134','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-09 11:46:32'),(47,'192.168.0.134','port/row/forbid','admin','API接口管理管理','功能禁用成功','2018-04-09 14:09:42'),(48,'192.168.0.134','port/row/resume','admin','API接口管理管理','功能启用成功','2018-04-09 14:09:48'),(49,'192.168.0.134','port/row/resume','admin','API接口管理管理','功能启用成功','2018-04-09 14:09:53'),(50,'192.168.0.134','port/row/forbid','admin','API接口管理管理','功能禁用成功','2018-04-09 14:09:59'),(51,'192.168.0.134','port/row/forbid','admin','API接口管理管理','功能禁用成功','2018-04-09 14:19:01'),(52,'192.168.0.134','port/row/forbid','admin','API接口管理管理','功能禁用成功','2018-04-09 14:19:09'),(53,'192.168.0.134','port/row/resume','admin','API接口管理管理','功能启用成功','2018-04-09 14:19:18'),(54,'192.168.0.134','port/row/resume','admin','API接口管理管理','功能启用成功','2018-04-09 14:20:22'),(55,'192.168.0.134','port/row/forbid','admin','API接口管理管理','功能禁用成功','2018-04-09 14:20:42'),(56,'192.168.0.134','port/row/resume','admin','API接口管理管理','功能启用成功','2018-04-09 14:21:15'),(57,'192.168.0.134','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-09 14:22:38'),(58,'192.168.0.134','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-09 14:24:04'),(59,'192.168.0.134','port/row/forbid','admin','API接口管理管理','功能禁用成功','2018-04-09 14:37:25'),(60,'192.168.0.134','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-09 14:37:30'),(61,'192.168.0.134','port/row/resume','admin','API接口管理管理','功能启用成功','2018-04-09 14:39:29'),(62,'192.168.0.134','port/row/api_tagset','admin','API接口管理管理','接口分组设置成功','2018-04-09 16:06:08'),(63,'192.168.0.134','port/row/api_tagset','admin','API接口管理管理','接口分组设置成功','2018-04-09 16:06:31'),(64,'192.168.0.134','port/group/add','admin','API接口管理','添加API分组成功','2018-04-09 16:07:18'),(65,'192.168.0.134','port/row/api_tagset','admin','API接口管理管理','接口分组设置成功','2018-04-09 16:07:29'),(66,'192.168.0.134','port/row/del','admin','API接口管理','API接口删除成功','2018-04-09 16:59:40'),(67,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-09 17:13:28'),(68,'127.0.0.1','port/row/restore','admin','API接口管理','还原接口删除成功','2018-04-09 17:27:40'),(69,'127.0.0.1','port/row/add','admin','API接口管理','添加接口成功','2018-04-09 21:54:20'),(70,'127.0.0.1','port/row/edit','admin','API接口管理','编辑接口成功','2018-04-09 22:09:55'),(71,'127.0.0.1','port/row/api_tagset','admin','API接口管理管理','接口分组设置成功','2018-04-09 22:10:07'),(72,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-09 22:10:17'),(73,'127.0.0.1','port/row/del','admin','API接口管理','API接口删除成功','2018-04-09 22:11:26'),(74,'127.0.0.1','port/visit/forbid_doc','admin','API接口管理管理','文档密钥禁用成功','2018-04-09 23:35:19'),(75,'127.0.0.1','port/visit/resume_doc','admin','API接口管理管理','文档密钥启用成功','2018-04-09 23:35:24'),(76,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-11 00:18:16'),(77,'127.0.0.1','port/row/add','admin','API接口管理','添加接口成功','2018-04-11 00:24:05'),(78,'127.0.0.1','port/row/api_tagset','admin','API接口管理管理','接口分组设置成功','2018-04-11 00:24:19'),(79,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-11 00:28:55'),(80,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-11 12:23:43'),(81,'127.0.0.1','port/row/add','admin','API接口管理','添加接口成功','2018-04-11 14:44:27'),(82,'127.0.0.1','port/row/edit','admin','API接口管理','编辑接口成功','2018-04-11 14:44:42'),(83,'127.0.0.1','port/row/edit','admin','API接口管理','编辑接口成功','2018-04-11 14:44:49'),(84,'127.0.0.1','port/row/edit','admin','API接口管理','编辑接口成功','2018-04-11 14:45:07'),(85,'127.0.0.1','port/row/add','admin','API接口管理','添加接口成功','2018-04-11 14:46:11'),(86,'127.0.0.1','port/row/api_tagset','admin','API接口管理管理','接口分组设置成功','2018-04-11 14:47:01'),(87,'127.0.0.1','port/row/api_tagset','admin','API接口管理管理','接口分组设置成功','2018-04-11 14:47:05'),(88,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-11 14:47:28'),(89,'127.0.0.1','port/row/refresh','admin','API接口管理','刷新接口路由成功','2018-04-11 16:28:39'),(90,'127.0.0.1','port/visit/forbid','admin','API接口管理','应用禁用成功','2018-04-11 22:47:30'),(91,'127.0.0.1','port/visit/add','admin','API接口管理','添加接口应用成功','2018-04-11 23:19:24'),(92,'127.0.0.1','port/visit/edit','admin','API接口管理','编辑接口应用成功','2018-04-11 23:22:30'),(93,'127.0.0.1','port/visit/add_doc','admin','API接口管理','添加接口文档访问密钥成功','2018-04-11 23:50:42'),(94,'127.0.0.1','port/visit/edit_doc','admin','API接口管理','编辑接口文档访问密钥成功','2018-04-12 00:03:12'),(95,'127.0.0.1','port/visit/edit_doc','admin','API接口管理','编辑接口文档访问密钥成功','2018-04-12 00:04:19'),(96,'127.0.0.1','port/visit/edit_doc','admin','API接口管理','编辑接口文档访问密钥成功','2018-04-12 00:04:36'),(97,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-12 10:30:37'),(98,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-13 13:13:51'),(99,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-16 16:11:21'),(100,'127.0.0.1','port/row/forbid','admin','API接口管理','功能禁用成功','2018-04-16 16:39:25'),(101,'127.0.0.1','port/row/resume','admin','API接口管理','功能启用成功','2018-04-16 16:39:40'),(102,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-17 10:50:10'),(103,'127.0.0.1','port/row/delete','admin','API接口管理','彻底删除接口成功','2018-04-17 13:50:55'),(104,'127.0.0.1','port/row/edit','admin','API接口管理','编辑接口成功','2018-04-17 16:08:57'),(105,'127.0.0.1','port/row/resume','admin','API接口管理','功能启用成功','2018-04-17 16:10:42'),(106,'127.0.0.1','port/row/forbid','admin','API接口管理','功能禁用成功','2018-04-17 16:10:46'),(107,'127.0.0.1','port/row/add_param','admin','API接口管理','添加接口参数成功','2018-04-17 17:28:49'),(108,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 17:33:53'),(109,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 17:34:21'),(110,'127.0.0.1','port/row/del','admin','API接口管理','API接口删除成功','2018-04-17 18:16:03'),(111,'127.0.0.1','port/row/restore','admin','API接口管理','还原接口删除成功','2018-04-17 18:16:10'),(112,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 21:37:44'),(113,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 21:53:02'),(114,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 21:55:48'),(115,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 21:56:40'),(116,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 21:58:31'),(117,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 22:01:34'),(118,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 22:28:20'),(119,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 22:34:07'),(120,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数失败','2018-04-17 22:34:07'),(121,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 22:34:42'),(122,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 22:38:57'),(123,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 22:46:00'),(124,'127.0.0.1','port/row/edit_param','admin','API接口管理','编辑接口参数成功','2018-04-17 22:52:24'),(125,'127.0.0.1','port/row/edit','admin','API接口管理','编辑接口成功','2018-04-18 00:07:56'),(126,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-18 09:49:39'),(127,'127.0.0.1','port/row/del_param','admin','API接口管理','API接口参数删除成功','2018-04-18 09:50:52'),(128,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2018-04-18 09:51:05'),(129,'127.0.0.1','port/row/add_param','admin','API接口管理','添加接口参数成功','2018-04-18 09:53:52'),(130,'127.0.0.1','port/row/del_param','admin','API接口管理','API接口参数删除成功','2018-04-18 09:54:03'),(131,'127.0.0.1','port/row/add_param','admin','API接口管理','添加接口参数成功','2018-04-18 09:54:22'),(132,'127.0.0.1','port/row/add_param','admin','API接口管理','添加接口参数成功','2018-04-18 09:54:33'),(133,'127.0.0.1','port/row/del_param','admin','API接口管理','API接口参数删除成功','2018-04-18 09:55:02'),(134,'127.0.0.1','port/row/add','admin','API接口管理','添加接口成功','2018-04-18 09:56:46'),(135,'127.0.0.1','port/row/api_tagset','admin','API接口管理','接口分组设置成功','2018-04-18 09:58:38'),(136,'127.0.0.1','port/row/add_param','admin','API接口管理','添加接口参数成功','2018-04-18 10:47:16'),(137,'127.0.0.1','port/row/upload_res','admin','API接口管理','API接口响应参数上传失败','2018-04-18 10:53:39'),(138,'127.0.0.1','port/row/upload_res','admin','API接口管理','API接口响应参数上传成功','2018-04-18 11:02:18'),(139,'127.0.0.1','port/row/upload_res','admin','API接口管理','API接口响应参数上传失败','2018-04-18 11:19:33'),(140,'127.0.0.1','port/row/upload_res','admin','API接口管理','API接口响应参数上传成功','2018-04-18 11:49:48'),(141,'127.0.0.1','port/row/del_param','admin','API接口管理','API接口参数删除成功','2018-04-18 11:53:15'),(142,'127.0.0.1','port/row/del','admin','API接口管理','API接口删除成功','2018-04-18 11:53:33'),(143,'127.0.0.1','port/row/delete','admin','API接口管理','彻底删除接口成功','2018-04-18 11:53:44'),(144,'127.0.0.1','port/row/add_param','admin','API接口管理','添加接口参数成功','2018-04-18 11:56:36');

/*Table structure for table `system_menu` */

DROP TABLE IF EXISTS `system_menu`;

CREATE TABLE `system_menu` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父id',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
  `node` varchar(200) NOT NULL DEFAULT '' COMMENT '节点代码',
  `icon` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单图标',
  `url` varchar(400) NOT NULL DEFAULT '' COMMENT '链接',
  `params` varchar(500) DEFAULT '' COMMENT '链接参数',
  `target` varchar(20) NOT NULL DEFAULT '_self' COMMENT '链接打开方式',
  `sort` int(11) unsigned DEFAULT '0' COMMENT '菜单排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
  `create_by` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `index_system_menu_node` (`node`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COMMENT='系统菜单表';

/*Data for the table `system_menu` */

insert  into `system_menu`(`id`,`pid`,`title`,`node`,`icon`,`url`,`params`,`target`,`sort`,`status`,`create_by`,`create_at`) values (2,0,'系统管理','','fa fa-cog','#','','_self',1000,1,0,'2015-11-16 19:15:38'),(4,2,'系统配置','','','#','','_self',100,1,0,'2016-03-14 18:12:55'),(5,4,'网站参数','','fa fa-apple','admin/config/index','','_self',20,1,0,'2016-05-06 14:36:49'),(6,4,'文件存储','','fa fa-save','admin/config/file','','_self',30,1,0,'2016-05-06 14:39:43'),(9,20,'操作日志','','glyphicon glyphicon-console','admin/log/index','','_self',50,1,0,'2017-03-24 15:49:31'),(19,20,'权限管理','','fa fa-user-secret','admin/auth/index','','_self',10,1,0,'2015-11-17 13:18:12'),(20,2,'系统权限','','','#','','_self',200,1,0,'2016-03-14 18:11:41'),(21,20,'系统菜单','','glyphicon glyphicon-menu-hamburger','admin/menu/index','','_self',30,1,0,'2015-11-16 19:16:16'),(22,20,'节点管理','','fa fa-ellipsis-v','admin/node/index','','_self',20,1,0,'2015-11-16 19:16:16'),(29,20,'系统用户','','fa fa-users','admin/user/index','','_self',40,1,0,'2016-10-31 14:31:40'),(61,0,'微信管理','','fa fa-wechat','#','','_self',2000,1,0,'2017-03-29 11:00:21'),(62,61,'微信对接配置','','','#','','_self',400,1,0,'2017-03-29 11:03:38'),(63,62,'微信接口配置\r\n','','fa fa-usb','wechat/config/index','','_self',10,1,0,'2017-03-29 11:04:44'),(65,61,'微信粉丝管理','','','#','','_self',100,1,0,'2017-03-29 11:08:32'),(66,65,'粉丝标签','','fa fa-tags','wechat/tags/index','','_self',20,1,0,'2017-03-29 11:09:41'),(67,65,'已关注粉丝','','fa fa-wechat','wechat/fans/index','','_self',10,1,0,'2017-03-29 11:10:07'),(68,61,'微信订制','','','#','','_self',200,1,0,'2017-03-29 11:10:39'),(69,68,'微信菜单定制','','glyphicon glyphicon-phone','wechat/menu/index','','_self',40,1,0,'2017-03-29 11:11:08'),(70,68,'关键字管理','','fa fa-paw','wechat/keys/index','','_self',20,1,0,'2017-03-29 11:11:49'),(71,68,'关注自动回复','','fa fa-commenting-o','wechat/keys/subscribe','','_self',10,1,0,'2017-03-29 11:12:32'),(81,68,'无配置默认回复','','fa fa-commenting-o','wechat/keys/defaults','','_self',30,1,0,'2017-04-21 14:48:25'),(82,61,'素材资源管理','','','#','','_self',300,1,0,'2017-04-24 11:23:18'),(83,82,'添加图文','','fa fa-folder-open-o','wechat/news/add?id=1','','_self',20,1,0,'2017-04-24 11:23:40'),(85,82,'图文列表','','fa fa-file-pdf-o','wechat/news/index','','_self',10,1,0,'2017-04-24 11:25:45'),(86,65,'粉丝黑名单','','fa fa-reddit-alien','wechat/fans/back','','_self',30,1,0,'2017-05-05 16:17:03'),(87,0,'插件案例','','fa fa-hashtag','#','','_self',9000,1,0,'2017-07-10 15:10:16'),(88,87,'第三方插件','','','#','','_self',0,1,0,'2017-07-10 15:10:37'),(90,88,'PCAS 省市区','','','demo/plugs/region','','_self',0,1,0,'2017-07-10 18:45:47'),(91,87,'内置插件','','','#','','_self',0,1,0,'2017-07-10 18:56:59'),(92,91,'文件上传','','','demo/plugs/file','','_self',0,1,0,'2017-07-10 18:57:22'),(93,88,'富文本编辑器','','','demo/plugs/editor','','_self',0,1,0,'2017-07-28 15:19:44'),(94,0,'后台首页','','fa fa-edge','admin/index/main','','_self',0,1,0,'2017-08-08 11:28:43'),(95,0,'内容管理','','fa fa-code','#','','_self',3000,1,0,'2018-04-08 13:57:36'),(96,0,'接口管理','','fa fa-usb','#','','_self',4000,1,0,'2018-04-08 13:58:11'),(97,62,'微信支付配置','','fa fa-paypal','wechat/config/pay','','_self',20,1,0,'2018-04-08 14:22:30'),(98,96,'接口分组管理','','','#','','_self',20,1,0,'2018-04-08 15:37:30'),(99,98,'分组列表','','fa fa-bars','port/group/index','','_self',1,1,0,'2018-04-08 15:38:45'),(100,98,'分组回收站','','fa fa-trash-o','port/group/recycle','','_self',2,1,0,'2018-04-08 15:42:35'),(101,96,'接口管理','','','#','','_self',10,1,0,'2018-04-08 15:46:35'),(102,101,'接口列表','','fa fa-code-fork','port/row/index','','_self',1,1,0,'2018-04-08 22:13:06'),(103,101,'接口回收站','','fa fa-trash-o','port/row/recycle','','_self',3,1,0,'2018-04-09 17:02:03'),(104,96,'访问控制','','','#','','_self',30,1,0,'2018-04-09 22:32:23'),(105,104,'应用列表','','fa fa-cube','port/visit/app','','_self',1,1,0,'2018-04-09 22:38:14'),(106,104,'文档密钥','','fa fa-building-o','port/visit/doc','','_self',2,1,0,'2018-04-09 22:38:57'),(107,101,'接口参数','','fa fa-keyboard-o','port/row/param','','_self',2,1,0,'2018-04-16 17:42:15');

/*Table structure for table `system_node` */

DROP TABLE IF EXISTS `system_node`;

CREATE TABLE `system_node` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `node` varchar(100) DEFAULT NULL COMMENT '节点代码',
  `title` varchar(500) DEFAULT NULL COMMENT '节点标题',
  `is_menu` tinyint(1) unsigned DEFAULT '0' COMMENT '是否可设置为菜单',
  `is_auth` tinyint(1) unsigned DEFAULT '1' COMMENT '是否启动RBAC权限控制',
  `is_login` tinyint(1) unsigned DEFAULT '1' COMMENT '是否启动登录控制',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `index_system_node_node` (`node`)
) ENGINE=InnoDB AUTO_INCREMENT=268 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统节点表';

/*Data for the table `system_node` */

insert  into `system_node`(`id`,`node`,`title`,`is_menu`,`is_auth`,`is_login`,`create_at`) values (131,'admin/auth/index','权限列表',1,1,1,'2017-08-23 15:45:42'),(132,'admin','后台管理',0,1,1,'2017-08-23 15:45:44'),(133,'admin/auth/apply','节点授权',0,1,1,'2017-08-23 16:05:18'),(134,'admin/auth/add','添加授权',0,1,1,'2017-08-23 16:05:19'),(135,'admin/auth/edit','编辑权限',0,1,1,'2017-08-23 16:05:19'),(136,'admin/auth/forbid','禁用权限',0,1,1,'2017-08-23 16:05:20'),(137,'admin/auth/resume','启用权限',0,1,1,'2017-08-23 16:05:20'),(138,'admin/auth/del','删除权限',0,1,1,'2017-08-23 16:05:21'),(139,'admin/config/index','参数配置',1,1,1,'2017-08-23 16:05:22'),(140,'admin/config/file','文件配置',1,1,1,'2017-08-23 16:05:22'),(141,'admin/log/index','日志列表',1,1,1,'2017-08-23 16:05:23'),(142,'admin/log/del','删除日志',0,1,1,'2017-08-23 16:05:24'),(143,'admin/menu/index','菜单列表',1,1,1,'2017-08-23 16:05:25'),(144,'admin/menu/add','添加菜单',0,1,1,'2017-08-23 16:05:25'),(145,'admin/menu/edit','编辑菜单',0,1,1,'2017-08-23 16:05:26'),(146,'admin/menu/del','删除菜单',0,1,1,'2017-08-23 16:05:26'),(147,'admin/menu/forbid','禁用菜单',0,1,1,'2017-08-23 16:05:27'),(148,'admin/menu/resume','启用菜单',0,1,1,'2017-08-23 16:05:28'),(149,'admin/node/index','节点列表',1,1,1,'2017-08-23 16:05:29'),(150,'admin/node/save','节点更新',0,1,1,'2017-08-23 16:05:30'),(151,'admin/user/index','用户管理',1,1,1,'2017-08-23 16:05:31'),(152,'admin/user/auth','用户授权',0,1,1,'2017-08-23 16:05:32'),(153,'admin/user/add','添加用户',0,1,1,'2017-08-23 16:05:33'),(154,'admin/user/edit','编辑用户',0,1,1,'2017-08-23 16:05:33'),(155,'admin/user/pass','用户密码',0,1,1,'2017-08-23 16:05:34'),(156,'admin/user/del','删除用户',0,1,1,'2017-08-23 16:05:34'),(157,'admin/user/forbid','禁用用户',0,1,1,'2017-08-23 16:05:34'),(158,'admin/user/resume','启用用户',0,1,1,'2017-08-23 16:05:35'),(159,'demo/plugs/file','文件上传',1,0,1,'2017-08-23 16:05:36'),(160,'demo/plugs/region','区域选择',1,0,1,'2017-08-23 16:05:36'),(161,'demo/plugs/editor','富文本器',1,0,1,'2017-08-23 16:05:37'),(162,'wechat/config/index','微信参数',1,1,1,'2017-08-23 16:05:37'),(163,'wechat/config/pay','微信支付',0,1,1,'2017-08-23 16:05:38'),(164,'wechat/fans/index','粉丝列表',1,1,1,'2017-08-23 16:05:39'),(165,'wechat/fans/back','粉丝黑名单',1,1,1,'2017-08-23 16:05:39'),(166,'wechat/fans/backadd','移入黑名单',0,1,1,'2017-08-23 16:05:40'),(167,'wechat/fans/tagset','设置标签',0,1,1,'2017-08-23 16:05:41'),(168,'wechat/fans/backdel','移出黑名单',0,1,1,'2017-08-23 16:05:41'),(169,'wechat/fans/tagadd','添加标签',0,1,1,'2017-08-23 16:05:41'),(170,'wechat/fans/tagdel','删除标签',0,1,1,'2017-08-23 16:05:42'),(171,'wechat/fans/sync','同步粉丝',0,1,1,'2017-08-23 16:05:43'),(172,'wechat/keys/index','关键字列表',1,1,1,'2017-08-23 16:05:44'),(173,'wechat/keys/add','添加关键字',0,1,1,'2017-08-23 16:05:44'),(174,'wechat/keys/edit','编辑关键字',0,1,1,'2017-08-23 16:05:45'),(175,'wechat/keys/del','删除关键字',0,1,1,'2017-08-23 16:05:45'),(176,'wechat/keys/forbid','禁用关键字',0,1,1,'2017-08-23 16:05:46'),(177,'wechat/keys/resume','启用关键字',0,1,1,'2017-08-23 16:05:46'),(178,'wechat/keys/subscribe','关注默认回复',0,1,1,'2017-08-23 16:05:48'),(179,'wechat/keys/defaults','默认响应回复',0,1,1,'2017-08-23 16:05:49'),(180,'wechat/menu/index','微信菜单',1,1,1,'2017-08-23 16:05:51'),(181,'wechat/menu/edit','发布微信菜单',0,1,1,'2017-08-23 16:05:51'),(182,'wechat/menu/cancel','取消微信菜单',0,1,1,'2017-08-23 16:05:52'),(183,'wechat/news/index','微信图文列表',1,1,1,'2017-08-23 16:05:52'),(184,'wechat/news/select','微信图文选择',0,1,1,'2017-08-23 16:05:53'),(185,'wechat/news/image','微信图片选择',0,1,1,'2017-08-23 16:05:53'),(186,'wechat/news/add','添加图文',0,1,1,'2017-08-23 16:05:54'),(187,'wechat/news/edit','编辑图文',0,1,1,'2017-08-23 16:05:56'),(188,'wechat/news/del','删除图文',0,1,1,'2017-08-23 16:05:56'),(189,'wechat/news/push','推送图文',0,1,1,'2017-08-23 16:05:56'),(190,'wechat/tags/index','微信标签列表',1,1,1,'2017-08-23 16:05:58'),(191,'wechat/tags/add','添加微信标签',0,1,1,'2017-08-23 16:05:58'),(192,'wechat/tags/edit','编辑微信标签',0,1,1,'2017-08-23 16:05:58'),(193,'wechat/tags/sync','同步微信标签',0,1,1,'2017-08-23 16:05:59'),(194,'admin/auth','权限管理',0,1,1,'2017-08-23 16:06:58'),(195,'admin/config','系统配置',0,1,1,'2017-08-23 16:07:34'),(196,'admin/log','系统日志',0,1,1,'2017-08-23 16:07:46'),(197,'admin/menu','系统菜单',0,1,1,'2017-08-23 16:08:02'),(198,'admin/node','系统节点',0,1,1,'2017-08-23 16:08:44'),(199,'admin/user','系统用户',0,1,1,'2017-08-23 16:09:43'),(200,'demo','插件案例',0,1,1,'2017-08-23 16:10:43'),(201,'demo/plugs','插件案例',0,1,1,'2017-08-23 16:10:51'),(202,'wechat','微信管理',0,1,1,'2017-08-23 16:11:13'),(203,'wechat/config','微信配置',0,1,1,'2017-08-23 16:11:19'),(204,'wechat/fans','粉丝管理',0,1,1,'2017-08-23 16:11:36'),(205,'wechat/keys','关键字管理',0,1,1,'2017-08-23 16:13:00'),(206,'wechat/menu','微信菜单管理',0,1,1,'2017-08-23 16:14:11'),(207,'wechat/news','微信图文管理',0,1,1,'2017-08-23 16:14:40'),(208,'wechat/tags','微信标签管理',0,1,1,'2017-08-23 16:15:25'),(209,'port/group/index','分组列表',0,1,1,'2018-04-08 18:09:07'),(210,'port/group/recycle','分组回收站',0,1,1,'2018-04-08 18:09:07'),(211,'port/group/add','添加分组',0,1,1,'2018-04-08 18:09:08'),(212,'port/group/edit','编辑分组',0,1,1,'2018-04-08 18:09:08'),(213,'port/group/forbid','禁用分组',0,1,1,'2018-04-08 18:09:09'),(214,'port/group/resume','启用分组',0,1,1,'2018-04-08 18:09:10'),(215,'port/group/del','删除分组',0,1,1,'2018-04-08 18:09:10'),(216,'port/group/restore','还原删除',0,1,1,'2018-04-08 18:09:11'),(217,'port/group/delete','彻底删除',0,1,1,'2018-04-08 18:09:11'),(218,'port','接口管理',0,1,1,'2018-04-08 18:10:02'),(219,'port/group','接口分组管理',0,1,1,'2018-04-08 18:10:10'),(220,'wiki','接口文档',0,1,1,'2018-04-08 18:13:31'),(221,'wiki/index','文档展示',0,1,1,'2018-04-08 18:13:43'),(222,'wiki/login','文档登录',0,1,1,'2018-04-08 18:13:51'),(223,'wiki/index/index','文档首页',0,0,0,'2018-04-08 18:14:12'),(224,'wiki/index/detail','文档详情',0,0,0,'2018-04-08 18:14:19'),(225,'wiki/index/calculation','接口访问AccessToken算法',0,0,0,'2018-04-08 18:14:21'),(226,'wiki/index/errorcode','接口错误码',0,0,0,'2018-04-08 18:14:23'),(227,'wiki/login/index','接口文档登录页',0,0,0,'2018-04-08 18:15:38'),(228,'api','接口控制器',0,1,1,'2018-04-08 18:18:10'),(229,'api/buildtoken','token建造类',0,1,1,'2018-04-08 18:18:29'),(230,'api/debug','debug接口',0,1,1,'2018-04-08 18:18:35'),(231,'api/index','接口首页',0,1,1,'2018-04-08 18:18:50'),(232,'api/miss','接口错误访问页',0,1,1,'2018-04-08 18:19:05'),(233,'api/tool','工具类接口',0,1,1,'2018-04-08 18:19:26'),(234,'port/row/index','接口列表',0,1,1,'2018-04-11 00:18:42'),(235,'port/row/add','添加接口',0,1,1,'2018-04-11 00:18:43'),(236,'port/row/edit','编辑接口',0,1,1,'2018-04-11 00:18:50'),(237,'port/row/recycle','接口回收站',0,1,1,'2018-04-11 00:18:51'),(238,'port/row/api_tagset','接口打分组标签',0,1,1,'2018-04-11 00:18:52'),(239,'port/row/forbid','禁用接口',0,1,1,'2018-04-11 00:18:53'),(240,'port/row/resume','启用接口',0,1,1,'2018-04-11 00:18:55'),(241,'port/row/del','接口软删除',0,1,1,'2018-04-11 00:18:56'),(242,'port/row/restore','还原接口删除',0,1,1,'2018-04-11 00:18:57'),(243,'port/row/delete','接口彻底删除',0,1,1,'2018-04-11 00:18:58'),(244,'port/row/refresh','刷新接口路由配置',0,1,1,'2018-04-11 00:18:59'),(245,'port/row/ask','接口请求参数配置',0,1,1,'2018-04-11 00:19:04'),(246,'port/row/res','接口响应参数配置',0,1,1,'2018-04-11 00:19:05'),(247,'port/visit/app','接口访问应用',0,1,1,'2018-04-11 00:19:07'),(248,'port/visit/add','添加接口应用',0,1,1,'2018-04-11 00:19:09'),(249,'port/visit/edit','编辑接口应用',0,1,1,'2018-04-11 00:19:10'),(250,'port/visit/forbid','禁用应用',0,1,1,'2018-04-11 00:19:11'),(251,'port/visit/resume','启用应用',0,1,1,'2018-04-11 00:19:13'),(252,'port/visit/del','删除接口应用',0,1,1,'2018-04-11 00:19:15'),(253,'port/visit/doc','接口文档访问密钥列表',0,1,1,'2018-04-11 00:19:16'),(254,'port/visit/add_doc','添加访问密钥',0,1,1,'2018-04-11 00:19:17'),(255,'port/visit/edit_doc','编辑访问密钥',0,1,1,'2018-04-11 00:19:18'),(256,'port/visit/forbid_doc','禁用访问密钥',0,1,1,'2018-04-11 00:19:19'),(257,'port/visit/resume_doc','启用访问密钥',0,1,1,'2018-04-11 00:19:20'),(258,'port/visit/del_doc','删除访问密钥',0,1,1,'2018-04-11 00:19:21'),(259,'port/row','接口管理',0,1,1,'2018-04-11 15:17:02'),(260,'port/visit','接口访问控制',0,1,1,'2018-04-11 15:20:31'),(261,'api/buildtoken/getaccesstoken','获取接口访问accesstoken',0,0,0,'2018-04-11 15:25:54'),(262,'worker','workerman服务端',0,1,1,'2018-04-16 17:29:30'),(263,'port/row/param','接口参数',0,1,1,'2018-04-16 17:54:32'),(264,'port/row/add_param','添加接口参数',0,1,1,'2018-10-11 11:15:23'),(265,'port/row/edit_param','编辑接口参数',0,1,1,'2018-10-11 11:15:30'),(266,'port/row/del_param','删除接口参数',0,1,1,'2018-10-11 11:15:37'),(267,'port/row/upload_res','上传接口返回json数据格式化',0,1,1,'2018-10-11 11:15:42');

/*Table structure for table `system_sequence` */

DROP TABLE IF EXISTS `system_sequence`;

CREATE TABLE `system_sequence` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT NULL COMMENT '序号类型',
  `sequence` char(50) NOT NULL COMMENT '序号值',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_system_sequence_unique` (`type`,`sequence`) USING BTREE,
  KEY `index_system_sequence_type` (`type`),
  KEY `index_system_sequence_number` (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='系统序号表';

/*Data for the table `system_sequence` */

insert  into `system_sequence`(`id`,`type`,`sequence`,`create_at`) values (1,'WECHAT-PAY-TEST','7477860649','2018-04-08 14:25:10'),(2,'WXPAY-OUTER-NO','795524300498041291','2018-04-08 14:25:10');

/*Table structure for table `system_user` */

DROP TABLE IF EXISTS `system_user`;

CREATE TABLE `system_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户登录名',
  `password` char(32) NOT NULL DEFAULT '' COMMENT '用户登录密码',
  `qq` varchar(16) DEFAULT NULL COMMENT '联系QQ',
  `mail` varchar(32) DEFAULT NULL COMMENT '联系邮箱',
  `phone` varchar(16) DEFAULT NULL COMMENT '联系手机号',
  `desc` varchar(255) DEFAULT '' COMMENT '备注说明',
  `login_num` bigint(20) unsigned DEFAULT '0' COMMENT '登录次数',
  `login_at` datetime DEFAULT NULL,
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
  `authorize` varchar(255) DEFAULT NULL,
  `is_deleted` tinyint(1) unsigned DEFAULT '0' COMMENT '删除状态(1:删除,0:未删)',
  `create_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_system_user_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='系统用户表';

/*Data for the table `system_user` */

insert  into `system_user`(`id`,`username`,`password`,`qq`,`mail`,`phone`,`desc`,`login_num`,`login_at`,`status`,`authorize`,`is_deleted`,`create_by`,`create_at`) values (10000,'admin','21232f297a57a5a743894a0e4a801fc3','22222222','','','',27058,'2018-04-18 09:51:05',1,'301,302,303,304',0,NULL,'2015-11-13 15:14:22');

/*Table structure for table `wechat_fans` */

DROP TABLE IF EXISTS `wechat_fans`;

CREATE TABLE `wechat_fans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '粉丝表ID',
  `appid` varchar(50) DEFAULT NULL COMMENT '公众号Appid',
  `groupid` bigint(20) unsigned DEFAULT NULL COMMENT '分组ID',
  `tagid_list` varchar(100) DEFAULT '' COMMENT '标签id',
  `is_back` tinyint(1) unsigned DEFAULT '0' COMMENT '是否为黑名单用户',
  `subscribe` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '用户是否订阅该公众号，0：未关注，1：已关注',
  `openid` char(100) NOT NULL DEFAULT '' COMMENT '用户的标识，对当前公众号唯一',
  `spread_openid` char(100) DEFAULT NULL COMMENT '推荐人OPENID',
  `spread_at` datetime DEFAULT NULL,
  `nickname` varchar(100) DEFAULT NULL COMMENT '用户的昵称',
  `sex` tinyint(1) unsigned DEFAULT NULL COMMENT '用户的性别，值为1时是男性，值为2时是女性，值为0时是未知',
  `country` varchar(50) DEFAULT NULL COMMENT '用户所在国家',
  `province` varchar(50) DEFAULT NULL COMMENT '用户所在省份',
  `city` varchar(50) DEFAULT NULL COMMENT '用户所在城市',
  `language` varchar(50) DEFAULT NULL COMMENT '用户的语言，简体中文为zh_CN',
  `headimgurl` varchar(500) DEFAULT NULL COMMENT '用户头像',
  `subscribe_time` bigint(20) unsigned DEFAULT NULL COMMENT '用户关注时间',
  `subscribe_at` datetime DEFAULT NULL COMMENT '关注时间',
  `unionid` varchar(100) DEFAULT NULL COMMENT 'unionid',
  `remark` varchar(50) DEFAULT NULL COMMENT '备注',
  `expires_in` bigint(20) unsigned DEFAULT '0' COMMENT '有效时间',
  `refresh_token` varchar(200) DEFAULT NULL COMMENT '刷新token',
  `access_token` varchar(200) DEFAULT NULL COMMENT '访问token',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `index_wechat_fans_spread_openid` (`spread_openid`) USING BTREE,
  KEY `index_wechat_fans_openid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信粉丝';

/*Data for the table `wechat_fans` */

/*Table structure for table `wechat_fans_tags` */

DROP TABLE IF EXISTS `wechat_fans_tags`;

CREATE TABLE `wechat_fans_tags` (
  `id` bigint(20) unsigned NOT NULL COMMENT '标签ID',
  `appid` char(50) DEFAULT NULL COMMENT '公众号APPID',
  `name` varchar(35) DEFAULT NULL COMMENT '标签名称',
  `count` int(11) unsigned DEFAULT NULL COMMENT '总数',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  KEY `index_wechat_fans_tags_id` (`id`) USING BTREE,
  KEY `index_wechat_fans_tags_appid` (`appid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信会员标签';

/*Data for the table `wechat_fans_tags` */

/*Table structure for table `wechat_keys` */

DROP TABLE IF EXISTS `wechat_keys`;

CREATE TABLE `wechat_keys` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` char(50) DEFAULT NULL COMMENT '公众号APPID',
  `type` varchar(20) DEFAULT NULL COMMENT '类型，text 文件消息，image 图片消息，news 图文消息',
  `keys` varchar(100) DEFAULT NULL COMMENT '关键字',
  `content` text COMMENT '文本内容',
  `image_url` varchar(255) DEFAULT NULL COMMENT '图片链接',
  `voice_url` varchar(255) DEFAULT NULL COMMENT '语音链接',
  `music_title` varchar(100) DEFAULT NULL COMMENT '音乐标题',
  `music_url` varchar(255) DEFAULT NULL COMMENT '音乐链接',
  `music_image` varchar(255) DEFAULT NULL COMMENT '音乐缩略图链接',
  `music_desc` varchar(255) DEFAULT NULL COMMENT '音乐描述',
  `video_title` varchar(100) DEFAULT NULL COMMENT '视频标题',
  `video_url` varchar(255) DEFAULT NULL COMMENT '视频URL',
  `video_desc` varchar(255) DEFAULT NULL COMMENT '视频描述',
  `news_id` bigint(20) unsigned DEFAULT NULL COMMENT '图文ID',
  `sort` bigint(20) unsigned DEFAULT '0' COMMENT '排序字段',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '0 禁用，1 启用',
  `create_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信关键字';

/*Data for the table `wechat_keys` */

/*Table structure for table `wechat_menu` */

DROP TABLE IF EXISTS `wechat_menu`;

CREATE TABLE `wechat_menu` (
  `id` bigint(16) unsigned NOT NULL AUTO_INCREMENT,
  `index` bigint(20) DEFAULT NULL,
  `pindex` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父id',
  `type` varchar(24) NOT NULL DEFAULT '' COMMENT '菜单类型 null主菜单 link链接 keys关键字',
  `name` varchar(256) NOT NULL DEFAULT '' COMMENT '菜单名称',
  `content` text NOT NULL COMMENT '文字内容',
  `sort` bigint(20) unsigned DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(0禁用1启用)',
  `create_by` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `index_wechat_menu_pindex` (`pindex`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信菜单配置';

/*Data for the table `wechat_menu` */

/*Table structure for table `wechat_news` */

DROP TABLE IF EXISTS `wechat_news`;

CREATE TABLE `wechat_news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `media_id` varchar(100) DEFAULT NULL COMMENT '永久素材MediaID',
  `local_url` varchar(300) DEFAULT NULL COMMENT '永久素材显示URL',
  `article_id` varchar(60) DEFAULT NULL COMMENT '关联图文ID，用，号做分割',
  `is_deleted` tinyint(1) unsigned DEFAULT '0' COMMENT '是否删除',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`),
  KEY `index_wechat_new_artcle_id` (`article_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信图文表';

/*Data for the table `wechat_news` */

/*Table structure for table `wechat_news_article` */

DROP TABLE IF EXISTS `wechat_news_article`;

CREATE TABLE `wechat_news_article` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL COMMENT '素材标题',
  `local_url` varchar(300) DEFAULT NULL COMMENT '永久素材显示URL',
  `show_cover_pic` tinyint(4) unsigned DEFAULT '0' COMMENT '是否显示封面 0不显示，1 显示',
  `author` varchar(20) DEFAULT NULL COMMENT '作者',
  `digest` varchar(300) DEFAULT NULL COMMENT '摘要内容',
  `content` longtext COMMENT '图文内容',
  `content_source_url` varchar(200) DEFAULT NULL COMMENT '图文消息原文地址',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信素材表';

/*Data for the table `wechat_news_article` */

/*Table structure for table `wechat_news_image` */

DROP TABLE IF EXISTS `wechat_news_image`;

CREATE TABLE `wechat_news_image` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `md5` varchar(32) DEFAULT NULL COMMENT '文件md5',
  `local_url` varchar(300) DEFAULT NULL COMMENT '本地文件链接',
  `media_url` varchar(300) DEFAULT NULL COMMENT '远程图片链接',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `index_wechat_news_image_md5` (`md5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信服务器图片';

/*Data for the table `wechat_news_image` */

/*Table structure for table `wechat_news_media` */

DROP TABLE IF EXISTS `wechat_news_media`;

CREATE TABLE `wechat_news_media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `appid` varchar(200) DEFAULT NULL COMMENT '公众号ID',
  `md5` varchar(32) DEFAULT NULL COMMENT '文件md5',
  `type` varchar(20) DEFAULT NULL COMMENT '媒体类型',
  `media_id` varchar(100) DEFAULT NULL COMMENT '永久素材MediaID',
  `local_url` varchar(300) DEFAULT NULL COMMENT '本地文件链接',
  `media_url` varchar(300) DEFAULT NULL COMMENT '远程图片链接',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信素材表';

/*Data for the table `wechat_news_media` */

/*Table structure for table `wechat_pay_notify` */

DROP TABLE IF EXISTS `wechat_pay_notify`;

CREATE TABLE `wechat_pay_notify` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(50) DEFAULT NULL COMMENT '公众号Appid',
  `bank_type` varchar(50) DEFAULT NULL COMMENT '银行类型',
  `cash_fee` bigint(20) DEFAULT NULL COMMENT '现金价',
  `fee_type` char(20) DEFAULT NULL COMMENT '币种，1人民币',
  `is_subscribe` char(1) DEFAULT 'N' COMMENT '是否关注，Y为关注，N为未关注',
  `mch_id` varchar(50) DEFAULT NULL COMMENT '商户MCH_ID',
  `nonce_str` varchar(32) DEFAULT NULL COMMENT '随机串',
  `openid` varchar(50) DEFAULT NULL COMMENT '微信用户openid',
  `out_trade_no` varchar(50) DEFAULT NULL COMMENT '支付平台退款交易号',
  `sign` varchar(100) DEFAULT NULL COMMENT '签名',
  `time_end` datetime DEFAULT NULL COMMENT '结束时间',
  `result_code` varchar(10) DEFAULT NULL,
  `return_code` varchar(10) DEFAULT NULL,
  `total_fee` varchar(11) DEFAULT NULL COMMENT '支付总金额，单位为分',
  `trade_type` varchar(20) DEFAULT NULL COMMENT '支付方式',
  `transaction_id` varchar(64) DEFAULT NULL COMMENT '订单号',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '本地系统时间',
  PRIMARY KEY (`id`),
  KEY `index_wechat_pay_notify_openid` (`openid`) USING BTREE,
  KEY `index_wechat_pay_notify_out_trade_no` (`out_trade_no`) USING BTREE,
  KEY `index_wechat_pay_notify_transaction_id` (`transaction_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付日志表';

/*Data for the table `wechat_pay_notify` */

/*Table structure for table `wechat_pay_prepayid` */

DROP TABLE IF EXISTS `wechat_pay_prepayid`;

CREATE TABLE `wechat_pay_prepayid` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `appid` char(50) DEFAULT NULL COMMENT '公众号APPID',
  `from` char(32) DEFAULT 'shop' COMMENT '支付来源',
  `fee` bigint(20) unsigned DEFAULT NULL COMMENT '支付费用(分)',
  `trade_type` varchar(20) DEFAULT NULL COMMENT '订单类型',
  `order_no` varchar(50) DEFAULT NULL COMMENT '内部订单号',
  `out_trade_no` varchar(50) DEFAULT NULL COMMENT '外部订单号',
  `prepayid` varchar(500) DEFAULT NULL COMMENT '预支付码',
  `expires_in` bigint(20) unsigned DEFAULT NULL COMMENT '有效时间',
  `transaction_id` varchar(64) DEFAULT NULL COMMENT '微信平台订单号',
  `is_pay` tinyint(1) unsigned DEFAULT '0' COMMENT '1已支付，0未支退款',
  `pay_at` datetime DEFAULT NULL COMMENT '支付时间',
  `is_refund` tinyint(1) unsigned DEFAULT '0' COMMENT '是否退款，退款单号(T+原来订单)',
  `refund_at` datetime DEFAULT NULL COMMENT '退款时间',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '本地系统时间',
  PRIMARY KEY (`id`),
  KEY `index_wechat_pay_prepayid_outer_no` (`out_trade_no`) USING BTREE,
  KEY `index_wechat_pay_prepayid_order_no` (`order_no`) USING BTREE,
  KEY `index_wechat_pay_is_pay` (`is_pay`) USING BTREE,
  KEY `index_wechat_pay_is_refund` (`is_refund`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付订单号对应表';

/*Data for the table `wechat_pay_prepayid` */

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;