3.3.0.sql 40 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242
  1. ALTER TABLE `exam_student` ADD COLUMN `course_paper_id` VARCHAR(45) NULL COMMENT '试卷编号(交互)' AFTER `paper_number`;
  2. ALTER TABLE `exam_detail_course` ADD COLUMN `course_paper_id` VARCHAR(45) NULL COMMENT '试卷编号(交互)' AFTER `paper_number`;
  3. ALTER TABLE `sys_user` ADD COLUMN `ui_setting` TEXT NULL COMMENT '阅卷参数' AFTER `historic_name`;
  4. ALTER TABLE `basic_exam` DROP COLUMN `auto_sync_student`;
  5. UPDATE `sys_privilege` SET `name` = '评卷管理' WHERE (`id` = '483');
  6. UPDATE `sys_privilege` SET `name` = '评卷管理' WHERE (`id` = '486');
  7. UPDATE `sys_privilege` SET `name` = '评卷入口' WHERE (`id` = '491');
  8. UPDATE `sys_privilege` SET `parent_id` = '897', `sequence` = '3' WHERE (`id` = '495');
  9. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('884', '列表', 'List', 'LIST', '491', '1', 'AUTH', '887', '1', '0', '1');
  10. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('886', '点击评卷', 'Marking', 'LINK', '491', '3', 'AUTH', '888,889,890,891,892,893,894,895,896', '1', '0', '1');
  11. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('885', '查询', 'Select', 'BUTTON', '491', '2', 'AUTH', '887', '1', '0', '1');
  12. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('887', '查询', '/api/admin/mark/entrance/list', 'URL', '491', '1', 'AUTH', '1', '1', '1');
  13. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('888', '评卷页面', '/api/mark/getSetting', 'URL', '491', '2', 'AUTH', '1', '1', '1');
  14. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('889', '获取分组列表', '/api/mark/getGroup', 'URL', '491', '3', 'AUTH', '1', '1', '1');
  15. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('890', '获取评卷状态', '/api/mark/getStatus', 'URL', '491', '4', 'AUTH', '1', '1', '1');
  16. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('891', '获取任务', '/api/mark/getTask', 'URL', '491', '5', 'AUTH', '1', '1', '1');
  17. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('892', '保存任务', '/api/mark/saveTask', 'URL', '491', '6', 'AUTH', '1', '1', '1');
  18. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('893', '获取评卷历史', '/api/mark/getHistory', 'URL', '491', '7', 'AUTH', '1', '1', '1');
  19. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('894', '更新个人评卷配置', '/api/mark/updateSetting', 'URL', '491', '8', 'AUTH', '1', '1', '1');
  20. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('895', '选择评卷分组', '/api/mark/subjectSelect', 'URL', '491', '9', 'AUTH', '1', '1', '1');
  21. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('896', '清理评卷员的评卷任务缓存', '/api/mark/clear', 'URL', '491', '10', 'AUTH', '1', '1', '1');
  22. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('897', '评卷设置', 'MarkSetting', 'MENU', '486', '2', 'AUTH', '1', '0', '1');
  23. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('898', '列表', 'List', 'LIST', '897', '1', 'AUTH', '900', '1', '0', '1');
  24. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('899', '查询', 'Select', 'BUTTON', '897', '2', 'AUTH', '900', '1', '0', '1');
  25. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('900', '查询', '/api/admin/mark/setting/list', 'URL', '897', '1', 'AUTH', '1', '1', '1');
  26. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('901', '评卷参数设置', 'MarkParamSetting', 'LINK', '897', '3', 'AUTH', '672,902,903,904,905,906,907,908,909,910,911,912,913,962,963', '1', '0', '1');
  27. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('902', '结构查询', '/api/admin/mark/question/list', 'URL', '897', '1', 'AUTH', '1', '1', '1');
  28. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('903', '结构提交', '/api/admin/mark/question/save', 'URL', '897', '2', 'AUTH', '1', '1', '1');
  29. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('904', '评卷任务查询', '/api/admin/mark/group/list', 'URL', '897', '3', 'AUTH', '1', '1', '1');
  30. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('905', '评卷任务新增', '/api/admin/mark/group/save', 'URL', '897', '4', 'AUTH', '1', '1', '1');
  31. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('906', '评卷任务修改', '/api/admin/mark/group/update', 'URL', '897', '5', 'AUTH', '1', '1', '1');
  32. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('907', '评卷任务删除', '/api/admin/mark/group/delete', 'URL', '897', '6', 'AUTH', '1', '1', '1');
  33. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('908', '分班阅查询', '/api/admin/mark/class/list', 'URL', '897', '7', 'AUTH', '1', '1', '1');
  34. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('909', '分班阅提交', '/api/admin/mark/class/save', 'URL', '897', '8', 'AUTH', '1', '1', '1');
  35. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('910', '客观题标答查询', '/api/admin/mark/question/objective/list', 'URL', '897', '9', 'AUTH', '1', '1', '1');
  36. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('911', '客观题标答提交', '/api/admin/mark/question/objective/save', 'URL', '897', '10', 'AUTH', '1', '1', '1');
  37. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('912', '主观题标答查询', '/api/admin/mark/question/subjective/get', 'URL', '897', '11', 'AUTH', '1', '1', '1');
  38. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('913', '主观题标答提交', '/api/admin/mark/question/subjective/upload', 'URL', '897', '12', 'AUTH', '1', '1', '1');
  39. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('914', '评卷设置', 'MarkConfig', 'LINK', '897', '4', 'AUTH', '915,916', '1', '0', '1');
  40. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('915', '数据获取', '/api/admin/mark/setting/paper/get', 'URL', '897', '13', 'AUTH', '1', '1', '1');
  41. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('916', '数据保存', '/api/admin/mark/setting/paper/save', 'URL', '897', '14', 'AUTH', '1', '1', '1');
  42. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('917', '评卷管理', 'MarkManage', 'MENU', '486', '3', 'AUTH', '1', '0', '1');
  43. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('918', '列表', 'List', 'LIST', '917', '1', 'AUTH', '925', '1', '0', '1');
  44. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('919', '查询', 'Select', 'BUTTON', '917', '2', 'AUTH', '925', '1', '0', '1');
  45. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('920', '查询条件', 'Condition', 'CONDITION', '917', '3', 'AUTH', '1', '0', '1');
  46. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('921', '查询条件', 'Condition', 'CONDITION', '491', '3', 'AUTH', '1', '0', '1');
  47. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('922', '查询条件', 'Condition', 'CONDITION', '897', '3', 'AUTH', '1', '0', '1');
  48. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('923', '导出评卷工作量', 'Export', 'BUTTON', '917', '4', 'AUTH', '926', '1', '0', '1');
  49. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('924', '结束评卷', 'BatchFinish', 'BUTTON', '917', '5', 'AUTH', '927', '1', '0', '1');
  50. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('925', '列表获取', '/api/admin/mark/setting/summary', 'URL', '917', '1', 'AUTH', '1', '1', '1');
  51. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('926', '导出评卷员工作量', '/api/admin/mark/setting/export_marker', 'URL', '917', '2', 'AUTH', '1', '1', '1');
  52. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('927', '结束评卷', '/api/admin/mark/paper/finish', 'URL', '917', '3', 'AUTH', '1', '1', '1');
  53. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('928', '进度列表查询', '/api/admin/mark/group/summary', 'URL', '917', '4', 'AUTH', '1', '1', '1');
  54. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('929', '评卷员管理列表查询', '/api/admin/mark/marker/list', 'URL', '917', '5', 'AUTH', '1', '1', '1');
  55. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('930', '重置', '/api/admin/mark/marker/reset', 'URL', '917', '6', 'AUTH', '1', '1', '1');
  56. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('931', '解绑', '/api/admin/mark/marker/delete', 'URL', '917', '7', 'AUTH', '1', '1', '1');
  57. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('932', '回收', '/api/admin/mark/marker/release', 'URL', '917', '8', 'AUTH', '1', '1', '1');
  58. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('933', '设置评卷数', '/api/admin/mark/marker/setTaskCount', 'URL', '917', '9', 'AUTH', '1', '1', '1');
  59. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('934', '评卷质量查询', '/api/admin/mark/quality/list', 'URL', '917', '10', 'AUTH', '1', '1', '1');
  60. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('935', '问题试卷列表查询', '/api/admin/mark/problem/list', 'URL', '917', '11', 'AUTH', '1', '1', '1');
  61. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('936', '问题试卷重置', '/api/admin/mark/problem/reset', 'URL', '917', '12', 'AUTH', '1', '1', '1');
  62. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('937', '仲裁管理列表查询', '/api/admin/mark/arbitrate/list', 'URL', '917', '13', 'AUTH', '1', '1', '1');
  63. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('938', '仲裁-获取任务', '/api/admin/mark/arbitrate/getTask', 'URL', '917', '14', 'AUTH', '1', '1', '1');
  64. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('939', '仲裁-左边的列表', '/api/admin/mark/arbitrate/getArbitrationList', 'URL', '917', '15', 'AUTH', '1', '1', '1');
  65. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('940', '仲裁-清理锁卷缓存', '/api/admin/mark/arbitrate/clear', 'URL', '917', '16', 'AUTH', '1', '1', '1');
  66. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('941', '仲裁-获取评卷状态', '/api/admin/mark/arbitrate/getStatus', 'URL', '917', '17', 'AUTH', '1', '1', '1');
  67. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('942', '仲裁-获取配置信息', '/api/admin/mark/arbitrate/getSetting', 'URL', '917', '18', 'AUTH', '1', '1', '1');
  68. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('943', '仲裁-保存任务', '/api/admin/mark/arbitrate/saveTask', 'URL', '917', '19', 'AUTH', '1', '1', '1');
  69. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('944', '查看详情', 'Detail', 'LINK', '917', '6', 'AUTH', '928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,964,965,966,967,968,1008', '1', '0', '1');
  70. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('945', '结束评卷', 'Finish', 'LINK', '917', '7', 'AUTH', '927', '1', '0', '1');
  71. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('946', '成绩检查', 'ScoreCheck', 'MENU', '486', '4', 'AUTH', '1', '0', '1');
  72. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('947', '列表', 'List', 'LIST', '946', '1', 'AUTH', '952', '1', '0', '1');
  73. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('948', '查询条件', 'Condition', 'CONDITION', '946', '2', 'AUTH', '1', '0', '1');
  74. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('949', '查询', 'Select', 'BUTTON', '946', '3', 'AUTH', '952', '1', '0', '1');
  75. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('950', '查看详情', 'Detail', 'LINK', '946', '4', 'AUTH', '953,954,955,956,957,958,959,960,969', '1', '0', '1');
  76. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('951', '查看签到表', 'PackageDetail', 'LINK', '946', '5', 'AUTH', '961', '1', '0', '1');
  77. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('952', '列表获取', '/api/admin/mark/setting/scoreList', 'URL', '946', '1', 'AUTH', '1', '1', '1');
  78. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('953', '详情列表', '/api/admin/mark/student/score', 'URL', '946', '2', 'AUTH', '1', '1', '1');
  79. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('954', '获取配置', '/api/admin/mark/track/getSetting', 'URL', '946', '3', 'AUTH', '1', '1', '1');
  80. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('955', '获取任务', '/api/admin/mark/track/getTask', 'URL', '946', '4', 'AUTH', '1', '1', '1');
  81. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('956', '主观题检查-获取配置', '/api/admin/mark/inspected/getSetting', 'URL', '946', '5', 'AUTH', '1', '1', '1');
  82. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('957', '主观题检查-获取任务', '/api/admin/mark/inspected/subjective/getTask', 'URL', '946', '6', 'AUTH', '1', '1', '1');
  83. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('958', '主观题检查-保存任务', '/api/admin/mark/inspected/subjective/saveTask', 'URL', '946', '7', 'AUTH', '1', '1', '1');
  84. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('959', '客观题检查-获取任务', '/api/admin/mark/inspected/objective/getTask', 'URL', '946', '8', 'AUTH', '1', '1', '1');
  85. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('960', '客观题检查-保存任务', '/api/admin/mark/inspected/objective/saveTask', 'URL', '946', '9', 'AUTH', '1', '1', '1');
  86. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('961', '签到表列表', '/api/admin/mark/paper/package/list', 'URL', '946', '10', 'AUTH', '1', '1', '1');
  87. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('962', '评卷区设置', '/api/admin/mark/group/update_picture_config', 'URL', '897', '13', 'AUTH', '1', '1', '1');
  88. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('963', '开启/关闭分班阅', '/api/admin/mark/group/update_open_mark_class', 'URL', '897', '14', 'AUTH', '1', '1', '1');
  89. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('964', '班级阅卷进度', '/api/admin/mark/group/class/summary', 'URL', '917', '20', 'AUTH', '1', '1', '1');
  90. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('965', '绑定评卷员', '/api/admin/mark/marker/add', 'URL', '917', '21', 'AUTH', '1', '1', '1');
  91. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('966', '评卷质量重新计算', '/api/admin/mark/quality/update', 'URL', '917', '22', 'AUTH', '1', '1', '1');
  92. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('967', '评卷质量给分曲线', '/api/admin/mark/quality/chart', 'URL', '917', '23', 'AUTH', '1', '1', '1');
  93. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('968', '绑定评卷员-已绑定评卷员集合', '/api/admin/mark/marker/list_bind_marker', 'URL', '917', '20', 'AUTH', '1', '1', '1');
  94. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('969', '客观题统分', '/api/admin/mark/student/objective/calculate', 'URL', '946', '11', 'AUTH', '1', '1', '1');
  95. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `sequence`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('970', '扫描端', 'scan', 'MENU', '11', '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', '1', '0', '0');
  96. UPDATE `sys_privilege` SET `name` = '打印端', `related` = '200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,973,974,975' WHERE (`id` = '199');
  97. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('971', '心跳接口', '/api/scan/server/heartbeat', 'URL', '970', '1', 'AUTH', '1', '1', '1');
  98. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('972', '登出接口', '/api/scan/logout', 'URL', '970', '2', 'AUTH', '1', '1', '1');
  99. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('973', '获取学期、考试列表', '/api/admin/basic/condition/scan/semester/list', 'URL', '970', '3', 'AUTH', '1', '1', '1');
  100. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('974', '获取课程、试卷编号列表', '/api/admin/basic/condition/scan/course/list', 'URL', '970', '4', 'AUTH', '1', '1', '1');
  101. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('975', '获取校区、考场', '/api/admin/basic/condition/scan/campus/list', 'URL', '970', '5', 'AUTH', '1', '1', '1');
  102. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('976', '扫描汇总-答题卡扫描、签到表扫描', '/api/scan/exam/card/info', 'URL', '970', '6', 'AUTH', '1', '1', '1');
  103. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('977', '扫描汇总-数据校对', '/api/scan/exam/check/info', 'URL', '970', '7', 'AUTH', '1', '1', '1');
  104. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('978', '答题卡卡格式列表', '/api/scan/answer/card/list', 'URL', '970', '8', 'AUTH', '1', '1', '1');
  105. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('979', '创建/修改题卡卡格式', '/api/scan/answer/card/save', 'URL', '970', '9', 'AUTH', '1', '1', '1');
  106. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('980', '删除答题卡卡格式', '/api/scan/answer/card/delete', 'URL', '970', '10', 'AUTH', '1', '1', '1');
  107. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('981', '答题卡适配卡格式上传', '/api/scan/answer/card/adapte/upload', 'URL', '970', '11', 'AUTH', '1', '1', '1');
  108. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('982', '答题卡卡格式查询', '/api/scan/answer/card/get', 'URL', '970', '12', 'AUTH', '1', '1', '1');
  109. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('983', '答题卡扫描批次创建', '/api/scan/answer/batch/create', 'URL', '970', '13', 'AUTH', '1', '1', '1');
  110. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('984', '答题卡扫描批次完成', '/api/scan/answer/batch/finish', 'URL', '970', '14', 'AUTH', '1', '1', '1');
  111. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('985', '答题卡扫描结果保存', '/api/scan/answer/batch/save', 'URL', '970', '15', 'AUTH', '1', '1', '1');
  112. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('986', '获取考生信息', '/api/scan/student/find', 'URL', '970', '16', 'AUTH', '1', '1', '1');
  113. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('987', '答题卡扫描原图上传', '/api/scan/answer/sheet/upload', 'URL', '970', '17', 'AUTH', '1', '1', '1');
  114. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('988', '答题卡条码识别坐标获取', '/api/scan/package/position/get', 'URL', '970', '18', 'AUTH', '1', '1', '1');
  115. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('989', '签到表扫描图片上传', '/api/scan/package/image/upload', 'URL', '970', '19', 'AUTH', '1', '1', '1');
  116. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('990', '签到表扫描结果保存', '/api/scan/package/save', 'URL', '970', '20', 'AUTH', '1', '1', '1');
  117. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('991', '签到表扫描结果列表', '/api/scan/package/image/list', 'URL', '970', '21', 'AUTH', '1', '1', '1');
  118. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('992', '签到表编号查询', '/api/scan/package/find', 'URL', '970', '22', 'AUTH', '1', '1', '1');
  119. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('993', '签到表详情', '/api/scan/package/image/get', 'URL', '970', '23', 'AUTH', '1', '1', '1');
  120. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('994', '查询答题卡扫描详情', '/api/scan/answer/query', 'URL', '970', '24', 'AUTH', '1', '1', '1');
  121. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('995', '查询答题卡扫描概要', '/api/scan/answer/summary', 'URL', '970', '25', 'AUTH', '1', '1', '1');
  122. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('996', '修改答题卡识别结果', '/api/scan/answer/omr/edit', 'URL', '970', '26', 'AUTH', '1', '1', '1');
  123. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('997', '更新缺考状态', '/api/scan/student/absent/update', 'URL', '970', '27', 'AUTH', '1', '1', '1');
  124. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('998', '修改答题卡扫描图片绑定考生', '/api/scan/answer/paper/migrate', 'URL', '970', '28', 'AUTH', '1', '1', '1');
  125. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('999', '任务确认', '/api/scan/student/confirm', 'URL', '970', '29', 'AUTH', '1', '1', '1');
  126. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1000', '任务待处理列表', '/api/scan/task/omr/get', 'URL', '970', '30', 'AUTH', '1', '1', '1');
  127. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1001', '任务提交', '/api/scan/task/omr/save', 'URL', '970', '31', 'AUTH', '1', '1', '1');
  128. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1002', '任务状态', '/api/scan/task/omr/status', 'URL', '970', '32', 'AUTH', '1', '1', '1');
  129. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1003', '任务释放', '/api/scan/task/omr/release', 'URL', '970', '33', 'AUTH', '1', '1', '1');
  130. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1004', '任务历史', '/api/scan/task/omr/history', 'URL', '970', '34', 'AUTH', '1', '1', '1');
  131. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1005', '答题卡二次识别', '/api/scan/answer/refix', 'URL', '970', '35', 'AUTH', '1', '1', '1');
  132. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`,`related`, `enable`, `default_auth`, `front_display`) VALUES ('1006', '查询条件', 'Condition', 'CONDITION', '970', '1', 'AUTH','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', '1', '0', '1');
  133. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1007', '未扫描-导出', '/api/scan/student/unexist/export', 'URL', '970', '36', 'AUTH', '1', '1', '1');
  134. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1008', '仲裁-评卷历史', '/api/admin/mark/arbitrate/getHistory', 'URL', '917', '20', 'AUTH', '1', '1', '1');
  135. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1009, '任务列表', '/api/scan/task/omr/list', 'URL', 970, 37, 'AUTH', NULL, 1, 1, 1);
  136. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1010', '人工绑定确认', '/api/scan/student/assign/confirm', 'URL', '970', '38', 'AUTH', '1', '1', '1');
  137. DELETE FROM `sys_privilege` WHERE (`id` = '392');
  138. DELETE FROM `sys_privilege` WHERE (`id` = '393');
  139. DELETE FROM `sys_privilege` WHERE (`id` = '394');
  140. DELETE FROM `sys_privilege` WHERE (`id` = '395');
  141. DELETE FROM `sys_privilege` WHERE (`id` = '396');
  142. DELETE FROM `sys_privilege` WHERE (`id` = '397');
  143. DELETE FROM `sys_privilege` WHERE (`id` = '398');
  144. DELETE FROM `sys_privilege` WHERE (`id` = '399');
  145. DELETE FROM `sys_privilege` WHERE (`id` = '431');
  146. DELETE FROM `sys_privilege` WHERE (`id` = '435');
  147. DELETE FROM `sys_privilege` WHERE (`id` = '792');
  148. DELETE FROM `sys_privilege` WHERE (`id` = '793');
  149. UPDATE `sys_privilege` SET `name` = '查看详情' WHERE (`id` = '320');
  150. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('327', '新增考生', '/api/admin/exam/print/add_exam_student', 'URL', '44', '8', 'AUTH', '1', '1', '1');
  151. UPDATE `sys_privilege` SET `related` = '55,327,328,329' WHERE (`id` = '320');
  152. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('328', '查询考场下试卷列表', '/api/admin/exam/print/list_exam_detail_course', 'URL', '44', '9', 'AUTH', '1', '1', '1');
  153. ALTER TABLE `exam_student` ADD COLUMN `required_fields` MEDIUMTEXT NULL COMMENT '基础字段' AFTER `print_card`;
  154. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('329', '删除考生', '/api/admin/exam/print/delete_exam_student', 'URL', '44', '10', 'AUTH', '1', '1', '1');
  155. INSERT INTO `sys_config` (`id`, `config_key`, `config_name`, `config_value`, `enable`, `sort`, `create_id`) VALUES ('41', 'package.barcode.position', '签到表条码坐标', '[0.7,0,0.3,0.1]', '1', '17', '1');
  156. UPDATE `sys_privilege` SET `url` = '/api/admin/exam/card/find_jpg_file' WHERE (`id` = '672');
  157. UPDATE `sys_privilege` SET `url` = 'MarkEntrance' WHERE (`id` = '491');
  158. DELETE FROM `sys_privilege` WHERE (`id` = '488');
  159. DELETE FROM `sys_privilege` WHERE (`id` = '489');
  160. DELETE FROM `sys_privilege` WHERE (`id` = '490');
  161. DELETE FROM `sys_privilege` WHERE (`id` = '494');
  162. DELETE FROM `sys_privilege` WHERE (`id` = '540');
  163. DELETE FROM `sys_privilege` WHERE (`id` = '667');
  164. DELETE FROM `sys_privilege` WHERE (`id` = '669');
  165. DELETE FROM `sys_privilege` WHERE (`id` = '670');
  166. DELETE FROM `sys_privilege` WHERE (`id` = '671');
  167. DELETE FROM `sys_privilege` WHERE (`id` = '673');
  168. DELETE FROM `sys_privilege` WHERE (`id` = '674');
  169. DELETE FROM `sys_privilege` WHERE (`id` = '754');
  170. DELETE FROM `sys_privilege` WHERE (`id` = '855');
  171. DELETE FROM `sys_privilege` WHERE (`id` = '857');
  172. DELETE FROM `sys_privilege` WHERE (`id` = '858');
  173. DELETE FROM `sys_privilege` WHERE (`id` = '859');
  174. DELETE FROM `sys_privilege` WHERE (`id` = '882');
  175. DELETE FROM `sys_privilege` WHERE (`id` = '883');
  176. DELETE FROM `sys_privilege` WHERE (`id` = '819');
  177. DELETE FROM `sys_privilege` WHERE (`id` = '820');
  178. DELETE FROM `sys_privilege` WHERE (`id` = '821');
  179. DELETE FROM `sys_privilege` WHERE (`id` = '822');
  180. DELETE FROM `sys_privilege` WHERE (`id` = '823');
  181. DELETE FROM `sys_privilege` WHERE (`id` = '824');
  182. DELETE FROM `sys_privilege` WHERE (`id` = '818');
  183. delete from t_b_sync_task where type in ('EXAM_PUSH','STRUCTURE_GROUP_PUSH','MARK_LEADER_PUSH','MARKER_PUSH','PAPER_ANSWER_FILE_PUSH','OBJECTIVE_ANSWER_PUSH', 'SCORE_PUSH');
  184. ALTER TABLE `t_b_sync_task`
  185. DROP COLUMN `org_code`,
  186. DROP COLUMN `third_relate_name`,
  187. DROP COLUMN `third_relate_id`,
  188. ADD COLUMN `paper_type` VARCHAR(10) NULL COMMENT '试卷类型' AFTER `paper_number`;
  189. ALTER TABLE `sys_user`
  190. ADD COLUMN `allow_manual_card` TINYINT(1) NULL DEFAULT 0 COMMENT '是否允许新增卡格式' AFTER `ui_setting`;
  191. ALTER TABLE `exam_card` DROP COLUMN `sync_status`;
  192. ALTER TABLE `exam_student` DROP COLUMN `sync_status`;
  193. ALTER TABLE `exam_print_plan` DROP COLUMN `sync_status`;
  194. ALTER TABLE `basic_print_config`
  195. ADD COLUMN `audit_content` VARCHAR(45) NULL COMMENT '[PAPER,CARD]' AFTER `review`;
  196. ALTER TABLE `exam_student`
  197. ADD COLUMN `can_delete` TINYINT(1) NULL DEFAULT 0 COMMENT '是否可以删除(手动新增可以删除)' AFTER `attachment_id`;
  198. ALTER TABLE `exam_student`
  199. CHANGE COLUMN `org_id` `org_id` BIGINT NULL COMMENT '机构id' ;
  200. UPDATE `sys_privilege` SET `url` = 'ScoreManage' WHERE (`id` = '487');
  201. DELETE FROM `sys_privilege` WHERE (`id` = '501');
  202. DELETE FROM `sys_privilege` WHERE (`id` = '503');
  203. UPDATE `sys_privilege` SET `url` = '/api/admin/mark/archive/score/list', `parent_id` = '487' WHERE (`id` = '542');
  204. UPDATE `sys_privilege` SET `url` = '/api/admin/mark/archive/score/export', `parent_id` = '488' WHERE (`id` = '543');
  205. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('488', '班级详情', 'ClassScoreDetail', 'LINK', '487', '1', 'AUTH', '490,543', '1', '0', '1');
  206. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('489', '成绩报告', 'ScoreReport', 'LINK', '487', '2', 'AUTH', '494', '1', '0', '1');
  207. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES ('490', '列表查询', '/api/admin/mark/archive/student/list', 'URL', '488', '1', 'AUTH', NULL, '1', '1', '1');
  208. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('494', '报告数据', '/api/admin/mark/archive/score/report', 'URL', '489', '1', 'AUTH', '1', '1', '1');
  209. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('1009', '任务列表', '/api/scan/task/omr/list', 'URL', '970', '37', 'AUTH', '1', '1', '1');
  210. UPDATE `sys_privilege` SET `property` = 'SYS' WHERE (`id` = '370');
  211. delete from sys_config where config_key = 'cloudmark.host.url';
  212. delete from sys_config where config_key = 'cloudmark.sync.mode';
  213. DELETE FROM `sys_privilege` WHERE (`id` = '546');
  214. DELETE FROM `sys_privilege` WHERE (`id` = '545');
  215. DELETE FROM `sys_privilege` WHERE (`id` = '544');
  216. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('544', '报告下载', '/api/admin/mark/archive/score/report/download', 'URL', '488', '3', 'AUTH', '1', '1', '1');
  217. UPDATE `sys_privilege` SET `related` = '490,543,544' WHERE (`id` = '488');
  218. DELETE FROM `sys_privilege` WHERE (`id` = '502');
  219. DELETE FROM `sys_privilege` WHERE (`id` = '563');
  220. DELETE FROM `sys_privilege` WHERE (`id` = '504');
  221. DELETE FROM `sys_privilege` WHERE (`id` = '505');
  222. UPDATE `sys_privilege` SET `related` = '490,543' WHERE (`id` = '488');
  223. UPDATE `sys_privilege` SET `related` = '494,544' WHERE (`id` = '489');
  224. UPDATE `sys_privilege` SET `parent_id` = '489', `sequence` = '2' WHERE (`id` = '544');
  225. ALTER TABLE `basic_template`
  226. ADD COLUMN `add_blank_page` TINYINT(1) NULL DEFAULT 1 COMMENT '是否增加空白页' AFTER `update_time`,
  227. ADD COLUMN `line_height_times` DOUBLE NULL DEFAULT 1 COMMENT '行间距在初始值扩大倍数(默认1)' AFTER `add_blank_page`;
  228. ALTER TABLE `basic_school` ADD COLUMN `default_school` TINYINT(1) NULL DEFAULT 0 AFTER `init_password`;
  229. ALTER TABLE `basic_card_rule`
  230. ADD COLUMN `undertaking_enable` TINYINT(1) NULL COMMENT '启用考生承诺书' AFTER `discipline`,
  231. ADD COLUMN `undertaking_body` VARCHAR(300) NULL COMMENT '考生承诺书内容' AFTER `undertaking_enable`;
  232. ALTER TABLE `basic_template`
  233. ADD COLUMN `font_size` VARCHAR(10) DEFAULT 'SMALL' COMMENT '字体大小(small,medium,large)' AFTER `line_height_times`;