~azzar1/unity/add-show-desktop-key

Add unique indices on assessed(loginid, projectid) and assessed(groupid, projectid), where they should have been from the start.

added added

removed removed

183

OR (loginid IS NULL AND groupid IS NOT NULL))

184

);

185

186

-- We must use conditional constraints here -- NULL != NULL.

187

CREATE UNIQUE INDEX assessed_loginid_key ON assessed(loginid, projectid) WHERE loginid IS NOT NULL;

188

CREATE UNIQUE INDEX assessed_groupid_key ON assessed(groupid, projectid) WHERE groupid IS NOT NULL;

189

186

190

CREATE TABLE project_extension (

187

191

extensionid SERIAL PRIMARY KEY,

188

192

assessedid INT4 REFERENCES assessed (assessedid) NOT NULL,