-
Notifications
You must be signed in to change notification settings - Fork 5
/
springboot-vue.sql
154 lines (141 loc) · 12.2 KB
/
springboot-vue.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
/*
Navicat Premium Data Transfer
Source Server : 本地
Source Server Type : MySQL
Source Server Version : 80030
Source Host : localhost:3306
Source Schema : springboot-vue
Target Server Type : MySQL
Target Server Version : 80030
File Encoding : 65001
Date: 17/01/2023 20:08:06
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`isbn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '图书编号',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '名称',
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',
`author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '作者',
`publisher` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '出版社',
`create_time` date NULL DEFAULT NULL COMMENT '出版时间',
`status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '0：未归还 1：已归还',
`borrownum` int NOT NULL DEFAULT 0 COMMENT '此书被借阅次数',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES (9, '20211880115', '十万个为什么', 15.00, '苏格与', '温州大学出版社', '2022-12-05', '0', 18);
INSERT INTO `book` VALUES (10, '20211880119', '五万个为什么', 20.00, '聂家辉', '温州大学出版社', '2022-12-01', '0', 19);
INSERT INTO `book` VALUES (11, '20211880106', '一万个为什么', 16.00, '丁奕中', '温州大学出版社', '2022-12-02', '1', 13);
INSERT INTO `book` VALUES (12, '20211880114', '计算机操作系统', 32.00, '凌浩晨', '温州大学出版社', '2022-12-03', '1', 4);
INSERT INTO `book` VALUES (13, '20211880118', '伊索寓言', 25.00, '沈益威', '温州大学出版社', '2022-12-04', '1', 12);
INSERT INTO `book` VALUES (15, '20211880109', '格林童话', 20.00, '张超祥', '温州大学出版社', '2022-12-05', '1', 3);
INSERT INTO `book` VALUES (16, '20211880100', '图书管理系统', 188.00, '聂家辉', '温州大学出版社', '2022-08-10', '0', 16);
INSERT INTO `book` VALUES (17, '20211880128', '和另一个自己谈谈心', 12.00, '\r\n武志红', '中国友谊出版公司', '2021-01-01', '1', 12);
INSERT INTO `book` VALUES (18, '20211880111', '全国计算机技术与软件专业技术资格(水平)考试. 系统分析师考试大纲', 12.00, '全国计算机技术与软件专业技术资格(水平)考试办公室', '清华大学出版社', '2004-05-22', '1', 1);
INSERT INTO `book` VALUES (19, '20211880145', '简单减肥餐, 好吃不反弹', 20.00, '\r\n萨巴蒂娜', '中国轻工业出版社', '2022-07-07', '1', 1);
INSERT INTO `book` VALUES (20, '20211880155', '其实她真的好喜欢你', 25.00, '\r\n莫妮打', '时代文艺出版社', '2022-02-02', '1', 0);
INSERT INTO `book` VALUES (21, '20211880156', '导游业务. 第7版', 24.00, '\r\n全国导游人员资格考试教材编写组', '旅游教育出版社', '2022-08-22', '1', 0);
INSERT INTO `book` VALUES (22, '20211880166', '法医秦明. 幸存者', 22.00, '\r\n法医秦明', '北京联合出版公司', '2022-02-22', '1', 0);
INSERT INTO `book` VALUES (23, '20211880177', '中国书法史', 24.00, '\r\n徐建融', '浙江人民美术出版社', '2021-11-01', '1', 0);
INSERT INTO `book` VALUES (24, '20211880199', '实用百草治百病', 22.00, '\r\n宋纬文', '福建科学技术出版社', '2021-09-22', '1', 0);
INSERT INTO `book` VALUES (25, '20211880176', '烈火芳菲', 20.00, '赵方新', '北京十月文艺出版社', '2022-01-22', '1', 0);
-- ----------------------------
-- Table structure for bookwithuser
-- ----------------------------
DROP TABLE IF EXISTS `bookwithuser`;
CREATE TABLE `bookwithuser` (
`id` bigint NOT NULL COMMENT '读者id',
`isbn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '图书编号',
`book_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '图书名',
`nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '读者姓名',
`lendtime` datetime NULL DEFAULT NULL COMMENT '借阅时间',
`deadtime` datetime NULL DEFAULT NULL COMMENT '应归还时间',
`prolong` int NULL DEFAULT NULL COMMENT '续借次数',
PRIMARY KEY (`book_name`) USING BTREE,
INDEX `id`(`id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of bookwithuser
-- ----------------------------
INSERT INTO `bookwithuser` VALUES (21, '20211880119', '五万个为什么', 'db', '2023-01-01 13:38:36', '2023-01-31 13:38:36', 1);
INSERT INTO `bookwithuser` VALUES (28, '20211880115', '十万个为什么', '123', '2022-12-29 09:22:08', '2023-02-27 09:22:08', 0);
INSERT INTO `bookwithuser` VALUES (27, '20211880100', '图书管理系统', '12', '2022-12-29 08:48:36', '2023-01-28 08:48:36', 2);
-- ----------------------------
-- Table structure for lend_record
-- ----------------------------
DROP TABLE IF EXISTS `lend_record`;
CREATE TABLE `lend_record` (
`id` bigint NOT NULL AUTO_INCREMENT,
`reader_id` bigint NOT NULL COMMENT '读者id',
`isbn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '图书编号',
`bookname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '图书名',
`lend_time` datetime NULL DEFAULT NULL COMMENT '借书日期',
`return_time` datetime NULL DEFAULT NULL COMMENT '还书日期',
`status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '0：未归还 1：已归还',
`borrownum` int NOT NULL COMMENT '此书被借阅次数',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2030043138 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of lend_record
-- ----------------------------
INSERT INTO `lend_record` VALUES (-2048151551, 21, '20211880119', '五万个为什么', '2023-01-01 13:38:36', NULL, '0', 19);
INSERT INTO `lend_record` VALUES (-1859469311, 21, '20211880114', '计算机操作系统', '2022-12-26 17:31:05', '2023-01-01 13:38:22', '1', 4);
INSERT INTO `lend_record` VALUES (-1851039742, 21, '20211880100', '图书管理系统', '2022-12-23 19:30:59', '2022-12-23 19:32:00', '1', 13);
INSERT INTO `lend_record` VALUES (-1691627519, 27, '20211880100', '图书管理系统', '2022-12-29 08:48:36', NULL, '0', 16);
INSERT INTO `lend_record` VALUES (-1230368766, 21, '20211880115', '十万个为什么', '2022-12-24 15:10:31', '2022-12-24 15:17:51', '1', 13);
INSERT INTO `lend_record` VALUES (-1171603454, 21, '20211880106', '一万个为什么', '2021-12-26 17:31:01', '2022-12-31 15:58:52', '1', 12);
INSERT INTO `lend_record` VALUES (-1007984639, 21, '20211880115', '十万个为什么', '2022-12-23 19:34:28', '2022-12-23 19:34:33', '1', 12);
INSERT INTO `lend_record` VALUES (-785686526, 21, '20211880115', '十万个为什么', '2022-12-23 19:31:28', '2022-12-23 19:32:05', '1', 11);
INSERT INTO `lend_record` VALUES (-705966078, 28, '20211880115', '十万个为什么', '2022-12-29 09:22:08', NULL, '0', 18);
INSERT INTO `lend_record` VALUES (-693452798, 21, '20211880100', '图书管理系统', '2022-12-26 17:31:07', '2022-12-27 13:16:54', '1', 15);
INSERT INTO `lend_record` VALUES (-630497279, 21, '20211880109', '格林童话', '2022-12-23 19:31:31', '2022-12-23 19:32:10', '1', 2);
INSERT INTO `lend_record` VALUES (-483696639, 21, '20211880118', '伊索寓言', '2022-12-23 19:31:29', '2022-12-23 19:32:11', '1', 9);
INSERT INTO `lend_record` VALUES (-391421951, 21, '20211880128', '和另一个自己谈谈心', '2022-12-23 19:35:41', '2022-12-23 19:35:46', '1', 11);
INSERT INTO `lend_record` VALUES (-177598462, 21, '20211880115', '十万个为什么', '2022-12-24 15:23:24', '2022-12-24 15:23:33', '1', 15);
INSERT INTO `lend_record` VALUES (-18128895, 21, '20211880111', '全国计算机技术与软件专业技术资格(水平)考试. 系统分析师考试大纲', '2022-12-23 19:31:35', '2022-12-23 19:32:15', '1', 1);
INSERT INTO `lend_record` VALUES (19632129, 21, '20211880106', '一万个为什么', '2022-12-31 16:05:24', '2023-01-01 13:38:29', '1', 13);
INSERT INTO `lend_record` VALUES (262901761, 21, '20211880109', '格林童话', '2022-12-31 15:58:56', '2023-01-01 13:38:24', '1', 3);
INSERT INTO `lend_record` VALUES (611016705, 21, '20211880119', '五万个为什么', '2022-12-23 19:31:28', '2022-12-23 19:31:57', '1', 18);
INSERT INTO `lend_record` VALUES (749342722, 21, '20211880115', '十万个为什么', '2022-12-24 15:26:33', '2022-12-24 15:29:49', '1', 16);
INSERT INTO `lend_record` VALUES (761970690, 21, '20211880118', '伊索寓言', '2022-12-26 17:31:02', '2023-01-01 13:38:28', '1', 12);
INSERT INTO `lend_record` VALUES (1001086978, 21, '20211880118', '伊索寓言', '2022-12-23 19:33:59', '2022-12-23 19:34:02', '1', 10);
INSERT INTO `lend_record` VALUES (1017778177, 21, '20211880115', '十万个为什么', '2022-12-24 15:19:35', '2022-12-24 15:19:50', '1', 14);
INSERT INTO `lend_record` VALUES (1172967426, 21, '20211880100', '图书管理系统', '2022-12-24 15:28:35', '2022-12-24 15:30:12', '1', 14);
INSERT INTO `lend_record` VALUES (1181442050, 21, '20211880106', '一万个为什么', '2022-12-23 19:31:29', '2022-12-23 19:32:06', '1', 11);
INSERT INTO `lend_record` VALUES (1290493954, 21, '20211880118', '伊索寓言', '2022-12-23 19:35:39', '2022-12-23 19:35:44', '1', 11);
INSERT INTO `lend_record` VALUES (1412087809, 21, '20211880128', '和另一个自己谈谈心', '2022-12-26 17:31:04', '2023-01-01 13:38:26', '1', 12);
INSERT INTO `lend_record` VALUES (1428905986, 21, '20211880114', '计算机操作系统', '2022-12-23 19:31:30', '2022-12-23 19:32:08', '1', 3);
INSERT INTO `lend_record` VALUES (1659592705, 21, '20211880119', '五万个为什么', '2022-12-23 19:30:59', '2022-12-23 19:31:18', '1', 17);
INSERT INTO `lend_record` VALUES (1735090177, 21, '20211880118', '和另一个自己谈谈心', '2022-12-23 19:33:57', '2022-12-23 19:34:03', '1', 2);
INSERT INTO `lend_record` VALUES (1756061697, 21, '20211880118', '和另一个自己谈谈心', '2022-12-23 19:31:33', '2022-12-23 19:32:13', '1', 1);
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户名',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
`nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电话号码',
`sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '性别',
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '地址',
`role` int NOT NULL COMMENT '角色、1：管理员 2：普通用户',
`alow` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否允许借阅',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'njh', '123', '聂家辉', '17326788058', '男', '温州大学南校区A12-417室', 1, '1');
INSERT INTO `user` VALUES (21, 'db', '123', '借阅者', '17326788058', '男', '温州大学计算机与人工智能学院', 2, '1');
INSERT INTO `user` VALUES (28, '123', '123', 'njh', '19802045416', '男', 'xxx', 2, '1');
SET FOREIGN_KEY_CHECKS = 1;