16 lines
503 B
SQL
16 lines
503 B
SQL
CREATE TABLE IF NOT EXISTS access_logs (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
occurred_at TEXT NOT NULL,
|
|
user_upn TEXT NOT NULL,
|
|
action TEXT NOT NULL,
|
|
method TEXT NOT NULL,
|
|
path TEXT NOT NULL,
|
|
status_code INTEGER,
|
|
share_id INTEGER,
|
|
details TEXT
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_access_logs_occurred_at ON access_logs (occurred_at);
|
|
CREATE INDEX IF NOT EXISTS idx_access_logs_user ON access_logs (user_upn);
|
|
CREATE INDEX IF NOT EXISTS idx_access_logs_action ON access_logs (action);
|