/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50624 Source Host : localhost:3306 Source Database : novel_plus Target Server Type : MYSQL Target Server Version : 50624 File Encoding : 65001 Date: 2020-05-13 21:42:20 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for author -- ---------------------------- DROP TABLE IF EXISTS `author`; CREATE TABLE `author` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID', `invite_code` varchar(20) DEFAULT NULL COMMENT '邀请码', `pen_name` varchar(20) DEFAULT NULL COMMENT '笔名', `tel_phone` varchar(20) DEFAULT NULL COMMENT '手机号码', `chat_account` varchar(50) DEFAULT NULL COMMENT 'QQ或微信账号', `email` varchar(50) DEFAULT NULL COMMENT '电子邮箱', `work_direction` tinyint(4) DEFAULT NULL COMMENT '作品方向,0:男频,1:女频', `status` tinyint(4) DEFAULT '0' COMMENT '0:正常,1:封禁', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='作者表'; -- ---------------------------- -- Records of author -- ---------------------------- INSERT INTO `author` VALUES ('1', null, 'reerer', 'abc', '13560487656', '23484388', '23484388@qq.com', '0', '0', null); INSERT INTO `author` VALUES ('2', '1255060328322027520', 'rwrr445554', '梦入神机', '13560421324', '1179705413', 'reerer@qq.com', '0', '0', '2020-05-13 14:01:31'); -- ---------------------------- -- Table structure for author_code -- ---------------------------- DROP TABLE IF EXISTS `author_code`; CREATE TABLE `author_code` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `invite_code` varchar(100) DEFAULT NULL COMMENT '邀请码', `validity_time` datetime DEFAULT NULL COMMENT '有效时间', `is_use` tinyint(1) DEFAULT '0' COMMENT '是否使用过,0:未使用,1:使用过', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人ID', PRIMARY KEY (`id`), UNIQUE KEY `key_code` (`invite_code`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='作家邀请码表'; -- ---------------------------- -- Records of author_code -- ---------------------------- INSERT INTO `author_code` VALUES ('3', 'reerer', '2020-05-27 22:43:45', '1', '2020-05-13 11:40:56', '1'); INSERT INTO `author_code` VALUES ('4', '123456', '2020-05-28 00:00:00', '0', '2020-05-13 14:09:55', '1'); INSERT INTO `author_code` VALUES ('5', 'ww34343', '2020-05-21 00:00:00', '0', '2020-05-13 14:18:58', '1'); -- ---------------------------- -- Table structure for user_buy_record -- ---------------------------- DROP TABLE IF EXISTS `user_buy_record`; CREATE TABLE `user_buy_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `book_id` bigint(20) DEFAULT NULL COMMENT '购买的小说ID', `book_name` varchar(50) DEFAULT NULL COMMENT '购买的小说名', `book_index_id` bigint(20) DEFAULT NULL COMMENT '购买的章节ID', `book_index_name` varchar(100) DEFAULT NULL COMMENT '购买的章节名', `buy_amount` int(11) DEFAULT NULL COMMENT '购买使用的屋币数量', `create_time` datetime DEFAULT NULL COMMENT '购买时间', PRIMARY KEY (`id`), UNIQUE KEY `key_userId_indexId` (`user_id`,`book_index_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='用户消费记录表'; -- ---------------------------- -- Records of user_buy_record -- ---------------------------- INSERT INTO `user_buy_record` VALUES ('1', '1255060328322027520', '1260400284744613890', '我是一只消消乐2', '1260522024606953472', '第三章', '10', '2020-05-13 21:29:09'); INSERT INTO `user_buy_record` VALUES ('2', '1255060328322027520', '1260400284744613890', '我是一只消消乐2', '1260564410687107072', '第四章', '10', '2020-05-13 21:40:38');