19 lines
593 B
TypeScript
19 lines
593 B
TypeScript
// shared/lib/audit/audit-schema.ts — audit_logs 表结构常量
|
|
export const AUDIT_LOGS_TABLE_SQL = `
|
|
CREATE TABLE IF NOT EXISTS audit_logs (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
user_id INTEGER REFERENCES users(id),
|
|
username TEXT,
|
|
api_key_id INTEGER,
|
|
action TEXT NOT NULL,
|
|
entity_type TEXT NOT NULL,
|
|
entity_id INTEGER,
|
|
details TEXT,
|
|
ip_address TEXT,
|
|
created_at TEXT DEFAULT (datetime('now', '+8 hours'))
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_audit_logs_time ON audit_logs(created_at);
|
|
CREATE INDEX IF NOT EXISTS idx_audit_logs_user ON audit_logs(username, created_at);
|
|
`
|