2 -- WARNING - WARNING - WARNING - WARNING - WARNING - WARNING - WARNING - WARNING - WARNING
4 -- WARNING - WARNING - WARNING - WARNING - WARNING - WARNING - WARNING - WARNING - WARNING
6 -- WARNING - WARNING - WARNING - WARNING - WARNING - WARNING - WARNING - WARNING - WARNING
8 -- This SQL file is going to delete every mailing_list from the db that is not associated with
9 -- an existing group. Please check that this does really is not deleting sensible information
11 DELETE FROM mail_group_list WHERE group_id NOT IN (SELECT group_id FROM groups);
13 ALTER TABLE ONLY mail_group_list
14 ADD CONSTRAINT mail_group_list_group_id_fkey
15 FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;