1 CREATE TABLE person_block (
3 person_id int REFERENCES person ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
4 target_id int REFERENCES person ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
5 published timestamp NOT NULL DEFAULT now(),
6 UNIQUE (person_id, target_id)
9 CREATE TABLE community_block (
10 id serial PRIMARY KEY,
11 person_id int REFERENCES person ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
12 community_id int REFERENCES community ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
13 published timestamp NOT NULL DEFAULT now(),
14 UNIQUE (person_id, community_id)