text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 3306
   Source Server Type    : MySQL
   Source Server Version : 80011
   Source Host           : localhost:3306
   Source Schema         : blog
  
   Target Server Type    : MySQL
   Target Server Version : 80011
   File Encoding         : 65001
  
   Date: 19/10/2018 08:23:49
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for article
  -- ----------------------------
  DROP TABLE IF EXISTS `article`;
  CREATE TABLE `article` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `uid` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '用户id',
    `title` varchar(30) NOT NULL DEFAULT '' COMMENT '文章中文title',
    `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属栏目id',
    `category_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
    `source` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '来源 原创/参考/转载',
    `display` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示 0 隐藏 1显示',
    `thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '缩略图 路径',
    `summary` varchar(255) NOT NULL DEFAULT '',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新/修改时间',
    `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否禁用: 0删除 1正常',
    `views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问数',
    `comments` int(5) unsigned NOT NULL DEFAULT '0' COMMENT '评论数量',
    `likes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数',
    `html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '文章主题内容',
    `markdown` longtext NOT NULL COMMENT '存储markdown内容',
    `smtitle` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `tags` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '标签json',
    `featured` tinyint(3) unsigned DEFAULT '0' COMMENT '推荐字段',
    PRIMARY KEY (`id`),
    KEY `category_id` (`category_id`,`is_delete`)
  ) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of article
  -- ----------------------------
  BEGIN;
  INSERT INTO `article` VALUES (54, 1, 'Setup VPN 使用方法', 49, '其它', '原创', 1, 'https://www.html-js.cn/upload/smallimgs/img20160413171705.png', 'Setup VPN 使用方法', '2018-10-17 10:20:58', '2018-10-17 10:20:58', 1, 0, 0, 0, '<h1 id=\"h1--tw-1f1e8-1f1f3-\"><a name=\":tw-1f1e8-1f1f3:\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span><img src=\"http://twemoji.maxcdn.com/36x36/1f1e8-1f1f3.png\" title=\"twemoji-1f1e8-1f1f3\" alt=\"twemoji-1f1e8-1f1f3\" class=\"emoji twemoji\"></h1><h3 id=\"h3-setup-vpn-\"><a name=\"setup vpn下载\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>setup vpn下载</h3><p><a href=\"https://node2.173app.com/chrome/ext/oofgbpoabipfcfjapgnbbjjaenockbdp?name=SetupVPN  - 终身免费VPN「SetupVPN - Lifetime Free VPN」&amp;prodversion=69.0.3497.100http://\" title=\"setup vpn下载链接\">setup vpn下载链接</a></p>\n<h3 id=\"h3-u8FDBu5165u62D3u5C55u7A0Bu5E8Fu9875\"><a name=\"进入拓展程序页\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>进入拓展程序页</h3><p><a href=\"https://i.loli.net/2018/10/08/5bbabcb79f237.png\"><img src=\"https://i.loli.net/2018/10/08/5bbabcb79f237.png\" alt=\"\"></a></p>\n<h3 id=\"h3--vpn-\"><a name=\"将下载的vpn拖进拓展页内\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>将下载的vpn拖进拓展页内</h3><p><a href=\"https://i.loli.net/2018/10/08/5bbabd7a7d288.png\"><img src=\"https://i.loli.net/2018/10/08/5bbabd7a7d288.png\" alt=\"\"></a></p>\n<h3 id=\"h3-u5B89u88C5u5B8Cu540Eu4F1Au51FAu73B0u4E0Bu56FEu4E24u4E2Au4E1Cu897F\"><a name=\"安装完后会出现下图两个东西\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>安装完后会出现下图两个东西</h3><p><a href=\"https://i.loli.net/2018/10/08/5bbabe2db9f2f.png\"><img src=\"https://i.loli.net/2018/10/08/5bbabe2db9f2f.png\" alt=\"\"></a></p>\n<h3 id=\"h3--\"><a name=\"点击右上角小图标,选择汉语\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>点击右上角小图标,选择汉语</h3><p><a href=\"https://i.loli.net/2018/10/08/5bbabed0e1e46.png\"><img src=\"https://i.loli.net/2018/10/08/5bbabed0e1e46.png\" alt=\"\"></a></p>\n<h3 id=\"h3-u6CE8u518Cu8D26u6237\"><a name=\"注册账户\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>注册账户</h3><p><a href=\"https://i.loli.net/2018/10/08/5bbabed0e39a8.png\">https://i.loli.net/2018/10/08/5bbabed0e39a8.png</a></p>\n<h3 id=\"h3--\"><a name=\"填写信息—密码会在点击注册后发送到你的邮箱里,注意查看\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>填写信息—密码会在点击注册后发送到你的邮箱里,注意查看</h3><p><a href=\"https://i.loli.net/2018/10/08/5bbabed0e5739.png\"><img src=\"https://i.loli.net/2018/10/08/5bbabed0e5739.png\" alt=\"\"></a></p>\n<h3 id=\"h3--vpn-twitter-\"><a name=\"再次点击小图标,登录vpn,选择你需要的节点,这里我想看twitter,所以选择美国节点\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>再次点击小图标,登录vpn,选择你需要的节点,这里我想看twitter,所以选择美国节点</h3><p><a href=\"https://i.loli.net/2018/10/08/5bbac01c573e2.png\"><img src=\"https://i.loli.net/2018/10/08/5bbac01c573e2.png\" alt=\"\"></a></p>\n<h3 id=\"h3--vpn-\"><a name=\"等待连接vpn,完成后会有以下提示\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>等待连接vpn,完成后会有以下提示</h3><p><a href=\"https://i.loli.net/2018/10/08/5bbac08175458.png\"><img src=\"https://i.loli.net/2018/10/08/5bbac08175458.png\" alt=\"\"></a></p>\n<h3 id=\"h3--a-a-\"><a name=\"成功后就可以愉快翻墙了…<a></a>\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>成功后就可以愉快翻墙了…<a href=\"https://i.loli.net/2018/10/08/5bbac08257fa6.png\"><img src=\"https://i.loli.net/2018/10/08/5bbac08257fa6.png\" alt=\"\"></a></h3>', '#:tw-1f1e8-1f1f3:\n### setup vpn下载\n[setup vpn下载链接](https://node2.173app.com/chrome/ext/oofgbpoabipfcfjapgnbbjjaenockbdp?name=SetupVPN  - 终身免费VPN「SetupVPN - Lifetime Free VPN」&prodversion=69.0.3497.100http:// \"setup vpn下载链接\")\n###进入拓展程序页\n[![](https://i.loli.net/2018/10/08/5bbabcb79f237.png)](https://i.loli.net/2018/10/08/5bbabcb79f237.png)\n###将下载的vpn拖进拓展页内\n[![](https://i.loli.net/2018/10/08/5bbabd7a7d288.png)](https://i.loli.net/2018/10/08/5bbabd7a7d288.png)\n###安装完后会出现下图两个东西\n[![](https://i.loli.net/2018/10/08/5bbabe2db9f2f.png)](https://i.loli.net/2018/10/08/5bbabe2db9f2f.png)\n###点击右上角小图标,选择汉语\n[![](https://i.loli.net/2018/10/08/5bbabed0e1e46.png)](https://i.loli.net/2018/10/08/5bbabed0e1e46.png)\n###注册账户\nhttps://i.loli.net/2018/10/08/5bbabed0e39a8.png\n###填写信息--密码会在点击注册后发送到你的邮箱里,注意查看\n[![](https://i.loli.net/2018/10/08/5bbabed0e5739.png)](https://i.loli.net/2018/10/08/5bbabed0e5739.png)\n###再次点击小图标,登录vpn,选择你需要的节点,这里我想看twitter,所以选择美国节点\n[![](https://i.loli.net/2018/10/08/5bbac01c573e2.png)](https://i.loli.net/2018/10/08/5bbac01c573e2.png)\n###等待连接vpn,完成后会有以下提示\n[![](https://i.loli.net/2018/10/08/5bbac08175458.png)](https://i.loli.net/2018/10/08/5bbac08175458.png)\n###成功后就可以愉快翻墙了...[![](https://i.loli.net/2018/10/08/5bbac08257fa6.png)](https://i.loli.net/2018/10/08/5bbac08257fa6.png)', 'Setup VPN 使用方法', '[{\"id\":20,\"name\":\"vpn\",\"create_time\":\"2018-10-08T09:54:52.000Z\",\"update_time\":\"2018-10-08T09:54:52.000Z\"}]', 1);
  INSERT INTO `article` VALUES (56, 1, '测试文章1', 49, '其它', '原创', 1, 'http://localhost:3000/upload/images/2018-10-15/1539585196828_img20160224123902.jpg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Explicabo doloribus dolore saepe perspiciatis inventore eius laudantium. Enim dicta tempora magnam assumenda minima aut, odit ut. Quaerat assumenda consectetur perspiciatis suscipit?', '2018-10-17 09:24:54', '2018-10-17 09:24:54', 1, 0, 0, 0, '<h3 id=\"h3-u4E3Bu8981u7279u6027\"><a name=\"主要特性\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>主要特性</h3><ul>\n<li>支持“标准”Markdown / CommonMark和Github风格的语法，也可变身为代码编辑器；</li><li>支持实时预览、图片（跨域）上传、预格式文本/代码/表格插入、代码折叠、搜索替换、只读模式、自定义样式主题和多语言语法高亮等功能；</li><li>支持ToC（Table of Contents）、Emoji表情、Task lists、@链接等Markdown扩展语法；</li><li>支持TeX科学公式（基于KaTeX）、流程图 Flowchart 和 时序图 Sequence Diagram;</li><li>支持识别和解析HTML标签，并且支持自定义过滤标签解析，具有可靠的安全性和几乎无限的扩展性；</li><li>支持 AMD / CMD 模块化加载（支持 Require.js &amp; Sea.js），并且支持自定义扩展插件；</li><li>兼容主流的浏览器（IE8+）和Zepto.js，且支持iPad等平板设备；</li><li>支持自定义主题样式；</li></ul>\n<h1 id=\"h1-editor-md\"><a name=\"Editor.md\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Editor.md</h1><p><img src=\"https://pandao.github.io/editor.md/images/logos/editormd-logo-180x180.png\" alt=\"\"></p>\n<p><img src=\"https://img.shields.io/github/stars/pandao/editor.md.svg\" alt=\"\"> <img src=\"https://img.shields.io/github/forks/pandao/editor.md.svg\" alt=\"\"> <img src=\"https://img.shields.io/github/tag/pandao/editor.md.svg\" alt=\"\"> <img src=\"https://img.shields.io/github/release/pandao/editor.md.svg\" alt=\"\"> <img src=\"https://img.shields.io/github/issues/pandao/editor.md.svg\" alt=\"\"> <img src=\"https://img.shields.io/bower/v/editor.md.svg\" alt=\"\"></p>\n<p><strong>目录 (Table of Contents)</strong></p>\n<div class=\"editormd-toc-menu\"><div class=\"markdown-toc editormd-markdown-toc\"><ul class=\"markdown-toc-list\"><li><h1>目录 <i class=\"fa fa-angle-down\"></i></h1></li><li><a class=\"toc-level-3\" href=\"#主要特性\" level=\"3\">主要特性</a></li><li><a class=\"toc-level-1\" href=\"#Editor.md\" level=\"1\">Editor.md</a></li><li><a class=\"toc-level-1\" href=\"#Heading 1\" level=\"1\">Heading 1</a><ul><li><a class=\"toc-level-2\" href=\"#Heading 2\" level=\"2\">Heading 2</a><ul><li><a class=\"toc-level-3\" href=\"#Heading 3\" level=\"3\">Heading 3</a><ul><li><a class=\"toc-level-4\" href=\"#Heading 4\" level=\"4\">Heading 4</a><ul><li><a class=\"toc-level-5\" href=\"#Heading 5\" level=\"5\">Heading 5</a><ul><li><a class=\"toc-level-6\" href=\"#Heading 6\" level=\"6\">Heading 6</a></li></ul></li></ul></li></ul></li></ul></li></ul></li><li><a class=\"toc-level-1\" href=\"#Heading 1 link   Heading link\" level=\"1\">Heading 1 link   Heading link</a><ul><li><a class=\"toc-level-2\" href=\"#Heading 2 link   Heading link\" level=\"2\">Heading 2 link   Heading link</a><ul><li><a class=\"toc-level-3\" href=\"#Heading 3 link   Heading link\" level=\"3\">Heading 3 link   Heading link</a><ul><li><a class=\"toc-level-4\" href=\"#Heading 4 link   Heading link  Heading link   Heading link\" level=\"4\">Heading 4 link   Heading link  Heading link   Heading link</a><ul><li><a class=\"toc-level-5\" href=\"#Heading 5 link   Heading link\" level=\"5\">Heading 5 link   Heading link</a><ul><li><a class=\"toc-level-6\" href=\"#Heading 6 link   Heading link\" level=\"6\">Heading 6 link   Heading link</a><ul></ul></li></ul></li></ul></li></ul></li></ul></li></ul></li></ul><a href=\"javascript:;\" class=\"toc-menu-btn\"><i class=\"fa fa-angle-down\"></i>目录</a></div></div><br><div class=\"markdown-toc editormd-markdown-toc\"><ul class=\"markdown-toc-list\"><li><a class=\"toc-level-3\" href=\"#主要特性\" level=\"3\">主要特性</a></li><li><a class=\"toc-level-1\" href=\"#Editor.md\" level=\"1\">Editor.md</a></li><li><a class=\"toc-level-1\" href=\"#Heading 1\" level=\"1\">Heading 1</a><ul><li><a class=\"toc-level-2\" href=\"#Heading 2\" level=\"2\">Heading 2</a><ul><li><a class=\"toc-level-3\" href=\"#Heading 3\" level=\"3\">Heading 3</a><ul><li><a class=\"toc-level-4\" href=\"#Heading 4\" level=\"4\">Heading 4</a><ul><li><a class=\"toc-level-5\" href=\"#Heading 5\" level=\"5\">Heading 5</a><ul><li><a class=\"toc-level-6\" href=\"#Heading 6\" level=\"6\">Heading 6</a></li></ul></li></ul></li></ul></li></ul></li></ul></li><li><a class=\"toc-level-1\" href=\"#Heading 1 link   Heading link\" level=\"1\">Heading 1 link   Heading link</a><ul><li><a class=\"toc-level-2\" href=\"#Heading 2 link   Heading link\" level=\"2\">Heading 2 link   Heading link</a><ul><li><a class=\"toc-level-3\" href=\"#Heading 3 link   Heading link\" level=\"3\">Heading 3 link   Heading link</a><ul><li><a class=\"toc-level-4\" href=\"#Heading 4 link   Heading link  Heading link   Heading link\" level=\"4\">Heading 4 link   Heading link  Heading link   Heading link</a><ul><li><a class=\"toc-level-5\" href=\"#Heading 5 link   Heading link\" level=\"5\">Heading 5 link   Heading link</a><ul><li><a class=\"toc-level-6\" href=\"#Heading 6 link   Heading link\" level=\"6\">Heading 6 link   Heading link</a><ul></ul></li></ul></li></ul></li></ul></li></ul></li></ul></li></ul></div><h1 id=\"h1-heading-1\"><a name=\"Heading 1\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 1</h1><h2 id=\"h2-heading-2\"><a name=\"Heading 2\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 2</h2><h3 id=\"h3-heading-3\"><a name=\"Heading 3\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 3</h3><h4 id=\"h4-heading-4\"><a name=\"Heading 4\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 4</h4><h5 id=\"h5-heading-5\"><a name=\"Heading 5\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 5</h5><h6 id=\"h6-heading-6\"><a name=\"Heading 6\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 6</h6><h1 id=\"h1-heading-1-link-heading-link\"><a name=\"Heading 1 link   Heading link\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 1 link <a href=\"https://github.com/pandao/editor.md\" title=\"Heading link\">Heading link</a></h1><h2 id=\"h2-heading-2-link-heading-link\"><a name=\"Heading 2 link   Heading link\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 2 link <a href=\"https://github.com/pandao/editor.md\" title=\"Heading link\">Heading link</a></h2><h3 id=\"h3-heading-3-link-heading-link\"><a name=\"Heading 3 link   Heading link\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 3 link <a href=\"https://github.com/pandao/editor.md\" title=\"Heading link\">Heading link</a></h3><h4 id=\"h4-heading-4-link-heading-link-heading-link-heading-link\"><a name=\"Heading 4 link   Heading link  Heading link   Heading link\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 4 link <a href=\"https://github.com/pandao/editor.md\" title=\"Heading link\">Heading link</a> Heading link <a href=\"https://github.com/pandao/editor.md\" title=\"Heading link\">Heading link</a></h4><h5 id=\"h5-heading-5-link-heading-link\"><a name=\"Heading 5 link   Heading link\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 5 link <a href=\"https://github.com/pandao/editor.md\" title=\"Heading link\">Heading link</a></h5><h6 id=\"h6-heading-6-link-heading-link\"><a name=\"Heading 6 link   Heading link\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Heading 6 link <a href=\"https://github.com/pandao/editor.md\" title=\"Heading link\">Heading link</a></h6>', '### 主要特性\n\n- 支持“标准”Markdown / CommonMark和Github风格的语法，也可变身为代码编辑器；\n- 支持实时预览、图片（跨域）上传、预格式文本/代码/表格插入、代码折叠、搜索替换、只读模式、自定义样式主题和多语言语法高亮等功能；\n- 支持ToC（Table of Contents）、Emoji表情、Task lists、@链接等Markdown扩展语法；\n- 支持TeX科学公式（基于KaTeX）、流程图 Flowchart 和 时序图 Sequence Diagram;\n- 支持识别和解析HTML标签，并且支持自定义过滤标签解析，具有可靠的安全性和几乎无限的扩展性；\n- 支持 AMD / CMD 模块化加载（支持 Require.js & Sea.js），并且支持自定义扩展插件；\n- 兼容主流的浏览器（IE8+）和Zepto.js，且支持iPad等平板设备；\n- 支持自定义主题样式；\n\n# Editor.md\n\n![](https://pandao.github.io/editor.md/images/logos/editormd-logo-180x180.png)\n\n![](https://img.shields.io/github/stars/pandao/editor.md.svg) ![](https://img.shields.io/github/forks/pandao/editor.md.svg) ![](https://img.shields.io/github/tag/pandao/editor.md.svg) ![](https://img.shields.io/github/release/pandao/editor.md.svg) ![](https://img.shields.io/github/issues/pandao/editor.md.svg) ![](https://img.shields.io/bower/v/editor.md.svg)\n\n**目录 (Table of Contents)**\n\n[TOCM]\n\n[TOC]\n\n# Heading 1\n## Heading 2\n### Heading 3\n#### Heading 4\n##### Heading 5\n###### Heading 6\n# Heading 1 link [Heading link](https://github.com/pandao/editor.md \"Heading link\")\n## Heading 2 link [Heading link](https://github.com/pandao/editor.md \"Heading link\")\n### Heading 3 link [Heading link](https://github.com/pandao/editor.md \"Heading link\")\n#### Heading 4 link [Heading link](https://github.com/pandao/editor.md \"Heading link\") Heading link [Heading link](https://github.com/pandao/editor.md \"Heading link\")\n##### Heading 5 link [Heading link](https://github.com/pandao/editor.md \"Heading link\")\n###### Heading 6 link [Heading link](https://github.com/pandao/editor.md \"Heading link\")\n', '测试文章1', '[{\"id\":18,\"name\":\"wtff\",\"create_time\":\"2018-09-21T07:49:33.000Z\",\"update_time\":\"2018-09-21T07:49:33.000Z\"}]', 0);
  INSERT INTO `article` VALUES (57, 1, '测试文章2', 49, '其它', '原创', 1, 'http://localhost:3000/upload/images/2018-10-15/1539585438754_img1444892892000.jpg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Explicabo doloribus dolore saepe perspiciatis inventore eius laudantium. Enim dicta tempora magnam assumenda minima aut, odit ut. Quaerat assumenda consectetur perspiciatis suscipit?', '2018-10-17 10:20:59', '2018-10-17 10:20:59', 1, 0, 0, 0, '<h4 id=\"h4--heading-underline-\"><a name=\"标题（用底线的形式）Heading (underline)\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>标题（用底线的形式）Heading (underline)</h4><h1 id=\"h1-this-is-an-h1\"><a name=\"This is an H1\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>This is an H1</h1><h2 id=\"h2-this-is-an-h2\"><a name=\"This is an H2\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>This is an H2</h2><h3 id=\"h3-u5B57u7B26u6548u679Cu548Cu6A2Au7EBFu7B49\"><a name=\"字符效果和横线等\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>字符效果和横线等</h3><hr>\n<p><del>删除线</del> &lt;s&gt;删除线（开启识别HTML标签时）&lt;/s&gt;<br><em>斜体字</em>      <em>斜体字</em><br><strong>粗体</strong>  <strong>粗体</strong><br><strong><em>粗斜体</em></strong> <strong><em>粗斜体</em></strong></p>\n<p>上标：X&lt;sub&gt;2&lt;/sub&gt;，下标：O&lt;sup&gt;2&lt;/sup&gt;</p>\n<p><strong>缩写(同HTML的abbr标签)</strong></p>\n<blockquote>\n<p>即更长的单词或短语的缩写形式，前提是开启识别HTML标签时，已默认开启</p>\n</blockquote>\n<p>The &lt;abbr title=\"Hyper Text Markup Language\"&gt;HTML&lt;/abbr&gt; specification is maintained by the &lt;abbr title=\"World Wide Web Consortium\"&gt;W3C&lt;/abbr&gt;.</p>\n<h3 id=\"h3--blockquotes\"><a name=\"引用 Blockquotes\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>引用 Blockquotes</h3><blockquote>\n<p>引用文本 Blockquotes</p>\n</blockquote>\n<p>引用的行内混合 Blockquotes</p>\n<blockquote>\n<p>引用：如果想要插入空白换行<code>即&lt;br /&gt;标签</code>，在插入处先键入两个以上的空格然后回车即可，<a href=\"http://localhost/\">普通链接</a>。</p>\n</blockquote>\n', '#### 标题（用底线的形式）Heading (underline)\n\nThis is an H1\n=============\n\nThis is an H2\n-------------\n\n### 字符效果和横线等\n                \n----\n\n~~删除线~~ <s>删除线（开启识别HTML标签时）</s>\n*斜体字*      _斜体字_\n**粗体**  __粗体__\n***粗斜体*** ___粗斜体___\n\n上标：X<sub>2</sub>，下标：O<sup>2</sup>\n\n**缩写(同HTML的abbr标签)**\n\n> 即更长的单词或短语的缩写形式，前提是开启识别HTML标签时，已默认开启\n\nThe <abbr title=\"Hyper Text Markup Language\">HTML</abbr> specification is maintained by the <abbr title=\"World Wide Web Consortium\">W3C</abbr>.\n\n### 引用 Blockquotes\n\n> 引用文本 Blockquotes\n\n引用的行内混合 Blockquotes\n                    \n> 引用：如果想要插入空白换行`即<br />标签`，在插入处先键入两个以上的空格然后回车即可，[普通链接](http://localhost/)。\n', '测试文章2', '[{\"id\":10,\"name\":\"潜潜潜\",\"create_time\":\"2018-09-20T08:41:11.000Z\",\"update_time\":\"2018-09-20T08:41:11.000Z\"}]', 1);
  INSERT INTO `article` VALUES (58, 1, '测试文章3', 7, '生活', '原创', 1, 'http://localhost:3000/upload/images/2018-10-15/1539585508330_img20171101165729.jpg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Explicabo doloribus dolore saepe perspiciatis inventore eius laudantium. Enim dicta tempora magnam assumenda minima aut, odit ut. Quaerat assumenda consectetur perspiciatis suscipit?', '2017-11-21 10:21:00', '2018-10-17 14:30:02', 1, 0, 0, 0, '<h3 id=\"h3--links\"><a name=\"锚点与链接 Links\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>锚点与链接 Links</h3><p><a href=\"http://localhost/\">普通链接</a></p>\n<p><a href=\"http://localhost/\" title=\"普通链接带标题\">普通链接带标题</a></p>\n<p>直接链接：<a href=\"https://github.com\">https://github.com</a></p>\n<p><a href=\"http://www.this-anchor-link.com/\">锚点链接</a> </p>\n<p>GFM a-tail link <a href=\"https://github.com/pandao\" title=\"@pandao\" class=\"at-link\">@pandao</a></p>\n<blockquote>\n<p><a href=\"https://github.com/pandao\" title=\"@pandao\" class=\"at-link\">@pandao</a></p>\n</blockquote>\n<h3 id=\"h3--codes\"><a name=\"多语言代码高亮 Codes\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>多语言代码高亮 Codes</h3><h4 id=\"h4--inline-code\"><a name=\"行内代码 Inline code\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>行内代码 Inline code</h4><p>执行命令：<code>npm install marked</code></p>\n<h4 id=\"h4-u7F29u8FDBu98CEu683C\"><a name=\"缩进风格\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>缩进风格</h4><p>即缩进四个空格，也做为实现类似<code>&lt;pre&gt;</code>预格式化文本(Preformatted Text)的功能。</p>\n<pre class=\"prettyprint linenums prettyprinted\" style=\"\"><ol class=\"linenums\"><li class=\"L0\"><code><span class=\"pun\">&lt;?</span><span class=\"pln\">php</span></code></li><li class=\"L1\"><code><span class=\"pln\">    echo </span><span class=\"str\">\"Hello world!\"</span><span class=\"pun\">;</span></code></li><li class=\"L2\"><code><span class=\"pun\">?&gt;</span></code></li></ol></pre><p>预格式化文本：</p>\n<pre class=\"prettyprint linenums prettyprinted\" style=\"\"><ol class=\"linenums\"><li class=\"L0\"><code><span class=\"pun\">|</span><span class=\"pln\"> </span><span class=\"typ\">First</span><span class=\"pln\"> </span><span class=\"typ\">Header</span><span class=\"pln\">  </span><span class=\"pun\">|</span><span class=\"pln\"> </span><span class=\"typ\">Second</span><span class=\"pln\"> </span><span class=\"typ\">Header</span><span class=\"pln\"> </span><span class=\"pun\">|</span></code></li><li class=\"L1\"><code><span class=\"pun\">|</span><span class=\"pln\"> </span><span class=\"pun\">-------------</span><span class=\"pln\"> </span><span class=\"pun\">|</span><span class=\"pln\"> </span><span class=\"pun\">-------------</span><span class=\"pln\"> </span><span class=\"pun\">|</span></code></li><li class=\"L2\"><code><span class=\"pun\">|</span><span class=\"pln\"> </span><span class=\"typ\">Content</span><span class=\"pln\"> </span><span class=\"typ\">Cell</span><span class=\"pln\">  </span><span class=\"pun\">|</span><span class=\"pln\"> </span><span class=\"typ\">Content</span><span class=\"pln\"> </span><span class=\"typ\">Cell</span><span class=\"pln\">  </span><span class=\"pun\">|</span></code></li><li class=\"L3\"><code><span class=\"pun\">|</span><span class=\"pln\"> </span><span class=\"typ\">Content</span><span class=\"pln\"> </span><span class=\"typ\">Cell</span><span class=\"pln\">  </span><span class=\"pun\">|</span><span class=\"pln\"> </span><span class=\"typ\">Content</span><span class=\"pln\"> </span><span class=\"typ\">Cell</span><span class=\"pln\">  </span><span class=\"pun\">|</span></code></li></ol></pre>', '### 锚点与链接 Links\n\n[普通链接](http://localhost/)\n\n[普通链接带标题](http://localhost/ \"普通链接带标题\")\n\n直接链接：<https://github.com>\n\n[锚点链接][anchor-id] \n\n[anchor-id]: http://www.this-anchor-link.com/\n\nGFM a-tail link @pandao\n\n> @pandao\n\n### 多语言代码高亮 Codes\n\n#### 行内代码 Inline code\n\n执行命令：`npm install marked`\n\n#### 缩进风格\n\n即缩进四个空格，也做为实现类似`<pre>`预格式化文本(Preformatted Text)的功能。\n\n    <?php\n        echo \"Hello world!\";\n    ?>\n    \n预格式化文本：\n\n    | First Header  | Second Header |\n    | ------------- | ------------- |\n    | Content Cell  | Content Cell  |\n    | Content Cell  | Content Cell  |', '测试文章3', '[{\"id\":2,\"name\":\"vue\",\"create_time\":\"2018-09-20T11:54:53.000Z\",\"update_time\":\"2018-09-20T11:54:52.000Z\"}]', 1);
  INSERT INTO `article` VALUES (59, 1, '测试文章4', 7, '生活', '原创', 1, 'http://localhost:3000/upload/images/2018-10-15/1539585539929_img20171101165729.jpg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Explicabo doloribus dolore saepe perspiciatis inventore eius laudantium. Enim dicta tempora magnam assumenda minima aut, odit ut. Quaerat assumenda consectetur perspiciatis suscipit?', '2018-10-17 09:25:28', '2018-10-17 09:25:28', 1, 0, 0, 0, '<h1 id=\"h1-js\"><a name=\"js\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>js</h1><h4 id=\"h4-js-\"><a name=\"JS代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>JS代码　</h4><pre class=\"prettyprint linenums prettyprinted\" data-rel=\"JAVASCRIPT\" style=\"\"><ol class=\"linenums\"><li class=\"L0\"><code class=\"lang-javascript\"><span class=\"kwd\">function</span><span class=\"pln\"> test</span><span class=\"pun\">(){</span></code></li><li class=\"L1\"><code class=\"lang-javascript\"><span class=\"pln\">    console</span><span class=\"pun\">.</span><span class=\"pln\">log</span><span class=\"pun\">(</span><span class=\"str\">\"Hello world!\"</span><span class=\"pun\">);</span></code></li><li class=\"L2\"><code class=\"lang-javascript\"><span class=\"pun\">}</span></code></li><li class=\"L3\"><code class=\"lang-javascript\"></code></li><li class=\"L4\"><code class=\"lang-javascript\"><span class=\"pun\">(</span><span class=\"kwd\">function</span><span class=\"pun\">(){</span></code></li><li class=\"L5\"><code class=\"lang-javascript\"><span class=\"pln\">    </span><span class=\"kwd\">var</span><span class=\"pln\"> box </span><span class=\"pun\">=</span><span class=\"pln\"> </span><span class=\"kwd\">function</span><span class=\"pun\">(){</span></code></li><li class=\"L6\"><code class=\"lang-javascript\"><span class=\"pln\">        </span><span class=\"kwd\">return</span><span class=\"pln\"> box</span><span class=\"pun\">.</span><span class=\"pln\">fn</span><span class=\"pun\">.</span><span class=\"pln\">init</span><span class=\"pun\">();</span></code></li><li class=\"L7\"><code class=\"lang-javascript\"><span class=\"pln\">    </span><span class=\"pun\">};</span></code></li><li class=\"L8\"><code class=\"lang-javascript\"></code></li><li class=\"L9\"><code class=\"lang-javascript\"><span class=\"pln\">    box</span><span class=\"pun\">.</span><span class=\"pln\">prototype </span><span class=\"pun\">=</span><span class=\"pln\"> box</span><span class=\"pun\">.</span><span class=\"pln\">fn </span><span class=\"pun\">=</span><span class=\"pln\"> </span><span class=\"pun\">{</span></code></li><li class=\"L0\"><code class=\"lang-javascript\"><span class=\"pln\">        init </span><span class=\"pun\">:</span><span class=\"pln\"> </span><span class=\"kwd\">function</span><span class=\"pun\">(){</span></code></li><li class=\"L1\"><code class=\"lang-javascript\"><span class=\"pln\">            console</span><span class=\"pun\">.</span><span class=\"pln\">log</span><span class=\"pun\">(</span><span class=\"str\">\'box.init()\'</span><span class=\"pun\">);</span></code></li><li class=\"L2\"><code class=\"lang-javascript\"></code></li><li class=\"L3\"><code class=\"lang-javascript\"><span class=\"pln\">            </span><span class=\"kwd\">return</span><span class=\"pln\"> </span><span class=\"kwd\">this</span><span class=\"pun\">;</span></code></li><li class=\"L4\"><code class=\"lang-javascript\"><span class=\"pln\">        </span><span class=\"pun\">},</span></code></li><li class=\"L5\"><code class=\"lang-javascript\"></code></li><li class=\"L6\"><code class=\"lang-javascript\"><span class=\"pln\">        add </span><span class=\"pun\">:</span><span class=\"pln\"> </span><span class=\"kwd\">function</span><span class=\"pun\">(</span><span class=\"pln\">str</span><span class=\"pun\">){</span></code></li><li class=\"L7\"><code class=\"lang-javascript\"><span class=\"pln\">            alert</span><span class=\"pun\">(</span><span class=\"str\">\"add\"</span><span class=\"pun\">,</span><span class=\"pln\"> str</span><span class=\"pun\">);</span></code></li><li class=\"L8\"><code class=\"lang-javascript\"></code></li><li class=\"L9\"><code class=\"lang-javascript\"><span class=\"pln\">            </span><span class=\"kwd\">return</span><span class=\"pln\"> </span><span class=\"kwd\">this</span><span class=\"pun\">;</span></code></li><li class=\"L0\"><code class=\"lang-javascript\"><span class=\"pln\">        </span><span class=\"pun\">},</span></code></li><li class=\"L1\"><code class=\"lang-javascript\"></code></li><li class=\"L2\"><code class=\"lang-javascript\"><span class=\"pln\">        remove </span><span class=\"pun\">:</span><span class=\"pln\"> </span><span class=\"kwd\">function</span><span class=\"pun\">(</span><span class=\"pln\">str</span><span class=\"pun\">){</span></code></li><li class=\"L3\"><code class=\"lang-javascript\"><span class=\"pln\">            alert</span><span class=\"pun\">(</span><span class=\"str\">\"remove\"</span><span class=\"pun\">,</span><span class=\"pln\"> str</span><span class=\"pun\">);</span></code></li><li class=\"L4\"><code class=\"lang-javascript\"></code></li><li class=\"L5\"><code class=\"lang-javascript\"><span class=\"pln\">            </span><span class=\"kwd\">return</span><span class=\"pln\"> </span><span class=\"kwd\">this</span><span class=\"pun\">;</span></code></li><li class=\"L6\"><code class=\"lang-javascript\"><span class=\"pln\">        </span><span class=\"pun\">}</span></code></li><li class=\"L7\"><code class=\"lang-javascript\"><span class=\"pln\">    </span><span class=\"pun\">};</span></code></li><li class=\"L8\"><code class=\"lang-javascript\"></code></li><li class=\"L9\"><code class=\"lang-javascript\"><span class=\"pln\">    box</span><span class=\"pun\">.</span><span class=\"pln\">fn</span><span class=\"pun\">.</span><span class=\"pln\">init</span><span class=\"pun\">.</span><span class=\"pln\">prototype </span><span class=\"pun\">=</span><span class=\"pln\"> box</span><span class=\"pun\">.</span><span class=\"pln\">fn</span><span class=\"pun\">;</span></code></li><li class=\"L0\"><code class=\"lang-javascript\"></code></li><li class=\"L1\"><code class=\"lang-javascript\"><span class=\"pln\">    window</span><span class=\"pun\">.</span><span class=\"pln\">box </span><span class=\"pun\">=</span><span class=\"pln\">box</span><span class=\"pun\">;</span></code></li><li class=\"L2\"><code class=\"lang-javascript\"><span class=\"pun\">})();</span></code></li><li class=\"L3\"><code class=\"lang-javascript\"></code></li><li class=\"L4\"><code class=\"lang-javascript\"><span class=\"kwd\">var</span><span class=\"pln\"> testBox </span><span class=\"pun\">=</span><span class=\"pln\"> box</span><span class=\"pun\">();</span></code></li><li class=\"L5\"><code class=\"lang-javascript\"><span class=\"pln\">testBox</span><span class=\"pun\">.</span><span class=\"pln\">add</span><span class=\"pun\">(</span><span class=\"str\">\"jQuery\"</span><span class=\"pun\">).</span><span class=\"pln\">remove</span><span class=\"pun\">(</span><span class=\"str\">\"jQuery\"</span><span class=\"pun\">);</span></code></li></ol></pre>\n<h3 id=\"h3-u6D4Bu8BD5\"><a name=\"测试\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>测试</h3><p>悄悄这代码多可爱啊……</p>\n', '#js\n#### JS代码　\n\n```javascript\nfunction test(){\n	console.log(\"Hello world!\");\n}\n \n(function(){\n    var box = function(){\n        return box.fn.init();\n    };\n\n    box.prototype = box.fn = {\n        init : function(){\n            console.log(\'box.init()\');\n\n			return this;\n        },\n\n		add : function(str){\n			alert(\"add\", str);\n\n			return this;\n		},\n\n		remove : function(str){\n			alert(\"remove\", str);\n\n			return this;\n		}\n    };\n    \n    box.fn.init.prototype = box.fn;\n    \n    window.box =box;\n})();\n\nvar testBox = box();\ntestBox.add(\"jQuery\").remove(\"jQuery\");\n```\n###测试\n悄悄这代码多可爱啊......', '测试文章4', '[{\"id\":17,\"name\":\"欣欣欣\",\"create_time\":\"2018-09-21T03:12:35.000Z\",\"update_time\":\"2018-09-21T03:12:35.000Z\"}]', 0);
  INSERT INTO `article` VALUES (60, 1, 'html', 9, 'html', '原创', 1, 'http://localhost:3000/upload/images/2018-10-15/1539585656578_img20171231152208.png', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Explicabo doloribus dolore saepe perspiciatis inventore eius laudantium. Enim dicta tempora magnam assumenda minima aut, odit ut. Quaerat assumenda consectetur perspiciatis suscipit?', '2017-11-15 10:21:01', '2018-10-17 14:30:11', 1, 0, 0, 0, '<h1 id=\"h1-html-\"><a name=\"html结构\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>html结构</h1><h4 id=\"h4-html-html-codes\"><a name=\"HTML代码 HTML codes\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>HTML代码 HTML codes</h4><pre class=\"prettyprint linenums prettyprinted\" data-rel=\"HTML\" style=\"\"><ol class=\"linenums\"><li class=\"L0\"><code class=\"lang-html\"><span class=\"dec\">&lt;!DOCTYPE html&gt;</span></code></li><li class=\"L1\"><code class=\"lang-html\"><span class=\"tag\">&lt;html&gt;</span></code></li><li class=\"L2\"><code class=\"lang-html\"><span class=\"pln\">    </span><span class=\"tag\">&lt;head&gt;</span></code></li><li class=\"L3\"><code class=\"lang-html\"><span class=\"pln\">        </span><span class=\"tag\">&lt;mate</span><span class=\"pln\"> </span><span class=\"atn\">charest</span><span class=\"pun\">=</span><span class=\"atv\">\"utf-8\"</span><span class=\"pln\"> </span><span class=\"tag\">/&gt;</span></code></li><li class=\"L4\"><code class=\"lang-html\"><span class=\"pln\">        </span><span class=\"tag\">&lt;title&gt;</span><span class=\"pln\">Hello world!</span><span class=\"tag\">&lt;/title&gt;</span></code></li><li class=\"L5\"><code class=\"lang-html\"><span class=\"pln\">    </span><span class=\"tag\">&lt;/head&gt;</span></code></li><li class=\"L6\"><code class=\"lang-html\"><span class=\"pln\">    </span><span class=\"tag\">&lt;body&gt;</span></code></li><li class=\"L7\"><code class=\"lang-html\"><span class=\"pln\">        </span><span class=\"tag\">&lt;h1&gt;</span><span class=\"pln\">Hello world!</span><span class=\"tag\">&lt;/h1&gt;</span></code></li><li class=\"L8\"><code class=\"lang-html\"><span class=\"pln\">    </span><span class=\"tag\">&lt;/body&gt;</span></code></li><li class=\"L9\"><code class=\"lang-html\"><span class=\"tag\">&lt;/html&gt;</span></code></li></ol></pre>\n', '#html结构\n#### HTML代码 HTML codes\n\n```html\n<!DOCTYPE html>\n<html>\n    <head>\n        <mate charest=\"utf-8\" />\n        <title>Hello world!</title>\n    </head>\n    <body>\n        <h1>Hello world!</h1>\n    </body>\n</html>\n```', 'html', '[{\"id\":5,\"name\":\"html\",\"create_time\":\"2018-09-20T11:54:59.000Z\",\"update_time\":\"2018-09-20T11:54:58.000Z\"}]', 1);
  INSERT INTO `article` VALUES (61, 1, '测试文章6', 8, 'css', '原创', 1, 'http://localhost:3000/upload/images/2018-10-15/1539585744046_img1444889877000.jpg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Explicabo doloribus dolore saepe perspiciatis inventore eius laudantium. Enim dicta tempora magnam assumenda minima aut, odit ut. Quaerat assumenda consectetur perspiciatis suscipit?', '2018-10-17 09:25:33', '2018-10-17 09:25:33', 1, 0, 0, 0, '<h3 id=\"h3--images\"><a name=\"图片 Images\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>图片 Images</h3><p>Image:</p>\n<p><img src=\"https://pandao.github.io/editor.md/examples/images/4.jpg\" alt=\"\"></p>\n<blockquote>\n<p>Follow your heart.</p>\n</blockquote>\n<p><img src=\"https://pandao.github.io/editor.md/examples/images/8.jpg\" alt=\"\"></p>\n<blockquote>\n<p>图为：厦门白城沙滩</p>\n</blockquote>\n<p>图片加链接 (Image + Link)：</p>\n<p><a href=\"https://pandao.github.io/editor.md/examples/images/7.jpg\" title=\"李健首张专辑《似水流年》封面\"><img src=\"https://pandao.github.io/editor.md/examples/images/7.jpg\" alt=\"\"></a></p>\n<blockquote>\n<p>图为：李健首张专辑《似水流年》封面</p>\n</blockquote>\n<hr>\n', '### 图片 Images\n\nImage:\n\n![](https://pandao.github.io/editor.md/examples/images/4.jpg)\n\n> Follow your heart.\n\n![](https://pandao.github.io/editor.md/examples/images/8.jpg)\n\n> 图为：厦门白城沙滩\n\n图片加链接 (Image + Link)：\n\n[![](https://pandao.github.io/editor.md/examples/images/7.jpg)](https://pandao.github.io/editor.md/examples/images/7.jpg \"李健首张专辑《似水流年》封面\")\n\n> 图为：李健首张专辑《似水流年》封面\n                \n----\n', '测试文章6', '[{\"id\":4,\"name\":\"css\",\"create_time\":\"2018-09-20T11:54:57.000Z\",\"update_time\":\"2018-09-20T11:54:56.000Z\"}]', 0);
  INSERT INTO `article` VALUES (62, 1, '测试文章7', 8, 'css', '原创', 1, 'http://localhost:3000/upload/images/2018-10-15/1539585805628_img20171231152208.png', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Explicabo doloribus dolore saepe perspiciatis inventore eius laudantium. Enim dicta tempora magnam assumenda minima aut, odit ut. Quaerat assumenda consectetur perspiciatis suscipit?', '2018-10-17 10:21:03', '2018-10-17 10:21:03', 1, 0, 0, 0, '<h3 id=\"h3--lists\"><a name=\"列表 Lists\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>列表 Lists</h3><h4 id=\"h4--unordered-lists-\"><a name=\"无序列表（减号）Unordered Lists (-)\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>无序列表（减号）Unordered Lists (-)</h4><ul>\n<li>列表一</li><li>列表二</li><li>列表三</li></ul>\n<h4 id=\"h4--unordered-lists-\"><a name=\"无序列表（星号）Unordered Lists (*)\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>无序列表（星号）Unordered Lists (*)</h4><ul>\n<li>列表一</li><li>列表二</li><li>列表三</li></ul>\n<h4 id=\"h4--unordered-lists-\"><a name=\"无序列表（加号和嵌套）Unordered Lists (+)\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>无序列表（加号和嵌套）Unordered Lists (+)</h4><ul>\n<li>列表一</li><li>列表二<ul>\n<li>列表二-1</li><li>列表二-2</li><li>列表二-3</li></ul>\n</li><li>列表三<ul>\n<li>列表一</li><li>列表二</li><li>列表三</li></ul>\n</li></ul>\n<h4 id=\"h4--ordered-lists-\"><a name=\"有序列表 Ordered Lists (-)\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>有序列表 Ordered Lists (-)</h4><ol>\n<li>第一行</li><li>第二行</li><li>第三行</li></ol>\n<h4 id=\"h4-gfm-task-list\"><a name=\"GFM task list\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>GFM task list</h4><ul>\n<li style=\"list-style: none;\"><input type=\"checkbox\" class=\"task-list-item-checkbox\" checked=\"\" disabled=\"\"> GFM task list 1</li><li style=\"list-style: none;\"><input type=\"checkbox\" class=\"task-list-item-checkbox\" checked=\"\" disabled=\"\"> GFM task list 2</li><li style=\"list-style: none;\"><input type=\"checkbox\" class=\"task-list-item-checkbox\"> GFM task list 3<ul>\n<li style=\"list-style: none;\"><input type=\"checkbox\" class=\"task-list-item-checkbox\"> GFM task list 3-1</li><li style=\"list-style: none;\"><input type=\"checkbox\" class=\"task-list-item-checkbox\"> GFM task list 3-2</li><li style=\"list-style: none;\"><input type=\"checkbox\" class=\"task-list-item-checkbox\"> GFM task list 3-3</li></ul>\n</li><li style=\"list-style: none;\"><input type=\"checkbox\" class=\"task-list-item-checkbox\"> GFM task list 4<ul>\n<li style=\"list-style: none;\"><input type=\"checkbox\" class=\"task-list-item-checkbox\"> GFM task list 4-1</li><li style=\"list-style: none;\"><input type=\"checkbox\" class=\"task-list-item-checkbox\"> GFM task list 4-2</li></ul>\n</li></ul>\n<hr>\n', '### 列表 Lists\n\n#### 无序列表（减号）Unordered Lists (-)\n                \n- 列表一\n- 列表二\n- 列表三\n     \n#### 无序列表（星号）Unordered Lists (*)\n\n* 列表一\n* 列表二\n* 列表三\n\n#### 无序列表（加号和嵌套）Unordered Lists (+)\n                \n+ 列表一\n+ 列表二\n    + 列表二-1\n    + 列表二-2\n    + 列表二-3\n+ 列表三\n    * 列表一\n    * 列表二\n    * 列表三\n\n#### 有序列表 Ordered Lists (-)\n                \n1. 第一行\n2. 第二行\n3. 第三行\n\n#### GFM task list\n\n- [x] GFM task list 1\n- [x] GFM task list 2\n- [ ] GFM task list 3\n    - [ ] GFM task list 3-1\n    - [ ] GFM task list 3-2\n    - [ ] GFM task list 3-3\n- [ ] GFM task list 4\n    - [ ] GFM task list 4-1\n    - [ ] GFM task list 4-2\n                \n----\n                    ', '测试文章7', '[{\"id\":4,\"name\":\"css\",\"create_time\":\"2018-09-20T11:54:57.000Z\",\"update_time\":\"2018-09-20T11:54:56.000Z\"}]', 1);
  INSERT INTO `article` VALUES (63, 1, '测试文章8', 8, 'css', '原创', 1, 'http://localhost:3000/upload/images/2018-10-15/1539585871939_img20160224123902.jpg', '测试文章8-------------------------表格绘制,测试文章8-------------------------表格绘制测试文章8-------------------------表格绘制测试文章8-------------------------表格绘制测试文章8表格绘制', '2019-02-13 09:24:09', '2018-10-17 14:31:10', 1, 0, 0, 0, '<h3 id=\"h3--tables\"><a name=\"绘制表格 Tables\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>绘制表格 Tables</h3><table>\n<thead>\n<tr>\n<th>项目</th>\n<th style=\"text-align:right\">价格</th>\n<th style=\"text-align:center\">数量</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>计算机</td>\n<td style=\"text-align:right\">$1600</td>\n<td style=\"text-align:center\">5</td>\n</tr>\n<tr>\n<td>手机</td>\n<td style=\"text-align:right\">$12</td>\n<td style=\"text-align:center\">12</td>\n</tr>\n<tr>\n<td>管线</td>\n<td style=\"text-align:right\">$1</td>\n<td style=\"text-align:center\">234</td>\n</tr>\n</tbody>\n</table>\n<table>\n<thead>\n<tr>\n<th>First Header</th>\n<th>Second Header</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>Content Cell</td>\n<td>Content Cell</td>\n</tr>\n<tr>\n<td>Content Cell</td>\n<td>Content Cell </td>\n</tr>\n</tbody>\n</table>\n<table>\n<thead>\n<tr>\n<th>First Header</th>\n<th>Second Header</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>Content Cell</td>\n<td>Content Cell</td>\n</tr>\n<tr>\n<td>Content Cell</td>\n<td>Content Cell</td>\n</tr>\n</tbody>\n</table>\n<table>\n<thead>\n<tr>\n<th>Function name</th>\n<th>Description</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td><code>help()</code></td>\n<td>Display the help window.</td>\n</tr>\n<tr>\n<td><code>destroy()</code></td>\n<td><strong>Destroy your computer!</strong></td>\n</tr>\n</tbody>\n</table>\n<table>\n<thead>\n<tr>\n<th style=\"text-align:left\">Left-Aligned</th>\n<th style=\"text-align:center\">Center Aligned</th>\n<th style=\"text-align:right\">Right Aligned</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td style=\"text-align:left\">col 3 is</td>\n<td style=\"text-align:center\">some wordy text</td>\n<td style=\"text-align:right\">$1600</td>\n</tr>\n<tr>\n<td style=\"text-align:left\">col 2 is</td>\n<td style=\"text-align:center\">centered</td>\n<td style=\"text-align:right\">$12</td>\n</tr>\n<tr>\n<td style=\"text-align:left\">zebra stripes</td>\n<td style=\"text-align:center\">are neat</td>\n<td style=\"text-align:right\">$1</td>\n</tr>\n</tbody>\n</table>\n<table>\n<thead>\n<tr>\n<th>Item</th>\n<th style=\"text-align:right\">Value</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>Computer</td>\n<td style=\"text-align:right\">$1600</td>\n</tr>\n<tr>\n<td>Phone</td>\n<td style=\"text-align:right\">$12</td>\n</tr>\n<tr>\n<td>Pipe</td>\n<td style=\"text-align:right\">$1</td>\n</tr>\n</tbody>\n</table>\n<hr>\n', '### 绘制表格 Tables\n\n| 项目        | 价格   |  数量  |\n| --------   | -----:  | :----:  |\n| 计算机      | $1600   |   5     |\n| 手机        |   $12   |   12   |\n| 管线        |    $1    |  234  |\n                    \nFirst Header  | Second Header\n------------- | -------------\nContent Cell  | Content Cell\nContent Cell  | Content Cell \n\n| First Header  | Second Header |\n| ------------- | ------------- |\n| Content Cell  | Content Cell  |\n| Content Cell  | Content Cell  |\n\n| Function name | Description                    |\n| ------------- | ------------------------------ |\n| `help()`      | Display the help window.       |\n| `destroy()`   | **Destroy your computer!**     |\n\n| Left-Aligned  | Center Aligned  | Right Aligned |\n| :------------ |:---------------:| -----:|\n| col 3 is      | some wordy text | $1600 |\n| col 2 is      | centered        |   $12 |\n| zebra stripes | are neat        |    $1 |\n\n| Item      | Value |\n| --------- | -----:|\n| Computer  | $1600 |\n| Phone     |   $12 |\n| Pipe      |    $1 |\n                \n----', '测试文章8', '[{\"id\":4,\"name\":\"css\",\"create_time\":\"2018-09-20T11:54:57.000Z\",\"update_time\":\"2018-09-20T11:54:56.000Z\"}]', 0);
  INSERT INTO `article` VALUES (64, 1, '测试文章9', 49, '其它', '原创', 1, 'http://localhost:3000/upload/images/2018-10-15/1539585919301_img1444892892000.jpg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Explicabo doloribus dolore saepe perspiciatis inventore eius laudantium. Enim dicta tempora magnam assumenda minima aut, odit ut. Quaerat assumenda consectetur perspiciatis suscipit?', '2018-10-17 10:21:03', '2018-10-17 10:21:03', 1, 0, 0, 0, '<h3 id=\"h3--tex-katex-\"><a name=\"科学公式 TeX(KaTeX)\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>科学公式 TeX(KaTeX)</h3><p class=\"editormd-tex\"><span class=\"katex\" style=\"font-size: 1.6em;\"><span class=\"katex-mathml\"><math><semantics><mrow><mi>E</mi><mo>=</mo><mi>m</mi><msup><mi>c</mi><mn>2</mn></msup></mrow><annotation encoding=\"application/x-tex\">E=mc^2</annotation></semantics></math></span><span class=\"katex-html\" aria-hidden=\"true\"><span class=\"strut\" style=\"height: 0.814108em;\"></span><span class=\"strut bottom\" style=\"height: 0.814108em; vertical-align: 0em;\"></span><span class=\"base textstyle uncramped\"><span class=\"mord mathit\" style=\"margin-right: 0.05764em;\">E</span><span class=\"mrel\">=</span><span class=\"mord mathit\">m</span><span class=\"mord\"><span class=\"mord mathit\">c</span><span class=\"vlist\"><span class=\"\" style=\"top: -0.363em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord\">2</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span></span></span></span></p>\n<p>行内的公式<span class=\"editormd-tex\"><span class=\"katex\" style=\"font-size: 1.6em;\"><span class=\"katex-mathml\"><math><semantics><mrow><mi>E</mi><mo>=</mo><mi>m</mi><msup><mi>c</mi><mn>2</mn></msup></mrow><annotation encoding=\"application/x-tex\">E=mc^2</annotation></semantics></math></span><span class=\"katex-html\" aria-hidden=\"true\"><span class=\"strut\" style=\"height: 0.814108em;\"></span><span class=\"strut bottom\" style=\"height: 0.814108em; vertical-align: 0em;\"></span><span class=\"base textstyle uncramped\"><span class=\"mord mathit\" style=\"margin-right: 0.05764em;\">E</span><span class=\"mrel\">=</span><span class=\"mord mathit\">m</span><span class=\"mord\"><span class=\"mord mathit\">c</span><span class=\"vlist\"><span class=\"\" style=\"top: -0.363em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord\">2</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span></span></span></span></span>行内的公式，行内的<span class=\"editormd-tex\"><span class=\"katex\" style=\"font-size: 1.6em;\"><span class=\"katex-mathml\"><math><semantics><mrow><mi>E</mi><mo>=</mo><mi>m</mi><msup><mi>c</mi><mn>2</mn></msup></mrow><annotation encoding=\"application/x-tex\">E=mc^2</annotation></semantics></math></span><span class=\"katex-html\" aria-hidden=\"true\"><span class=\"strut\" style=\"height: 0.814108em;\"></span><span class=\"strut bottom\" style=\"height: 0.814108em; vertical-align: 0em;\"></span><span class=\"base textstyle uncramped\"><span class=\"mord mathit\" style=\"margin-right: 0.05764em;\">E</span><span class=\"mrel\">=</span><span class=\"mord mathit\">m</span><span class=\"mord\"><span class=\"mord mathit\">c</span><span class=\"vlist\"><span class=\"\" style=\"top: -0.363em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord\">2</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span></span></span></span></span>公式。</p>\n<p class=\"editormd-tex\"><span class=\"katex\" style=\"font-size: 1.6em;\"><span class=\"katex-mathml\"><math><semantics><mrow><mo>(</mo><msqrt><mrow><mn>3</mn><mi>x</mi><mo>−</mo><mn>1</mn></mrow></msqrt><mo>+</mo><mo>(</mo><mn>1</mn><mo>+</mo><mi>x</mi><msup><mo>)</mo><mn>2</mn></msup><mo>)</mo></mrow><annotation encoding=\"application/x-tex\">(\\sqrt{3x-1}+(1+x)^2)</annotation></semantics></math></span><span class=\"katex-html\" aria-hidden=\"true\"><span class=\"strut\" style=\"height: 0.865555em;\"></span><span class=\"strut bottom\" style=\"height: 1.11556em; vertical-align: -0.25em;\"></span><span class=\"base textstyle uncramped\"><span class=\"mopen\">(</span><span class=\"sqrt mord\"><span class=\"sqrt-sign\" style=\"top: -0.025555em;\"><span class=\"style-wrap reset-textstyle textstyle uncramped\">√</span></span><span class=\"vlist\"><span class=\"\" style=\"top: 0em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 1em;\">​</span></span><span class=\"mord textstyle cramped\"><span class=\"mord\">3</span><span class=\"mord mathit\">x</span><span class=\"mbin\">−</span><span class=\"mord\">1</span></span></span><span class=\"\" style=\"top: -0.785555em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 1em;\">​</span></span><span class=\"reset-textstyle textstyle uncramped sqrt-line\"></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 1em;\">​</span></span>​</span></span></span><span class=\"mbin\">+</span><span class=\"mopen\">(</span><span class=\"mord\">1</span><span class=\"mbin\">+</span><span class=\"mord mathit\">x</span><span class=\"mclose\"><span class=\"mclose\">)</span><span class=\"vlist\"><span class=\"\" style=\"top: -0.363em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord\">2</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"mclose\">)</span></span></span></span></p>\n<p class=\"editormd-tex\"><span class=\"katex\" style=\"font-size: 1.6em;\"><span class=\"katex-mathml\"><math><semantics><mrow><mi>sin</mi><mo>(</mo><mi>α</mi><msup><mo>)</mo><mrow><mi>θ</mi></mrow></msup><mo>=</mo><msubsup><mo>∑</mo><mrow><mi>i</mi><mo>=</mo><mn>0</mn></mrow><mrow><mi>n</mi></mrow></msubsup><mo>(</mo><msup><mi>x</mi><mi>i</mi></msup><mo>+</mo><mi>cos</mi><mo>(</mo><mi>f</mi><mo>)</mo><mo>)</mo></mrow><annotation encoding=\"application/x-tex\">\\sin(\\alpha)^{\\theta}=\\sum_{i=0}^{n}(x^i + \\cos(f))</annotation></semantics></math></span><span class=\"katex-html\" aria-hidden=\"true\"><span class=\"strut\" style=\"height: 0.849108em;\"></span><span class=\"strut bottom\" style=\"height: 1.14912em; vertical-align: -0.30001em;\"></span><span class=\"base textstyle uncramped\"><span class=\"mop\">sin</span><span class=\"mopen\">(</span><span class=\"mord mathit\" style=\"margin-right: 0.0037em;\">α</span><span class=\"mclose\"><span class=\"mclose\">)</span><span class=\"vlist\"><span class=\"\" style=\"top: -0.363em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord scriptstyle uncramped\"><span class=\"mord mathit\" style=\"margin-right: 0.02778em;\">θ</span></span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"mrel\">=</span><span class=\"mop\"><span class=\"op-symbol small-op mop\" style=\"top: -5e-06em;\">∑</span><span class=\"vlist\"><span class=\"\" style=\"top: 0.30001em; margin-left: 0em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle cramped\"><span class=\"mord scriptstyle cramped\"><span class=\"mord mathit\">i</span><span class=\"mrel\">=</span><span class=\"mord\">0</span></span></span></span><span class=\"\" style=\"top: -0.364em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord scriptstyle uncramped\"><span class=\"mord mathit\">n</span></span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"mopen\">(</span><span class=\"mord\"><span class=\"mord mathit\">x</span><span class=\"vlist\"><span class=\"\" style=\"top: -0.363em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord mathit\">i</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"mbin\">+</span><span class=\"mop\">cos</span><span class=\"mopen\">(</span><span class=\"mord mathit\" style=\"margin-right: 0.10764em;\">f</span><span class=\"mclose\">)</span><span class=\"mclose\">)</span></span></span></span></p>\n<p>多行公式：</p>\n<p class=\"editormd-tex\"><span class=\"katex\" style=\"font-size: 1.6em;\"><span class=\"katex-mathml\"><math><semantics><mrow><mstyle scriptlevel=\"0\" displaystyle=\"true\"><msup><mrow><mo fence=\"true\">(</mo><mo>∑</mo><mi mathvariant=\"normal\">_</mi><msup><mrow><mi>k</mi><mo>=</mo><mn>1</mn></mrow><mi>n</mi></msup><mi>a</mi><mi mathvariant=\"normal\">_</mi><mi>k</mi><mi>b</mi><mi mathvariant=\"normal\">_</mi><mi>k</mi><mo fence=\"true\">)</mo></mrow><mn>2</mn></msup><mo>≤</mo><mrow><mo fence=\"true\">(</mo><mo>∑</mo><mi mathvariant=\"normal\">_</mi><msup><mrow><mi>k</mi><mo>=</mo><mn>1</mn></mrow><mi>n</mi></msup><mi>a</mi><mi mathvariant=\"normal\">_</mi><msup><mi>k</mi><mn>2</mn></msup><mo fence=\"true\">)</mo></mrow><mrow><mo fence=\"true\">(</mo><mo>∑</mo><mi mathvariant=\"normal\">_</mi><msup><mrow><mi>k</mi><mo>=</mo><mn>1</mn></mrow><mi>n</mi></msup><mi>b</mi><mi mathvariant=\"normal\">_</mi><msup><mi>k</mi><mn>2</mn></msup><mo fence=\"true\">)</mo></mrow></mstyle></mrow><annotation encoding=\"application/x-tex\">\\displaystyle\n\\left( \\sum\\_{k=1}^n a\\_k b\\_k \\right)^2\n\\leq\n\\left( \\sum\\_{k=1}^n a\\_k^2 \\right)\n\\left( \\sum\\_{k=1}^n b\\_k^2 \\right)</annotation></semantics></math></span><span class=\"katex-html\" aria-hidden=\"true\"><span class=\"strut\" style=\"height: 1.21511em;\"></span><span class=\"strut bottom\" style=\"height: 1.86513em; vertical-align: -0.65002em;\"></span><span class=\"base textstyle uncramped\"><span class=\"reset-textstyle displaystyle textstyle uncramped\"><span class=\"minner\"><span class=\"minner displaystyle textstyle uncramped\"><span class=\"style-wrap reset-textstyle textstyle uncramped\" style=\"top: 0em;\"><span class=\"delimsizing size2\">(</span></span><span class=\"op-symbol large-op mop\" style=\"top: -5e-06em;\">∑</span><span class=\"mord\" style=\"margin-right: 0.02778em;\">_</span><span class=\"mord\"><span class=\"mord displaystyle textstyle uncramped\"><span class=\"mord mathit\" style=\"margin-right: 0.03148em;\">k</span><span class=\"mrel\">=</span><span class=\"mord\">1</span></span><span class=\"vlist\"><span class=\"\" style=\"top: -0.413em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord mathit\">n</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"mord mathit\">a</span><span class=\"mord\" style=\"margin-right: 0.02778em;\">_</span><span class=\"mord mathit\" style=\"margin-right: 0.03148em;\">k</span><span class=\"mord mathit\">b</span><span class=\"mord\" style=\"margin-right: 0.02778em;\">_</span><span class=\"mord mathit\" style=\"margin-right: 0.03148em;\">k</span><span class=\"style-wrap reset-textstyle textstyle uncramped\" style=\"top: 0em;\"><span class=\"delimsizing size2\">)</span></span></span><span class=\"vlist\"><span class=\"\" style=\"top: -0.764em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord\">2</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"mrel\">≤</span><span class=\"minner displaystyle textstyle uncramped\"><span class=\"style-wrap reset-textstyle textstyle uncramped\" style=\"top: 0em;\"><span class=\"delimsizing size2\">(</span></span><span class=\"op-symbol large-op mop\" style=\"top: -5e-06em;\">∑</span><span class=\"mord\" style=\"margin-right: 0.02778em;\">_</span><span class=\"mord\"><span class=\"mord displaystyle textstyle uncramped\"><span class=\"mord mathit\" style=\"margin-right: 0.03148em;\">k</span><span class=\"mrel\">=</span><span class=\"mord\">1</span></span><span class=\"vlist\"><span class=\"\" style=\"top: -0.413em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord mathit\">n</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"mord mathit\">a</span><span class=\"mord\" style=\"margin-right: 0.02778em;\">_</span><span class=\"mord\"><span class=\"mord mathit\" style=\"margin-right: 0.03148em;\">k</span><span class=\"vlist\"><span class=\"\" style=\"top: -0.413em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord\">2</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"style-wrap reset-textstyle textstyle uncramped\" style=\"top: 0em;\"><span class=\"delimsizing size2\">)</span></span></span><span class=\"minner displaystyle textstyle uncramped\"><span class=\"style-wrap reset-textstyle textstyle uncramped\" style=\"top: 0em;\"><span class=\"delimsizing size2\">(</span></span><span class=\"op-symbol large-op mop\" style=\"top: -5e-06em;\">∑</span><span class=\"mord\" style=\"margin-right: 0.02778em;\">_</span><span class=\"mord\"><span class=\"mord displaystyle textstyle uncramped\"><span class=\"mord mathit\" style=\"margin-right: 0.03148em;\">k</span><span class=\"mrel\">=</span><span class=\"mord\">1</span></span><span class=\"vlist\"><span class=\"\" style=\"top: -0.413em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord mathit\">n</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"mord mathit\">b</span><span class=\"mord\" style=\"margin-right: 0.02778em;\">_</span><span class=\"mord\"><span class=\"mord mathit\" style=\"margin-right: 0.03148em;\">k</span><span class=\"vlist\"><span class=\"\" style=\"top: -0.413em; margin-right: 0.05em;\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span><span class=\"reset-textstyle scriptstyle uncramped\"><span class=\"mord\">2</span></span></span><span class=\"baseline-fix\"><span class=\"fontsize-ensurer reset-size5 size5\"><span class=\"\" style=\"font-size: 0em;\">​</span></span>​</span></span></span><span class=\"style-wrap reset-textstyle textstyle uncramped\" style=\"top: 0em;\"><span class=\"delimsizing size2\">)</span></span></span></span></span></span></span></p><p>的</p>\n', '### 科学公式 TeX(KaTeX)\n                    \n$$E=mc^2$$\n\n行内的公式$$E=mc^2$$行内的公式，行内的$$E=mc^2$$公式。\n\n$$\\(\\sqrt{3x-1}+(1+x)^2\\)$$\n                    \n$$\\sin(\\alpha)^{\\theta}=\\sum_{i=0}^{n}(x^i + \\cos(f))$$\n\n多行公式：\n\n```math\n\\displaystyle\n\\left( \\sum\\_{k=1}^n a\\_k b\\_k \\right)^2\n\\leq\n\\left( \\sum\\_{k=1}^n a\\_k^2 \\right)\n\\left( \\sum\\_{k=1}^n b\\_k^2 \\right)\n```\n的', '测试文章9', '[{\"id\":10,\"name\":\"潜潜潜\",\"create_time\":\"2018-09-20T08:41:11.000Z\",\"update_time\":\"2018-09-20T08:41:11.000Z\"}]', 1);
  INSERT INTO `article` VALUES (65, 1, 'koa', 10, 'koa', '转载', 1, '', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Explicabo doloribus dolore saepe perspiciatis inventore eius laudantium. Enim dicta tempora magnam assumenda minima aut, odit ut. Quaerat assumenda consectetur perspiciatis suscipit?', '2019-03-04 09:25:41', '2018-10-17 14:31:17', 1, 0, 0, 0, '<h1 id=\"h1-koa-\"><a name=\"koa教程…\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>koa教程…</h1>', '#koa教程...\n', 'koa', '[{\"id\":3,\"name\":\"node\",\"create_time\":\"2018-09-20T11:54:55.000Z\",\"update_time\":\"2018-09-20T11:54:54.000Z\"}]', 0);
  COMMIT;
  
  -- ----------------------------
  -- Table structure for category
  -- ----------------------------
  DROP TABLE IF EXISTS `category`;
  CREATE TABLE `category` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `uid` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '用户id',
    `name` varchar(30) NOT NULL DEFAULT '' COMMENT '栏目名称',
    `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '自栏目所属父栏目id',
    `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目排序 0为最底端',
    `url` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '栏目中文名称',
    `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '服务端渲染 meta 关键词描述',
    `description` varchar(255) NOT NULL DEFAULT '' COMMENT '服务端渲染 meta 描述详细信息',
    `allow_publish` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否发布',
    `display` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
    `view` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问数',
    `create_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of category
  -- ----------------------------
  BEGIN;
  INSERT INTO `category` VALUES (1, 1, 'js', 4, 1, 'js', 'js 测试', 'js', 1, 1, 0, '2018-09-19 06:19:09', '2018-09-19 06:19:09');
  INSERT INTO `category` VALUES (2, 1, 'vue', 4, 2, 'vue', '', '', 1, 1, 0, '2018-09-17 14:39:36', '2018-09-17 14:39:36');
  INSERT INTO `category` VALUES (3, 1, 'node', 5, 1, 'node', '', '', 1, 1, 0, '2018-09-19 02:29:04', '2018-09-19 02:29:04');
  INSERT INTO `category` VALUES (4, 1, '前端', 0, 1, 'frondend', '前端', '前端', 1, 1, 0, '2018-09-19 06:09:03', '2018-09-19 06:09:03');
  INSERT INTO `category` VALUES (5, 1, '后端', 0, 2, 'backend', '', '', 1, 1, 0, '2018-09-17 14:39:57', '2018-09-17 14:39:57');
  INSERT INTO `category` VALUES (6, 1, '音乐', 0, 3, 'music', '', '', 1, 1, 0, '2018-09-17 14:39:59', '2018-09-17 14:39:59');
  INSERT INTO `category` VALUES (7, 1, '生活', 0, 4, 'life', '', '', 1, 1, 0, '2018-09-19 02:47:46', '2018-09-19 02:47:46');
  INSERT INTO `category` VALUES (8, 1, 'css', 4, 4, 'css', '', '', 1, 1, 0, '2018-09-17 14:40:03', '2018-09-17 14:40:03');
  INSERT INTO `category` VALUES (9, 1, 'html', 4, 3, 'html', '', '', 1, 1, 0, '2018-09-17 14:40:05', '2018-09-17 14:40:05');
  INSERT INTO `category` VALUES (10, 1, 'koa', 3, 2, 'koa', '', '', 1, 1, 0, '2018-09-17 14:40:06', '2018-09-17 14:40:06');
  INSERT INTO `category` VALUES (11, 1, 'express', 3, 3, 'express', '', '', 1, 1, 0, '2018-09-17 14:40:11', '2018-09-17 14:40:11');
  INSERT INTO `category` VALUES (12, 1, 'react', 4, 2, 'react', '', '', 1, 1, 0, '2018-09-19 06:09:09', '2018-09-19 06:09:09');
  INSERT INTO `category` VALUES (13, 1, 'jquery', 1, 0, 'jquery', '', '', 1, 1, 0, '2018-09-19 06:05:25', '2018-09-19 06:05:25');
  INSERT INTO `category` VALUES (14, 1, 'zepto', 1, 1, 'zepto', '', '', 1, 1, 0, '2018-09-17 14:40:20', '2018-09-17 14:40:20');
  INSERT INTO `category` VALUES (16, 1, 'vue-router', 2, 0, 'vue-router', '', '', 1, 1, 0, '2018-09-17 14:40:31', '2018-09-17 14:40:31');
  INSERT INTO `category` VALUES (17, 1, 'vuex', 2, 0, 'vuex', '', '', 1, 1, 0, '2018-09-17 14:40:34', '2018-09-17 14:40:34');
  INSERT INTO `category` VALUES (23, 1, 'hapi', 3, 3, 'hapi', 'hapi', 'hapi', 1, 1, 0, '2018-09-17 09:08:05', '2018-09-17 09:08:05');
  INSERT INTO `category` VALUES (44, 1, '其它', 2, 0, 'others', '', '', 1, 1, 0, '2018-09-20 03:14:14', '2018-09-20 03:14:14');
  INSERT INTO `category` VALUES (49, 1, '其它', 0, 0, 'others', '其它分类', '', 1, 1, 0, '2018-10-08 09:53:56', '2018-10-08 09:53:56');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for tags
  -- ----------------------------
  DROP TABLE IF EXISTS `tags`;
  CREATE TABLE `tags` (
    `id` tinyint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '标签id',
    `name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标签名称',
    `create_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  
  -- ----------------------------
  -- Records of tags
  -- ----------------------------
  BEGIN;
  INSERT INTO `tags` VALUES (1, 'js', '2018-09-20 08:21:20', '2018-09-20 08:21:20');
  INSERT INTO `tags` VALUES (2, 'vue', '2018-09-20 11:54:53', '2018-09-20 11:54:52');
  INSERT INTO `tags` VALUES (3, 'node', '2018-09-20 11:54:55', '2018-09-20 11:54:54');
  INSERT INTO `tags` VALUES (4, 'css', '2018-09-20 11:54:57', '2018-09-20 11:54:56');
  INSERT INTO `tags` VALUES (5, 'html', '2018-09-20 11:54:59', '2018-09-20 11:54:58');
  INSERT INTO `tags` VALUES (10, '潜', '2018-10-16 01:55:38', '2018-10-16 01:55:38');
  INSERT INTO `tags` VALUES (18, 'wth', '2018-10-16 01:55:46', '2018-10-16 01:55:46');
  INSERT INTO `tags` VALUES (20, 'vpn', '2018-10-08 09:54:52', '2018-10-08 09:54:52');
  INSERT INTO `tags` VALUES (21, 'Huston', '2018-10-16 01:11:44', '2018-10-16 01:11:44');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for user
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
    `uname` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名成',
    `real_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '用户真名',
    `pwd` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
    `type` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '用户类型',
    `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联系号码',
    `email` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联系邮箱',
    `enable` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否启用',
    `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '用户创建时间',
    `update_item` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of user
  -- ----------------------------
  BEGIN;
  INSERT INTO `user` VALUES (4, 'qianqian', '潜', 'qianqian', 1, '17632389324', '7827343274@qq.com', 1, 'test', '2018-10-01 21:21:16', '2018-10-01 21:21:12');
  COMMIT;
  
  SET FOREIGN_KEY_CHECKS = 1;
  