-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathblog.sql
More file actions
199 lines (171 loc) · 17.3 KB
/
blog.sql
File metadata and controls
199 lines (171 loc) · 17.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
-- phpMyAdmin SQL Dump
-- version 4.5.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 2018-01-02 08:34:10
-- 服务器版本： 5.7.9
-- PHP Version: 5.6.16
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `blog`
--
-- --------------------------------------------------------
--
-- 表的结构 `article`
--
DROP TABLE IF EXISTS `article`;
CREATE TABLE IF NOT EXISTS `article` (
`article_id` int(11) NOT NULL COMMENT '文章ID号',
`title` char(40) NOT NULL DEFAULT '无题' COMMENT '标题',
`link` char(100) DEFAULT NULL,
`user` char(20) NOT NULL DEFAULT '天边' COMMENT '用户',
`content` text COMMENT '内容',
`head_pic` varchar(200) NOT NULL DEFAULT '/blog/img/title/default.png' COMMENT '文章列表显示的默认头图',
`class` char(20) NOT NULL DEFAULT '未分类' COMMENT '分类',
`keywords` char(50) DEFAULT NULL,
`pub_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发表时间',
`click` int(11) NOT NULL DEFAULT '0' COMMENT '点击数',
`comment` int(10) NOT NULL DEFAULT '0',
`fav` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`article_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `article`
--
INSERT INTO `article` (`article_id`, `title`, `link`, `user`, `content`, `head_pic`, `class`, `keywords`, `pub_time`, `click`, `comment`, `fav`) VALUES
(2016070201, '新测试', '/blog/page/2016/07/2016070201.html', '天边', '<p>这是又一篇<span>测试</span>文章</p><pre>int a=b,b=c;</pre><p><br/></p>', '/blog/img/title/default.png', '测试', '测试', '2016-07-02 02:15:04', 14, 3, 16),
(2016070202, '英文命名测试', '/blog/page/2016/07/untitled.html', '天边', '<p>这是一篇测试。</p>', '/blog/img/title/default.png', '测试', '测试', '2016-07-02 02:27:55', 1, 0, 0),
(2016070203, '新测试 ver2.0', '/blog/page/2016/07/2016070203.html', '天边', '<p> </p><pre class="brush:css;toolbar:false;">div#head {\r\n padding: 20px 0 30px;\r\n text-align: center;\r\n background-color: #28282E;\r\n color: #fff;\r\n}</pre><p> </p>', '/blog/img/title/default.png', '测试', '测试', '2016-07-02 05:58:54', 3, 0, 1),
(2016070204, '新测试2222222', '/blog/page/2016/07/2016070204.html', '天边', '<p>这是第一篇经过编辑更新的测试文章</p><pre>int a=b,b=c;</pre><p>2222222222222222222222222222222222222222222</p>', '/blog/img/title/default.png', '测试', '测试', '2016-07-02 05:59:21', 1, 0, 0),
(2016070401, '!', '/blog/page/2016/07/!!.html', '天边', '<p>!</p>', '/blog/img/title/default.png', '!', '!', '2016-07-04 12:34:59', 1, 0, 0),
(2016070801, '测试代码高亮功能', '/blog/page/2016/07/code_highlight.html', '天边', '<p> 测试CSS，JS，Html代码高亮：</p><pre class="brush:css;toolbar:false;">#container {\r\n position: relative;\r\n width: 1130px;\r\n left: 200px;\r\n border-radius: 5px;\r\n -webkit-transition: -webkit-transform 1s;\r\n transition: transform 1s\r\n}</pre><pre class="brush:js;toolbar:false">jQuery(document).ready(function($) {\r\n $("form").submit(function(event) {\r\n event.preventDefault();\r\n $user= $("input#user").val();\r\n $pwd= $("input#pwd").val();\r\n $.ajax({\r\n url: 'control.php?action=login',\r\n type: 'post',\r\n data: {user: $user,pwd: $pwd},\r\n success:function(msg){\r\n if(msg=="登陆成功！"){\r\n window.location.href="index.php";\r\n }else{\r\n $("div#msg p").html(msg);\r\n }\r\n }\r\n });\r\n return false;\r\n });\r\n});</pre><pre class="brush:html;toolbar:false"> <div id="header">\r\n <div id="content">\r\n <img src="/blog/img/avatar/skyside.png" alt="" />\r\n <p>后台登陆</p>\r\n </div>\r\n </div></pre><p> 测试结束。</p>', '/blog/img/title/default.png', '测试', '测试 代码高亮', '2016-07-08 17:38:18', 1416, 21, 87),
(2016072302, '第二次测试静态生成文章', '/blog/page/2016/07/test2.html', '天边', '<p>第二次测试后台静态生成文章。</p><pre class="brush:css;toolbar:false">input{\r\n margin-right: 40px;\r\n}\r\ninput:focus{\r\n border: 2px solid #FF5E53;\r\n outline: none;\r\n}</pre><p>这里是加上去的内容。</p>', '/blog/img/title/default.png', '测试', '测试', '2016-07-23 07:11:04', 51, 2, 0),
(2016072402, '新样式测试', '/blog/page/2016/07/new_style.html', '天边', '<p>新样式测试。</p><pre class="brush:css;toolbar:false">#article #title {\r\n text-align: center;\r\n}\r\n#article #title, #article #content{\r\n padding-bottom: 40px;\r\n border-bottom: 1px solid #ccc;\r\n}\r\nh1 {\r\n color: #6d6d6d;\r\n font-size: 40px;\r\n padding: 0;\r\n margin-bottom: 25px;\r\n}\r\n#post-info a {\r\n color: #D93641;\r\n}</pre><p><br/></p>', '/blog/img/title/default.png', '测试', '测试 代码高亮', '2016-07-24 17:10:39', 248, 4, 10),
(2016081401, 'test', '/blog/page/2016/08/test.html', '天边', '<p>测试新功能。</p>', '/blog/img/title/default.png', '测试', '测试', '2016-08-14 10:12:16', 11, 0, 0),
(2016081501, '测试文章', '/blog/page/2016/08/test2.html', '天边', '<p>测测测测测测测测测测测测测测测测测测</p>', '/blog/img/title/default.png', '测试', '标签4 标签6 测试', '2016-08-15 07:06:43', 21, 0, 2),
(2016081502, '新测试文章', '/blog/page/2016/08/new_test.html', '天边', '<p>新测试文章新测试文章新测试文章新测试文章新测试文章</p>', '/blog/img/title/default.png', '测试', '测试', '2016-08-15 07:09:05', 3, 0, 0),
(2016081503, '测试图片上传', '/blog/page/2016/08/pic_upload.html', '天边', '', '/blog/img/upload/20160815/__.png', '测试', '测试 图片上传', '2016-08-15 10:09:21', 8, 0, 0),
(2016081504, '成功的一次头图上传', '/blog/page/2016/08/x.html', '天边', '', '/blog/img/upload/20160815/roadways.png', '测试', '图片上传 测试', '2016-08-15 16:16:09', 17, 0, 0),
(2016081505, '文章头图上传功能成功啦', '/blog/page/2016/08/head_pic_upload.html', '天边', '<p style="text-align: center;">决定放一张冬眠君给予奖励，啊哈哈~~~<img src="/blog/img/upload/20160816/1471277915726715.jpg" title="1471277915726715.jpg" alt="788ac5cdjw1f2yvknm03oj216o0qo7eo.jpg"/></p>', '/blog/img/upload/20160815/01b70055658d090000008ec9dbb50c.jpg', '测试', '图片上传 测试', '2016-08-15 16:18:54', 35, 1, 2),
(2016081602, '今天8月16', '/blog/page/2016/08/0816.html', '天边', '<p>今天8月16</p><pre class="brush:cpp;toolbar:false;">sweqw</pre><p><br/></p>', '/blog/img/upload/20160816/others.png', '生活', '生活', '2016-08-15 17:05:02', 112, 4, 2);
-- --------------------------------------------------------
--
-- 表的结构 `comment`
--
DROP TABLE IF EXISTS `comment`;
CREATE TABLE IF NOT EXISTS `comment` (
`article_id` int(11) NOT NULL COMMENT '文章ID号',
`comment_id` int(40) NOT NULL AUTO_INCREMENT,
`parent` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`children` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`content` text CHARACTER SET utf8 NOT NULL COMMENT '评论内容',
`user` char(20) CHARACTER SET utf8 NOT NULL COMMENT '用户',
`avatar` varchar(100) COLLATE utf8_bin NOT NULL,
`pub_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`have_read` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=299 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- 转存表中的数据 `comment`
--
INSERT INTO `comment` (`article_id`, `comment_id`, `parent`, `children`, `content`, `user`, `avatar`, `pub_time`, `have_read`) VALUES
(2016070801, 10, NULL, '', '奇迹在天边。', '刘明皓', '/blog/img/avatar/7.jpg', '2016-07-15 11:18:45', 1),
(2016070801, 12, NULL, '21,22,33,34,43,51,52,', '我喜欢阿心', '小飞飞', '/blog/img/avatar/7.jpg', '2016-07-15 14:29:55', 1),
(2016070801, 21, '12', '', '回复<a href='#comment12'><span>@小飞飞</span></a>：我也喜欢你，我们在一起吧，会幸福的。', '阿心', '/blog/img/avatar/7.jpg', '2016-07-16 10:41:09', 1),
(2016070801, 22, '12', '', '回复<a href='#comment21'><span>@阿心</span></a>：可是我喜欢你，你不要喜欢他好吗？', '大心心', '/blog/img/avatar/7.jpg', '2016-07-16 10:50:06', 1),
(2016070801, 33, '12', '', '回复<a href=#comment22><span>@大心心</span></a>：你喜欢他，可是我喜欢你啊。', '小心心', '/blog/img/avatar/7.jpg', '2016-07-16 14:26:44', 1),
(2016070801, 34, '12', '', '回复<a href=#comment22><span>@大心心</span></a>：我不喜欢你，别追我了。', '阿心', '/blog/img/avatar/7.jpg', '2016-07-16 14:31:42', 1),
(2016070801, 43, '12', '', '回复<a href=#comment12><span>@小飞飞</span></a>：我也喜欢你。', '新心', '/blog/img/avatar/7.jpg', '2016-07-16 14:59:15', 1),
(2016070801, 51, '12', '', '回复<a href=#comment21><span>@阿心</span></a>：我爱你。', '小甜甜', '/blog/img/avatar/7.jpg', '2016-07-16 15:18:01', 1),
(2016070801, 52, '12', '', '回复<a href=#comment12><span>@小飞飞</span></a>：我对你的忠贞不渝。', '阿心', '/blog/img/avatar/7.jpg', '2016-07-16 15:18:20', 1),
(2016070801, 69, '', '109,110,111,112,113,', '我是大哥。', '我是大哥', '/blog/img/avatar/7.jpg', '2016-07-16 16:26:02', 1),
(2016070801, 109, '69', '', '回复<a><span>@我是大哥</span></a>：我是二哥', '我是二哥', '/blog/img/avatar/7.jpg', '2016-07-17 10:30:53', 1),
(2016070801, 110, '69', '', '回复<a href=#comment109><span>@我是二哥</span></a>：我是三哥', '我是三哥', '/blog/img/avatar/7.jpg', '2016-07-17 10:33:48', 1),
(2016070801, 111, '69', '', '回复<a href=#comment110><span>@我是三哥</span></a>：我是四哥', '我是四哥', '/blog/img/avatar/7.jpg', '2016-07-17 10:35:23', 1),
(2016070801, 112, '69', '', '回复<a href=#comment111><span>@我是四哥</span></a>：我是五哥', '我是五哥', '/blog/img/avatar/7.jpg', '2016-07-17 10:38:49', 1),
(2016070801, 113, '69', '', '回复<a href=#comment112><span>@我是五哥</span></a>：像我这么屌的还有一打！！！', '我是N哥', '/blog/img/avatar/7.jpg', '2016-07-17 10:45:56', 1),
(2016070801, 177, '', '', '我是大表哥。', '大表哥', '/blog/img/avatar/1.jpg', '2016-07-19 09:26:32', 1),
(2016070801, 178, '', '', '我是小婊砸。', '小婊砸', '/blog/img/avatar/2.jpg', '2016-07-19 09:32:23', 1),
(2016070801, 189, '', '', '睡了吗？', '冬眠', '/blog/img/avatar/3.jpg', '2016-07-19 12:32:41', 1),
(2016070801, 191, '', '', '明天去哪里玩呢？', '若轩', '/blog/img/avatar/5.jpg', '2016-07-19 14:38:23', 1),
(2016070801, 221, '', '', '尼玛。。。。再也不给这评论部分加需求了，累死爹了！！！', '刘大帅', '/blog/img/avatar/7.jpg', '2016-07-21 08:16:51', 1),
(2016070801, 222, '', '', '最爱你夕阳下的身影。', 'Lydia', '/blog/img/avatar/4.jpg', '2016-07-21 08:21:14', 1),
(2016070201, 224, '', '', '这是新测试文章哦。', '若轩', '/blog/img/avatar/5.jpg', '2016-07-23 03:10:49', 1),
(2016070201, 225, '', '226,', '测试页面静态化。', '冬眠', '/blog/img/avatar/3.jpg', '2016-07-23 03:25:57', 1),
(2016070201, 226, '225', '', '回复<a href=#comment225><span>@冬眠</span></a>：测试静态页面文章嵌套评论。', '若轩', '/blog/img/avatar/5.jpg', '2016-07-23 03:26:51', 1),
(2016072302, 228, '', '', '这是一个测试评论。', '测试', '/blog/img/avatar/5.jpg', '2016-07-23 10:06:13', 1),
(2016072302, 235, '', '', '这是第二个测试评论。', '测试', 'http://localhost/blog/img/avatar/2.jpg', '2016-07-24 15:52:10', 1),
(2016072402, 239, '', '', '这是第一个新样式的评论测试。', '洛轩', '/blog/img/avatar/5.jpg', '2016-07-24 17:11:28', 1),
(2016072402, 241, '', '', '这是第二个新样式的评论测试。', '冬眠', '/blog/img/avatar/3.jpg', '2016-08-08 16:17:44', 1),
(2016072402, 242, '', '', '这是第三个新样式的评论测试。', '心心', 'http://localhost/blog/img/avatar/psb2.png', '2016-08-08 16:18:34', 1),
(2016072402, 276, '', '', '&lt;author==true&gt;大家好，我是天边。', '天边', '/blog/img/avatar/skyside.png', '2016-08-13 07:49:31', 1),
(2016081602, 291, '', '', '&lt;author==true&gt;这是[:grin:]第一个有表情的评论~~~[:cool:][:cool:][:cool:]', '洛轩', '/blog/img/avatar/5.jpg', '2016-08-16 14:27:55', 1),
(2016081602, 292, '', '294,295,', '&lt;author==true&gt;心心你太帅了 [:lol:][:lol:][:lol:]，我要给你生猴子~~[:cool:][:cool:]~~', '冬眠', '/blog/img/avatar/3.jpg', '2016-08-16 14:32:26', 1),
(2016081602, 294, '292', '', '&lt;author==true&gt;回复@@@292-冬眠@@：冬眠晚上好~', '洛轩', '/blog/img/avatar/5.jpg', '2016-08-17 12:07:56', 1),
(2016081602, 295, '292', '', '&lt;author==true&gt;回复@@@294-洛轩@@：洛轩晚上好啊~', '冬眠', '/blog/img/avatar/3.jpg', '2016-08-17 14:38:32', 1),
(2016081505, 296, '', '', '&lt;author==true&gt;[:lol:][:muse:]好久不见。', '天边', '/blog/img/avatar/5.jpg', '2017-02-11 13:06:37', 0),
(0, 298, '', '', '&lt;author==true&gt;皓，下午好，今天是第一天，将博客重新改了一下，2018加油加油~ [:cool:][:grin:][:eye:]', 'Ming', '/blog/img/avatar/5.jpg', '2018-01-02 08:32:21', 0);
-- --------------------------------------------------------
--
-- 表的结构 `recycle`
--
DROP TABLE IF EXISTS `recycle`;
CREATE TABLE IF NOT EXISTS `recycle` (
`article_id` int(11) NOT NULL COMMENT '文章ID号',
`title` char(40) CHARACTER SET utf8 NOT NULL DEFAULT '无题' COMMENT '标题',
`link` char(100) CHARACTER SET utf8 DEFAULT NULL,
`user` char(20) CHARACTER SET utf8 NOT NULL DEFAULT '天边' COMMENT '用户',
`content` text CHARACTER SET utf8 COMMENT '内容',
`head_pic` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '/blog/img/title/default.png' COMMENT '文章列表显示的默认头图',
`class` char(20) CHARACTER SET utf8 NOT NULL DEFAULT '未分类' COMMENT '分类',
`keywords` char(50) CHARACTER SET utf8 DEFAULT NULL,
`pub_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发表时间',
`click` int(11) NOT NULL DEFAULT '0' COMMENT '点击数',
`comment` int(10) NOT NULL DEFAULT '0',
`fav` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`article_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
--
-- 表的结构 `user`
--
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
`username` varchar(100) COLLATE utf8_bin NOT NULL,
`password` varchar(100) COLLATE utf8_bin NOT NULL,
`email` char(30) COLLATE utf8_bin NOT NULL,
`avatar` varchar(100) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- 转存表中的数据 `user`
--
INSERT INTO `user` (`username`, `password`, `email`, `avatar`) VALUES
('天边', '80b9104949fd51e6c71a52aced47c667755d3451', '616315821@qq.com', 'skyside.png');
-- --------------------------------------------------------
--
-- 表的结构 `works`
--
DROP TABLE IF EXISTS `works`;
CREATE TABLE IF NOT EXISTS `works` (
`works_id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '未命名项目',
`description` varchar(300) COLLATE utf8_bin NOT NULL,
`head_pic` varchar(100) COLLATE utf8_bin NOT NULL,
`url` varchar(100) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`works_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- 转存表中的数据 `works`
--
INSERT INTO `works` (`works_id`, `name`, `description`, `head_pic`, `url`) VALUES
(14, '轮播图demo', '这是第一次jquery实战的demo', '/blog/img/title/0b2cf1273342800f8008fb0281e58469dc0c1eb5b11b-8aUTqX_fw658.png', 'http://dreamer-somebody.github.io/demo/');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;