A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
429 B · 12 lines
12345678910111213CREATE TABLE IF NOT EXISTS records ( uri TEXT PRIMARY KEY, did TEXT NOT NULL, collection TEXT NOT NULL, rkey TEXT NOT NULL, record TEXT NOT NULL, cid TEXT NOT NULL, indexed_at TEXT DEFAULT (datetime('now')));
CREATE INDEX IF NOT EXISTS idx_records_did_collection ON records (did, collection);CREATE INDEX IF NOT EXISTS idx_records_collection ON records (collection);