goat.navy / tranquil-pds
forked from tranquil.farm/tranquil-pds
Our Personal Data Server from scratch!
0
Fork 0

Configure Feed

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

tranquil-pds / migrations / 20260114_backlinks.sql
324 B 10 lines
1CREATE TABLE backlinks ( 2 uri TEXT NOT NULL, 3 path TEXT NOT NULL, 4 link_to TEXT NOT NULL, 5 repo_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, 6 PRIMARY KEY (uri, path) 7); 8 9CREATE INDEX backlinks_path_link_to_idx ON backlinks(path, link_to); 10CREATE INDEX backlinks_repo_id_idx ON backlinks(repo_id);