Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
290 B · 11 lines
SQL
at main
123456789101112CREATE TABLE labels ( src TEXT NOT NULL, uri TEXT NOT NULL, val TEXT NOT NULL, cts TIMESTAMPTZ NOT NULL, exp TIMESTAMPTZ, PRIMARY KEY (src, uri, val));
CREATE INDEX idx_labels_uri ON labels (uri);CREATE INDEX idx_labels_exp ON labels (exp) WHERE exp IS NOT NULL;