-- MySQL dump 10.13 Distrib 8.0.29, for macos12 (arm64)
--
-- Host: localhost Database: ms-book
-- ------------------------------------------------------
-- Server version 8.0.29
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `t_admin_user`
--
DROP TABLE IF EXISTS `t_admin_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_admin_user` (
`id` bigint NOT NULL AUTO_INCREMENT,
`username` varchar(64) NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(100) NOT NULL DEFAULT '' COMMENT '密码',
`nick_name` varchar(64) NOT NULL DEFAULT '' COMMENT '昵称',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COMMENT='后台用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_admin_user`
--
LOCK TABLES `t_admin_user` WRITE;
/*!40000 ALTER TABLE `t_admin_user` DISABLE KEYS */;
INSERT INTO `t_admin_user` VALUES (1,'admin','111111','管理员','2022-08-11 15:27:44','2023-04-10 10:09:16'),(5,'test','11','测试','2022-08-14 14:51:49','2022-08-22 16:01:35');
/*!40000 ALTER TABLE `t_admin_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_book`
--
DROP TABLE IF EXISTS `t_book`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_book` (
`id` bigint NOT NULL AUTO_INCREMENT,
`no` varchar(64) NOT NULL DEFAULT '' COMMENT '编号',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
`cover` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '封面',
`category_id` bigint DEFAULT NULL COMMENT '分类',
`author` varchar(64) NOT NULL DEFAULT '' COMMENT '作者',
`press` varchar(100) NOT NULL DEFAULT '' COMMENT '出版社',
`description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
`status` char(1) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '状态',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COMMENT='图书信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_book`
--
LOCK TABLES `t_book` WRITE;
/*!40000 ALTER TABLE `t_book` DISABLE KEYS */;
INSERT INTO `t_book` VALUES (1,'B20220822001','Java编程思想','/file/f0fe0ffc7ebe45a787db904d3b5e0c46.png',1,'汤姆','人民出版社','Java学习必读经典,殿堂级著作!赢得了全球程序员的广泛赞誉100册以上团购优惠联系电话4006186622','1','2022-08-11 16:34:42','2023-04-27 03:36:48'),(2,'B20220822002','MySQL必知必会','/file/f0fe0ffc7ebe45a787db904d3b5e0c46.png',1,'图灵','工业出版社','《MySQL必知必会》注重实用性,操作性很强,适用于广大软件开发和数据库管理人员学习参考。','2','2022-08-12 16:48:05','2023-04-27 03:36:48'),(3,'B20220822003','深入浅出Vue.js','/file/f0fe0ffc7ebe45a787db904d3b5e0c46.png',1,'尤雨溪','人民邮电出版社','深入讲解Vue.js实现原理和思想','1','2022-08-12 16:53:09','2023-04-27 03:36:48'),(4,'B20220822004','水浒传','/file/f0fe0ffc7ebe45a787db904d3b5e0c46.png',2,'施耐庵','工业出版社','原著正版完整版120回','1','2022-08-12 16:57:41','2023-04-27 03:36:48'),(5,'B20220822005','K8s权威指南','/file/f0fe0ffc7ebe45a787db904d3b5e0c46.png',1,'吴志辉',' 电子工业出版社','内容超详尽的K8s指南全新升级至K8s1.19提供源码下载勘误及读者群答疑,CNCF、阿里、华为、腾讯、字节跳动、VMware众咖力荐,学用K8s的神器','1','2022-08-12 17:00:42','2023-04-27 03:36:48'),(6,'B20220822006','C程序设计','/file/f0fe0ffc7ebe45a787db904d3b5e0c46.png',1,'谭浩强','清华大学出版社','《中国高等院校计算机基础教育课程体系规划教材:C程序设计(第4版)》是一本公认的学习C语言程序设计的经典教材。','1','2022-08-12 17:21:48','2023-04-27 03:36:48'),(7,'B20220812001','三国演义','/file/f0fe0ffc7ebe45a787db904d3b5e0c46.png',2,'罗贯中','人民邮电出版社','是中国首部长篇章回体历史演义小说,以描写东汉末年的战争为主,反映了魏、蜀、吴三个政治集团之间的政治和军事斗争。分为黄巾之乱、董卓之乱、三国鼎立三大部分。','1','2022-08-12 17:25:59','2023-04-27 03:36:48'),(8,'B20220812002','应急救援基础知识','/file/f0fe0ffc7ebe45a787db904d3b5e0c46.png',4,'赵正宏','人民邮电出版社','《应急救援基础知识》简明扼要地介绍了应急管理的发展历程,应急管理基础知识、石化应急必备常识,应急管理与应急救援等内容','1','2022-08-12 17:29:52','2023-04-27 03:36:48'),(10,'B20220823001','泰戈尔诗集','/file/f0fe0ffc7ebe45a787db904d3b5e0c46.png',3,'泰戈尔','邮电出版社','泰戈尔诗集','1','2022-08-22 16:45:32','2023-04-27 04:12:02');
/*!40000 ALTER TABLE `t_book` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_category`
--
DROP TABLE IF EXISTS `t_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_category` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COMMENT='图书分类信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_category`
--
LOCK TABLES `t_category` WRITE;
/*!40000 ALTER TABLE `t_category` DISABLE KEYS */;
INSERT INTO `t_category` VALUES (1,'人文科学','2022-08-11 15:57:17','2022-08-11 15:59:05'),(2,'古典名著','2022-08-11 15:57:44',NULL),(3,'地理风情','2022-08-11 15:58:03',NULL),(4,'医疗救援','2022-08-11 15:58:29',NULL);
/*!40000 ALTER TABLE `t_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_history`
--
DROP TABLE IF EXISTS `t_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_history` (
`id` bigint NOT NULL AUTO_INCREMENT,
`book_id` bigint NOT NULL COMMENT '图书ID',
`user_id` bigint NOT NULL COMMENT '用户ID',
`lend_date` date DEFAULT NULL COMMENT '借阅日期',
`back_date` date DEFAULT NULL COMMENT '还书日期',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb3 COMMENT='借阅历史表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_history`
--
LOCK TABLES `t_history` WRITE;
/*!40000 ALTER TABLE `t_history` DISABLE KEYS */;
INSERT INTO `t_history` VALUES (39,1,2,'2023-04-27','2023-04-27','2023-04-27 13:03:43','2023-04-27 13:08:44'),(40,2,2,'2023-04-27',NULL,'2023-04-27 13:03:43',