同步操作将从 enilu/web-flash 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
/*Navicat MySQL Data TransferSource Server : localhostSource Server Version : 50725Source Host : localhost:3306Source Database : web-flashTarget Server Type : MYSQLTarget Server Version : 50725File Encoding : 65001Date: 2020年06月21日 21:33:27*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `t_cms_article`-- ----------------------------DROP TABLE IF EXISTS `t_cms_article`;CREATE TABLE `t_cms_article` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`author` varchar(64) DEFAULT NULL COMMENT '作者',`content` text COMMENT '内容',`id_channel` bigint(20) NOT NULL COMMENT '栏目id',`img` varchar(64) DEFAULT NULL COMMENT '文章题图ID',`title` varchar(128) DEFAULT NULL COMMENT '标题',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='文章';-- ------------------------------ Records of t_cms_article-- ----------------------------INSERT INTO `t_cms_article` VALUES ('1', '1', '2019-03-09 16:24:58', '1', '2019-05-10 13:22:49', 'enilu', '<div id=\"articleContent\" class=\"content\">\n<div class=\"ad-wrap\">\n<p style=\"margin: 0 0 10px 0;\">一般我们都有这样的需求:我需要知道库中的数据是由谁创建,什么时候创建,最后一次修改时间是什么时候,最后一次修改人是谁。web-flash最新代码已经实现该需求,具体实现方式网上有很多资料,这里做会搬运工,将web-flash的实现步骤罗列如下:%%</p>\n</div>\n<p>在Spring jpa中可以通过在实体bean的属性或者方法上添加以下注解来实现上述需求@CreatedDate、@CreatedBy、@LastModifiedDate、@LastModifiedBy。</p>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>@CreatedDate 表示该字段为创建时间时间字段,在这个实体被insert的时候,会设置值</p>\n</li>\n<li>\n<p>@CreatedBy 表示该字段为创建人,在这个实体被insert的时候,会设置值</p>\n</li>\n<li>\n<p>@LastModifiedDate 最后修改时间 实体被update的时候会设置</p>\n</li>\n<li>\n<p>@LastModifiedBy 最后修改人 实体被update的时候会设置</p>\n</li>\n</ul>\n<h2>使用方式</h2>\n<h3>实体类添加注解</h3>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>首先在实体中对应的字段加上上述4个注解</p>\n</li>\n<li>\n<p>在web-flash中我们提取了一个基础实体类BaseEntity,并将对应的字段添加上述4个注解,所有需要记录维护信息的表对应的实体都集成该类</p>\n</li>\n</ul>\n<pre>import org.springframework.data.annotation.CreatedBy;\nimport org.springframework.data.annotation.CreatedDate;\nimport org.springframework.data.annotation.LastModifiedBy;\nimport org.springframework.data.annotation.LastModifiedDate;\nimport javax.persistence.Column;\nimport javax.persistence.GeneratedValue;\nimport javax.persistence.Id;\nimport javax.persistence.MappedSuperclass;\nimport java.io.Serializable;\nimport java.util.Date;\n@MappedSuperclass\n@Data\npublic abstract class BaseEntity implements Serializable {\n @Id\n @GeneratedValue\n private Long id;\n @CreatedDate\n @Column(name = \"create_time\",columnDefinition=\"DATETIME COMMENT \'创建时间/注册时间\'\")\n private Date createTime;\n @Column(name = \"create_by\",columnDefinition=\"bigint COMMENT \'创建人\'\")\n @CreatedBy\n private Long createBy;\n @LastModifiedDate\n @Column(name = \"modify_time\",columnDefinition=\"DATETIME COMMENT \'最后更新时间\'\")\n private Date modifyTime;\n @LastModifiedBy\n @Column(name = \"modify_by\",columnDefinition=\"bigint COMMENT \'最后更新人\'\")\n private Long modifyBy;\n}</pre>\n<h3>实现AuditorAware接口返回操作人员的id</h3>\n<p>配置完上述4个注解后,在jpa.save方法被调用的时候,时间字段会自动设置并插入数据库,但是CreatedBy和LastModifiedBy并没有赋值 这两个信息需要实现AuditorAware接口来返回操作人员的id</p>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>首先需要在项目启动类添加@EnableJpaAuditing 注解来启用审计功能</p>\n</li>\n</ul>\n<pre>@SpringBootApplication\n@EnableJpaAuditing\npublic class AdminApplication extends WebMvcConfigurerAdapter {\n //省略\n}</pre>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>然后实现AuditorAware接口返回操作人员的id</p>\n</li>\n</ul>\n<pre>@Configuration\npublic class UserIDAuditorConfig implements AuditorAware<Long> {\n @Override\n public Long getCurrentAuditor() {\n ShiroUser shiroUser = ShiroKit.getUser();\n if(shiroUser!=null){\n return shiroUser.getId();\n }\n return null;\n }\n}</pre>\n</div>', '1', '1', 'web-flash 将所有表增加维护人员和维护时间信息');INSERT INTO `t_cms_article` VALUES ('2', '1', '2019-03-09 16:24:58', '1', '2019-03-23 23:12:16', 'enilu.cn', '<div id=\"articleContent\" class=\"content\">\n<div class=\"ad-wrap\">\n<p style=\"margin: 0 0 10px 0;\"><a style=\"color: #a00; font-weight: bold;\" href=\"https://my.oschina.net/u/3985214/blog/3018099?tdsourcetag=s_pcqq_aiomsg\" target=\"_blank\" rel=\"noopener\" data-traceid=\"news_detail_above_text_link_1\" data-tracepid=\"news_detail_above_text_link\">开发十年,就只剩下这套架构体系了! >>></a> <img style=\"max-height: 32px; max-width: 32px;\" src=\"https://www.oschina.net/img/hot3.png\" align=\"\" /></p>\n</div>\n<h3>国际化</h3>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>web-flash实现国际化了.</p>\n</li>\n<li>\n<p>不了解上面两个的区别的同学可以再回顾下这个<a href=\"http://www.enilu.cn/web-flash/base/web-flash.html\">文档</a></p>\n</li>\n<li>\n<p>web-flash实现国际化的方式参考vue-element-admin的 <a href=\"https://panjiachen.github.io/vue-element-admin-site/zh/guide/advanced/i18n.html\" target=\"_blank\" rel=\"noopener\">官方文档</a>,这里不再赘述,强烈建议你先把文档读了之后再看下面的内容。</p>\n</li>\n</ul>\n<h3>默认约定</h3>\n<p>针对网站资源进行国际园涉及到的国际化资源的管理维护,这里给出一些web-flash的资源分类建议,当然,你也可以根据你的实际情况进行调整。</p>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>src/lang/为国际化资源目录,目前提供了英文(en.js)和中文(zh.js)的两种语言实现。</p>\n</li>\n<li>\n<p>目前资源语言资源文件中是json配置主要有以下几个节点:</p>\n</li>\n<ul class=\" list-paddingleft-2\" style=\"list-style-type: square;\">\n<li>\n<p>route 左侧菜单资源</p>\n</li>\n<li>\n<p>navbar 顶部导航栏资源</p>\n</li>\n<li>\n<p>button 公共的按钮资源,比如:添加、删除、修改、确定、取消之类等等</p>\n</li>\n<li>\n<p>common 其他公共的资源,比如一些弹出框标题、提示信息、label等等</p>\n</li>\n<li>\n<p>login 登录页面资源</p>\n</li>\n<li>\n<p>config 参数管理界面资源</p>\n</li>\n</ul>\n<li>\n<p>目前针对具体的页面资源只做了登录和参数管理两个页面,其他具体业务界面仅针对公共的按钮做了国际化,你可以参考config页面资源进行配置进行进一步配置:/src/views/cfg/</p>\n</li>\n<li>\n<p>如果你有其他资源在上面对应的节点添加即可,针对每个页面特有的资源以页面名称作为几点进行维护,这样方便记忆和维护,不容易出错。</p>\n</li>\n</ul>\n<h3>添加新的语言支持</h3>\n<p>如果英文和中文两种语言不够,那么你可以通过下面步骤添加语言支持</p>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>在src/lang/目录下新增对应的资源文件</p>\n</li>\n<li>\n<p>在src/lang/index.js中import对应的资源文件</p>\n</li>\n<li>\n<p>在src/lang/index.js中的messages变量中加入新的语言声明</p>\n</li>\n<li>\n<p>在src/components/LangSelect/index.vue的语言下拉框中增加新的语言选项</p>\n</li>\n</ul>\n<h3>演示地址</h3>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>vue版本后台管理 <a href=\"http://106.75.35.53:8082/vue/#/login\" target=\"_blank\" rel=\"noopener\">http://106.75.35.53:8082/vue/#/login</a></p>\n</li>\n<li>CMS内容管理系统的h5前端demo:<a href=\"http://106.75.35.53:8082/mobile/#/index\" target=\"_blank\" rel=\"noopener\">http://106.75.35.53:8082/mobile/#/index</a></li>\n</ul>\n</div>', '1', '2', 'web-flash1.0.1 发布,增加国际化和定时任务管理功能');INSERT INTO `t_cms_article` VALUES ('3', '1', '2019-03-09 16:24:58', '1', '2019-04-28 17:39:52', 'enilu.cn', '<div class=\"content\" id=\"articleContent\">\r\n <div class=\"ad-wrap\">\r\n <p style=\"margin:0 0 10px 0;\"><a data-traceid=\"news_detail_above_text_link_1\" data-tracepid=\"news_detail_above_text_link\" style=\"color:#A00;font-weight:bold;\" href=\"https://my.oschina.net/u/3985214/blog/3018099?tdsourcetag=s_pcqq_aiomsg\" target=\"_blank\">开发十年,就只剩下这套架构体系了! >>></a> <img src=\"https://www.oschina.net/img/hot3.png\" align=\"\" style=\"max-height: 32px; max-width: 32px;\"></p>\r\n </div>\r\n <p>web-flash使用的Spring Boot从1.5.1升级到2.1.1</p><p>下面为升级过程</p><ul class=\" list-paddingleft-2\"><li><p>版本升级</p><pre><spring.boot.version>2.1.1.RELEASE</spring.boot.version>\r\n<springframework.version>5.1.3.RELEASE<springframework.version></pre></li><li><p>配置增加</p><pre>spring.main.allow-bean-definition-overriding=true\r\nspring.jpa.hibernate.use-new-id-generator-mappings=false</pre></li></ul><ul class=\" list-paddingleft-2\"><li><p>审计功能调整,调整后代码:</p><pre>@Configuration\r\npublic class UserIDAuditorConfig implements AuditorAware<Long> {\r\n @Override\r\n public Optional<Long> getCurrentAuditor() {\r\n ShiroUser shiroUser = ShiroKit.getUser();\r\n if(shiroUser!=null){\r\n return Optional.of(shiroUser.getId());\r\n }\r\n return null;\r\n }\r\n}</pre></li><li><p>repository调整</p></li><ul class=\" list-paddingleft-2\" style=\"list-style-type: square;\"><li><p>之前的 delete(Long id)方法没有了,替换为:deleteById(Long id)</p></li><li><p>之前的 T findOne(Long id)方法没有了,替换为: </p><pre>Optional<T> optional = ***Repository.findById(id);\r\n if (optional.isPresent()) {\r\n return optional.get();\r\n }\r\n return null;</pre></li></ul><li><p>随着这次Spring Boot的升级也顺便做了一些其他内容的调整和重构</p></li><ul class=\" list-paddingleft-2\" style=\"list-style-type: square;\"><li><p>springframework也从4.3.5.RELEASE升级到5.1.3.RELEASE</p></li><li><p>为减小复杂度service去掉接口和实现类的结构,基础功能的service直接使用实现类;当然具体业务中如果有需求你也可以这没用</p></li><li><p>去掉了一些暂时用不到的maven依赖</p></li><li><p>完善了基础功能的审计功能(之前有介绍审计功能的实现翻番,后续会专门发一篇文档来说明审计功能在系统总的具体用法,当然聪明的你看代码就知道了)</p></li></ul></ul>\r\n </div>', '1', '1', 'web-flash 升级 Spring Boot 到 2.1.1 版本');INSERT INTO `t_cms_article` VALUES ('4', '1', '2019-03-09 16:24:58', '1', '2019-04-28 00:34:21', 'enilu.cn', 'H5通用官网系统', '2', '17', 'H5通用官网系统');INSERT INTO `t_cms_article` VALUES ('5', '1', '2019-03-09 16:24:58', '1', '2019-04-28 00:34:36', 'enilu.cn', 'H5通用论坛系统', '2', '18', 'H5通用论坛系统');INSERT INTO `t_cms_article` VALUES ('6', '1', '2019-03-09 16:24:58', '1', '2019-04-28 00:38:33', 'enilu.cn', '官网建设方案', '3', '19', '官网建设方案');INSERT INTO `t_cms_article` VALUES ('7', '1', '2019-03-09 16:24:58', '1', '2019-04-28 00:39:48', 'enilu.cn', '论坛建设方案', '3', '22', '论坛建设方案');INSERT INTO `t_cms_article` VALUES ('8', '1', '2019-03-09 16:24:58', '1', '2019-04-28 17:39:52', 'enilu.cn', '案例1', '4', '3', '案例1');INSERT INTO `t_cms_article` VALUES ('9', '1', '2019-03-09 16:24:58', '1', '2019-04-28 00:39:11', 'enilu.cn', '案例2', '4', '20', '案例2');INSERT INTO `t_cms_article` VALUES ('14', '1', '2019-03-09 16:24:58', '1', '2019-04-28 00:39:25', 'test5', '<p>aaaaa<img class=\"wscnph\" src=\"http://127.0.0.1:8082/file/download?idFile=12\" /></p>', '4', '21', 'IDEA的代码生成插件发布啦');INSERT INTO `t_cms_article` VALUES ('15', '1', '2019-04-28 17:39:52', '1', '2019-05-05 15:36:57', 'enilu', '<p><img class=\"wscnph\" src=\"http://127.0.0.1:8082/file/download?idFile=24\" /></p>', '1', '25', '程序员头冷');-- ------------------------------ Table structure for `t_cms_banner`-- ----------------------------DROP TABLE IF EXISTS `t_cms_banner`;CREATE TABLE `t_cms_banner` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`id_file` bigint(20) DEFAULT NULL COMMENT 'banner图id',`title` varchar(64) DEFAULT NULL COMMENT '标题',`type` varchar(32) DEFAULT NULL COMMENT '类型',`url` varchar(128) DEFAULT NULL COMMENT '点击banner跳转到url',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='Banner';-- ------------------------------ Records of t_cms_banner-- ----------------------------INSERT INTO `t_cms_banner` VALUES ('1', '1', '2019-03-09 16:29:03', null, null, '1', '不打开链接', 'index', 'javascript:');INSERT INTO `t_cms_banner` VALUES ('2', '1', '2019-03-09 16:29:03', null, null, '2', '打打开站内链接', 'index', '/contact');INSERT INTO `t_cms_banner` VALUES ('3', '1', '2019-03-09 16:29:03', null, null, '6', '打开外部链接', 'index', 'http://www.baidu.com');INSERT INTO `t_cms_banner` VALUES ('4', '1', '2019-03-09 16:29:03', null, null, '1', '不打开链接', 'product', 'javascript:');INSERT INTO `t_cms_banner` VALUES ('5', '1', '2019-03-09 16:29:03', null, null, '2', '打打开站内链接', 'product', '/contact');INSERT INTO `t_cms_banner` VALUES ('6', '1', '2019-03-09 16:29:03', null, null, '6', '打开外部链接', 'product', 'http://www.baidu.com');INSERT INTO `t_cms_banner` VALUES ('7', '1', '2019-03-09 16:29:03', null, null, '1', '不打开链接', 'solution', 'javascript:');INSERT INTO `t_cms_banner` VALUES ('8', '1', '2019-03-09 16:29:03', null, null, '2', '打打开站内链接', 'solution', '/contact');INSERT INTO `t_cms_banner` VALUES ('9', '1', '2019-03-09 16:29:03', null, null, '6', '打开外部链接', 'solution', 'http://www.baidu.com');INSERT INTO `t_cms_banner` VALUES ('10', '1', '2019-03-09 16:29:03', null, null, '1', '不打开链接', 'case', 'javascript:');INSERT INTO `t_cms_banner` VALUES ('11', '1', '2019-03-09 16:29:03', null, null, '2', '打打开站内链接', 'case', '/contact');INSERT INTO `t_cms_banner` VALUES ('12', '1', '2019-03-09 16:29:03', null, null, '6', '打开外部链接', 'case', 'http://www.baidu.com');INSERT INTO `t_cms_banner` VALUES ('14', '1', '2019-03-09 16:29:03', null, null, '1', '不打开链接', 'news', 'javascript:');INSERT INTO `t_cms_banner` VALUES ('15', '1', '2019-03-09 16:29:03', null, null, '2', '打打开站内链接', 'news', '/contact');INSERT INTO `t_cms_banner` VALUES ('16', '1', '2019-03-09 16:29:03', null, null, '6', '打开外部链接', 'news', 'http://www.baidu.com');-- ------------------------------ Table structure for `t_cms_channel`-- ----------------------------DROP TABLE IF EXISTS `t_cms_channel`;CREATE TABLE `t_cms_channel` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`code` varchar(64) DEFAULT NULL COMMENT '编码',`name` varchar(64) DEFAULT NULL COMMENT '名称',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='文章栏目';-- ------------------------------ Records of t_cms_channel-- ----------------------------INSERT INTO `t_cms_channel` VALUES ('1', null, null, '1', '2019-03-13 22:52:46', 'news', '动态资讯');INSERT INTO `t_cms_channel` VALUES ('2', null, null, '1', '2019-03-13 22:53:11', 'product', '产品服务');INSERT INTO `t_cms_channel` VALUES ('3', null, null, '1', '2019-03-13 22:53:37', 'solution', '解决方案');INSERT INTO `t_cms_channel` VALUES ('4', null, null, '1', '2019-03-13 22:53:41', 'case', '精选案例');-- ------------------------------ Table structure for `t_cms_contacts`-- ----------------------------DROP TABLE IF EXISTS `t_cms_contacts`;CREATE TABLE `t_cms_contacts` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`email` varchar(32) DEFAULT NULL COMMENT '电子邮箱',`mobile` varchar(64) DEFAULT NULL COMMENT '联系电话',`remark` varchar(128) DEFAULT NULL COMMENT '备注',`user_name` varchar(64) DEFAULT NULL COMMENT '邀约人名称',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='邀约信息';-- ------------------------------ Records of t_cms_contacts-- ----------------------------INSERT INTO `t_cms_contacts` VALUES ('1', null, '2019-07-31 17:44:27', null, '2019-07-31 17:44:27', 'test@qq.com', '15011111111', '测试联系,哈哈哈', '张三');-- ------------------------------ Table structure for `t_message`-- ----------------------------DROP TABLE IF EXISTS `t_message`;CREATE TABLE `t_message` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`content` text COMMENT '消息内容',`receiver` varchar(64) DEFAULT NULL COMMENT '接收者',`state` varchar(32) DEFAULT NULL COMMENT '消息类型,0:初始,1:成功,2:失败',`tpl_code` varchar(32) DEFAULT NULL COMMENT '模板编码',`type` varchar(32) DEFAULT NULL COMMENT '消息类型,0:短信,1:邮件',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='历史消息';-- ------------------------------ Records of t_message-- ----------------------------INSERT INTO `t_message` VALUES ('1', null, '2019-06-10 21:20:16', null, null, '【腾讯云】校验码1032,请于5分钟内完成验证,如非本人操作请忽略本短信。', '15011112222', '2', 'REGISTER_CODE', '0');-- ------------------------------ Table structure for `t_message_sender`-- ----------------------------DROP TABLE IF EXISTS `t_message_sender`;CREATE TABLE `t_message_sender` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`class_name` varchar(64) DEFAULT NULL COMMENT '发送类',`name` varchar(64) DEFAULT NULL COMMENT '名称',`tpl_code` varchar(64) DEFAULT NULL COMMENT '短信运营商模板编号',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='消息发送者';-- ------------------------------ Records of t_message_sender-- ----------------------------INSERT INTO `t_message_sender` VALUES ('1', null, null, null, null, 'tencentSmsSender', ' 腾讯短信服务', null);INSERT INTO `t_message_sender` VALUES ('2', null, null, null, null, 'defaultEmailSender', '默认邮件发送器', null);-- ------------------------------ Table structure for `t_message_template`-- ----------------------------DROP TABLE IF EXISTS `t_message_template`;CREATE TABLE `t_message_template` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`code` varchar(32) DEFAULT NULL COMMENT '编号',`cond` varchar(32) DEFAULT NULL COMMENT '发送条件',`content` text COMMENT '内容',`id_message_sender` bigint(20) NOT NULL COMMENT '发送者id',`title` varchar(64) DEFAULT NULL COMMENT '标题',`type` varchar(32) DEFAULT NULL COMMENT '消息类型,0:短信,1:邮件',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='消息模板';-- ------------------------------ Records of t_message_template-- ----------------------------INSERT INTO `t_message_template` VALUES ('1', null, null, null, null, 'REGISTER_CODE', '注册页面,点击获取验证码', '【腾讯云】校验码{1},请于5分钟内完成验证,如非本人操作请忽略本短信。', '1', '注册验证码', '0');INSERT INTO `t_message_template` VALUES ('2', null, null, null, null, 'EMAIL_TEST', '测试发送', '你好:{1},欢迎使用{2}', '2', '测试邮件', '1');INSERT INTO `t_message_template` VALUES ('3', null, null, null, null, 'EMAIL_HTML_TEMPLATE_TEST', '测试发送模板邮件', '你好<strong>${userName}</strong>欢迎使用<font color=\"red\">${appName}</font>,这是html模板邮件', '2', '测试发送模板邮件', '1');-- ------------------------------ Table structure for `t_sys_cfg`-- ----------------------------DROP TABLE IF EXISTS `t_sys_cfg`;CREATE TABLE `t_sys_cfg` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`cfg_desc` text COMMENT '备注',`cfg_name` varchar(256) DEFAULT NULL COMMENT '参数名',`cfg_value` varchar(512) DEFAULT NULL COMMENT '参数值',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='系统参数';-- ------------------------------ Records of t_sys_cfg-- ----------------------------INSERT INTO `t_sys_cfg` VALUES ('1', null, null, '-1', '2020-06-21 21:30:00', 'update by 2020年06月21日 21:30:00', 'system.app.name', 'web-flash');INSERT INTO `t_sys_cfg` VALUES ('2', null, null, '1', '2019-04-15 21:36:17', '系统默认上传文件路径', 'system.file.upload.path', '/data/web-flash/runtime/upload');INSERT INTO `t_sys_cfg` VALUES ('3', null, null, '1', '2019-04-15 21:36:17', '腾讯sms接口appid', 'api.tencent.sms.appid', '1400219425');INSERT INTO `t_sys_cfg` VALUES ('4', null, null, '1', '2019-04-15 21:36:17', '腾讯sms接口appkey', 'api.tencent.sms.appkey', '5f71ed5325f3b292946530a1773e997a');INSERT INTO `t_sys_cfg` VALUES ('5', null, null, '1', '2019-04-15 21:36:17', '腾讯sms接口签名参数', 'api.tencent.sms.sign', '需要去申请咯');-- ------------------------------ Table structure for `t_sys_dept`-- ----------------------------DROP TABLE IF EXISTS `t_sys_dept`;CREATE TABLE `t_sys_dept` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`fullname` varchar(255) DEFAULT NULL,`num` int(11) DEFAULT NULL,`pid` bigint(20) DEFAULT NULL,`pids` varchar(255) DEFAULT NULL,`simplename` varchar(255) DEFAULT NULL,`tips` varchar(255) DEFAULT NULL,`version` int(11) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='部门';-- ------------------------------ Records of t_sys_dept-- ----------------------------INSERT INTO `t_sys_dept` VALUES ('1', null, null, null, null, '总公司', '1', '0', '[0],', '总公司', '', null);INSERT INTO `t_sys_dept` VALUES ('2', null, null, null, null, '开发部', '2', '1', '[0],[1],', '开发部', '', null);INSERT INTO `t_sys_dept` VALUES ('3', null, null, null, null, '运营部', '3', '1', '[0],[1],', '运营部', '', null);INSERT INTO `t_sys_dept` VALUES ('4', null, null, null, null, '战略部', '4', '1', '[0],[1],', '战略部', '', null);-- ------------------------------ Table structure for `t_sys_dict`-- ----------------------------DROP TABLE IF EXISTS `t_sys_dict`;CREATE TABLE `t_sys_dict` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`name` varchar(255) DEFAULT NULL,`num` varchar(255) DEFAULT NULL,`pid` bigint(20) DEFAULT NULL,`tips` varchar(255) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COMMENT='字典';-- ------------------------------ Records of t_sys_dict-- ----------------------------INSERT INTO `t_sys_dict` VALUES ('16', null, null, null, null, '状态', '0', '0', null);INSERT INTO `t_sys_dict` VALUES ('17', null, null, null, null, '启用', '1', '16', null);INSERT INTO `t_sys_dict` VALUES ('18', null, null, null, null, '禁用', '2', '16', null);INSERT INTO `t_sys_dict` VALUES ('29', null, null, null, null, '性别', '0', '0', null);INSERT INTO `t_sys_dict` VALUES ('30', null, null, null, null, '男', '1', '29', null);INSERT INTO `t_sys_dict` VALUES ('31', null, null, null, null, '女', '2', '29', null);INSERT INTO `t_sys_dict` VALUES ('35', null, null, null, null, '账号状态', '0', '0', null);INSERT INTO `t_sys_dict` VALUES ('36', null, null, null, null, '启用', '1', '35', null);INSERT INTO `t_sys_dict` VALUES ('37', null, null, null, null, '冻结', '2', '35', null);INSERT INTO `t_sys_dict` VALUES ('38', null, null, null, null, '已删除', '3', '35', null);INSERT INTO `t_sys_dict` VALUES ('53', null, null, null, null, '证件类型', '0', '0', null);INSERT INTO `t_sys_dict` VALUES ('54', null, null, null, null, '身份证', '1', '53', null);INSERT INTO `t_sys_dict` VALUES ('55', null, null, null, null, '护照', '2', '53', null);INSERT INTO `t_sys_dict` VALUES ('68', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '是否', '0', '0', null);INSERT INTO `t_sys_dict` VALUES ('69', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '是', '1', '68', null);INSERT INTO `t_sys_dict` VALUES ('70', '1', '2019-01-13 14:18:21', '1', '2019-01-13 14:18:21', '否', '0', '68', null);-- ------------------------------ Table structure for `t_sys_file_info`-- ----------------------------DROP TABLE IF EXISTS `t_sys_file_info`;CREATE TABLE `t_sys_file_info` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`original_file_name` varchar(255) DEFAULT NULL,`real_file_name` varchar(255) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='文件';-- ------------------------------ Records of t_sys_file_info-- ----------------------------INSERT INTO `t_sys_file_info` VALUES ('1', '1', '2019-03-18 10:34:34', '1', '2019-03-18 10:34:34', 'banner1.png', '7e9ebc08-b194-4f85-8997-d97ccb0d2c2d.png');INSERT INTO `t_sys_file_info` VALUES ('2', '1', '2019-03-18 10:54:04', '1', '2019-03-18 10:54:04', 'banner2.png', '756b9ca8-562f-4bf5-a577-190dcdd25c29.png');INSERT INTO `t_sys_file_info` VALUES ('3', '1', '2019-03-18 20:09:59', '1', '2019-03-18 20:09:59', 'offcial_site.png', 'b0304e2b-0ee3-4966-ac9f-a075b13d4af6.png');INSERT INTO `t_sys_file_info` VALUES ('4', '1', '2019-03-18 20:10:18', '1', '2019-03-18 20:10:18', 'bbs.png', '67486aa5-500c-4993-87ad-7e1fbc90ac1a.png');INSERT INTO `t_sys_file_info` VALUES ('5', '1', '2019-03-18 20:20:14', '1', '2019-03-18 20:20:14', 'product.png', '1f2b05e0-403a-41e0-94a2-465f0c986b78.png');INSERT INTO `t_sys_file_info` VALUES ('6', '1', '2019-03-18 20:22:09', '1', '2019-03-18 20:22:09', 'profile.jpg', '40ead888-14d1-4e9f-abb3-5bfb056a966a.jpg');INSERT INTO `t_sys_file_info` VALUES ('7', '1', '2019-03-20 09:05:54', '1', '2019-03-20 09:05:54', '2303938_1453211.png', '87b037da-b517-4007-a66e-ba7cc8cfd6ea.png');INSERT INTO `t_sys_file_info` VALUES ('8', null, null, null, null, 'login.png', '26835cc4-059e-4900-aff5-a41f2ea6a61d.png');INSERT INTO `t_sys_file_info` VALUES ('9', null, null, null, null, 'login.png', '7ec7553b-7c9e-44d9-b9c2-3d89b11cf842.png');INSERT INTO `t_sys_file_info` VALUES ('10', null, null, null, null, 'login.png', '357c4aad-19fd-4600-9fb6-e62aafa3df25.png');INSERT INTO `t_sys_file_info` VALUES ('11', null, null, null, null, 'index.png', '55dd582b-033e-440d-8e8d-c8d39d01f1bb.png');INSERT INTO `t_sys_file_info` VALUES ('12', null, null, null, null, 'login.png', '70507c07-e8bc-492f-9f0a-00bf1c23e329.png');INSERT INTO `t_sys_file_info` VALUES ('13', null, null, null, null, 'index.png', 'cd539518-d15a-4cda-a19f-251169f5d1a4.png');INSERT INTO `t_sys_file_info` VALUES ('14', null, null, null, null, 'login.png', '194c8a38-be94-483c-8875-3c62a857ead7.png');INSERT INTO `t_sys_file_info` VALUES ('15', null, null, null, null, 'index.png', '6a6cb215-d0a7-4574-a45e-5fa04dcfdf90.png');INSERT INTO `t_sys_file_info` VALUES ('16', '1', '2019-03-21 19:37:50', null, null, '测试文档.doc', 'd9d77815-496f-475b-a0f8-1d6dcb86e6ab.doc');INSERT INTO `t_sys_file_info` VALUES ('17', '1', '2019-04-28 00:34:09', null, null, '首页.png', 'd5aba978-f8af-45c5-b079-673decfbdf26.png');INSERT INTO `t_sys_file_info` VALUES ('18', '1', '2019-04-28 00:34:34', null, null, '资讯.png', '7e07520d-5b73-4712-800b-16f88d133db2.png');INSERT INTO `t_sys_file_info` VALUES ('19', '1', '2019-04-28 00:38:32', null, null, '产品服务.png', '99214651-8cb8-4488-b572-12c6aa21f30a.png');INSERT INTO `t_sys_file_info` VALUES ('20', '1', '2019-04-28 00:39:09', null, null, '67486aa5-500c-4993-87ad-7e1fbc90ac1a.png', '31fdc83e-7688-41f5-b153-b6816d5dfb06.png');INSERT INTO `t_sys_file_info` VALUES ('21', '1', '2019-04-28 00:39:22', null, null, '67486aa5-500c-4993-87ad-7e1fbc90ac1a.png', 'ffaf0563-3115-477b-b31d-47a4e80a75eb.png');INSERT INTO `t_sys_file_info` VALUES ('22', '1', '2019-04-28 00:39:47', null, null, '7e07520d-5b73-4712-800b-16f88d133db2.png', '8928e5d4-933a-4953-9507-f60b78e3ccee.png');INSERT INTO `t_sys_file_info` VALUES ('23', null, '2019-04-28 17:34:31', null, null, '756b9ca8-562f-4bf5-a577-190dcdd25c29.png', '7d64ba36-adc4-4982-9ec2-8c68db68861b.png');INSERT INTO `t_sys_file_info` VALUES ('24', null, '2019-04-28 17:39:43', null, null, 'timg.jpg', '6483eb26-775c-4fe2-81bf-8dd49ac9b6b1.jpg');INSERT INTO `t_sys_file_info` VALUES ('25', '1', '2019-05-05 15:36:54', null, null, 'timg.jpg', '7fe918a2-c59a-4d17-ad77-f65dd4e163bf.jpg');-- ------------------------------ Table structure for `t_sys_login_log`-- ----------------------------DROP TABLE IF EXISTS `t_sys_login_log`;CREATE TABLE `t_sys_login_log` (`id` int(11) NOT NULL AUTO_INCREMENT,`create_time` datetime DEFAULT NULL COMMENT '创建时间',`ip` varchar(255) DEFAULT NULL,`logname` varchar(255) DEFAULT NULL,`message` varchar(255) DEFAULT NULL,`succeed` varchar(255) DEFAULT NULL,`userid` int(11) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8 COMMENT='登录日志';-- ------------------------------ Records of t_sys_login_log-- ----------------------------INSERT INTO `t_sys_login_log` VALUES ('71', '2019-05-10 13:17:43', '127.0.0.1', '登录日志', null, '成功', '1');INSERT INTO `t_sys_login_log` VALUES ('72', '2019-05-12 13:36:56', '127.0.0.1', '登录日志', null, '成功', '1');INSERT INTO `t_sys_login_log` VALUES ('73', '2020-06-21 17:55:20', '127.0.0.1', '登录日志', null, '成功', '1');INSERT INTO `t_sys_login_log` VALUES ('74', '2020-06-21 19:54:12', '127.0.0.1', '登录日志', null, '成功', '1');INSERT INTO `t_sys_login_log` VALUES ('75', '2020-06-21 21:15:24', '127.0.0.1', '登录日志', null, '成功', '1');INSERT INTO `t_sys_login_log` VALUES ('76', '2020-06-21 21:18:29', '127.0.0.1', '登录日志', null, '成功', '1');INSERT INTO `t_sys_login_log` VALUES ('77', '2020-06-21 21:28:47', '127.0.0.1', '登录日志', null, '成功', '1');-- ------------------------------ Table structure for `t_sys_menu`-- ----------------------------DROP TABLE IF EXISTS `t_sys_menu`;CREATE TABLE `t_sys_menu` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`code` varchar(32) NOT NULL COMMENT '编号',`component` varchar(64) DEFAULT NULL COMMENT '页面组件',`hidden` tinyint(4) DEFAULT NULL COMMENT '是否隐藏',`icon` varchar(32) DEFAULT NULL COMMENT '图标',`ismenu` int(11) NOT NULL COMMENT '是否是菜单1:菜单,0:按钮',`isopen` int(11) DEFAULT NULL COMMENT '是否默认打开1:是,0:否',`levels` int(11) NOT NULL COMMENT '级别',`name` varchar(64) NOT NULL COMMENT '名称',`num` int(11) NOT NULL COMMENT '顺序',`pcode` varchar(64) NOT NULL COMMENT '父菜单编号',`pcodes` varchar(128) DEFAULT NULL COMMENT '递归父级菜单编号',`status` int(11) NOT NULL COMMENT '状态1:启用,0:禁用',`tips` varchar(32) DEFAULT NULL COMMENT '鼠标悬停提示信息',`url` varchar(32) DEFAULT NULL COMMENT '链接标识',PRIMARY KEY (`id`),UNIQUE KEY `UK_s37unj3gh67ujhk83lqva8i1t` (`code`)) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COMMENT='菜单';-- ------------------------------ Records of t_sys_menu-- ----------------------------INSERT INTO `t_sys_menu` VALUES ('1', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'system', 'layout', '0', 'system', '1', '1', '1', '系统管理', '1', '0', '[0],', '1', null, '/system');INSERT INTO `t_sys_menu` VALUES ('2', '1', '2019-07-31 22:04:30', '1', '2019-03-11 22:25:38', 'cms', 'layout', '0', 'documentation', '1', null, '1', 'CMS管理', '3', '0', '[0],', '1', null, '/cms');INSERT INTO `t_sys_menu` VALUES ('3', '1', '2019-07-31 22:04:30', '1', '2019-06-02 10:09:09', 'operationMgr', 'layout', '0', 'operation', '1', null, '1', '运维管理', '2', '0', '[0],', '1', null, '/optionMgr');INSERT INTO `t_sys_menu` VALUES ('4', '1', '2019-07-31 22:04:30', '1', '2019-04-16 18:59:15', 'mgr', 'views/system/user/index', '0', 'user', '1', null, '2', '用户管理', '1', 'system', '[0],[system],', '1', null, '/mgr');INSERT INTO `t_sys_menu` VALUES ('5', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'mgrAdd', null, '0', null, '0', null, '3', '添加用户', '1', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/add');INSERT INTO `t_sys_menu` VALUES ('6', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'mgrEdit', null, '0', null, '0', null, '3', '修改用户', '2', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/edit');INSERT INTO `t_sys_menu` VALUES ('7', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'mgrDelete', null, '0', null, '0', '0', '3', '删除用户', '3', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/delete');INSERT INTO `t_sys_menu` VALUES ('8', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'mgrReset', null, '0', null, '0', '0', '3', '重置密码', '4', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/reset');INSERT INTO `t_sys_menu` VALUES ('9', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'setRole', null, '0', null, '0', '0', '3', '分配角色', '5', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/setRole');INSERT INTO `t_sys_menu` VALUES ('10', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'mgrUnfreeze', null, '0', null, '0', '0', '3', '解除冻结用户', '6', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/unfreeze');INSERT INTO `t_sys_menu` VALUES ('11', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'mgrSetRole', null, '0', null, '0', '0', '3', '分配角色', '7', 'mgr', '[0],[system],[mgr],', '1', null, '/mgr/setRole');INSERT INTO `t_sys_menu` VALUES ('12', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'role', 'views/system/role/index', '0', 'peoples', '1', '0', '2', '角色管理', '2', 'system', '[0],[system],', '1', null, '/role');INSERT INTO `t_sys_menu` VALUES ('13', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'roleAdd', null, '0', null, '0', '0', '3', '添加角色', '1', 'role', '[0],[system],[role],', '1', null, '/role/add');INSERT INTO `t_sys_menu` VALUES ('14', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'roleEdit', null, '0', null, '0', '0', '3', '修改角色', '2', 'role', '[0],[system],[role],', '1', null, '/role/edit');INSERT INTO `t_sys_menu` VALUES ('15', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'roleDelete', null, '0', null, '0', '0', '3', '删除角色', '3', 'role', '[0],[system],[role],', '1', null, '/role/remove');INSERT INTO `t_sys_menu` VALUES ('16', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'roleSetAuthority', null, '0', null, '0', '0', '3', '配置权限', '4', 'role', '[0],[system],[role],', '1', null, '/role/setAuthority');INSERT INTO `t_sys_menu` VALUES ('17', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'menu', 'views/system/menu/index', '0', 'menu', '1', '0', '2', '菜单管理', '4', 'system', '[0],[system],', '1', null, '/menu');INSERT INTO `t_sys_menu` VALUES ('18', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'menuAdd', null, '0', null, '0', '0', '3', '添加菜单', '1', 'menu', '[0],[system],[menu],', '1', null, '/menu/add');INSERT INTO `t_sys_menu` VALUES ('19', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'menuEdit', null, '0', null, '0', '0', '3', '修改菜单', '2', 'menu', '[0],[system],[menu],', '1', null, '/menu/edit');INSERT INTO `t_sys_menu` VALUES ('20', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'menuDelete', null, '0', null, '0', '0', '3', '删除菜单', '3', 'menu', '[0],[system],[menu],', '1', null, '/menu/remove');INSERT INTO `t_sys_menu` VALUES ('21', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'dept', 'views/system/dept/index', '0', 'dept', '1', null, '2', '部门管理', '3', 'system', '[0],[system],', '1', null, '/dept');INSERT INTO `t_sys_menu` VALUES ('22', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'dict', 'views/system/dict/index', '0', 'dict', '1', null, '2', '字典管理', '4', 'system', '[0],[system],', '1', null, '/dict');INSERT INTO `t_sys_menu` VALUES ('23', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'deptEdit', null, '0', null, '0', null, '3', '修改部门', '1', 'dept', '[0],[system],[dept],', '1', null, '/dept/update');INSERT INTO `t_sys_menu` VALUES ('24', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'deptDelete', null, '0', null, '0', null, '3', '删除部门', '1', 'dept', '[0],[system],[dept],', '1', null, '/dept/delete');INSERT INTO `t_sys_menu` VALUES ('25', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'dictAdd', null, '0', null, '0', null, '3', '添加字典', '1', 'dict', '[0],[system],[dict],', '1', null, '/dict/add');INSERT INTO `t_sys_menu` VALUES ('26', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'dictEdit', null, '0', null, '0', null, '3', '修改字典', '1', 'dict', '[0],[system],[dict],', '1', null, '/dict/update');INSERT INTO `t_sys_menu` VALUES ('27', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'dictDelete', null, '0', null, '0', null, '3', '删除字典', '1', 'dict', '[0],[system],[dict],', '1', null, '/dict/delete');INSERT INTO `t_sys_menu` VALUES ('28', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'deptList', null, '0', null, '0', null, '3', '部门列表', '5', 'dept', '[0],[system],[dept],', '1', null, '/dept/list');INSERT INTO `t_sys_menu` VALUES ('29', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'deptDetail', null, '0', null, '0', null, '3', '部门详情', '6', 'dept', '[0],[system],[dept],', '1', null, '/dept/detail');INSERT INTO `t_sys_menu` VALUES ('30', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'dictList', null, '0', null, '0', null, '3', '字典列表', '5', 'dict', '[0],[system],[dict],', '1', null, '/dict/list');INSERT INTO `t_sys_menu` VALUES ('31', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'dictDetail', null, '0', null, '0', null, '3', '字典详情', '6', 'dict', '[0],[system],[dict],', '1', null, '/dict/detail');INSERT INTO `t_sys_menu` VALUES ('32', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'deptAdd', null, '0', null, '0', null, '3', '添加部门', '1', 'dept', '[0],[system],[dept],', '1', null, '/dept/add');INSERT INTO `t_sys_menu` VALUES ('33', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'cfg', 'views/system/cfg/index', '0', 'cfg', '1', null, '2', '参数管理', '10', 'system', '[0],[system],', '1', null, '/cfg');INSERT INTO `t_sys_menu` VALUES ('34', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'cfgAdd', null, '0', null, '0', null, '3', '添加参数', '1', 'cfg', '[0],[system],[cfg],', '1', null, '/cfg/add');INSERT INTO `t_sys_menu` VALUES ('35', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'cfgEdit', null, '0', null, '0', null, '3', '修改参数', '2', 'cfg', '[0],[system],[cfg],', '1', null, '/cfg/update');INSERT INTO `t_sys_menu` VALUES ('36', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'cfgDelete', null, '0', null, '0', null, '3', '删除参数', '3', 'cfg', '[0],[system],[cfg],', '1', null, '/cfg/delete');INSERT INTO `t_sys_menu` VALUES ('37', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'task', 'views/system/task/index', '0', 'task', '1', null, '2', '任务管理', '11', 'system', '[0],[system],', '1', null, '/task');INSERT INTO `t_sys_menu` VALUES ('38', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'taskAdd', null, '0', null, '0', null, '3', '添加任务', '1', 'task', '[0],[system],[task],', '1', null, '/task/add');INSERT INTO `t_sys_menu` VALUES ('39', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'taskEdit', null, '0', null, '0', null, '3', '修改任务', '2', 'task', '[0],[system],[task],', '1', null, '/task/update');INSERT INTO `t_sys_menu` VALUES ('40', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'taskDelete', null, '0', null, '0', null, '3', '删除任务', '3', 'task', '[0],[system],[task],', '1', null, '/task/delete');INSERT INTO `t_sys_menu` VALUES ('41', '1', '2019-03-11 22:29:54', '1', '2019-03-11 22:29:54', 'channel', 'views/cms/channel/index', '0', 'channel', '1', null, '2', '栏目管理', '1', 'cms', '[0],[cms],', '1', null, '/channel');INSERT INTO `t_sys_menu` VALUES ('42', '1', '2019-03-11 22:30:17', '1', '2019-03-11 22:30:17', 'article', 'views/cms/article/index', '0', 'documentation', '1', null, '2', '文章管理', '2', 'cms', '[0],[cms],', '1', null, '/article');INSERT INTO `t_sys_menu` VALUES ('43', '1', '2019-03-11 22:30:52', '1', '2019-03-11 22:30:52', 'banner', 'views/cms/banner/index', '0', 'banner', '1', null, '2', 'banner管理', '3', 'cms', '[0],[cms],', '1', null, '/banner');INSERT INTO `t_sys_menu` VALUES ('44', '1', '2019-03-18 19:45:37', '1', '2019-03-18 19:45:37', 'contacts', 'views/cms/contacts/index', '0', 'contacts', '1', null, '2', '邀约管理', '4', 'cms', '[0],[cms],', '1', null, '/contacts');INSERT INTO `t_sys_menu` VALUES ('45', '1', '2019-03-19 10:25:05', '1', '2019-03-19 10:25:05', 'file', 'views/cms/file/index', '0', 'file', '1', null, '2', '文件管理', '5', 'cms', '[0],[cms],', '1', null, '/fileMgr');INSERT INTO `t_sys_menu` VALUES ('46', '1', '2019-03-11 22:30:17', '1', '2019-03-11 22:30:17', 'editArticle', 'views/cms/article/edit.vue', '0', 'articleEdit', '1', null, '2', '新建文章', '1', 'cms', '[0],[cms],', '1', null, '/cms/articleEdit');INSERT INTO `t_sys_menu` VALUES ('47', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'taskLog', 'views/system/task/taskLog', '1', 'task', '1', null, '2', '任务日志', '4', 'system', '[0],[system],', '1', null, '/taskLog');INSERT INTO `t_sys_menu` VALUES ('48', '1', '2019-07-31 22:04:30', '1', '2019-06-02 10:25:31', 'log', 'views/operation/log/index', '0', 'log', '1', null, '2', '业务日志', '6', 'operationMgr', '[0],[operationMgr],', '1', null, '/log');INSERT INTO `t_sys_menu` VALUES ('49', '1', '2019-07-31 22:04:30', '1', '2019-06-02 10:25:36', 'loginLog', 'views/operation/loginLog/index', '0', 'logininfor', '1', null, '2', '登录日志', '6', 'operationMgr', '[0],[operationMgr],', '1', null, '/loginLog');INSERT INTO `t_sys_menu` VALUES ('50', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'logClear', null, '0', null, '0', null, '3', '清空日志', '3', 'log', '[0],[system],[log],', '1', null, '/log/delLog');INSERT INTO `t_sys_menu` VALUES ('51', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'logDetail', null, '0', null, '0', null, '3', '日志详情', '3', 'log', '[0],[system],[log],', '1', null, '/log/detail');INSERT INTO `t_sys_menu` VALUES ('52', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'loginLogClear', null, '0', null, '0', null, '3', '清空登录日志', '1', 'loginLog', '[0],[system],[loginLog],', '1', null, '/loginLog/delLoginLog');INSERT INTO `t_sys_menu` VALUES ('53', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'loginLogList', null, '0', null, '0', null, '3', '登录日志列表', '2', 'loginLog', '[0],[system],[loginLog],', '1', null, '/loginLog/list');INSERT INTO `t_sys_menu` VALUES ('54', '1', '2019-06-02 10:10:20', '1', '2019-06-02 10:10:20', 'druid', 'views/operation/druid/index', '0', 'monitor', '1', null, '2', '数据库管理', '1', 'operationMgr', '[0],[operationMgr],', '1', null, '/druid');INSERT INTO `t_sys_menu` VALUES ('55', '1', '2019-06-02 10:10:20', '1', '2019-06-02 10:10:20', 'swagger', 'views/operation/api/index', '0', 'swagger', '1', null, '2', '接口文档', '2', 'operationMgr', '[0],[operationMgr],', '1', null, '/swagger');INSERT INTO `t_sys_menu` VALUES ('56', '1', '2019-06-10 21:26:52', '1', '2019-06-10 21:26:52', 'messageMgr', 'layout', '0', 'message', '1', null, '1', '消息管理', '4', '0', '[0],', '1', null, '/message');INSERT INTO `t_sys_menu` VALUES ('57', '1', '2019-06-10 21:27:34', '1', '2019-06-10 21:27:34', 'msg', 'views/message/message/index', '0', 'message', '1', null, '2', '历史消息', '1', 'messageMgr', '[0],[messageMgr],', '1', null, '/history');INSERT INTO `t_sys_menu` VALUES ('58', '1', '2019-06-10 21:27:56', '1', '2019-06-10 21:27:56', 'msgTpl', 'views/message/template/index', '0', 'template', '1', null, '2', '消息模板', '2', 'messageMgr', '[0],[messageMgr],', '1', null, '/template');INSERT INTO `t_sys_menu` VALUES ('59', '1', '2019-06-10 21:28:21', '1', '2019-06-10 21:28:21', 'msgSender', 'views/message/sender/index', '0', 'sender', '1', null, '2', '消息发送者', '3', 'messageMgr', '[0],[messageMgr],', '1', null, '/sender');INSERT INTO `t_sys_menu` VALUES ('60', '1', '2019-06-10 21:28:21', '1', '2019-06-10 21:28:21', 'msgClear', null, '0', null, '1', null, '2', '清空历史消息', '3', 'messageMgr', '[0],[messageMgr],', '1', null, '/message/clear');INSERT INTO `t_sys_menu` VALUES ('61', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'msgTplEdit', null, '0', null, '0', null, '3', '编辑模板', '1', 'msgTpl', '[0],[messageMgr],[msgTpl]', '1', null, '/template/edit');INSERT INTO `t_sys_menu` VALUES ('62', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'msgTplDelete', null, '0', null, '0', null, '3', '删除模板', '2', 'msgTpl', '[0],[messageMgr],[msgTpl]', '1', null, '/template/remove');INSERT INTO `t_sys_menu` VALUES ('63', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'msgSenderEdit', null, '0', null, '0', null, '3', '编辑发送器', '1', 'msgSender', '[0],[messageMgr],[msgSender]', '1', null, '/sender/edit');INSERT INTO `t_sys_menu` VALUES ('64', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'msgSenderDelete', null, '0', null, '0', null, '3', '删除发送器', '2', 'msgSender', '[0],[messageMgr],[msgSender]', '1', null, '/sender/remove');INSERT INTO `t_sys_menu` VALUES ('65', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'fileUpload', null, '0', null, '0', null, '3', '上传文件', '1', 'file', '[0],[cms],[file],', '1', null, '/file/upload');INSERT INTO `t_sys_menu` VALUES ('66', '1', '2019-07-31 21:51:33', '1', '2019-07-31 21:51:33', 'bannerEdit', null, '0', null, '0', null, '3', '编辑banner', '1', 'banner', '[0],[cms],[banner],', '1', null, '/banner/edit');INSERT INTO `t_sys_menu` VALUES ('67', '1', '2019-07-31 21:51:33', '1', '2019-07-31 21:51:33', 'bannerDelete', null, '0', null, '0', null, '3', '删除banner', '2', 'banner', '[0],[cms],[banner],', '1', null, '/banner/remove');INSERT INTO `t_sys_menu` VALUES ('68', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'channelEdit', null, '0', null, '0', null, '3', '编辑栏目', '1', 'channel', '[0],[cms],[channel],', '1', null, '/channel/edit');INSERT INTO `t_sys_menu` VALUES ('69', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'channelDelete', null, '0', null, '0', null, '3', '删除栏目', '2', 'channel', '[0],[cms],[channel],', '1', null, '/channel/remove');INSERT INTO `t_sys_menu` VALUES ('70', '1', '2019-07-31 22:04:30', '1', '2019-07-31 22:04:30', 'deleteArticle', null, '0', null, '0', null, '3', '删除文章', '2', 'article', '[0],[cms],[article]', '1', null, '/article/remove');-- ------------------------------ Table structure for `t_sys_notice`-- ----------------------------DROP TABLE IF EXISTS `t_sys_notice`;CREATE TABLE `t_sys_notice` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`content` varchar(255) DEFAULT NULL,`title` varchar(255) DEFAULT NULL,`type` int(11) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='通知';-- ------------------------------ Records of t_sys_notice-- ----------------------------INSERT INTO `t_sys_notice` VALUES ('1', '1', '2017-01-11 08:53:20', '1', '2019-01-08 23:30:58', '欢迎使用web-flash后台管理系统', '欢迎光临', '10');-- ------------------------------ Table structure for `t_sys_operation_log`-- ----------------------------DROP TABLE IF EXISTS `t_sys_operation_log`;CREATE TABLE `t_sys_operation_log` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`classname` varchar(255) DEFAULT NULL,`create_time` datetime DEFAULT NULL,`logname` varchar(255) DEFAULT NULL,`logtype` varchar(255) DEFAULT NULL,`message` text COMMENT '详细信息',`method` varchar(255) DEFAULT NULL,`succeed` varchar(255) DEFAULT NULL,`userid` int(11) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='操作日志';-- ------------------------------ Records of t_sys_operation_log-- ----------------------------INSERT INTO `t_sys_operation_log` VALUES ('1', 'cn.enilu.flash.api.controller.cms.ArticleMgrController', '2019-05-10 13:22:49', '添加参数', '业务日志', '参数名称=system.app.name', 'upload', '成功', '1');INSERT INTO `t_sys_operation_log` VALUES ('2', 'cn.enilu.flash.api.controller.cms.ArticleMgrController', '2019-06-10 13:31:09', '修改参数', '业务日志', '参数名称=system.app.name', 'upload', '成功', '1');INSERT INTO `t_sys_operation_log` VALUES ('3', 'cn.enilu.flash.api.controller.cms.ArticleMgrController', '2019-07-10 13:22:49', '编辑文章', '业务日志', '参数名称=system.app.name', 'upload', '成功', '1');INSERT INTO `t_sys_operation_log` VALUES ('4', 'cn.enilu.flash.api.controller.cms.ArticleMgrController', '2019-08-10 13:31:09', '编辑栏目', '业务日志', '参数名称=system.app.name', 'upload', '成功', '1');-- ------------------------------ Table structure for `t_sys_relation`-- ----------------------------DROP TABLE IF EXISTS `t_sys_relation`;CREATE TABLE `t_sys_relation` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`menuid` bigint(20) DEFAULT NULL,`roleid` bigint(20) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8 COMMENT='菜单角色关系';-- ------------------------------ Records of t_sys_relation-- ----------------------------INSERT INTO `t_sys_relation` VALUES ('1', '42', '1');INSERT INTO `t_sys_relation` VALUES ('2', '70', '1');INSERT INTO `t_sys_relation` VALUES ('3', '46', '1');INSERT INTO `t_sys_relation` VALUES ('4', '43', '1');INSERT INTO `t_sys_relation` VALUES ('5', '67', '1');INSERT INTO `t_sys_relation` VALUES ('6', '66', '1');INSERT INTO `t_sys_relation` VALUES ('7', '33', '1');INSERT INTO `t_sys_relation` VALUES ('8', '34', '1');INSERT INTO `t_sys_relation` VALUES ('9', '36', '1');INSERT INTO `t_sys_relation` VALUES ('10', '35', '1');INSERT INTO `t_sys_relation` VALUES ('11', '41', '1');INSERT INTO `t_sys_relation` VALUES ('12', '69', '1');INSERT INTO `t_sys_relation` VALUES ('13', '68', '1');INSERT INTO `t_sys_relation` VALUES ('14', '2', '1');INSERT INTO `t_sys_relation` VALUES ('15', '44', '1');INSERT INTO `t_sys_relation` VALUES ('16', '21', '1');INSERT INTO `t_sys_relation` VALUES ('17', '32', '1');INSERT INTO `t_sys_relation` VALUES ('18', '24', '1');INSERT INTO `t_sys_relation` VALUES ('19', '29', '1');INSERT INTO `t_sys_relation` VALUES ('20', '23', '1');INSERT INTO `t_sys_relation` VALUES ('21', '28', '1');INSERT INTO `t_sys_relation` VALUES ('22', '22', '1');INSERT INTO `t_sys_relation` VALUES ('23', '25', '1');INSERT INTO `t_sys_relation` VALUES ('24', '27', '1');INSERT INTO `t_sys_relation` VALUES ('25', '31', '1');INSERT INTO `t_sys_relation` VALUES ('26', '26', '1');INSERT INTO `t_sys_relation` VALUES ('27', '30', '1');INSERT INTO `t_sys_relation` VALUES ('28', '54', '1');INSERT INTO `t_sys_relation` VALUES ('29', '45', '1');INSERT INTO `t_sys_relation` VALUES ('30', '65', '1');INSERT INTO `t_sys_relation` VALUES ('31', '48', '1');INSERT INTO `t_sys_relation` VALUES ('32', '50', '1');INSERT INTO `t_sys_relation` VALUES ('33', '51', '1');INSERT INTO `t_sys_relation` VALUES ('34', '49', '1');INSERT INTO `t_sys_relation` VALUES ('35', '52', '1');INSERT INTO `t_sys_relation` VALUES ('36', '53', '1');INSERT INTO `t_sys_relation` VALUES ('37', '17', '1');INSERT INTO `t_sys_relation` VALUES ('38', '18', '1');INSERT INTO `t_sys_relation` VALUES ('39', '20', '1');INSERT INTO `t_sys_relation` VALUES ('40', '19', '1');INSERT INTO `t_sys_relation` VALUES ('41', '56', '1');INSERT INTO `t_sys_relation` VALUES ('42', '4', '1');INSERT INTO `t_sys_relation` VALUES ('43', '5', '1');INSERT INTO `t_sys_relation` VALUES ('44', '7', '1');INSERT INTO `t_sys_relation` VALUES ('45', '6', '1');INSERT INTO `t_sys_relation` VALUES ('46', '9', '1');INSERT INTO `t_sys_relation` VALUES ('47', '8', '1');INSERT INTO `t_sys_relation` VALUES ('48', '11', '1');INSERT INTO `t_sys_relation` VALUES ('49', '10', '1');INSERT INTO `t_sys_relation` VALUES ('50', '57', '1');INSERT INTO `t_sys_relation` VALUES ('51', '60', '1');INSERT INTO `t_sys_relation` VALUES ('52', '59', '1');INSERT INTO `t_sys_relation` VALUES ('53', '64', '1');INSERT INTO `t_sys_relation` VALUES ('54', '63', '1');INSERT INTO `t_sys_relation` VALUES ('55', '58', '1');INSERT INTO `t_sys_relation` VALUES ('56', '62', '1');INSERT INTO `t_sys_relation` VALUES ('57', '61', '1');INSERT INTO `t_sys_relation` VALUES ('58', '3', '1');INSERT INTO `t_sys_relation` VALUES ('59', '12', '1');INSERT INTO `t_sys_relation` VALUES ('60', '13', '1');INSERT INTO `t_sys_relation` VALUES ('61', '15', '1');INSERT INTO `t_sys_relation` VALUES ('62', '14', '1');INSERT INTO `t_sys_relation` VALUES ('63', '16', '1');INSERT INTO `t_sys_relation` VALUES ('64', '55', '1');INSERT INTO `t_sys_relation` VALUES ('65', '1', '1');INSERT INTO `t_sys_relation` VALUES ('66', '37', '1');INSERT INTO `t_sys_relation` VALUES ('67', '38', '1');INSERT INTO `t_sys_relation` VALUES ('68', '40', '1');INSERT INTO `t_sys_relation` VALUES ('69', '39', '1');INSERT INTO `t_sys_relation` VALUES ('70', '47', '1');INSERT INTO `t_sys_relation` VALUES ('128', '41', '2');INSERT INTO `t_sys_relation` VALUES ('129', '42', '2');INSERT INTO `t_sys_relation` VALUES ('130', '43', '2');INSERT INTO `t_sys_relation` VALUES ('131', '44', '2');INSERT INTO `t_sys_relation` VALUES ('132', '45', '2');INSERT INTO `t_sys_relation` VALUES ('133', '46', '2');INSERT INTO `t_sys_relation` VALUES ('134', '65', '2');INSERT INTO `t_sys_relation` VALUES ('135', '66', '2');INSERT INTO `t_sys_relation` VALUES ('136', '67', '2');INSERT INTO `t_sys_relation` VALUES ('137', '68', '2');INSERT INTO `t_sys_relation` VALUES ('138', '69', '2');INSERT INTO `t_sys_relation` VALUES ('139', '70', '2');INSERT INTO `t_sys_relation` VALUES ('143', '2', '2');-- ------------------------------ Table structure for `t_sys_role`-- ----------------------------DROP TABLE IF EXISTS `t_sys_role`;CREATE TABLE `t_sys_role` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`deptid` bigint(20) DEFAULT NULL,`name` varchar(255) DEFAULT NULL,`num` int(11) DEFAULT NULL,`pid` bigint(20) DEFAULT NULL,`tips` varchar(255) DEFAULT NULL,`version` int(11) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色';-- ------------------------------ Records of t_sys_role-- ----------------------------INSERT INTO `t_sys_role` VALUES ('1', null, null, null, null, '24', '超级管理员', '1', '0', 'administrator', '1');INSERT INTO `t_sys_role` VALUES ('2', null, null, null, null, '25', '网站管理员', '1', '1', 'developer', null);-- ------------------------------ Table structure for `t_sys_task`-- ----------------------------DROP TABLE IF EXISTS `t_sys_task`;CREATE TABLE `t_sys_task` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`concurrent` tinyint(4) DEFAULT NULL COMMENT '是否允许并发',`cron` varchar(50) DEFAULT NULL COMMENT '定时规则',`data` text COMMENT '执行参数',`disabled` tinyint(4) DEFAULT NULL COMMENT '是否禁用',`exec_at` datetime DEFAULT NULL COMMENT '执行时间',`exec_result` text COMMENT '执行结果',`job_class` varchar(255) DEFAULT NULL COMMENT '执行类',`job_group` varchar(50) DEFAULT NULL COMMENT '任务组名',`name` varchar(50) DEFAULT NULL COMMENT '任务名',`note` varchar(255) DEFAULT NULL COMMENT '任务说明',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='定时任务';-- ------------------------------ Records of t_sys_task-- ----------------------------INSERT INTO `t_sys_task` VALUES ('1', '1', '2018-12-28 09:54:00', '-1', '2020-06-21 21:30:00', '0', '0 0/30 * * * ?', '{\n\"appname\": \"web-flash\",\n\"version\":1\n}\n\n\n\n\n\n\n\n\n\n\n\n ', '0', '2020-06-21 21:30:00', '执行成功', 'cn.enilu.flash.service.task.job.HelloJob', 'default', '测试任务', '测试任务,每30分钟执行一次');-- ------------------------------ Table structure for `t_sys_task_log`-- ----------------------------DROP TABLE IF EXISTS `t_sys_task_log`;CREATE TABLE `t_sys_task_log` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`exec_at` datetime DEFAULT NULL COMMENT '执行时间',`exec_success` int(11) DEFAULT NULL COMMENT '执行结果(成功:1、失败:0)',`id_task` bigint(20) DEFAULT NULL,`job_exception` varchar(500) DEFAULT NULL COMMENT '抛出异常',`name` varchar(50) DEFAULT NULL COMMENT '任务名',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='定时任务日志';-- ------------------------------ Records of t_sys_task_log-- ----------------------------INSERT INTO `t_sys_task_log` VALUES ('1', '2020-06-21 18:00:00', '1', '1', null, '测试任务');INSERT INTO `t_sys_task_log` VALUES ('2', '2020-06-21 18:30:00', '1', '1', null, '测试任务');INSERT INTO `t_sys_task_log` VALUES ('3', '2020-06-21 19:00:00', '1', '1', null, '测试任务');INSERT INTO `t_sys_task_log` VALUES ('4', '2020-06-21 19:30:00', '1', '1', null, '测试任务');INSERT INTO `t_sys_task_log` VALUES ('5', '2020-06-21 20:00:00', '1', '1', null, '测试任务');INSERT INTO `t_sys_task_log` VALUES ('6', '2020-06-21 20:30:00', '1', '1', null, '测试任务');INSERT INTO `t_sys_task_log` VALUES ('7', '2020-06-21 21:00:00', '1', '1', null, '测试任务');INSERT INTO `t_sys_task_log` VALUES ('8', '2020-06-21 21:30:00', '1', '1', null, '测试任务');-- ------------------------------ Table structure for `t_sys_user`-- ----------------------------DROP TABLE IF EXISTS `t_sys_user`;CREATE TABLE `t_sys_user` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`account` varchar(32) DEFAULT NULL COMMENT '账户',`avatar` varchar(255) DEFAULT NULL,`birthday` datetime DEFAULT NULL,`deptid` bigint(20) DEFAULT NULL,`email` varchar(64) DEFAULT NULL COMMENT 'email',`name` varchar(64) DEFAULT NULL COMMENT '姓名',`password` varchar(64) DEFAULT NULL COMMENT '密码',`phone` varchar(16) DEFAULT NULL COMMENT '手机号',`roleid` varchar(128) DEFAULT NULL COMMENT '角色id列表,以逗号分隔',`salt` varchar(16) DEFAULT NULL COMMENT '密码盐',`sex` int(11) DEFAULT NULL,`status` int(11) DEFAULT NULL,`version` int(11) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='账号';-- ------------------------------ Records of t_sys_user-- ----------------------------INSERT INTO `t_sys_user` VALUES ('-1', null, '2016-01-29 08:49:53', '1', '2019-03-20 23:45:24', 'system', null, null, null, null, '应用系统', null, null, null, null, null, null, null);INSERT INTO `t_sys_user` VALUES ('1', null, '2016-01-29 08:49:53', '1', '2019-03-20 23:45:24', 'admin', null, '2017-05-05 00:00:00', '2', 'eniluzt@qq.com', '管理员', 'b5a51391f271f062867e5984e2fcffee', '15021222222', '1', '8pgby', '2', '1', '2');INSERT INTO `t_sys_user` VALUES ('2', null, '2018-09-13 17:21:02', '1', '2019-01-09 23:05:51', 'developer', null, '2017-12-31 00:00:00', '3', 'eniluzt@qq.com', '网站管理员', 'fac36d5616fe9ebd460691264b28ee27', '15022222222', '2,', 'vscp9', '1', '1', null);-- ------------------------------ Table structure for `t_test_boy`-- ----------------------------DROP TABLE IF EXISTS `t_test_boy`;CREATE TABLE `t_test_boy` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`age` int(11) DEFAULT NULL COMMENT '年龄',`birthday` varchar(12) DEFAULT NULL COMMENT '生日',`has_girl_friend` tinyint(4) DEFAULT NULL COMMENT '是否有女朋友',`name` varchar(32) DEFAULT NULL COMMENT '姓名',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='男孩';-- ------------------------------ Records of t_test_boy-- ----------------------------INSERT INTO `t_test_boy` VALUES ('1', null, null, null, null, '18', '2000-01-01', '1', '张三');-- ------------------------------ Table structure for `t_test_girl`-- ----------------------------DROP TABLE IF EXISTS `t_test_girl`;CREATE TABLE `t_test_girl` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',`create_time` datetime DEFAULT NULL COMMENT '创建时间/注册时间',`modify_by` bigint(20) DEFAULT NULL COMMENT '最后更新人',`modify_time` datetime DEFAULT NULL COMMENT '最后更新时间',`age` int(11) DEFAULT NULL COMMENT '年龄',`birthday` date DEFAULT NULL COMMENT '生日',`has_boy_friend` tinyint(4) DEFAULT NULL COMMENT '是否有男朋友',`name` varchar(32) DEFAULT NULL COMMENT '姓名',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='女孩';-- ------------------------------ Records of t_test_girl-- ----------------------------
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。