/*
 Navicat MySQL Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50712
 Source Host           : localhost:3306
 Source Schema         : books

 Target Server Type    : MySQL
 Target Server Version : 50712
 File Encoding         : 65001

 Date: 02/02/2022 19:56:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book`  (
  `book_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '图书id',
  `book_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '图书名称',
  `book_ssm` mediumtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '图书描述',
  `book_auth` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '图书作者',
  `category_id` bigint(20) NULL DEFAULT NULL COMMENT '图书类型（关联id）',
  `is_delete` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '0' COMMENT '软删除(0为存在，1为删除)',
  PRIMARY KEY (`book_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES (1, 'Java编程思想', '深入的面向对象概念、多线程、自动项目构建、单元测试和调试等', '埃克尔', 1, '0');
INSERT INTO `book` VALUES (2, 'Java入门', '适合广大想学习一门编程语言的读者', '臧萌', 1, '0');
INSERT INTO `book` VALUES (3, '红楼梦', '以贾宝玉的所见所闻为线索，以贾府的家庭琐事。', '曹雪芹', 2, '0');
INSERT INTO `book` VALUES (6, '2', '2', '2', 2, '1');
INSERT INTO `book` VALUES (7, 'cess', 'ass', '12', 1, '1');
INSERT INTO `book` VALUES (8, '测试', '测试', '测试', 2, '1');

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category`  (
  `category_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '图书分类编号',
  `category_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '分类名称',
  `is_delete` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '0',
  PRIMARY KEY (`category_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1, '编程技术', '0');
INSERT INTO `category` VALUES (2, '文学', '0');

SET FOREIGN_KEY_CHECKS = 1;