huang
42c5ec912f
All checks were successful
构建并部署到测试环境（无 SSH） / build-and-deploy (push) Successful in 7m13s
6 lines
484 B
SQL
6 lines
484 B
SQL
-- 回滚：恢复已删除的废弃字段（列结构恢复，历史数据已备份）
|
|
ALTER TABLE tb_iot_card ADD COLUMN IF NOT EXISTS first_commission_paid boolean NOT NULL DEFAULT false;
|
|
ALTER TABLE tb_iot_card ADD COLUMN IF NOT EXISTS accumulated_recharge bigint NOT NULL DEFAULT 0;
|
|
ALTER TABLE tb_device ADD COLUMN IF NOT EXISTS first_commission_paid boolean NOT NULL DEFAULT false;
|
|
ALTER TABLE tb_device ADD COLUMN IF NOT EXISTS accumulated_recharge bigint NOT NULL DEFAULT 0;
|