Add project_authorizations.is_unique column and schedule partial index
requested to merge 418205-restore-unique-index-on-project_authorizations-project_id-user_id-1 into master
What does this MR do and why?
First MR in a series to restore a previously deleted unique index on project_authorizations
(#418205).
- adds a nullable column
project_authorizations.is_unique
. - schedules a partial unique index
CREATE UNIQUE INDEX CONCURRENTLY ON project_authorizations (user_id, project_id) WHERE is_unique;
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 #418205
Edited by Dominic Bauer