A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
504 B · 13 lines
SQL
at dev
1234567891011121314CREATE TABLE event_logs ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), event_type TEXT NOT NULL, severity TEXT NOT NULL DEFAULT 'info', actor_did TEXT, subject TEXT, detail JSONB NOT NULL DEFAULT '{}', created_at TIMESTAMPTZ NOT NULL DEFAULT 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);