huang
42c5ec912f
All checks were successful
构建并部署到测试环境（无 SSH） / build-and-deploy (push) Successful in 7m13s
7 lines
417 B
SQL
7 lines
417 B
SQL
-- 删除 tb_iot_card 和 tb_device 表中的废弃分佣追踪字段
|
|
-- 这两个字段已被 accumulated_recharge_by_series (JSONB) 字段替代
|
|
ALTER TABLE tb_iot_card DROP COLUMN IF EXISTS first_commission_paid;
|
|
ALTER TABLE tb_iot_card DROP COLUMN IF EXISTS accumulated_recharge;
|
|
ALTER TABLE tb_device DROP COLUMN IF EXISTS first_commission_paid;
|
|
ALTER TABLE tb_device DROP COLUMN IF EXISTS accumulated_recharge;
|