/*
 Navicat Premium Data Transfer

 Source Server         : java
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : localhost:3306
 Source Schema         : scsys

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

 Date: 19/12/2022 23:11:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course`  (
  `course_id` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `course_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `teacher` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `point` int(0) NOT NULL,
  `time_1` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `time_2` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `location` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `limited` int(0) NOT NULL,
  PRIMARY KEY (`course_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES ('1111', 'java', '一头菜', 2, '12', '42', '广东科技学院', 10);
INSERT INTO `course` VALUES ('1112', 'javaWeb', '一头菜', 6, '12', '54', '广东科技学院', 2);
INSERT INTO `course` VALUES ('1113', 'JavaScript', '一头菜', 3, '25', '11', '广东科技大圆', 1);
INSERT INTO `course` VALUES ('2221', 'c', '二头菜', 2, '22', '41', 'A-304', 6);
INSERT INTO `course` VALUES ('2222', '脂肪的秘密', '二头菜', 5, '12', '41', '抖音', 10);
INSERT INTO `course` VALUES ('2223', '激动的心', '二头菜', 2, '11', '44', '梦里', 5);
INSERT INTO `course` VALUES ('3331', 'Vue.js', '三头菜', 2, '13', '34', '5-405', 6);
INSERT INTO `course` VALUES ('3332', '一个小目标', '三头菜', 6, '14', '45', '万达广场', 50);
INSERT INTO `course` VALUES ('3333', '计算机导师', '三头菜', 1, '13', '53', '板凳前', 16);

-- ----------------------------
-- Table structure for elective
-- ----------------------------
DROP TABLE IF EXISTS `elective`;
CREATE TABLE `elective`  (
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `course_id` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  INDEX `u_e_name`(`username`) USING BTREE,
  INDEX `c_e_id`(`course_id`) USING BTREE,
  CONSTRAINT `c_e_id` FOREIGN KEY (`course_id`) REFERENCES `course` (`course_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `u_e_name` FOREIGN KEY (`username`) REFERENCES `user` (`username`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of elective
-- ----------------------------
INSERT INTO `elective` VALUES ('张二', '1111');
INSERT INTO `elective` VALUES ('张一', '1111');
INSERT INTO `elective` VALUES ('张二', '2222');
INSERT INTO `elective` VALUES ('张一', '3331');
INSERT INTO `elective` VALUES ('张二', '2221');
INSERT INTO `elective` VALUES ('张三', '1111');
INSERT INTO `elective` VALUES ('张三', '1112');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `password` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `realname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `role` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('张一', '123', '一天才', '0');
INSERT INTO `user` VALUES ('张三', '123', '三天才', '0');
INSERT INTO `user` VALUES ('张二', '123', '二天才', '0');
INSERT INTO `user` VALUES ('李一', '123456', '一头菜', '1');
INSERT INTO `user` VALUES ('李三', '123456', '三头菜', '1');
INSERT INTO `user` VALUES ('李二', '123456', '二头菜', '1');
INSERT INTO `user` VALUES ('李四', '123', '四头菜', '1');
INSERT INTO `user` VALUES ('梦飞', '1234', '梦', '1');

SET FOREIGN_KEY_CHECKS = 1;