Chats: Add cascading delete on both referenced users.
Also remove the now-superfluous join in the chat controller, which was only used to filter out these cases.
Also remove the now-superfluous join in the chat controller, which was only used to filter out these cases.