Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
376 B · 13 lines
SQL
at main
1234567891011121314CREATE TABLE IF NOT EXISTS backfill_jobs ( id TEXT PRIMARY KEY, collection TEXT, did TEXT, status TEXT NOT NULL DEFAULT 'pending', total_repos INTEGER DEFAULT 0, processed_repos INTEGER DEFAULT 0, total_records INTEGER DEFAULT 0, error TEXT, started_at TEXT, completed_at TEXT, created_at TEXT NOT NULL DEFAULT (datetime('now')));