Files
junhong_cmp_fiber/migrations/000159_update_agent_recharge_status_constraint.down.sql
break b5b7f9a41e
All checks were successful
构建并部署到测试环境(无 SSH) / build-and-deploy (push) Successful in 7m53s
迁移
2026-06-29 12:29:31 +09:00

7 lines
277 B
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
-- 回滚将状态约束恢复为不包含驳回状态6
ALTER TABLE tb_agent_recharge_record
DROP CONSTRAINT IF EXISTS chk_agent_recharge_status;
ALTER TABLE tb_agent_recharge_record
ADD CONSTRAINT chk_agent_recharge_status CHECK (status IN (1, 2, 3, 4, 5));