Something went wrong. Try again.
An ATProto Powered Reputation Network
Something went wrong. Try again.
668 B · 15 lines
SQL
at master
12345678910111213141516-- Per-account sequence guards retain order when archive batches interleave accounts.CREATE TABLE IF NOT EXISTS replay_accounts ( source TEXT NOT NULL, author INTEGER NOT NULL REFERENCES identities(id), sequence INTEGER NOT NULL CHECK(sequence > 0), PRIMARY KEY(source, author)) WITHOUT ROWID;
-- Keep index deferral across restarts. A completed source does not defer indexes again.CREATE TABLE IF NOT EXISTS replay_indexes ( singleton INTEGER PRIMARY KEY CHECK(singleton = 1), source TEXT NOT NULL DEFAULT '', deferred INTEGER NOT NULL DEFAULT 0 CHECK(deferred IN (0, 1)));INSERT OR IGNORE INTO replay_indexes(singleton) VALUES (1);