Deleting archived groups

Background

Occasionally we need to delete groups which have been created in error. This is the process.

It requires access to the database.

Process

• Check for users: SELECT email FROM users INNER JOIN users_groups ON users.id = users_groups.user WHERE group = X;
• If there are any users shown, as the person who has asked us to delete the group if they are sure, and to remove the members first.
• Check for events: SELECT * FROM events WHERE group = X;. We will not delete groups with events unless there are strong mitigating circumstances.
• DELETE FROM users_groups WHERE group = X; (should be a no-op given above).
• DELETE FROM group_network WHERE group_id = X;
• DELETE FROM grouptags_groups WHERE group = X;
• DELETE FROM group WHERE id = x;