Something went wrong. Try again.
Our Personal Data Server from scratch! forked from tranquil.farm/tranquil-pds
Something went wrong. Try again.
324 B · 10 lines
SQL
at main
1234567891011CREATE TABLE backlinks ( uri TEXT NOT NULL, path TEXT NOT NULL, link_to TEXT NOT NULL, repo_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, PRIMARY KEY (uri, path));
CREATE INDEX backlinks_path_link_to_idx ON backlinks(path, link_to);CREATE INDEX backlinks_repo_id_idx ON backlinks(repo_id);