Add NOT NULL constraint to group_wiki_repository_states.group_id for Geo verification state migration

Natanael Silvarequested to merge
587551-add-not-null-constraint into master

What does this MR do and why?

This MR adds the NOT NULL constraint to the group_id sharding key column in the group_wiki_repository_states table and updates the table schema classification from gitlab_main_cell_local to gitlab_main_org. This is the final step in completing the sharding key work for this table, as part of the Geo verification state tables migration strategy for Protocell organization moves (&20487 (closed)). Changes:

  • Add NOT NULL constraint to group_id column
  • Update gitlab_schema to gitlab_main_org in db/docs/group_wiki_repository_states.yml
  • Add sharding_key attribute in db/docs/group_wiki_repository_states.yml

References

Closes #587551 (closed)

How to set up and validate locally

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.

Related to #587551 (closed)

Merge request reports