1 CREATE TABLE user_former_groups (
2 ufg_user
INTEGER NULL REFERENCES mwuser(user_id
) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
3 ufg_group
TEXT NOT NULL
5 CREATE UNIQUE INDEX user_former_groups_unique
ON user_former_groups (ufg_user
, ufg_group
);