moth11.net
tiny 88x31 lexicon for atproto
1CREATE TABLE buttons (
2 uri TEXT PRIMARY KEY,
3 did TEXT NOT NULL,
4 blob_cid TEXT NOT NULL,
5 blob_mime TEXT NOT NULL,
6 alt TEXT,
7 href TEXT,
8 cid TEXT NOT NULL,
9 posted_at TIMESTAMPTZ NOT NULL DEFAULT now(),
10 indexed_at TIMESTAMPTZ NOT NULL DEFAULT now()
11);
12
13CREATE INDEX ON buttons (posted_at);