~launchpad-pqm/launchpad/devel

1
2
3
4
5
6
7
8
9
10
11
12
ALTER TABLE BugTask
DROP CONSTRAINT bugtask_assignment_checks;

ALTER TABLE BugTask
ADD CONSTRAINT bugtask_assignment_checks
CHECK (
    CASE
        WHEN (product IS NOT NULL) THEN distribution IS NULL AND distrorelease IS NULL
        WHEN (distribution IS NOT NULL) THEN product IS NULL AND distrorelease IS NULL
        WHEN (distrorelease IS NOT NULL) THEN product IS NULL AND distribution IS NULL
    END
);