毕设-基于springboot+uniapp(vue)的小说阅读app

/* 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