Port of issue-42692-deployment-chat-notifications to EE

This is a port of https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/27338 to Enterprise Edition.

This is for a failing compat check due to the schema file.

https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/203369149

The offending line in EE:

https://gitlab.com/gitlab-org/gitlab-ee/blob/master/db/schema.rb#L13

And in CE:

https://gitlab.com/gitlab-org/gitlab-ce/blob/master/db/schema.rb#L13