master

分支 (1)

管理

管理

master

BookMS
/
BookMS.sql

/*
SQLyog Enterprise v12.09 (64 bit)
MySQL - 8.0.19 : Database - bookmanagementsystem
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`bookmanagementsystem` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `bookmanagementsystem`;

/*Table structure for table `book` */

DROP TABLE IF EXISTS `book`;

CREATE TABLE `book` (
  `bid` int NOT NULL AUTO_INCREMENT,
  `bname` varchar(100) DEFAULT NULL,
  `description` text,
  `image` varchar(200) DEFAULT NULL,
  `author` varchar(20) DEFAULT NULL,
  `publisher` varchar(20) DEFAULT NULL,
  `publishTime` varchar(30) DEFAULT NULL,
  `price` decimal(8,2) DEFAULT NULL,
  `stock` int DEFAULT NULL,
  `status` int DEFAULT '1',
  PRIMARY KEY (`bid`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `book` */

insert  into `book`(`bid`,`bname`,`description`,`image`,`author`,`publisher`,`publishTime`,`price`,`stock`,`status`) values (5,'数据库原理','这是一本不错的数据库入门书籍','images/dbyl.jpg','张老师','机械工业出版社','2020-05-06','49.99',8,1),(6,'C++','这是一本适合零基础同学的C++入门书籍','images/c++.jpg','C老师','机械工业出版社','2020-05-06','46.99',8,1),(7,'JavaWeb实战','沙发斯蒂芬谁打的舒服','images/javaweb.jpg','Java老师','人民邮电出版社','2020-05-13','59.99',8,1),(8,'算法图解','算法入门可视化算法','images/alogoith.jpg','算法老师','电子工业出版社','2020-05-08','59.99',9,1),(9,'汇编语言','最靠近机器语言的程序设计语言','images/huibian.jpg','汇编老师','清华大学出版社','2020-05-11','69.99',10,1),(10,'物联网','关于物联网工程设计与实施','images/IoT.jpg','物老师','机械工业出版社','2020-05-01','48.99',10,1),(11,'Android','Android工程师的第一行代码','images/android.jpg','Android老师','清华大学出版社','2020-05-08','39.99',10,1),(12,'编程珠玑','字字珠玑','images/bczj.jpg','BC老师','人民邮电出版社','2020-05-13','50.00',10,0),(13,'JavaScript','JavaScript高级程序设计','images/javascript.jpg','JS老师','人民邮电出版社','2020-05-18','69.99',10,0),(14,'IOS','IOS和MacOS性能优化','images/ios.jpg','IOS老师','电子工业出版社','2020-05-06','69.99',10,1),(15,'Python','Pythoncookbook','images/cookbook.jpg','python老师','人民邮电出版社','2020-05-01','59.99',10,1),(28,'go语言','真不错','images/gonotes.jpg','知道了','人民邮电出版社','2020-06-03','59.00',10,1);

/*Table structure for table `borrow` */

DROP TABLE IF EXISTS `borrow`;

CREATE TABLE `borrow` (
  `recordId` int NOT NULL AUTO_INCREMENT,
  `uid` int DEFAULT NULL,
  `bid` int DEFAULT NULL,
  `borrowTime` datetime DEFAULT NULL,
  PRIMARY KEY (`recordId`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `borrow` */

insert  into `borrow`(`recordId`,`uid`,`bid`,`borrowTime`) values (20,1,5,'2020-05-26 10:39:11'),(22,1,6,'2020-05-26 14:35:59'),(36,2,6,'2020-05-27 11:00:13'),(37,2,5,'2020-05-27 11:00:14'),(38,2,7,'2020-05-27 11:00:15'),(42,3,8,'2020-06-19 10:05:04'),(44,3,7,'2020-06-19 10:05:06');

/*Table structure for table `comment` */

DROP TABLE IF EXISTS `comment`;

CREATE TABLE `comment` (
  `cid` int NOT NULL AUTO_INCREMENT,
  `uid` int DEFAULT NULL,
  `bid` int DEFAULT NULL,
  `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `commentTime` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `comment` */

insert  into `comment`(`cid`,`uid`,`bid`,`content`,`commentTime`) values (1,3,5,'很不错','2020-05-12 19:46:29'),(2,3,5,'二刷了好评','2020-05-26 21:45:01'),(3,3,5,'这本书真好看','2020-05-26 22:38:21'),(4,3,6,'C++入门','2020-05-27 10:23:37'),(5,3,9,'汇编lalalal sdfasdasd','2020-05-27 10:29:00'),(6,2,5,'数据库不错发送到发送到发送到','2020-05-27 10:32:37'),(7,3,6,'荆防颗粒手机打开了福建省','2020-05-27 10:57:18'),(8,2,5,'所发生的防守打法','2020-05-27 11:00:01'),(9,3,5,'三刷了还可以','2020-06-19 10:04:33'),(10,3,8,'真不错','2020-06-19 10:05:54');

/*Table structure for table `log` */

DROP TABLE IF EXISTS `log`;

CREATE TABLE `log` (
  `lid` int NOT NULL AUTO_INCREMENT,
  `uid` int DEFAULT NULL,
  `bid` int DEFAULT NULL,
  `opr` text,
  `oprTime` datetime DEFAULT NULL,
  PRIMARY KEY (`lid`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `log` */

insert  into `log`(`lid`,`uid`,`bid`,`opr`,`oprTime`) values (9,3,6,'借阅','2020-05-26 10:47:49'),(10,1,7,'归还','2020-05-26 14:35:24'),(11,1,6,'借阅','2020-05-26 14:35:59'),(12,3,7,'借阅','2020-05-26 16:14:20'),(13,3,5,'借阅','2020-05-26 16:14:21'),(14,3,0,'添加','2020-05-26 16:21:25'),(15,3,11,'借阅','2020-05-26 16:21:38'),(16,3,6,'归还','2020-05-26 16:21:49'),(17,3,7,'归还','2020-05-26 16:56:47'),(18,2,7,'借阅','2020-05-26 18:30:59'),(19,2,7,'归还','2020-05-26 18:31:07'),(20,2,9,'借阅','2020-05-26 18:43:40'),(21,3,7,'修改','2020-05-26 19:00:22'),(22,3,5,'评论','2020-05-26 21:45:01'),(23,3,0,'添加','2020-05-26 21:47:23'),(24,3,0,'添加','2020-05-26 21:58:13'),(25,3,0,'添加','2020-05-26 22:02:36'),(26,3,0,'添加','2020-05-26 22:07:05'),(27,0,0,'添加','2020-05-26 22:15:09'),(28,0,17,'添加','2020-05-26 22:22:17'),(29,3,18,'添加','2020-05-26 22:27:40'),(30,3,5,'评论','2020-05-26 22:38:21'),(31,3,5,'归还','2020-05-26 22:38:56'),(32,3,17,'下架','2020-05-26 22:50:32'),(33,3,18,'下架','2020-05-26 22:50:33'),(34,3,12,'修改','2020-05-26 22:59:18'),(35,3,19,'添加','2020-05-27 10:16:47'),(36,3,6,'借阅','2020-05-27 10:17:59'),(37,3,8,'借阅','2020-05-27 10:18:18'),(38,3,7,'借阅','2020-05-27 10:18:20'),(39,3,8,'归还','2020-05-27 10:23:08'),(40,3,7,'归还','2020-05-27 10:23:13'),(41,3,6,'评论','2020-05-27 10:23:37'),(42,3,7,'修改','2020-05-27 10:25:46'),(43,3,9,'评论','2020-05-27 10:29:00'),(44,2,5,'评论','2020-05-27 10:32:37'),(45,2,12,'借阅','2020-05-27 10:33:13'),(46,2,14,'借阅','2020-05-27 10:33:14'),(47,2,13,'借阅','2020-05-27 10:33:15'),(48,2,12,'归还','2020-05-27 10:33:30'),(49,2,14,'归还','2020-05-27 10:33:33'),(50,3,20,'添加','2020-05-27 10:56:36'),(51,3,6,'评论','2020-05-27 10:57:18'),(52,3,6,'归还','2020-05-27 10:57:31'),(53,3,7,'修改','2020-05-27 10:58:53'),(54,3,16,'下架','2020-05-27 10:59:20'),(55,3,20,'下架','2020-05-27 10:59:22'),(56,3,19,'下架','2020-05-27 10:59:22'),(57,3,5,'借阅','2020-05-27 10:59:29'),(58,3,6,'借阅','2020-05-27 10:59:30'),(59,3,6,'归还','2020-05-27 10:59:35'),(60,2,5,'评论','2020-05-27 11:00:01'),(61,2,6,'借阅','2020-05-27 11:00:13'),(62,2,5,'借阅','2020-05-27 11:00:14'),(63,2,7,'借阅','2020-05-27 11:00:15'),(64,2,9,'归还','2020-05-27 11:00:20'),(65,2,13,'归还','2020-05-27 11:00:22'),(66,3,10,'借阅','2020-05-30 15:54:49'),(67,3,9,'借阅','2020-05-30 15:54:50'),(68,3,11,'归还','2020-05-30 15:55:12'),(69,3,5,'归还','2020-05-30 15:55:15'),(70,3,10,'归还','2020-06-06 10:10:05'),(71,3,9,'归还','2020-06-06 10:10:30'),(72,3,27,'添加','2020-06-19 10:00:49'),(73,3,28,'添加','2020-06-19 10:03:24'),(74,3,5,'借阅','2020-06-19 10:04:13'),(75,3,5,'评论','2020-06-19 10:04:33'),(76,3,5,'归还','2020-06-19 10:04:49'),(77,3,7,'借阅','2020-06-19 10:05:06'),(78,3,8,'借阅','2020-06-19 10:05:04'),(79,3,6,'借阅','2020-06-19 10:05:06'),(80,3,6,'归还','2020-06-19 10:05:25'),(81,3,12,'下架','2020-06-19 10:05:38'),(82,3,13,'下架','2020-06-19 10:05:40'),(83,3,8,'评论','2020-06-19 10:05:54'),(84,0,28,'修改','2020-06-19 10:06:47');

/*Table structure for table `role` */

DROP TABLE IF EXISTS `role`;

CREATE TABLE `role` (
  `rid` int NOT NULL,
  `rname` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `role` */

insert  into `role`(`rid`,`rname`) values (0,'superAdmin'),(1,'admin'),(2,'normalUser');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `uid` int NOT NULL AUTO_INCREMENT,
  `account` varchar(20) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  `rid` int DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `user` */

insert  into `user`(`uid`,`account`,`password`,`rid`) values (1,'jack11','123',1),(2,'jack101','123',2),(3,'Mike','111',1),(4,'ekko','111',2);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;