Add unique index on project_authorizations (project_id, user_id)
What does this MR do and why?
Restores a previously deleted unique index on project_authorizations
. See !119642 (comment 1464793622)
CREATE UNIQUE INDEX index_unique_project_authorizations_on_project_id_user_id ON project_authorizations (project_id, user_id);
https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/20268/commands/66225
The index was previously scheduled in !125992 (closed).
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #395545 (closed)
Edited by Dominic Bauer