-- 考试设置扩展。执行前请确认目标数据库与备份策略。
ALTER TABLE exam_assessment
  ADD COLUMN question_order_mode varchar(16) NOT NULL DEFAULT 'FIXED' AFTER allow_rollback,
  ADD COLUMN option_order_mode varchar(16) NOT NULL DEFAULT 'FIXED' AFTER question_order_mode,
  ADD COLUMN allow_copy_question bit NOT NULL DEFAULT 0 AFTER option_order_mode,
  ADD COLUMN allow_paste_answer bit NOT NULL DEFAULT 0 AFTER allow_copy_question,
  ADD COLUMN multiple_score_mode varchar(32) NOT NULL DEFAULT 'ALL_OR_NOTHING' AFTER allow_paste_answer;