mirror of
https://tangled.org/tranquil.farm/tranquil-pds
synced 2026-02-08 21:30:08 +00:00
8 lines
254 B
SQL
8 lines
254 B
SQL
CREATE TABLE IF NOT EXISTS user_blocks (
|
|
user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
|
|
block_cid BYTEA NOT NULL,
|
|
PRIMARY KEY (user_id, block_cid)
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_user_blocks_user_id ON user_blocks(user_id);
|