|
1790
by William Grant
Add unique indices on assessed(loginid, projectid) and assessed(groupid, projectid), where they should have been from the start. |
1 |
BEGIN; |
2 |
||
3 |
-- Add forgotten Assessed uniqueness constraints.
|
|
4 |
CREATE UNIQUE INDEX assessed_loginid_key ON assessed(loginid, projectid) WHERE loginid IS NOT NULL; |
|
5 |
CREATE UNIQUE INDEX assessed_groupid_key ON assessed(groupid, projectid) WHERE groupid IS NOT NULL; |
|
6 |
||
7 |
COMMIT; |
|
8 |