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