18 lines
813 B
SQL
18 lines
813 B
SQL
-- 删除个人客户设备号绑定表
|
|
DROP INDEX IF EXISTS idx_personal_customer_device_deleted_at;
|
|
DROP INDEX IF EXISTS idx_personal_customer_device_device_no;
|
|
DROP INDEX IF EXISTS idx_personal_customer_device_customer_device;
|
|
DROP TABLE IF EXISTS personal_customer_device;
|
|
|
|
-- 删除个人客户 ICCID 绑定表
|
|
DROP INDEX IF EXISTS idx_personal_customer_iccid_deleted_at;
|
|
DROP INDEX IF EXISTS idx_personal_customer_iccid_iccid;
|
|
DROP INDEX IF EXISTS idx_personal_customer_iccid_customer_iccid;
|
|
DROP TABLE IF EXISTS personal_customer_iccid;
|
|
|
|
-- 删除个人客户手机号绑定表
|
|
DROP INDEX IF EXISTS idx_personal_customer_phone_deleted_at;
|
|
DROP INDEX IF EXISTS idx_personal_customer_phone_phone;
|
|
DROP INDEX IF EXISTS idx_personal_customer_phone_customer_phone;
|
|
DROP TABLE IF EXISTS personal_customer_phone;
|