/*
Navicat MySQL Data Transfer
Source Server : xing
Source Server Type : MySQL
Source Server Version : 80031
Source Host : localhost:3306
Source Schema : testapply
Target Server Type : MySQL
Target Server Version : 80031
File Encoding : 65001
Date: 28/11/2022 14:12:14
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for apply
-- ----------------------------
DROP TABLE IF EXISTS `apply`;
CREATE TABLE `apply` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`usersid` int(0) NULL DEFAULT NULL COMMENT '学生id',
`kemuid` int(0) NULL DEFAULT NULL COMMENT '报名科目id',
`createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of apply
-- ----------------------------
INSERT INTO `apply` VALUES (1, 3, 1, '2022-04-27 21:01:03');
INSERT INTO `apply` VALUES (2, 3, 2, '2022-04-27 21:01:57');
INSERT INTO `apply` VALUES (3, 3, 4, '2022-04-27 20:08:25');
INSERT INTO `apply` VALUES (4, 8, 4, '2022-04-27 10:30:04');
INSERT INTO `apply` VALUES (5, 8, 1, '2022-04-27 10:13:04');
INSERT INTO `apply` VALUES (6, 8, 6, '2022-04-27 10:27:08');
INSERT INTO `apply` VALUES (7, 8, 7, '2022-04-27 10:30:00');
INSERT INTO `apply` VALUES (8, 8, 5, '2022-04-27 10:40:50');
INSERT INTO `apply` VALUES (9, 8, 9, '2022-04-27 11:01:55');
INSERT INTO `apply` VALUES (10, 3, 7, '2022-04-27 08:22:24');
INSERT INTO `apply` VALUES (11, 3, 5, '2022-04-27 08:23:19');
INSERT INTO `apply` VALUES (12, 12, 1, '2022-04-27 11:57:59');
INSERT INTO `apply` VALUES (13, 13, 1, '2022-11-28 13:24:49');
-- ----------------------------
-- Table structure for subject
-- ----------------------------
DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '科目id',
`classname` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '科目名称',
`starttime` datetime(0) NULL DEFAULT NULL COMMENT '考试开始时间',
`testaddr` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '考试地点',
`nums` int(0) NULL DEFAULT 0 COMMENT '报考人数',
`endtime` datetime(0) NULL DEFAULT NULL COMMENT '考试结束时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of subject
-- ----------------------------
INSERT INTO `subject` VALUES (1, '行政职业能力测试', '2022-11-28 00:00:00', '石家庄市中学', 1, '2022-11-29 00:00:00');
INSERT INTO `subject` VALUES (2, '申论', '2022-12-02 00:00:00', '闽南理工学院', 0, '2022-12-03 00:00:00');
INSERT INTO `subject` VALUES (3, '面试', '2022-12-15 00:00:00', '中国人民大学', 0, '2022-12-20 00:00:00');
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键序号',
`username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名',
`password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '密码',
`email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机号',
`role` tinyint(1) NULL DEFAULT NULL COMMENT '角色 (1:学生 2:管理员)',
`picimg` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '头像',
`realname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '姓名',
`studentcard` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`classnum` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (13, 'user', '123456', '[email protected]', '15891589415', 1, 'UklGRsI2AABXRUJQVlA4ILY2AACQIwGdASoMAvQBPpFGnkslo6MnpFM6QPASCWduvnHOd3eoqlt0r621ZB2/+j/xzu+G5qXm3YX6K/rX797XGF/t41LPnn6O9Je5j/I8Df2TxDsjezN6vzC/A/oK/h+df2y9gXhgPVfYR/UfrI/7vnY/ZP+MOkhIkfSj4ASPpR8AJH0o+AEj6UfACR9KMNbU+O6VOoJUUcWddLJbgHTxRreXQbdXN+cNurm/OG3VinW10ZgdPtUC0vRdrTPi2yiKdNo7LVD85xTCoUyJH0o+AEj6UYXLuFi00/nR2QHjHknzn83N4e3bzTzdPFhdcAWNdz7ewVCmRI+lHwAkHP2NXG5lwkVldL40A629aDqvBVFnz+h1r+fYCZ0il2k5tPMsSa8wRyFMiR9KPgBI+lE1yC6z5Ykh3jjtGs7bnKPZGbRmg55AZy1qIYc2VPBotjZRQLpOpDm5M+irv4H7tEXN+cNurm/OGkQamx8qWzL73wOehU64gAbg7lY77FS67AHskGXSuF8JLGngnyz2BcVww26ub84bdWRDQxubuxexPITSNojWD0yQZxUMcq66CV9a1R8u7LLz0EqHwDl4HBNuPWRiUqcdthThXpv0o+AEj6UfAB0BF53Xe4dptdHzlE7hI/MUCqDLTskFC9cDs5TCWNuueMCvPgi1Wh6D1aNpf0JXstQJ1OatISJH0o+AEjs4P6o3Hm8zbzGZNSHYpKTFWRGtxFgjAJ3aFcJY/l25m0Xg7fNs9z+XDVELPvrmckij1yJcd6QkSPpR8AJHd7y4RNU5EPFSakNUS0L6Y9SXOhpOXkkYu1WNiFEaeKICPCfAIn3o11si18QlLWWJYg4hiWtsvme8AfnBthIUD2BwkH+d2XVLzDZpR8AJH0o9/2MGJACCfORV4WfglogZpovv/2pD+uJ8Hlb7jtH8g0xEiv+SODLZ0QkB0eEDe64p7rGoIQTigUQMT/2hJy66N7cVQwBr+bFj2S1J++SpJ/ApSnNbfzk8n0o+AEj6g356Sxrxhh6iOqk8fnsZguGw04B8/p6p0bK46et9bVVgYwYMHRz0mK6ohH5bSb6jyb345wH2NdaPSiZ0AV7+S4paX3fPJ9KPgBI7VFasFgWehYxbfIfIyLpUef0B65+mrIX8Qerixue1tzzh2a/cJMSQP/QDmRjd+GYKXwSdkck27R4sFZ0wHX8bq5vzht0JBLQTZncWlWAV3LiYBvreTQFb4iaijz0t3DgmeZGeLgIKZ9+DDIldqi2tUgkigWXwEg0WR5gv1m5k+MoqfirNKu4DpKz6S0LkWK0c5QSPpR8AJBsOqezMLP54ITMabTLSGsbtmtu4zsocmuGBy3vhjb8S4fJpz9gSAXodqMhqYb6S78BZS2WW1xqhbCYFnBZfSzJTkHUvItwNYnLT4CAt4cx16VSHi19PftGHYbdXN+aOHRhrWze+FD27XxGmp9JQ1TnLmgUlRcDBMiCghWcaGKJMoiV1jGZwBLQlULNEpCiT1gfoHPiMzAoRa0m0goaV7l2i7iXh6kCJ3/6aFDmVfbT784bdNv318Mjkwt5UiP8Fnr8nvTDePSf2fljVZO7aNg70M/WNZLg3H5EuZR+DkF344Ud32P3rTJ0wVyi9hj06bY0SrlxxylRp3EfzV9LM2tta0sqFMiR8y088i/88sJAyF5LFP0TfsWaj4HrstNzotwrd5aD7JHsZXAY0eykpfvZprPy1ycwt3mKcurn0/L++P8YPZpyLkk73TI9vKm4qQjLWLqF2Jwa1KdSp77KNJCNZOW72CoSE3rw+XY7NszHNsTWw9tjDJ6gXm5cptSFHoRHu0xRZEk2LztIPEgKGVuKXGo03rkJjsUl/7V4lLsCZkyV4y8UuCi5LGYgnu86KVKmkQRl4CNBp0o1sPiy2B8AJBt8uXZP9e7cuhxKmW7SaFweig7VhYUsjB+wIqC+TqVOZsN5CrhgoA56xWT07bQIfeZguzbCVwrHREV9ormi5SvEEpiPimKRNv8TXeiS2UQZqL+WB8AJH12aYC8iVZLArmBViln71d7BufjGaBwEI78SVLchaXCq7fROC/jdka1D80CqY2oFvPMM3vwu+3auAUzRRD1EpoKKp5+U/eWN1c35w5JgpFpFrs67vrh07CzPiQBqtFpgNvU7uFuHe8sYsWr50KYyA+pGJ4wwZ31SEvst/RBrTjAMCewMAs/3ea49PRXhUPaY81r+0yRrf6ub84baWfy1eOYW1d54NHPpp1nZkagEOXWcBd3dUc8IibLfvwAjDVfgERl+who/nzDDcpE29w0o3A0qC6Gr/GY/FA6+OKUfACR7Hm00mHtN7WeHuVPhTvf3l5h6MymfW83uU+bIPVK8jKTLI7ugciAANoQ1noGHJI5lwQ7dcqE1+3TEhJfFvplhcLhc/w9j48dG+s3VzfnAoHBFrZokuhlVtxkM5jV5MBU1KXjILoOCRANVYmA4lgrDrYS5QwUapjXpetBXb9ba5ga+rx4x/MYVZPLN94rLZfh0Tj5wckOQ0h8AJH0IJX8VTkUyPInAQXZQ9uaN2TLhoxZrloh5cZqsXCB7jBygqZdhFJbxzxx5lqAp1K+c/6mbVh/9mhPSH+RpZ8KlYYbdX/BG14DztB1YALFeG4dTec4sqdeFrJCXXpxTVbX7ecdqyrFBZRYna2hUqnqN7VGkdfSxayAYAMW0Xfk52VRKd67fZAL+os6ub8rZn3ZwMepbedi4U34HGRvtoOFfyMNX8U6Z1rXRHrbMrgxY/WTfsfKggz05E4zsegNTh8s0rqIftaVEz42VdgNJEkhP7oqI1h/wOMHljezLPchfhXqmq5QDC76DbqNjW72JEL6gK2BGfII+eGkfGoanYNHtEauKPMLHfEfx8jwZot/M+qI51+XHhQ8mSmD9TfRXEki9OWKXu6SNYWIQCaaRPGayjzt1sJUmMV5w282Xn7Y5OdSvWu6Zs8n875YUYHt/OOQV+SI6TIfSmBhqROqE1cxOXoaJzyaGi2vLLwAC4Lb2ninbQp7WVEyeC+qEW5t1deV/q50OjEiskh2IuGKbw6dfSbi2FyvOopl6dOyNhp7XPsberGf/xU9f576Q7qgnP9GzFQZCNcIQAAP744AAAAAAAAAAgnT6RA3M2eX2q8H6fqenb+TwF6h+wrkJiaJC3AUB3tvMuxPS254vifd95BytRx9ujfYgS7idhTZuZiEY43Twa5iqgYdKX5As9UpKALiop/AWcUiIevx6WUXILPMIUi1ZQyZaAtsti6eBbW/bsBrETJaO945nGZoNhf+phqhrcPDoAp3cgoCYcjaLBLRlvXV8e8a03vwAAAAJ5S