/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80025
 Source Host           : localhost:3306
 Source Schema         : novelweb

 Target Server Type    : MySQL
 Target Server Version : 80025
 File Encoding         : 65001

 Date: 13/12/2021 14:25:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for author
-- ----------------------------
DROP TABLE IF EXISTS `author`;
CREATE TABLE `author`  (
  `nick_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '男' COMMENT '性别',
  `subscriptions` int(0) NULL DEFAULT 0,
  `collections` int(0) NULL DEFAULT 0,
  `concerns` int(0) NULL DEFAULT 0,
  `footmark` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '足迹',
  `works` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作品',
  `fans` int(0) NULL DEFAULT 0 COMMENT '粉丝',
  `password` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `headimage` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户头像',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  PRIMARY KEY (`nick_name`) USING BTREE,
  INDEX `FK_authfootmark`(`footmark`) USING BTREE,
  INDEX `FK_authwork`(`works`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for author_work_novel
-- ----------------------------
DROP TABLE IF EXISTS `author_work_novel`;
CREATE TABLE `author_work_novel`  (
  `novel_author` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `novel_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `creat_time` date NULL DEFAULT NULL,
  `id` int(0) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK_worknavel`(`novel_name`) USING BTREE,
  INDEX `navel_author`(`novel_author`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for book_status
-- ----------------------------
DROP TABLE IF EXISTS `book_status`;
CREATE TABLE `book_status`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `bookName` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `bookStatus` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `novel_bookStatus`(`bookName`) USING BTREE,
  CONSTRAINT `novel_bookStatus` FOREIGN KEY (`bookName`) REFERENCES `novel` (`book_name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for catalog
-- ----------------------------
DROP TABLE IF EXISTS `catalog`;
CREATE TABLE `catalog`  (
  `novel_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `novale_catalog` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `updatetime` date NOT NULL,
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `vip` int(0) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `navel_name`(`novel_name`) USING BTREE,
  INDEX `novale_catalog`(`novale_catalog`) USING BTREE,
  CONSTRAINT `FK_catlog_novel` FOREIGN KEY (`novel_name`) REFERENCES `novel` (`book_name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 593420 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for catlog_content
-- ----------------------------
DROP TABLE IF EXISTS `catlog_content`;
CREATE TABLE `catlog_content`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `novelname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `catlogname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `content` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `catlognameIndex`(`catlogname`) USING BTREE,
  INDEX `catlognovelnameindex`(`novelname`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 855037 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for comment_rules
-- ----------------------------
DROP TABLE IF EXISTS `comment_rules`;
CREATE TABLE `comment_rules`  (
  `rule_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规则名',
  `rule_list` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规则内容',
  PRIMARY KEY (`rule_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评论规则表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for consumption_record
-- ----------------------------
DROP TABLE IF EXISTS `consumption_record`;
CREATE TABLE `consumption_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `amount` float(11, 2) NOT NULL,
  `pay_time` datetime(0) NOT NULL,
  `pay_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_username`(`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for footmarks
-- ----------------------------
DROP TABLE IF EXISTS `footmarks`;
CREATE TABLE `footmarks`  (
  `user_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `novle_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `visit_time` date NOT NULL,
  INDEX `user_name`(`user_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for novel
-- ----------------------------
DROP TABLE IF EXISTS `novel`;
CREATE TABLE `novel`  (
  `book_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '小说名',
  `book_type` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小说类型',
  `book_author` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '小说作者',
  `book_state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '小说状态',
  `book_words` int(0) NULL DEFAULT 0 COMMENT '小说字数',
  `book_intro` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '小说简介',
  `book_catalog` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小说目录',
  `update_time` date NOT NULL COMMENT '最近更新时间',
  `monthly_tickets` int(0) NULL DEFAULT 0 COMMENT '月票数',
  `total_hits` int(0) NULL DEFAULT 0 COMMENT '总点击量',
  `monthly_hits` int(0) NULL DEFAULT 0 COMMENT '月点击',
  `weekly_hits` int(0) NULL DEFAULT 0 COMMENT '周点击',
  `daily_hits` int(0) NULL DEFAULT 0 COMMENT '日点击',
  `total_collections` int(0) NULL DEFAULT 0 COMMENT '总收藏',
  `monthly_collections` int(0) NULL DEFAULT 0 COMMENT '月收藏',
  `weekly_collections` int(0) NULL DEFAULT 0 COMMENT '周收藏',
  `daily_collections` int(0) NULL DEFAULT 0 COMMENT '日收藏',
  `downloads` int(0) NULL DEFAULT 0 COMMENT '下载量',
  `comments` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论数',
  PRIMARY KEY (`book_name`) USING BTREE,
  INDEX `FK_novelcomment`(`comments`) USING BTREE,
  INDEX `FK_type`(`book_type`) USING BTREE,
  INDEX `FK_catlog`(`book_catalog`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for novel_comments
-- ----------------------------
DROP TABLE IF EXISTS `novel_comments`;
CREATE TABLE `novel_comments`  (
  `novel_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comment_id` int(0) NOT NULL,
  `id` int(0) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `navel_name`(`novel_name`) USING BTREE,
  INDEX `FK_novelcombook`(`comment_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for novel_db
-- ----------------------------
DROP TABLE IF EXISTS `novel_db`;
CREATE TABLE `novel_db`  (
  `novel_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `db_id` int(0) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for novel_type
-- ----------------------------
DROP TABLE IF EXISTS `novel_type`;
CREATE TABLE `novel_type`  (
  `novel_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `N_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`N_type`, `novel_name`) USING BTREE,
  INDEX `novel_name`(`novel_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for noveltype
-- ----------------------------
DROP TABLE IF EXISTS `noveltype`;
CREATE TABLE `noveltype`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `typename` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `typename`(`typename`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reader_bookshelf
-- ----------------------------
DROP TABLE IF EXISTS `reader_bookshelf`;
CREATE TABLE `reader_bookshelf`  (
  `reader_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `novel_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `bookmark` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `reader_name`(`reader_name`) USING BTREE,
  CONSTRAINT `FK_bookshelf` FOREIGN KEY (`reader_name`) REFERENCES `readers` (`nick_name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reader_bought_catalogs
-- ----------------------------
DROP TABLE IF EXISTS `reader_bought_catalogs`;
CREATE TABLE `reader_bought_catalogs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `novel_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `catalog_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_time` date NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_usernam`(`username`, `novel_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reader_collection
-- ----------------------------
DROP TABLE IF EXISTS `reader_collection`;
CREATE TABLE `reader_collection`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `reader_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `noval_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `reader_name`(`reader_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reader_comment
-- ----------------------------
DROP TABLE IF EXISTS `reader_comment`;
CREATE TABLE `reader_comment`  (
  `reader_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comment_title` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comment_id` int(0) NOT NULL,
  `id` int(0) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `reader_name`(`reader_name`) USING BTREE,
  INDEX `FK_readcom`(`comment_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reader_concerns
-- ----------------------------
DROP TABLE IF EXISTS `reader_concerns`;
CREATE TABLE `reader_concerns`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `reader_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `auth_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reader_recharge_record
-- ----------------------------
DROP TABLE IF EXISTS `reader_recharge_record`;
CREATE TABLE `reader_recharge_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `amount` float(11, 2) NOT NULL,
  `recharge_time` datetime(0) NOT NULL,
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_username`(`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reader_subscribed
-- ----------------------------
DROP TABLE IF EXISTS `reader_subscribed`;
CREATE TABLE `reader_subscribed`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `reader_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `noval_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `reader_name`(`reader_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for readers
-- ----------------------------
DROP TABLE IF EXISTS `readers`;
CREATE TABLE `readers`  (
  `nick_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '男' COMMENT '性别',
  `birthday` date NULL DEFAULT NULL COMMENT '生日',
  `intro` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人简介',
  `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `fans` int(0) NULL DEFAULT 0 COMMENT '粉丝数',
  `mybookshelf` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '书架',
  `collection_novels` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收藏的小说',
  `subscribed_novels` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '足迹',
  `footmark` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '足迹',
  `account_balance` float(11, 2) NULL DEFAULT 0.00 COMMENT '账户余额',
  `monthly_tickets` int(0) NULL DEFAULT 0 COMMENT '月票数',
  `mycomments` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论',
  `vip` int(0) NULL DEFAULT 0 COMMENT 'vip等级',
  `access` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '是' COMMENT '允许访问主页',
  `password` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `headimage` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户头像',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  PRIMARY KEY (`nick_name`) USING BTREE,
  INDEX `FK_readerfoot`(`footmark`) USING BTREE,
  INDEX `FK_readercomment`(`mycomments`) USING BTREE,
  INDEX `FK_readerbookshelf`(`mybookshelf`) USING BTREE,
  INDEX `FK_readercollection`(`collection_novels`) USING BTREE,
  INDEX `FK_readersubscrib`(`subscribed_novels`) USING BTREE,
  CONSTRAINT `FK_readerbookshelf` FOREIGN KEY (`mybookshelf`) REFERENCES `reader_bookshelf` (`reader_name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_readercollection` FOREIGN KEY (`collection_novels`) REFERENCES `reader_collection` (`reader_name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_readercomment` FOREIGN KEY (`mycomments`) REFERENCES `reader_comment` (`reader_name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_readerfoot` FOREIGN KEY (`footmark`) REFERENCES `footmarks` (`user_name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_readersubscrib` FOREIGN KEY (`subscribed_novels`) REFERENCES `reader_subscribed` (`reader_name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user_status
-- ----------------------------
DROP TABLE IF EXISTS `user_status`;
CREATE TABLE `user_status`  (
  `nick_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `status` int(0) NOT NULL COMMENT '账号状态',
  `describe` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `deadlines` date NULL DEFAULT NULL COMMENT '截止日期',
  `identity` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封号类型',
  PRIMARY KEY (`nick_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for usercomment
-- ----------------------------
DROP TABLE IF EXISTS `usercomment`;
CREATE TABLE `usercomment`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `comment_title` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comment_context` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comment_author` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comment_time` datetime(0) NOT NULL,
  `comment_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `comment_title`(`comment_title`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `sex` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `headimg` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `age` int(0) NULL DEFAULT NULL COMMENT '年龄',
  `pwd_erro` int(0) NULL DEFAULT NULL COMMENT '密码错误次数（3次就锁定账号）',
  `user_status` int(0) NULL DEFAULT NULL COMMENT '账号状态（1：正常 2：已被锁定 3：封号）',
  `lock_until` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号锁定时间截止日期',
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;