Add NOT NULL (NOT VALID) on ci_sources_pipelines#project_id

Tomasz Skoruparequested to merge
tskorupa/add-not-null-to-ci_sources_pipelines-on-project_id into master

What does this MR do and why?

Add NOT NULL (NOT VALID) to ci_sources_pipelines#project_id

Addresses #555251

Follows up on 6dafca0d

There are no rows with ci_sources_pipelines#project_id IS NULL on gitlab.com (https://postgres.ai/console/gitlab/gitlab-production-ci/sessions/42471/commands/130009)

The attribute is already enforced in the model (https://gitlab.com/gitlab-org/gitlab/-/blob/96b20ce271294f9aaa65ece66f7b05f476d967d0/app/models/ci/sources/pipeline.rb\#L25).

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Tomasz Skorupa

Merge request reports