14 lines
521 B
SQL
14 lines
521 B
SQL
-- 删除 tb_device 的索引和字段
|
|
DROP INDEX IF EXISTS idx_device_series_allocation;
|
|
ALTER TABLE tb_device
|
|
DROP COLUMN IF EXISTS series_allocation_id,
|
|
DROP COLUMN IF EXISTS first_commission_paid,
|
|
DROP COLUMN IF EXISTS accumulated_recharge;
|
|
|
|
-- 删除 tb_iot_card 的索引和字段
|
|
DROP INDEX IF EXISTS idx_iot_card_series_allocation;
|
|
ALTER TABLE tb_iot_card
|
|
DROP COLUMN IF EXISTS series_allocation_id,
|
|
DROP COLUMN IF EXISTS first_commission_paid,
|
|
DROP COLUMN IF EXISTS accumulated_recharge;
|