cmd/bsky-users/schema.sql at 17376ca3b2ff9199d850efc5c2e9a9c0458341bb · edavis.dev/bsky-tools

edavis.dev / bsky-tools

this repo has no description

bsky-tools / cmd / bsky-users / schema.sql

at 17376ca3b2ff9199d850efc5c2e9a9c0458341bb 164 B view raw

1CREATE TABLE IF NOT EXISTS users (did TEXT, ts TIMESTAMP);
2CREATE UNIQUE INDEX IF NOT EXISTS did_idx on users(did);
3CREATE INDEX IF NOT EXISTS ts_idx on users(ts);