Something went wrong. Try again.
A lexicon-driven AppView for ATProto. forked from gamesgamesgamesgames.games/happyview
Something went wrong. Try again.
482 B · 13 lines
SQL
at dev
1234567891011121314CREATE TABLE event_logs ( id TEXT PRIMARY KEY, event_type TEXT NOT NULL, severity TEXT NOT NULL DEFAULT 'info', actor_did TEXT, subject TEXT, detail TEXT NOT NULL DEFAULT '{}', created_at TEXT NOT NULL DEFAULT (datetime('now')));
CREATE INDEX idx_event_logs_event_type ON event_logs (event_type);CREATE INDEX idx_event_logs_severity ON event_logs (severity);CREATE INDEX idx_event_logs_created_at ON event_logs (created_at);