姚章浩
30 lines
1019 B
SQL
30 lines
1019 B
SQL
-- 000006_native_card_feedback_reasons down migration
|
|
-- A schema rollback cannot retain values rejected by the legacy constraint,
|
|
-- so map each native reason to its closest B2 legacy category first.
|
|
|
|
UPDATE answer_feedback
|
|
SET reason_code = CASE reason_code
|
|
WHEN 'content_mismatch' THEN 'irrelevant'
|
|
WHEN 'content_incomplete' THEN 'not_resolved'
|
|
WHEN 'illogical_expression' THEN 'unclear'
|
|
WHEN 'factual_error' THEN 'incorrect'
|
|
WHEN 'sensitive_content' THEN 'other'
|
|
WHEN 'answer_not_wanted' THEN 'not_resolved'
|
|
ELSE reason_code
|
|
END
|
|
WHERE reason_code IN (
|
|
'content_mismatch',
|
|
'content_incomplete',
|
|
'illogical_expression',
|
|
'factual_error',
|
|
'sensitive_content',
|
|
'answer_not_wanted'
|
|
);
|
|
|
|
ALTER TABLE answer_feedback
|
|
DROP CONSTRAINT IF EXISTS answer_feedback_reason_code_check;
|
|
|
|
ALTER TABLE answer_feedback
|
|
ADD CONSTRAINT answer_feedback_reason_code_check
|
|
CHECK (reason_code IN ('', 'incorrect', 'not_resolved', 'irrelevant', 'unclear', 'outdated', 'other'));
|