/*
 Navicat Premium Data Transfer

 Source Server         : ctgu_stu_reg_sys
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : ctgu-mysql

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

 Date: 27/11/2020 16:06:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tel` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `profile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `account` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `roleId` int(0) NULL DEFAULT 0
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('华北水利水电大学', '男', '18338663494', '454@qq.com', '111', 'admin', NULL);

-- ----------------------------
-- Table structure for pay
-- ----------------------------
DROP TABLE IF EXISTS `pay`;
CREATE TABLE `pay`  (
  `IDNum` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `money` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
  `payDate` datetime(0) NULL DEFAULT NULL,
  `green` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未提交',
  `tuition` int(0) NULL DEFAULT 6000,
  `dormitoryFee` int(0) NULL DEFAULT 1000,
  `costumes` int(0) NULL DEFAULT 0,
  `result` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未完成',
  `proofMaterial` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未提交',
  `loan` int(0) NULL DEFAULT 0
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pay
-- ----------------------------
INSERT INTO `pay` VALUES ('413026158654562565', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562564', '0', NULL, '未提交', 36000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562566', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562567', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562568', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562569', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562570', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562571', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562572', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562574', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562575', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562576', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562577', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);
INSERT INTO `pay` VALUES ('413026158654562578', '0', NULL, '未提交', 6000, 1000, 0, '未完成', '未提交', 0);

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `roleId` int(0) NULL DEFAULT NULL,
  `rolename` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `permissions` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `id` int(0) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (0, 'admin', '可以管理其他用户', 1);
INSERT INTO `role` VALUES (1, 'school', '对学生进行管理', 2);
INSERT INTO `role` VALUES (2, 'student', '能够报到注册', 3);

-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room`  (
  `rno` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `roomSize` int(0) NULL DEFAULT NULL,
  `currentSize` int(0) NULL DEFAULT NULL,
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `major` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `roomStatus` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '可选',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of room
-- ----------------------------
INSERT INTO `room` VALUES ('1101', 6, 1, 10, '数字媒体技术', '可选');

-- ----------------------------
-- Table structure for school
-- ----------------------------
DROP TABLE IF EXISTS `school`;
CREATE TABLE `school`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `account` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `school` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `roleState` int(0) NULL DEFAULT 0,
  `roleId` int(0) NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of school
-- ----------------------------
INSERT INTO `school` VALUES (6, 'xiaowang', '小王', '男', '13569856985', '494955845@qq.com', '三峡大学', '宜昌市西陵区大学路8号', 1, 1);

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `IDNum` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(0) NULL DEFAULT NULL,
  `roleState` int(0) NULL DEFAULT 1,
  `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `birthday` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `major` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `rno` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未选择',
  `registration` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未报到',
  `roleId` int(0) NULL DEFAULT 2,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `student_IDNum_uindex`(`IDNum`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 150 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (135, '413026158654562565', '王志强', '男', 20, 1, '15869856595', '2000-01-01', '计算机科学与技术', '1101', '未报到', 2);
INSERT INTO `student` VALUES (136, '413026158654562564', '王小红', '女', 19, 1, '11846584568', '2001-01-01', '数字媒体技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (138, '413026158654562566', '丁天翊', '男', 20, 1, '11846584568', '1996-01-01', '数字媒体技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (139, '413026158654562567', '邓杰', '男', 20, 1, '11846584568', '2000-02-01', '数字媒体技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (140, '413026158654562568', '王赛雅', '女', 19, 1, '11846584568', '2001-03-01', '数字媒体技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (141, '413026158654562569', '李婧旖', '女', 20, 1, '11846584568', '2000-01-01', '数字媒体技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (142, '413026158654562570', '王敬娇', '女', 23, 1, '11846584568', '2000-01-01', '数字媒体技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (143, '413026158654562571', '许振', '男', 20, 1, '11846584568', '2000-01-01', '计算机科学与技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (144, '413026158654562572', '张朔', '男', 20, 1, '11846584568', '1996-01-01', '计算机科学与技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (145, '413026158654562574', '胡智杰', '男', 20, 1, '11846584568', '2000-01-01', '计算机科学与技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (146, '413026158654562575', '杨小芳', '女', 20, 1, '11846584568', '2000-01-01', '计算机科学与技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (147, '413026158654562576', '胡小梅', '女', 20, 1, '11846584568', '2000-01-01', '计算机科学与技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (148, '413026158654562577', '范斌鹏', '男', 20, 1, '11846584568', '2000-01-01', '计算机科学与技术', '未选择', '未报到', 2);
INSERT INTO `student` VALUES (149, '413026158654562578', '胡昆鹏', '男', 20, 1, '11846584568', '2000-05-01', '计算机科学与技术', '未选择', '未报到', 2);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `account` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `role` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'admin', '123456', 0);
INSERT INTO `user` VALUES (2, 'xiaowang', '123456', 1);
INSERT INTO `user` VALUES (3, '413026158654562565', '123456', 2);
INSERT INTO `user` VALUES (4, '413026158654562564', '123456', 2);
INSERT INTO `user` VALUES (5, '413026158654562566', '123456', 2);
INSERT INTO `user` VALUES (6, '413026158654562567', '123456', 2);
INSERT INTO `user` VALUES (7, '413026158654562568', '123456', 2);
INSERT INTO `user` VALUES (8, '413026158654562569', '123456', 2);
INSERT INTO `user` VALUES (9, '413026158654562570', '123456', 2);
INSERT INTO `user` VALUES (10, '413026158654562571', '123456', 2);
INSERT INTO `user` VALUES (11, '413026158654562572', '123456', 2);
INSERT INTO `user` VALUES (12, '413026158654562574', '123456', 2);
INSERT INTO `user` VALUES (13, '413026158654562575', '123456', 2);
INSERT INTO `user` VALUES (14, '413026158654562576', '123456', 2);
INSERT INTO `user` VALUES (15, '413026158654562577', '123456', 2);
INSERT INTO `user` VALUES (16, '413026158654562578', '123456', 2);

SET FOREIGN_KEY_CHECKS = 1;