mirror of
https://gitee.com/wanwujie/sub2api
synced 2026-04-03 15:02:13 +08:00
11 lines
377 B
MySQL
11 lines
377 B
MySQL
|
-- 043_add_usage_cleanup_cancel_audit.sql
|
||
|
|
-- usage_cleanup_tasks 取消任务审计字段
|
||
|
|
|
||
|
|
ALTER TABLE usage_cleanup_tasks
|
||
|
|
ADD COLUMN IF NOT EXISTS canceled_by BIGINT REFERENCES users(id) ON DELETE SET NULL,
|
||
|
|
ADD COLUMN IF NOT EXISTS canceled_at TIMESTAMPTZ;
|
||
|
|
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_usage_cleanup_tasks_canceled_at
|
||
|
|
ON usage_cleanup_tasks(canceled_at DESC);
|
||
|
|
|