paper-library-service/sql/1.0.2修改内容.txt

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 '绑定图片数量' ;