Skip to content

Add unique index on project_authorizations (project_id, user_id)

Dominic Bauer requested to merge 395545-restore-deleted-index-2 into master

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.

Related to #395545 (closed)

Edited by Dominic Bauer

Merge request reports