3.3.1.sql 1.2 KB

1234567891011121314151617
  1. -------------补考-----------
  2. update basic_exam t set t.category = 'MAKEUP' where t.category = 'ONLINE';
  3. update basic_exam t set t.category = 'FORMAL' where t.category = 'OFFLINE';
  4. ALTER TABLE `exam_print_plan` ADD COLUMN `category` VARCHAR(10) NULL COMMENT '考试类型' AFTER `org_id`;
  5. update exam_print_plan t set t.category = 'FORMAL' where t.category is null;
  6. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('193', '补考任务查询', '/api/admin/exam/print/list_makeup_task', 'URL', '43', '5', 'AUTH', '1', '1', '1');
  7. INSERT INTO `sys_privilege` (`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `enable`, `default_auth`, `front_display`) VALUES ('194', '补考任务保存', '/api/admin/exam/print/save_makeup_task', 'URL', '43', '6', 'AUTH', '1', '1', '1');
  8. UPDATE `sys_privilege` SET `related` = '50,49,193,194,621' WHERE (`id` = '310');
  9. --------------3.3.1新需求--------------
  10. ALTER TABLE `mark_paper`
  11. ADD COLUMN `open_double_marking` BIGINT(1) NULL DEFAULT 0 COMMENT '是否开启双评:true-开启,false-关闭' AFTER `paper_type`;