Files

16 lines
603 B
SQL

-- Ported from the SQLite migration of the same number.
-- Who changed what, from where: every change through the admin API and the
-- administration pages. Detail is the request's fields with anything secret
-- taken out; status is how it ended.
CREATE TABLE audit_events (
id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
ts BIGINT NOT NULL,
actor TEXT NOT NULL,
source TEXT NOT NULL,
action TEXT NOT NULL,
target TEXT NOT NULL DEFAULT '',
detail TEXT NOT NULL DEFAULT '',
status INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX audit_events_ts ON audit_events (ts);