Public/one-blog
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
one-blog/docs/db/init_data.sql
liushuang 8013c7f5f6 init
2024-07-28 23:39:54 +08:00

294 lines
75 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

################################### readme ###################################
#
# 该文件只用来初始化数据库内容，需要有限执行dblog.sql创建数据库
#
################################### readme ###################################
# 清空文章表
TRUNCATE TABLE `dblog`.`biz_article`;
# 初始化文章
INSERT INTO `dblog`.`biz_article` VALUES ('1', 'OneBlog简介', '1', 'zhyd/cover/20180613092017699.jpg', null, '1', '<h1 id=\"dblog-\">OneBlog简介</h1>\r\n<p>OneBlog是一款简洁美观、自适应的Java博客系统。使用springboot开发，前端使用Bootstrap。支持移动端自适应，配有完备的前台和后台管理功能。</p>\r\n<p><strong>网站预览</strong> </p>\r\n<p><a href=\"https://www.zhyd.me\">https://www.zhyd.me</a> </p>\r\n<p><strong>开源地址</strong> </p>\r\n<ol>\r\n<li><a href=\"https://gitee.com/yadong.zhang/DBlog\">Gitee</a> </li>\r\n<li><a href=\"https://github.com/zhangyd-c/DBlog\">Github</a> </li>\r\n</ol>\r\n<h2 id=\"-\">写在前面的话</h2>\r\n<p>ps: 虽然我知道，大部分人都是来了<strong>直接下载源代码</strong>后就潇洒的离开，并且只有等到下次<strong>突然想到</strong>“我天~~我得去看看OneBlog这烂项目更新新功能了吗”的时候才会重新来到这儿，即使你重新来过，我估计你也只有两个选择： </p>\r\n<p>发现更新代码了 --&gt; 下载源码后重复上面的步骤<br>发现没更新代码 --&gt; 直接关闭浏览器</p>\r\n<p>虽然我知道现实就是如此的残酷，但我还是要以我萤虫之力对各位到来的同仁发出一声诚挚的嘶吼：</p>\r\n<p><strong>如果喜欢，请多多分享！！多多Star！！fork可以，但还是请star一下！！</strong></p>\r\n<h3 id=\"-\">开发环境</h3>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th>工具</th>\r\n<th>版本或描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td>OS</td>\r\n<td>Windows 7</td>\r\n</tr>\r\n<tr>\r\n<td>JDK</td>\r\n<td>1.7+</td>\r\n</tr>\r\n<tr>\r\n<td>IDE</td>\r\n<td>IntelliJ IDEA 2017.3</td>\r\n</tr>\r\n<tr>\r\n<td>Maven</td>\r\n<td>3.3.1</td>\r\n</tr>\r\n<tr>\r\n<td>MySQL</td>\r\n<td>5.6.4</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"-\">模块划分</h3>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th>模块</th>\r\n<th>释义</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td>blog-core</td>\r\n<td>核心业务类模块，提供基本的数据操作、工具处理等</td>\r\n</tr>\r\n<tr>\r\n<td>blog-admin</td>\r\n<td>后台管理模块</td>\r\n</tr>\r\n<tr>\r\n<td>blog-web</td>\r\n<td>前台模块</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"-\">技术栈</h3>\r\n<ul>\r\n<li>Springboot 1.5.9</li>\r\n<li>Apache Shiro 1.2.2</li>\r\n<li>Logback</li>\r\n<li>Redis</li>\r\n<li>Lombok</li>\r\n<li>Websocket</li>\r\n<li>MySQL、Mybatis、Mapper、Pagehelper</li>\r\n<li>Freemarker</li>\r\n<li>Bootstrap 3.3.0</li>\r\n<li>wangEditor</li>\r\n<li>jQuery 1.11.1、jQuery Lazyload 1.9.7、fancybox、iCheck</li>\r\n<li>阿里云OSS</li>\r\n<li>kaptcha</li>\r\n<li>Qiniu</li>\r\n<li>...</li>\r\n</ul>\r\n<h3 id=\"-\">使用方法</h3>\r\n<ol>\r\n<li>使用IDE导入本项目</li>\r\n<li>新建数据库<code>CREATE DATABASE dblog;</code></li>\r\n<li>导入数据库<code>docs/db/dblog.sql</code></li>\r\n<li>修改(<code>resources/application.yml</code>)配置文件<ol>\r\n<li>数据库链接属性(可搜索<code>datasource</code>或定位到L.19) </li>\r\n<li>redis配置(可搜索<code>redis</code>或定位到L.69)</li>\r\n<li>mail配置(可搜索<code>mail</code>或定位到L.89)</li>\r\n<li>【<a href=\"http://qiniu.com\">七牛云</a>】配置(见sys<em>config表中qiniu</em>*开头的字段)<br>注：因为系统存在redis缓存，如果是第一次使用，可以直接修改sys_config表内容，如果不是第一次用，建议使用admin项目中的<code>系统配置</code>页面修改相关配置内容</li>\r\n</ol>\r\n</li>\r\n<li>运行项目(三种方式)<ol>\r\n<li>项目根目录下执行<code>mvn -X clean package -Dmaven.test.skip=true</code>编译打包，然后执行<code>java -jar target/blog-web.jar</code></li>\r\n<li>项目根目录下执行<code>mvn springboot:run</code></li>\r\n<li>直接运行<code>BlogWebApplication.java</code></li>\r\n</ol>\r\n</li>\r\n<li>浏览器访问<code>http://127.0.0.1:8443</code></li>\r\n</ol>\r\n<p><strong>后台用户</strong></p>\r\n<p><em>超级管理员</em>： 账号：root 密码：123456 （本地测试使用这个账号，admin没设置权限）</p>\r\n<p><em>普通管理员</em>： 账号：admin 密码：123456</p>\r\n<p><em>评论审核管理员</em>： 账号：comment-admin 密码：123456</p>\r\n<p>注：后台用户的创建，尽可能做到<strong>权限最小化</strong></p>\r\n<p>更多详情，请参考【<a href=\"https://gitee.com/yadong.zhang/DBlog/wikis\">Wiki</a>】</p>\r\n<h3 id=\"-\">更新日志</h3>\r\n<p>2018-06-10</p>\r\n<p><strong>修改功能：</strong></p>\r\n<p>新增：<br> markdown版的编辑器、评论框<br> 控制文章的评论框是否显示<br> 修改密码功能<br>优化：相关页面进行优化 </p>\r\n<p>2018-06-05</p>\r\n<p><strong>修改功能：</strong></p>\r\n<p>修复： admin用户首页报错的问题 </p>\r\n<p>优化：</p>\r\n<ol>\r\n<li>ROOT用户默认拥有所有权限</li>\r\n<li>admin页面改为macro引用的方式</li>\r\n<li>登录界面</li>\r\n<li>日志记录</li>\r\n</ol>\r\n<p>2018-05-25</p>\r\n<p><strong>修改功能：</strong></p>\r\n<ol>\r\n<li>修复后台标签等分页失败的问题</li>\r\n<li>修复前台自动申请友链失败的问题</li>\r\n<li>其他一些问题</li>\r\n</ol>\r\n<p>2018-05-22</p>\r\n<p><strong>修改功能：</strong></p>\r\n<ol>\r\n<li>完善shiro权限（数据库、页面）。注：需要重新执行下<code>sys_resources</code>和<code>sys_role_resources</code>两张表的<code>insert</code>语句</li>\r\n<li>redis配置默认不含密码（鉴于大多数朋友的redis都没有密码做此修改，不过本人 <strong>强烈建议</strong>设置下密码）</li>\r\n</ol>\r\n<p>2018-05-18</p>\r\n<p><strong>修复bug：</strong></p>\r\n<ol>\r\n<li>web端自动申请友链后不显示的问题</li>\r\n<li>config表修改后不能实时刷新的问题</li>\r\n</ol>\r\n<p><strong>增加功能：</strong></p>\r\n<ol>\r\n<li>网站赞赏码</li>\r\n<li>百度推送功能(链接提交到百度站长平台)</li>\r\n</ol>\r\n<p><strong>修改功能：</strong></p>\r\n<ol>\r\n<li>百度api的ak和百度推送的token以及七牛云的配置改为通过config表管理</li>\r\n<li>admin模块菜单通过标签实时获取</li>\r\n<li>弹窗工具类js结构调整</li>\r\n</ol>\r\n<p>你能看到这儿已经很不容易了，剩下的自己先摸索摸索吧，实在不行，加QQ群<a href=\"http://shang.qq.com/wpa/qunwpa?idkey=9f986e9b33b1de953e1ef9a96cdeec990affd0ac7855e00ff103514de2027b60\">190886500</a>，进群可以选择性的备注：<del>欧巴群主我爱你</del>(咳咳，鉴于部分群友的抗议，该备注就不用了)，麻烦大家换成：<code>我猜群主一定很帅</code></p>\r\n<h3 id=\"-\">图片预览</h3>\r\n<p><strong>前台页面</strong><br><img src=\"https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/pc-index.png?v=1.0\" alt=\"PC-首页\"><br><img src=\"https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/pc-detail.png?v=1.0\" alt=\"PC-文章详情页\"><br><img src=\"https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/m.png?v=1.0\" alt=\"手机\"><br><strong>后台页面</strong><br><img src=\"https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-index.png?v=1.0\" alt=\"首页\"><br><img src=\"https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-menu.png?v=1.0\" alt=\"菜单\"><br><img src=\"https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-articles.png?v=1.0\" alt=\"文章列表\"><br><img src=\"https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-article2.png?v=1.0\" alt=\"发表文章\"><br><img src=\"https://gitee.com/uploads/images/2018/0610/145228_06541ada_784199.png?v=1.0\" alt=\"markdown版的编辑器\" title=\"markdown版的编辑器\"><br><img src=\"https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-role.png?v=1.0\" alt=\"角色列表\"><br><img src=\"https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-role2.png?v=1.0\" alt=\"角色分配\"></p>\r\n<h3 id=\"-\">生命不息，折腾不止！ 更多信息，请关注：</h3>\r\n<ol>\r\n<li><a href=\"https://www.zhyd.me\">我的博客</a></li>\r\n<li><a href=\"http://weibo.com/211230415\">我的微博</a></li>\r\n<li><a href=\"http://www.toutiao.com/c/user/3286958681/\">我的头条号</a></li>\r\n<li><p><a href=\"http://www.imooc.com/u/1175248/articles\">我的mooc</a></p>\r\n<h3 id=\"-\">有任何问题可以</h3>\r\n<ul>\r\n<li><a href=\"https://www.zhyd.me/guestbook\">给我留言</a></li>\r\n</ul>\r\n</li>\r\n</ol>\r\n<h3 id=\"-\">开源协议</h3>\r\n<p> <a href=\"https://gitee.com/yadong.zhang/DBlog/blob/master/LICENSE\">MIT</a></p>\r\n', '# OneBlog简介\r\nOneBlog是一款简洁美观、自适应的Java博客系统。使用springboot开发，前端使用Bootstrap。支持移动端自适应，配有完备的前台和后台管理功能。\r\n \r\n**网站预览** \r\n \r\n[https://www.zhyd.me](https://www.zhyd.me) \r\n\r\n**开源地址** \r\n1. [Gitee](https://gitee.com/yadong.zhang/DBlog) \r\n2. [Github](https://github.com/zhangyd-c/DBlog) \r\n\r\n## 写在前面的话\r\nps: 虽然我知道，大部分人都是来了**直接下载源代码**后就潇洒的离开，并且只有等到下次**突然想到**“我天~~我得去看看OneBlog这烂项目更新新功能了吗”的时候才会重新来到这儿，即使你重新来过，我估计你也只有两个选择： \r\n\r\n发现更新代码了 --> 下载源码后重复上面的步骤 \r\n发现没更新代码 --> 直接关闭浏览器\r\n\r\n虽然我知道现实就是如此的残酷，但我还是要以我萤虫之力对各位到来的同仁发出一声诚挚的嘶吼：\r\n\r\n**如果喜欢，请多多分享！！多多Star！！fork可以，但还是请star一下！！**\r\n\r\n\r\n### 开发环境\r\n\r\n| 工具 | 版本或描述 |\r\n| ----- | -------------------- |\r\n| OS | Windows 7 |\r\n| JDK | 1.7+ |\r\n| IDE | IntelliJ IDEA 2017.3 |\r\n| Maven | 3.3.1 |\r\n| MySQL | 5.6.4 |\r\n\r\n### 模块划分\r\n\r\n| 模块 | 释义 |\r\n| ---------- | ----------------------- |\r\n| blog-core | 核心业务类模块，提供基本的数据操作、工具处理等 |\r\n| blog-admin | 后台管理模块 |\r\n| blog-web | 前台模块 |\r\n\r\n\r\n### 技术栈\r\n\r\n- Springboot 1.5.9\r\n- Apache Shiro 1.2.2\r\n- Logback\r\n- Redis\r\n- Lombok\r\n- Websocket\r\n- MySQL、Mybatis、Mapper、Pagehelper\r\n- Freemarker\r\n- Bootstrap 3.3.0\r\n- wangEditor\r\n- jQuery 1.11.1、jQuery Lazyload 1.9.7、fancybox、iCheck\r\n- 阿里云OSS\r\n- kaptcha\r\n- Qiniu\r\n- ...\r\n\r\n\r\n### 使用方法\r\n\r\n1. 使用IDE导入本项目\r\n2. 新建数据库`CREATE DATABASE dblog;`\r\n3. 导入数据库`docs/db/dblog.sql`\r\n4. 修改(`resources/application.yml`)配置文件\r\n 1. 数据库链接属性(可搜索`datasource`或定位到L.19) \r\n 2. redis配置(可搜索`redis`或定位到L.69)\r\n 3. mail配置(可搜索`mail`或定位到L.89)\r\n 4. 【[七牛云](http://qiniu.com)】配置(见sys_config表中qiniu_*开头的字段) \r\n 注：因为系统存在redis缓存，如果是第一次使用，可以直接修改sys_config表内容，如果不是第一次用，建议使用admin项目中的`系统配置`页面修改相关配置内容\r\n5. 运行项目(三种方式)\r\n 1. 项目根目录下执行`mvn -X clean package -Dmaven.test.skip=true`编译打包，然后执行`java -jar target/blog-web.jar`\r\n 2. 项目根目录下执行`mvn springboot:run`\r\n 3. 直接运行`BlogWebApplication.java`\r\n6. 浏览器访问`http://127.0.0.1:8443`\r\n\r\n\r\n**后台用户**\r\n\r\n_超级管理员_： 账号：root 密码：123456 （本地测试使用这个账号，admin没设置权限）\r\n\r\n_普通管理员_： 账号：admin 密码：123456\r\n\r\n_评论审核管理员_： 账号：comment-admin 密码：123456\r\n\r\n注：后台用户的创建，尽可能做到**权限最小化**\r\n\r\n更多详情，请参考【[Wiki](https://gitee.com/yadong.zhang/DBlog/wikis)】\r\n\r\n### 更新日志\r\n\r\n2018-06-10\r\n\r\n**修改功能：**\r\n\r\n新增： \r\n markdown版的编辑器、评论框 \r\n 控制文章的评论框是否显示 \r\n 修改密码功能 \r\n优化：相关页面进行优化 \r\n\r\n2018-06-05\r\n\r\n**修改功能：**\r\n\r\n修复： admin用户首页报错的问题 \r\n\r\n优化：\r\n1. ROOT用户默认拥有所有权限\r\n2. admin页面改为macro引用的方式\r\n3. 登录界面\r\n4. 日志记录\r\n\r\n2018-05-25\r\n\r\n**修改功能：**\r\n\r\n1. 修复后台标签等分页失败的问题\r\n2. 修复前台自动申请友链失败的问题\r\n3. 其他一些问题\r\n\r\n\r\n2018-05-22\r\n\r\n**修改功能：**\r\n\r\n1. 完善shiro权限（数据库、页面）。注：需要重新执行下`sys_resources`和`sys_role_resources`两张表的`insert`语句\r\n2. redis配置默认不含密码（鉴于大多数朋友的redis都没有密码做此修改，不过本人 **强烈建议**设置下密码）\r\n\r\n2018-05-18\r\n\r\n**修复bug：**\r\n\r\n1. web端自动申请友链后不显示的问题\r\n2. config表修改后不能实时刷新的问题\r\n \r\n**增加功能：**\r\n1. 网站赞赏码\r\n2. 百度推送功能(链接提交到百度站长平台)\r\n \r\n**修改功能：**\r\n1. 百度api的ak和百度推送的token以及七牛云的配置改为通过config表管理\r\n3. admin模块菜单通过标签实时获取\r\n3. 弹窗工具类js结构调整\r\n\r\n你能看到这儿已经很不容易了，剩下的自己先摸索摸索吧，实在不行，加QQ群[190886500](http://shang.qq.com/wpa/qunwpa?idkey=9f986e9b33b1de953e1ef9a96cdeec990affd0ac7855e00ff103514de2027b60)，进群可以选择性的备注：~~欧巴群主我爱你~~(咳咳，鉴于部分群友的抗议，该备注就不用了)，麻烦大家换成：`我猜群主一定很帅`\r\n\r\n### 图片预览\r\n\r\n**前台页面**\r\n![PC-首页](https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/pc-index.png?v=1.0)\r\n![PC-文章详情页](https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/pc-detail.png?v=1.0)\r\n![手机](https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/m.png?v=1.0)\r\n**后台页面**\r\n![首页](https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-index.png?v=1.0)\r\n![菜单](https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-menu.png?v=1.0)\r\n![文章列表](https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-articles.png?v=1.0)\r\n![发表文章](https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-article2.png?v=1.0)\r\n![markdown版的编辑器](https://gitee.com/uploads/images/2018/0610/145228_06541ada_784199.png?v=1.0 \"markdown版的编辑器\")\r\n![角色列表](https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-role.png?v=1.0)\r\n![角色分配](https://gitee.com/yadong.zhang/DBlog/raw/master/docs/img/admin-role2.png?v=1.0)\r\n\r\n\r\n ### 生命不息，折腾不止！ 更多信息，请关注：\r\n 1. [我的博客](https://www.zhyd.me)\r\n 2. [我的微博](http://weibo.com/211230415)\r\n 3. [我的头条号](http://www.toutiao.com/c/user/3286958681/)\r\n 4. [我的mooc](http://www.imooc.com/u/1175248/articles)\r\n\r\n ### 有任何问题可以\r\n- [给我留言](https://www.zhyd.me/guestbook)\r\n\r\n\r\n### 开源协议\r\n\r\n [MIT](https://gitee.com/yadong.zhang/OneBlog/blob/master/LICENSE)', '0', '3', '1', '0', '1', 'OneBlog是一款简洁美观、自适应的Java博客系统。使用springboot开发，前端使用Bootstrap。支持移动端自适应，配有完备的前台和后台管理功能。', 'OneBlog,开源博客', '1', now(), now());
INSERT INTO `dblog`.`biz_article` VALUES ('2', 'OneBlog简介（未开启评论）', '1', 'zhyd/cover/20180613092017699.jpg', null, '1', '<h1 id=\"dblog-\">OneBlog简介</h1>\n<p>OneBlog是一款简洁美观、自适应的Java博客系统。使用springboot开发，前端使用Bootstrap。支持移动端自适应，配有完备的前台和后台管理功能。</p>\n<p><strong>网站预览</strong> </p>\n<p><a href=\"https://www.zhyd.me\">https://www.zhyd.me</a> </p>\n<p><strong>开源地址</strong> </p>\n<ol>\n<li><a href=\"https://gitee.com/yadong.zhang/DBlog\">Gitee</a> </li>\n<li><a href=\"https://github.com/zhangyd-c/DBlog\">Github</a> </li>\n</ol>\n<h2 id=\"-\">写在前面的话</h2>\n<p>ps: 虽然我知道，大部分人都是来了<strong>直接下载源代码</strong>后就潇洒的离开，并且只有等到下次<strong>突然想到</strong>“我天~~我得去看看OneBlog这烂项目更新新功能了吗”的时候才会重新来到这儿，即使你重新来过，我估计你也只有两个选择： </p>\n<p>发现更新代码了 --&gt; 下载源码后重复上面的步骤<br>发现没更新代码 --&gt; 直接关闭浏览器</p>\n<p>虽然我知道现实就是如此的残酷，但我还是要以我萤虫之力对各位到来的同仁发出一声诚挚的嘶吼：</p>\n<p><strong>如果喜欢，请多多分享！！多多Star！！fork可以，但还是请star一下！！</strong></p>\n<h3 id=\"-\">开发环境</h3>\n<table>\n<thead>\n<tr>\n<th>工具</th>\n<th>版本或描述</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>OS</td>\n<td>Windows 7</td>\n</tr>\n<tr>\n<td>JDK</td>\n<td>1.7+</td>\n</tr>\n<tr>\n<td>IDE</td>\n<td>IntelliJ IDEA 2017.3</td>\n</tr>\n<tr>\n<td>Maven</td>\n<td>3.3.1</td>\n</tr>\n<tr>\n<td>MySQL</td>\n<td>5.6.4</td>\n</tr>\n</tbody>\n</table>\n<h3 id=\"-\">模块划分</h3>\n<table>\n<thead>\n<tr>\n<th>模块</th>\n<th>释义</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>blog-core</td>\n<td>核心业务类模块，提供基本的数据操作、工具处理等</td>\n</tr>\n<tr>\n<td>blog-admin</td>\n<td>后台管理模块</td>\n</tr>\n<tr>\n<td>blog-web</td>\n<td>前台模块</td>\n</tr>\n</tbody>\n</table>\n<h3 id=\"-\">技术栈</h3>\n<ul>\n<li>Springboot 1.5.9</li>\n<li>Apache Shiro 1.2.2</li>\n<li>Logback</li>\n<li>Redis</li>\n<li>Lombok</li>\n<li>Websocket</li>\n<li>MySQL、Mybatis、Mapper、Pagehelper</li>\n<li>Freemarker</li>\n<li>Bootstrap 3.3.0</li>\n<li>wangEditor</li>\n<li>jQuery 1.11.1、jQuery Lazyload 1.9.7、fancybox、iCheck</li>\n<li>阿里云OSS</li>\n<li>kaptcha</li>\n<li>Qiniu</li>\n<li>...</li>\n</ul>\n<h3 id=\"-\">使用方法</h3>\n<ol>\n<li>使用IDE导入本项目</li>\n<li>新建数据库<code>CREATE DATABASE dblog;</code></li>\n<li>导入数据库<code>docs/db/dblog.sql</code></li>\n<li>修改(<code>resources/application.yml</code>)配置文件<ol>\n<li>数据库链接属性(可搜索<code>datasource</code>或定位到L.19) </li>\n<li>redis配置(可搜索<code>redis</code>或定位到L.69)</li>\n<li>mail配置(可搜索<code>mail</code>或定位到L.89)</li>\n<li>【<a href=\"http://qiniu.com\">七牛云</a>】配置(见sys<em>config表中qiniu</em>*开头的字段)<br>注：因为系统存在redis缓存，如果是第一次使用，可以直接修改sys_config表内容，如果不是第一次用，建议使用admin项目中的<code>系统配置</code>页面修改相关配置内容</li>\n</ol>\n</li>\n<li>运行项目(三种方式)<ol>\n<li>项目根目录下执行<code>mvn -X clean package -Dmaven.test.skip=true</code>编译打包，然后执行<code>java -jar target/blog-web.jar</code></li>\n<li>项目根目录下执行<code>mvn springboot:run</code></li>\n<li>直接运行<code>BlogWebApplication.java</code></li>\n</ol>\n</li>\n<li>浏览器访问<code>http://127.0.0.1:8443</code></li>\n</ol>\n<p><strong>后台用户</strong></p>\n<p><em>超级管理员</em>： 账号：root 密码：123456 （本地测试使用这个账号，admin没设置权限）</p>\n<p><em>普通管理员</em>： 账号：admin 密码：123456</p>\n<p><em>评论审核管理员</em>： 账号：comment-admin 密码：123456</p>\n<p>注：后台用户的创建，尽可能做到<strong>权限最小化</strong></p>\n<p>更多详情，请参考【<a href=\"https://gitee.com/yadong.zhang/DBlog/wikis\">Wiki</a>】</p>\n', '# OneBlog简介\nDBlog是一款简洁美观、自适应的Java博客系统。使用springboot开发，前端使用Bootstrap。支持移动端自适应，配有完备的前台和后台管理功能。\n \n**网站预览** \n \n[https://www.zhyd.me](https://www.zhyd.me) \n\n**开源地址** \n1. [Gitee](https://gitee.com/yadong.zhang/DBlog) \n2. [Github](https://github.com/zhangyd-c/DBlog) \n\n## 写在前面的话\nps: 虽然我知道，大部分人都是来了**直接下载源代码**后就潇洒的离开，并且只有等到下次**突然想到**“我天~~我得去看看OneBlog这烂项目更新新功能了吗”的时候才会重新来到这儿，即使你重新来过，我估计你也只有两个选择： \n\n发现更新代码了 --> 下载源码后重复上面的步骤 \n发现没更新代码 --> 直接关闭浏览器\n\n虽然我知道现实就是如此的残酷，但我还是要以我萤虫之力对各位到来的同仁发出一声诚挚的嘶吼：\n\n**如果喜欢，请多多分享！！多多Star！！fork可以，但还是请star一下！！**\n\n\n### 开发环境\n\n| 工具 | 版本或描述 |\n| ----- | -------------------- |\n| OS | Windows 7 |\n| JDK | 1.7+ |\n| IDE | IntelliJ IDEA 2017.3 |\n| Maven | 3.3.1 |\n| MySQL | 5.6.4 |\n\n### 模块划分\n\n| 模块 | 释义 |\n| ---------- | ----------------------- |\n| blog-core | 核心业务类模块，提供基本的数据操作、工具处理等 |\n| blog-admin | 后台管理模块 |\n| blog-web | 前台模块 |\n\n\n### 技术栈\n\n- Springboot 1.5.9\n- Apache Shiro 1.2.2\n- Logback\n- Redis\n- Lombok\n- Websocket\n- MySQL、Mybatis、Mapper、Pagehelper\n- Freemarker\n- Bootstrap 3.3.0\n- wangEditor\n- jQuery 1.11.1、jQuery Lazyload 1.9.7、fancybox、iCheck\n- 阿里云OSS\n- kaptcha\n- Qiniu\n- ...\n\n\n### 使用方法\n\n1. 使用IDE导入本项目\n2. 新建数据库`CREATE DATABASE dblog;`\n3. 导入数据库`docs/db/dblog.sql`\n4. 修改(`resources/application.yml`)配置文件\n 1. 数据库链接属性(可搜索`datasource`或定位到L.19) \n 2. redis配置(可搜索`redis`或定位到L.69)\n 3. mail配置(可搜索`mail`或定位到L.89)\n 4. 【[七牛云](http://qiniu.com)】配置(见sys_config表中qiniu_*开头的字段) \n 注：因为系统存在redis缓存，如果是第一次使用，可以直接修改sys_config表内容，如果不是第一次用，建议使用admin项目中的`系统配置`页面修改相关配置内容\n5. 运行项目(三种方式)\n 1. 项目根目录下执行`mvn -X clean package -Dmaven.test.skip=true`编译打包，然后执行`java -jar target/blog-web.jar`\n 2. 项目根目录下执行`mvn springboot:run`\n 3. 直接运行`BlogWebApplication.java`\n6. 浏览器访问`http://127.0.0.1:8443`\n\n\n**后台用户**\n\n_超级管理员_： 账号：root 密码：123456 （本地测试使用这个账号，admin没设置权限）\n\n_普通管理员_： 账号：admin 密码：123456\n\n_评论审核管理员_： 账号：comment-admin 密码：123456\n\n注：后台用户的创建，尽可能做到**权限最小化**\n\n更多详情，请参考【[Wiki](https://gitee.com/yadong.zhang/DBlog/wikis)】', '0', '3', '1', '0', '1', 'OneBlog是一款简洁美观、自适应的Java博客系统。使用springboot开发，前端使用Bootstrap。支持移动端自适应，配有完备的前台和后台管理功能。', 'OneBlog,开源博客', '0', now(), now());
# 清空标签表
TRUNCATE TABLE `dblog`.`biz_tags`;
# 初始化标签
INSERT INTO `dblog`.`biz_tags` VALUES ('1', 'Linux', null, now(), now());
INSERT INTO `dblog`.`biz_tags` VALUES ('2', 'Java', null, now(), now());
INSERT INTO `dblog`.`biz_tags` VALUES ('3', 'Spring', null, now(), now());
INSERT INTO `dblog`.`biz_tags` VALUES ('4', 'Spring Boot', null, now(), now());
INSERT INTO `dblog`.`biz_tags` VALUES ('5', '其他', null, now(), now());
# 清空文章标签表
TRUNCATE TABLE `dblog`.`biz_article_tags`;
# 初始化文章标签
INSERT INTO `dblog`.`biz_article_tags` VALUES ('1', '5', '1', now(), now());
INSERT INTO `dblog`.`biz_article_tags` VALUES ('2', '1', '2', now(), now());
INSERT INTO `dblog`.`biz_article_tags` VALUES ('3', '2', '3', now(), now());
INSERT INTO `dblog`.`biz_article_tags` VALUES ('4', '2', '4', now(), now());
# 清空文章分类表
TRUNCATE TABLE `dblog`.`biz_type`;
# 初始化文章分类
INSERT INTO `dblog`.`biz_type` VALUES ('1', null, '前端技术', '主要收集、整理的基础前端类文章，包括JS、jQuery和CSS等Web开发所需的基础的文章总结', '1', 'fa fa-css3', '1', now(), now());
INSERT INTO `dblog`.`biz_type` VALUES ('2', null, '后端技术', '网站中记录的后端类文章，包括Java、SSM、MySQL和其他在日常工作学习中所用的后端技术', '2', 'fa fa-coffee', '1', now(), now());
INSERT INTO `dblog`.`biz_type` VALUES ('3', null, '其他文章', '记录网站建设以及日常工作、学习中的闲言碎语和个人笔记等文章', '3', 'fa fa-folder-open-o', '1', now(), now());
# 清空系统配置表
TRUNCATE TABLE `dblog`.`sys_config`;
# 初始化系统配置
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (1, 'homeDesc', 'OneBlog是一款简洁美观、自适应的Java博客系统。使用springboot开发，前端使用Bootstrap。支持移动端自适应，配有完备的前台和后台管理功能。', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (2, 'homeKeywords', 'OneBlog,开源博客', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (3, 'domain', 'zhyd.me', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (4, 'cmsUrl', 'http://localhost:8085', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (5, 'siteUrl', 'http://localhost:8443', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (6, 'siteName', 'OneBlog开源博客', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (7, 'siteDesc', 'OneBlog是一款简洁美观、自适应的Java博客系统', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (8, 'siteFavicon', 'http://localhost:8443/img/favicon.ico', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (9, 'staticWebSite', 'http://localhost:8443', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (10, 'authorName', '张亚东', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (11, 'authorEmail', 'yadong.zhang0415#gmail.com', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (12, 'wxCode', 'https://static.zhyd.me/static/img/wechat_account.jpg', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (13, 'qq', '843977358', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (14, 'weibo', 'http://weibo.com/211230415', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (15, 'github', 'https://github.com/zhangyd-c', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (16, 'maintenance', '0', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (17, 'maintenanceDate', now(), now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (18, 'comment', '1', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (19, 'qiniuBasePath', NULL, now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (20, 'qiniuAccessKey', NULL, now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (21, 'qiniuSecretKey', NULL, now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (22, 'qiniuBucketName', NULL, now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (23, 'baiduPushToken', NULL, now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (24, 'wxPraiseCode', NULL, now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (25, 'zfbPraiseCode', NULL, now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (26, 'baiduApiAk', 'NwHaYlGalDEpgxm46xBaC3T9', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (27, 'spiderConfig', '{\r\n imooc: {\r\n domain: \"www.imooc.com\",\r\n titleRegex: \"//span[@class=js-title]/html()\",\r\n authorRegex: \"//div[@class=name_con]/p[@class=name]/a[@class=nick]/html()\",\r\n releaseDateRegex: \"//div[@class=\'dc-profile\']/div[@class=\'l\']/span[@class=\'spacer\']/text()\",\r\n contentRegex: \"//div[@class=detail-content]/html()\",\r\n targetLinksRegex: \"/article/[0-9]{1,10}\",\r\n tagRegex: \"//div[@class=cat-box]/div[@class=cat-wrap]/a[@class=cat]/html()\",\r\n header: [\r\n \"Host=www.imooc.com\",\r\n \"Referer=https://www.imooc.com\"\r\n ],\r\n entryUrls: \'https://www.imooc.com/u/{uid}/articles?page={curPage}\'\r\n },\r\n csdn: {\r\n domain: \"blog.csdn.net\",\r\n titleRegex: \"//h1[@class=title-article]/html()\",\r\n authorRegex: \"//a[@class=follow-nickName]/html()\",\r\n releaseDateRegex: \"//div[@class=\'article-bar-top\']/span[@class=\'time\']/text()\",\r\n contentRegex: \"//div[@class=article_content]/html()\",\r\n targetLinksRegex: \".*blog\\\\.csdn\\\\.net/{uid}/article/details/[0-9a-zA-Z]{1,15}\",\r\n tagRegex: \"//span[@class=artic-tag-box]/a[@class=tag-link]/html()\",\r\n header: [\r\n \"Host=blog.csdn.net\",\r\n \"Referer=https://blog.csdn.net/{uid}/article/list/1\"\r\n ],\r\n entryUrls: \'https://blog.csdn.net/{uid}/article/list/{curPage}\'\r\n },\r\n iteye: {\r\n domain: \"{uid}.iteye.com\",\r\n titleRegex: \"//div[@class=blog_title]/h3/a/html()\",\r\n authorRegex: \"//div[@id=blog_owner_name]/html()\",\r\n releaseDateRegex: \"//div[@class=blog_bottom]/ul/li/html()\",\r\n contentRegex: \"//div[@class=blog_content]/html()\",\r\n targetLinksRegex: \".*{uid}\\\\.iteye\\\\.com/blog/[0-9]+\",\r\n tagRegex: \"//div[@class=news_tag]/a/html()\",\r\n header: [\r\n \"Host={uid}.iteye.com\",\r\n \"Referer=http://{uid}.iteye.com/\"\r\n ],\r\n entryUrls: \'http://{uid}.iteye.com/?page={curPage}\'\r\n },\r\n csblogs: {\r\n domain: \"www.cnblogs.com\",\r\n titleRegex: \"//a[@id=cb_post_title_url]/html()\",\r\n authorRegex: \"//div[@class=postDesc]/a[1]/html()\",\r\n releaseDateRegex: \"//span[@id=post-date]/html()\",\r\n contentRegex: \"//div[@id=cnblogs_post_body]/html()\",\r\n targetLinksRegex: \".*www\\\\.cnblogs\\\\.com/{uid}/p/[\\\\w\\\\d]+\\\\.html\",\r\n tagRegex: \"//div[@id=EntryTag]/a/html()\",\r\n header: [\r\n \"Host=www.cnblogs.com\",\r\n \"Referer=https://www.cnblogs.com/\"\r\n ],\r\n entryUrls: \'https://www.cnblogs.com/{uid}/default.html?page={curPage}\'\r\n }\r\n }', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (28, 'anonymous', '1', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (29, 'editorPlaceholder', '说点什么吧', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (30, 'editorAlert', '讲文明、要和谐', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (31, 'defaultUserAvatar', '[\r\n \"http://localhost:8443/img/random/user/1.jpg\",\r\n \"http://localhost:8443/img/random/user/2.jpg\",\r\n \"http://localhost:8443/img/random/user/3.jpg\",\r\n \"http://localhost:8443/img/random/user/4.jpg\",\r\n \"http://localhost:8443/img/random/user/5.jpg\",\r\n \"http://localhost:8443/img/random/user/6.jpg\",\r\n \"http://localhost:8443/img/random/user/7.jpg\",\r\n \"http://localhost:8443/img/random/user/8.jpg\",\r\n \"http://localhost:8443/img/random/user/9.jpg\",\r\n \"http://localhost:8443/img/random/user/10.jpg\",\r\n \"http://localhost:8443/img/random/user/11.jpg\",\r\n \"http://localhost:8443/img/random/user/12.jpg\",\r\n \"http://localhost:8443/img/random/user/13.jpg\",\r\n \"http://localhost:8443/img/random/user/14.jpg\",\r\n \"http://localhost:8443/img/random/user/15.jpg\",\r\n \"http://localhost:8443/img/random/user/16.jpg\",\r\n \"http://localhost:8443/img/random/user/17.jpg\",\r\n \"http://localhost:8443/img/random/user/18.jpg\",\r\n \"http://localhost:8443/img/random/user/19.jpg\",\r\n \"http://localhost:8443/img/random/user/20.jpg\"\r\n]', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (32, 'sessionTimeOut', '5', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (33, 'sessionTimeOutUnit', 'MINUTES', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (34, 'loginRetryNum', '5', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (35, 'installdate', now(), now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (36, 'copyright', 'Copyright zhyd.me', now(), now());
INSERT INTO `dblog`.`sys_config`(`id`, `config_key`, `config_value`, `create_time`, `update_time`) VALUES (37, 'dynamicTitle', '您有一条新消息', now(), now());
# 清空友情链接表
TRUNCATE TABLE `dblog`.`sys_link`;
# 初始化友情链接
INSERT INTO `dblog`.`sys_link` VALUES ('1', 'https://www.zhyd.me', '张亚东博客', '一个程序员的个人博客', 'yadong.zhang0415@gmail.com', null, 'https://static.zhyd.me/static/img/favicon.ico', '1', '1', null, 'ADMIN', now(), now());
# 清空系统通知表
TRUNCATE TABLE `dblog`.`sys_notice`;
# 初始化系统通知
INSERT INTO `dblog`.`sys_notice` VALUES (1, 1, 'RELEASE', 'OneBlog开源博客', 'OneBlog开源博客，一款超好用的Java版开源博客', now(), now());
INSERT INTO `dblog`.`sys_notice` VALUES (2, 1, 'RELEASE', '问题反馈', '在使用过程中，有问题请先参考相关文档，确实无法解决的，请优先提Issue，感谢各位老铁', now(), now());
# 清空系统模板表
TRUNCATE TABLE `dblog`.`sys_template`;
# 初始化系统模板
INSERT INTO `dblog`.`sys_template` VALUES ('1', 'TM_SITEMAP_XML', '<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<urlset xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\" xsi:schemaLocation=\"http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd\">\r\n <url>\r\n <loc>${config.siteUrl}</loc>\r\n <priority>1.0</priority>\r\n <lastmod>${.now?string(\"yyyy-MM-dd\")}</lastmod>\r\n <changefreq>daily</changefreq>\r\n </url>\r\n <url>\r\n <loc>${config.siteUrl}/about</loc>\r\n <priority>0.6</priority>\r\n <lastmod>${.now?string(\"yyyy-MM-dd\")}</lastmod>\r\n <changefreq>daily</changefreq>\r\n </url>\r\n <url>\r\n <loc>${config.siteUrl}/links</loc>\r\n <priority>0.6</priority>\r\n <lastmod>${.now?string(\"yyyy-MM-dd\")}</lastmod>\r\n <changefreq>daily</changefreq>\r\n </url>\r\n <url>\r\n <loc>${config.siteUrl}/guestbook</loc>\r\n <priority>0.6</priority>\r\n <lastmod>${.now?string(\"yyyy-MM-dd\")}</lastmod>\r\n <changefreq>daily</changefreq>\r\n </url>\r\n <url>\r\n <loc>${config.siteUrl}/updateLog</loc>\r\n <priority>0.6</priority>\r\n <lastmod>${.now?string(\"yyyy-MM-dd\")}</lastmod>\r\n <changefreq>daily</changefreq>\r\n </url>\r\n <url>\r\n <loc>${config.siteUrl}/recommended</loc>\r\n <priority>0.6</priority>\r\n <lastmod>${.now?string(\"yyyy-MM-dd\")}</lastmod>\r\n <changefreq>daily</changefreq>\r\n </url>\r\n <#list articleList as item>\r\n <url>\r\n <loc>${config.siteUrl}/article/${item.id}</loc>\r\n <priority>0.6</priority>\r\n <lastmod>${item.updateTime?string(\"yyyy-MM-dd\")}</lastmod>\r\n <changefreq>daily</changefreq>\r\n </url>\r\n </#list>\r\n <#list articleTypeList as item>\r\n <url>\r\n <loc>${config.siteUrl}/type/${item.id}</loc>\r\n <priority>0.6</priority>\r\n <lastmod>${item.updateTime?string(\"yyyy-MM-dd\")}</lastmod>\r\n <changefreq>daily</changefreq>\r\n </url>\r\n </#list>\r\n \r\n <#list articleTagsList as item>\r\n <url>\r\n <loc>${config.siteUrl}/tag/${item.id}</loc>\r\n <priority>0.6</priority>\r\n <lastmod>${item.updateTime?string(\"yyyy-MM-dd\")}</lastmod>\r\n <changefreq>daily</changefreq>\r\n </url>\r\n </#list>\r\n</urlset>', now(), now());
INSERT INTO `dblog`.`sys_template` VALUES ('2', 'TM_SITEMAP_TXT', '${config.siteUrl}\r\n${config.siteUrl}/about\r\n${config.siteUrl}/links\r\n${config.siteUrl}/guestbook\r\n${config.siteUrl}/updateLog\r\n${config.siteUrl}/recommended\r\n<#list articleList as item>\r\n${config.siteUrl}/article/${item.id}\r\n</#list>\r\n<#list articleTypeList as item>\r\n${config.siteUrl}/type/${item.id}\r\n</#list>\r\n<#list articleTagsList as item>\r\n${config.siteUrl}/tag/${item.id}\r\n</#list>', now(), now());
INSERT INTO `dblog`.`sys_template` VALUES ('3', 'TM_SITEMAP_HTML', '<!DOCTYPE html>\r\n<html lang=\"zh-CN\">\r\n<head>\r\n <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>\r\n <title>${config.siteName} 网站地图</title>\r\n <meta name=\"author\" content=\"SiteMapX.com\"/>\r\n <meta name=\"robots\" content=\"index,follow\"/>\r\n <style type=\"text/css\">\r\n body {\r\n color: #000000;\r\n background: #ffffff;\r\n margin: 20px;\r\n font-family: Verdana, Arial, Helvetica, sans-serif;\r\n font-size: 12px;\r\n }\r\n\r\n #myTable {\r\n list-style: none;\r\n margin: 10px 0px 10px 0px;\r\n padding: 0px;\r\n width: 100%;\r\n min-width: 804px;\r\n }\r\n\r\n #myTable li {\r\n list-style-type: none;\r\n width: 100%;\r\n min-width: 404px;\r\n height: 20px;\r\n line-height: 20px;\r\n }\r\n\r\n .pull-left{\r\n float: left!important;\r\n }\r\n .pull-right{\r\n float: right!important;\r\n }\r\n\r\n #myTable li .T1-h {\r\n font-weight: bold;\r\n min-width: 300px;\r\n }\r\n\r\n #myTable li .T2-h {\r\n width: 200px;\r\n font-weight: bold;\r\n }\r\n\r\n #myTable li .T3-h {\r\n width: 200px;\r\n font-weight: bold;\r\n }\r\n\r\n #myTable li .T4-h {\r\n width: 100px;\r\n font-weight: bold;\r\n }\r\n\r\n #myTable li .T1 {\r\n min-width: 300px;\r\n }\r\n\r\n #myTable li .T2 {\r\n width: 200px;\r\n }\r\n\r\n #myTable li .T3 {\r\n width: 200px;\r\n }\r\n\r\n #myTable li .T4 {\r\n width: 100px;\r\n }\r\n\r\n #footer {\r\n padding: 2px;\r\n margin: 0px;\r\n font-size: 8pt;\r\n color: gray;\r\n min-width: 900px;\r\n }\r\n\r\n #footer a {\r\n color: gray;\r\n }\r\n\r\n .myClear {\r\n clear: both;\r\n }\r\n\r\n #nav, #content, #footer {padding: 8px; border: 1px solid #EEEEEE; clear: both; width: 95%; margin: auto; margin-top: 10px;}\r\n\r\n </style>\r\n</head>\r\n<body>\r\n<h2 style=\"text-align: center; margin-top: 20px\">${config.siteName?if_exists} 网站地图 </h2>\r\n<div id=\"nav\"><a href=\"${config.siteUrl?if_exists}\"><strong>${config.siteName?if_exists}</strong></a> &raquo; <a href=\"${config.siteUrl?if_exists}/sitemap.html\">站点地图</a></div>\r\n<div id=\"content\">\r\n <h3>最新文章</h3>\r\n <ul id=\"myTable\">\r\n <li>\r\n <div class=\"T1-h pull-left\">URL</div>\r\n <div class=\"T2-h pull-right\">Last Change</div>\r\n <div class=\"T3-h pull-right\">Change Frequency</div>\r\n <div class=\"T4-h pull-right\">Priority</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n <li>\r\n <div class=\"T1 pull-left\"><a href=\"${config.siteUrl}\" title=\"${config.siteName}\">${config.siteName} | 一个程序员的个人博客</a></div>\r\n <div class=\"T2 pull-right\">${.now?string(\"yyyy-MM-dd\")}</div>\r\n <div class=\"T3 pull-right\">daily</div>\r\n <div class=\"T4 pull-right\">1</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n <li>\r\n <div class=\"T1 pull-left\"><a href=\"${config.siteUrl}/about\" title=\"${config.siteName}\">关于 | ${config.siteName}</a></div>\r\n <div class=\"T2 pull-right\">${.now?string(\"yyyy-MM-dd\")}</div>\r\n <div class=\"T3 pull-right\">daily</div>\r\n <div class=\"T4 pull-right\">0.6</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n <li>\r\n <div class=\"T1 pull-left\"><a href=\"${config.siteUrl}/links\" title=\"${config.siteName}\">友情链接 | ${config.siteName}</a></div>\r\n <div class=\"T2 pull-right\">${.now?string(\"yyyy-MM-dd\")}</div>\r\n <div class=\"T3 pull-right\">daily</div>\r\n <div class=\"T4 pull-right\">0.6</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n <li>\r\n <div class=\"T1 pull-left\"><a href=\"${config.siteUrl}/guestbook\" title=\"${config.siteName}\">留言板 | ${config.siteName}</a></div>\r\n <div class=\"T2 pull-right\">${.now?string(\"yyyy-MM-dd\")}</div>\r\n <div class=\"T3 pull-right\">daily</div>\r\n <div class=\"T4 pull-right\">0.6</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n <li>\r\n <div class=\"T1 pull-left\"><a href=\"${config.siteUrl}/updateLog\" title=\"${config.siteName}\">网站更新记录 | ${config.siteName}</a></div>\r\n <div class=\"T2 pull-right\">${.now?string(\"yyyy-MM-dd\")}</div>\r\n <div class=\"T3 pull-right\">daily</div>\r\n <div class=\"T4 pull-right\">0.6</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n <li>\r\n <div class=\"T1 pull-left\"><a href=\"${config.siteUrl}/recommended\" title=\"${config.siteName}\">站长推荐 | ${config.siteName}</a></div>\r\n <div class=\"T2 pull-right\">${.now?string(\"yyyy-MM-dd\")}</div>\r\n <div class=\"T3 pull-right\">daily</div>\r\n <div class=\"T4 pull-right\">0.6</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n <#list articleList as item>\r\n <li>\r\n <div class=\"T1 pull-left\"><a href=\"${config.siteUrl}/article/${item.id}\" title=\"${item.title}\">${item.title} | ${config.siteName}</a></div>\r\n <div class=\"T2 pull-right\">${item.updateTime?string(\"yyyy-MM-dd\")}</div>\r\n <div class=\"T3 pull-right\">daily</div>\r\n <div class=\"T4 pull-right\">0.6</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n </#list>\r\n </ul>\r\n</div>\r\n<div id=\"content\">\r\n <h3>分类目录</h3>\r\n <ul id=\"myTable\">\r\n <#list articleTypeList as item>\r\n <li>\r\n <div class=\"T1 pull-left\"><a href=\"${config.siteUrl}/type/${item.id}\" title=\"${item.name}\">${item.name} | ${config.siteName}</a></div>\r\n <div class=\"T2 pull-right\">${item.updateTime?string(\"yyyy-MM-dd\")}</div>\r\n <div class=\"T3 pull-right\">daily</div>\r\n <div class=\"T4 pull-right\">0.6</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n </#list>\r\n </ul>\r\n</div>\r\n<div id=\"content\">\r\n <h3>标签目录</h3>\r\n <ul id=\"myTable\">\r\n <#list articleTagsList as item>\r\n <li>\r\n <div class=\"T1 pull-left\"><a href=\"${config.siteUrl}/tag/${item.id}\" title=\"${item.name}\">${item.name} | ${config.siteName}</a></div>\r\n <div class=\"T2 pull-right\">${item.updateTime?string(\"yyyy-MM-dd\")}</div>\r\n <div class=\"T3 pull-right\">daily</div>\r\n <div class=\"T4 pull-right\">0.6</div>\r\n </li>\r\n <div class=\"myClear\"></div>\r\n </#list>\r\n </ul>\r\n</div>\r\n<div id=\"footer\">\r\n 该文件由<a href=\"${config.siteUrl}\" title=\"${config.siteName}\">${config.siteName}</a>网站自动生成。\r\n</div>\r\n</body>\r\n</html>', now(), now());
INSERT INTO `dblog`.`sys_template` VALUES ('4', 'TM_ROBOTS', 'Crawl-delay: 5\r\nSitemap: ${config.cmsUrl}/sitemap.txt\r\nSitemap: ${config.cmsUrl}/sitemap.xml\r\nSitemap: ${config.cmsUrl}/sitemap.html\r\n', now(), now());
INSERT INTO `dblog`.`sys_template` VALUES ('5', 'TM_LINKS', '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n <meta charset=\"UTF-8\">\r\n <title>友情链接操作通知</title>\r\n</head>\r\n<body>\r\n<div style=\"border-radius:5px;font-size:13px;width:680px;font-family:微软雅黑,\'Helvetica Neue\',Arial,sans-serif;margin:10px auto 0px;border:1px solid #eee;max-width:100%\">\r\n <div style=\"width:100%;background:#2f889a;color:#ffffff;border-radius:5px 5px 0 0\">\r\n <p style=\"font-size:15px;word-break:break-all;padding:20px 32px;margin:0\">\r\n 友情链接操作通知\r\n </p>\r\n </div>\r\n <div style=\"margin:0px auto;width:90%\">\r\n <p>站长<a href=\"${link.url?if_exists}\" target=\"_blank\">${link.name?if_exists}</a>，您好!</p>\r\n <p>您于 ${link.createTime?string(\'yyyy-MM-dd HH:mm:ss\')} 提交的友链申请已通过系统审核。以下为您提交的信息，请确认（如有误，请联系我）！</p>\r\n <p>\r\n <ul>\r\n <li>${link.name?if_exists}</li>\r\n <li>${link.url?if_exists}</li>\r\n <li>${link.description?if_exists}</li>\r\n <li>${link.email?if_exists}</li>\r\n <li>${link.qq?if_exists}</li>\r\n <li><img src=\"${link.favicon?if_exists}\" width=\"100\" alt=\"LOGO\"></li>\r\n </ul>\r\n </p>\r\n <p>本站会不定期检查连接有效性，如果因为贵站改版、服务到期等原因导致无法正常访问的，我会暂时停掉贵站友链，待贵站可以正常访问后，本站会继续启用贵站友链。</p>\r\n <p>特别注意：以下情况，本站将在不做任何通知下，<strong>取消友链</strong>！</p>\r\n <ul>\r\n <li>私自取消本站友情链接</li>\r\n <li>更换域名且未通知本站</li>\r\n <li>网站内容长期不更新</li>\r\n <li>友链上使用诸如nofollow之类的属性</li>\r\n </ul>\r\n <p>感谢您对 <a style=\"text-decoration:none;\" href=\"${config.siteUrl?if_exists}\" target=\"_blank\">${config.siteName?if_exists}</a> 的关注，如您有任何疑问，欢迎来我网站<a style=\"text-decoration:none;\" href=\"${config.siteUrl}/guestbook\" target=\"_blank\">留言</a>。</p>\r\n <p>（注：此邮件由系统自动发出，请勿回复。）</p>\r\n </div>\r\n <div class=\"adL\">\r\n </div>\r\n</div>\r\n</body>\r\n</html>', now(), now());
INSERT INTO `dblog`.`sys_template` VALUES ('6', 'TM_COMMENT_AUDIT', '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n <meta charset=\"UTF-8\">\r\n <title>评论审核结果通知</title>\r\n</head>\r\n<body>\r\n<div style=\"border-radius:5px;font-size:13px;width:680px;font-family:微软雅黑,\'Helvetica Neue\',Arial,sans-serif;margin:10px auto 0px;border:1px solid #eee;max-width:100%\">\r\n <div style=\"width:100%;background:#2f889a;color:#ffffff;border-radius:5px 5px 0 0\">\r\n <p style=\"font-size:15px;word-break:break-all;padding:20px 32px;margin:0\">\r\n 评论审核结果通知\r\n </p>\r\n </div>\r\n <div style=\"margin:0px auto;width:90%\">\r\n <p>${comment.nickname?if_exists}，您好!</p>\r\n <p>\r\n 您于 ${comment.createTime?string(\'yyyy-MM-dd HH:mm:ss\')} 在文章《${config.siteUrl?if_exists}${comment.sourceUrl?if_exists}》 上发表的<span class=\"il\">评论</span>：\r\n </p>\r\n <div style=\"background:#efefef;margin:15px 0px;padding:1px 15px;border-radius:5px;font-size:14px;color:#333\">${comment.content}</div>\r\n <#if comment.status == \'APPROVED\'>\r\n <p>已通过管理员审核并显示。</p>\r\n <p>\r\n 您可以点击 <a style=\"text-decoration:none;\" href=\"${config.siteUrl}${comment.sourceUrl}\" target=\"_blank\">链接</a>查看回复的完整內容。\r\n </p>\r\n <#elseif comment.status == \'REJECT\'>\r\n <p>审核失败！失败原因：</p>\r\n <p style=\"background:#efefef;margin:15px 0px;padding:1px 15px;border-radius:5px;font-size:14px;color:#333\">${comment.remark}</p>\r\n <#elseif comment.status == \'DELETED\'>\r\n <p>已被管理员删除！删除原因：</p>\r\n <p style=\"background:#efefef;margin:15px 0px;padding:1px 15px;border-radius:5px;font-size:14px;color:#333\">${comment.remark}</p>\r\n <#else>\r\n <p>管理员正在审核中！审核通过后将给您及时发送通知！</p>\r\n </#if>\r\n <p>感谢您对 <a style=\"text-decoration:none;\" href=\"${config.siteUrl}\" target=\"_blank\">${config.siteName}</a> 的关注，如您有任何疑问，欢迎来我网站<a style=\"text-decoration:none;\" href=\"${config.siteUrl}/guestbook\" target=\"_blank\">留言</a>。</p>\r\n <p>（注：此邮件由系统自动发出，请勿回复。）</p>\r\n </div>\r\n <div class=\"adL\">\r\n </div>\r\n</div>\r\n</body>\r\n</html>', now(), now());
INSERT INTO `dblog`.`sys_template` VALUES ('7', 'TM_COMMENT_REPLY', '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n <meta charset=\"UTF-8\">\r\n <title>评论回复通知</title>\r\n</head>\r\n<body>\r\n<div style=\"border-radius:5px;font-size:13px;width:680px;font-family:微软雅黑,\'Helvetica Neue\',Arial,sans-serif;margin:10px auto 0px;border:1px solid #eee;max-width:100%\">\r\n <div style=\"width:100%;background:#2f889a;color:#ffffff;border-radius:5px 5px 0 0\">\r\n <p style=\"font-size:15px;word-break:break-all;padding:20px 32px;margin:0\">\r\n 评论回复通知\r\n </p>\r\n </div>\r\n <div style=\"margin:0px auto;width:90%\">\r\n <p>${comment.nickname}，您好!</p>\r\n <p>\r\n 您于 ${comment.createTime?string(\'yyyy-MM-dd HH:mm:ss\')} 在文章《${config.siteUrl}${comment.sourceUrl}》 上发表的<span class=\"il\">评论</span>：\r\n </p>\r\n <div style=\"background:#efefef;margin:15px 0px;padding:1px 15px;border-radius:5px;font-size:14px;color:#333\">${comment.content}</div>\r\n <p>\r\n 有了 <strong>新的回复</strong>！您可以点击 <a style=\"text-decoration:none;\" href=\"${config.siteUrl}${comment.sourceUrl}\" target=\"_blank\">链接</a>查看回复的完整內容。\r\n </p>\r\n <p>感谢您对 <a style=\"text-decoration:none;\" href=\"${config.siteUrl}\" target=\"_blank\">${config.siteName}</a> 的关注，如您有任何疑问，欢迎来我网站<a style=\"text-decoration:none;\" href=\"${config.siteUrl}/guestbook\" target=\"_blank\">留言</a>。</p>\r\n <p>（注：此邮件由系统自动发出，请勿回复。）</p>\r\n </div>\r\n <div class=\"adL\">\r\n </div>\r\n</div>\r\n</body>\r\n</html>', now(), now());
INSERT INTO `dblog`.`sys_template` VALUES ('8', 'TM_LINKS_TO_ADMIN', '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n <meta charset=\"UTF-8\">\r\n <title>友情链接操作通知</title>\r\n</head>\r\n<body>\r\n<div style=\"border-radius:5px;font-size:13px;width:680px;font-family:微软雅黑,\'Helvetica Neue\',Arial,sans-serif;margin:10px auto 0px;border:1px solid #eee;max-width:100%\">\r\n <div style=\"width:100%;background:#2f889a;color:#ffffff;border-radius:5px 5px 0 0\">\r\n <p style=\"font-size:15px;word-break:break-all;padding:20px 32px;margin:0\">\r\n 友情链接操作通知\r\n </p>\r\n </div>\r\n <div style=\"margin:0px auto;width:90%\">\r\n <p>有新的友情链接加入，信息如下</p>\r\n <p>\r\n <ul>\r\n <li>${link.name?if_exists}</li>\r\n <li>${link.url?if_exists}</li>\r\n <li>${link.description?if_exists}</li>\r\n <#if link.favicon?exists><li><img src=\"${link.favicon?if_exists}\" width=\"100\" alt=\"LOGO\"></li></#if>\r\n </ul>\r\n </p>\r\n <p><a style=\"text-decoration:none;\" href=\"${config.cmsUrl}\" target=\"_blank\">去后台继续审核</a>。</p>\r\n <p>（注：此邮件由系统自动发出，请勿回复。）</p>\r\n </div>\r\n <div class=\"adL\">\r\n </div>\r\n</div>\r\n</body>\r\n</html>', now(), now());
INSERT INTO `dblog`.`sys_template` VALUES ('9', 'TM_NEW_COMMENT', '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n <meta charset=\"UTF-8\">\r\n <title>新评论通知</title>\r\n</head>\r\n<body>\r\n<div style=\"border-radius:5px;font-size:13px;width:680px;font-family:微软雅黑,\'Helvetica Neue\',Arial,sans-serif;margin:10px auto 0px;border:1px solid #eee;max-width:100%\">\r\n <div style=\"width:100%;background:#2f889a;color:#ffffff;border-radius:5px 5px 0 0\">\r\n <p style=\"font-size:15px;word-break:break-all;padding:20px 32px;margin:0\">\r\n 新评论通知\r\n </p>\r\n </div>\r\n <div style=\"margin:0px auto;width:90%\">\r\n <p>\r\n 评论内容：\r\n </p>\r\n <div style=\"background:#efefef;margin:15px 0px;padding:1px 15px;border-radius:5px;font-size:14px;color:#333\"><#if comment?exists>${comment.content}<#else>**无评论内容**</#if></div>\r\n <p>\r\n <a style=\"text-decoration:none;\" href=\"${config.siteUrl}${comment.sourceUrl}\" target=\"_blank\">查看完整评论</a>\r\n </p>\r\n <p>（注：此邮件由系统自动发出，请勿回复。）</p>\r\n </div>\r\n <div class=\"adL\">\r\n </div>\r\n</div>\r\n</body>\r\n</html>', now(), now());
INSERT INTO `dblog`.`sys_template` VALUES ('10', 'TM_NGINX_FILE_SERVER', 'server {\r\n listen 80;\r\n server_name serverName;\r\n root serverPath;\r\n error_page 403 /error.html;\r\n location = /error.html {\r\n return 404;\r\n }\r\n autoindex off; \r\n autoindex_exact_size off; \r\n autoindex_localtime off; \r\n \r\n location ^~ / {\r\n proxy_set_header Host $host:$server_port;\r\n }\r\n \r\n location ~*\\.(jpg|gif|png|swf|flv|wma|wmv|asf|mp3|mmf|zip|rar|js|css)$ {\r\n expires 30d;\r\n valid_referers serverReferers;\r\n if ($invalid_referer) {\r\n rewrite ^/ serverLogoPath;\r\n }\r\n }\r\n}\r\n', now(), now());
# 清空系统更新通知表
TRUNCATE TABLE `dblog`.`sys_update_recorde`;
# 初始化系统更新通知
INSERT INTO `dblog`.`sys_update_recorde` VALUES ('1', '1.0.1', '第一版', now(), now(), now());
# 清空系统资源表
TRUNCATE TABLE `dblog`.`sys_resources`;
# 初始化系统资源
INSERT INTO `dblog`.`sys_resources` VALUES (1, '用户管理', 'menu', '', '', 0, 4, 0, 1, 'fa fa-users', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (2, '用户列表', 'menu', '/users', 'users', 1, 1, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (3, '新增用户', 'button', NULL, 'user:add', 2, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (4, '批量删除用户', 'button', NULL, 'user:batchDelete', 2, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (5, '编辑用户', 'button', NULL, 'user:edit,user:get', 2, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (6, '删除用户', 'button', NULL, 'user:delete', 2, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (7, '分配用户角色', 'button', NULL, 'user:allotRole', 2, 6, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (8, '权限管理', 'menu', '', '', 0, 3, 0, 1, 'fa fa-cogs', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (9, '资源管理', 'menu', '/resources', 'resources', 8, 1, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (10, '新增资源', 'button', NULL, 'resource:add', 9, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (11, '批量删除资源', 'button', NULL, 'resource:batchDelete', 9, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (12, '编辑资源', 'button', NULL, 'resource:edit,resource:get', 9, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (13, '删除资源', 'button', NULL, 'resource:delete', 9, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (14, '角色管理', 'menu', '/roles', 'roles', 8, 2, 0, 1, '', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (15, '新增角色', 'button', NULL, 'role:add', 14, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (16, '批量删除角色', 'button', NULL, 'role:batchDelete', 14, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (17, '编辑角色', 'button', NULL, 'role:edit,role:get', 14, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (18, '删除角色', 'button', NULL, 'role:delete', 14, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (19, '分配角色资源', 'button', NULL, 'role:allotResource', 14, 6, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (20, '文章管理', 'menu', '', '', 0, 1, 0, 1, 'fa fa-list', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (21, '文章列表', 'menu', '/articles', 'articles', 20, 1, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (22, '发表文章', 'button', NULL, 'article:publish', 21, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (23, '批量删除文章', 'button', NULL, 'article:batchDelete', 21, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (24, '批量推送文章', 'button', NULL, 'article:batchPush', 21, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (25, '推送文章', 'button', NULL, 'article:push', 21, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (26, '置顶文章', 'button', NULL, 'article:top', 21, 6, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (27, '推荐文章', 'button', NULL, 'article:recommend', 21, 7, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (28, '编辑文章', 'button', NULL, 'article:edit,article:get', 21, 8, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (29, '删除文章', 'button', NULL, 'article:delete', 21, 9, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (30, '分类列表', 'menu', '/article/types', 'types', 20, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (31, '添加分类', 'button', NULL, 'type:add', 30, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (32, '批量删除分类', 'button', NULL, 'type:batchDelete', 30, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (33, '编辑分类', 'button', NULL, 'type:edit,type:get', 30, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (34, '删除分类', 'button', NULL, 'type:delete', 30, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (35, '标签列表', 'menu', '/article/tags', 'tags', 20, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (36, '添加标签', 'button', NULL, 'tag:add', 35, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (37, '批量删除标签', 'button', NULL, 'tag:batchDelete', 35, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (38, '编辑标签', 'button', NULL, 'tag:edit,tag:get', 35, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (39, '删除标签', 'button', NULL, 'tag:delete', 35, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (40, '网站管理', 'menu', '', '', 0, 2, 0, 1, 'fa fa-globe', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (41, '友情链接', 'menu', '/links', 'links', 40, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (42, '添加友情链接', 'button', NULL, 'link:add', 41, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (43, '批量删除友情链接', 'button', NULL, 'link:batchDelete', 41, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (44, '编辑友情链接', 'button', NULL, 'link:edit,link:get', 41, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (45, '删除友情链接', 'button', NULL, 'link:delete', 41, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (46, '评论管理', 'menu', '/comments', 'comments', 40, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (47, '批量删除评论', 'button', NULL, 'comment:batchDelete', 46, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (48, '回复评论', 'button', NULL, 'comment:reply', 46, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (49, '审核评论', 'button', NULL, 'comment:audit', 46, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (50, '删除评论', 'button', NULL, 'comment:delete', 46, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (51, '模板管理', 'menu', '/templates', 'templates', 40, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (52, '添加模板', 'button', NULL, 'template:add', 51, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (53, '批量删除模板', 'button', NULL, 'template:batchDelete', 51, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (54, '编辑模板', 'button', NULL, 'template:edit,template:get', 51, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (55, '删除模板', 'button', NULL, 'template:delete', 51, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (56, '更新日志', 'menu', '/updates', 'updateLogs', 40, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (57, '添加更新日志', 'button', NULL, 'updateLog:add', 51, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (58, '批量删除更新日志', 'button', NULL, 'updateLog:batchDelete', 51, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (59, '编辑更新日志', 'button', NULL, 'updateLog:edit,updateLog:get', 51, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (60, '删除更新日志', 'button', NULL, 'updateLog:delete', 51, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (61, '公告管理', 'menu', '/notices', 'notices', 40, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (62, '添加公告', 'button', NULL, 'notice:add', 61, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (63, '批量删除公告', 'button', NULL, 'notice:batchDelete', 61, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (64, '编辑公告', 'button', NULL, 'notice:edit,notice:get', 61, 4, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (65, '删除公告', 'button', NULL, 'notice:delete', 61, 5, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (66, '发布公告', 'button', NULL, 'notice:release', 61, 6, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (67, '撤回公告', 'button', NULL, 'notice:withdraw', 61, 7, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (68, '测试页面', 'menu', '', '', 0, 6, 0, 1, 'fa fa-desktop', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (69, 'icons图标', 'menu', '/icons', 'icons', 68, 2, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (70, 'shiro测试', 'menu', '/shiro', 'shiro', 68, 3, 0, 1, NULL, now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (71, '推送消息', 'menu', '/notice', 'notice', 72, NULL, 0, 1, '', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (72, '实验室', 'menu', '', '', 0, 5, 0, 1, 'fa fa-flask', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (73, '文章搬运工', 'menu', '/remover', 'remover', 72, NULL, 0, 1, '', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (74, '编辑器', 'menu', '/editor', 'editor', 68, NULL, 0, 1, '', now(), now());
INSERT INTO `dblog`.`sys_resources` VALUES (75, '文件管理', 'menu', '/files', 'files', 40, 6, 0, 1, NULL, now(), now());
# 清空系统角色
TRUNCATE TABLE `dblog`.`sys_role`;
# 初始化系统角色
INSERT INTO `dblog`.`sys_role` VALUES ('1', 'role:root', '超级管理员', '1', now(), now());
INSERT INTO `dblog`.`sys_role` VALUES ('2', 'role:admin', '管理员', '1', now(), now());
INSERT INTO `dblog`.`sys_role` VALUES ('3', 'role:comment', '评论审核管理员', '1', now(), now());
# 清空角色->资源对应内容
TRUNCATE TABLE `dblog`.`sys_role_resources`;
# 初始化角色->资源对应内容
INSERT INTO `dblog`.`sys_role_resources` VALUES ('1', '1', '1', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('2', '1', '2', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('3', '1', '3', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('4', '1', '4', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('5', '1', '5', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('6', '1', '6', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('7', '1', '7', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('8', '1', '8', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('9', '1', '9', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('10', '1', '10', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('11', '1', '11', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('12', '1', '12', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('13', '1', '13', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('14', '1', '14', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('15', '1', '15', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('16', '1', '16', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('17', '1', '17', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('18', '1', '18', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('19', '1', '19', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('20', '1', '20', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('21', '1', '21', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('22', '1', '22', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('23', '1', '23', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('24', '1', '24', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('25', '1', '25', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('26', '1', '26', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('27', '1', '27', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('28', '1', '28', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('29', '1', '29', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('30', '1', '30', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('31', '1', '31', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('32', '1', '32', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('33', '1', '33', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('34', '1', '34', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('35', '1', '35', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('36', '1', '36', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('37', '1', '37', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('38', '1', '38', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('39', '1', '39', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('40', '1', '40', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('41', '1', '41', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('42', '1', '42', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('43', '1', '43', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('44', '1', '44', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('45', '1', '45', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('46', '1', '46', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('47', '1', '47', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('48', '1', '48', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('49', '1', '49', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('50', '1', '50', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('51', '1', '51', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('52', '1', '52', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('53', '1', '57', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('54', '1', '53', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('55', '1', '58', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('56', '1', '54', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('57', '1', '59', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('58', '1', '55', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('59', '1', '60', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('60', '1', '56', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('61', '1', '61', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('62', '1', '62', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('63', '1', '63', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('64', '1', '64', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('65', '1', '65', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('66', '1', '66', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('67', '1', '67', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('68', '1', '68', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('84', '2', '20', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('85', '2', '21', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('86', '2', '24', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('87', '2', '25', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('88', '2', '26', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('89', '2', '27', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('93', '3', '40', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('94', '3', '46', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('95', '3', '48', now(), now());
INSERT INTO `dblog`.`sys_role_resources` VALUES ('96', '3', '49', now(), now());
# 清空系统用户表
TRUNCATE TABLE `dblog`.`sys_user`;
# 初始化系统用户
INSERT INTO `dblog`.`sys_user` VALUES (1, 'root', 'CGUx1FN++xS+4wNDFeN6DA==', '超级管理员', '15151551516', '843977358@qq.com', '843977358', NULL, NULL, 'https://static.zhyd.me/static/img/favicon.ico', 'ROOT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, '0:0:0:0:0:0:0:1', '2019-06-01 11:59:23', 254, NULL, 1, now(), now());
INSERT INTO `dblog`.`sys_user` VALUES (2, 'admin', 'gXp2EbyZ+sB/A6QUMhiUJQ==', '管理员', '15151551516', '843977358@qq.com', '843977358', NULL, NULL, NULL, 'ADMIN', NULL, NULL, NULL, NULL, NULL, 1, 1, 0, 0, '0:0:0:0:0:0:0:1', '0:0:0:0:0:0:0:1',now(), 2, NULL, 1,now(),now());
INSERT INTO `dblog`.`sys_user` VALUES (3, 'comment-admin', 'x9qCx3yP05yWfIE5wXbCsg==', '评论审核管理员', '', '', '', NULL, NULL, NULL, 'ADMIN', NULL, NULL, NULL, NULL, NULL, 1, 1, 0, 0, '0:0:0:0:0:0:0:1', '0:0:0:0:0:0:0:1',now(), 1, NULL, 1,now(),now());
# 清空用户角色关联数据
TRUNCATE TABLE `dblog`.`sys_user_role`;
# 初始化用户角色关联数据
INSERT INTO `dblog`.`sys_user_role` VALUES ('1', '1', '1', now(), now());
INSERT INTO `dblog`.`sys_user_role` VALUES ('2', '2', '2', now(), now());
INSERT INTO `dblog`.`sys_user_role` VALUES ('3', '3', '3', now(), now());
# 清空评论数据
TRUNCATE TABLE `dblog`.`biz_comment`;
# 初始化评论数据
INSERT INTO `dblog`.`biz_comment` VALUES (0, '1', null, '0', '843977358', '七彩狼', 'https://q1.qlogo.cn/g?b=qq&nk=843977358&s=40', '843977358@qq.com', 'https://www.zhyd.me', 'VERIFYING', '0:0:0:0:0:0:0:1', null, null, '未知', 'Windows 7', null, 'Chrome 65.0.3325.146', null, '<p>测试评论</p>', null, '0', '0', now(), now());
Reference in New Issue View Git Blame Copy Permalink