lms.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50729
Source Host           : localhost:3306
Source Database       : lms

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

Date: 2021-06-07 12:30:12
*/
CREATE DATABASE lms;
use lms;
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accountID` char(200) NOT NULL,
  `password` char(200) NOT NULL,
  `judge` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES ('1', '123', '132', '1');
INSERT INTO `account` VALUES ('4', '1', '123', '0');
INSERT INTO `account` VALUES ('5', '1234', '1', '0');

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `bookNum` int(100) NOT NULL DEFAULT '1',
  `bookName` char(100) NOT NULL,
  `bookAuthor` char(100) NOT NULL,
  `bookPrice` int(100) NOT NULL,
  `bookType` int(2) NOT NULL DEFAULT '0',
  `time` int(10) NOT NULL DEFAULT '10',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES ('1', '2', '孔乙己', '鲁迅', '35', '0', '10');
INSERT INTO `book` VALUES ('2', '1', '操作系统', 'Bob', '105', '2', '10');
INSERT INTO `book` VALUES ('3', '2', '人工智能', 'hwh', '100', '3', '10');
INSERT INTO `book` VALUES ('4', '3', '自然', 'Nature', '188', '4', '10');
INSERT INTO `book` VALUES ('5', '2', '硬笔书法', '王羲之', '55', '1', '10');
INSERT INTO `book` VALUES ('6', '2', '乡土中国', '费孝通', '58', '0', '10');
INSERT INTO `book` VALUES ('7', '1', '礼物的流动', '阎云翔', '59', '0', '10');
INSERT INTO `book` VALUES ('9', '2', '艺术的力量', '西蒙', '78', '1', '10');
INSERT INTO `book` VALUES ('10', '3', '美的历程', '李泽厚', '50', '1', '10');
INSERT INTO `book` VALUES ('11', '3', '大数据革命', '张靖笙', '60', '2', '10');
INSERT INTO `book` VALUES ('12', '3', '酷玩NLP', '白果', '79', '3', '10');
INSERT INTO `book` VALUES ('15', '3', '微观经济学', '平迪克', '26', '5', '10');
INSERT INTO `book` VALUES ('16', '2', '微观经济学', '曼昆', '81', '5', '10');
INSERT INTO `book` VALUES ('17', '2', '平凡的世界', '路遥', '100', '0', '10');
INSERT INTO `book` VALUES ('18', '2', '创业基础', '陈文华', '55', '5', '10');
INSERT INTO `book` VALUES ('19', '1', '数据结构', 'Rose', '35', '2', '10');
INSERT INTO `book` VALUES ('20', '1', '概率论', '陈喜怒', '58', '5', '10');
INSERT INTO `book` VALUES ('21', '1', 'W自传', 'W', '45', '5', '10');

-- ----------------------------
-- Table structure for borrow
-- ----------------------------
DROP TABLE IF EXISTS `borrow`;
CREATE TABLE `borrow` (
  `bookID` int(100) NOT NULL DEFAULT '0',
  `stuID` int(100) NOT NULL,
  `addTime` char(100) NOT NULL,
  `lastTime` char(100) NOT NULL,
  PRIMARY KEY (`bookID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of borrow
-- ----------------------------

-- ----------------------------
-- Table structure for examine
-- ----------------------------
DROP TABLE IF EXISTS `examine`;
CREATE TABLE `examine` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `stuID` int(100) NOT NULL,
  `stuName` char(100) NOT NULL,
  `type` int(100) NOT NULL,
  `bookName` char(100) NOT NULL,
  `bookAuthor` char(100) NOT NULL,
  `bookPrice` int(100) NOT NULL,
  `bookType` int(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of examine
-- ----------------------------
INSERT INTO `examine` VALUES ('2', '4', 'wsx', '0', '素描', 'Alan', '45', '1');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(200) NOT NULL,
  `name` char(200) NOT NULL,
  `sex` char(10) NOT NULL,
  `stuID` bigint(100) NOT NULL,
  `maxNum` int(10) NOT NULL DEFAULT '5',
  `nowNum` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('4', 'wsx', '男', '201926205054', '8', '0');
INSERT INTO `student` VALUES ('5', 'zz', 'z', '123', '5', '0');