Something went wrong. Try again.
atproto Thingiverse but good
Something went wrong. Try again.
403 B · 12 lines
SQL
at main
12345678910111213CREATE TABLE follows ( follower_did TEXT NOT NULL, followed_did TEXT NOT NULL, rkey TEXT NOT NULL, cid TEXT NOT NULL, created_at INTEGER NOT NULL, PRIMARY KEY (follower_did, rkey), UNIQUE (follower_did, followed_did));
CREATE INDEX idx_follows_followed ON follows(followed_did, created_at DESC);CREATE INDEX idx_follows_follower ON follows(follower_did, created_at DESC);