Prior to this change, it was possible for the global project and snippet
visibilities to be NULL, which could cause errors in the UI. We now
enforce a NOT NULL constraint and set the default value to private for
both visibility levels.

Closes https://gitlab.com/gitlab-org/gitlab/issues/35013