blog_posts.sql

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `blog_posts`
-- ----------------------------
DROP TABLE IF EXISTS `blog_posts`;
CREATE TABLE `blog_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `content_markdown` text,
  `content_html` text,
  `tags` varchar(255) DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `published_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `views` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `blog_posts`
-- ----------------------------
BEGIN;
INSERT INTO `blog_posts` VALUES ('2', '这是我的第一篇博文', '---\n__Advertisement :)__\n\n- __[pica](https://nodeca.github.io/pica/demo/)__ - high quality and fast image\n  resize in browser.\n- __[babelfish](https://github.com/nodeca/babelfish/)__ - developer friendly\n  i18n with plurals support and easy syntax.\n\nYou will like those projects!\n\n---\n\n# h1 Heading 8-)\n## h2 Heading\n### h3 Heading\n#### h4 Heading\n##### h5 Heading\n###### h6 Heading\n\n\n## Horizontal Rules\n\n___\n\n---\n\n***\n\n\n## Typographic replacements\n\nEnable typographer option to see result.\n\n(c) (C) (r) (R) (tm) (TM) (p) (P) +-\n\ntest.. test... test..... test?..... test!....\n\n!!!!!! ???? ,,  -- ---\n\n\"Smartypants, double quotes\" and \'single quotes\'\n\n\n## Emphasis\n\n**This is bold text**\n\n__This is bold text__\n\n*This is italic text*\n\n_This is italic text_\n\n~~Strikethrough~~\n\n\n## Blockquotes\n\n\n> Blockquotes can also be nested...\n>> ...by using additional greater-than signs right next to each other...\n> > > ...or with spaces between arrows.\n\n\n## Lists\n\nUnordered\n\n+ Create a list by starting a line with `+`, `-`, or `*`\n+ Sub-lists are made by indenting 2 spaces:\n  - Marker character change forces new list start:\n    * Ac tristique libero volutpat at\n    + Facilisis in pretium nisl aliquet\n    - Nulla volutpat aliquam velit\n+ Very easy!\n\nOrdered\n\n1. Lorem ipsum dolor sit amet\n2. Consectetur adipiscing elit\n3. Integer molestie lorem at massa\n\n\n1. You can use sequential numbers...\n1. ...or keep all the numbers as `1.`\n\nStart numbering with offset:\n\n57. foo\n1. bar\n\n\n## Code\n\nInline `code`\n\nIndented code\n\n    // Some comments\n    line 1 of code\n    line 2 of code\n    line 3 of code\n\n\nBlock code \"fences\"\n\n```\nSample text here...\n```\n\nSyntax highlighting\n\n``` js\nvar foo = function (bar) {\n  return bar++;\n};\n\nconsole.log(foo(5));\n```\n\n## Tables\n\n| Option | Description |\n| ------ | ----------- |\n| data   | path to data files to supply the data that will be passed into templates. |\n| engine | engine to be used for processing templates. Handlebars is the default. |\n| ext    | extension to be used for dest files. |\n\nRight aligned columns\n\n| Option | Description |\n| ------:| -----------:|\n| data   | path to data files to supply the data that will be passed into templates. |\n| engine | engine to be used for processing templates. Handlebars is the default. |\n| ext    | extension to be used for dest files. |\n\n\n## Links\n\n[link text](http://dev.nodeca.com)\n\n[link with title](http://nodeca.github.io/pica/demo/ \"title text!\")\n\nAutoconverted link https://github.com/nodeca/pica (enable linkify to see)\n\n\n## Images\n\n![Minion](https://octodex.github.com/images/minion.png)\n![Stormtroopocat](https://octodex.github.com/images/stormtroopocat.jpg \"The Stormtroopocat\")\n\nLike links, Images also have a footnote style syntax\n\n![Alt text][id]\n\nWith a reference later in the document defining the URL location:\n\n[id]: https://octodex.github.com/images/dojocat.jpg  \"The Dojocat\"\n\n\n## Plugins\n\nThe killer feature of `markdown-it` is very effective support of\n[syntax plugins](https://www.npmjs.org/browse/keyword/markdown-it-plugin).\n\n\n### [Emojies](https://github.com/markdown-it/markdown-it-emoji)\n\n> Classic markup: :wink: :crush: :cry: :tear: :laughing: :yum:\n>\n> Shortcuts (emoticons): :-) :-( 8-) ;)\n\nsee [how to change output](https://github.com/markdown-it/markdown-it-emoji#change-output) with twemoji.\n\n\n### [Subscript](https://github.com/markdown-it/markdown-it-sub) / [Superscript](https://github.com/markdown-it/markdown-it-sup)\n\n- 19^th^\n- H~2~O\n\n\n### [\\<ins>](https://github.com/markdown-it/markdown-it-ins)\n\n++Inserted text++\n\n\n### [\\<mark>](https://github.com/markdown-it/markdown-it-mark)\n\n==Marked text==\n\n\n### [Footnotes](https://github.com/markdown-it/markdown-it-footnote)\n\nFootnote 1 link[^first].\n\nFootnote 2 link[^second].\n\nInline footnote^[Text of inline footnote] definition.\n\nDuplicated footnote reference[^second].\n\n[^first]: Footnote **can have markup**\n\n    and multiple paragraphs.\n\n[^second]: Footnote text.\n\n\n### [Definition lists](https://github.com/markdown-it/markdown-it-deflist)\n\nTerm 1\n\n:   Definition 1\nwith lazy continuation.\n\nTerm 2 with *inline markup*\n\n:   Definition 2\n\n        { some code, part of Definition 2 }\n\n    Third paragraph of definition 2.\n\n_Compact style:_\n\nTerm 1\n  ~ Definition 1\n\nTerm 2\n  ~ Definition 2a\n  ~ Definition 2b\n\n\n### [Abbreviations](https://github.com/markdown-it/markdown-it-abbr)\n\nThis is HTML abbreviation example.\n\nIt converts \"HTML\", but keep intact partial entries like \"xxxHTMLyyy\" and so on.\n\n*[HTML]: Hyper Text Markup Language\n\n### [Custom containers](https://github.com/markdown-it/markdown-it-container)\n\n::: warning\n*here be dragons*\n:::\n', '<hr>\n<p class=\"line\" data-line=\"1\"><strong>Advertisement <img class=\"emoji\" draggable=\"false\" alt=\"😃\" src=\"http://twemoji.maxcdn.com/36x36/1f603.png\"></strong></p>\n<ul>\n<li><strong><a href=\"https://nodeca.github.io/pica/demo/\">pica</a></strong> - high quality and fast image\nresize in browser.</li>\n<li><strong><a href=\"https://github.com/nodeca/babelfish/\">babelfish</a></strong> - developer friendly\ni18n with plurals support and easy syntax.</li>\n</ul>\n<p class=\"line\" data-line=\"8\">You will like those projects!</p>\n<hr>\n<h1 class=\"line\" data-line=\"12\">h1 Heading <img class=\"emoji\" draggable=\"false\" alt=\"😎\" src=\"http://twemoji.maxcdn.com/36x36/1f60e.png\"></h1>\n<h2 class=\"line\" data-line=\"13\">h2 Heading</h2>\n<h3 class=\"line\" data-line=\"14\">h3 Heading</h3>\n<h4 class=\"line\" data-line=\"15\">h4 Heading</h4>\n<h5 class=\"line\" data-line=\"16\">h5 Heading</h5>\n<h6 class=\"line\" data-line=\"17\">h6 Heading</h6>\n<h2 class=\"line\" data-line=\"20\">Horizontal Rules</h2>\n<hr>\n<hr>\n<hr>\n<h2 class=\"line\" data-line=\"29\">Typographic replacements</h2>\n<p class=\"line\" data-line=\"31\">Enable typographer option to see result.</p>\n<p class=\"line\" data-line=\"33\">© © ® ® ™ ™ § § ±</p>\n<p class=\"line\" data-line=\"35\">test… test… test… test?.. test!..</p>\n<p class=\"line\" data-line=\"37\">!!! ??? ,  – —</p>\n<p class=\"line\" data-line=\"39\">“Smartypants, double quotes” and ‘single quotes’</p>\n<h2 class=\"line\" data-line=\"42\">Emphasis</h2>\n<p class=\"line\" data-line=\"44\"><strong>This is bold text</strong></p>\n<p class=\"line\" data-line=\"46\"><strong>This is bold text</strong></p>\n<p class=\"line\" data-line=\"48\"><em>This is italic text</em></p>\n<p class=\"line\" data-line=\"50\"><em>This is italic text</em></p>\n<p class=\"line\" data-line=\"52\"><s>Strikethrough</s></p>\n<h2 class=\"line\" data-line=\"55\">Blockquotes</h2>\n<blockquote>\n<p>Blockquotes can also be nested…</p>\n<blockquote>\n<p>…by using additional greater-than signs right next to each other…</p>\n<blockquote>\n<p>…or with spaces between arrows.</p>\n</blockquote>\n</blockquote>\n</blockquote>\n<h2 class=\"line\" data-line=\"63\">Lists</h2>\n<p class=\"line\" data-line=\"65\">Unordered</p>\n<ul>\n<li>Create a list by starting a line with <code>+</code>, <code>-</code>, or <code>*</code></li>\n<li>Sub-lists are made by indenting 2 spaces:\n<ul>\n<li>Marker character change forces new list start:\n<ul>\n<li>Ac tristique libero volutpat at</li>\n</ul>\n<ul>\n<li>Facilisis in pretium nisl aliquet</li>\n</ul>\n<ul>\n<li>Nulla volutpat aliquam velit</li>\n</ul>\n</li>\n</ul>\n</li>\n<li>Very easy!</li>\n</ul>\n<p class=\"line\" data-line=\"75\">Ordered</p>\n<ol>\n<li>\n<p>Lorem ipsum dolor sit amet</p>\n</li>\n<li>\n<p>Consectetur adipiscing elit</p>\n</li>\n<li>\n<p>Integer molestie lorem at massa</p>\n</li>\n<li>\n<p>You can use sequential numbers…</p>\n</li>\n<li>\n<p>…or keep all the numbers as <code>1.</code></p>\n</li>\n</ol>\n<p class=\"line\" data-line=\"85\">Start numbering with offset:</p>\n<ol start=\"57\">\n<li>foo</li>\n<li>bar</li>\n</ol>\n<h2 class=\"line\" data-line=\"91\">Code</h2>\n<p class=\"line\" data-line=\"93\">Inline <code>code</code></p>\n<p class=\"line\" data-line=\"95\">Indented code</p>\n<pre><code>// Some comments\nline 1 of code\nline 2 of code\nline 3 of code\n</code></pre>\n<p class=\"line\" data-line=\"103\">Block code “fences”</p>\n<pre class=\"hljs\"><code>Sample text here...\n</code></pre>\n<p class=\"line\" data-line=\"109\">Syntax highlighting</p>\n<pre class=\"hljs language-js\"><code><span class=\"hljs-keyword\">var</span> foo = <span class=\"hljs-function\"><span class=\"hljs-keyword\">function</span> (<span class=\"hljs-params\">bar</span>) </span>{\n  <span class=\"hljs-keyword\">return</span> bar++;\n};\n\n<span class=\"hljs-built_in\">console</span>.log(foo(<span class=\"hljs-number\">5</span>));\n</code></pre>\n<h2 class=\"line\" data-line=\"119\">Tables</h2>\n<table class=\"table table-striped\">\n<thead>\n<tr>\n<th>Option</th>\n<th>Description</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>data</td>\n<td>path to data files to supply the data that will be passed into templates.</td>\n</tr>\n<tr>\n<td>engine</td>\n<td>engine to be used for processing templates. Handlebars is the default.</td>\n</tr>\n<tr>\n<td>ext</td>\n<td>extension to be used for dest files.</td>\n</tr>\n</tbody>\n</table>\n<p class=\"line\" data-line=\"127\">Right aligned columns</p>\n<table class=\"table table-striped\">\n<thead>\n<tr>\n<th style=\"text-align:right\">Option</th>\n<th style=\"text-align:right\">Description</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td style=\"text-align:right\">data</td>\n<td style=\"text-align:right\">path to data files to supply the data that will be passed into templates.</td>\n</tr>\n<tr>\n<td style=\"text-align:right\">engine</td>\n<td style=\"text-align:right\">engine to be used for processing templates. Handlebars is the default.</td>\n</tr>\n<tr>\n<td style=\"text-align:right\">ext</td>\n<td style=\"text-align:right\">extension to be used for dest files.</td>\n</tr>\n</tbody>\n</table>\n<h2 class=\"line\" data-line=\"136\">Links</h2>\n<p class=\"line\" data-line=\"138\"><a href=\"http://dev.nodeca.com\">link text</a></p>\n<p class=\"line\" data-line=\"140\"><a href=\"http://nodeca.github.io/pica/demo/\" title=\"title text!\">link with title</a></p>\n<p class=\"line\" data-line=\"142\">Autoconverted link <a href=\"https://github.com/nodeca/pica\">https://github.com/nodeca/pica</a> (enable linkify to see)</p>\n<h2 class=\"line\" data-line=\"145\">Images</h2>\n<p class=\"line\" data-line=\"147\"><img src=\"https://octodex.github.com/images/minion.png\" alt=\"Minion\">\n<img src=\"https://octodex.github.com/images/stormtroopocat.jpg\" alt=\"Stormtroopocat\" title=\"The Stormtroopocat\"></p>\n<p class=\"line\" data-line=\"150\">Like links, Images also have a footnote style syntax</p>\n<p class=\"line\" data-line=\"152\"><img src=\"https://octodex.github.com/images/dojocat.jpg\" alt=\"Alt text\" title=\"The Dojocat\"></p>\n<p class=\"line\" data-line=\"154\">With a reference later in the document defining the URL location:</p>\n<h2 class=\"line\" data-line=\"159\">Plugins</h2>\n<p class=\"line\" data-line=\"161\">The killer feature of <code>markdown-it</code> is very effective support of\n<a href=\"https://www.npmjs.org/browse/keyword/markdown-it-plugin\">syntax plugins</a>.</p>\n<h3 class=\"line\" data-line=\"165\"><a href=\"https://github.com/markdown-it/markdown-it-emoji\">Emojies</a></h3>\n<blockquote>\n<p>Classic markup: <img class=\"emoji\" draggable=\"false\" alt=\"😉\" src=\"http://twemoji.maxcdn.com/36x36/1f609.png\"> :crush: <img class=\"emoji\" draggable=\"false\" alt=\"😢\" src=\"http://twemoji.maxcdn.com/36x36/1f622.png\"> :tear: <img class=\"emoji\" draggable=\"false\" alt=\"😆\" src=\"http://twemoji.maxcdn.com/36x36/1f606.png\"> <img class=\"emoji\" draggable=\"false\" alt=\"😋\" src=\"http://twemoji.maxcdn.com/36x36/1f60b.png\"></p>\n<p>Shortcuts (emoticons): <img class=\"emoji\" draggable=\"false\" alt=\"😃\" src=\"http://twemoji.maxcdn.com/36x36/1f603.png\"> <img class=\"emoji\" draggable=\"false\" alt=\"😦\" src=\"http://twemoji.maxcdn.com/36x36/1f626.png\"> <img class=\"emoji\" draggable=\"false\" alt=\"😎\" src=\"http://twemoji.maxcdn.com/36x36/1f60e.png\"> <img class=\"emoji\" draggable=\"false\" alt=\"😉\" src=\"http://twemoji.maxcdn.com/36x36/1f609.png\"></p>\n</blockquote>\n<p class=\"line\" data-line=\"171\">see <a href=\"https://github.com/markdown-it/markdown-it-emoji#change-output\">how to change output</a> with twemoji.</p>\n<h3 class=\"line\" data-line=\"174\"><a href=\"https://github.com/markdown-it/markdown-it-sub\">Subscript</a> / <a href=\"https://github.com/markdown-it/markdown-it-sup\">Superscript</a></h3>\n<ul>\n<li>19<sup>th</sup></li>\n<li>H<sub>2</sub>O</li>\n</ul>\n<h3 class=\"line\" data-line=\"180\"><a href=\"https://github.com/markdown-it/markdown-it-ins\">&lt;ins&gt;</a></h3>\n<p class=\"line\" data-line=\"182\"><ins>Inserted text</ins></p>\n<h3 class=\"line\" data-line=\"185\"><a href=\"https://github.com/markdown-it/markdown-it-mark\">&lt;mark&gt;</a></h3>\n<p class=\"line\" data-line=\"187\"><mark>Marked text</mark></p>\n<h3 class=\"line\" data-line=\"190\"><a href=\"https://github.com/markdown-it/markdown-it-footnote\">Footnotes</a></h3>\n<p class=\"line\" data-line=\"192\">Footnote 1 link<sup class=\"footnote-ref\"><a href=\"#fn1\" id=\"fnref1\">[1]</a></sup>.</p>\n<p class=\"line\" data-line=\"194\">Footnote 2 link<sup class=\"footnote-ref\"><a href=\"#fn2\" id=\"fnref2\">[2]</a></sup>.</p>\n<p class=\"line\" data-line=\"196\">Inline footnote<sup class=\"footnote-ref\"><a href=\"#fn3\" id=\"fnref3\">[3]</a></sup> definition.</p>\n<p class=\"line\" data-line=\"198\">Duplicated footnote reference<sup class=\"footnote-ref\"><a href=\"#fn2\" id=\"fnref2:1\">[2:1]</a></sup>.</p>\n<h3 class=\"line\" data-line=\"207\"><a href=\"https://github.com/markdown-it/markdown-it-deflist\">Definition lists</a></h3>\n<dl>\n<dt>Term 1</dt>\n<dd>\n<p>Definition 1\nwith lazy continuation.</p>\n</dd>\n<dt>Term 2 with <em>inline markup</em></dt>\n<dd>\n<p>Definition 2</p>\n<pre><code>  { some code, part of Definition 2 }\n</code></pre>\n<p>Third paragraph of definition 2.</p>\n</dd>\n</dl>\n<p class=\"line\" data-line=\"222\"><em>Compact style:</em></p>\n<dl>\n<dt>Term 1</dt>\n<dd>Definition 1</dd>\n<dt>Term 2</dt>\n<dd>Definition 2a</dd>\n<dd>Definition 2b</dd>\n</dl>\n<h3 class=\"line\" data-line=\"232\"><a href=\"https://github.com/markdown-it/markdown-it-abbr\">Abbreviations</a></h3>\n<p class=\"line\" data-line=\"234\">This is <abbr title=\"Hyper Text Markup Language\">HTML</abbr> abbreviation example.</p>\n<p class=\"line\" data-line=\"236\">It converts “<abbr title=\"Hyper Text Markup Language\">HTML</abbr>”, but keep intact partial entries like “xxxHTMLyyy” and so on.</p>\n<h3 class=\"line\" data-line=\"240\"><a href=\"https://github.com/markdown-it/markdown-it-container\">Custom containers</a></h3>\n<div class=\"warning\">\n<p><em>here be dragons</em></p>\n</div>\n<hr class=\"footnotes-sep\">\n<section class=\"footnotes\">\n<ol class=\"footnotes-list\">\n<li id=\"fn1\" class=\"footnote-item\"><p>Footnote <strong>can have markup</strong></p>\n<p>and multiple paragraphs. <a href=\"#fnref1\" class=\"footnote-backref\">↩︎</a></p>\n</li>\n<li id=\"fn2\" class=\"footnote-item\"><p>Footnote text. <a href=\"#fnref2\" class=\"footnote-backref\">↩︎</a> <a href=\"#fnref2:1\" class=\"footnote-backref\">↩︎</a></p>\n</li>\n<li id=\"fn3\" class=\"footnote-item\"><p>Text of inline footnote <a href=\"#fnref3\" class=\"footnote-backref\">↩︎</a></p>\n</li>\n</ol>\n</section>\n', null, '7', '1512090926', '1512116659', null, null), ('6', '第二篇博文', '### 一个标题', '<h3 class=\"line\" data-line=\"0\">一个标题</h3>\n', null, '0', '1512118945', '1512118945', null, null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;