-- 回滚:恢复已删除的废弃字段(列结构恢复,历史数据已备份) 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;