Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
382 B · 12 lines
SQL
at main
12345678910111213CREATE TABLE IF NOT EXISTS space_sync_state ( id TEXT PRIMARY KEY, space_id TEXT NOT NULL REFERENCES spaces(id) ON DELETE CASCADE, member_did TEXT NOT NULL, cursor TEXT, last_synced_at TEXT, status TEXT NOT NULL DEFAULT 'pending', error TEXT, UNIQUE(space_id, member_did));
CREATE INDEX idx_space_sync_state_space_id ON space_sync_state(space_id);