USE teachcloud_db;

ALTER TABLE `mark_task` RENAME TO  `mark_task_3.4.3` ;
CREATE TABLE `mark_task`  (
       `id` bigint NOT NULL COMMENT '主键',
       `exam_id` bigint NOT NULL COMMENT '考试ID',
       `course_id` bigint NULL DEFAULT NULL COMMENT '课程ID（basic_course表ID）',
       `course_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程代码',
       `course_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程名称',
       `paper_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '试卷编号',
       `question_id` bigint NULL DEFAULT NULL COMMENT '题目ID',
       `main_number` int NULL DEFAULT NULL COMMENT '大题号',
       `sub_number` int NULL DEFAULT NULL COMMENT '小题号',
       `group_number` int NULL DEFAULT NULL COMMENT '大题号',
       `student_id` bigint NOT NULL COMMENT '考生ID',
       `basic_student_id` bigint NULL DEFAULT NULL COMMENT '考生管理ID',
       `student_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学号',
       `secret_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '考生密号',
       `task_number` int NOT NULL COMMENT '多评任务序号',
       `status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态',
       `user_id` bigint NULL DEFAULT NULL COMMENT '评卷员ID',
       `marker_time` bigint NULL DEFAULT NULL COMMENT '评卷时间',
       `marker_score` double NULL DEFAULT NULL COMMENT '评卷总分',
       `marker_score_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '评卷给分明细',
       `marker_track_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '评卷分数轨迹',
       `marker_tag_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '评卷特殊标记',
       `marker_spent` int NULL DEFAULT NULL COMMENT '评卷时长',
       `header_id` bigint NULL DEFAULT NULL COMMENT '科组长ID',
       `header_time` bigint NULL DEFAULT NULL COMMENT '科组长评卷时间',
       `header_score` double NULL DEFAULT NULL COMMENT '科组长总分',
       `header_score_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '科组长给分明细',
       `header_track_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '复核轨迹',
       `header_tag_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '复核特殊标记',
       `reject_reason` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '打回原因',
       PRIMARY KEY (`id`) USING BTREE,
       UNIQUE INDEX `index2`(`student_id` ASC, `group_number` ASC, `task_number` ASC) USING BTREE,
       INDEX `index3`(`user_id` ASC, `status` ASC, `marker_time` ASC) USING BTREE,
       INDEX `index1`(`exam_id` ASC, `paper_number` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '评卷任务表' ROW_FORMAT = DYNAMIC;

ALTER TABLE `mark_question` RENAME TO  `mark_question_3.4.3` ;
CREATE TABLE `mark_question`  (
           `id` bigint NOT NULL COMMENT '主键',
           `exam_id` bigint NOT NULL COMMENT '考试ID',
           `course_id` bigint NULL DEFAULT NULL COMMENT '课程ID',
           `paper_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '试卷类型',
           `paper_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '卷型',
           `objective` tinyint NOT NULL COMMENT '是否客观题',
           `group_number` int NULL DEFAULT NULL COMMENT '分组序号',
           `main_number` int NOT NULL COMMENT '大题号',
           `sub_number` int NOT NULL COMMENT '小题号',
           `main_title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '大题名称',
           `answer` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '正确答案',
           `total_score` double NULL DEFAULT NULL COMMENT '满分',
           `option_count` int NULL DEFAULT NULL COMMENT '客观题答案数量',
           `interval_score` double NULL DEFAULT NULL COMMENT '评卷间隔分',
           `objective_policy` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客观题判分策略',
           `question_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '题型',
           `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
           `paper_index` int NULL DEFAULT NULL,
           `page_index` int NULL DEFAULT NULL,
           `objective_policy_score` double NULL DEFAULT NULL COMMENT '客观题判分策略计分',
           `create_id` bigint NULL DEFAULT NULL,
           `create_time` bigint NULL DEFAULT NULL,
           `update_id` bigint NULL DEFAULT NULL,
           `update_time` bigint NULL DEFAULT NULL,
           `pic_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '评卷区坐标',
           `double_rate` double NULL DEFAULT NULL COMMENT '双评比例',
           `arbitrate_threshold` double NULL DEFAULT NULL COMMENT '仲裁阈值',
           `score_policy` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '合分策略',
           `task_count` int NULL DEFAULT 0 COMMENT '任务总量',
           `marked_count` int NULL DEFAULT 0 COMMENT '已评数量',
           `left_count` int NULL DEFAULT NULL COMMENT '剩余数量',
           PRIMARY KEY (`id`) USING BTREE,
           INDEX `index_1`(`exam_id` ASC, `paper_number` ASC, `main_number` ASC, `sub_number` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小题信息表' ROW_FORMAT = DYNAMIC;

CREATE TABLE `mark_user_question`  (
           `id` bigint NOT NULL COMMENT '主键',
           `exam_id` bigint NOT NULL COMMENT '考试ID',
           `paper_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '试卷编号',
           `question_id` bigint NULL DEFAULT NULL COMMENT '题目ID',
           `group_number` int NULL DEFAULT NULL COMMENT '分组编号',
           `user_id` bigint NOT NULL COMMENT '用户ID',
           `mode` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '强制评卷模式',
           `top_count` int NULL DEFAULT NULL COMMENT '评卷数上限',
           `finish_count` int NULL DEFAULT NULL COMMENT '完成数量',
           `header_finish_count` int NULL DEFAULT NULL COMMENT '管理员直接打分数量',
           `valid_count` int NULL DEFAULT NULL COMMENT '有效数量',
           `avg_score` double NULL DEFAULT NULL COMMENT '平均分',
           `avg_speed` double NULL DEFAULT NULL COMMENT '平均时长',
           `stdev_score` double NULL DEFAULT NULL COMMENT '标准差',
           `max_score` double NULL DEFAULT NULL COMMENT '最高分',
           `min_score` double NULL DEFAULT NULL COMMENT '最低分',
           `reject_count` int NULL DEFAULT NULL COMMENT '打回次数',
           `enable` tinyint(1) NULL DEFAULT 1 COMMENT '是否启用',
           PRIMARY KEY (`id`) USING BTREE,
           INDEX `index2`(`exam_id` ASC, `paper_number` ASC, `group_number` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COMMENT = '评卷员表' ROW_FORMAT = DYNAMIC;

ALTER TABLE `mark_subjective_score` RENAME TO  `mark_subjective_score_3.4.3` ;
CREATE TABLE `mark_subjective_score`  (
           `student_id` bigint NOT NULL COMMENT '考生ID',
           `main_number` int NOT NULL COMMENT '大题号',
           `sub_number` int NOT NULL COMMENT '小题号',
           `exam_id` bigint NOT NULL COMMENT '考试ID',
           `paper_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程代码',
           `question_id` bigint NULL DEFAULT NULL COMMENT '题目ID',
           `group_number` int NULL DEFAULT NULL COMMENT '分组序号',
           `group_score` double NULL DEFAULT NULL COMMENT '分组得分',
           `main_score` double NOT NULL COMMENT '大题得分',
           `score` double NOT NULL COMMENT '小题得分',
           `uncalculate` tinyint(1) NULL DEFAULT NULL COMMENT '是否合分',
           `rejected` tinyint(1) NULL DEFAULT 0 COMMENT '是否打回',
           PRIMARY KEY (`student_id`, `main_number`, `sub_number`) USING BTREE,
           INDEX `index1`(`exam_id` ASC, `paper_number` ASC, `main_number` ASC, `main_score` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '主观题得分明细表' ROW_FORMAT = DYNAMIC;

ALTER TABLE `mark_problem_history` RENAME TO  `mark_problem_history_3.4.3` ;
CREATE TABLE `mark_problem_history`  (
           `id` bigint NOT NULL COMMENT '自增主键',
           `exam_id` bigint NOT NULL COMMENT '考试ID',
           `paper_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '试卷编号',
           `question_id` bigint NULL DEFAULT NULL COMMENT '题目ID',
           `group_number` int NULL DEFAULT NULL COMMENT '大题号',
           `student_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学号',
           `secret_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '考生密号',
           `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '问题类型',
           `student_id` bigint NOT NULL COMMENT '考生ID',
           `task_id` bigint NOT NULL COMMENT '评卷任务ID',
           `status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
           `update_user_id` bigint NULL DEFAULT NULL COMMENT '处理人ID',
           `user_id` bigint NULL DEFAULT NULL COMMENT '评卷员ID',
           `score_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '给分明细',
           `create_time` bigint NOT NULL COMMENT '创建时间',
           `update_time` bigint NULL DEFAULT NULL COMMENT '处理时间',
           `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题原因',
           PRIMARY KEY (`id`) USING BTREE,
           INDEX `index2`(`update_user_id` ASC, `status` ASC, `update_time` ASC) USING BTREE,
           INDEX `index3`(`student_id` ASC, `status` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '问题卷历史表' ROW_FORMAT = DYNAMIC;

ALTER TABLE `mark_arbitrate_history` RENAME TO  `mark_arbitrate_history_3.4.3` ;
CREATE TABLE `mark_arbitrate_history`  (
           `id` bigint NOT NULL COMMENT '自增主键',
           `exam_id` bigint NOT NULL COMMENT '考试ID',
           `paper_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '试卷编号',
           `question_id` bigint NULL DEFAULT NULL COMMENT '题目ID',
           `group_number` int NULL DEFAULT NULL COMMENT '大题号',
           `student_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '准考证号',
           `secret_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '考生密号',
           `student_id` bigint NOT NULL COMMENT '考生ID',
           `status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态',
           `update_user_id` bigint NULL DEFAULT NULL COMMENT '处理人ID',
           `total_score` double NULL DEFAULT NULL COMMENT '总分',
           `score_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '给分明细',
           `create_time` bigint NOT NULL COMMENT '创建时间',
           `update_time` bigint NULL DEFAULT NULL COMMENT '处理时间',
           PRIMARY KEY (`id`) USING BTREE,
           INDEX `index1`(`exam_id` ASC, `paper_number` ASC, `group_number` ASC, `status` ASC) USING BTREE,
           INDEX `index3`(`student_id` ASC, `status` ASC) USING BTREE,
           INDEX `index2`(`update_user_id` ASC, `status` ASC, `update_time` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '仲裁记录表' ROW_FORMAT = DYNAMIC;

ALTER TABLE `mark_reject_history` RENAME TO  `mark_reject_history_3.4.3` ;
CREATE TABLE `mark_reject_history`  (
           `id` bigint NOT NULL,
           `exam_id` bigint NULL DEFAULT NULL COMMENT '考试ID',
           `paper_number` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '试卷编号',
           `question_id` bigint NULL DEFAULT NULL COMMENT '题目ID',
           `group_number` int NULL DEFAULT NULL COMMENT '分组号',
           `task_id` bigint NULL DEFAULT NULL COMMENT '任务ID',
           `student_id` bigint NULL DEFAULT NULL COMMENT '考生ID',
           `basic_student_id` bigint NULL DEFAULT NULL COMMENT 'basic_exam_student表id',
           `student_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学号',
           `secret_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务密号',
           `user_id` bigint NULL DEFAULT NULL COMMENT '评卷用户ID',
           `reject_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '打回原因',
           `reject_score_list` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '打回后分数列表',
           `marker_score_list` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '打回前分数列表',
           `marker_score` double NULL DEFAULT NULL COMMENT '总分',
           `marker_time` bigint NULL DEFAULT NULL COMMENT '评卷时间',
           `reject_user_id` bigint NULL DEFAULT NULL COMMENT '打回用户ID',
           `reject_time` bigint NOT NULL COMMENT '打回时间',
           PRIMARY KEY (`id`) USING BTREE,
           INDEX `index2`(`task_id` ASC) USING BTREE,
           INDEX `index1`(`exam_id` ASC, `paper_number` ASC, `group_number` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

ALTER TABLE `basic_exam_student`
    ADD COLUMN `exam_date` VARCHAR(20) NULL COMMENT '考试日期' AFTER `exam_end_time`,
ADD COLUMN `exam_time` VARCHAR(20) NULL COMMENT '考试时间' AFTER `exam_date`;

update basic_exam_student set exam_date = DATE_FORMAT(FROM_UNIXTIME(exam_start_time/1000), '%Y-%m-%d') where exam_start_time is not null and exam_date is null;
update basic_exam_student set exam_time = concat(DATE_FORMAT(FROM_UNIXTIME(exam_start_time/1000), '%H:%i'),'-',DATE_FORMAT(FROM_UNIXTIME(exam_end_time/1000), '%H:%i')) where exam_start_time is not null and exam_time is null;

ALTER TABLE `exam_detail`
    ADD COLUMN `exam_date` VARCHAR(20) NULL COMMENT '考试日期' AFTER `exam_end_time`,
ADD COLUMN `exam_time` VARCHAR(20) NULL COMMENT '考试时间' AFTER `exam_date`;

update exam_detail set exam_date = DATE_FORMAT(FROM_UNIXTIME(exam_start_time/1000), '%Y-%m-%d') where exam_start_time is not null and exam_date is null;
update exam_detail set exam_time = concat(DATE_FORMAT(FROM_UNIXTIME(exam_start_time/1000), '%H:%i'),'-',DATE_FORMAT(FROM_UNIXTIME(exam_end_time/1000), '%H:%i')) where exam_start_time is not null and exam_time is null;

ALTER TABLE `sys_user_role` ADD INDEX `idx_1` (`role_id` ASC, `user_id` ASC);
ALTER TABLE `t_f_flow_log` DROP INDEX `flow_log_idx` , ADD INDEX `flow_log_idx` USING BTREE (`flow_id`);
ALTER TABLE `exam_task` ADD INDEX `idx_1` (`flow_id` ASC);

ALTER TABLE `mark_paper`
    ADD COLUMN `merge_marker` TINYINT(1) NULL DEFAULT '1' COMMENT '填空题是否合并设置评卷员' AFTER `double_mark`,
CHANGE COLUMN `open_double_marking` `double_mark` TINYINT(1) NULL DEFAULT '0' COMMENT '是否开启双评：true-开启，false-关闭' ;

CREATE TABLE `mark_user_paper` (
               `id` BIGINT(20) NOT NULL,
               `exam_id` BIGINT(20) NULL,
               `paper_number` VARCHAR(100) NULL,
               `user_id` BIGINT(20) NULL COMMENT '用户ID',
               `question_model` VARCHAR(10) NULL COMMENT '评卷模式（SINGLE：单题阅，MULTI：多题阅）',
               PRIMARY KEY (`id`))
    COMMENT = '试卷评卷员设置';

CREATE TABLE `mark_header_history` (
               `id` BIGINT(20) NOT NULL,
               `exam_id` BIGINT(20) NULL COMMENT '考试ID',
               `paper_number` VARCHAR(100) NULL COMMENT '试卷编号',
               `student_id` BIGINT(20) NULL COMMENT '考生ID',
               `question_id` BIGINT(20) NULL COMMENT '题目ID',
               `main_number` INT NULL COMMENT '大题号',
               `sub_number` INT NULL COMMENT '小题号',
               `user_id` BIGINT(20) NULL COMMENT '用户ID',
               `score` DOUBLE NULL COMMENT '分数',
               `track_list` MEDIUMTEXT NULL COMMENT '轨迹',
               `original_score` DOUBLE NULL COMMENT '原分数',
               `original_track_list` MEDIUMTEXT NULL COMMENT '原轨迹',
               `create_time` BIGINT(20) NULL COMMENT '创建时间',
               PRIMARY KEY (`id`))
    COMMENT = '复核历史表';

ALTER TABLE `mark_user_paper` ADD COLUMN `mode` VARCHAR(45) NULL COMMENT '阅卷模式' AFTER `question_model`;
ALTER TABLE `mark_paper` CHANGE COLUMN `open_mark_class` `class_mark` TINYINT NULL DEFAULT '0' COMMENT '是否开启分班阅' AFTER `paper_type`;

drop table if exists t_s_job_log;
UPDATE `sys_privilege` SET `url` = '/api/admin/mark/question/subjective/list' WHERE (`id` = '904');
UPDATE `sys_privilege` SET `related` = '672,902,903,904,905,906,907,908,909,910,911,912,913,962,963,965,1132,1133' WHERE (`id` = '901');
UPDATE `sys_privilege` SET `name` = '单双评设置', `url` = '/api/admin/mark/question/subjective/double/mark/update' WHERE (`id` = '905');
UPDATE `sys_privilege` SET `url` = '/api/admin/mark/question/subjective/picture/config/update' WHERE (`id` = '962');
UPDATE `sys_privilege` SET `url` = '/api/admin/mark/class/update' WHERE (`id` = '963');
UPDATE `sys_privilege` SET `url` = '/api/admin/mark/question/subjective/summary' WHERE (`id` = '928');
UPDATE `sys_privilege` SET `url` = '/api/admin/mark/question/subjective/class/summary' WHERE (`id` = '964');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1012', '评阅题目列表', '/api/admin/mark/question/subjective/number/list', 'URL', '917', '28', 'AUTH', '1', '1', '1');
UPDATE `sys_privilege` SET `related` = '928,929,932,933,934,935,936,937,938,939,940,941,942,943,964,965,966,967,968,1008,1012,1183,1186' WHERE (`id` = '944');

INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1189, '版本管理列表', '/api/admin/version/list', 'URL', 1, 18, 'SYS', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1190, '版本管理新增/修改', '/api/admin/version/save', 'URL', 1, 18, 'SYS', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1191, '版本管理编辑', '/api/admin/version/edit', 'URL', 1, 18, 'SYS', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1192, '版本管理删除', '/api/admin/version/delete', 'URL', 1, 18, 'SYS', NULL, 1, 1, 1);

DROP TABLE IF EXISTS `t_b_version`;
CREATE TABLE `t_b_version` (
               `id` bigint NOT NULL COMMENT '主键',
               `soft_version` varchar(200) NOT NULL COMMENT '服务端版本',
               `client_version` varchar(100) NOT NULL COMMENT '客户端版本',
               `create_id` bigint DEFAULT NULL COMMENT '创建人id',
               `create_time` bigint DEFAULT NULL COMMENT '创建时间',
               `update_id` bigint DEFAULT NULL COMMENT '更新人id',
               `update_time` bigint DEFAULT NULL COMMENT '更新时间',
               PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='版本管理表';

UPDATE `sys_privilege` SET `name` = '评卷参数设置步骤状态', `url` = '/api/admin/mark/question/subjective/step/status' WHERE (`id` = '906');
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1193, '课程任课老师导入', '/api/admin/basic/course/import', 'URL', 13, 1, 'AUTH', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1194, '课程任课老师导入', 'AssginCourseUserImport', 'BUTTON', 576, 7, 'AUTH', '1193', 1, 0, 1);
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1013', '新增考生', '/api/scan/student/save', 'URL', '970', '44', 'AUTH', '1', '1', '1');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1014', '复制卡格式', '/api/scan/answer/card/copy', 'URL', '970', '45', 'AUTH', '1', '1', '1');
UPDATE `sys_privilege` SET `related` = '971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1007,1009,1010,1013,1014,1148,3072,3073,3074,3075' WHERE (`id` = '970');
UPDATE sys_config SET school_id=NULL, org_id=NULL, config_key='attachment.type', config_name='附件类型', config_value='[.xlsx,.xls,.doc,.docx,.pdf,.jpg,.jpeg,.png,.html,.zip,.mp3,.wav,.dll,.exe,.ftl,.bpmn,.xml,.ttf,.otf,.pfm,.woff,.svg,.eot]', remark=NULL, enable=1, sort=1, create_id=1, create_time=NULL, update_id=NULL, update_time=NULL WHERE id=10;

ALTER TABLE `basic_print_config` ADD COLUMN `default_serial_number` INT(2) NULL DEFAULT 0 COMMENT '默认抽取卷型（0-随机，1-卷1，2-卷2）' AFTER `draw_rule`;

INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1195, '字体查询', '/api/admin/set/font/select', 'URL', 508, 21, 'AUTH', NULL, 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1196, '字体保存', '/api/admin/set/font/save', 'URL', 508, 21, 'AUTH', NULL, 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1197, '字体修改', '/api/admin/set/font/update', 'URL', 508, 21, 'AUTH', NULL, 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1198, '字体删除', '/api/admin/set/font/delete', 'URL', 508, 21, 'AUTH', NULL, 1, 0, 1);

ALTER TABLE mark_student ADD version INTEGER DEFAULT 1 COMMENT '版本号' NOT NULL after miss_scan;
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1015', '获取识别对照任务', '/api/scan/task/omr/getTask', 'URL', '970', '44', 'AUTH', '1', '1', '1');
UPDATE `sys_privilege` SET `related` = '971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1007,1009,1010,1013,1014,1015,1148,3072,3073,3074,3075' WHERE (`id` = '970');
INSERT INTO sys_config(id, school_id, org_id, config_key, config_name, config_value, remark, enable, sort, create_id, create_time, update_id, update_time) VALUES(51, NULL, NULL, 'mark.score.calculate.job.db.limit', '统分查询考生条数', 'limit 0,500', NULL, 1, 20, 1, NULL, NULL, NULL);

CREATE TABLE IF NOT EXISTS `exam_card_model_four` (
        `id` bigint NOT NULL COMMENT '主键',
        `school_id` bigint NOT NULL COMMENT '学校id',
        `org_id` bigint DEFAULT NULL COMMENT '机构id',
        `exam_id` bigint DEFAULT NULL COMMENT '考试id',
        `course_id` bigint DEFAULT NULL COMMENT '课程ID（basic_course表ID）',
        `title` varchar(200) NOT NULL COMMENT '标题',
        `status` varchar(45) DEFAULT NULL COMMENT 'STAGE-暂存，SUBMIT-提交',
        `content` mediumtext COMMENT '题卡工具制作题卡内容',
        `stage_content` mediumtext COMMENT '暂存内容（提交后置空）',
        `html_content` mediumtext COMMENT 'html格式内容',
        `enable` tinyint(1) DEFAULT '1' COMMENT '1正常，0禁用',
        `card_rule_id` bigint DEFAULT NULL COMMENT '题卡规则Id',
        `jpg_attachment` text COMMENT '题卡转换成的jpg文件信息',
        `create_id` bigint DEFAULT NULL COMMENT '创建人',
        `create_time` bigint DEFAULT NULL COMMENT '创建时间',
        `update_id` bigint DEFAULT NULL COMMENT '更新人',
        `update_time` bigint DEFAULT NULL COMMENT '更新时间',
        `page_size` varchar(10) DEFAULT NULL COMMENT '题卡纸张大小（A3，8K）',
        `remark` mediumtext COMMENT '备注',
        PRIMARY KEY (`id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='模式4题卡';

INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1199, '答题卡管理', 'CardModel4Manage', 'MENU', 3, 4, 'AUTH', NULL, 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1200, '查询', 'Select', 'BUTTON', 1199, 1, 'AUTH', '1209', 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1201, '新增题卡', 'Add', 'BUTTON', 1199, 2, 'AUTH', '1210', 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1202, '批量下载', 'BatchDownload', 'BUTTON', 1199, 3, 'AUTH', '1214', 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1203, '查询条件', 'Condition', 'CONDITION', 1199, 4, 'AUTH', NULL, 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1204, '查看', 'Preview', 'LINK', 1199, 1, 'AUTH', NULL, 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1205, '生成图片/预览图片', 'ConvertImage', 'LINK', 1199, 2, 'AUTH', '1212', 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1206, '编辑题卡/编辑信息', 'Edit', 'LINK', 1199, 3, 'AUTH', '1210', 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1207, '下载', 'Download', 'LINK', 1199, 4, 'AUTH', '1213', 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1208, '删除', 'Delete', 'LINK', 1199, 5, 'AUTH', '1211', 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1209, '查询', '/api/admin/exam/model_4/card/page', 'URL', 1199, 1, 'AUTH', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1210, '新增/修改', '/api/admin/exam/model_4/card/save_generic', 'URL', 1199, 2, 'AUTH', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1211, '删除', '/api/admin/exam/model_4/card/delete_generic', 'URL', 1199, 3, 'AUTH', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1212, '生成图片', '/api/admin/exam/model_4/card/convert_image', 'URL', 1199, 4, 'AUTH', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1213, '下载', '/api/admin/exam/model_4/card/download_card', 'URL', 1199, 5, 'AUTH', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1214, '批量下载', '/api/admin/exam/model_4/card/batch_download_card', 'URL', 1199, 6, 'AUTH', NULL, 1, 1, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1215, '列表', 'List', 'LIST', 1199, 5, 'AUTH', '1209', 1, 0, 1);
INSERT INTO sys_privilege(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display) VALUES(1216, '查看', '/api/admin/exam/model_4/card/get_one', 'URL', 1199, 7, 'AUTH', NULL, 1, 1, 1);
UPDATE sys_privilege SET name='查看', url='Preview', `type`='LINK', parent_id=1199, `sequence`=1, property='AUTH', related='1216', enable=1, default_auth=0, front_display=1 WHERE id=1204;
UPDATE sys_privilege SET name='答题卡管理', url='ModeCardManage', `type`='MENU', parent_id=3, `sequence`=4, property='AUTH', related=NULL, enable=1, default_auth=0, front_display=1 WHERE id=1199;
INSERT INTO sys_config(id, school_id, org_id, config_key, config_name, config_value, remark, enable, sort, create_id, create_time, update_id, update_time) VALUES(52, NULL, NULL, 'sms.mark.task.create.code', '阅卷待办短信通知', 'SMS_480165252', NULL, 1, 21, 1, 1733878447209, NULL, 1733878447249);

ALTER TABLE `basic_print_config` ADD COLUMN `two_paper_enable` TINYINT(1) NULL DEFAULT 0 COMMENT '是否提交两套卷子（0-否，1-是）' AFTER `output_file_type`;

UPDATE sys_privilege SET name='课程任课老师导入', url='/api/admin/teach/course/import', `type`='URL', parent_id=13, `sequence`=1, property='AUTH', related=NULL, enable=1, default_auth=1, front_display=1 WHERE id=1193;

ALTER TABLE `mark_student` ADD INDEX `index7` (`subjective_status` ASC);
ALTER TABLE `mark_user_paper` ADD INDEX `index1` (`exam_id` ASC, `paper_number` ASC, `user_id` ASC);
ALTER TABLE `mark_user_paper` ADD COLUMN `marked_question_id` BIGINT(20) NULL COMMENT '正在阅卷的题目ID' AFTER `mode`;
ALTER TABLE `mark_student` ADD COLUMN `teach_class_name` VARCHAR(100) NULL COMMENT '教学班' AFTER `exam_room`;

INSERT INTO sys_privilege(id, name, url, parent_id, `type`, `sequence`, property, related, enable, default_auth, front_display) VALUES(1300, '获取评卷区', '/api/admin/mark/inspected/get_mark_area', 946, 'URL', 9, 'AUTH', NULL, 1, 1, 1);
UPDATE sys_privilege SET name='成绩检查', url='ScoreCheck', `type`='MENU', parent_id=486, `sequence`=4, property='AUTH', related='1300', enable=1, default_auth=0, front_display=1 WHERE id=946;

ALTER TABLE t_b_version ADD CONSTRAINT t_b_version_unique UNIQUE KEY (client_version);
ALTER TABLE exam_card_model_four ADD CONSTRAINT exam_card_model_four_unique UNIQUE KEY (exam_id,course_id);
ALTER TABLE `mark_task` CHANGE COLUMN `group_number` `group_number` INT NULL COMMENT '大题号' ;

update basic_print_config set default_serial_number = 0 where default_serial_number is null;
update basic_print_config set two_paper_enable = 0 where two_paper_enable is null;
update mark_paper set merge_marker = 1 where merge_marker is null;
update mark_paper set double_mark = 0 where double_mark is null;
update mark_student set version = 1 where version is null;
update mark_student ms left join basic_exam_student bes on ms.basic_student_id = bes.id set ms.teach_class_name = bes.teach_class_name where ms.teach_class_name is null;

INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1217', '课程唯一性校验', '/api/admin/exam/model_4/card/valid_course', 'URL', '1199', '8', 'AUTH', '1', '1', '1');
UPDATE `sys_privilege` SET `related` = '1210,1217' WHERE (`id` = '1201');
UPDATE `sys_privilege` SET `related` = '1210,1217' WHERE (`id` = '1206');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('1218', '复核记录导出', 'ExportScoreHistory', 'BUTTON', '946', '14', 'AUTH', '1219', '1', '0', '1');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1219', '复核记录导出', '/api/admin/mark/archive/score/history/export', 'URL', '946', '14', 'AUTH', '1', '1', '1');
ALTER TABLE `basic_template` ADD COLUMN `convert_a3` TINYINT(1) NULL DEFAULT 0 COMMENT '是否转换成A3' AFTER `font_size`;

INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1220', '全卷轨迹信息', '/api/admin/mark/archive/student/question/track', 'URL', '487', '4', 'AUTH', '1', '1', '1');
UPDATE `sys_privilege` SET `related` = '490,543,955,959,1139,1220' WHERE (`id` = '488');
UPDATE `sys_privilege` SET `related` = '542,959,1139,1220' WHERE (`id` = '498');
UPDATE `sys_privilege` SET `related` = '542,959,1139,1220' WHERE (`id` = '499');
UPDATE `sys_privilege` SET `related` = '542,959,1139,1220' WHERE (`id` = '500');

INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1221', '班级阅卷进度-详情', '/api/admin/mark/question/subjective/class/detail', 'URL', '917', '21', 'AUTH', '1', '1', '1');
UPDATE `sys_privilege` SET `related` = '928,929,932,933,934,935,936,937,938,939,940,941,942,943,964,965,966,967,968,1008,1012,1183,1186,1221' WHERE (`id` = '944');
UPDATE `sys_config` SET `config_value` = '[{"name":"A3","size":"297*420"}, {"name":"A4","size":"210*297"}, {"name":"A5","size":"148*210"}, {"name":"B3","size":"353*500"}, {"name":"B4","size":"250*353"}, {"name":"B5","size":"176*250"}, {"name":"8K","size":"270*390"}]' WHERE (`id` = '8');
UPDATE `sys_config` SET `config_value` = '[{"name":"A3","size":"297*420"}, {"name":"8K","size":"270*390"}]' WHERE (`id` = '43');

ALTER TABLE `exam_detail` ADD COLUMN `merge_pdf_path` VARCHAR(2000) NULL COMMENT '考场合并所有文件后的文件路径' AFTER `update_time`;
ALTER TABLE `t_b_sync_task` CHANGE COLUMN `error_message` `error_message` VARCHAR(2000) CHARACTER SET 'utf8mb4' NULL DEFAULT NULL COMMENT '人工错误原因' ;