master

分支 (1)

管理

管理

master

bokexitong
/
blog.sql

/*
MySQL Data Transfer
Source Host: localhost
Source Database: blog
Target Host: localhost
Target Database: blog
Date: 2017/5/20 14:30:02
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `username` varchar(255) NOT NULL COMMENT '用户名',
  `auth_key` varchar(32) NOT NULL COMMENT '自动登录key',
  `password_hash` varchar(255) NOT NULL COMMENT '加密密码',
  `password_reset_token` varchar(255) NOT NULL COMMENT '重置密码token',
  `email_validate_token` varchar(255) NOT NULL COMMENT '邮箱验证token',
  `email` varchar(255) NOT NULL COMMENT '邮箱',
  `role` smallint(6) NOT NULL DEFAULT '10' COMMENT '角色等级',
  `status` smallint(6) NOT NULL DEFAULT '10' COMMENT '状态',
  `avatar` varchar(255) NOT NULL COMMENT '头像',
  `vip_lv` int(11) NOT NULL DEFAULT '0' COMMENT 'vip等级',
  `created_at` int(11) NOT NULL COMMENT '创建时间',
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='会员表';

-- ----------------------------
-- Table structure for cats
-- ----------------------------
DROP TABLE IF EXISTS `cats`;
CREATE TABLE `cats` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `cat_name` varchar(255) DEFAULT NULL COMMENT '分类名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='文章';

-- ----------------------------
-- Table structure for feeds
-- ----------------------------
DROP TABLE IF EXISTS `feeds`;
CREATE TABLE `feeds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `content` varchar(255) NOT NULL COMMENT '内容',
  `created_at` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='聊天信息表';

-- ----------------------------
-- Table structure for post_extends
-- ----------------------------
DROP TABLE IF EXISTS `post_extends`;
CREATE TABLE `post_extends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) DEFAULT NULL COMMENT '文章id',
  `browser` int(11) DEFAULT '0' COMMENT '浏览量',
  `comment` int(11) DEFAULT '0' COMMENT '评论',
  `praise` int(11) DEFAULT '0' COMMENT '点赞',
  `collect` int(11) DEFAULT '0' COMMENT '收藏量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for posts
-- ----------------------------
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `summary` varchar(255) DEFAULT NULL COMMENT '摘要',
  `content` text COMMENT '内容',
  `label_img` varchar(255) DEFAULT NULL COMMENT '标签图',
  `cat_id` int(11) DEFAULT NULL COMMENT '分类ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `user_name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `is_valid` tinyint(1) DEFAULT '0' COMMENT '是否有效：0-未发布 1-已发布',
  `created_at` int(11) DEFAULT NULL COMMENT '创建时间',
  `updated_at` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_cat_valid` (`cat_id`,`is_valid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8 COMMENT='文章';

-- ----------------------------
-- Table structure for relation_post_tags
-- ----------------------------
DROP TABLE IF EXISTS `relation_post_tags`;
CREATE TABLE `relation_post_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `post_id` int(11) DEFAULT NULL COMMENT '文章ID',
  `tag_id` int(11) DEFAULT NULL COMMENT '标签ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `post_id` (`post_id`,`tag_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='文章和标签关系表';

-- ----------------------------
-- Table structure for tags
-- ----------------------------
DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `tag_name` varchar(255) DEFAULT NULL COMMENT '标签名称',
  `post_num` int(11) DEFAULT '0' COMMENT '关联文章数',
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_name` (`tag_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='标签表';

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `username` varchar(255) NOT NULL COMMENT '用户名',
  `auth_key` varchar(32) NOT NULL COMMENT '自动登录key',
  `password_hash` varchar(255) NOT NULL COMMENT '加密密码',
  `password_reset_token` varchar(255) NOT NULL COMMENT '重置密码token',
  `email_validate_token` varchar(255) NOT NULL COMMENT '邮箱验证token',
  `email` varchar(255) NOT NULL COMMENT '邮箱',
  `role` smallint(6) NOT NULL DEFAULT '10' COMMENT '角色等级',
  `status` smallint(6) NOT NULL DEFAULT '10' COMMENT '状态',
  `avatar` varchar(255) NOT NULL COMMENT '头像',
  `vip_lv` int(11) NOT NULL DEFAULT '0' COMMENT 'vip等级',
  `created_at` int(11) NOT NULL COMMENT '创建时间',
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='会员表';

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'oDD9pAo54n10psgY23att5sPOws46zXp', '$2y$13$v3X.TUxvOlR6NVNA.9nQR.OacBI9aGi3QAR.c.4O.kYDfIsQsaBqi', '', '', '1334514199@qq.com', '10', '10', '', '0', '1477903951', '1477903951');
INSERT INTO `cats` VALUES ('5', '分类1');
INSERT INTO `cats` VALUES ('6', '分类2');
INSERT INTO `post_extends` VALUES ('2', '122', '5', '0', '0', '0');
INSERT INTO `post_extends` VALUES ('3', '134', '11', '0', '0', '0');
INSERT INTO `post_extends` VALUES ('4', '123', '1', '0', '0', '0');
INSERT INTO `posts` VALUES ('122', '新兰新兰', '撒地方是否撒地方', '<p>撒地方是否撒地方</p>', '/image/20161102/1478089213263655.jpg', null, '1', 'xinlan', '1', '1478089218', '1478089218');
INSERT INTO `posts` VALUES ('134', '科技新闻', '今天要赞美一下 Burberry（的广告）。迎来 160 周年的英国奢侈品牌于昨日公布了一支 3 分半的广告大片：《品牌创始人 Thomas Burberry 的传奇故事》，拉开了', '<p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 24px; color: rgb(54, 54, 54); font-family: Arial, &quot;Hiragino Sans GB&quot;, 冬青黑, &quot;Microsoft YaHei&quot;, 微软雅黑, SimSun, 宋体, Helvetica, Tahoma, &quot;Arial sans-serif&quot;; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);\">今天要赞美一下 Burberry（的广告）。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 24px; color: rgb(54, 54, 54); font-family: Arial, &quot;Hiragino Sans GB&quot;, 冬青黑, &quot;Microsoft YaHei&quot;, 微软雅黑, SimSun, 宋体, Helvetica, Tahoma, &quot;Arial sans-serif&quot;; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);\">迎来 160 周年的英国奢侈品牌于昨日公布了一支 3 分半的广告大片：《品牌创始人 Thomas Burberry 的传奇故事》，拉开了今年圣诞广告大战的序幕。</p><p><br/></p><p></p><figure style=\"box-sizing: border-box; margin: 0px;\"><img alt=\"\" data-ratio=\"0.647696\" data-format=\"jpeg\" class=\" lazyloaded\" data-src=\"http://img.qdaily.com/uploads/20161102182445rCFmu648nYgy27LI.jpg-WebpWebW640\" src=\"http://img.qdaily.com/uploads/20161102182445rCFmu648nYgy27LI.jpg-WebpWebW640\" style=\"box-sizing: border-box; border: 0px; vertical-align: top; opacity: 1; transition: opacity 0.5s; display: block; margin: 0px auto 16px; width: 575px; height: 372.425px; max-width: 100%;\"/></figure><p></p><p><br/></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 24px; color: rgb(54, 54, 54); font-family: Arial, &quot;Hiragino Sans GB&quot;, 冬青黑, &quot;Microsoft YaHei&quot;, 微软雅黑, SimSun, 宋体, Helvetica, Tahoma, &quot;Arial sans-serif&quot;; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);\">短片以半真实、半虚构的形式再现了 Burberry 品牌创始人 Thomas Burberry 一生中的关键历史时刻。整支广告的拍摄制作堪比好莱坞大片预告的水准，仅上线一天，就在 YouTube 上获得了 178 万次观看。', '/image/20161102/1478096114108650.jpg', null, '1', 'xinlan', '1', '1478096157', '1478096157');
INSERT INTO `relation_post_tags` VALUES ('66', '122', '36');
INSERT INTO `tags` VALUES ('36', '犬夜叉', '1');
INSERT INTO `user` VALUES ('1', 'xinlan', 'oDD9pAo54n10psgY23att5sPOws46zXp', '$2y$13$v3X.TUxvOlR6NVNA.9nQR.OacBI9aGi3QAR.c.4O.kYDfIsQsaBqi', '', '', '1334514199@qq.com', '10', '10', '', '0', '1477903951', '1477903951');