1.修改接口（采集端图片上传）：/api/admin/client/picture/upload?studentCode=    增加studentCode参数
2.增加接口（刷新缓存）：/api/admin/common/flush_cache?type=        type值为：学校系统设置：SYS_SETTING   超管全局系统设置：SYS_SETTING_GLOBAL
3.增加接口（导入考生）：/api/admin/paper/scan_task/import_student?paperScanTaskId=&file=
4.修改接口(识别)：/api/admin/paper/library/ocr 改名为/api/admin/paper/library/recognition?type=    并增加type参数（识别类型）。值：OCR或者BAR_CODE
5.增加接口（查询已开启的识别方式）：/api/admin/sys/setting/recognition_mode      权限绑在开始处理按钮



ALTER TABLE paper_scan_task_detail`
ADD COLUMN `teach_clazz_name` VARCHAR(100) NULL COMMENT '教学班' AFTER `student_id`;

ALTER TABLE `paper_scan_task_detail`
ADD COLUMN `teacher_name` VARCHAR(45) NULL COMMENT '任课老师' AFTER `teach_clazz_name`;

ALTER TABLE `paper_scan_task`
ADD COLUMN `course_code` VARCHAR(45) NULL COMMENT '课程代码' AFTER `scan_task_name`;

UPDATE `sys_privilege` SET `name` = '识别', `url` = '/api/admin/paper/library/recognition' WHERE (`id` = '35');

INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('265', '导入考生', 'Import', 'LINK', '244', '12', 'AUTH', '266', '1', '0', '1');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('266', '导入考生', '/api/admin/paper/scan_task/import_student', 'URL', '244', '10', 'AUTH',  '1', '0', '1');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('635', '刷新缓存', '/api/admin/common/flush_cache', 'URL', '149', '20', 'SYS', '1', '1', '1');
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`) VALUES ('414', '查询识别方式', '/api/admin/sys/setting/recognition_mode', 'URL', '409', '3', 'AUTH', '1', '1');
UPDATE `sys_privilege` SET `related` = '27,28,34,35,42,414' WHERE (`id` = '22');










-------以下需要更新到江汉大学服务器

ALTER TABLE `paper_scan_task` ADD COLUMN `check_user_id` BIGINT(20) NULL COMMENT '数据校验员Id' AFTER `scan_user_id`;
ALTER TABLE `paper_scan_task` ADD COLUMN `bind_count` INT NULL DEFAULT '0' COMMENT '已绑定数量' AFTER `scan_count`;
ALTER TABLE `paper_scan_task` ADD COLUMN `progress` DOUBLE NULL DEFAULT '0' COMMENT '绑定进度' AFTER `bind_count`;
UPDATE `sys_privilege` SET `type` = 'LINK' WHERE (`id` = '22');


ALTER TABLE `paper_scan_task`
ADD COLUMN `abnormal_count` INT NULL DEFAULT '0' COMMENT '异常数量' AFTER `bind_count`;
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('267', '新增', 'Add', 'BUTTON', '244', '13', 'AUTH', '245', '1', '0', '1');
UPDATE `sys_privilege` SET `name` = '新增' WHERE (`id` = '245');

ALTER TABLE `paper_scan_task_detail`
CHANGE COLUMN `is_bind` `bind_count` INT NULL DEFAULT '0' COMMENT '绑定图片数量' ;

CREATE TABLE `paper_archives_course` (
  `id` BIGINT(20) NOT NULL,
  `school_id` BIGINT(20) NULL COMMENT '学校ID',
  `paper_archives_id` BIGINT(20) NULL COMMENT '档案ID',
  `course_code` VARCHAR(45) NULL COMMENT '课程代码',
  `course_name` VARCHAR(100) NULL COMMENT '课程名称',
  `teacher_name` VARCHAR(100) NULL COMMENT '任课老师',
  `teach_clazz_name` VARCHAR(45) 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`));


UPDATE `sys_privilege` SET `id` = '44', `name` = '导入课程信息', `parent_id` = '9', `related` = '45' WHERE (`id` = '265');
UPDATE `sys_privilege` SET `id` = '45', `name` = '导入课程信息', `parent_id` = '9' WHERE (`id` = '266');

ALTER TABLE `paper_scan_task_detail`
DROP COLUMN `teacher_name`,
DROP COLUMN `teach_clazz_name`;


DELETE from sys_privilege where id in (44,45);
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (44, '导入课程信息', 'Import', 'LINK', 9, 12, 'AUTH', 45, 1, 0, 1);
INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (45, '导入课程信息', '/api/admin/paper/archives/import', 'URL', 9, 10, 'AUTH', NULL, 1, 1, 1);

ALTER TABLE `paper_scan_task`
DROP COLUMN `teach_clazz_name`,
DROP COLUMN `teacher_name`;


DELETE FROM `sys_privilege` WHERE (`id` = '24');
DELETE FROM `sys_privilege` WHERE (`id` = '41');
DELETE FROM `sys_privilege` WHERE (`id` = '26');


ALTER TABLE `paper_scan_task_detail`
ADD UNIQUE INDEX `idx_paper_scan_task_id` (`paper_scan_task_id` ASC, `student_id` ASC) VISIBLE;


ALTER TABLE `paper_scan_task`
ADD INDEX `idx_paper_archives_id` (`paper_archives_id` ASC) VISIBLE;