姚章浩
12 lines
596 B
SQL
12 lines
596 B
SQL
-- 000020_feedback_support_trigger: let an existing support-case workflow be
|
|
-- triggered by a downvote while preserving one case per successful Turn.
|
|
|
|
ALTER TABLE support_cases
|
|
ALTER COLUMN coverage_decision_id DROP NOT NULL,
|
|
ADD COLUMN IF NOT EXISTS trigger_type TEXT NOT NULL DEFAULT 'coverage_uncovered'
|
|
CHECK (trigger_type IN ('coverage_uncovered', 'feedback_down')),
|
|
ADD COLUMN IF NOT EXISTS trigger_feedback_id TEXT REFERENCES answer_feedback(id);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_support_cases_trigger_type_created
|
|
ON support_cases (trigger_type, created_at DESC);
|