Cannot delete user who has changed their password

When a user changes their own password, it creates a FOREIGN KEY constraint from the user to itself. This makes it impossible to delete the user without disabling foreign key constraints.