/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50711
Source Host           : localhost:3306
Source Database       : blog

Target Server Type    : MYSQL
Target Server Version : 50711
File Encoding         : 65001

Date: 2016-12-27 17:12:40
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for bg_admin
-- ----------------------------
DROP TABLE IF EXISTS `bg_admin`;
CREATE TABLE `bg_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `headimg` varchar(255) DEFAULT NULL,
  `lastdate` int(11) DEFAULT NULL,
  `loginnum` int(11) DEFAULT '0',
  `is_admin` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for bg_article
-- ----------------------------
DROP TABLE IF EXISTS `bg_article`;
CREATE TABLE `bg_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cateid` int(11) NOT NULL COMMENT '分类',
  `title` varchar(255) NOT NULL COMMENT '文章标题',
  `author` varchar(255) NOT NULL COMMENT '作者',
  `artid` int(1) NOT NULL COMMENT '发布者',
  `profiles` varchar(255) NOT NULL COMMENT '简介',
  `content` text NOT NULL COMMENT '文章内容',
  `creattime` int(11) NOT NULL COMMENT '发布时间',
  `updatetime` int(11) NOT NULL COMMENT '更新时间',
  `hits` int(11) DEFAULT '0' COMMENT '点击量',
  `is_home` int(1) DEFAULT '0' COMMENT '是否首页显示',
  `is_top` int(1) DEFAULT '0' COMMENT '是否顶置',
  `bigimg` varchar(255) NOT NULL COMMENT '大图地址',
  `smallimg` varchar(255) NOT NULL COMMENT '小图地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for bg_cate
-- ----------------------------
DROP TABLE IF EXISTS `bg_cate`;
CREATE TABLE `bg_cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cate` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cate` (`cate`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for bg_comment
-- ----------------------------
DROP TABLE IF EXISTS `bg_comment`;
CREATE TABLE `bg_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论id',
  `name` varchar(255) NOT NULL COMMENT '评论者',
  `time` int(11) NOT NULL COMMENT '评论时间',
  `comtId` int(11) DEFAULT '0' COMMENT '评论id',
  `toname` varchar(255) DEFAULT NULL COMMENT '对谁回复',
  `toart` int(11) NOT NULL COMMENT '评论文章id',
  `email` varchar(255) NOT NULL COMMENT '评论者的邮箱',
  `comment` varchar(255) NOT NULL COMMENT '评论内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for bg_msg
-- ----------------------------
DROP TABLE IF EXISTS `bg_msg`;
CREATE TABLE `bg_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `msg` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;