Skip to content

Move `project_authorizations` to gitlab_main_cell

Manoj M J requested to merge project-authorizations-415204-cells-iteration-2-configure-namespaces-adjacent-tables-to-be-gitlab_main_cell-to-support into master

What does this MR do and why?

As part of building out Cells, this MR tags the project_authorizations table as a cell-local table, by assigning the schema gitlab_main_cell to it.

After assigning this schema, the specs failed because of cross-joins involving project_authorizations table and other tables in the clusterwide schema, and this has been marked and allowed for now using allow_cross_joins_across_databases(url: 'https://gitlab.com/gitlab-org/gitlab/-/issues/422045') wherever this happens.

project_authorizations.user_id needs to be converted to a loose foreign key as well, and that has been marked in the MR as well.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before After

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #415204 (closed)

Edited by Manoj M J

Merge request reports