248_intelligent_assessment_v2.sql 969 B

123456789101112
  1. -- Keep historical judgments intact; new evaluations separate execution and verdicts.
  2. ALTER TABLE account_tests DROP CONSTRAINT IF EXISTS account_tests_status_check;
  3. ALTER TABLE account_tests ADD CONSTRAINT account_tests_status_check CHECK (
  4. status IN ('queued','running','completed','cancelled','success','failed','rate_limited','account_error','model_error','request_error','network_error','suspected_degradation')
  5. );
  6. ALTER TABLE account_tests ADD COLUMN IF NOT EXISTS available_at TIMESTAMPTZ NOT NULL DEFAULT NOW();
  7. ALTER TABLE account_tests ADD COLUMN IF NOT EXISTS queue_reason TEXT NOT NULL DEFAULT '';
  8. UPDATE test_settings SET config = config || '{"answer_type":"number","answer_unit":"颗","answer_format":"answer_line"}'::jsonb
  9. WHERE test_type='candy' AND config->>'evaluator'='exact_answer'
  10. AND config->>'expected_answer'='12'
  11. AND config->>'prompt' LIKE '盒子里有 24 颗糖。小明取走总数的四分之一%'
  12. AND NOT (config ? 'answer_type');