Skip to content

Prepare unique index on project_authorizations (project_id, user_id)

Dominic Bauer requested to merge 395545-restore-deleted-index 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

Follow-up for adding the index synchronously: !125994 (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