/*
 Navicat MySQL Data Transfer

 Source Server         : 腾讯云
 Source Server Type    : MySQL
 Source Server Version : 50650
 Source Host           : 81.70.253.225:3306
 Source Schema         : qinsx

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

 Date: 25/12/2021 17:05:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_student
-- ----------------------------
DROP TABLE IF EXISTS `sys_student`;
CREATE TABLE `sys_student`  (
  `id` int(11) NOT NULL COMMENT 'id',
  `sno` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学号',
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `age` int(11) NULL DEFAULT NULL,
  `academy` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业学院',
  `birthday` date NULL DEFAULT NULL,
  `address` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '住址',
  `other` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其他(备注)',
  PRIMARY KEY (`sno`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_student
-- ----------------------------
INSERT INTO `sys_student` VALUES (2, '421419406001', '贾梦豪', '男', 19, '通信工程19406', '2000-09-21', '河南省驻马店', '优秀');
INSERT INTO `sys_student` VALUES (1, '421419406002', '秦世兴', '男', 20, '通信工程19406', '2001-02-03', '河南省商丘市民权县', '优秀');
INSERT INTO `sys_student` VALUES (3, '421419406008', '何贵龙', '男', 22, '通信工程19406', '1999-09-05', '贵州省六盘水', '优秀');
INSERT INTO `sys_student` VALUES (4, '421419406009', '敖鹏举', '男', 23, '通信工程19406', '2002-02-10', '贵州省贵阳市', '优秀');
INSERT INTO `sys_student` VALUES (5, '421419406014', '孙博', '男', 24, '通信工程19406', '2000-05-26', '吉林省长春市', '优秀');
INSERT INTO `sys_student` VALUES (21, '421419454', 'zjl', '男', 20, 'aa', '2020-02-27', 'aa', '852');
INSERT INTO `sys_student` VALUES (6, 'aa', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', '11');
INSERT INTO `sys_student` VALUES (7, 'bb', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', '55');
INSERT INTO `sys_student` VALUES (8, 'qesrdfghj', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', 'rdcfvghbjn');
INSERT INTO `sys_student` VALUES (15, 'sryxdtucfykv', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', 'srdxcvkb');
INSERT INTO `sys_student` VALUES (16, 'syrdxtucfvgkb', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', 'rxrycjyvkb');
INSERT INTO `sys_student` VALUES (14, 'szrxydtcuykvulbkn', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', 'ryxcjvgb');
INSERT INTO `sys_student` VALUES (18, 'uxrcytvkyulb', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', 'zxycjvkb');
INSERT INTO `sys_student` VALUES (17, 'xrytuykugliu', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', 'chb');
INSERT INTO `sys_student` VALUES (13, 'zeryxtcykvub', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', 'rsrxutcvkbjhn');
INSERT INTO `sys_student` VALUES (20, 'zsxrydtcuyvub', 'aa', '女', 20, 'aa', '2020-02-03', 'aa', 'exrcyitvuylbn');
INSERT INTO `sys_student` VALUES (9, 'zxcvbhjkj', 'aa', '女', 20, 'aa', '2020-02-03', 'hjnm,', 'xgcfhjb');
INSERT INTO `sys_student` VALUES (19, 'zxetrcytkvuyb', 'aa', '男', 20, 'aa', '2020-02-03', 'aa', 'dfckgvjhbk');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `salt` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '盐值加密',
  `telephone` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('admin', 'e1273f08aff965673e5090c139e4ff94', NULL, 'L3Ga9w9L', '15896943734', '[email protected]', '通信工程19406');
INSERT INTO `sys_user` VALUES ('eric', 'qsx19406.', NULL, 'qwesaas', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('qsx', '28ae233f755de4763bbf768c0c91bb3c', NULL, 'aX39ya*G', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('wert', '375f145ee799654d622ee5394a1d8cd0', NULL, 'fGCy1eRd', NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;