USE teachcloud_db;
ALTER TABLE `basic_card_rule` CHANGE COLUMN `name` `name` VARCHAR(100) NOT NULL COMMENT '题卡规则名称' ;
ALTER TABLE `basic_exam` DROP COLUMN `in_used`;
ALTER TABLE `basic_semester` DROP COLUMN `in_used`;
UPDATE `sys_privilege` SET `related` = '620,621,622,623,49' WHERE (`id` = '614');
DELETE FROM `sys_privilege` WHERE (`id` = '646');
DELETE FROM `sys_privilege` WHERE (`id` = '645');
ALTER TABLE `basic_major`
CHANGE COLUMN `belong_org_id` `belong_org_id` BIGINT NOT NULL COMMENT '所属机构id' AFTER `org_id`,
DROP INDEX `major_schoolId_name_idx` ,
ADD UNIQUE INDEX `major_schoolId_name_idx` USING BTREE (`school_id`, `name`, `belong_org_id`);
ALTER TABLE `basic_clazz`
DROP INDEX `clazz_schoolId_name_idx` ,
ADD UNIQUE INDEX `clazz_schoolId_name_idx` USING BTREE (`school_id`, `major_id`, `clazz_name`);
DELETE FROM `sys_privilege` WHERE (`id` = '425');
DELETE FROM `sys_privilege` WHERE (`id` = '426');
DELETE FROM `sys_privilege` WHERE (`id` = '428');
DELETE FROM `sys_privilege` WHERE (`id` = '429');
DELETE FROM `sys_privilege` WHERE (`id` = '430');
DELETE FROM `sys_privilege` WHERE (`id` = '449');
DELETE FROM `sys_privilege` WHERE (`id` = '306');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '224');
UPDATE `sys_privilege` SET `name` = '启用/禁用' WHERE (`id` = '220');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '218');
UPDATE `sys_privilege` SET `name` = '导入' WHERE (`id` = '243');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '230');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '238');
UPDATE `sys_privilege` SET `name` = '生成图片/预览图片' WHERE (`id` = '828');
UPDATE `sys_privilege` SET `name` = '编辑题卡/编辑信息' WHERE (`id` = '630');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '250');
UPDATE `sys_privilege` SET `name` = '启用/禁用' WHERE (`id` = '253');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '511');
UPDATE `sys_privilege` SET `name` = '编辑' WHERE (`id` = '628');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '516');
DELETE FROM `sys_privilege` WHERE (`id` = '460');
DELETE FROM `sys_privilege` WHERE (`id` = '454');
UPDATE `sys_privilege` SET `name` = '导入' WHERE (`id` = '382');
UPDATE `sys_privilege` SET `name` = '批量删除' WHERE (`id` = '570');
UPDATE `sys_privilege` SET `name` = '批量删除' WHERE (`id` = '574');
UPDATE `sys_privilege` SET `name` = '删除' WHERE (`id` = '269');
UPDATE `sys_privilege` SET `name` = '导入' WHERE (`id` = '388');
DELETE FROM `sys_privilege` WHERE (`id` = '265');
UPDATE `sys_privilege` SET `name` = '查询条件' WHERE (`id` = '838');
UPDATE `sys_privilege` SET `name` = '查询' WHERE (`id` = '836');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '840');
UPDATE `sys_privilege` SET `name` = '删除' WHERE (`id` = '837');
UPDATE `sys_privilege` SET `name` = '管理' WHERE (`id` = '841');
UPDATE `sys_privilege` SET `name` = '批量新增' WHERE (`id` = '273');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '274');
UPDATE `sys_privilege` SET `name` = '启用/禁用' WHERE (`id` = '277');
UPDATE `sys_privilege` SET `name` = '指派/更改' WHERE (`id` = '448');
DELETE FROM `sys_privilege` WHERE (`id` = '276');
UPDATE `sys_privilege` SET `name` = '立即申请' WHERE (`id` = '283');
UPDATE `sys_privilege` SET `name` = '新建命题申请' WHERE (`id` = '307');
UPDATE `sys_privilege` SET `name` = '新建任务' WHERE (`id` = '463');
UPDATE `sys_privilege` SET `name` = '查询条件（未审核）' WHERE (`id` = '293');
UPDATE `sys_privilege` SET `name` = '查询条件（已审核）' WHERE (`id` = '297');
UPDATE `sys_privilege` SET `name` = '列表（未审核）' WHERE (`id` = '294');
UPDATE `sys_privilege` SET `name` = '查询（未审核）' WHERE (`id` = '288');
UPDATE `sys_privilege` SET `name` = '列表（已审核）' WHERE (`id` = '298');
UPDATE `sys_privilege` SET `name` = '查询（已审核）' WHERE (`id` = '295');
UPDATE `sys_privilege` SET `name` = '查看详情（已审核）' WHERE (`id` = '296');
UPDATE `sys_privilege` SET `name` = '审核（未审核）' WHERE (`id` = '292');
UPDATE `sys_privilege` SET `name` = '批量通过（未审核）' WHERE (`id` = '291');
UPDATE `sys_privilege` SET `name` = '批量不通过（未审核）', `front_display` = '0' WHERE (`id` = '290');
UPDATE `sys_privilege` SET `name` = '导出审核样本（未审核）' WHERE (`id` = '289');
UPDATE `sys_privilege` SET `name` = '启用/禁用' WHERE (`id` = '302');
DELETE FROM `sys_privilege` WHERE (`id` = '412');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '310');
UPDATE `sys_privilege` SET `name` = '模版下载' WHERE (`id` = '317');
UPDATE `sys_privilege` SET `name` = '导出' WHERE (`id` = '318');
DELETE FROM `sys_privilege` WHERE (`id` = '438');
UPDATE `sys_privilege` SET `name` = '查看pdf' WHERE (`id` = '332');
UPDATE `sys_privilege` SET `name` = '作废/恢复' WHERE (`id` = '447');
UPDATE `sys_privilege` SET `front_display` = '0' WHERE (`id` = '495');
UPDATE `sys_privilege` SET `name` = '上传标答文件' WHERE (`id` = '666');
UPDATE `sys_privilege` SET `name` = '查询' WHERE (`id` = '674');
UPDATE `sys_privilege` SET `name` = '查看标答文件' WHERE (`id` = '497');
UPDATE `sys_privilege` SET `front_display` = '0' WHERE (`id` = '496');
UPDATE `sys_privilege` SET `name` = '设置客观题标答' WHERE (`id` = '668');
DELETE FROM `sys_privilege` WHERE (`id` = '174');
UPDATE `sys_privilege` SET `related` = '71,167,424,477,417,420,421,441,442,640,641' WHERE (`id` = '283');
DELETE FROM `sys_privilege` WHERE (`id` = '423');
DELETE FROM `sys_privilege` WHERE (`id` = '424');
DELETE FROM `sys_privilege` WHERE (`id` = '436');
DELETE FROM `sys_privilege` WHERE (`id` = '307');
DELETE FROM `sys_privilege` WHERE (`id` = '140');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('174', '导入模板下载', '/api/admin/common/download_import_template', 'URL', '149', '15', 'SYS', '1', '1', '1');
UPDATE `sys_privilege` SET `url` = 'Assign' WHERE (`id` = '448');
DELETE FROM `sys_privilege` WHERE (`id` = '870');
DELETE FROM `sys_privilege` WHERE (`id` = '871');
DELETE FROM `sys_privilege` WHERE (`id` = '46');
UPDATE `sys_privilege` SET `parent_id` = '43' WHERE (`id` = '56');
UPDATE `sys_privilege` SET `parent_id` = '43' WHERE (`id` = '57');
UPDATE `sys_privilege` SET `parent_id` = '43' WHERE (`id` = '58');
UPDATE `sys_privilege` SET `parent_id` = '43' WHERE (`id` = '105');
DELETE FROM `sys_privilege` WHERE (`id` = '327');
DELETE FROM `sys_privilege` WHERE (`id` = '328');
DELETE FROM `sys_privilege` WHERE (`id` = '329');
DELETE FROM `sys_privilege` WHERE (`id` = '330');
ALTER TABLE `exam_card`
ADD COLUMN `content` MEDIUMTEXT NULL COMMENT '题卡工具制作题卡内容' AFTER `status`,
ADD COLUMN `html_content` MEDIUMTEXT NULL COMMENT 'html格式内容' AFTER `content`,
ADD COLUMN `backup_attachment` MEDIUMTEXT NULL COMMENT '备用题卡json' AFTER `card_rule_id`,
ADD COLUMN `jpg_attachment` TEXT NULL COMMENT '题卡转换成的jpg文件信息' AFTER `backup_attachment`,
CHANGE COLUMN `create_id` `create_id` BIGINT NULL DEFAULT NULL COMMENT '创建人' AFTER `jpg_attachment`,
CHANGE COLUMN `create_time` `create_time` BIGINT NULL DEFAULT NULL COMMENT '创建时间' AFTER `create_id`,
CHANGE COLUMN `update_id` `update_id` BIGINT NULL DEFAULT NULL COMMENT '更新人' AFTER `create_time`,
CHANGE COLUMN `update_time` `update_time` BIGINT NULL DEFAULT NULL COMMENT '更新时间' AFTER `update_id`;
update exam_card a set a.content = (select b.content from exam_card_detail b where a.id = b.card_id);
update exam_card a set a.html_content = (select b.html_content from exam_card_detail b where a.id = b.card_id);
update exam_card a set a.backup_attachment = (select b.attachment_id from exam_card_detail b where a.id = b.card_id);
update exam_card a set a.jpg_attachment = (select b.jpg_attachment_info from exam_card_detail b where a.id = b.card_id);
ALTER TABLE `exam_task` DROP COLUMN `paper_number_id`;
ALTER TABLE `exam_detail_course` DROP COLUMN `org_id`;
update exam_print_plan set status = 'FINISH' where status = 'PRINT_FINISH';
update exam_print_plan set status = 'FINISH' where status = 'END';
update exam_detail set status = 'CANCEL' where status = 'EXPIRED';
ALTER TABLE `exam_detail`
ADD COLUMN `task_id` BIGINT(20) NULL COMMENT 'pdf生成异步任务ID（t_b_task）' AFTER `backup_count`,
CHANGE COLUMN `create_id` `create_id` BIGINT NULL DEFAULT NULL COMMENT '创建人' AFTER `task_id`,
CHANGE COLUMN `create_time` `create_time` BIGINT NULL DEFAULT NULL COMMENT '创建时间' AFTER `create_id`,
CHANGE COLUMN `update_id` `update_id` BIGINT NULL DEFAULT NULL COMMENT '更新人' AFTER `create_time`,
CHANGE COLUMN `update_time` `update_time` BIGINT NULL DEFAULT NULL COMMENT '更新时间' AFTER `update_id`;
ALTER TABLE `exam_paper_structure`
ADD COLUMN `object_answer_change` TINYINT(1) NULL DEFAULT '0' COMMENT '客观题答案有提交，需要重新统分。（1：有变动，需要统分，0：不统分）' AFTER `structure_change`;
ALTER TABLE `t_b_sync_task`
ADD COLUMN `org_code` VARCHAR(45) NULL COMMENT '学院编码' AFTER `object_id`,
ADD COLUMN `third_relate_name` VARCHAR(300) NULL COMMENT '云阅卷考试名称' AFTER `third_relate_id`,
ADD COLUMN `exam_time` VARCHAR(20) NULL COMMENT '考试时间' AFTER `third_relate_name`;
ALTER TABLE `exam_card`
ADD COLUMN `stage_content` MEDIUMTEXT NULL COMMENT '暂存内容（提交后置空）' AFTER `content`;
ALTER TABLE `basic_exam`
ADD COLUMN `auto_sync_student` TINYINT(1) NULL DEFAULT 0 COMMENT '是否自动同步考务数据（默认否）' AFTER `name`;
ALTER TABLE `sys_role_privilege`
ADD COLUMN `school_id` BIGINT(20) NULL COMMENT '内置角色，按学校自定义的权限' AFTER `enable`;
INSERT INTO sys_privilege
(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
VALUES(880, '重启流程', '/api/admin/exam/task/restart', 'URL', 42, 9, 'AUTH', NULL, 1, 1, 1);
INSERT INTO sys_privilege
(id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
VALUES(881, '打回', 'Restart', 'LINK', 42, 6, 'AUTH', '880', 1, 0, 1);
CREATE TABLE `exam_paper_class_marker` (
`id` BIGINT(20) NOT NULL,
`exam_paper_structure_id` BIGINT(20) NULL COMMENT '评卷参数id',
`marker_id` BIGINT(20) NULL COMMENT '评卷员id',
`login_name` VARCHAR(100) NULL COMMENT '评卷员登录名',
`class_name` MEDIUMTEXT NULL COMMENT '班级',
`create_id` BIGINT(20) NULL,
`create_time` BIGINT(20) NULL,
`update_id` BIGINT(20) NULL,
`update_time` BIGINT(20) NULL,
PRIMARY KEY (`id`));
ALTER TABLE `exam_paper_structure`
ADD COLUMN `open_class_reading` TINYINT(1) NULL DEFAULT 0 COMMENT '是否开启分班阅' AFTER `object_answer_change`;
ALTER TABLE `exam_paper_structure`
CHANGE COLUMN `status` `status` VARCHAR(700) NULL DEFAULT NULL COMMENT '{\n \"structure\":\n {\n \"save\": false,\n \"sync\": false\n },\n \"group\":\n {\n \"save\": false,\n \"sync\": false\n },\n \"class\":\n {\n \"save\": false,\n \"sync\": false\n },\n \"objective\":\n {\n \"save\": false,\n \"sync\": false\n },\n \"markerLeader\":\n {\n \"save\": false,\n \"sync\": false\n },\n \"marker\":\n {\n \"save\": false,\n \"sync\": false\n },\n \"answerFile\":\n {\n \"save\": false,\n \"sync\": false\n }\n}' ;
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('882', '查询分班阅班级', '/api/admin/exam/structure/list_user_class', 'URL', '488', '13', 'AUTH', '1', '1', '1');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('883', '查询评卷参数状态', '/api/admin/exam/structure/get_structure_status', 'URL', '488', '14', 'AUTH', '1', '1', '1');
UPDATE `sys_privilege` SET `related` = '490,540,667,669,671,672,754,855,882,883' WHERE (`id` = '670');
UPDATE `sys_privilege` SET `name` = '分班阅（开关）', `url` = 'OpenClassReading', `type` = 'BUTTON', `sequence` = '9', `related` = NULL, `enable` = '1', `default_auth` = '0', `front_display` = '1' WHERE (`id` = '495');
DELETE FROM `sys_privilege` WHERE (`id` = '496');
DELETE FROM `sys_privilege` WHERE (`id` = '497');
DELETE FROM `sys_privilege` WHERE (`id` = '666');
DELETE FROM `sys_privilege` WHERE (`id` = '668');
DELETE FROM `sys_privilege` WHERE (`id` = '753');
DELETE FROM `sys_privilege` WHERE (`id` = '854');
ALTER TABLE `exam_paper_structure`
ADD COLUMN `is_finish` TINYINT(1) NULL DEFAULT 0 COMMENT '是否完成。根据status中组合状态计算。用于当查询条件' AFTER `status`;
ALTER TABLE `t_b_sync_task`
ADD COLUMN `semester_id` BIGINT(20) NULL COMMENT '学期' AFTER `school_id`,
ADD COLUMN `exam_id` BIGINT(20) NULL COMMENT '考试' AFTER `semester_id`,
ADD COLUMN `course_code` VARCHAR(500) NULL COMMENT '课程代码' AFTER `exam_id`,
ADD COLUMN `course_name` VARCHAR(500) NULL COMMENT '课程名称' AFTER `course_code`,
ADD COLUMN `paper_number` VARCHAR(500) NULL COMMENT '试卷编号' AFTER `course_name`;
ALTER TABLE `t_b_task`
ADD COLUMN `semester_id` BIGINT(20) NULL COMMENT '学期' AFTER `id`,
ADD COLUMN `exam_id` BIGINT(20) NULL COMMENT '考试' AFTER `semester_id`,
ADD COLUMN `course_code` VARCHAR(500) NULL COMMENT '课程代码' AFTER `exam_id`,
ADD COLUMN `course_name` VARCHAR(500) NULL COMMENT '课程名称' AFTER `course_code`,
ADD COLUMN `paper_number` VARCHAR(500) NULL COMMENT '试卷编号' AFTER `course_name`;
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '234');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '308');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '512');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('330', '重新生成pdf', 'CreatePdf', 'LINK', '47', '6', 'AUTH', '190', '1', '0', '1');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '857');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('140', '模糊查询-试卷编号', '/api/admin/exam/task/paper_number_query', 'URL', '136', '4', 'SYS', '1', '1', '1');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '357');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '359');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '360');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '361');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '372');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '373');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '374');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '375');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '376');
UPDATE `sys_privilege` SET `enable` = '0', `front_display` = '0' WHERE (`id` = '391');
ALTER TABLE `exam_detail_course` ADD COLUMN `clazz_name` MEDIUMTEXT NULL COMMENT '班级（取学生表中的班级集合）' AFTER `clazz_id`;
UPDATE exam_detail_course edc
SET
edc.clazz_name = (SELECT
GROUP_CONCAT(DISTINCT es.clazz_name)
FROM
exam_student es
WHERE
clazz_name IS NOT NULL
AND edc.id = es.exam_detail_course_id
GROUP BY es.exam_detail_course_id);
ALTER TABLE `client_status` ADD INDEX `idx_1` (`school_id` ASC, `exam_detail_id` ASC, `course_code` ASC, `paper_number` ASC, `machine_code` ASC);
delete from t_b_sync_task where type = 'USER_PUSH';
UPDATE basic_major bm
SET
bm.belong_org_id = (SELECT
a.orgId
FROM
(SELECT
bc.id, so.id orgId
FROM
basic_college bc
LEFT JOIN sys_org so ON bc.school_id = so.school_id
AND bc.college_name = so.name) a
WHERE
bm.belong_org_id = a.id);
-- 必须在更新basic_major表belong_org_id后执行
UPDATE basic_student t
SET
t.belong_org_id = (SELECT
bm.belong_org_id
FROM
basic_major bm
WHERE
t.major_id = bm.id);
UPDATE `sys_config` SET `config_value` = '知学知考' WHERE (`id` = '24');
INSERT INTO `sys_role` (`id`, `school_id`, `org_id`, `name`, `enable`, `type`, `create_id`, `create_time`, `update_id`, `update_time`, `default_role`, `source`, `interpret`) VALUES (12, NULL, NULL, '印刷员', 1, 'PRINT', NULL, NULL, 1, 1691114261182, 1, 'SYS', '系统内置');
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (600, 12, 199, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (601, 12, 200, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (602, 12, 201, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (603, 12, 202, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (604, 12, 203, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (605, 12, 204, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (606, 12, 205, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (607, 12, 206, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (608, 12, 207, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (609, 12, 208, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (610, 12, 209, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (611, 12, 210, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (612, 12, 211, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (613, 12, 212, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (614, 12, 213, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (615, 12, 214, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (616, 12, 215, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (617, 12, 216, 1, NULL);
-- 按顺序执行以下步骤
-- 1.更新t_b_task表exam_id字段
UPDATE t_b_task t
SET
t.exam_id = (SELECT
ed.exam_id
FROM
exam_detail ed
WHERE
t.entity_id = ed.id)
WHERE
t.entity_id IS NOT NULL;
-- 2.更新t_b_task表paper_number字段
UPDATE t_b_task t
SET
t.paper_number = (SELECT
GROUP_CONCAT(edc.paper_number)
FROM
exam_detail_course edc
JOIN
exam_detail ed ON edc.exam_detail_id = ed.id
WHERE
t.school_id = ed.school_id
AND t.entity_id = ed.id)
WHERE
t.entity_id IS NOT NULL;
-- 3.更新t_b_task表course_code字段
UPDATE t_b_task t
SET
t.course_code = (SELECT
GROUP_CONCAT(edc.course_code)
FROM
exam_detail_course edc
JOIN
exam_detail ed ON edc.exam_detail_id = ed.id
WHERE
t.school_id = ed.school_id
AND t.entity_id = ed.id)
WHERE
t.entity_id IS NOT NULL;
-- 4.更新t_b_task表course_name字段
UPDATE t_b_task t
SET
t.course_name = (SELECT
GROUP_CONCAT(edc.course_name)
FROM
exam_detail_course edc
JOIN
exam_detail ed ON edc.exam_detail_id = ed.id
WHERE
t.school_id = ed.school_id
AND t.entity_id = ed.id)
WHERE
t.entity_id IS NOT NULL;
-- 4.更新t_b_task表semester_id字段
UPDATE t_b_task t
SET
t.semester_id = (SELECT
be.semester_id
FROM
basic_exam be
WHERE
t.exam_id = be.id);
update exam_paper_structure set is_finish = 1 , status = '{"answerFile":{"save":true,"sync":true},"markerClass":{"save":false,"sync":false},"marker":{"save":true,"sync":true},"markerLeader":{"save":true,"sync":true},"structure":{"save":true,"sync":true},"group":{"save":true,"sync":true},"objective":{"save":true,"sync":true}}' where status = 'FINISH';
update exam_paper_structure set is_finish = 0 , status = '{"answerFile":{"save":false,"sync":false},"markerClass":{"save":false,"sync":false},"marker":{"save":false,"sync":false},"markerLeader":{"save":false,"sync":false},"structure":{"save":false,"sync":false},"group":{"save":false,"sync":false},"objective":{"save":false,"sync":false}}' where status = 'INIT';
UPDATE `sys_privilege` SET `related` = '768' WHERE (`id` = '770');
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (1687280181941567488, 7, 768, 1, NULL);
INSERT INTO `sys_role_privilege` (`id`, `role_id`, `privilege_id`, `enable`, `school_id`) VALUES (1687281093103779841, 8, 768, 1, NULL);
-- sys_org表中，学院code要手动加上