- Fix orphaned data causing 500 in profile/chat_names when projects
  are removed
- Add foreign key to prevent future orphaned rows
- Add before destroy hook to project cleaning up any chat names

Relates to https://gitlab.com/gitlab-org/gitlab/issues/25230