Add sharding keys and update schema for security policy tables
requested to merge 452380-change-schema-and-adding-sharding-key-or-desired-sharding-key-for-approval_policy_rules-and into master
What does this MR do and why?
!146504 (merged) introduced new tables for persisting security policies to the database, but the MR missed to assign the gitlab_main_cell schema and lacked sharding keys.
Both tables are empty and behind a disabled feature flag:
- https://console.postgres.ai/gitlab/gitlab-production-main/sessions/27569/commands/85912
- https://console.postgres.ai/gitlab/gitlab-production-main/sessions/27569/commands/85913
MR acceptance checklist
Please 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 #452380
Edited by Dominic Bauer