1 -- Add the mod_transfer_community log table
2 CREATE TABLE mod_transfer_community (
4 mod_person_id int REFERENCES person ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
5 other_person_id int REFERENCES person ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
6 community_id int REFERENCES community ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
7 removed boolean DEFAULT FALSE,
8 when_ timestamp NOT NULL DEFAULT now()