/*
 Navicat Premium Data Transfer

 Source Server         : reactor
 Source Server Type    : MySQL
 Source Server Version : 50736
 Source Host           : 121.41.39.19:3306
 Source Schema         : exam_sys

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

 Date: 28/12/2022 13:45:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of auth_group
-- ----------------------------

-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `auth_group_permissions_group_id_permission_id_0cd325b0_uniq`(`group_id`, `permission_id`) USING BTREE,
  INDEX `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm`(`permission_id`) USING BTREE,
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of auth_group_permissions
-- ----------------------------

-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `auth_permission_content_type_id_codename_01ab375a_uniq`(`content_type_id`, `codename`) USING BTREE,
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of auth_permission
-- ----------------------------
INSERT INTO `auth_permission` VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` VALUES (2, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` VALUES (4, 'Can view log entry', 1, 'view_logentry');
INSERT INTO `auth_permission` VALUES (5, 'Can add permission', 2, 'add_permission');
INSERT INTO `auth_permission` VALUES (6, 'Can change permission', 2, 'change_permission');
INSERT INTO `auth_permission` VALUES (7, 'Can delete permission', 2, 'delete_permission');
INSERT INTO `auth_permission` VALUES (8, 'Can view permission', 2, 'view_permission');
INSERT INTO `auth_permission` VALUES (9, 'Can add group', 3, 'add_group');
INSERT INTO `auth_permission` VALUES (10, 'Can change group', 3, 'change_group');
INSERT INTO `auth_permission` VALUES (11, 'Can delete group', 3, 'delete_group');
INSERT INTO `auth_permission` VALUES (12, 'Can view group', 3, 'view_group');
INSERT INTO `auth_permission` VALUES (13, 'Can add content type', 4, 'add_contenttype');
INSERT INTO `auth_permission` VALUES (14, 'Can change content type', 4, 'change_contenttype');
INSERT INTO `auth_permission` VALUES (15, 'Can delete content type', 4, 'delete_contenttype');
INSERT INTO `auth_permission` VALUES (16, 'Can view content type', 4, 'view_contenttype');
INSERT INTO `auth_permission` VALUES (17, 'Can add session', 5, 'add_session');
INSERT INTO `auth_permission` VALUES (18, 'Can change session', 5, 'change_session');
INSERT INTO `auth_permission` VALUES (19, 'Can delete session', 5, 'delete_session');
INSERT INTO `auth_permission` VALUES (20, 'Can view session', 5, 'view_session');
INSERT INTO `auth_permission` VALUES (21, 'Can add student class', 6, 'add_studentclass');
INSERT INTO `auth_permission` VALUES (22, 'Can change student class', 6, 'change_studentclass');
INSERT INTO `auth_permission` VALUES (23, 'Can delete student class', 6, 'delete_studentclass');
INSERT INTO `auth_permission` VALUES (24, 'Can view student class', 6, 'view_studentclass');
INSERT INTO `auth_permission` VALUES (25, 'Can add userinfo', 7, 'add_userinfo');
INSERT INTO `auth_permission` VALUES (26, 'Can change userinfo', 7, 'change_userinfo');
INSERT INTO `auth_permission` VALUES (27, 'Can delete userinfo', 7, 'delete_userinfo');
INSERT INTO `auth_permission` VALUES (28, 'Can view userinfo', 7, 'view_userinfo');
INSERT INTO `auth_permission` VALUES (29, 'Can add paper', 8, 'add_paper');
INSERT INTO `auth_permission` VALUES (30, 'Can change paper', 8, 'change_paper');
INSERT INTO `auth_permission` VALUES (31, 'Can delete paper', 8, 'delete_paper');
INSERT INTO `auth_permission` VALUES (32, 'Can view paper', 8, 'view_paper');
INSERT INTO `auth_permission` VALUES (33, 'Can add title', 9, 'add_title');
INSERT INTO `auth_permission` VALUES (34, 'Can change title', 9, 'change_title');
INSERT INTO `auth_permission` VALUES (35, 'Can delete title', 9, 'delete_title');
INSERT INTO `auth_permission` VALUES (36, 'Can view title', 9, 'view_title');
INSERT INTO `auth_permission` VALUES (37, 'Can add topic', 10, 'add_topic');
INSERT INTO `auth_permission` VALUES (38, 'Can change topic', 10, 'change_topic');
INSERT INTO `auth_permission` VALUES (39, 'Can delete topic', 10, 'delete_topic');
INSERT INTO `auth_permission` VALUES (40, 'Can view topic', 10, 'view_topic');
INSERT INTO `auth_permission` VALUES (41, 'Can add student paper', 11, 'add_studentpaper');
INSERT INTO `auth_permission` VALUES (42, 'Can change student paper', 11, 'change_studentpaper');
INSERT INTO `auth_permission` VALUES (43, 'Can delete student paper', 11, 'delete_studentpaper');
INSERT INTO `auth_permission` VALUES (44, 'Can view student paper', 11, 'view_studentpaper');
INSERT INTO `auth_permission` VALUES (45, 'Can add student answer', 12, 'add_studentanswer');
INSERT INTO `auth_permission` VALUES (46, 'Can change student answer', 12, 'change_studentanswer');
INSERT INTO `auth_permission` VALUES (47, 'Can delete student answer', 12, 'delete_studentanswer');
INSERT INTO `auth_permission` VALUES (48, 'Can view student answer', 12, 'view_studentanswer');
INSERT INTO `auth_permission` VALUES (49, 'Can add option', 13, 'add_option');
INSERT INTO `auth_permission` VALUES (50, 'Can change option', 13, 'change_option');
INSERT INTO `auth_permission` VALUES (51, 'Can delete option', 13, 'delete_option');
INSERT INTO `auth_permission` VALUES (52, 'Can view option', 13, 'view_option');
INSERT INTO `auth_permission` VALUES (53, 'Can add subject', 14, 'add_subject');
INSERT INTO `auth_permission` VALUES (54, 'Can change subject', 14, 'change_subject');
INSERT INTO `auth_permission` VALUES (55, 'Can delete subject', 14, 'delete_subject');
INSERT INTO `auth_permission` VALUES (56, 'Can view subject', 14, 'view_subject');
INSERT INTO `auth_permission` VALUES (57, 'Can add task', 15, 'add_task');
INSERT INTO `auth_permission` VALUES (58, 'Can change task', 15, 'change_task');
INSERT INTO `auth_permission` VALUES (59, 'Can delete task', 15, 'delete_task');
INSERT INTO `auth_permission` VALUES (60, 'Can view task', 15, 'view_task');

-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `object_repr` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `action_flag` smallint(5) UNSIGNED NOT NULL,
  `change_message` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `content_type_id` int(11) NULL DEFAULT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `django_admin_log_content_type_id_c4bce8eb_fk_django_co`(`content_type_id`) USING BTREE,
  INDEX `django_admin_log_user_id_c564eba6_fk_user_id`(`user_id`) USING BTREE,
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of django_admin_log
-- ----------------------------
INSERT INTO `django_admin_log` VALUES (1, '2022-11-24 09:59:52.688359', '1', '语文', 1, '[{\"added\": {}}]', 14, 1);
INSERT INTO `django_admin_log` VALUES (2, '2022-11-24 10:00:21.065314', '1', '学科科目有哪些', 1, '[{\"added\": {}}]', 9, 1);
INSERT INTO `django_admin_log` VALUES (3, '2022-11-24 10:00:37.684684', '1', '语文', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (4, '2022-11-24 10:00:44.541045', '2', '数学', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (5, '2022-11-24 10:00:52.737600', '3', '英语', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (6, '2022-11-24 10:00:59.998401', '4', '体育', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (7, '2022-11-24 10:01:48.664482', '1', '语文考试', 1, '[{\"added\": {}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (8, '2022-11-24 10:01:56.797303', '1', '选择题', 1, '[{\"added\": {}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (9, '2022-11-24 10:05:03.426754', '1', 'student的答卷:语文考试', 1, '[{\"added\": {}}]', 11, 1);
INSERT INTO `django_admin_log` VALUES (10, '2022-11-24 10:05:18.320058', '1', 'A', 1, '[{\"added\": {}}]', 12, 1);
INSERT INTO `django_admin_log` VALUES (11, '2022-11-24 11:37:22.894360', '2', '下列正确的是', 1, '[{\"added\": {}}]', 9, 1);
INSERT INTO `django_admin_log` VALUES (12, '2022-11-24 11:37:46.629093', '5', '1+1=2', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (13, '2022-11-24 11:37:57.149540', '6', '1+1=1', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (14, '2022-11-24 11:38:34.367311', '2', '判断题', 1, '[{\"added\": {}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (15, '2022-11-24 11:39:29.684900', '2', 'A', 1, '[{\"added\": {}}]', 12, 1);
INSERT INTO `django_admin_log` VALUES (16, '2022-11-24 11:42:12.877784', '2', 'student2的答卷:语文考试', 1, '[{\"added\": {}}]', 11, 1);
INSERT INTO `django_admin_log` VALUES (17, '2022-11-24 11:42:31.336313', '3', 'B', 1, '[{\"added\": {}}]', 12, 1);
INSERT INTO `django_admin_log` VALUES (18, '2022-11-24 11:42:40.781393', '4', 'B', 1, '[{\"added\": {}}]', 12, 1);
INSERT INTO `django_admin_log` VALUES (19, '2022-11-26 16:08:31.066112', '2', '数学', 1, '[{\"added\": {}}]', 14, 1);
INSERT INTO `django_admin_log` VALUES (20, '2022-11-27 12:00:03.706457', '3', 'aisudbuisb', 1, '[{\"added\": {}}]', 9, 1);
INSERT INTO `django_admin_log` VALUES (21, '2022-11-27 12:00:19.489763', '4', '1+115*45', 1, '[{\"added\": {}}]', 9, 1);
INSERT INTO `django_admin_log` VALUES (22, '2022-11-27 12:00:46.307387', '5', '篮球是什么', 1, '[{\"added\": {}}]', 9, 1);
INSERT INTO `django_admin_log` VALUES (23, '2022-11-27 12:43:08.530057', '6', '四大名著有哪些', 1, '[{\"added\": {}}]', 9, 1);
INSERT INTO `django_admin_log` VALUES (24, '2022-11-27 12:43:26.274777', '7', '水浒传', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (25, '2022-11-27 12:43:34.521511', '8', '西游记', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (26, '2022-11-27 12:43:44.862877', '9', '红楼梦', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (27, '2022-11-27 12:43:59.695673', '10', '三国演义', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (28, '2022-11-27 12:44:11.128278', '11', '金瓶梅', 1, '[{\"added\": {}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (29, '2022-11-27 12:45:43.173859', '7', '请默写出静夜思', 1, '[{\"added\": {}}]', 9, 1);
INSERT INTO `django_admin_log` VALUES (30, '2022-11-27 12:47:26.648635', '8', '西游记', 2, '[{\"changed\": {\"fields\": [\"\\u6240\\u5c5e\\u9898\\u76ee\"]}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (31, '2022-11-27 12:47:38.384389', '7', '水浒传', 2, '[{\"changed\": {\"fields\": [\"\\u6240\\u5c5e\\u9898\\u76ee\"]}}]', 13, 1);
INSERT INTO `django_admin_log` VALUES (32, '2022-11-27 13:00:27.096403', '7', '请默写出静夜思', 2, '[{\"changed\": {\"fields\": [\"\\u9898\\u76ee\\u6b63\\u786e\\u7b54\\u6848\"]}}]', 9, 1);
INSERT INTO `django_admin_log` VALUES (33, '2022-11-27 13:01:18.264478', '7', '请默写出静夜思', 2, '[{\"changed\": {\"fields\": [\"\\u9898\\u76ee\\u6b63\\u786e\\u7b54\\u6848\"]}}]', 9, 1);
INSERT INTO `django_admin_log` VALUES (34, '2022-11-27 13:02:44.072416', '7', '请默写出静夜思', 2, '[{\"changed\": {\"fields\": [\"\\u9898\\u76ee\\u6b63\\u786e\\u7b54\\u6848\"]}}]', 9, 1);

-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `model` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `django_content_type_app_label_model_76bd3d3b_uniq`(`app_label`, `model`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of django_content_type
-- ----------------------------
INSERT INTO `django_content_type` VALUES (1, 'admin', 'logentry');
INSERT INTO `django_content_type` VALUES (3, 'auth', 'group');
INSERT INTO `django_content_type` VALUES (2, 'auth', 'permission');
INSERT INTO `django_content_type` VALUES (4, 'contenttypes', 'contenttype');
INSERT INTO `django_content_type` VALUES (13, 'paper', 'option');
INSERT INTO `django_content_type` VALUES (8, 'paper', 'paper');
INSERT INTO `django_content_type` VALUES (12, 'paper', 'studentanswer');
INSERT INTO `django_content_type` VALUES (11, 'paper', 'studentpaper');
INSERT INTO `django_content_type` VALUES (14, 'paper', 'subject');
INSERT INTO `django_content_type` VALUES (15, 'paper', 'task');
INSERT INTO `django_content_type` VALUES (9, 'paper', 'title');
INSERT INTO `django_content_type` VALUES (10, 'paper', 'topic');
INSERT INTO `django_content_type` VALUES (5, 'sessions', 'session');
INSERT INTO `django_content_type` VALUES (6, 'user', 'studentclass');
INSERT INTO `django_content_type` VALUES (7, 'user', 'userinfo');

-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of django_migrations
-- ----------------------------
INSERT INTO `django_migrations` VALUES (1, 'contenttypes', '0001_initial', '2022-11-23 19:57:39.929986');
INSERT INTO `django_migrations` VALUES (2, 'contenttypes', '0002_remove_content_type_name', '2022-11-23 19:57:40.252657');
INSERT INTO `django_migrations` VALUES (3, 'auth', '0001_initial', '2022-11-23 19:57:41.499875');
INSERT INTO `django_migrations` VALUES (4, 'auth', '0002_alter_permission_name_max_length', '2022-11-23 19:57:41.795843');
INSERT INTO `django_migrations` VALUES (5, 'auth', '0003_alter_user_email_max_length', '2022-11-23 19:57:41.810887');
INSERT INTO `django_migrations` VALUES (6, 'auth', '0004_alter_user_username_opts', '2022-11-23 19:57:41.823385');
INSERT INTO `django_migrations` VALUES (7, 'auth', '0005_alter_user_last_login_null', '2022-11-23 19:57:41.834359');
INSERT INTO `django_migrations` VALUES (8, 'auth', '0006_require_contenttypes_0002', '2022-11-23 19:57:41.842387');
INSERT INTO `django_migrations` VALUES (9, 'auth', '0007_alter_validators_add_error_messages', '2022-11-23 19:57:41.857345');
INSERT INTO `django_migrations` VALUES (10, 'auth', '0008_alter_user_username_max_length', '2022-11-23 19:57:41.868777');
INSERT INTO `django_migrations` VALUES (11, 'auth', '0009_alter_user_last_name_max_length', '2022-11-23 19:57:41.879325');
INSERT INTO `django_migrations` VALUES (12, 'auth', '0010_alter_group_name_max_length', '2022-11-23 19:57:42.106383');
INSERT INTO `django_migrations` VALUES (13, 'auth', '0011_update_proxy_permissions', '2022-11-23 19:57:42.122460');
INSERT INTO `django_migrations` VALUES (14, 'auth', '0012_alter_user_first_name_max_length', '2022-11-23 19:57:42.133873');
INSERT INTO `django_migrations` VALUES (15, 'user', '0001_initial', '2022-11-23 19:57:43.755563');
INSERT INTO `django_migrations` VALUES (16, 'admin', '0001_initial', '2022-11-23 19:57:44.484569');
INSERT INTO `django_migrations` VALUES (17, 'admin', '0002_logentry_remove_auto_add', '2022-11-23 19:57:44.503518');
INSERT INTO `django_migrations` VALUES (18, 'admin', '0003_logentry_add_action_flag_choices', '2022-11-23 19:57:44.526457');
INSERT INTO `django_migrations` VALUES (19, 'paper', '0001_initial', '2022-11-23 19:57:46.273607');
INSERT INTO `django_migrations` VALUES (20, 'paper', '0002_auto_20221123_1841', '2022-11-23 19:57:46.303527');
INSERT INTO `django_migrations` VALUES (21, 'paper', '0003_auto_20221123_1858', '2022-11-23 19:57:46.446453');
INSERT INTO `django_migrations` VALUES (22, 'paper', '0004_auto_20221123_1954', '2022-11-23 19:57:48.414978');
INSERT INTO `django_migrations` VALUES (23, 'sessions', '0001_initial', '2022-11-23 19:57:48.587412');
INSERT INTO `django_migrations` VALUES (24, 'user', '0002_alter_userinfo_student_class', '2022-11-23 19:57:48.607938');
INSERT INTO `django_migrations` VALUES (25, 'paper', '0005_alter_studentanswer_title', '2022-11-24 09:52:22.447901');
INSERT INTO `django_migrations` VALUES (26, 'paper', '0006_auto_20221124_0959', '2022-11-24 09:59:23.328283');
INSERT INTO `django_migrations` VALUES (27, 'paper', '0007_auto_20221124_1332', '2022-11-24 13:33:39.092551');
INSERT INTO `django_migrations` VALUES (28, 'paper', '0008_auto_20221124_1340', '2022-11-24 13:40:37.449239');
INSERT INTO `django_migrations` VALUES (29, 'user', '0003_alter_userinfo_role', '2022-11-25 13:28:15.471276');
INSERT INTO `django_migrations` VALUES (30, 'user', '0004_alter_userinfo_student_class', '2022-11-25 16:18:53.559376');
INSERT INTO `django_migrations` VALUES (31, 'paper', '0009_alter_studentpaper_student', '2022-11-25 16:45:17.278451');
INSERT INTO `django_migrations` VALUES (32, 'paper', '0010_auto_20221127_1242', '2022-11-27 12:42:52.835311');
INSERT INTO `django_migrations` VALUES (33, 'paper', '0011_alter_option_option', '2022-11-27 15:27:52.695990');
INSERT INTO `django_migrations` VALUES (34, 'paper', '0012_rename_title_topic_titles', '2022-11-28 16:31:41.849027');
INSERT INTO `django_migrations` VALUES (35, 'paper', '0013_alter_topic_paper', '2022-11-28 18:48:16.363475');
INSERT INTO `django_migrations` VALUES (36, 'paper', '0014_title_answer_blank', '2022-11-29 11:19:32.114429');
INSERT INTO `django_migrations` VALUES (37, 'paper', '0015_rename_answer_blank_title_blank', '2022-11-29 11:20:34.042556');
INSERT INTO `django_migrations` VALUES (38, 'paper', '0016_alter_title_blank', '2022-11-29 11:21:23.497268');
INSERT INTO `django_migrations` VALUES (39, 'paper', '0017_remove_title_blank', '2022-11-29 11:52:08.284626');
INSERT INTO `django_migrations` VALUES (40, 'paper', '0018_alter_studentanswer_student_paper', '2022-11-29 14:52:33.961736');
INSERT INTO `django_migrations` VALUES (41, 'paper', '0019_auto_20221129_1519', '2022-11-29 15:19:30.571289');
INSERT INTO `django_migrations` VALUES (42, 'paper', '0020_task_paper', '2022-11-29 15:22:31.950992');
INSERT INTO `django_migrations` VALUES (43, 'paper', '0021_task_name', '2022-11-29 15:28:25.739591');
INSERT INTO `django_migrations` VALUES (44, 'paper', '0022_auto_20221129_1546', '2022-11-29 15:46:55.841965');
INSERT INTO `django_migrations` VALUES (45, 'paper', '0023_auto_20221129_1944', '2022-11-29 19:44:52.097828');
INSERT INTO `django_migrations` VALUES (46, 'paper', '0024_remove_task_status', '2022-11-29 19:55:47.689901');
INSERT INTO `django_migrations` VALUES (47, 'paper', '0025_alter_studentpaper_task', '2022-11-30 08:38:46.965719');
INSERT INTO `django_migrations` VALUES (48, 'paper', '0026_auto_20221130_0943', '2022-11-30 09:43:12.327008');
INSERT INTO `django_migrations` VALUES (49, 'paper', '0027_alter_studentpaper_duration', '2022-11-30 09:49:55.472407');
INSERT INTO `django_migrations` VALUES (50, 'paper', '0028_alter_studentpaper_status', '2022-12-02 08:58:55.999446');
INSERT INTO `django_migrations` VALUES (51, 'paper', '0029_alter_studentpaper_status', '2022-12-02 09:01:23.569229');
INSERT INTO `django_migrations` VALUES (52, 'paper', '0030_alter_studentpaper_status', '2022-12-02 09:21:10.070295');
INSERT INTO `django_migrations` VALUES (53, 'paper', '0031_alter_option_option', '2022-12-02 09:24:26.667219');
INSERT INTO `django_migrations` VALUES (54, 'paper', '0032_auto_20221202_2000', '2022-12-02 20:00:47.762233');
INSERT INTO `django_migrations` VALUES (55, 'user', '0005_alter_userinfo_icon', '2022-12-03 15:33:12.050317');
INSERT INTO `django_migrations` VALUES (56, 'user', '0006_alter_userinfo_icon', '2022-12-03 20:29:12.315713');
INSERT INTO `django_migrations` VALUES (57, 'paper', '0033_auto_20221227_1622', '2022-12-27 16:22:10.854202');
INSERT INTO `django_migrations` VALUES (58, 'user', '0007_alter_studentclass_table', '2022-12-27 16:22:10.944138');

-- ----------------------------
-- Table structure for django_session
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session`  (
  `session_key` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `session_data` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`) USING BTREE,
  INDEX `django_session_expire_date_a5c62663`(`expire_date`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of django_session
-- ----------------------------
INSERT INTO `django_session` VALUES ('9moxv6401254x6zq0gva5p8sab8xmba2', '.eJzFlk1zmzAQhv9KhrM_-BCSyLH33tpTyXhWH9gkGDwIpoeM_3slTDtYkQvGGXLxjrWvV3qfFYvfvR20zWHXKlnvcuE9e4G3Gq4x4G-yNAnxCuW-2vCqbOqcbYxk02fV5nslZPGt114VOIA66F-H2Mc8BJKxLEsQxYIQLDMGgBmJwwTiUCQUGEUhQkxEPlAgPvMTP4gQDxg1RY-ybJWu9es99Uo4ytR7fkq9NG11BaoDDiOSeiu9lutTXrIZ1E8ZrHle80JekkdzVmXSHwtFUpgggehAKaYT6rV1ccltQRzzcmtsb1XTClk2vAClthcdCPFzVKpFvZzVEgSv2yO7cdbJps-rp4eNnl9MWubCZAPfD11FByd6jJ75yMusGiH3T7YUtXsN2tQieyFw7EIZoC7wQIcYUW72jGi3NUHRxz2V2VMdclmINRTN-DWXHN2oYpCqNa_27u6Y53q7r6v2dLs1A830vnyCaVfDJhm1mxLbC8jZJRGbk0bkkZnzA9SbmvGUnOCk73-jf327DwPNPX2YastmMsWKDZY4wMYM4-5ZCzIdkAyhC8wEwmI0HbobWj9uL19G4F1pl4D4af5t0nR0p742pmjO2L7iBaX6PRluL_4SutM92zyT_9RORDAIWMr5PFv2KnkzSrKXLczwXp8Ww8B31ea-aUxCE_oovCZvCjk6HjvRUuDuNWcTc_1dIEC60YCJuPu15AY3aTQuOhPnerT5uf61DqvpkISkmwg--dup2fevOuV89P51ooUwPmjVphk5thjebf1ND8pukSSzMVanJq_KMY69aiGQc13aBJH9WsHnF-_8B-1M2V8:1oz9R1:HnpyLLjlZPve8RjSAPhRSXjOQf0tFWTUnHzpnNJFuzA', '2022-12-11 12:38:31.384246');

-- ----------------------------
-- Table structure for option
-- ----------------------------
DROP TABLE IF EXISTS `option`;
CREATE TABLE `option`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `prefix` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `option_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `Option_option_id_e4cf3f37_fk_Title_id`(`option_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of option
-- ----------------------------
INSERT INTO `option` VALUES (30, 'A', '是', 23);
INSERT INTO `option` VALUES (31, 'B', '不是', 23);
INSERT INTO `option` VALUES (32, 'A', '正确', 24);
INSERT INTO `option` VALUES (33, 'B', '错误', 24);
INSERT INTO `option` VALUES (34, 'A', 'unsigned int', 25);
INSERT INTO `option` VALUES (35, 'B', 'bit', 25);
INSERT INTO `option` VALUES (36, 'C', 'byte', 25);
INSERT INTO `option` VALUES (37, 'D', 'string', 25);
INSERT INTO `option` VALUES (38, 'A', 'os', 26);
INSERT INTO `option` VALUES (39, 'B', 'sys', 26);
INSERT INTO `option` VALUES (40, 'C', 'django-redis', 26);
INSERT INTO `option` VALUES (41, 'D', 'collection', 26);
INSERT INTO `option` VALUES (42, 'A', 'multiprocessing', 27);
INSERT INTO `option` VALUES (43, 'B', 'threading', 27);
INSERT INTO `option` VALUES (44, 'C', 'zip', 27);
INSERT INTO `option` VALUES (45, 'D', 'subprocess', 27);
INSERT INTO `option` VALUES (46, 'E', 'threadingpool', 27);
INSERT INTO `option` VALUES (47, 'A', '正确', 30);
INSERT INTO `option` VALUES (48, 'B', '错误', 30);
INSERT INTO `option` VALUES (49, 'A', '正确', 31);
INSERT INTO `option` VALUES (50, 'B', '错误', 31);
INSERT INTO `option` VALUES (51, 'A', '缓存', 32);
INSERT INTO `option` VALUES (52, 'B', 'django', 32);
INSERT INTO `option` VALUES (53, 'C', 'orm', 32);
INSERT INTO `option` VALUES (54, 'D', '事务的原子性', 32);
INSERT INTO `option` VALUES (55, 'A', 'integerfield', 33);
INSERT INTO `option` VALUES (56, 'B', 'decimalfield', 33);
INSERT INTO `option` VALUES (57, 'C', 'dictfield', 33);
INSERT INTO `option` VALUES (58, 'D', 'varchar(64)', 33);
INSERT INTO `option` VALUES (59, 'A', 'B树', 34);
INSERT INTO `option` VALUES (60, 'B', 'B+树', 34);
INSERT INTO `option` VALUES (61, 'C', 'B*树', 34);
INSERT INTO `option` VALUES (62, 'D', '脏读', 34);
INSERT INTO `option` VALUES (63, 'E', '幻读', 34);
INSERT INTO `option` VALUES (64, 'A', '事务操作transaction', 35);
INSERT INTO `option` VALUES (65, 'B', '事务的原子性', 35);
INSERT INTO `option` VALUES (66, 'C', '事务的回退', 35);
INSERT INTO `option` VALUES (67, 'D', '连表操作', 35);
INSERT INTO `option` VALUES (68, 'E', '子查询', 35);
INSERT INTO `option` VALUES (69, 'A', 'django-redis', 36);
INSERT INTO `option` VALUES (70, 'B', 'django', 36);
INSERT INTO `option` VALUES (71, 'C', 'djangorestframework', 36);
INSERT INTO `option` VALUES (72, 'D', 'pymysql', 36);
INSERT INTO `option` VALUES (73, 'E', 'os', 36);
INSERT INTO `option` VALUES (74, 'A', '脏读', 37);
INSERT INTO `option` VALUES (75, 'B', '幻读', 37);
INSERT INTO `option` VALUES (76, 'C', '不可重复度', 37);
INSERT INTO `option` VALUES (77, 'D', '可重复读', 37);
INSERT INTO `option` VALUES (78, 'E', 'insert into', 37);
INSERT INTO `option` VALUES (79, 'F', 'drop database', 37);
INSERT INTO `option` VALUES (80, 'A', 'select from', 38);
INSERT INTO `option` VALUES (81, 'B', 'inner join', 38);
INSERT INTO `option` VALUES (82, 'C', 'group by', 38);
INSERT INTO `option` VALUES (83, 'D', 'limit', 38);
INSERT INTO `option` VALUES (84, 'E', 'delete', 38);
INSERT INTO `option` VALUES (85, 'A', 'sha256', 39);
INSERT INTO `option` VALUES (86, 'B', 'md5', 39);
INSERT INTO `option` VALUES (87, 'C', 'base64', 39);
INSERT INTO `option` VALUES (88, 'D', 'sha512', 39);
INSERT INTO `option` VALUES (89, 'E', 'md6', 39);
INSERT INTO `option` VALUES (90, 'A', 'pillow', 40);
INSERT INTO `option` VALUES (91, 'B', 'simpleui', 40);
INSERT INTO `option` VALUES (92, 'C', 'jason', 40);
INSERT INTO `option` VALUES (93, 'D', 'json', 40);
INSERT INTO `option` VALUES (94, 'E', 'pikle', 40);

-- ----------------------------
-- Table structure for paper
-- ----------------------------
DROP TABLE IF EXISTS `paper`;
CREATE TABLE `paper`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `paper_score` decimal(10, 2) NOT NULL,
  `subject_id` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `Paper_subject_id_bac9e72e`(`subject_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of paper
-- ----------------------------
INSERT INTO `paper` VALUES (13, 'python基础阶段测试', '2022-11-30 18:49:15.761272', 40.00, 3);
INSERT INTO `paper` VALUES (15, 'mysql七天快速入门测试考试', '2022-12-02 09:59:24.240719', 40.00, 4);
INSERT INTO `paper` VALUES (16, '七天快速入门mysql阶段性测试', '2022-12-03 20:46:07.824624', 50.00, 4);
INSERT INTO `paper` VALUES (17, '30天入门python基础，阶段性测试', '2022-12-03 20:48:12.277326', 50.00, 3);

-- ----------------------------
-- Table structure for studentanswer
-- ----------------------------
DROP TABLE IF EXISTS `studentanswer`;
CREATE TABLE `studentanswer`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `student_paper_id` bigint(20) NOT NULL,
  `title_id` bigint(20) NULL DEFAULT NULL,
  `student_score` decimal(6, 2) NULL DEFAULT NULL,
  `is_right` smallint(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `StudentAnswer_student_paper_id_e681ad6a`(`student_paper_id`) USING BTREE,
  INDEX `StudentAnswer_title_id_0ebe32d8`(`title_id`) USING BTREE,
  CONSTRAINT `StudentAnswer_student_paper_id_e681ad6a_fk_StudentPaper_id` FOREIGN KEY (`student_paper_id`) REFERENCES `studentpaper` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1631 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of studentanswer
-- ----------------------------
INSERT INTO `studentanswer` VALUES (891, 'D', 188, 25, 5.00, 1);
INSERT INTO `studentanswer` VALUES (892, 'C', 188, 26, 5.00, 1);
INSERT INTO `studentanswer` VALUES (893, 'B', 188, 23, 5.00, 1);
INSERT INTO `studentanswer` VALUES (894, 'A', 188, 24, 5.00, 1);
INSERT INTO `studentanswer` VALUES (895, 'ABE', 188, 27, 0.00, 3);
INSERT INTO `studentanswer` VALUES (896, 'ABCD', 188, 36, 5.00, 1);
INSERT INTO `studentanswer` VALUES (897, 'ABD', 188, 39, 5.00, 1);
INSERT INTO `studentanswer` VALUES (898, 'DE', 188, 40, 5.00, 1);
INSERT INTO `studentanswer` VALUES (899, 'int float string', 188, 21, 2.00, 2);
INSERT INTO `studentanswer` VALUES (900, 'os time sys json pickle datetime', 188, 22, 4.00, 2);
INSERT INTO `studentanswer` VALUES (901, 'D', 189, 25, 5.00, 1);
INSERT INTO `studentanswer` VALUES (902, 'C', 189, 26, 5.00, 1);
INSERT INTO `studentanswer` VALUES (903, 'B', 189, 23, 5.00, 1);
INSERT INTO `studentanswer` VALUES (904, 'A', 189, 24, 5.00, 1);
INSERT INTO `studentanswer` VALUES (905, 'AB', 189, 27, 5.00, 1);
INSERT INTO `studentanswer` VALUES (906, 'ABCD', 189, 36, 5.00, 1);
INSERT INTO `studentanswer` VALUES (907, 'ABD', 189, 39, 5.00, 1);
INSERT INTO `studentanswer` VALUES (908, 'D', 189, 40, 2.50, 2);
INSERT INTO `studentanswer` VALUES (909, 'int double dict', 189, 21, 3.00, 2);
INSERT INTO `studentanswer` VALUES (910, 'os sys time threading', 189, 22, 2.00, 2);
INSERT INTO `studentanswer` VALUES (911, 'D', 190, 25, 5.00, 1);
INSERT INTO `studentanswer` VALUES (912, 'B', 190, 26, 0.00, 3);
INSERT INTO `studentanswer` VALUES (913, 'A', 190, 23, 0.00, 3);
INSERT INTO `studentanswer` VALUES (914, 'A', 190, 24, 5.00, 1);
INSERT INTO `studentanswer` VALUES (915, 'BA', 190, 27, 5.00, 1);
INSERT INTO `studentanswer` VALUES (916, 'CBA', 190, 36, 2.50, 2);
INSERT INTO `studentanswer` VALUES (917, 'ABC', 190, 39, 0.00, 3);
INSERT INTO `studentanswer` VALUES (918, 'DE', 190, 40, 5.00, 1);
INSERT INTO `studentanswer` VALUES (919, 'dict list set tuple', 190, 21, 2.00, 2);
INSERT INTO `studentanswer` VALUES (920, 'os sys time datetime ', 190, 22, 3.00, 2);
INSERT INTO `studentanswer` VALUES (921, 'C', 191, 25, 0.00, 3);
INSERT INTO `studentanswer` VALUES (922, 'C', 191, 26, 5.00, 1);
INSERT INTO `studentanswer` VALUES (923, 'B', 191, 23, 5.00, 1);
INSERT INTO `studentanswer` VALUES (924, 'A', 191, 24, 5.00, 1);
INSERT INTO `studentanswer` VALUES (925, 'AB', 191, 27, 5.00, 1);
INSERT INTO `studentanswer` VALUES (926, 'BACD', 191, 36, 5.00, 1);
INSERT INTO `studentanswer` VALUES (927, 'AB', 191, 39, 2.50, 2);
INSERT INTO `studentanswer` VALUES (928, 'DE', 191, 40, 5.00, 1);
INSERT INTO `studentanswer` VALUES (929, 'int double string float dict list set tuple', 191, 21, 5.00, 1);
INSERT INTO `studentanswer` VALUES (930, 'json pickle time datetime threading', 191, 22, 4.00, 2);
INSERT INTO `studentanswer` VALUES (931, 'D', 192, 25, 5.00, 1);
INSERT INTO `studentanswer` VALUES (932, 'C', 192, 26, 5.00, 1);
INSERT INTO `studentanswer` VALUES (933, 'B', 192, 23, 5.00, 1);
INSERT INTO `studentanswer` VALUES (934, 'A', 192, 24, 5.00, 1);
INSERT INTO `studentanswer` VALUES (935, 'AB', 192, 27, 5.00, 1);
INSERT INTO `studentanswer` VALUES (936, 'BACD', 192, 36, 5.00, 1);
INSERT INTO `studentanswer` VALUES (937, 'AB', 192, 39, 2.50, 2);
INSERT INTO `studentanswer` VALUES (938, 'DE', 192, 40, 5.00, 1);
INSERT INTO `studentanswer` VALUES (939, 'int float dict string list tuple set ', 192, 21, 5.00, 1);
INSERT INTO `studentanswer` VALUES (940, 'os sys multiprocessing threading time datetime json pickle', 192, 22, 4.00, 2);
INSERT INTO `studentanswer` VALUES (941, 'C', 193, 25, 0.00, 3);
INSERT INTO `studentanswer` VALUES (942, 'D', 193, 26, 0.00, 3);
INSERT INTO `studentanswer` VALUES (943, 'A', 193, 23, 0.00, 3);
INSERT INTO `studentanswer` VALUES (944, 'B', 193, 24, 0.00, 3);
INSERT INTO `studentanswer` VALUES (945, 'CB', 193, 27, 0.00, 3);
INSERT INTO `studentanswer` VALUES (946, 'ED', 193, 36, 0.00, 3);
INSERT INTO `studentanswer` VALUES (947, 'BCDE', 193, 39, 0.00, 3);
INSERT INTO `studentanswer` VALUES (948, 'D', 193, 40, 2.50, 2);
INSERT INTO `studentanswer` VALUES (949, 'int char', 193, 21, 1.00, 2);
INSERT INTO `studentanswer` VALUES (950, 'django', 193, 22, 0.00, 3);
INSERT INTO `studentanswer` VALUES (951, 'D', 194, 25, 5.00, 1);
INSERT INTO `studentanswer` VALUES (952, 'C', 194, 26, 5.00, 1);
INSERT INTO `studentanswer` VALUES (953, 'A', 194, 23, 0.00, 3);
INSERT INTO `studentanswer` VALUES (954, 'A', 194, 24, 5.00, 1);
INSERT INTO `studentanswer` VALUES (955, 'AB', 194, 27, 5.00, 1);
INSERT INTO `studentanswer` VALUES (956, 'ABCD', 194, 36, 5.00, 1);
INSERT INTO `studentanswer` VALUES (957, 'AB', 194, 39, 2.50, 2);
INSERT INTO `studentanswer` VALUES (958, 'DE', 194, 40, 5.00, 1);
INSERT INTO `studentanswer` VALUES (959, 'int float list', 194, 21, 2.00, 2);
INSERT INTO `studentanswer` VALUES (960, 'os sys time', 194, 22, 1.00, 2);
INSERT INTO `studentanswer` VALUES (961, 'D', 195, 25, 5.00, 1);
INSERT INTO `studentanswer` VALUES (962, 'C', 195, 26, 5.00, 1);
INSERT INTO `studentanswer` VALUES (963, 'B', 195, 23, 5.00, 1);
INSERT INTO `studentanswer` VALUES (964, 'A', 195, 24, 5.00, 1);
INSERT INTO `studentanswer` VALUES (965, 'AB', 195, 27, 5.00, 1);
INSERT INTO `studentanswer` VALUES (966, 'BAC', 195, 36, 2.50, 2);
INSERT INTO `studentanswer` VALUES (967, 'AB', 195, 39, 2.50, 2);
INSERT INTO `studentanswer` VALUES (968, 'BC', 195, 40, 0.00, 3);
INSERT INTO `studentanswer` VALUES (969, 'int string list dixt', 195, 21, 3.00, 2);
INSERT INTO `studentanswer` VALUES (970, 'os sys time datetime', 195, 22, 3.00, 2);
INSERT INTO `studentanswer` VALUES (971, 'D', 196, 25, 5.00, 1);
INSERT INTO `studentanswer` VALUES (972, 'C', 196, 26, 5.00, 1);
INSERT INTO `studentanswer` VALUES (973, 'B', 196, 23, 5.00, 1);
INSERT INTO `studentanswer` VALUES (974, 'A', 196, 24, 5.00, 1);
INSERT INTO `studentanswer` VALUES (975, 'AB', 196, 27, 5.00, 1);
INSERT INTO `studentanswer` VALUES (976, 'ABCD', 196, 36, 5.00, 1);
INSERT INTO `studentanswer` VALUES (977, 'ABD', 196, 39, 5.00, 1);
INSERT INTO `studentanswer` VALUES (978, 'DE', 196, 40, 5.00, 1);
INSERT INTO `studentanswer` VALUES (979, 'int float string double dict list tuple set ', 196, 21, 5.00, 1);
INSERT INTO `studentanswer` VALUES (980, 'sys time os datetime zip reduce collection ', 196, 22, 4.00, 2);
INSERT INTO `studentanswer` VALUES (981, 'D', 197, 25, 5.00, 1);
INSERT INTO `studentanswer` VALUES (982, 'C', 197, 26, 5.00, 1);
INSERT INTO `studentanswer` VALUES (983, 'B', 197, 23, 5.00, 1);
INSERT INTO `studentanswer` VALUES (984, 'A', 197, 24, 5.00, 1);
INSERT INTO `studentanswer` VALUES (985, 'AB', 197, 27, 5.00, 1);
INSERT INTO `studentanswer` VALUES (986, 'ABCDE', 197, 36, 0.00, 3);
INSERT INTO `studentanswer` VALUES (987, 'AB', 197, 39, 2.50, 2);
INSERT INTO `studentanswer` VALUES (988, 'DE', 197, 40, 5.00, 1);
INSERT INTO `studentanswer` VALUES (989, 'int float dict list set tuple', 197, 21, 4.00, 2);
INSERT INTO `studentanswer` VALUES (990, 'os sys time json ', 197, 22, 2.00, 2);
INSERT INTO `studentanswer` VALUES (991, 'D', 198, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (992, 'C', 198, 33, 0.00, 3);
INSERT INTO `studentanswer` VALUES (993, 'CE', 198, 34, 0.00, 3);
INSERT INTO `studentanswer` VALUES (994, 'BD', 198, 35, 2.50, 2);
INSERT INTO `studentanswer` VALUES (995, 'CBAD', 198, 37, 5.00, 1);
INSERT INTO `studentanswer` VALUES (996, 'AB', 198, 38, 2.50, 2);
INSERT INTO `studentanswer` VALUES (997, 'B', 198, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (998, 'A', 198, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (999, '关系型数据库', 198, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1000, '原子性 一致性 隔离性 持久性', 198, 29, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1001, 'D', 199, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1002, 'C', 199, 33, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1003, 'CAB', 199, 34, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1004, 'ABCE', 199, 35, 2.50, 2);
INSERT INTO `studentanswer` VALUES (1005, 'ABCD', 199, 37, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1006, 'ABCD', 199, 38, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1007, 'B', 199, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1008, 'A', 199, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1009, '关系型数据库', 199, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1010, 'acid', 199, 29, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1011, 'B', 200, 32, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1012, 'D', 200, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1013, 'BAC', 200, 34, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1014, 'ABCDE', 200, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1015, 'ABCD', 200, 37, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1016, 'ABCD', 200, 38, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1017, 'B', 200, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1018, 'A', 200, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1019, '刮吸星数据库', 200, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1020, '无', 200, 29, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1021, 'B', 201, 32, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1022, 'D', 201, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1023, 'ABC', 201, 34, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1024, 'ABCDE', 201, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1025, 'ABCD', 201, 37, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1026, 'ABCD', 201, 38, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1027, 'B', 201, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1028, 'A', 201, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1029, '关系型数据库', 201, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1030, 'acid', 201, 29, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1031, NULL, 202, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1032, NULL, 202, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1033, NULL, 202, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1034, NULL, 202, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1035, NULL, 202, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1036, NULL, 202, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1037, NULL, 202, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1038, NULL, 202, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1039, NULL, 202, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1040, NULL, 202, 29, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1041, 'B', 203, 32, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1042, 'D', 203, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1043, 'BAC', 203, 34, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1044, 'ABCDE', 203, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1045, 'ABCD', 203, 37, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1046, 'ABCD', 203, 38, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1047, 'B', 203, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1048, 'A', 203, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1049, '关系型数据库', 203, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1050, 'acid', 203, 29, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1051, NULL, 204, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1052, NULL, 204, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1053, NULL, 204, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1054, NULL, 204, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1055, NULL, 204, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1056, NULL, 204, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1057, NULL, 204, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1058, NULL, 204, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1059, NULL, 204, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1060, NULL, 204, 29, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1061, NULL, 205, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1062, NULL, 205, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1063, NULL, 205, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1064, NULL, 205, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1065, NULL, 205, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1066, NULL, 205, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1067, NULL, 205, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1068, NULL, 205, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1069, NULL, 205, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1070, NULL, 205, 29, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1071, NULL, 206, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1072, NULL, 206, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1073, NULL, 206, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1074, NULL, 206, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1075, NULL, 206, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1076, NULL, 206, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1077, NULL, 206, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1078, NULL, 206, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1079, NULL, 206, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1080, NULL, 206, 29, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1081, NULL, 207, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1082, NULL, 207, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1083, NULL, 207, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1084, NULL, 207, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1085, NULL, 207, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1086, NULL, 207, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1087, NULL, 207, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1088, NULL, 207, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1089, NULL, 207, 28, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1090, NULL, 207, 29, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1171, 'D', 218, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1172, 'D', 218, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1173, 'AB', 218, 34, 2.50, 2);
INSERT INTO `studentanswer` VALUES (1174, 'ABCE', 218, 35, 2.50, 2);
INSERT INTO `studentanswer` VALUES (1175, 'BAE', 218, 37, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1176, 'DECBA', 218, 38, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1177, 'A', 218, 30, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1178, 'A', 218, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1179, '关系型数据库', 218, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1180, '<p>ASCID</p>', 218, 29, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1181, 'D', 219, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1182, 'C', 219, 33, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1183, 'ABCDE', 219, 34, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1184, 'ABCDE', 219, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1185, 'ABCDE', 219, 37, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1186, 'ABCE', 219, 38, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1187, 'B', 219, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1188, 'A', 219, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1189, '关系型数据库 支持连表操作', 219, 28, 2.00, 2);
INSERT INTO `studentanswer` VALUES (1190, '原子性', 219, 29, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1191, 'D', 220, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1192, 'D', 220, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1193, 'BAC', 220, 34, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1194, 'ABCDE', 220, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1195, 'ABCDEF', 220, 37, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1196, 'ABCDE', 220, 38, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1197, 'B', 220, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1198, 'A', 220, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1199, 'mysql是一个关系型数据库 支持事务操作&nbsp;', 220, 28, 2.00, 2);
INSERT INTO `studentanswer` VALUES (1200, 'ACID 原子性 一致性 隔离性 持久性', 220, 29, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1201, 'D', 221, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1202, 'D', 221, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1203, 'CBADE', 221, 34, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1204, 'ABCDE', 221, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1205, 'ABCDEF', 221, 37, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1206, 'ABCDE', 221, 38, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1207, 'B', 221, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1208, 'A', 221, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1209, '关系型数据库<br/><br/>', 221, 28, 1.00, 2);
INSERT INTO `studentanswer` VALUES (1210, 'ACID', 221, 29, 2.00, 2);
INSERT INTO `studentanswer` VALUES (1211, 'D', 222, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1212, 'D', 222, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1213, 'CBA', 222, 34, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1214, 'ABCDE', 222, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1215, 'ABCD', 222, 37, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1216, 'ABCD', 222, 38, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1217, 'B', 222, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1218, 'A', 222, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1219, '<p>关系型数据库</p>', 222, 28, 4.00, 2);
INSERT INTO `studentanswer` VALUES (1220, 'ACID', 222, 29, 3.00, 2);
INSERT INTO `studentanswer` VALUES (1221, 'D', 223, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1222, 'D', 223, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1223, 'AB', 223, 34, 2.50, 2);
INSERT INTO `studentanswer` VALUES (1224, 'ABCDE', 223, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1225, 'ABCDE', 223, 37, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1226, 'ABE', 223, 38, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1227, 'B', 223, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1228, 'A', 223, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1229, '关系型数据库', 223, 28, 2.00, 2);
INSERT INTO `studentanswer` VALUES (1230, 'ACID', 223, 29, 3.00, 2);
INSERT INTO `studentanswer` VALUES (1231, 'D', 224, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1232, 'D', 224, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1233, 'BAC', 224, 34, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1234, 'ABCDE', 224, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1235, 'ABCD', 224, 37, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1236, 'ABCDE', 224, 38, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1237, 'B', 224, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1238, 'A', 224, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1239, '不知道', 224, 28, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1240, 'ASBD', 224, 29, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1241, 'D', 225, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1242, 'D', 225, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1243, 'ABC', 225, 34, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1244, 'ABDCE', 225, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1245, 'ABCD', 225, 37, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1246, 'ABC', 225, 38, 2.50, 2);
INSERT INTO `studentanswer` VALUES (1247, 'B', 225, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1248, 'A', 225, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1249, '关系型数据库', 225, 28, 2.00, 2);
INSERT INTO `studentanswer` VALUES (1250, 'ACID', 225, 29, 3.00, 2);
INSERT INTO `studentanswer` VALUES (1251, 'D', 226, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1252, 'D', 226, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1253, 'AB', 226, 34, 2.50, 2);
INSERT INTO `studentanswer` VALUES (1254, 'ABCDE', 226, 35, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1255, 'ACDF', 226, 37, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1256, 'ABCDE', 226, 38, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1257, 'B', 226, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1258, 'A', 226, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1259, 'sql数据库 不知道 垃圾', 226, 28, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1260, '特性不知道 没学过&nbsp;', 226, 29, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1261, 'D', 227, 32, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1262, 'D', 227, 33, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1263, 'BAC', 227, 34, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1264, 'ABCD', 227, 35, 2.50, 2);
INSERT INTO `studentanswer` VALUES (1265, 'ABCDE', 227, 37, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1266, 'ABCDE', 227, 38, 0.00, 3);
INSERT INTO `studentanswer` VALUES (1267, 'B', 227, 30, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1268, 'A', 227, 31, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1269, '关系型数据库 并发量不如redis高 可连表', 227, 28, 4.00, 2);
INSERT INTO `studentanswer` VALUES (1270, 'ACID 原子性 隔离性 持久性 一致性', 227, 29, 5.00, 1);
INSERT INTO `studentanswer` VALUES (1531, NULL, 258, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1532, NULL, 258, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1533, NULL, 258, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1534, NULL, 258, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1535, NULL, 258, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1536, NULL, 258, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1537, NULL, 258, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1538, NULL, 258, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1539, NULL, 258, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1540, NULL, 258, 29, NULL, 0);
INSERT INTO `studentanswer` VALUES (1541, NULL, 259, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1542, NULL, 259, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1543, NULL, 259, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1544, NULL, 259, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1545, NULL, 259, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1546, NULL, 259, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1547, NULL, 259, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1548, NULL, 259, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1549, NULL, 259, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1550, NULL, 259, 29, NULL, 0);
INSERT INTO `studentanswer` VALUES (1551, NULL, 260, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1552, NULL, 260, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1553, NULL, 260, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1554, NULL, 260, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1555, NULL, 260, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1556, NULL, 260, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1557, NULL, 260, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1558, NULL, 260, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1559, NULL, 260, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1560, NULL, 260, 29, NULL, 0);
INSERT INTO `studentanswer` VALUES (1561, NULL, 261, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1562, NULL, 261, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1563, NULL, 261, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1564, NULL, 261, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1565, NULL, 261, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1566, NULL, 261, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1567, NULL, 261, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1568, NULL, 261, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1569, NULL, 261, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1570, NULL, 261, 29, NULL, 0);
INSERT INTO `studentanswer` VALUES (1571, NULL, 262, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1572, NULL, 262, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1573, NULL, 262, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1574, NULL, 262, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1575, NULL, 262, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1576, NULL, 262, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1577, NULL, 262, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1578, NULL, 262, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1579, NULL, 262, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1580, NULL, 262, 29, NULL, 0);
INSERT INTO `studentanswer` VALUES (1581, NULL, 263, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1582, NULL, 263, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1583, NULL, 263, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1584, NULL, 263, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1585, NULL, 263, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1586, NULL, 263, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1587, NULL, 263, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1588, NULL, 263, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1589, NULL, 263, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1590, NULL, 263, 29, NULL, 0);
INSERT INTO `studentanswer` VALUES (1591, NULL, 264, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1592, NULL, 264, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1593, NULL, 264, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1594, NULL, 264, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1595, NULL, 264, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1596, NULL, 264, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1597, NULL, 264, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1598, NULL, 264, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1599, NULL, 264, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1600, NULL, 264, 29, NULL, 0);
INSERT INTO `studentanswer` VALUES (1601, NULL, 265, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1602, NULL, 265, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1603, NULL, 265, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1604, NULL, 265, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1605, NULL, 265, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1606, NULL, 265, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1607, NULL, 265, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1608, NULL, 265, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1609, NULL, 265, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1610, NULL, 265, 29, NULL, 0);
INSERT INTO `studentanswer` VALUES (1611, NULL, 266, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1612, NULL, 266, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1613, NULL, 266, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1614, NULL, 266, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1615, NULL, 266, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1616, NULL, 266, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1617, NULL, 266, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1618, NULL, 266, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1619, NULL, 266, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1620, NULL, 266, 29, NULL, 0);
INSERT INTO `studentanswer` VALUES (1621, NULL, 267, 32, NULL, 0);
INSERT INTO `studentanswer` VALUES (1622, NULL, 267, 33, NULL, 0);
INSERT INTO `studentanswer` VALUES (1623, NULL, 267, 34, NULL, 0);
INSERT INTO `studentanswer` VALUES (1624, NULL, 267, 35, NULL, 0);
INSERT INTO `studentanswer` VALUES (1625, NULL, 267, 37, NULL, 0);
INSERT INTO `studentanswer` VALUES (1626, NULL, 267, 38, NULL, 0);
INSERT INTO `studentanswer` VALUES (1627, NULL, 267, 30, NULL, 0);
INSERT INTO `studentanswer` VALUES (1628, NULL, 267, 31, NULL, 0);
INSERT INTO `studentanswer` VALUES (1629, NULL, 267, 28, NULL, 0);
INSERT INTO `studentanswer` VALUES (1630, NULL, 267, 29, NULL, 0);

-- ----------------------------
-- Table structure for studentclass
-- ----------------------------
DROP TABLE IF EXISTS `studentclass`;
CREATE TABLE `studentclass`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `students` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of studentclass
-- ----------------------------
INSERT INTO `studentclass` VALUES (5, '六年级二班', '2022-11-30 18:17:46.505090', 6);
INSERT INTO `studentclass` VALUES (6, '14级二班', '2022-11-30 18:18:08.892167', 4);

-- ----------------------------
-- Table structure for studentpaper
-- ----------------------------
DROP TABLE IF EXISTS `studentpaper`;
CREATE TABLE `studentpaper`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `paper_id` bigint(20) NULL DEFAULT NULL,
  `student_id` bigint(20) NULL DEFAULT NULL,
  `final_score` decimal(10, 2) NOT NULL,
  `hand_score` decimal(10, 2) NOT NULL,
  `sys_score` decimal(10, 2) NOT NULL,
  `task_id` bigint(20) NOT NULL,
  `duration` int(11) NOT NULL,
  `start_time` datetime(6) NULL DEFAULT NULL,
  `status` smallint(6) NOT NULL,
  `task_type` smallint(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `StudentPaper_student_id_db2df38f`(`student_id`) USING BTREE,
  INDEX `StudentPaper_paper_id_f874a2d1`(`paper_id`) USING BTREE,
  INDEX `StudentPaper_task_id_349b124c`(`task_id`) USING BTREE,
  CONSTRAINT `StudentPaper_task_id_349b124c_fk_paper_task_id` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 268 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of studentpaper
-- ----------------------------
INSERT INTO `studentpaper` VALUES (188, 17, 38, 41.00, 6.00, 35.00, 71, 2, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (189, 17, 39, 42.50, 5.00, 37.50, 71, 1, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (190, 17, 40, 27.50, 5.00, 22.50, 71, 1, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (191, 17, 42, 41.50, 9.00, 32.50, 71, 2, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (192, 17, 45, 46.50, 9.00, 37.50, 71, 1, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (193, 17, 46, 3.50, 1.00, 2.50, 71, 1, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (194, 17, 47, 35.50, 3.00, 32.50, 71, 1, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (195, 17, 49, 36.00, 6.00, 30.00, 71, 1, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (196, 17, 50, 49.00, 9.00, 40.00, 71, 2, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (197, 17, 51, 38.50, 6.00, 32.50, 71, 1, '2022-12-03 20:53:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (198, 16, 36, 31.00, 6.00, 25.00, 72, 1, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (199, 16, 37, 38.50, 6.00, 32.50, 72, 1, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (200, 16, 41, 36.00, 1.00, 35.00, 72, 1, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (201, 16, 43, 41.00, 6.00, 35.00, 72, 1, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (202, 16, 44, 2.00, 2.00, 0.00, 72, 0, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (203, 16, 48, 41.00, 6.00, 35.00, 72, 1, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (204, 16, 52, 6.00, 6.00, 0.00, 72, 0, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (205, 16, 53, 1.00, 1.00, 0.00, 72, 0, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (206, 16, 54, 1.00, 1.00, 0.00, 72, 0, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (207, 16, 55, 1.00, 1.00, 0.00, 72, 0, '2022-12-03 20:54:00.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (218, 16, 36, 22.00, 2.00, 20.00, 74, 1, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (219, 16, 37, 23.00, 3.00, 20.00, 74, 2, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (220, 16, 41, 37.00, 7.00, 30.00, 74, 16, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (221, 16, 43, 28.00, 3.00, 25.00, 74, 1, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (222, 16, 44, 47.00, 7.00, 40.00, 74, 1, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (223, 16, 48, 32.50, 5.00, 27.50, 74, 1, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (224, 16, 52, 35.00, 0.00, 35.00, 74, 1, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (225, 16, 53, 42.50, 5.00, 37.50, 74, 1, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (226, 16, 54, 27.50, 0.00, 27.50, 74, 1, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (227, 16, 55, 36.50, 9.00, 27.50, 74, 2, '2022-12-27 20:07:45.000000', 3, 0);
INSERT INTO `studentpaper` VALUES (258, 16, 36, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);
INSERT INTO `studentpaper` VALUES (259, 16, 37, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);
INSERT INTO `studentpaper` VALUES (260, 16, 41, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);
INSERT INTO `studentpaper` VALUES (261, 16, 43, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);
INSERT INTO `studentpaper` VALUES (262, 16, 44, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);
INSERT INTO `studentpaper` VALUES (263, 16, 48, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);
INSERT INTO `studentpaper` VALUES (264, 16, 52, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);
INSERT INTO `studentpaper` VALUES (265, 16, 53, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);
INSERT INTO `studentpaper` VALUES (266, 16, 54, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);
INSERT INTO `studentpaper` VALUES (267, 16, 55, 0.00, 0.00, 0.00, 78, 0, '2022-12-28 13:36:55.000000', 0, 0);

-- ----------------------------
-- Table structure for subject
-- ----------------------------
DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_time` datetime(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of subject
-- ----------------------------
INSERT INTO `subject` VALUES (3, 'python基础', '2022-11-30 18:18:49.904776');
INSERT INTO `subject` VALUES (4, 'mysql数据库', '2022-11-30 18:19:08.368512');

-- ----------------------------
-- Table structure for task
-- ----------------------------
DROP TABLE IF EXISTS `task`;
CREATE TABLE `task`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `task_type` smallint(6) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `start_time` datetime(6) NULL DEFAULT NULL,
  `duration` int(11) NULL DEFAULT NULL,
  `paper_id` bigint(20) NULL DEFAULT NULL,
  `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `to_class_id` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `paper_task_paper_id_ea5fba67`(`paper_id`) USING BTREE,
  INDEX `paper_task_to_class_id_be10cf41`(`to_class_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of task
-- ----------------------------
INSERT INTO `task` VALUES (71, 0, '2022-12-03 20:49:49.157477', '2022-12-03 20:53:00.000000', 15, 17, 'python基础阶段性测试', 6);
INSERT INTO `task` VALUES (72, 0, '2022-12-03 20:51:02.576334', '2022-12-03 20:54:00.000000', 15, 16, 'mysql数据库一周入门测试', 5);
INSERT INTO `task` VALUES (74, 0, '2022-12-27 20:07:00.108303', '2022-12-27 20:07:45.000000', 15, 16, '项目上线测试', 5);
INSERT INTO `task` VALUES (78, 0, '2022-12-28 13:36:08.112415', '2022-12-28 13:36:55.000000', 1, 16, '测试定时', 5);

-- ----------------------------
-- Table structure for title
-- ----------------------------
DROP TABLE IF EXISTS `title`;
CREATE TABLE `title`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `theme` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `right_answer` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title_type` smallint(6) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `title_score` decimal(6, 2) NOT NULL,
  `subject_id` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `Title_subject_id_1babfd2c`(`subject_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of title
-- ----------------------------
INSERT INTO `title` VALUES (21, 'python基本数据类型有哪些？', 'int、float、string、list、dict、set、tuple', 3, '2022-11-30 18:24:18.835307', 5.00, 3);
INSERT INTO `title` VALUES (22, 'python常用内置模块有哪些?', 'os、sys、json、pickle、time、datetime、subprocess、multiprocessing、thread', 3, '2022-11-30 18:26:10.839127', 5.00, 3);
INSERT INTO `title` VALUES (23, 'python是编译型语言吗？', 'B', 2, '2022-11-30 18:27:08.675189', 5.00, 3);
INSERT INTO `title` VALUES (24, 'python支持多线程、多进程', 'A', 2, '2022-11-30 18:27:49.806911', 5.00, 3);
INSERT INTO `title` VALUES (25, '请选出下列与属于python的基本数据类型', 'D', 0, '2022-11-30 18:29:53.162968', 5.00, 3);
INSERT INTO `title` VALUES (26, '请选出下列属于python第三方模块的选项？', 'C', 0, '2022-11-30 18:31:17.175908', 5.00, 3);
INSERT INTO `title` VALUES (27, '下列与python并发编程相关的模块是?', 'AB', 1, '2022-11-30 18:34:27.614478', 5.00, 3);
INSERT INTO `title` VALUES (28, '请简述mysql数据库', 'mysql是一个关系型数据库 支持链表操作 跨表查询 设置索引 事务操作', 3, '2022-11-30 18:36:32.982418', 5.00, 4);
INSERT INTO `title` VALUES (29, '请简述mysql数据库事务的四大特性', '1.原子性\n2.一致性\n3.隔离性\n4.持久性', 3, '2022-11-30 18:37:32.837533', 5.00, 4);
INSERT INTO `title` VALUES (30, 'mysql和redis是一个类型的数据库', 'B', 2, '2022-11-30 18:38:14.304432', 5.00, 4);
INSERT INTO `title` VALUES (31, 'mysql支持事务操作', 'A', 2, '2022-11-30 18:38:35.391875', 5.00, 4);
INSERT INTO `title` VALUES (32, '请选出下列属于mysql的知识点', 'D', 0, '2022-11-30 18:39:51.637201', 5.00, 4);
INSERT INTO `title` VALUES (33, '请指出下列属于mysql常用字段的是', 'D', 0, '2022-11-30 18:41:27.508144', 5.00, 4);
INSERT INTO `title` VALUES (34, 'mysql有哪些数据存储结构？', 'ABC', 1, '2022-11-30 18:43:04.098187', 5.00, 4);
INSERT INTO `title` VALUES (35, 'mysql有哪些相关知识点', 'ABCDE', 1, '2022-11-30 18:44:56.065385', 5.00, 4);
INSERT INTO `title` VALUES (36, '下列那些事python的常用第三方模块', 'ABCD', 1, '2022-11-30 18:47:54.806281', 5.00, 3);
INSERT INTO `title` VALUES (37, '下列哪些属于mysql事务的关键词？', 'ABCD', 1, '2022-12-03 20:38:41.673410', 5.00, 4);
INSERT INTO `title` VALUES (38, 'mysql查询语句的关键词有哪些？', 'ABCD', 1, '2022-12-03 20:40:19.972965', 5.00, 4);
INSERT INTO `title` VALUES (39, '加密模块hashlib有哪些加密算法?', 'ABD', 1, '2022-12-03 20:41:41.593738', 5.00, 3);
INSERT INTO `title` VALUES (40, '下列那些模块可在python中做序列化和反序列化使用？', 'DE', 1, '2022-12-03 20:43:36.006333', 5.00, 3);

-- ----------------------------
-- Table structure for topic
-- ----------------------------
DROP TABLE IF EXISTS `topic`;
CREATE TABLE `topic`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `paper_id` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `Topic_paper_id_5e2a7d87`(`paper_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of topic
-- ----------------------------
INSERT INTO `topic` VALUES (62, '单选题', 13);
INSERT INTO `topic` VALUES (63, '多选题', 13);
INSERT INTO `topic` VALUES (64, '判断题', 13);
INSERT INTO `topic` VALUES (65, '简答题', 13);
INSERT INTO `topic` VALUES (70, '第一大题', 15);
INSERT INTO `topic` VALUES (71, '第二大题', 15);
INSERT INTO `topic` VALUES (72, '第三大题', 15);
INSERT INTO `topic` VALUES (73, '第四大题', 15);
INSERT INTO `topic` VALUES (74, '第一大题，请选出下列正确的唯一选项', 16);
INSERT INTO `topic` VALUES (75, '第二大题，多选题', 16);
INSERT INTO `topic` VALUES (76, '第三大题，判断题', 16);
INSERT INTO `topic` VALUES (77, '第四大题，简答题', 16);
INSERT INTO `topic` VALUES (78, '第一大题，还是单选题', 17);
INSERT INTO `topic` VALUES (79, '第二大题，python基础的判断题', 17);
INSERT INTO `topic` VALUES (80, '第三大题、python基础的多选题', 17);
INSERT INTO `topic` VALUES (81, '第四大题，python基础的简答题', 17);

-- ----------------------------
-- Table structure for topic_titles
-- ----------------------------
DROP TABLE IF EXISTS `topic_titles`;
CREATE TABLE `topic_titles`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `topic_id` bigint(20) NOT NULL,
  `title_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `Topic_title_topic_id_title_id_d8562e2d_uniq`(`topic_id`, `title_id`) USING BTREE,
  INDEX `Topic_title_title_id_df3d4eef_fk_Title_id`(`title_id`) USING BTREE,
  CONSTRAINT `Topic_title_title_id_df3d4eef_fk_Title_id` FOREIGN KEY (`title_id`) REFERENCES `title` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `Topic_title_topic_id_699f6b17_fk_Topic_id` FOREIGN KEY (`topic_id`) REFERENCES `topic` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 112 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of topic_titles
-- ----------------------------
INSERT INTO `topic_titles` VALUES (68, 62, 25);
INSERT INTO `topic_titles` VALUES (69, 62, 26);
INSERT INTO `topic_titles` VALUES (70, 63, 27);
INSERT INTO `topic_titles` VALUES (71, 63, 36);
INSERT INTO `topic_titles` VALUES (73, 64, 23);
INSERT INTO `topic_titles` VALUES (72, 64, 24);
INSERT INTO `topic_titles` VALUES (74, 65, 21);
INSERT INTO `topic_titles` VALUES (75, 65, 22);
INSERT INTO `topic_titles` VALUES (84, 70, 33);
INSERT INTO `topic_titles` VALUES (85, 70, 35);
INSERT INTO `topic_titles` VALUES (87, 71, 31);
INSERT INTO `topic_titles` VALUES (86, 71, 34);
INSERT INTO `topic_titles` VALUES (88, 72, 28);
INSERT INTO `topic_titles` VALUES (89, 72, 30);
INSERT INTO `topic_titles` VALUES (91, 73, 29);
INSERT INTO `topic_titles` VALUES (90, 73, 32);
INSERT INTO `topic_titles` VALUES (92, 74, 32);
INSERT INTO `topic_titles` VALUES (93, 74, 33);
INSERT INTO `topic_titles` VALUES (94, 75, 34);
INSERT INTO `topic_titles` VALUES (95, 75, 35);
INSERT INTO `topic_titles` VALUES (96, 75, 37);
INSERT INTO `topic_titles` VALUES (97, 75, 38);
INSERT INTO `topic_titles` VALUES (98, 76, 30);
INSERT INTO `topic_titles` VALUES (99, 76, 31);
INSERT INTO `topic_titles` VALUES (100, 77, 28);
INSERT INTO `topic_titles` VALUES (101, 77, 29);
INSERT INTO `topic_titles` VALUES (102, 78, 25);
INSERT INTO `topic_titles` VALUES (103, 78, 26);
INSERT INTO `topic_titles` VALUES (105, 79, 23);
INSERT INTO `topic_titles` VALUES (104, 79, 24);
INSERT INTO `topic_titles` VALUES (107, 80, 27);
INSERT INTO `topic_titles` VALUES (108, 80, 36);
INSERT INTO `topic_titles` VALUES (109, 80, 39);
INSERT INTO `topic_titles` VALUES (106, 80, 40);
INSERT INTO `topic_titles` VALUES (110, 81, 21);
INSERT INTO `topic_titles` VALUES (111, 81, 22);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `password` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `last_login` datetime(6) NULL DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `first_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `last_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `email` varchar(254) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  `mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `role` smallint(6) NOT NULL,
  `student_class_id` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE,
  INDEX `user_student_class_id_c3c19646`(`student_class_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'pbkdf2_sha256$260000$1sC5yHK1nVGDIUJW3p1cVK$SqD7o8epbAfs4xAgYLIhUwm8HinOqR8zkpxFA9ywm+4=', '2022-11-23 21:48:44.825752', 1, '海饼干', '', '', '286348300@qq.com', 1, 1, '2022-11-23 19:59:02.057910', '15696005305', 'icon/avatar.jpg', 2, NULL);
INSERT INTO `user` VALUES (34, 'pbkdf2_sha256$260000$NBdnywqBNJ1QvmDjdgy48c$Ad7feZqVZZdS7h1NmLwfh9XNbG4rMLRp8UoqTryUwCc=', NULL, 1, 'teacher', '', '', '18723755458@qq.com', 1, 1, '2022-11-26 15:17:31.421948', '18723755458', 'icon/traval.jpg', 1, NULL);
INSERT INTO `user` VALUES (36, 'pbkdf2_sha256$260000$QiuHa3yNsTFoP6NUJNTzYg$4sqc7dtzLHfsQRJagM6EQyFPs7svM++66vIcZMACCv4=', NULL, 0, 'bjy', '', '', '110@qq.com', 0, 1, '2022-11-30 18:19:56.227173', '110', 'icon/default.png', 0, 5);
INSERT INTO `user` VALUES (37, 'pbkdf2_sha256$260000$FwfO7ZXeAZZhUKHkjevQHD$pXZziH2Cz6C3EHo0AKsfl74rqx0cN0FnjI2+Qxr/+Yw=', NULL, 0, 'cqg', '', '', '', 0, 1, '2022-11-30 18:20:10.082191', NULL, 'icon/default.png', 0, 5);
INSERT INTO `user` VALUES (38, 'pbkdf2_sha256$260000$buWeIjNcvhEV3FCDhpx0nQ$B24X0ID+cj7nqKmak4EDsMAyWz3FuCU19uE7kKl95MM=', NULL, 0, 'ccy', '', '', '', 0, 1, '2022-11-30 18:20:29.098116', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (39, 'pbkdf2_sha256$260000$rtBH0LCsCnqNhYqpfhxFPg$HVaIISBiNEIaje9cTcbRYvNn3AxMmAqaAlr2P3Uzm9g=', NULL, 0, 'zh', '', '', '', 0, 1, '2022-11-30 18:20:46.436205', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (40, 'pbkdf2_sha256$260000$q76FalvCnMgTUw8TEWFwmT$KZViGb4WGUkSfSyiFBV3mbC6mD0qkasZogcO5Uv2GlA=', NULL, 0, 'zj', '', '', '', 0, 1, '2022-11-30 18:21:02.313126', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (41, 'pbkdf2_sha256$260000$SY8E95NUOk3AJBTEC5ep22$SToyYUh3skhncTK2xrAbmx0SiY9UDn9AKSINDHuR8V4=', NULL, 0, '王禄扬', '', '', '15696005307@qq.com', 0, 1, '2022-11-30 18:21:18.640870', '15696005309', 'icon/default.png', 0, 5);
INSERT INTO `user` VALUES (42, 'pbkdf2_sha256$260000$y823gOljAb4j6a9RJn5hyF$8U7Gpz1prZvfww17aheTjDaYGhScDIXIWG5QhdM9KSA=', NULL, 0, 'fzr', '', '', '', 0, 1, '2022-11-30 18:21:32.153991', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (43, 'pbkdf2_sha256$260000$W5bx8jDVa9m5FFFqK8KOZW$734Z1KkXPsIbuQoi/g5eGDLSWTi2MxYld3sGkffmEjI=', NULL, 0, 'sq', '', '', '', 0, 1, '2022-11-30 18:21:51.132130', NULL, 'icon/default.png', 0, 5);
INSERT INTO `user` VALUES (44, 'pbkdf2_sha256$260000$SY8E95NUOk3AJBTEC5ep22$SToyYUh3skhncTK2xrAbmx0SiY9UDn9AKSINDHuR8V4=', NULL, 0, 'lzq', '', '', '', 0, 1, '2022-12-02 11:12:29.445425', NULL, 'icon/default.png', 0, 5);
INSERT INTO `user` VALUES (45, 'pbkdf2_sha256$260000$S5Q2cQ1U0nrhY9Ry7uKVYV$DnE5zfLX7lYQL2iM9+UM3jDFgPqeIzLZLVWITsK0Zxk=', NULL, 0, '式织', '', '', '', 0, 1, '2022-12-02 20:04:26.930829', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (46, 'pbkdf2_sha256$260000$4UOkURDH9d4UW0ZpK2TqLa$MjJeZxpmScSN1EpcB7zqiAtQ/RWsLxllg5gg7/ejhdw=', NULL, 0, 'cy', '', '', '', 0, 1, '2022-12-03 20:30:23.793747', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (47, 'pbkdf2_sha256$260000$LxIHTkbBDD1uZEaYmnnnBh$Mx6kmUZOvMpB9371HrrCdXH4UPPG8pIRzG7972Gbf/Q=', NULL, 0, 'zy', '', '', '', 0, 1, '2022-12-03 20:30:37.422766', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (48, 'pbkdf2_sha256$260000$lkMbbWx4e47GRVBPQAvksg$JPMlcwepBsipG/MowK2wAk097eKAbR+DH1GqbH0UjJc=', NULL, 0, 'awj', '', '', '', 0, 1, '2022-12-03 20:30:49.876732', NULL, 'icon/default.png', 0, 5);
INSERT INTO `user` VALUES (49, 'pbkdf2_sha256$260000$GmTLo7MxeVy77sMkaPkp4N$reA9/COJ/1b7HUySNtl2iLDLws+RrRbenT37+x8NTMo=', NULL, 0, 'xj', '', '', '', 0, 1, '2022-12-03 20:31:20.674082', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (50, 'pbkdf2_sha256$260000$K3FqJrEEF4ydYvoQOeylIk$QosSoV95OkDWcsGTFxKKPPGb/IghGZ0aH3Way4y+IoI=', NULL, 0, 'qy', '', '', '', 0, 1, '2022-12-03 20:31:30.225499', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (51, 'pbkdf2_sha256$260000$Cl5AlLKjz9oRNPN1TufH6j$rqBQmeamG33F00m3kaZKEjA0iQcJdZksgO37dUnVghs=', NULL, 0, 'lr', '', '', '', 0, 1, '2022-12-03 20:31:56.197873', NULL, 'icon/default.png', 0, 6);
INSERT INTO `user` VALUES (52, 'pbkdf2_sha256$260000$SY8E95NUOk3AJBTEC5ep22$SToyYUh3skhncTK2xrAbmx0SiY9UDn9AKSINDHuR8V4=', NULL, 0, 'zhy', '', '', '', 0, 1, '2022-12-03 20:33:21.739176', NULL, 'icon/default.png', 0, 5);
INSERT INTO `user` VALUES (53, 'pbkdf2_sha256$260000$muiNWesnESW80xsCsY2kvN$u8r8wG7fgS0OmT0Z21XUdskMfG6ftsiAAjCSo2XQoSA=', NULL, 0, 'jzb', '', '', '', 0, 1, '2022-12-03 20:33:46.750337', NULL, 'icon/default.png', 0, 5);
INSERT INTO `user` VALUES (54, 'pbkdf2_sha256$260000$rAurM1bc6lP9RPkI0UGNfE$RMEht+EpWLSC2I5BC0mhSEmOF8E85PZMrro5RJmnmoQ=', NULL, 0, 'ld', '', '', '', 0, 1, '2022-12-03 20:34:24.792686', NULL, 'icon/default.png', 0, 5);
INSERT INTO `user` VALUES (55, 'pbkdf2_sha256$260000$1lUXMrS1nWLh2EZaTZqYVA$v1iAkfMu90Tmp4VR01ynhm31eMxo2gE/AqL/+kL2sd0=', NULL, 0, 'jz', '', '', '', 0, 1, '2022-12-03 20:34:44.358784', NULL, 'icon/default.png', 0, 5);

-- ----------------------------
-- Table structure for user_groups
-- ----------------------------
DROP TABLE IF EXISTS `user_groups`;
CREATE TABLE `user_groups`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userinfo_id` bigint(20) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `user_groups_userinfo_id_group_id_46f8e386_uniq`(`userinfo_id`, `group_id`) USING BTREE,
  INDEX `user_groups_group_id_b76f8aba_fk_auth_group_id`(`group_id`) USING BTREE,
  CONSTRAINT `user_groups_group_id_b76f8aba_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `user_groups_userinfo_id_5efa93b0_fk_user_id` FOREIGN KEY (`userinfo_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user_groups
-- ----------------------------

-- ----------------------------
-- Table structure for user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `user_user_permissions`;
CREATE TABLE `user_user_permissions`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userinfo_id` bigint(20) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `user_user_permissions_userinfo_id_permission_id_f561da46_uniq`(`userinfo_id`, `permission_id`) USING BTREE,
  INDEX `user_user_permission_permission_id_9deb68a3_fk_auth_perm`(`permission_id`) USING BTREE,
  CONSTRAINT `user_user_permission_permission_id_9deb68a3_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `user_user_permissions_userinfo_id_7e01fb93_fk_user_id` FOREIGN KEY (`userinfo_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user_user_permissions
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;