desertthunder.dev
a love letter to tangled (android, iOS, and a search API)
1CREATE TABLE IF NOT EXISTS indexing_audit (
2 id BIGSERIAL PRIMARY KEY,
3 source TEXT NOT NULL,
4 document_id TEXT NOT NULL,
5 collection TEXT NOT NULL,
6 cid TEXT NOT NULL,
7 decision TEXT NOT NULL,
8 attempt INTEGER NOT NULL DEFAULT 0,
9 error TEXT,
10 created_at TEXT NOT NULL
11);
12
13CREATE INDEX IF NOT EXISTS idx_indexing_audit_created
14 ON indexing_audit(created_at DESC);
15
16CREATE INDEX IF NOT EXISTS idx_indexing_audit_document
17 ON indexing_audit(document_id, created_at DESC);