-- MySQL dump 10.14  Distrib 5.5.56-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: blog_tbbbearing
-- ------------------------------------------------------
-- Server version	5.5.56-MariaDB

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `barticle`
--

DROP TABLE IF EXISTS `barticle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `barticle` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章表主键',
  `title` char(100) NOT NULL DEFAULT '' COMMENT '标题',
  `author` varchar(15) NOT NULL DEFAULT '' COMMENT '作者',
  `content` mediumtext NOT NULL COMMENT '文章内容',
  `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字',
  `description` char(255) NOT NULL DEFAULT '' COMMENT '描述',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '文章是否显示 1是 0否',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除 1是 0否',
  `is_top` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶 1是 0否',
  `is_original` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否原创',
  `click` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击数',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `cid` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
  PRIMARY KEY (`aid`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `barticle`
--

LOCK TABLES `barticle` WRITE;
/*!40000 ALTER TABLE `barticle` DISABLE KEYS */;
INSERT INTO `barticle` VALUES (17,'测试文章标题','白俊遥','<p>测试文章内容<img alt="白俊遥博客" src="/Upload/image/ueditor/20150601/1433171136139793.jpg" title="白俊遥博客"/></p>','关键词,多个','测试文章描述',1,1,1,1,376,1432649909,28),(18,'中午吃啥呢，','tbbbearing','<p><br/></p><p>中午吃啥呢，中午吃啥呢，</p><p>中午吃啥呢，中午吃啥呢，</p><p>中午吃啥呢，中午吃啥呢，</p><p><br/></p><p><img src="http://blog.tbbbearing.com/Upload/image/ueditor/20181228/1545977680539876.png" title="白俊遥博客" alt="白俊遥博客" style="white-space: normal;"/></p><audio controls="controls" style="display: none;"></audio>','','中午吃啥呢，中午吃啥呢，中午吃啥呢，中午吃啥呢，中午吃啥呢，中午吃啥呢，',1,0,0,1,7,1545977294,29);
/*!40000 ALTER TABLE `barticle` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `barticle_pic`
--

DROP TABLE IF EXISTS `barticle_pic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `barticle_pic` (
  `ap_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `path` varchar(100) NOT NULL DEFAULT '' COMMENT '图片路径',
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属文章id',
  PRIMARY KEY (`ap_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `barticle_pic`
--

LOCK TABLES `barticle_pic` WRITE;
/*!40000 ALTER TABLE `barticle_pic` DISABLE KEYS */;
INSERT INTO `barticle_pic` VALUES (11,'/Upload/image/ueditor/20150601/1433171136139793.jpg',17),(14,'/Upload/image/ueditor/20181228/1545977680539876.png',18);
/*!40000 ALTER TABLE `barticle_pic` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `barticle_tag`
--

DROP TABLE IF EXISTS `barticle_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `barticle_tag` (
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文章id',
  `tid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '标签id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `barticle_tag`
--

LOCK TABLES `barticle_tag` WRITE;
/*!40000 ALTER TABLE `barticle_tag` DISABLE KEYS */;
INSERT INTO `barticle_tag` VALUES (17,20),(18,22),(18,23),(18,24);
/*!40000 ALTER TABLE `barticle_tag` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bcategory`
--

DROP TABLE IF EXISTS `bcategory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bcategory` (
  `cid` tinyint(2) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类主键id',
  `cname` varchar(15) NOT NULL DEFAULT '' COMMENT '分类名称',
  `keywords` varchar(255) DEFAULT '' COMMENT '关键词',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  `sort` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `pid` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '父级栏目id',
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bcategory`
--

LOCK TABLES `bcategory` WRITE;
/*!40000 ALTER TABLE `bcategory` DISABLE KEYS */;
INSERT INTO `bcategory` VALUES (29,'分类1','','',0,0),(30,'分类2','分类2','分类2',0,0);
/*!40000 ALTER TABLE `bcategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bchat`
--

DROP TABLE IF EXISTS `bchat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bchat` (
  `chid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '碎言id',
  `date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发表时间',
  `content` text NOT NULL COMMENT '内容',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`chid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bchat`
--

LOCK TABLES `bchat` WRITE;
/*!40000 ALTER TABLE `bchat` DISABLE KEYS */;
INSERT INTO `bchat` VALUES (2,1432827004,'测试随言碎语',1,0),(3,1444529995,'测试碎言',1,0),(4,1545978379,'你干哈',1,0);
/*!40000 ALTER TABLE `bchat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bcomment`
--

DROP TABLE IF EXISTS `bcomment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bcomment` (
  `cmtid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `ouid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论用户id 关联oauth_user表的id',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1：文章评论',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
  `aid` int(10) unsigned NOT NULL COMMENT '文章id',
  `content` text NOT NULL COMMENT '内容',
  `date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论日期',
  `status` tinyint(1) unsigned NOT NULL COMMENT '1:已审核 0：未审核',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`cmtid`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bcomment`
--

LOCK TABLES `bcomment` WRITE;
/*!40000 ALTER TABLE `bcomment` DISABLE KEYS */;
INSERT INTO `bcomment` VALUES (19,1,1,0,17,'测试评论<img src="/Public/emote/tuzki/t_0002.gif" title="Love" alt="白俊遥博客">',1445747059,1,0),(21,1,1,19,17,'测试回复',1447943018,1,0),(29,0,1,0,18,'Please login to post a comment',1545980441,1,0),(30,0,1,0,18,'Please login to post a comment',1545980569,1,0),(31,0,1,0,18,'Please login to post a comment',1545981160,1,0),(32,0,1,0,18,'fdasfas',1545981182,1,0),(33,0,1,0,18,'Please login to post a comment',1545988355,1,0);
/*!40000 ALTER TABLE `bcomment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bconfig`
--

DROP TABLE IF EXISTS `bconfig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bconfig` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '配置项键名',
  `value` text COMMENT '配置项键值 1表示开启 0 关闭',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bconfig`
--

LOCK TABLES `bconfig` WRITE;
/*!40000 ALTER TABLE `bconfig` DISABLE KEYS */;
INSERT INTO `bconfig` VALUES (1,'WEB_NAME','Tbbblog'),(2,'WEB_KEYWORDS','Tbbblog'),(3,'WEB_DESCRIPTION','Tbbblog'),(4,'WEB_STATUS','1'),(5,'ADMIN_PASSWORD','21232f297a57a5a743894a0e4a801fc3'),(6,'WATER_TYPE','1'),(7,'TEXT_WATER_WORD','blog.tbbbearing.com'),(8,'TEXT_WATER_TTF_PTH','./Public/static/font/ariali.ttf'),(9,'TEXT_WATER_FONT_SIZE','15'),(10,'TEXT_WATER_COLOR','#008CBA'),(11,'TEXT_WATER_ANGLE','0'),(12,'TEXT_WATER_LOCATE','9'),(13,'IMAGE_WATER_PIC_PTAH','./Upload/image/logo/logo.png'),(14,'IMAGE_WATER_LOCATE','9'),(15,'IMAGE_WATER_ALPHA','80'),(16,'WEB_CLOSE_WORD','In the website upgrade, please visit later.'),(17,'WEB_ICP_NUMBER',''),(18,'ADMIN_EMAIL','tbb@tbbprovision.com'),(19,'COPYRIGHT_WORD','This article is an original TBB article, reprinted without contact with me, but please note that it is from TBB blog baijunyao.com.'),(20,'QQ_APP_ID',''),(21,'CHANGYAN_APP_ID','cyrKRbJ5N'),(22,'CHANGYAN_CONF','prod_c654661caf5ab6da98742d040413815b'),(23,'WEB_STATISTICS',''),(24,'CHANGEYAN_RETURN_COMMENT',''),(25,'AUTHOR','tbbbearing'),(26,'QQ_APP_KEY',''),(27,'CHANGYAN_COMMENT',''),(28,'BAIDU_SITE_URL',''),(29,'DOUBAN_API_KEY',''),(30,'DOUBAN_SECRET',''),(31,'RENREN_API_KEY',''),(32,'RENREN_SECRET',''),(33,'SINA_API_KEY',''),(34,'SINA_SECRET',''),(35,'KAIXIN_API_KEY',''),(36,'KAIXIN_SECRET',''),(37,'SOHU_API_KEY',''),(38,'SOHU_SECRET',''),(39,'GITHUB_CLIENT_ID',''),(40,'GITHUB_CLIENT_SECRET',''),(41,'IMAGE_TITLE_ALT_WORD','Tbbblog'),(42,'EMAIL_SMTP',''),(43,'EMAIL_USERNAME',''),(44,'EMAIL_PASSWORD',''),(45,'EMAIL_FROM_NAME',''),(46,'COMMENT_REVIEW','1'),(47,'COMMENT_SEND_EMAIL','0'),(48,'EMAIL_RECEIVE','');
/*!40000 ALTER TABLE `bconfig` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `blink`
--

DROP TABLE IF EXISTS `blink`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blink` (
  `lid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `lname` varchar(50) NOT NULL DEFAULT '' COMMENT '链接名',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '排序',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '文章是否显示 1是 0否',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除 1是 0否',
  PRIMARY KEY (`lid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `blink`
--

LOCK TABLES `blink` WRITE;
/*!40000 ALTER TABLE `blink` DISABLE KEYS */;
INSERT INTO `blink` VALUES (2,'白俊遥博客','http://baijunyao.com',1,1,1),(3,'Tbb provision','http://www.tbbbearing.com',1,1,0);
/*!40000 ALTER TABLE `blink` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `boauth_user`
--

DROP TABLE IF EXISTS `boauth_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boauth_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联的本站用户id',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '类型 1：QQ  2：新浪微博 3：豆瓣 4：人人 5：开心网',
  `nickname` varchar(30) NOT NULL DEFAULT '' COMMENT '第三方昵称',
  `head_img` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
  `openid` varchar(40) NOT NULL DEFAULT '' COMMENT '第三方用户id',
  `access_token` varchar(255) NOT NULL DEFAULT '' COMMENT 'access_token token',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '绑定时间',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `last_login_ip` varchar(16) NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `login_times` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT '邮箱',
  `is_admin` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否是admin',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `boauth_user`
--

LOCK TABLES `boauth_user` WRITE;
/*!40000 ALTER TABLE `boauth_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `boauth_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `btag`
--

DROP TABLE IF EXISTS `btag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `btag` (
  `tid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '标签主键',
  `tname` varchar(10) NOT NULL DEFAULT '' COMMENT '标签名',
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `btag`
--

LOCK TABLES `btag` WRITE;
/*!40000 ALTER TABLE `btag` DISABLE KEYS */;
INSERT INTO `btag` VALUES (21,'tbbbearing'),(22,'erp'),(23,'吃饭'),(24,'睡觉'),(25,'打豆豆');
/*!40000 ALTER TABLE `btag` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-01-08 21:31:54