-- MySQL dump 10.13  Distrib 5.6.26, for Win64 (x86_64)
--
-- Host: localhost    Database: gfast_open
-- ------------------------------------------------------
-- Server version	5.6.26

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

--
-- Table structure for table `auth_rule`
--

DROP TABLE IF EXISTS `auth_rule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则名称',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '规则名称',
  `icon` varchar(50) NOT NULL DEFAULT '' COMMENT '图标',
  `condition` varchar(255) NOT NULL DEFAULT '' COMMENT '条件',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `menu_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型 0目录 1菜单 2按钮',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `always_show` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '显示状态',
  `path` varchar(100) NOT NULL DEFAULT '' COMMENT '路由地址',
  `component` varchar(100) NOT NULL DEFAULT '' COMMENT '组件路径',
  `is_frame` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否外链 1是 0否',
  `module_type` varchar(30) NOT NULL DEFAULT '' COMMENT '所属模块',
  `model_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '模型ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE,
  KEY `weigh` (`weigh`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='菜单节点表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_rule`
--

LOCK TABLES `auth_rule` WRITE;
/*!40000 ALTER TABLE `auth_rule` DISABLE KEYS */;
INSERT INTO `auth_rule` VALUES (1,0,'system/config','系统配置','system','','Admin tips',0,1497429920,1497430320,0,1,1,'config','',0,'sys_admin',0),(2,0,'system/auth','权限管理','peoples','','',0,1497429920,1592380524,0,1,1,'system/auth','',0,'sys_admin',0),(3,0,'system/monitor','系统监控','monitor','','',0,1497429920,1592380560,0,1,1,'monitor','',0,'sys_admin',0),(4,0,'system/cms','cms管理','form','','',0,1497429920,1592380573,0,1,1,'cms','',0,'sys_admin',0),(5,1,'system/config/dict/list','字典管理','dict','','',1,1497429920,1592380469,0,1,1,'dict/list','system/config/dict/list',0,'sys_admin',0),(6,1,'system/config/params/list','参数管理','date-range','','',1,1497429920,1592380510,0,1,1,'params/list','system/config/params/list',0,'sys_admin',0),(8,2,'system/auth/menuList','菜单管理','nested','','',1,1497429920,1592380548,0,1,1,'menuList','system/auth/menuList',0,'sys_admin',0),(21,5,'system/config/dict/delete','删除字典','','','',2,1592363629,1592363629,0,1,1,'','',0,'sys_admin',0),(16,8,'system/auth/addMenu','添加菜单','','','',2,1592357208,1600396699,0,1,0,'','',0,'sys_admin',0),(17,8,'system/auth/editMenu','修改菜单','','','',2,1592357231,1592357274,0,1,1,'','',0,'sys_admin',0),(18,8,'system/auth/deleteMenu','删除菜单','','','',2,1592357268,1592357268,0,1,1,'','',0,'sys_admin',0),(19,5,'system/config/dict/add','添加字典','','','',2,1592363585,1592363585,0,1,1,'','',0,'sys_admin',0),(20,5,'system/config/dict/edit','修改字典','','','',2,1592363604,1592363604,0,1,1,'','',0,'sys_admin',0),(22,5,'system/config/dict/dataList','字典数据管理','','','',2,1592363790,1592365455,0,1,1,'dataList','',0,'sys_admin',0),(23,5,'system/config/dict/dataAdd','添加字典数据','','','',2,1592380398,1593411393,0,1,1,'','',0,'sys_admin',0),(24,5,'system/config/dict/dataEdit','修改字典数据','','','',2,1592380417,1593411398,0,1,1,'','',0,'sys_admin',0),(25,5,'system/config/dict/dataDelete','删除字典数据','','','',2,1592380449,1593411403,0,1,1,'','',0,'sys_admin',0),(26,2,'system/auth/roleList','角色管理','logininfor','','',1,1592385260,1592385291,0,1,1,'role','system/auth/roleList',0,'sys_admin',0),(27,26,'system/auth/addRole','添加角色','','','',2,1592389821,1592389821,0,1,1,'','',0,'sys_admin',0),(28,2,'system/auth/dept','部门管理','peoples','','',1,1592449845,1592449845,0,1,1,'dept','system/auth/dept',0,'sys_admin',0),(29,26,'system/auth/editRole','修改角色','','','',2,1592469153,1592469153,0,1,1,'','',0,'sys_admin',0),(30,26,'system/auth/statusSetRole','设置角色状态','','','',2,1592469201,1592469201,0,1,1,'','',0,'sys_admin',0),(31,26,'system/auth/deleteRole','删除角色','','','',2,1592469234,1592469234,0,1,1,'','',0,'sys_admin',0),(32,4,'system/cms/menu/list','栏目管理','tree-table','','',1,1592469318,1592469318,0,1,1,'menu','system/cms/menu/list',0,'sys_admin',0),(33,2,'system/auth/post','岗位管理','tab','','',1,1592558968,1592558968,0,1,1,'post','system/auth/post',0,'sys_admin',0),(34,3,'system/monitor/online/list','在线用户','cascader','','',1,1593328511,1593328511,0,1,1,'online','system/monitor/online/list',0,'sys_admin',0),(35,4,'system/cms/news/list','文章管理','log','','',1,1593331969,1593331991,0,1,1,'news','system/cms/news/list',0,'sys_admin',0),(36,3,'system/monitor/job','定时任务','clipboard','','',1,1593332305,1593332434,0,1,1,'job','system/monitor/job',0,'sys_admin',0),(37,3,'system/monitor/server','服务监控','dict','','',1,1593419394,1593419394,0,1,1,'server','system/monitor/server',0,'sys_admin',0),(38,3,'system/monitor/logininfor','登录日志','chart','','',1,1593423378,1593423505,0,1,1,'logininfor','system/monitor/logininfor',0,'sys_admin',0),(39,3,'system/monitor/operlog','操作日志','dashboard','','',1,1593485097,1593485097,0,1,1,'operlog','system/monitor/operlog',0,'sys_admin',0),(40,2,'system/auth/userList','用户管理','user','','',1,1593572523,1593572523,0,1,1,'user','system/auth/userList',0,'sys_admin',0),(41,6,'system/config/params/add','添加参数','','','',2,1593684331,1593684331,0,1,1,'','',0,'sys_admin',0),(42,6,'system/config/params/edit','修改参数','','','',2,1593684351,1593684351,0,1,1,'','',0,'sys_admin',0),(43,6,'system/config/params/delete','删除参数','','','',2,1593684470,1593684470,0,1,1,'','',0,'sys_admin',0),(44,28,'system/dept/addDept','添加部门','','','',2,1593738070,1593738070,0,1,1,'','',0,'sys_admin',0),(45,28,'system/dept/editDept','修改部门','','','',2,1593738097,1593738097,0,1,1,'','',0,'sys_admin',0),(46,28,'system/dept/delDept','删除部门','','','',2,1593738125,1593738125,0,1,1,'','',0,'sys_admin',0),(47,33,'system/post/add','添加岗位','','','',2,1593738444,1593738444,0,1,1,'','',0,'sys_admin',0),(48,33,'system/post/edit','修改岗位','','','',2,1593738567,1593738567,0,1,1,'','',0,'sys_admin',0),(49,33,'system/post/delete','删除岗位','','','',2,1593738590,1593738590,0,1,1,'','',0,'sys_admin',0),(50,40,'system/auth/addUser','添加用户','','','',2,1593738798,1593738798,0,1,1,'','',0,'sys_admin',0),(51,40,'system/auth/editUser','修改用户','','','',2,1593738950,1593738950,0,1,1,'','',0,'sys_admin',0),(52,40,'system/auth/resetUserPwd','密码重置','','','',2,1593739001,1593739001,0,1,1,'','',0,'sys_admin',0),(53,40,'system/auth/changeUserStatus','状态设置','','','',2,1593739079,1593739079,0,1,1,'','',0,'sys_admin',0),(54,40,'system/auth/deleteAdmin','删除用户','','','',2,1593739113,1593739113,0,1,1,'','',0,'sys_admin',0),(55,34,'system/monitor/online/forceLogout','强制退出','','','',2,1593739201,1593739201,0,1,1,'','',0,'sys_admin',0),(56,36,'system/monitor/job/add','添加任务','','','',2,1593740041,1593740041,0,1,1,'','',0,'sys_admin',0),(57,36,'system/monitor/job/edit','修改任务','','','',2,1593740062,1593740062,0,1,1,'','',0,'sys_admin',0),(58,36,'system/monitor/job/start','开启任务','','','',2,1593740105,1593740105,0,1,1,'','',0,'sys_admin',0),(59,36,'system/monitor/job/stop','停止任务','','','',2,1593740139,1593740139,0,1,1,'','',0,'sys_admin',0),(60,36,'system/monitor/job/delete','删除任务','','','',2,1593740165,1593740165,0,1,1,'','',0,'sys_admin',0),(61,38,'system/monitor/loginlog/delete','删除','','','',2,1593740342,1593740342,0,1,1,'','',0,'sys_admin',0),(62,38,'system/monitor/loginlog/clear','清空','','','',2,1593740359,1593740359,0,1,1,'','',0,'sys_admin',0),(63,39,'system/monitor/operlog/delete','删除','','','',2,1593740422,1593740422,0,1,1,'','',0,'sys_admin',0),(64,39,'system/monitor/operlog/clear','清空','','','',2,1593740434,1593740434,0,1,1,'','',0,'sys_admin',0),(65,32,'system/cms/menu/add','添加栏目','','','',2,1593740504,1593740504,0,1,1,'','',0,'sys_admin',0),(66,32,'system/cms/menu/edit','修改栏目','','','',2,1593740521,1593740521,0,1,1,'','',0,'sys_admin',0),(67,32,'system/cms/menu/sort','栏目排序','','','',2,1593740549,1593740549,0,1,1,'','',0,'sys_admin',0),(68,32,'system/cms/menu/delete','删除栏目','','','',2,1593740568,1593740568,0,1,1,'','',0,'sys_admin',0),(69,35,'system/cms/news/add','添加文章','','','',2,1593740691,1593740691,0,1,1,'','',0,'sys_admin',0),(70,35,'system/cms/news/edit','修改文章','','','',2,1593740711,1593740711,0,1,1,'','',0,'sys_admin',0),(71,35,'system/cms/news/delete','删除文章','','','',2,1593740730,1593740730,0,1,1,'','',0,'sys_admin',0),(72,0,'system/model','模型管理','table','','',0,1593742999,1593742999,0,1,1,'model','',0,'sys_admin',0),(73,72,'system/model/category/list','模型分类','tree-table','','',1,1593743065,1593743065,0,1,1,'category','system/model/category/list',0,'sys_admin',0),(74,72,'system/model/info/list','模型列表','list','','',1,1593743131,1594781057,0,1,1,'list','system/model/info/list',0,'sys_admin',0),(75,0,'system/tools','系统工具','server','','',0,1594016328,1594016328,0,1,1,'system/tools','',0,'sys_admin',0),(76,75,'system/tools/build','表单构建','build','','',1,1594016392,1594016808,0,1,1,'build','system/tools/build',0,'sys_admin',0),(77,75,'system/tools/gen','代码生成','code','','',1,1594016637,1594016637,0,1,1,'gen','system/tools/gen',0,'sys_admin',0),(78,0,'system/plug','扩展管理','logininfor','','',0,1594169636,1594169636,0,1,1,'system/plug','',0,'sys_admin',0),(79,78,'system/plug/ad','广告管理','color','','',0,1594169691,1595410089,0,1,1,'adManage','',0,'sys_admin',0),(80,79,'system/plug/ad/type/list','广告位管理','nested','','',1,1594169783,1595405904,0,1,1,'adtype','system/plug/ad/type/list',0,'sys_admin',0),(81,79,'system/plug/ad/info/list','广告列表','list','','',1,1594169949,1596418803,0,1,1,'adlist','system/plug/ad/info/list',0,'sys_admin',0),(82,75,'system/tools/api','系统接口','guide','','',1,1594951684,1594951684,0,1,1,'api','system/tools/api',0,'sys_admin',0),(83,78,'system/plug/link','友情链接','cascader','','',0,1595381634,1595403122,0,1,1,'link','',0,'sys_admin',0),(84,83,'system/plug/link/type/list','分类管理','component','','',1,1595381717,1595381717,0,1,1,'type','system/plug/link/type/list',0,'sys_admin',0),(85,83,'system/plug/link/info/list','链接管理','list','','',1,1595381754,1595381754,0,1,1,'info','system/plug/link/info/list',0,'sys_admin',0),(86,1,'system/config/webSet','站点设置','system','','',1,1596420340,1596420340,0,1,1,'/webSet','system/config/webSet',0,'sys_admin',0);
/*!40000 ALTER TABLE `auth_rule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `casbin_rule`
--

DROP TABLE IF EXISTS `casbin_rule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `casbin_rule` (
  `ptype` varchar(10) DEFAULT NULL,
  `v0` varchar(256) DEFAULT NULL,
  `v1` varchar(256) DEFAULT NULL,
  `v2` varchar(256) DEFAULT NULL,
  `v3` varchar(256) DEFAULT NULL,
  `v4` varchar(256) DEFAULT NULL,
  `v5` varchar(256) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `casbin_rule`
--

LOCK TABLES `casbin_rule` WRITE;
/*!40000 ALTER TABLE `casbin_rule` DISABLE KEYS */;
INSERT INTO `casbin_rule` VALUES ('p','g_8','r_1','All','','',''),('p','g_8','r_5','All','','',''),('p','g_8','r_19','All','','',''),('p','g_8','r_20','All','','',''),('p','g_8','r_21','All','','',''),('p','g_8','r_22','All','','',''),('p','g_8','r_23','All','','',''),('p','g_8','r_24','All','','',''),('p','g_8','r_25','All','','',''),('p','g_8','r_6','All','','',''),('p','g_1','r_1','All','','',''),('p','g_1','r_5','All','','',''),('p','g_1','r_19','All','','',''),('p','g_1','r_20','All','','',''),('p','g_1','r_21','All','','',''),('p','g_1','r_22','All','','',''),('p','g_1','r_23','All','','',''),('p','g_1','r_24','All','','',''),('p','g_1','r_25','All','','',''),('p','g_1','r_6','All','','',''),('p','g_1','r_2','All','','',''),('p','g_1','r_8','All','','',''),('p','g_1','r_16','All','','',''),('p','g_1','r_17','All','','',''),('p','g_1','r_18','All','','',''),('p','g_1','r_26','All','','',''),('p','g_1','r_27','All','','',''),('p','g_1','r_29','All','','',''),('p','g_1','r_30','All','','',''),('p','g_1','r_31','All','','',''),('p','g_1','r_28','All','','',''),('p','g_1','r_33','All','','',''),('p','g_1','r_40','All','','',''),('p','g_1','r_3','All','','',''),('p','g_1','r_34','All','','',''),('p','g_1','r_36','All','','',''),('p','g_1','r_37','All','','',''),('p','g_1','r_38','All','','',''),('p','g_1','r_39','All','','',''),('p','g_1','r_4','All','','',''),('p','g_1','r_32','All','','',''),('p','g_1','r_35','All','','',''),('g','u_2','g_2','','','',''),('p','g_2','r_1','All','','',''),('p','g_2','r_5','All','','',''),('p','g_2','r_19','All','','',''),('p','g_2','r_20','All','','',''),('p','g_2','r_21','All','','',''),('p','g_2','r_22','All','','',''),('p','g_2','r_23','All','','',''),('p','g_2','r_24','All','','',''),('p','g_2','r_25','All','','',''),('p','g_2','r_6','All','','',''),('p','g_2','r_41','All','','',''),('p','g_2','r_42','All','','',''),('p','g_2','r_43','All','','',''),('p','g_2','r_2','All','','',''),('p','g_2','r_8','All','','',''),('p','g_2','r_16','All','','',''),('p','g_2','r_17','All','','',''),('p','g_2','r_18','All','','',''),('p','g_2','r_26','All','','',''),('p','g_2','r_27','All','','',''),('p','g_2','r_29','All','','',''),('p','g_2','r_30','All','','',''),('p','g_2','r_31','All','','',''),('p','g_2','r_28','All','','',''),('p','g_2','r_33','All','','',''),('p','g_2','r_40','All','','',''),('p','g_2','r_3','All','','',''),('p','g_2','r_34','All','','',''),('p','g_2','r_36','All','','',''),('p','g_2','r_37','All','','',''),('p','g_2','r_38','All','','',''),('p','g_2','r_39','All','','',''),('p','g_2','r_4','All','','',''),('p','g_2','r_32','All','','',''),('p','g_2','r_35','All','','',''),('g','u_1','g_1','','','',''),('g','u_1','g_3','','','',''),('g','u_22','g_2','','','',''),('g','u_22','g_1','','','',''),('g','u_31','g_1','','','',''),('g','u_31','g_2','','','',''),('g','u_15','g_2','','','',''),('g','u_16','g_3','','','',''),('g','u_3','g_2','','','','');
/*!40000 ALTER TABLE `casbin_rule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_category`
--

DROP TABLE IF EXISTS `cms_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '分类父id',
  `model_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '模型ID',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `alias` varchar(255) NOT NULL DEFAULT '' COMMENT '栏目别名',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '分类描述',
  `seo_title` varchar(100) NOT NULL DEFAULT '',
  `seo_keywords` varchar(255) NOT NULL DEFAULT '',
  `seo_description` varchar(255) NOT NULL DEFAULT '',
  `list_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类列表模板',
  `one_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类文章页模板',
  `more` text COMMENT '扩展属性',
  `cate_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '分类类型',
  `cate_address` varchar(255) NOT NULL DEFAULT '' COMMENT '跳转地址',
  `cate_content` text COMMENT '单页内容',
  `list_template` varchar(150) DEFAULT NULL COMMENT '列表页模板',
  `content_template` varchar(150) DEFAULT NULL COMMENT '内容页模板',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_category`
--

LOCK TABLES `cms_category` WRITE;
/*!40000 ALTER TABLE `cms_category` DISABLE KEYS */;
INSERT INTO `cms_category` VALUES (1,0,0,1,0,1,'最新发布','','最新发布','最新发布','最新发布','最新发布','','','',1,'','',NULL,NULL),(2,1,0,1,0,0,'主要指标数据','','主要指标数据','云南主要指标数据','云南主要指标数据','云南主要指标数据','','','',1,'','',NULL,NULL),(3,2,9,1,0,0,'综合数据','','综合数据','综合数据','综合数据','综合数据','','','',2,'','',NULL,NULL),(4,0,9,1,0,2,'决策部署','','决策部署','决策部署','决策部署','决策部署','','','',1,'','',NULL,NULL),(5,0,0,1,0,3,'决策参考','','决策参考','决策参考','决策参考','决策参考','','','',1,'','',NULL,NULL),(6,0,9,1,0,4,'热点名词','','热点名词','热点名词','热点名词','热点名词','','','',2,'','',NULL,NULL),(8,0,9,1,0,5,'统计分析','','统计分析','统计分析','统计分析','统计分析','','','',2,'','',NULL,NULL),(9,4,0,1,0,0,'单页测试','','描述','','','','','','',4,'','<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\">1<span style=\"font-family:宋体\">、自己发布的问题自己应能看到。</span></span></span></p>\n\n<p style=\"text-align:justify\"><img src=\"http://localhost:8200/pub_upload/2020-06-24/c3p15b3e02a4y4ywny.png\" style=\"height:506px; width:1874px\" /></p>\n\n<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\">2<span style=\"font-family:宋体\">、删除问题后事项列表显示空问题，没有将对应的事项删除。</span></span></span></p>\n\n<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\"></span></span></p>\n\n<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\">3<span style=\"font-family:宋体\">、事项发布没填写列表内容点击保存报错，点了多次后添加了多个同样的问题督办。</span></span></span></p>\n\n<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\"></span></span></p>\n\n<table cellspacing=\"0\" style=\"border-collapse:collapse\">\n	<tbody>\n		<tr>\n			<td style=\"border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\"><span style=\"font-family:宋体\">姓名</span></span></span></p>\n			</td>\n			<td style=\"border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:1px solid black; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\"><span style=\"font-family:宋体\">账号</span></span></span></p>\n			</td>\n			<td style=\"border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:1px solid black; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\"><span style=\"font-family:宋体\">密码</span></span></span></p>\n			</td>\n			<td style=\"border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:1px solid black; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\"><span style=\"font-family:宋体\">描述</span></span></span></p>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:none; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\">aaaa</span></span></p>\n			</td>\n			<td style=\"border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\">vvvv</span></span></p>\n			</td>\n			<td style=\"border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\">&nbsp;</p>\n			</td>\n			<td style=\"border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\">&nbsp;</p>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"border-bottom:1px solid black; border-left:1px solid black; border-right:1px solid black; border-top:none; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\">&nbsp;</p>\n			</td>\n			<td style=\"border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\">aaaa</span></span></p>\n			</td>\n			<td style=\"border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\">ffff</span></span></p>\n			</td>\n			<td style=\"border-bottom:1px solid black; border-left:none; border-right:1px solid black; border-top:none; vertical-align:top; width:138px\">\n			<p style=\"text-align:justify\"><span style=\"font-size:10.5pt\"><span style=\"font-family:Calibri,serif\">wwww</span></span></p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n\n<p style=\"text-align:justify\">&nbsp;</p>\n',NULL,NULL),(10,4,0,1,0,0,'测试2','','描述','','','','','','{\"thumb\":\"pub_upload/2020-06-24/c3p4dvd0lj4kijlssl.jpg\"}',4,'','<p>离开家离开家离开家</p>\n',NULL,NULL),(11,5,9,1,0,0,'模型测试','','','','','','','','',2,'','',NULL,NULL),(12,5,9,1,0,0,'模型测试2','','','','','','','','',2,'','',NULL,NULL),(13,0,11,1,0,10,'圆角方','','','','','','','','',2,'','',NULL,NULL),(14,0,11,1,0,0,'专题专栏','','','','','','','','',2,'','','list/list.html','content/show.html'),(15,0,11,1,0,0,'新闻动态','','','','','','','','',2,'','',NULL,NULL);
/*!40000 ALTER TABLE `cms_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_category_news`
--

DROP TABLE IF EXISTS `cms_category_news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_category_news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `news_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文章id',
  `category_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `cid_nid_unique` (`news_id`,`category_id`) USING BTREE,
  KEY `term_taxonomy_id` (`news_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='cms应用 分类文章对应表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_category_news`
--

LOCK TABLES `cms_category_news` WRITE;
/*!40000 ALTER TABLE `cms_category_news` DISABLE KEYS */;
INSERT INTO `cms_category_news` VALUES (174,99,6),(175,99,8),(173,100,6),(168,102,6),(172,103,6),(171,104,6),(192,106,13),(182,107,13),(183,108,13),(196,109,14),(194,110,15),(195,111,6);
/*!40000 ALTER TABLE `cms_category_news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_news`
--

DROP TABLE IF EXISTS `cms_news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '发表者用户id',
  `news_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:已发布;0:未发布;',
  `is_top` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶;1:置顶;0:不置顶',
  `recommended` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
  `news_hits` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '查看数',
  `news_like` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `published_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  `news_title` varchar(150) NOT NULL DEFAULT '' COMMENT 'post标题',
  `news_keywords` varchar(150) NOT NULL DEFAULT '' COMMENT 'seo keywords',
  `news_excerpt` varchar(500) NOT NULL DEFAULT '' COMMENT 'post摘要',
  `news_source` varchar(150) NOT NULL DEFAULT '' COMMENT '转载文章的来源',
  `thumbnail` text COMMENT '缩略图',
  `is_jump` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否跳转地址',
  `jump_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL COMMENT '跳转地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='cms信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_news`
--

LOCK TABLES `cms_news` WRITE;
/*!40000 ALTER TABLE `cms_news` DISABLE KEYS */;
INSERT INTO `cms_news` VALUES (99,1,1,1,0,0,0,1596445247,1596503077,1596438109,0,'模型测试文章5','关键字333','摘要333','来源333','pub_upload/2020-08-03/c4n9kip80g787jiupk.jpg',0,''),(100,1,1,1,0,0,0,1596502983,1596503069,1596438109,0,'模型测试文章4','关键字','摘要','来源','pub_upload/2020-08-03/c4n63557pwsknml6pu.jpg',0,''),(102,1,1,1,0,0,0,1596502995,1596502995,1596438109,0,'模型测试文章3','关键字','摘要','来源','pub_upload/2020-08-03/c4n63557pwsknml6pu.jpg',0,''),(103,1,1,1,0,0,0,1596502999,1596503058,1596438109,0,'模型测试文章2','关键字','摘要','来源','pub_upload/2020-08-03/c4n63557pwsknml6pu.jpg',0,''),(104,1,1,1,0,0,0,1596503003,1596503051,1596438109,0,'模型测试文章1','关键字','摘要','来源','pub_upload/2020-08-03/c4n63557pwsknml6pu.jpg',0,''),(106,31,0,0,0,0,0,1597116539,1597139414,1597116470,0,'text123','','','','pub_upload/2020-08-11/c4tznud8e11kbwsa9p.png',0,''),(107,31,0,0,0,0,0,1597131211,1597131211,1597131108,0,'sadasf','','','','pub_upload/2020-08-11/c4tzqf0xashgedljgm.png',0,''),(108,31,0,0,0,0,0,1597131255,1597131255,1597131214,0,'text3','','','','pub_upload/2020-08-11/c4tzrwibqzho5rnrjl.png',0,''),(109,31,0,0,0,0,0,1597655450,1600397072,1597655394,0,'text1','','','','pub_upload/2020-08-17/c4z5l86qc0twis8y29.png',0,''),(110,31,0,0,0,0,0,1597711877,1597711877,1597711798,0,'新闻动态第一条','','','','',0,''),(111,31,0,0,0,0,0,1599467880,1599467880,1599467861,0,'测试','啊啊','阿萨大时代','阿萨大时代','',0,'');
/*!40000 ALTER TABLE `cms_news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_news_attr`
--

DROP TABLE IF EXISTS `cms_news_attr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_news_attr` (
  `art_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `news_content` text COMMENT '文章内容',
  `thumbnail` varchar(200) DEFAULT '' COMMENT '缩略图',
  `news_files` text COMMENT '附件',
  `news_file` varchar(200) DEFAULT '' COMMENT '单附件',
  `news_imgs` text COMMENT '多图片',
  `news_title` int(11) NOT NULL DEFAULT '0' COMMENT '文章标题',
  `news_info` varchar(200) NOT NULL DEFAULT '1' COMMENT '多选测试',
  `text_demo` varchar(30) NOT NULL DEFAULT '' COMMENT '文本测试',
  `time_demo` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '时间测试',
  PRIMARY KEY (`art_id`) USING BTREE,
  UNIQUE KEY `text_demo` (`text_demo`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_news_attr`
--

LOCK TABLES `cms_news_attr` WRITE;
/*!40000 ALTER TABLE `cms_news_attr` DISABLE KEYS */;
INSERT INTO `cms_news_attr` VALUES (99,'<p>文章内容22222</p>\n','pub_upload/2020-08-03/c4n63aygb5tw3wfnwc.jpg','[{\"name\":\"6ef43e00e7afa99e991b823f5c94a2fc.jpg\",\"status\":\"success\",\"uid\":1596438151172,\"url\":\"pub_upload/2020-08-03/c4n63cgl8qvsq5sdoz.jpg\"},{\"name\":\"8f1b65c6acd20ad98ade90195694451b.jpg\",\"status\":\"success\",\"uid\":1596438151173,\"url\":\"pub_upload/2020-08-03/c4n63e0gacukyrm5g0.jpg\"}]','[{\"name\":\"timg.jpg\",\"status\":\"success\",\"uid\":1596438154995,\"url\":\"pub_upload/2020-08-03/c4n63frusr3wb6h8ik.jpg\"}]','pub_upload/2020-08-03/c4n63hjq1r70gascrx.jpg,pub_upload/2020-08-03/c4n63j2eqbxct3llos.png,pub_upload/2020-08-03/c4n63k8gsim0gnztwy.jpg,pub_upload/2020-08-03/c4n9knh8z5dgkmnvoo.png',1,'1,2,3','文本测试内容422222',1596602606),(100,'<p>文章内容</p>\n','pub_upload/2020-08-03/c4n63aygb5tw3wfnwc.jpg','[{\"name\":\"6ef43e00e7afa99e991b823f5c94a2fc.jpg\",\"status\":\"success\",\"uid\":1596438151172,\"url\":\"pub_upload/2020-08-03/c4n63cgl8qvsq5sdoz.jpg\"},{\"name\":\"8f1b65c6acd20ad98ade90195694451b.jpg\",\"status\":\"success\",\"uid\":1596438151173,\"url\":\"pub_upload/2020-08-03/c4n63e0gacukyrm5g0.jpg\"}]','[{\"name\":\"timg.jpg\",\"status\":\"success\",\"uid\":1596438154995,\"url\":\"pub_upload/2020-08-03/c4n63frusr3wb6h8ik.jpg\"}]','pub_upload/2020-08-03/c4n63hjq1r70gascrx.jpg,pub_upload/2020-08-03/c4n63j2eqbxct3llos.png,pub_upload/2020-08-03/c4n63k8gsim0gnztwy.jpg',0,'1,2','文本测试内容4',1596429806),(102,'<p>文章内容</p>\n','pub_upload/2020-08-03/c4n63aygb5tw3wfnwc.jpg','[{\"name\":\"6ef43e00e7afa99e991b823f5c94a2fc.jpg\",\"status\":\"success\",\"uid\":1596438151172,\"url\":\"pub_upload/2020-08-03/c4n63cgl8qvsq5sdoz.jpg\"},{\"name\":\"8f1b65c6acd20ad98ade90195694451b.jpg\",\"status\":\"success\",\"uid\":1596438151173,\"url\":\"pub_upload/2020-08-03/c4n63e0gacukyrm5g0.jpg\"}]','[{\"name\":\"timg.jpg\",\"status\":\"success\",\"uid\":1596438154995,\"url\":\"pub_upload/2020-08-03/c4n63frusr3wb6h8ik.jpg\"}]','pub_upload/2020-08-03/c4n63hjq1r70gascrx.jpg,pub_upload/2020-08-03/c4n63j2eqbxct3llos.png,pub_upload/2020-08-03/c4n63k8gsim0gnztwy.jpg',0,'1,2','文本测试内容5',1596429806),(103,'<p>文章内容</p>\n','pub_upload/2020-08-03/c4n63aygb5tw3wfnwc.jpg','[{\"name\":\"6ef43e00e7afa99e991b823f5c94a2fc.jpg\",\"status\":\"success\",\"uid\":1596438151172,\"url\":\"pub_upload/2020-08-03/c4n63cgl8qvsq5sdoz.jpg\"},{\"name\":\"8f1b65c6acd20ad98ade90195694451b.jpg\",\"status\":\"success\",\"uid\":1596438151173,\"url\":\"pub_upload/2020-08-03/c4n63e0gacukyrm5g0.jpg\"}]','[{\"name\":\"timg.jpg\",\"status\":\"success\",\"uid\":1596438154995,\"url\":\"pub_upload/2020-08-03/c4n63frusr3wb6h8ik.jpg\"}]','pub_upload/2020-08-03/c4n63hjq1r70gascrx.jpg,pub_upload/2020-08-03/c4n63j2eqbxct3llos.png,pub_upload/2020-08-03/c4n63k8gsim0gnztwy.jpg',0,'1,2','文本测试内容6',1596429806),(104,'<p>文章内容</p>\n','pub_upload/2020-08-03/c4n63aygb5tw3wfnwc.jpg','[{\"name\":\"6ef43e00e7afa99e991b823f5c94a2fc.jpg\",\"status\":\"success\",\"uid\":1596438151172,\"url\":\"pub_upload/2020-08-03/c4n63cgl8qvsq5sdoz.jpg\"},{\"name\":\"8f1b65c6acd20ad98ade90195694451b.jpg\",\"status\":\"success\",\"uid\":1596438151173,\"url\":\"pub_upload/2020-08-03/c4n63e0gacukyrm5g0.jpg\"}]','[{\"name\":\"timg.jpg\",\"status\":\"success\",\"uid\":1596438154995,\"url\":\"pub_upload/2020-08-03/c4n63frusr3wb6h8ik.jpg\"}]','pub_upload/2020-08-03/c4n63hjq1r70gascrx.jpg,pub_upload/2020-08-03/c4n63j2eqbxct3llos.png,pub_upload/2020-08-03/c4n63k8gsim0gnztwy.jpg',0,'1,2','文本测试内容7',1596429806),(106,'<p>wzwwzwzwzwzwzw666666666666666666</p>\n','','[]','[]','',0,'1','1',1597116531),(111,'<p>客家话客家话</p>\n','','','','',0,'1','健康和',1599467863);
/*!40000 ALTER TABLE `cms_news_attr` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_yjf_attr`
--

DROP TABLE IF EXISTS `cms_yjf_attr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_yjf_attr` (
  `art_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `news_content` text COMMENT '文章内容',
  PRIMARY KEY (`art_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_yjf_attr`
--

LOCK TABLES `cms_yjf_attr` WRITE;
/*!40000 ALTER TABLE `cms_yjf_attr` DISABLE KEYS */;
INSERT INTO `cms_yjf_attr` VALUES (106,'<p><img src=\"http://localhost:8200/pub_upload/2020-08-11/c4u2nxwu69iggkulk2.png\" style=\"height:2365px; width:1701px\" /></p>\n\n<p>&nbsp;</p>\n'),(107,'<p>dasdasfasfsa</p>\n\n<p>sadsadaf<img src=\"http://localhost:8200/pub_upload/2020-08-11/c4tzqrorcgmg1bqifr.png\" style=\"height:356px; width:1710px\" />ss</p>\n\n<p>safasfasf</p>\n'),(108,'<p>aaaaaaaaaaaaaaaaaaaaaaassss</p>\n'),(109,'<p>456465456456</p>\n'),(110,'<p>新闻动态第一条的具体内容在这里</p>\n');
/*!40000 ALTER TABLE `cms_yjf_attr` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gen_table`
--

DROP TABLE IF EXISTS `gen_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gen_table` (
  `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_name` varchar(200) DEFAULT '' COMMENT '表名称',
  `table_comment` varchar(500) DEFAULT '' COMMENT '表描述',
  `class_name` varchar(100) DEFAULT '' COMMENT '实体类名称',
  `tpl_category` varchar(200) DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）',
  `package_name` varchar(100) DEFAULT NULL COMMENT '生成包路径',
  `module_name` varchar(30) DEFAULT NULL COMMENT '生成模块名',
  `business_name` varchar(30) DEFAULT NULL COMMENT '生成业务名',
  `function_name` varchar(50) DEFAULT NULL COMMENT '生成功能名',
  `function_author` varchar(50) DEFAULT NULL COMMENT '生成功能作者',
  `options` varchar(1000) DEFAULT NULL COMMENT '其它生成选项',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`table_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='代码生成业务表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gen_table`
--

LOCK TABLES `gen_table` WRITE;
/*!40000 ALTER TABLE `gen_table` DISABLE KEYS */;
INSERT INTO `gen_table` VALUES (33,'sys_dept','部门表','dept','tree','gfast','module','dept','部门','yunjie','{\"tree_code\":\"config_id\",\"tree_name\":\"config_key\",\"tree_parent_code\":\"config_name\"}','admin','2020-02-16 20:58:20','',NULL,''),(34,'model_category','模型分类表','model_category','tree','gfast','module','category','模型分类','gfast','{\"tree_code\":\"c_id\",\"tree_name\":\"create_time\",\"tree_parent_code\":\"c_name\"}','admin','2020-07-09 11:17:04','admin','2020-07-10 11:25:07',''),(35,'user','用户表','user','crud','gfast','module','user','用户','gfast','','admin','2020-07-09 11:17:04','',NULL,''),(37,'model_category','模型分类表','model_category','crud','gfast','module','category','模型分类','gfast','','admin','2020-07-09 11:44:12','',NULL,''),(38,'user','用户表','user','crud','gfast','module','user','用户','gfast','','admin','2020-07-09 11:44:13','admin','2020-07-10 11:42:07',''),(39,'model_category','模型分类表','model_category','crud','gfast','module','category','模型分类','gfast','','admin','2020-07-09 15:11:08','',NULL,''),(40,'user','用户表','user','crud','gfast','module','user','用户','gfast','','admin','2020-07-09 15:11:08','admin','2020-07-13 17:18:31','');
/*!40000 ALTER TABLE `gen_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gen_table_column`
--

DROP TABLE IF EXISTS `gen_table_column`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gen_table_column` (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_id` bigint(20) DEFAULT NULL COMMENT '归属表编号',
  `column_name` varchar(200) DEFAULT NULL COMMENT '列名称',
  `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述',
  `column_type` varchar(100) DEFAULT NULL COMMENT '列类型',
  `go_type` varchar(500) DEFAULT NULL COMMENT 'Go类型',
  `go_field` varchar(200) DEFAULT NULL COMMENT 'Go字段名',
  `html_field` varchar(200) DEFAULT NULL COMMENT 'html字段名',
  `is_pk` char(1) DEFAULT NULL COMMENT '是否主键（1是）',
  `is_increment` char(1) DEFAULT NULL COMMENT '是否自增（1是）',
  `is_required` char(1) DEFAULT NULL COMMENT '是否必填（1是）',
  `is_insert` char(1) DEFAULT NULL COMMENT '是否为插入字段（1是）',
  `is_edit` char(1) DEFAULT NULL COMMENT '是否编辑字段（1是）',
  `is_list` char(1) DEFAULT NULL COMMENT '是否列表字段（1是）',
  `is_query` char(1) DEFAULT NULL COMMENT '是否查询字段（1是）',
  `query_type` varchar(200) DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
  `html_type` varchar(200) DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
  `dict_type` varchar(200) DEFAULT '' COMMENT '字典类型',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`column_id`)
) ENGINE=InnoDB AUTO_INCREMENT=441 DEFAULT CHARSET=utf8 COMMENT='代码生成业务表字段';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gen_table_column`
--

LOCK TABLES `gen_table_column` WRITE;
/*!40000 ALTER TABLE `gen_table_column` DISABLE KEYS */;
INSERT INTO `gen_table_column` VALUES (355,33,'dept_id','部门id','bigint(20)','int64','DeptId','deptId','1','1','0','1','0','1','1','EQ','input','',1,'admin',NULL,'',NULL),(356,33,'parent_id','父部门id','bigint(20)','int64','ParentId','parentId','0','0','0','1','1','1','1','EQ','input','',2,'admin',NULL,'',NULL),(357,33,'ancestors','祖级列表','varchar(50)','string','Ancestors','ancestors','0','0','0','1','1','1','1','EQ','input','',3,'admin',NULL,'',NULL),(358,33,'dept_name','部门名称','varchar(30)','string','DeptName','deptName','0','0','1','1','1','1','1','LIKE','input','',4,'admin',NULL,'',NULL),(359,33,'order_num','显示顺序','int(4)','int','OrderNum','orderNum','0','0','0','1','1','1','1','EQ','input','',5,'admin',NULL,'',NULL),(360,33,'leader','负责人','varchar(20)','string','Leader','leader','0','0','0','1','1','1','1','EQ','input','',6,'admin',NULL,'',NULL),(361,33,'phone','联系电话','varchar(11)','string','Phone','phone','0','0','0','1','1','1','1','EQ','input','',7,'admin',NULL,'',NULL),(362,33,'email','邮箱','varchar(50)','string','Email','email','0','0','0','1','1','1','1','EQ','input','',8,'admin',NULL,'',NULL),(363,33,'status','部门状态（0正常 1停用）','char(1)','string','Status','status','0','0','1','1','1','1','1','EQ','radio','',9,'admin',NULL,'',NULL),(364,33,'del_flag','删除标志（0代表存在 2代表删除）','char(1)','string','DelFlag','delFlag','0','0','0','1','0','0','0','EQ','input','',10,'admin',NULL,'',NULL),(365,33,'create_by','创建者','varchar(64)','string','CreateBy','createBy','0','0','0','0','0','0','0','EQ','input','',11,'admin',NULL,'',NULL),(366,33,'create_time','创建时间','datetime','Time','CreateTime','createTime','0','0','0','0','0','0','0','EQ','datatime','',12,'admin',NULL,'',NULL),(367,33,'update_by','更新者','varchar(64)','string','UpdateBy','updateBy','0','0','0','0','0','0','0','EQ','input','',13,'admin',NULL,'',NULL),(368,33,'update_time','更新时间','datetime','Time','UpdateTime','updateTime','0','0','0','0','0','0','0','EQ','datatime','',14,'admin',NULL,'',NULL),(369,34,'c_id','主键','int(10) unsigned','int','CId','cId','1','1','0','1','0','1','1','EQ','input','',1,'admin',NULL,'',NULL),(370,34,'c_name','模型分类名称','varchar(60)','string','CName','cName','0','0','1','1','1','1','1','LIKE','input','',2,'admin',NULL,'',NULL),(371,34,'c_sort','排序','int(11)','int64','CSort','cSort','0','0','0','1','1','1','1','EQ','input','',3,'admin',NULL,'',NULL),(372,34,'create_by','创建人','int(10) unsigned','int','CreateBy','createBy','0','0','0','0','0','0','0','EQ','input','',4,'admin',NULL,'',NULL),(373,34,'create_time','创建时间','bigint(20) unsigned','int64','CreateTime','createTime','0','0','0','0','0','0','0','EQ','input','',5,'admin',NULL,'',NULL),(374,34,'update_by','修改人','int(10) unsigned','int','UpdateBy','updateBy','0','0','0','0','0','0','0','EQ','input','',6,'admin',NULL,'',NULL),(375,34,'update_time','修改时间','bigint(20) unsigned','int64','UpdateTime','updateTime','0','0','0','0','0','0','0','EQ','input','',7,'admin',NULL,'',NULL),(376,34,'c_status','状态','tinyint(3) unsigned','int','CStatus','cStatus','0','0','1','1','1','1','1','EQ','radio','',8,'admin',NULL,'',NULL),(377,35,'id','','bigint(20) unsigned','int64','Id','id','1','1','0','1','0','0','0','EQ','input','',1,'admin',NULL,'',NULL),(378,35,'user_name','用户名','varchar(60)','string','UserName','userName','0','0','1','1','1','1','1','LIKE','input','',2,'admin',NULL,'',NULL),(379,35,'mobile','中国手机不带国家代码，国际手机号格式为：国家代码-手机号','varchar(20)','string','Mobile','mobile','0','0','0','1','1','1','1','EQ','input','',3,'admin',NULL,'',NULL),(380,35,'user_nickname','用户昵称','varchar(50)','string','UserNickname','userNickname','0','0','1','1','1','1','1','LIKE','input','',4,'admin',NULL,'',NULL),(381,35,'birthday','生日','int(11)','int64','Birthday','birthday','0','0','0','1','1','1','1','EQ','input','',5,'admin',NULL,'',NULL),(382,35,'create_time','注册时间','int(11)','int64','CreateTime','createTime','0','0','0','0','0','0','0','EQ','input','',6,'admin',NULL,'',NULL),(383,35,'user_password','登录密码;cmf_password加密','varchar(255)','string','UserPassword','userPassword','0','0','0','1','1','1','1','EQ','input','',7,'admin',NULL,'',NULL),(384,35,'user_status','用户状态;0:禁用,1:正常,2:未验证','tinyint(3) unsigned','int','UserStatus','userStatus','0','0','1','1','1','1','1','EQ','radio','',8,'admin',NULL,'',NULL),(385,35,'user_email','用户登录邮箱','varchar(100)','string','UserEmail','userEmail','0','0','0','1','1','1','1','EQ','input','',9,'admin',NULL,'',NULL),(386,35,'sex','性别;0:保密,1:男,2:女','tinyint(2)','int','Sex','sex','0','0','0','1','1','1','1','EQ','select','',10,'admin',NULL,'',NULL),(387,35,'avatar','用户头像','varchar(255)','string','Avatar','avatar','0','0','0','1','1','1','1','EQ','input','',11,'admin',NULL,'',NULL),(388,35,'last_login_time','最后登录时间','int(11)','int64','LastLoginTime','lastLoginTime','0','0','0','1','1','1','1','EQ','input','',12,'admin',NULL,'',NULL),(389,35,'last_login_ip','最后登录ip','varchar(15)','string','LastLoginIp','lastLoginIp','0','0','0','1','1','1','1','EQ','input','',13,'admin',NULL,'',NULL),(390,35,'dept_id','部门id','bigint(20) unsigned','int64','DeptId','deptId','0','0','0','1','1','1','1','EQ','input','',14,'admin',NULL,'',NULL),(391,35,'remark','备注','varchar(255)','string','Remark','remark','0','0','0','1','1','1','0','EQ','input','',15,'admin',NULL,'',NULL),(392,35,'is_admin','是否后台管理员 1 是  0   否','tinyint(4)','int','IsAdmin','isAdmin','0','0','0','1','1','1','1','EQ','input','',16,'admin',NULL,'',NULL),(393,37,'c_id','主键','int(10) unsigned','int','CId','cId','1','1','0','1','0','1','1','EQ','input','',1,'admin',NULL,'',NULL),(394,37,'c_name','模型分类名称','varchar(60)','string','CName','cName','0','0','1','1','1','1','1','LIKE','input','',2,'admin',NULL,'',NULL),(395,37,'c_sort','排序','int(11)','int64','CSort','cSort','0','0','0','1','1','1','1','EQ','input','',3,'admin',NULL,'',NULL),(396,37,'create_by','创建人','int(10) unsigned','int','CreateBy','createBy','0','0','0','0','0','0','0','EQ','input','',4,'admin',NULL,'',NULL),(397,37,'create_time','创建时间','bigint(20) unsigned','int64','CreateTime','createTime','0','0','0','0','0','0','0','EQ','input','',5,'admin',NULL,'',NULL),(398,37,'update_by','修改人','int(10) unsigned','int','UpdateBy','updateBy','0','0','0','0','0','0','0','EQ','input','',6,'admin',NULL,'',NULL),(399,37,'update_time','修改时间','bigint(20) unsigned','int64','UpdateTime','updateTime','0','0','0','0','0','0','0','EQ','input','',7,'admin',NULL,'',NULL),(400,37,'c_status','状态','tinyint(3) unsigned','int','CStatus','cStatus','0','0','1','1','1','1','1','EQ','radio','',8,'admin',NULL,'',NULL),(401,38,'id','','bigint(20) unsigned','int64','Id','id','1','1','0','1','0','0','0','EQ','input','',1,'admin',NULL,'',NULL),(402,38,'user_name','用户名','varchar(60)','string','UserName','userName','0','0','1','1','1','1','1','LIKE','input','',2,'admin',NULL,'',NULL),(403,38,'mobile','中国手机不带国家代码，国际手机号格式为：国家代码-手机号','varchar(20)','string','Mobile','mobile','0','0','0','1','1','1','1','EQ','input','',3,'admin',NULL,'',NULL),(404,38,'user_nickname','用户昵称','varchar(50)','string','UserNickname','userNickname','0','0','1','1','1','1','1','LIKE','input','',4,'admin',NULL,'',NULL),(405,38,'birthday','生日','int(11)','int64','Birthday','birthday','0','0','0','1','1','1','1','EQ','input','',5,'admin',NULL,'',NULL),(406,38,'create_time','注册时间','int(11)','int64','CreateTime','createTime','0','0','0','0','0','0','0','EQ','input','',6,'admin',NULL,'',NULL),(407,38,'user_password','登录密码;cmf_password加密','varchar(255)','string','UserPassword','userPassword','0','0','0','1','1','1','1','EQ','input','',7,'admin',NULL,'',NULL),(408,38,'user_status','用户状态;0:禁用,1:正常,2:未验证','tinyint(3) unsigned','int','UserStatus','userStatus','0','0','1','1','1','1','1','EQ','radio','',8,'admin',NULL,'',NULL),(409,38,'user_email','用户登录邮箱','varchar(100)','string','UserEmail','userEmail','0','0','0','1','1','1','1','EQ','input','',9,'admin',NULL,'',NULL),(410,38,'sex','性别;0:保密,1:男,2:女','tinyint(2)','int','Sex','sex','0','0','0','1','1','1','1','EQ','select','sys_user_sex',10,'admin',NULL,'',NULL),(411,38,'avatar','用户头像','varchar(255)','string','Avatar','avatar','0','0','0','1','1','1','1','EQ','input','',11,'admin',NULL,'',NULL),(412,38,'last_login_time','最后登录时间','int(11)','int64','LastLoginTime','lastLoginTime','0','0','0','1','1','1','1','EQ','input','',12,'admin',NULL,'',NULL),(413,38,'last_login_ip','最后登录ip','varchar(15)','string','LastLoginIp','lastLoginIp','0','0','0','1','1','1','1','EQ','input','',13,'admin',NULL,'',NULL),(414,38,'dept_id','部门id','bigint(20) unsigned','int64','DeptId','deptId','0','0','0','1','1','1','1','EQ','input','',14,'admin',NULL,'',NULL),(415,38,'remark','备注','varchar(255)','string','Remark','remark','0','0','0','1','1','1','0','EQ','input','',15,'admin',NULL,'',NULL),(416,38,'is_admin','是否后台管理员 1 是  0   否','tinyint(4)','int','IsAdmin','isAdmin','0','0','0','1','1','1','1','EQ','input','',16,'admin',NULL,'',NULL),(417,39,'c_id','主键','int(10) unsigned','int','CId','cId','1','1','0','1','0','1','1','EQ','input','',1,'admin',NULL,'',NULL),(418,39,'c_name','模型分类名称','varchar(60)','string','CName','cName','0','0','1','1','1','1','1','LIKE','input','',2,'admin',NULL,'',NULL),(419,39,'c_sort','排序','int(11)','int64','CSort','cSort','0','0','0','1','1','1','1','EQ','input','',3,'admin',NULL,'',NULL),(420,39,'create_by','创建人','int(10) unsigned','int','CreateBy','createBy','0','0','0','0','0','0','0','EQ','input','',4,'admin',NULL,'',NULL),(421,39,'create_time','创建时间','bigint(20) unsigned','int64','CreateTime','createTime','0','0','0','0','0','0','0','EQ','input','',5,'admin',NULL,'',NULL),(422,39,'update_by','修改人','int(10) unsigned','int','UpdateBy','updateBy','0','0','0','0','0','0','0','EQ','input','',6,'admin',NULL,'',NULL),(423,39,'update_time','修改时间','bigint(20) unsigned','int64','UpdateTime','updateTime','0','0','0','0','0','0','0','EQ','input','',7,'admin',NULL,'',NULL),(424,39,'c_status','状态','tinyint(3) unsigned','int','CStatus','cStatus','0','0','1','1','1','1','1','EQ','radio','',8,'admin',NULL,'',NULL),(425,40,'id','','bigint(20) unsigned','int64','Id','id','1','1','0','1','0','0','0','EQ','input','',1,'admin',NULL,'',NULL),(426,40,'user_name','用户名','varchar(60)','string','UserName','userName','0','0','1','1','1','1','1','LIKE','input','',2,'admin',NULL,'',NULL),(427,40,'mobile','中国手机不带国家代码，国际手机号格式为：国家代码-手机号','varchar(20)','string','Mobile','mobile','0','0','0','1','1','1','1','EQ','input','',3,'admin',NULL,'',NULL),(428,40,'user_nickname','用户昵称','varchar(50)','string','UserNickname','userNickname','0','0','1','1','1','1','1','LIKE','input','',4,'admin',NULL,'',NULL),(429,40,'birthday','生日','int(11)','int64','Birthday','birthday','0','0','0','1','1','1','','EQ','input','',5,'admin',NULL,'',NULL),(430,40,'create_time','注册时间','int(11)','int64','CreateTime','createTime','0','0','0','0','0','0','0','EQ','input','',6,'admin',NULL,'',NULL),(431,40,'user_password','登录密码;cmf_password加密','varchar(255)','string','UserPassword','userPassword','0','0','0','1','1','1','','EQ','input','',7,'admin',NULL,'',NULL),(432,40,'user_status','用户状态;0:禁用,1:正常,2:未验证','tinyint(3) unsigned','int','UserStatus','userStatus','0','0','1','1','1','1','','EQ','radio','',8,'admin',NULL,'',NULL),(433,40,'user_email','用户登录邮箱','varchar(100)','string','UserEmail','userEmail','0','0','0','1','1','1','','EQ','input','',9,'admin',NULL,'',NULL),(434,40,'sex','性别;0:保密,1:男,2:女','tinyint(2)','int','Sex','sex','0','0','0','1','1','1','','EQ','select','sys_user_sex',10,'admin',NULL,'',NULL),(435,40,'avatar','用户头像','varchar(255)','string','Avatar','avatar','0','0','0','1','1','1','','EQ','input','',11,'admin',NULL,'',NULL),(436,40,'last_login_time','最后登录时间','int(11)','int64','LastLoginTime','lastLoginTime','0','0','0','1','1','1','','EQ','input','',12,'admin',NULL,'',NULL),(437,40,'last_login_ip','最后登录ip','varchar(15)','string','LastLoginIp','lastLoginIp','0','0','0','1','1','1','','EQ','input','',13,'admin',NULL,'',NULL),(438,40,'dept_id','部门id','bigint(20) unsigned','int64','DeptId','deptId','0','0','0','1','1','1','','EQ','input','',14,'admin',NULL,'',NULL),(439,40,'remark','备注','varchar(255)','string','Remark','remark','0','0','0','1','1','1','0','EQ','input','',15,'admin',NULL,'',NULL),(440,40,'is_admin','是否后台管理员 1 是  0   否','tinyint(4)','int','IsAdmin','isAdmin','0','0','0','1','1','1','','EQ','input','',16,'admin',NULL,'',NULL);
/*!40000 ALTER TABLE `gen_table_column` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_category`
--

DROP TABLE IF EXISTS `model_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `model_category` (
  `c_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `c_name` varchar(60) NOT NULL DEFAULT '' COMMENT '模型分类名称',
  `c_sort` int(11) NOT NULL COMMENT '排序',
  `create_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `create_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_by` int(10) unsigned NOT NULL COMMENT '修改人',
  `update_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `c_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`c_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='模型分类表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_category`
--

LOCK TABLES `model_category` WRITE;
/*!40000 ALTER TABLE `model_category` DISABLE KEYS */;
INSERT INTO `model_category` VALUES (1,'政府工作目标管理',0,1,1594000376,2,1596530619,1),(5,'测试分类',0,1,1594016237,2,1596530640,1),(6,'cms',0,1,1595316172,1,1595316184,1);
/*!40000 ALTER TABLE `model_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_fields`
--

DROP TABLE IF EXISTS `model_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `model_fields` (
  `field_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '模型字段ID',
  `model_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '模型ID',
  `field_name` varchar(30) NOT NULL DEFAULT '' COMMENT '字段名称',
  `field_title` varchar(60) NOT NULL DEFAULT '' COMMENT '字段标题',
  `field_type` varchar(30) NOT NULL DEFAULT '' COMMENT '字段类型',
  `field_length` varchar(50) NOT NULL DEFAULT '' COMMENT '字段长度',
  `field_default` varchar(150) NOT NULL DEFAULT '' COMMENT '字段默认值',
  `field_data` varchar(255) NOT NULL DEFAULT '' COMMENT '字段数据',
  `field_desc` varchar(150) NOT NULL DEFAULT '' COMMENT '字段描述',
  `field_rules` varchar(150) NOT NULL DEFAULT '' COMMENT '字段规则',
  `field_sort` bigint(20) NOT NULL DEFAULT '1000' COMMENT '字段排序',
  `field_width` varchar(30) NOT NULL DEFAULT '' COMMENT '字段列表显示宽度',
  `field_align` varchar(30) NOT NULL DEFAULT '' COMMENT '字段列表显示对齐',
  `create_by` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `update_by` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '修改人',
  `create_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`field_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='模型字段表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_fields`
--

LOCK TABLES `model_fields` WRITE;
/*!40000 ALTER TABLE `model_fields` DISABLE KEYS */;
INSERT INTO `model_fields` VALUES (5,6,'id','用户id','number','','','','','unsigned',0,'','',1,0,1595237473,1595237473),(6,6,'username','用户名','text','10','','','用户名','required,unique',1,'','',1,1,1595237518,1595493630),(7,6,'nickname','用户昵称','text','30','张三','','用户昵称','required',2,'','',1,1,1595237549,1595493589),(8,6,'age','年龄','number','','18','','年龄','unsigned',3,'','',1,1,1595300537,1595493575),(12,1,'house_id','房屋ID','number','','','','','unsigned',0,'','',1,0,1595322614,1595322614),(13,1,'belong_houses','所属楼盘','selectnumber','','0','houses|h_id|h_name|h_order','','required,unsigned',1,'','',1,31,1595322665,1599465550),(14,1,'belong_house_type','所属房型','selectnumber','','0','house_type|ht_id|ht_name|ht_order','','required,unsigned,ajax_select_change',2,'','',1,0,1595322728,1595322728),(15,1,'door_number','门牌号','text','10','','','','required,unique',3,'','',1,0,1595322849,1595322849),(16,9,'news_title','文章标题','selectnumber','150','',':cms_news_type','文章标题','required',6,'','',31,31,1595917601,1596415769),(17,9,'news_file','单附件','file','200','','','','',4,'','',31,31,1595917633,1596183979),(18,9,'news_imgs','多图片','images','30','','1:新浪,2:百度,3:腾讯','文章相册','',5,'','',31,31,1595917776,1596184646),(19,9,'art_id','附加表主键','large_number','','0','','','unsigned',0,'','',31,0,1595917830,1595917830),(20,9,'thumbnail','缩略图','imagefile','','','','缩略图','',2,'','',31,31,1596004062,1596095953),(21,9,'news_files','附件','files','','','plug_adtype|adtype_id|adtype_name|adtype_id asc|adtype_id>13','','',3,'','',31,31,1596016878,1596159484),(24,9,'news_content','文章内容','richtext','','','','','',1,'','',31,31,1596095070,1596095912),(25,9,'news_info','多选测试','checkbox','','1','1:张三,2:李四,3:王五','','required',7,'','',31,0,1596420410,1596420410),(26,9,'text_demo','文本测试','text','30','','','','required,unique',8,'','',31,31,1596425871,1596438255),(27,9,'time_demo','时间测试','datetime','','','','','',9,'','',31,0,1596443050,1596443050),(28,10,'project_id','项目主键','large_number','','','','','unsigned',0,'','',2,2,1596528913,1596530964),(29,10,'project_pid','父级ID','large_number','50','0','','','unsigned',2,'','',2,2,1596528959,1596530741),(30,10,'project_title','项目标题','text','150','','','','',3,'','',2,0,1596530780,1596530780),(31,10,'project_no','项目编号','text','50','','','','unique',1,'','',2,0,1596530990,1596530990),(32,10,'project_status','项目状态','switch','','0','','','',4,'','',2,0,1596531263,1596531263),(33,10,'project_report_status','汇报状态','switch','','0','','','',5,'','',2,0,1596531294,1596531294),(34,11,'art_id','附加表主键','large_number','','0','','','unsigned',0,'','',31,0,1595917830,1595917830),(35,11,'news_content','文章内容','richtext','','','','','',1,'','',31,31,1596095070,1596095912);
/*!40000 ALTER TABLE `model_fields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_info`
--

DROP TABLE IF EXISTS `model_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `model_info` (
  `model_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '模型ID',
  `model_category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '模板分类id',
  `model_name` char(30) NOT NULL DEFAULT '' COMMENT '模型标识',
  `model_title` char(30) NOT NULL DEFAULT '' COMMENT '模型名称',
  `model_pk` char(30) NOT NULL DEFAULT '' COMMENT '主键字段',
  `model_order` char(30) NOT NULL DEFAULT '' COMMENT '默认排序字段',
  `model_sort` varchar(255) DEFAULT NULL COMMENT '表单字段排序',
  `model_list` varchar(255) DEFAULT NULL COMMENT '列表显示字段，为空显示全部',
  `model_edit` varchar(255) DEFAULT '' COMMENT '可编辑字段，为空则除主键外均可以编辑',
  `model_indexes` varchar(255) DEFAULT NULL COMMENT '索引字段',
  `search_list` varchar(255) DEFAULT '' COMMENT '高级搜索的字段',
  `create_time` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `model_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `model_engine` varchar(25) NOT NULL DEFAULT 'MyISAM' COMMENT '数据库引擎',
  `create_by` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `update_by` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '修改人',
  PRIMARY KEY (`model_id`) USING BTREE,
  UNIQUE KEY `name_uni` (`model_name`) USING BTREE COMMENT '模型名唯一'
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='文档模型表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_info`
--

LOCK TABLES `model_info` WRITE;
/*!40000 ALTER TABLE `model_info` DISABLE KEYS */;
INSERT INTO `model_info` VALUES (1,5,'house_info','房屋信息','house_id','hi_order','house_id','house_id,belong_houses,belong_house_type,door_number','belong_houses,belong_house_type,door_number','door_number','belong_houses,belong_house_type,door_number',1498101800,1514193091,1,'MyISAM',0,0),(6,1,'demo','测试','id','','id,username,nickname','id,username,nickname,age','username,nickname,age','username,nickname','username,nickname,age',0,1595299599,1,'MyISAM',0,1),(7,5,'demo2','测试2','','','','','','','',1594803649,1594803649,1,'InnoDB',1,0),(8,1,'demo3','测试3','','','','','','','',1594861449,1595583462,1,'InnoDB',1,1),(9,6,'cms_news_attr','文章模型','art_id','','art_id','news_info,text_demo','news_content,thumbnail,news_files,news_file,news_imgs,news_title,news_info,text_demo,time_demo','','news_info,text_demo',1595316217,1596095352,1,'InnoDB',1,31),(10,1,'work_report','政府工作报告','project_id','','','','project_pid,project_title,project_status,project_report_status','','',1596528880,1596530597,1,'InnoDB',2,2),(11,6,'cms_yjf_attr','圆角方','art_id','','art_id','','news_content','','',1595316217,1597128476,1,'InnoDB',1,31);
/*!40000 ALTER TABLE `model_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plug_ad`
--

DROP TABLE IF EXISTS `plug_ad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plug_ad` (
  `ad_id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_name` varchar(50) NOT NULL DEFAULT '' COMMENT '广告名称',
  `ad_adtypeid` tinyint(5) NOT NULL COMMENT '所属位置',
  `ad_checkid` tinyint(2) NOT NULL COMMENT '1=图片 2=JS',
  `ad_js` varchar(255) NOT NULL COMMENT 'JS代码',
  `ad_pic` varchar(200) NOT NULL DEFAULT '' COMMENT '广告图片URL',
  `ad_url` varchar(200) NOT NULL DEFAULT '' COMMENT '广告链接',
  `ad_content` text COMMENT '广告文字内容',
  `ad_addtime` int(11) NOT NULL COMMENT '添加时间',
  `ad_sort` int(11) NOT NULL COMMENT '排序',
  `ad_open` tinyint(2) NOT NULL COMMENT '1=审核  0=未审核',
  PRIMARY KEY (`ad_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plug_ad`
--

LOCK TABLES `plug_ad` WRITE;
/*!40000 ALTER TABLE `plug_ad` DISABLE KEYS */;
INSERT INTO `plug_ad` VALUES (8,'dasfdsf',3,2,'asdasfagsgasdvb','','','fgfdbfd士大夫',1595930069,6,0),(26,'2222',3,1,'asdafasf','pub_upload/2020-07-31/c4kijvnpspakoibsdr.png','sss','ss',1596168625,2,0),(10,'dfgbsdfsd',10,2,'//:www.baiu.ocm','','','fgfdbfd士大夫',1595930194,4,1),(7,'1111',2,1,'','pub_upload/2020-07-31/c4kihqy0j2vczkexag.png','111','11111',1595929955,2,0),(11,'fdgb电风扇',11,1,'','pub_upload/2020-07-31/c4ki6c4v8y0g5kivt6.png','https://wsww.sadf.asvb','fgfdb案发时fd',1595930243,5,1),(27,'121',3,1,'','pub_upload/2020-07-31/c4klu06r1xlk1bnmct.jpg','sdss','cssssssssssssssssssssss',1596177749,2,1),(28,'gfast赞助',21,1,'','pub_upload/2020-10-16/c6e4fmhrpwewesaaia.png','','',1602831749,1,1);
/*!40000 ALTER TABLE `plug_ad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plug_adtype`
--

DROP TABLE IF EXISTS `plug_adtype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plug_adtype` (
  `adtype_id` tinyint(5) NOT NULL AUTO_INCREMENT,
  `adtype_name` varchar(50) NOT NULL DEFAULT '' COMMENT '广告位名称',
  `adtype_sort` int(11) NOT NULL COMMENT '广告位排序',
  PRIMARY KEY (`adtype_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plug_adtype`
--

LOCK TABLES `plug_adtype` WRITE;
/*!40000 ALTER TABLE `plug_adtype` DISABLE KEYS */;
INSERT INTO `plug_adtype` VALUES (3,'fgfghsss',4),(2,'aaaaaa',50),(8,'新增广告位',12),(9,'新增2',23),(10,'asfasfa',34),(11,'345',23),(12,'342342',13),(14,'asdasfa',2),(15,'asdfx',2),(20,'新增3',2),(21,'gfast赞助',0);
/*!40000 ALTER TABLE `plug_adtype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plug_link`
--

DROP TABLE IF EXISTS `plug_link`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plug_link` (
  `link_id` int(5) NOT NULL AUTO_INCREMENT,
  `link_name` varchar(50) NOT NULL COMMENT '链接名称',
  `link_url` varchar(200) NOT NULL COMMENT '链接URL',
  `link_target` varchar(25) NOT NULL DEFAULT '_blank' COMMENT '打开方式',
  `link_typeid` tinyint(4) NOT NULL DEFAULT '0' COMMENT '所属栏目ID',
  `link_qq` varchar(20) NOT NULL COMMENT '联系QQ',
  `link_order` bigint(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `link_addtime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `link_open` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0禁用1启用',
  `link_username` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '申请友情链接的联系人',
  `link_email` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '联系邮箱',
  `link_remark` text CHARACTER SET utf8mb4 NOT NULL COMMENT '申请友情链接时的备注',
  PRIMARY KEY (`link_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plug_link`
--

LOCK TABLES `plug_link` WRITE;
/*!40000 ALTER TABLE `plug_link` DISABLE KEYS */;
INSERT INTO `plug_link` VALUES (2,'asssssssssssssssssasa','/system/plug/linkType/add','_blank',1,'4512335',7,1594689455,1,'','',''),(3,'第一名23','/system/plug/linkType/add','_blank',5,'4512335',4,1594689460,1,'','',''),(5,'梵蒂冈地方11','/system/plug/linkType/add','_blank',3,'4512335',1,1594689469,1,'','',''),(6,'爱的速递撒','/system/plug/linkType/add','_self',4,'4512335',5,1594689473,1,'','',''),(9,'text123','safasga','_blank',1,'4534543',6,1595990353,0,'','',''),(11,'testssssss','safasfasfasd11','_self',3,'3243242',2,1596016372,1,'','',''),(18,'asdas','asf','_blank',1,'11111',3,1596080931,0,'','',''),(19,'百度','https://www.baidu.com/','新标签页打开',13,'177852',1,1601194070,1,'老李','11312','dasfasfaf'),(20,'百度翻译','https://fanyi.baidu.com/#en/zh/','本窗口打开',13,'123124',1,1602325353,1,'asdasf','2134@qq.com','通过一下'),(21,'h','hjgjh','_blank',0,'45646',1,1602747055,0,'4','6546@qq.com','jhgj'),(23,'asdsa','http://www.baidu.com','_blank',0,'12312312',0,1602830363,0,'萨达所所多','asdas@qq','fasd'),(24,'asd','https://fanyi.baidu.com/#en/zh/','_blank',0,'21312312',0,1602830396,0,'asd ','sadq@qq','sadsad ');
/*!40000 ALTER TABLE `plug_link` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plug_linktype`
--

DROP TABLE IF EXISTS `plug_linktype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plug_linktype` (
  `linktype_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `linktype_name` varchar(30) NOT NULL COMMENT '所属栏目名称',
  `linktype_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`linktype_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plug_linktype`
--

LOCK TABLES `plug_linktype` WRITE;
/*!40000 ALTER TABLE `plug_linktype` DISABLE KEYS */;
INSERT INTO `plug_linktype` VALUES (1,'我的',5),(2,'fasf',4),(3,'fvcc',3),(4,'gfdgd',3),(5,'fdvcc',6),(8,'dsfg',3),(13,'博客友情链接',3);
/*!40000 ALTER TABLE `plug_linktype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role`
--

DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态;0:禁用;1:正常',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `list_order` float NOT NULL DEFAULT '0' COMMENT '排序',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `data_scope` tinyint(3) unsigned NOT NULL DEFAULT '3' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role`
--

LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` VALUES (1,1,1582773740,1593680183,0,'超级管理员','备注',3),(2,1,1582773740,1593684627,0,'普通管理员','备注',3),(3,1,1582773740,0,0,'站点管理员','站点管理人员',3),(4,1,1582773740,0,0,'初级管理员','初级管理员',3),(5,1,1582773740,0,0,'高级管理员','高级管理员',3),(8,1,1582773740,1593506004,0,'区级管理员','',2);
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_dept`
--

DROP TABLE IF EXISTS `role_dept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_dept` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和部门关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_dept`
--

LOCK TABLES `role_dept` WRITE;
/*!40000 ALTER TABLE `role_dept` DISABLE KEYS */;
INSERT INTO `role_dept` VALUES (8,109),(8,200),(8,201);
/*!40000 ALTER TABLE `role_dept` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_config`
--

DROP TABLE IF EXISTS `sys_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_config` (
  `config_id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
  `config_type` tinyint(1) DEFAULT '0' COMMENT '系统内置（Y是 N否）',
  `create_by` int(64) unsigned DEFAULT '0' COMMENT '创建者',
  `create_time` bigint(20) unsigned DEFAULT '0' COMMENT '创建时间',
  `update_by` int(64) unsigned DEFAULT '0' COMMENT '更新者',
  `update_time` bigint(20) unsigned DEFAULT '0' COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`),
  UNIQUE KEY `uni_config_key` (`config_key`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_config`
--

LOCK TABLES `sys_config` WRITE;
/*!40000 ALTER TABLE `sys_config` DISABLE KEYS */;
INSERT INTO `sys_config` VALUES (1,'文件上传-文件大小','sys.uploadFile.fileSize','50M',1,31,1582968376,0,0,'文件上传大小限制'),(2,'文件上传-文件类型','sys.uploadFile.fileType','doc,docx,zip,xls,xlsx,rar,jpg,jpeg,gif,npm,png',1,31,1582968465,31,1592963888,'文件上传后缀类型限制'),(3,'图片上传-图片类型','sys.uploadFile.imageType','jpg,jpeg,gif,npm,png',1,31,1582968519,0,0,'图片上传后缀类型限制'),(4,'图片上传-图片大小','sys.uploadFile.imageSize','50M',1,31,1582968538,31,1582991905,'图片上传大小限制');
/*!40000 ALTER TABLE `sys_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dept`
--

DROP TABLE IF EXISTS `sys_dept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父部门id',
  `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称',
  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
  `leader` varchar(20) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8mb4 COMMENT='部门表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dept`
--

LOCK TABLES `sys_dept` WRITE;
/*!40000 ALTER TABLE `sys_dept` DISABLE KEYS */;
INSERT INTO `sys_dept` VALUES (100,0,'0','若依科技',0,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:54:39'),(101,100,'0,100','深圳总公司',1,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:54:45'),(102,100,'0,100','长沙分公司',2,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:55:08'),(103,101,'0,100,101','研发部门',1,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:54:49'),(104,101,'0,100,101','市场部门',2,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:54:53'),(105,101,'0,100,101','测试部门',3,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:54:57'),(106,101,'0,100,101','财务部门',4,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:55:00'),(107,101,'0,100,101','运维部门',5,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:55:04'),(108,102,'0,100,102','市场部门',1,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:55:12'),(109,102,'0,100,102','财务部门',2,'若依','15888888888','ry@qq.com','1','0','admin','2018-03-16 11:33:00','','2020-06-30 14:55:18'),(200,100,'','大数据',1,'小刘','18888888888','liou@qq.com','1','0','',NULL,'',NULL),(201,100,'','开发',1,'老李','18888888888','li@qq.com','1','0','admin','2020-06-19 10:14:06','','2020-06-30 14:55:22'),(202,108,'','外勤',1,'小a','18888888888','aa@qq.com','1','0','','2020-06-19 14:59:44','','2020-06-30 14:55:15'),(203,108,'','行政',0,'aa','18888888888','aa@qq.com','0','0','','2020-07-03 11:44:57','',NULL);
/*!40000 ALTER TABLE `sys_dept` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dict_data`
--

DROP TABLE IF EXISTS `sys_dict_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_dict_data` (
  `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
  `is_default` tinyint(1) DEFAULT '0' COMMENT '是否默认（1是 0否）',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` bigint(64) unsigned DEFAULT '0' COMMENT '创建者',
  `create_time` bigint(20) unsigned DEFAULT '0' COMMENT '创建时间',
  `update_by` bigint(64) unsigned DEFAULT '0' COMMENT '更新者',
  `update_time` bigint(20) unsigned DEFAULT '0' COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='字典数据表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dict_data`
--

LOCK TABLES `sys_dict_data` WRITE;
/*!40000 ALTER TABLE `sys_dict_data` DISABLE KEYS */;
INSERT INTO `sys_dict_data` VALUES (1,0,'男','1','sys_user_sex','','',0,1,31,1582884113,31,1593656868,'备注信息'),(2,0,'女','2','sys_user_sex','','',0,1,31,1582884125,31,1593656871,'备注信息'),(3,0,'保密','0','sys_user_sex','','',1,1,31,1582884871,31,1593656875,'备注信息'),(24,0,'频道页','1','cms_category_type','','',0,1,31,1583131942,31,1592532634,'作为频道页，不可作为栏目发布文章，可添加下级分类'),(25,0,'发布栏目','2','cms_category_type','','',0,1,31,1583132032,31,1592532724,'作为发布栏目，可添加文章'),(26,0,'跳转栏目','3','cms_category_type','','',0,1,31,1583132125,31,1592532737,'不直接发布内容，用于跳转页面'),(27,0,'单页栏目','4','cms_category_type','','',0,1,31,1583132145,31,1592532755,'单页面模式，分类直接显示为文章'),(28,0,'正常','0','sys_job_status','','default',1,1,31,1583762727,0,0,''),(29,0,'暂停','1','sys_job_status','','default',0,1,31,1583762751,31,1583763095,''),(30,0,'默认','DEFAULT','sys_job_group','','default',1,1,31,1583762854,0,0,''),(31,0,'系统','SYSTEM','sys_job_group','','default',0,1,31,1583762889,0,0,''),(32,0,'成功','1','admin_login_status','','default',0,1,31,1583891238,31,1583891244,''),(33,0,'失败','0','admin_login_status','','default',0,1,31,1583891262,0,0,''),(34,0,'成功','1','sys_oper_log_status','','default',0,1,31,1583917929,0,0,''),(35,0,'失败','0','sys_oper_log_status','','default',0,1,31,1583917942,0,0,''),(36,0,'重复执行','1','sys_job_policy','','default',1,1,31,1584687209,0,0,''),(37,0,'执行一次','2','sys_job_policy','','default',1,1,31,1584687226,0,0,''),(38,0,'显示','1','sys_show_hide',NULL,'default',1,1,31,1584687226,0,0,NULL),(39,0,'隐藏','0','sys_show_hide',NULL,'default',0,1,31,1584687226,0,0,NULL),(40,0,'正常','1','sys_normal_disable','','default',1,1,31,1592214217,0,0,''),(41,0,'停用','0','sys_normal_disable','','default',0,1,31,1592214239,0,0,''),(49,0,'是','1','sys_yes_no','','',1,1,31,1592381742,0,1592381742,''),(50,0,'否','0','sys_yes_no','','',0,1,31,1592381753,0,1592381753,''),(51,0,'已发布','1','cms_news_pub_type','','',1,1,31,1593336428,31,1593393871,''),(54,0,'未发布','0','cms_news_pub_type','','',0,1,31,1593393852,0,1593393852,''),(55,0,'置顶','1','cms_news_attr','','',0,1,31,1593394753,0,1593394753,''),(56,0,'推荐','2','cms_news_attr','','',0,1,31,1593394762,0,1593394762,''),(57,0,'普通文章','0','cms_news_type','','',0,1,31,1593397458,31,1593399098,''),(58,0,'跳转链接','1','cms_news_type','','',0,1,31,1593397468,31,1593399105,''),(59,0,'cms模型','6','cms_cate_models','','',0,1,1,1595495461,1,1595580310,''),(64,0,'幻灯','3','cms_news_attr','','',0,1,31,1597648857,0,1597648857,'');
/*!40000 ALTER TABLE `sys_dict_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dict_type`
--

DROP TABLE IF EXISTS `sys_dict_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `status` tinyint(1) unsigned DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` int(64) unsigned DEFAULT '0' COMMENT '创建者',
  `create_time` bigint(20) unsigned DEFAULT '0' COMMENT '创建时间',
  `update_by` int(64) unsigned DEFAULT '0' COMMENT '更新者',
  `update_time` bigint(20) unsigned DEFAULT '0' COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`) USING BTREE,
  UNIQUE KEY `dict_type` (`dict_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='字典类型表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dict_type`
--

LOCK TABLES `sys_dict_type` WRITE;
/*!40000 ALTER TABLE `sys_dict_type` DISABLE KEYS */;
INSERT INTO `sys_dict_type` VALUES (1,'用户性别','sys_user_sex',1,31,1582789177,31,1593596901,'用于选择用户性别'),(2,'分类类型','cms_category_type',1,31,1582789253,31,1583131577,'文章分类类型'),(3,'任务状态','sys_job_status',1,31,1582789296,31,1583762542,'任务状态列表'),(13,'任务分组','sys_job_group',1,31,1583762785,0,0,''),(14,'管理员登录状态','admin_login_status',1,31,1583891209,0,0,''),(15,'操作日志状态','sys_oper_log_status',1,31,1583917888,0,0,''),(16,'任务策略','sys_job_policy',1,31,1584687171,0,0,''),(17,'菜单状态','sys_show_hide',1,31,1584687171,0,1584687171,'菜单状态'),(18,'系统开关','sys_normal_disable',1,31,1592214147,31,1592362799,'系统开关'),(24,'系统内置','sys_yes_no',1,31,1592381722,0,0,''),(25,'文章发布状态','cms_news_pub_type',1,31,1593336396,0,0,''),(26,'文章附加状态','cms_news_attr',1,31,1593394729,0,0,''),(27,'文章类型','cms_news_type',1,31,1593397441,0,0,''),(28,'文章栏目模型分类','cms_cate_models',1,1,1595495428,0,0,'');
/*!40000 ALTER TABLE `sys_dict_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_job`
--

DROP TABLE IF EXISTS `sys_job`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `job_name` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称',
  `job_params` varchar(200) DEFAULT '' COMMENT '参数',
  `job_group` varchar(64) NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `cron_expression` varchar(255) DEFAULT '' COMMENT 'cron执行表达式',
  `misfire_policy` tinyint(4) DEFAULT '1' COMMENT '计划执行策略（1多次执行 2执行一次）',
  `concurrent` tinyint(4) DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
  `status` tinyint(4) DEFAULT '0' COMMENT '状态（0正常 1暂停）',
  `create_by` bigint(64) unsigned DEFAULT '0' COMMENT '创建者',
  `create_time` bigint(20) unsigned DEFAULT '1' COMMENT '创建时间',
  `update_by` bigint(64) unsigned DEFAULT '0' COMMENT '更新者',
  `update_time` bigint(20) unsigned DEFAULT '0' COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注信息',
  PRIMARY KEY (`job_id`,`job_name`,`job_group`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_job`
--

LOCK TABLES `sys_job` WRITE;
/*!40000 ALTER TABLE `sys_job` DISABLE KEYS */;
INSERT INTO `sys_job` VALUES (1,'测试任务1','','DEFAULT','test1','* * * * * *',1,0,1,1,1583805259,31,1593566793,''),(2,'测试任务2','hello|gfast','DEFAULT','test2','* * * * * *',1,0,1,1,1583805312,1,1583809723,'备注'),(6,'测试任务3','hello|gfast','DEFAULT','test2','* * * * * *',1,0,1,1,1583811085,31,1593398575,'备注'),(8,'在线用户定时更新','','DEFAULT','checkUserOnline','5 */10 * * * *',1,0,0,2,1596763977,2,1596768044,'');
/*!40000 ALTER TABLE `sys_job` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_login_log`
--

DROP TABLE IF EXISTS `sys_login_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_login_log` (
  `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `login_name` varchar(50) DEFAULT '' COMMENT '登录账号',
  `ipaddr` varchar(50) DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) DEFAULT '' COMMENT '操作系统',
  `status` tinyint(4) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) DEFAULT '' COMMENT '提示消息',
  `login_time` bigint(20) DEFAULT '0' COMMENT '访问时间',
  `module` varchar(30) DEFAULT NULL COMMENT '登录模块',
  PRIMARY KEY (`info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='系统访问记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_login_log`
--

LOCK TABLES `sys_login_log` WRITE;
/*!40000 ALTER TABLE `sys_login_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_login_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_oper_log`
--

DROP TABLE IF EXISTS `sys_oper_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_oper_log` (
  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) DEFAULT '' COMMENT '模块标题',
  `business_type` int(2) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` int(1) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(500) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(50) DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `oper_param` text COMMENT '请求参数',
  `json_result` text COMMENT '返回参数',
  `status` int(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
  `oper_time` bigint(20) DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`oper_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COMMENT='操作日志记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_oper_log`
--

LOCK TABLES `sys_oper_log` WRITE;
/*!40000 ALTER TABLE `sys_oper_log` DISABLE KEYS */;
INSERT INTO `sys_oper_log` VALUES (1,'清空',0,'/system/monitor/operlog/clear','DELETE',1,'demo','','/system/monitor/operlog/clear','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"清除成功\"}',1,'',1603359067),(2,'',0,'/system/monitor/operlog/list','GET',1,'demo','','/system/monitor/operlog/list?pageNum=1&pageSize=10&beginTime=&endTime=','[::1]','内网IP','{\"beginTime\":\"\",\"endTime\":\"\",\"pageNum\":\"1\",\"pageSize\":\"10\"}','{\"code\":0,\"msg\":\"操作日志列表\"}',1,'',1603359067),(3,'文章管理',0,'/system/cms/news/list','GET',1,'demo','','/system/cms/news/list?pageNum=1&pageSize=10&keyWords=','[::1]','内网IP','{\"keyWords\":\"\",\"pageNum\":\"1\",\"pageSize\":\"10\"}','{\"code\":0,\"msg\":\"信息列表\"}',1,'',1603359073),(4,'栏目管理',0,'/system/cms/menu/list','GET',1,'demo','','/system/cms/menu/list','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359074),(5,'',0,'/system/cms/menu/modelOptions','GET',1,'demo','','/system/cms/menu/modelOptions','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359074),(6,'文章管理',0,'/system/cms/news/list','GET',1,'demo','','/system/cms/news/list?pageNum=1&pageSize=10&keyWords=','[::1]','内网IP','{\"keyWords\":\"\",\"pageNum\":\"1\",\"pageSize\":\"10\"}','{\"code\":0,\"msg\":\"信息列表\"}',1,'',1603359393),(7,'',0,'/system/index/getInfo','GET',1,'demo','','/system/index/getInfo','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359395),(8,'',0,'/system/index/getRouters','GET',1,'demo','','/system/index/getRouters','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359395),(9,'栏目管理',0,'/system/cms/menu/list','GET',1,'demo','','/system/cms/menu/list','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359395),(10,'',0,'/system/cms/menu/modelOptions','GET',1,'demo','','/system/cms/menu/modelOptions','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359395),(11,'添加栏目',0,'/system/cms/menu/add','GET',1,'demo','','/system/cms/menu/add','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"添加栏目\"}',1,'',1603359397),(12,'',0,'/system/index/getInfo','GET',1,'demo','','/system/index/getInfo','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359404),(13,'',0,'/system/index/getRouters','GET',1,'demo','','/system/index/getRouters','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359404),(14,'栏目管理',0,'/system/cms/menu/list','GET',1,'demo','','/system/cms/menu/list','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359405),(15,'',0,'/system/cms/menu/modelOptions','GET',1,'demo','','/system/cms/menu/modelOptions','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359405),(16,'修改栏目',0,'/system/cms/menu/edit','GET',1,'demo','','/system/cms/menu/edit?id=14','[::1]','内网IP','{\"id\":\"14\"}','{\"code\":0,\"msg\":\"修改栏目\"}',1,'',1603359406),(17,'修改栏目',0,'/system/cms/menu/edit','POST',1,'demo','','/system/cms/menu/edit','[::1]','内网IP','{\"alias\":\"\",\"cate_address\":\"\",\"cate_content\":\"\",\"cate_type\":\"2\",\"content_template\":\"content/show.html\",\"description\":\"\",\"id\":14,\"input_seo_description\":\"\",\"input_seo_keywords\":\"\",\"input_seo_title\":\"\",\"list_template\":\"list/list.html\",\"model_id\":11,\"name\":\"专题专栏\",\"parent_id\":0,\"status\":\"1\",\"thumbnail\":\"\"}','{\"code\":0,\"msg\":\"栏目修改成功\"}',1,'',1603359411),(18,'栏目管理',0,'/system/cms/menu/list','GET',1,'demo','','/system/cms/menu/list','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359411),(19,'修改栏目',0,'/system/cms/menu/edit','GET',1,'demo','','/system/cms/menu/edit?id=14','[::1]','内网IP','{\"id\":\"14\"}','{\"code\":0,\"msg\":\"修改栏目\"}',1,'',1603359412),(20,'',0,'/system/index/getInfo','GET',1,'demo','','/system/index/getInfo','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359415),(21,'',0,'/system/index/getRouters','GET',1,'demo','','/system/index/getRouters','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359415),(22,'栏目管理',0,'/system/cms/menu/list','GET',1,'demo','','/system/cms/menu/list','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359415),(23,'',0,'/system/cms/menu/modelOptions','GET',1,'demo','','/system/cms/menu/modelOptions','[::1]','内网IP','{}','{\"code\":0,\"msg\":\"ok\"}',1,'',1603359415),(24,'修改栏目',0,'/system/cms/menu/edit','GET',1,'demo','','/system/cms/menu/edit?id=14','[::1]','内网IP','{\"id\":\"14\"}','{\"code\":0,\"msg\":\"修改栏目\"}',1,'',1603359416);
/*!40000 ALTER TABLE `sys_oper_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_post`
--

DROP TABLE IF EXISTS `sys_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_post` (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `post_code` varchar(64) NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) NOT NULL COMMENT '岗位名称',
  `post_sort` int(4) NOT NULL COMMENT '显示顺序',
  `status` char(1) NOT NULL COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`post_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='岗位信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_post`
--

LOCK TABLES `sys_post` WRITE;
/*!40000 ALTER TABLE `sys_post` DISABLE KEYS */;
INSERT INTO `sys_post` VALUES (1,'ceo','董事长',1,'1','',NULL,'','2020-07-02 10:09:11',''),(2,'se','项目经理',2,'1','',NULL,'','2020-07-02 10:09:14',''),(3,'hr','人力资源',3,'1','',NULL,'','2020-07-02 10:09:18',''),(4,'user','普通员工',4,'1','',NULL,'','2020-07-02 10:09:22','');
/*!40000 ALTER TABLE `sys_post` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '中国手机不带国家代码，国际手机号格式为：国家代码-手机号',
  `user_nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
  `birthday` int(11) NOT NULL DEFAULT '0' COMMENT '生日',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间',
  `user_password` varchar(255) NOT NULL DEFAULT '' COMMENT '登录密码;cmf_password加密',
  `user_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '用户状态;0:禁用,1:正常,2:未验证',
  `user_email` varchar(100) NOT NULL DEFAULT '' COMMENT '用户登录邮箱',
  `sex` tinyint(2) NOT NULL DEFAULT '0' COMMENT '性别;0:保密,1:男,2:女',
  `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '用户头像',
  `last_login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `last_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `dept_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '部门id',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `is_admin` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否后台管理员 1 是  0   否',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_login` (`user_name`) USING BTREE,
  UNIQUE KEY `mobile` (`mobile`) USING BTREE,
  KEY `user_nickname` (`user_nickname`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'admin','18687455555','超级管理员',0,1557715675,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'yxh669@qq.com',1,'pub_upload/2020-07-06/c3z4ly6gknispnpjea.jpeg',1595208583,'[::1]',101,'',1),(2,'yixiaohu','13699885599','奈斯',0,0,'9OFlt5qzzvCiZWhe7ilcLA==',1,'yxh@qq.com',1,'',1597310548,'[::1]',102,'备注',1),(3,'zs','16399669855','张三',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'zs@qq.com',0,'',1559293160,'127.0.0.1',101,'',1),(4,'qlgl','13758596696','测试c',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',0,'qlgl@qq.com',0,'',1559293134,'127.0.0.1',102,'',1),(5,'test','13845696696','测试2',0,0,'9OFlt5qzzvCiZWhe7ilcLA==',0,'123@qq.com',0,'',0,'',101,'',0),(6,'18999998889','13755866654','刘大大',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'1223@qq.com',0,'',0,'',103,'',1),(7,'zmm','13788566696','张明明',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'11123@qq.com',0,'',0,'',104,'',1),(8,'lxx','13756566696','李小小',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'123333@qq.com',0,'',1571729563,'127.0.0.1',101,'',1),(10,'xmm','13588999969','小秘密',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'',0,'',0,'',101,'',1),(14,'cd_19','123154564','看金利科技',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'',0,'',0,'',0,'',1),(15,'lmm','13587754545','刘敏敏',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'a@coc.com',0,'',0,'',201,'',1),(16,'ldn','13899658874','李大牛',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'a@ll.con',0,'',0,'',102,'',1),(20,'dbc','13877555566','大百词',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'',0,'',0,'',0,'',1),(22,'yxfmlbb','15969423326','yxf',0,1557715675,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'yxh6691@qq.com',0,'',1565059554,'127.0.0.1',200,'',1),(23,'wangming','13699888855','王明',0,0,'IJ1xz+Wve+ZONVMFfXJQMw==',1,'',0,'',0,'',0,'',1),(24,'zhk','13699885591','综合科',0,0,'IZNU7Pn91/++830Pi6HAWA==',1,'',0,'',1569288069,'192.168.0.146',0,'',1),(28,'demo3','18699888855','测试账号1',0,1581314035,'9OFlt5qzzvCiZWhe7ilcLA==',1,'',0,'',0,'',0,'',1),(31,'demo','18699888856','测试账号',0,1581314770,'9OFlt5qzzvCiZWhe7ilcLA==',1,'223@qq.com',2,'pub_upload/2020-09-03/c5disauti1wogasemy.jpeg',1599448473,'[::1]',109,'',1),(32,'demo100','18699888859','测试账号1',0,1582103659,'9OFlt5qzzvCiZWhe7ilcLA==',1,'',0,'',0,'',0,'',1),(33,'demo110','18699888853','测试账号1',0,1582109337,'9OFlt5qzzvCiZWhe7ilcLA==',1,'',0,'',0,'',0,'',1);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_online`
--

DROP TABLE IF EXISTS `user_online`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_online` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT '用户标识',
  `token` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT '用户token',
  `create_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '登录时间',
  `user_name` varchar(255) NOT NULL COMMENT '用户名',
  `ip` varchar(120) NOT NULL DEFAULT '' COMMENT '登录ip',
  `explorer` varchar(30) NOT NULL DEFAULT '' COMMENT '浏览器',
  `os` varchar(30) NOT NULL DEFAULT '' COMMENT '操作系统',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uni_token` (`token`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=16361 DEFAULT CHARSET=utf8mb4 COMMENT='用户在线状态表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_online`
--

LOCK TABLES `user_online` WRITE;
/*!40000 ALTER TABLE `user_online` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_online` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_post`
--

DROP TABLE IF EXISTS `user_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_post` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户与岗位关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_post`
--

LOCK TABLES `user_post` WRITE;
/*!40000 ALTER TABLE `user_post` DISABLE KEYS */;
INSERT INTO `user_post` VALUES (1,2),(1,3),(2,1),(2,2),(3,1),(5,2),(15,4),(16,2),(22,1),(22,2),(31,2);
/*!40000 ALTER TABLE `user_post` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_set`
--

DROP TABLE IF EXISTS `web_set`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_set` (
  `web_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `web_content` text CHARACTER SET utf8 COMMENT '站点信息',
  PRIMARY KEY (`web_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_set`
--

LOCK TABLES `web_set` WRITE;
/*!40000 ALTER TABLE `web_set` DISABLE KEYS */;
INSERT INTO `web_set` VALUES (2,'{\"webLogo\":\"pub_upload/2020-08-07/c4qgtm9okus0lbku6g.jpg\",\"webName\":\"gfast\",\"webSite\":\"localhost\"}');
/*!40000 ALTER TABLE `web_set` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-10-22 17:39:50
