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 / 20251240_add_block_count.sql
254 B 7 lines
1CREATE TABLE IF NOT EXISTS user_blocks ( 2 user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, 3 block_cid BYTEA NOT NULL, 4 PRIMARY KEY (user_id, block_cid) 5); 6 7CREATE INDEX IF NOT EXISTS idx_user_blocks_user_id ON user_blocks(user_id);