李建琦
6d655c9903
Release / update-version (push) Has been cancelled
Release / build-frontend (push) Has been cancelled
Release / release (push) Has been cancelled
Release / sync-version-file (push) Has been cancelled
CI / shell (push) Canceled after 0s
CI / test (push) Canceled after 0s
CI / frontend (push) Canceled after 0s
CI / golangci-lint (push) Canceled after 0s
Security Scan / backend-security (push) Canceled after 0s
Security Scan / frontend-security (push) Canceled after 0s
10 lines
307 B
SQL
10 lines
307 B
SQL
-- 迁移：为 api_keys 增加 last_used_at 字段，用于记录 API Key 最近使用时间
|
|
-- 幂等执行：可重复运行
|
|
|
|
ALTER TABLE api_keys
|
|
ADD COLUMN IF NOT EXISTS last_used_at TIMESTAMPTZ;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_api_keys_last_used_at
|
|
ON api_keys(last_used_at)
|
|
WHERE deleted_at IS NULL;
|