/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50554
Source Host           : localhost:3306
Source Database       : libary

Target Server Type    : MYSQL
Target Server Version : 50554
File Encoding         : 65001

Date: 2024-10-09 21:31:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for author
-- ----------------------------
DROP TABLE IF EXISTS `author`;
CREATE TABLE `author` (
  `authorId` int(11) NOT NULL AUTO_INCREMENT,
  `authorName` varchar(255) NOT NULL,
  `authorSex` varchar(255) NOT NULL,
  `authorAge` varchar(255) NOT NULL,
  PRIMARY KEY (`authorId`),
  UNIQUE KEY `authorName` (`authorName`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of author
-- ----------------------------
INSERT INTO `author` VALUES ('1', '小李', '男', '23');
INSERT INTO `author` VALUES ('2', '老王', '男', '32');
INSERT INTO `author` VALUES ('3', '小芳', '女', '25');
INSERT INTO `author` VALUES ('4', '淑芬', '女', '30');
INSERT INTO `author` VALUES ('5', '王五', '男', '33');

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
  `bookId` int(11) NOT NULL AUTO_INCREMENT,
  `bookName` varchar(255) NOT NULL,
  `authorId` int(11) DEFAULT NULL,
  `bookType` varchar(255) NOT NULL,
  `pressId` int(11) DEFAULT NULL,
  PRIMARY KEY (`bookId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES ('1', '第二天', '1', '历史', '1');
INSERT INTO `book` VALUES ('2', '夜晚', '1', '社会', '1');
INSERT INTO `book` VALUES ('3', '人性', '3', '社会', '2');
INSERT INTO `book` VALUES ('4', '离别', '4', '言情', '3');
INSERT INTO `book` VALUES ('5', '梨子', '3', '言情', '2');

-- ----------------------------
-- Table structure for press
-- ----------------------------
DROP TABLE IF EXISTS `press`;
CREATE TABLE `press` (
  `pressId` int(11) NOT NULL AUTO_INCREMENT,
  `pressName` varchar(255) NOT NULL,
  `pressCity` varchar(255) NOT NULL,
  PRIMARY KEY (`pressId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of press
-- ----------------------------
INSERT INTO `press` VALUES ('1', '出名', '绵阳');
INSERT INTO `press` VALUES ('2', '有趣', '南充');
INSERT INTO `press` VALUES ('3', '厉害', '成都');