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');