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);