/*
Navicat Premium Data Transfer
Source Server : novel
Source Server Type : MySQL
Source Server Version : 50724
Source Host : localhost:3306
Source Schema : novel
Target Server Type : MySQL
Target Server Version : 50724
File Encoding : 65001
Date: 01/06/2021 19:24:39
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL,
`name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`password` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, 'admin', '123456');
-- ----------------------------
-- Table structure for collect
-- ----------------------------
DROP TABLE IF EXISTS `collect`;
CREATE TABLE `collect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NULL DEFAULT NULL,
`type` tinyint(1) NULL DEFAULT NULL,
`novel_id` int(11) NULL DEFAULT NULL,
`novel_list_id` int(11) NULL DEFAULT NULL,
`chapterId` int(11) NULL DEFAULT NULL,
`create_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20069 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of collect
-- ----------------------------
INSERT INTO `collect` VALUES (31, 1, 1, 98, NULL, 7, '2021-02-25 21:24:22');
INSERT INTO `collect` VALUES (32, 1, 1, 522, NULL, 124, '2021-05-21 22:05:44');
INSERT INTO `collect` VALUES (33, 1, 1, 4746, NULL, 23, '2021-02-25 20:15:24');
INSERT INTO `collect` VALUES (34, 1, 1, 4469, NULL, 0, '2021-02-22 22:08:55');
INSERT INTO `collect` VALUES (36, 1, 1, 1731, NULL, 73, '2021-05-21 21:42:31');
INSERT INTO `collect` VALUES (38, 2, 1, 151, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (39, 2, 1, 4469, NULL, 1003, '2021-05-10 22:07:46');
INSERT INTO `collect` VALUES (40, 2, 1, 522, NULL, 7, '2021-02-25 21:24:22');
INSERT INTO `collect` VALUES (41, 2, 1, 4746, NULL, 0, '2021-02-22 22:05:24');
INSERT INTO `collect` VALUES (42, 2, 1, 12500, NULL, 23, '2021-02-25 20:15:24');
INSERT INTO `collect` VALUES (43, 2, 1, 20000, NULL, 0, '2021-03-20 16:52:26');
INSERT INTO `collect` VALUES (44, 9, 1, 545, NULL, 0, '2021-03-20 16:52:31');
INSERT INTO `collect` VALUES (45, 9, 1, 443, NULL, 0, '2021-03-20 16:52:33');
INSERT INTO `collect` VALUES (46, 9, 1, 4746, NULL, 0, '2021-03-20 16:52:37');
INSERT INTO `collect` VALUES (47, 9, 1, 1731, NULL, 0, '2021-03-20 16:52:40');
INSERT INTO `collect` VALUES (48, 9, 1, 93, NULL, 0, '2021-03-20 16:52:45');
INSERT INTO `collect` VALUES (49, 10, 1, 622, NULL, 0, '2021-03-20 16:53:07');
INSERT INTO `collect` VALUES (50, 10, 1, 4746, NULL, 0, '2021-03-20 16:53:10');
INSERT INTO `collect` VALUES (51, 10, 1, 665, NULL, 0, '2021-03-20 16:53:14');
INSERT INTO `collect` VALUES (52, 10, 1, 1111, NULL, 0, '2021-03-20 16:53:20');
INSERT INTO `collect` VALUES (53, 10, 1, 98, NULL, 0, '2021-03-20 16:53:24');
INSERT INTO `collect` VALUES (54, 11, 1, 98, NULL, 0, '2021-03-20 16:53:45');
INSERT INTO `collect` VALUES (55, 11, 1, 4746, NULL, 0, '2021-03-20 16:53:49');
INSERT INTO `collect` VALUES (56, 11, 1, 102, NULL, 0, '2021-03-20 18:39:56');
INSERT INTO `collect` VALUES (57, 11, 1, 1818, NULL, 0, '2021-03-20 16:53:58');
INSERT INTO `collect` VALUES (58, 11, 1, 30, NULL, 0, '2021-03-20 16:54:02');
INSERT INTO `collect` VALUES (19938, 14, 1, 42, NULL, 7, '2021-02-25 21:24:22');
INSERT INTO `collect` VALUES (19940, 14, 1, 422, NULL, 0, '2021-02-22 22:05:24');
INSERT INTO `collect` VALUES (19941, 14, 1, 4746, NULL, 23, '2021-02-25 20:15:24');
INSERT INTO `collect` VALUES (19942, 14, 1, 700, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19943, 14, 1, 2822, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19944, 14, 1, 1731, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19945, 14, 1, 6591, NULL, 1003, '2021-05-10 22:07:46');
INSERT INTO `collect` VALUES (19946, 14, 1, 98, NULL, 7, '2021-02-25 21:24:22');
INSERT INTO `collect` VALUES (19947, 14, 1, 10252, NULL, 0, '2021-02-22 22:05:24');
INSERT INTO `collect` VALUES (19948, 14, 1, 440, NULL, 0, '2021-02-25 20:15:24');
INSERT INTO `collect` VALUES (19949, 14, 1, 76, NULL, 0, '2021-02-22 22:08:55');
INSERT INTO `collect` VALUES (19950, 14, 1, 1731, NULL, 0, '2021-02-25 15:25:36');
INSERT INTO `collect` VALUES (19951, 14, 1, 89, NULL, 0, '2021-02-26 18:18:31');
INSERT INTO `collect` VALUES (19952, 14, 1, 1020, NULL, 0, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19953, 14, 1, 1222, NULL, 0, '2021-05-10 22:07:46');
INSERT INTO `collect` VALUES (19954, 14, 1, 42, NULL, 7, '2021-02-25 21:24:22');
INSERT INTO `collect` VALUES (19955, 14, 1, 422, NULL, 0, '2021-02-22 22:05:24');
INSERT INTO `collect` VALUES (19956, 14, 1, 590, NULL, 23, '2021-02-25 20:15:24');
INSERT INTO `collect` VALUES (19957, 15, 1, 3683, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19959, 15, 1, 1731, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19961, 15, 1, 52, NULL, 1003, '2021-05-10 22:07:46');
INSERT INTO `collect` VALUES (19963, 15, 1, 11125, NULL, 7, '2021-02-25 21:24:22');
INSERT INTO `collect` VALUES (19965, 15, 1, 5252, NULL, 0, '2021-02-22 22:05:24');
INSERT INTO `collect` VALUES (19967, 15, 1, 440, NULL, 23, '2021-02-25 20:15:24');
INSERT INTO `collect` VALUES (19969, 15, 1, 4746, NULL, 0, '2021-02-22 22:08:55');
INSERT INTO `collect` VALUES (19972, 15, 1, 17315, NULL, 28, '2021-05-18 23:03:07');
INSERT INTO `collect` VALUES (19973, 15, 1, 1442, NULL, 0, '2021-05-18 23:02:56');
INSERT INTO `collect` VALUES (19974, 16, 1, 261, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19975, 16, 1, 535, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19976, 16, 1, 1242, NULL, 1003, '2021-05-10 22:07:46');
INSERT INTO `collect` VALUES (19977, 16, 1, 98, NULL, 7, '2021-02-25 21:24:22');
INSERT INTO `collect` VALUES (19978, 15, 1, 522, NULL, 0, '2021-02-22 22:05:24');
INSERT INTO `collect` VALUES (19979, 16, 1, 5252, NULL, 23, '2021-02-25 20:15:24');
INSERT INTO `collect` VALUES (19980, 16, 1, 7675, NULL, 0, '2021-02-22 22:08:55');
INSERT INTO `collect` VALUES (19981, 16, 1, 7308, NULL, 28, '2021-02-25 15:25:36');
INSERT INTO `collect` VALUES (19982, 16, 1, 1442, NULL, 0, '2021-02-26 18:18:31');
INSERT INTO `collect` VALUES (19983, 17, 1, 14, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19984, 17, 1, 2522, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19985, 17, 1, 591, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19986, 17, 1, 2261, NULL, 1003, '2021-05-10 22:07:46');
INSERT INTO `collect` VALUES (19987, 17, 1, 145, NULL, 53, '2021-03-05 20:22:14');
INSERT INTO `collect` VALUES (19988, 17, 1, 4746, NULL, 1003, '2021-05-10 22:07:46');
INSERT INTO `collect` VALUES (19989, 17, 1, 1731, NULL, 7, '2021-02-25 21:24:22');
INSERT INTO `collect` VALUES (19990, 17, 1, 5234, NULL, 7, '2021-02-25 21:24:22');
INSERT INTO `collect` VALUES (19991, 17, 1, 42, NULL, 0, '2021-02-22 22:05:24');
INSERT INTO `collect` VALUES (19992, 17, 1, 5222, NULL, 0, '2021-02-22 22:05:24');
INSERT INTO `collect` VALUES (19993, 17, 1, 136, NULL, 23, '2021-02-25 20:15:24');
INSERT INTO `collect` VALUES (19994, 17, 1, 4469, NULL, 23, '2021-02-25 20:15:24');
INSERT INTO `collect` VALUES (19995, 17, 1, 7308, NULL, 0, '2021-02-22 22:08:55');
INSERT INTO `collect` VALUES (19996, 17, 1, 989, NULL, 0, '2021-02-22 22:08:55