/*
Navicat MySQL Data Transfer

Source Server         : local
Source Server Version : 50554
Source Host           : localhost:3306
Source Database       : mybatis

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

Date: 2022-10-20 13:30:04
*/

SET FOREIGN_KEY_CHECKS=0;

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

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES ('1', '西游记', '吴承恩', '120', '小说');
INSERT INTO `book` VALUES ('2', '水浒传', '施耐庵', '55', '小说');
INSERT INTO `book` VALUES ('3', 'Java入门', '高司令', '110', '技术');
INSERT INTO `book` VALUES ('4', 'mysql入门', '高司令', '55', '技术');
INSERT INTO `book` VALUES ('5', '三国演义', '罗贯中', '40', '小说');
INSERT INTO `book` VALUES ('7', '红楼梦', '曹雪芹', '100', '小说');

-- ----------------------------
-- Table structure for depart
-- ----------------------------
DROP TABLE IF EXISTS `depart`;
CREATE TABLE `depart` (
  `departId` int(11) NOT NULL AUTO_INCREMENT,
  `departName` varchar(255) NOT NULL,
  `departPhone` varchar(11) NOT NULL,
  PRIMARY KEY (`departId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of depart
-- ----------------------------
INSERT INTO `depart` VALUES ('1', '技术', '888888');
INSERT INTO `depart` VALUES ('2', '行政', '777777');
INSERT INTO `depart` VALUES ('3', '财务', '666666');

-- ----------------------------
-- Table structure for emp
-- ----------------------------
DROP TABLE IF EXISTS `emp`;
CREATE TABLE `emp` (
  `empId` int(11) NOT NULL AUTO_INCREMENT,
  `empName` varchar(255) NOT NULL,
  `departId` int(255) NOT NULL,
  `empAge` int(255) NOT NULL,
  `empSex` varchar(255) NOT NULL,
  PRIMARY KEY (`empId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of emp
-- ----------------------------
INSERT INTO `emp` VALUES ('1', '张三', '1', '21', '男');
INSERT INTO `emp` VALUES ('2', '李四', '2', '22', '女');
INSERT INTO `emp` VALUES ('3', '翠花', '3', '23', '男');
INSERT INTO `emp` VALUES ('4', '淑芬', '3', '22', '女');
INSERT INTO `emp` VALUES ('5', '王五', '2', '34', '男');

-- ----------------------------
-- Table structure for grade
-- ----------------------------
DROP TABLE IF EXISTS `grade`;
CREATE TABLE `grade` (
  `gradeId` int(11) NOT NULL AUTO_INCREMENT,
  `gradeName` varchar(255) NOT NULL,
  PRIMARY KEY (`gradeId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of grade
-- ----------------------------
INSERT INTO `grade` VALUES ('1', '软件一班');
INSERT INTO `grade` VALUES ('2', '软件二班');

-- ----------------------------
-- Table structure for movie
-- ----------------------------
DROP TABLE IF EXISTS `movie`;
CREATE TABLE `movie` (
  `movieId` int(11) NOT NULL AUTO_INCREMENT,
  `movieName` varchar(255) NOT NULL,
  PRIMARY KEY (`movieId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of movie
-- ----------------------------
INSERT INTO `movie` VALUES ('1', '钢铁侠');
INSERT INTO `movie` VALUES ('2', '中国机长');
INSERT INTO `movie` VALUES ('3', '神墓');
INSERT INTO `movie` VALUES ('4', '温暖的抱抱');

-- ----------------------------
-- Table structure for movie_type
-- ----------------------------
DROP TABLE IF EXISTS `movie_type`;
CREATE TABLE `movie_type` (
  `mtId` int(11) NOT NULL AUTO_INCREMENT,
  `movieId` int(11) NOT NULL,
  `typeId` int(11) NOT NULL,
  PRIMARY KEY (`mtId`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of movie_type
-- ----------------------------
INSERT INTO `movie_type` VALUES ('1', '1', '2');
INSERT INTO `movie_type` VALUES ('2', '1', '4');
INSERT INTO `movie_type` VALUES ('3', '2', '1');
INSERT INTO `movie_type` VALUES ('4', '2', '2');
INSERT INTO `movie_type` VALUES ('5', '2', '3');
INSERT INTO `movie_type` VALUES ('6', '3', '2');
INSERT INTO `movie_type` VALUES ('7', '3', '5');
INSERT INTO `movie_type` VALUES ('8', '4', '4');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `stuId` int(11) NOT NULL AUTO_INCREMENT,
  `stuName` varchar(255) NOT NULL,
  `gradeId` int(11) NOT NULL,
  PRIMARY KEY (`stuId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('1', '张三', '1');
INSERT INTO `student` VALUES ('2', '李四', '1');
INSERT INTO `student` VALUES ('3', '王五', '1');
INSERT INTO `student` VALUES ('4', '翠花', '2');
INSERT INTO `student` VALUES ('5', '淑芬', '2');

-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type` (
  `typeId` int(11) NOT NULL AUTO_INCREMENT,
  `typeName` varchar(255) NOT NULL,
  PRIMARY KEY (`typeId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of type
-- ----------------------------
INSERT INTO `type` VALUES ('1', '爱情');
INSERT INTO `type` VALUES ('2', '动作');
INSERT INTO `type` VALUES ('3', '记录');
INSERT INTO `type` VALUES ('4', '科幻');
INSERT INTO `type` VALUES ('5', '动漫');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `realName` varchar(255) NOT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `phoneOs` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userId`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'zhangsan', '123456', '张三', '男', '12345678911', 'ios');
INSERT INTO `user` VALUES ('2', 'lisi', '123456', '李四', '男', '5612312322', 'android');
INSERT INTO `user` VALUES ('3', 'wangwu', '123456', '淑芬', '女', '12345678923', 'ios');
INSERT INTO `user` VALUES ('4', 'cuihua', '123456', '翠花', null, null, null);
INSERT INTO `user` VALUES ('5', 'yijie', '123456', '易节', null, '133221333', null);
INSERT INTO `user` VALUES ('6', 'yijie2', '123456', '易节', null, '133221333', null);