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 / 20260312000000_create_record_refs.sql
403 B 9 lines
1CREATE TABLE IF NOT EXISTS record_refs ( 2 source_uri TEXT NOT NULL REFERENCES records(uri) ON DELETE CASCADE, 3 target_uri TEXT NOT NULL, 4 collection TEXT NOT NULL, 5 PRIMARY KEY (source_uri, target_uri) 6); 7 8CREATE INDEX IF NOT EXISTS idx_record_refs_target ON record_refs (target_uri, collection); 9CREATE INDEX IF NOT EXISTS idx_records_created_at_uri ON records (created_at DESC, uri DESC);