/*
Navicat Premium Data Transfer
Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 50732
Source Host : localhost:3306
Source Schema : springboot
Target Server Type : MySQL
Target Server Version : 50732
File Encoding : 65001
Date: 09/06/2022 19:22:36
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for book_book
-- ----------------------------
DROP TABLE IF EXISTS `book_book`;
CREATE TABLE `book_book` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`bauthor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`price` float(10, 2) NOT NULL,
`amount` int(11) NOT NULL,
`sid` int(11) NOT NULL,
`pid` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `sid`(`sid`) USING BTREE,
INDEX `pid`(`pid`) USING BTREE,
CONSTRAINT `pid` FOREIGN KEY (`pid`) REFERENCES `book_publisher` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `sid` FOREIGN KEY (`sid`) REFERENCES `book_saler` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of book_book
-- ----------------------------
INSERT INTO `book_book` VALUES (1, '数据结构', '严蔚敏', 42.00, 1000, 1, 1);
INSERT INTO `book_book` VALUES (2, '计算机网络', '谢希仁', 36.00, 96, 1, 1);
INSERT INTO `book_book` VALUES (3, '算法笔记', '胡凡', 47.00, 458, 1, 1);
INSERT INTO `book_book` VALUES (4, '线性代数', '李永乐', 66.00, 2680, 2, 3);
INSERT INTO `book_book` VALUES (5, '软件工程', '朴勇', 16.00, 130, 2, 2);
INSERT INTO `book_book` VALUES (6, '红宝书', '张一元', 68.00, 96, 4, 3);
INSERT INTO `book_book` VALUES (7, '人性的弱点', '戴尔', 33.00, 666, 1, 4);
INSERT INTO `book_book` VALUES (8, '乡土中国', '费孝通', 11.00, 300, 2, 4);
INSERT INTO `book_book` VALUES (9, '朝花夕拾', '鲁迅', 36.00, 130, 3, 1);
INSERT INTO `book_book` VALUES (10, '狂人日记', '鲁迅', 21.00, 96, 2, 2);
INSERT INTO `book_book` VALUES (11, '呐喊', '鲁迅', 33.00, 356, 3, 3);
INSERT INTO `book_book` VALUES (12, '活着', '余华', 31.00, 310, 4, 4);
INSERT INTO `book_book` VALUES (13, '狼王梦', '沈石溪', 35.00, 130, 3, 1);
INSERT INTO `book_book` VALUES (15, '测试数据111', '测试数据111', 12.00, 100, 5, 5);
INSERT INTO `book_book` VALUES (16, '测试数据111', '测试数据111', 12.00, 100, 5, 5);
INSERT INTO `book_book` VALUES (18, '11', '11', 11.00, 11, 1, 1);
INSERT INTO `book_book` VALUES (19, '11', '11', 11.00, 11, 10, 10);
INSERT INTO `book_book` VALUES (29, '11', '11', 11.00, 111, 1, 1);
INSERT INTO `book_book` VALUES (30, '11', '11', 11.00, 11, 5, 6);
SET FOREIGN_KEY_CHECKS = 1;
