junhong_cmp_fiber/migrations/archive/000100_remove_carrier_billing_day.down.sql at main - junhong_cmp_fiber - 长沙鑫精信息技术

csxj2026/junhong_cmp_fiber

Files

huang 5e9e41db21 feat: 归档旧迁移文件，创建初始化数据迁移和重置脚本

2026-04-14 11:24:35 +08:00

4 lines

253 B

SQL

Raw Permalink Blame History

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.

 -- 回滚：恢复 billing_day 字段
 ALTER TABLE tb_carrier ADD COLUMN IF NOT EXISTS billing_day INT DEFAULT 1;
 COMMENT ON COLUMN tb_carrier.billing_day IS '运营商计费日（用于流量查询接口的计费周期计算，联通=27，其他=1）';