C#课程设计-C#校园图书管理系统.zip

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80026 Source Host : localhost:3306 Source Schema : campuslibrary Target Server Type : MySQL Target Server Version : 80026 File Encoding : 65001 Date: 04/01/2022 07:07:27 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for __efmigrationshistory -- ---------------------------- DROP TABLE IF EXISTS `__efmigrationshistory`; CREATE TABLE `__efmigrationshistory` ( `MigrationId` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `ProductVersion` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (`MigrationId`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of __efmigrationshistory -- ---------------------------- INSERT INTO `__efmigrationshistory` VALUES ('20211217043826_init', '6.0.0'); INSERT INTO `__efmigrationshistory` VALUES ('20211217134806_2021-12-17', '6.0.0'); INSERT INTO `__efmigrationshistory` VALUES ('20211220053859_UserName_Phone', '6.0.0'); INSERT INTO `__efmigrationshistory` VALUES ('20211221144511_cls_sort', '6.0.0'); INSERT INTO `__efmigrationshistory` VALUES ('20211222133610_分类号', '6.0.0'); INSERT INTO `__efmigrationshistory` VALUES ('20211227044020_addBookshelfSort', '6.0.1'); INSERT INTO `__efmigrationshistory` VALUES ('20211228131018_isOpen', '6.0.1'); INSERT INTO `__efmigrationshistory` VALUES ('20211230140850_removeCode', '6.0.1'); -- ---------------------------- -- Table structure for book -- ---------------------------- DROP TABLE IF EXISTS `book`; CREATE TABLE `book` ( `Id` bigint NOT NULL AUTO_INCREMENT, `Name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `Author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `Cover` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `Count` int NOT NULL, `ISBN` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `QRCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `Press` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `Pdf` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `IsDeleted` tinyint(1) NOT NULL, `CreatedUserId` bigint NOT NULL, `CreatedTime` datetime(6) NOT NULL, `ModifyUserId` bigint NOT NULL, `ModifyTime` datetime(6) NOT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of book -- ---------------------------- -- ---------------------------- -- Table structure for bookclassification -- ---------------------------- DROP TABLE IF EXISTS `bookclassification`; CREATE TABLE `bookclassification` ( `Id` bigint NOT NULL AUTO_INCREMENT, `BookId` bigint NOT NULL, `BookshelfId` bigint NOT NULL, `ClassificationId` bigint NOT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of bookclassification -- ---------------------------- -- ---------------------------- -- Table structure for bookshelf -- ---------------------------- DROP TABLE IF EXISTS `bookshelf`; CREATE TABLE `bookshelf` ( `Id` bigint NOT NULL AUTO_INCREMENT, `Code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `LibraryId` bigint NOT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of bookshelf -- ---------------------------- INSERT INTO `bookshelf` VALUES (23, 'A-2-S1', 5); INSERT INTO `bookshelf` VALUES (24, 'A-3-S', 5); INSERT INTO `bookshelf` VALUES (25, 'A-4-S', 5); INSERT INTO `bookshelf` VALUES (26, 'A-5-S', 5); INSERT INTO `bookshelf` VALUES (27, 'A-B-S', 5); INSERT INTO `bookshelf` VALUES (28, 'A-C-S', 5); INSERT INTO `bookshelf` VALUES (29, 'A-D-S', 5); INSERT INTO `bookshelf` VALUES (30, 'A-E-S', 5); INSERT INTO `bookshelf` VALUES (31, 'A-F-S', 5); INSERT INTO `bookshelf` VALUES (32, 'A-B-S', 6); INSERT INTO `bookshelf` VALUES (33, 'A-C-S', 6); INSERT INTO `bookshelf` VALUES (34, 'A-D-S', 6); INSERT INTO `bookshelf` VALUES (35, 'A-E-S', 6); INSERT INTO `bookshelf` VALUES (36, 'A-F-S', 6); INSERT INTO `bookshelf` VALUES (37, 'A-G-S', 6); INSERT INTO `bookshelf` VALUES (38, 'A-H-S', 6); INSERT INTO `bookshelf` VALUES (39, 'A-I-S', 6); INSERT INTO `bookshelf` VALUES (40, 'A-J-S', 6); INSERT INTO `bookshelf` VALUES (41, 'A-K-S', 6); INSERT INTO `bookshelf` VALUES (42, 'AQ', 5); INSERT INTO `bookshelf` VALUES (43, 'q', 5); -- ---------------------------- -- Table structure for bookshelfclassification -- ---------------------------- DROP TABLE IF EXISTS `bookshelfclassification`; CREATE TABLE `bookshelfclassification` ( `Id` bigint NOT NULL AUTO_INCREMENT, `BookshelfId` bigint NOT NULL, `ClassificationId` bigint NOT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of bookshelfclassification -- ---------------------------- -- ---------------------------- -- Table structure for borrowreturnbook -- ---------------------------- DROP TABLE IF EXISTS `borrowreturnbook`; CREATE TABLE `borrowreturnbook` ( `Id` bigint NOT NULL AUTO_INCREMENT, `UserId` bigint NOT NULL, `BookId` bigint NOT NULL, `Name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `BorrowReturnStatus` int NOT NULL, `BorrowTime` datetime(6) NOT NULL, `ReturnTime` datetime(6) NOT NULL, `CreatedUserId` bigint NOT NULL, `CreatedTime` datetime(6) NOT NULL, `ModifyUserId` bigint NOT NULL, `ModifyTime` datetime(6) NOT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of borrowreturnbook -- ---------------------------- -- ---------------------------- -- Table structure for classification -- ---------------------------- DROP TABLE IF EXISTS `classification`; CREATE TABLE `classification` ( `Id` bigint NOT NULL AUTO_INCREMENT, `Name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `ParentId` bigint NOT NULL, `Sort` int NOT NULL DEFAULT 0, `Code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of classification -- ---------------------------- INSERT INTO `classification` VALUES (2, '政治、法律', 0, 4, 'D'); INSERT INTO `classification` VALUES (3, '哲学、宗教', 0, 2, 'B'); INSERT INTO `classification` VALUES (4, '社会科学总论', 0, 3, 'C'); INSERT INTO `classification` VALUES (5, '马克思主义、列宁主义、毛泽东思想、邓小平理论', 0, 1, 'A'); INSERT INTO `classification` VALUES (6, '军事', 0, 5, 'E'); INSERT INTO `classification` VALUES (7, '经济', 0, 6, 'F'); INSERT INTO `classification` VALUES (8, '马克思、恩格斯著作', 5, 1, 'A1'); INSERT INTO `classification` VALUES (9, '列宁著作', 5, 2, 'A2'); INSERT INTO `classification` VALUES (10, '斯大林著作', 5, 3, 'A3'); INSERT INTO `classification` VALUES (11, '毛泽东著作', 5, 4, 'A4'); INSERT INTO `classification` VALUES (12, '邓小平著作', 5, 5, 'A49'); INSERT INTO `classification` VALUES (13, '马克思、恩格斯、列宁、斯大林、毛�