You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
7 lines
342 B
7 lines
342 B
-- 机巢软删除支持：保留直播、告警、任务、指令、视频等历史数据用于审计。
|
|
-- 执行前请备份数据库。
|
|
|
|
ALTER TABLE dock
|
|
ADD COLUMN deleted_at DATETIME NULL COMMENT '软删除时间' AFTER updated_at,
|
|
ADD KEY idx_dock_user_deleted (user_id, deleted_at),
|
|
ADD KEY idx_dock_deleted (deleted_at);
|
|
|