edavis.dev / happyview
A lexicon-driven AppView for ATProto.
0
Fork 0

Configure Feed

Select the types of activity you want to include in your feed.

happyview / migrations / postgres / 20260314100001_create_labels.sql
290 B 11 lines
1CREATE TABLE labels ( 2 src TEXT NOT NULL, 3 uri TEXT NOT NULL, 4 val TEXT NOT NULL, 5 cts TIMESTAMPTZ NOT NULL, 6 exp TIMESTAMPTZ, 7 PRIMARY KEY (src, uri, val) 8); 9 10CREATE INDEX idx_labels_uri ON labels (uri); 11CREATE INDEX idx_labels_exp ON labels (exp) WHERE exp IS NOT NULL;