← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-99-0.sql

References and indices on bug/branch.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-99-0.sql
35
35
CREATE UNIQUE INDEX pillarobserverpermission__policy__person__key
36
36
    ON PillarObserverPermission(policy, person) WHERE artifact IS NULL;
37
37
 
 
38
ALTER TABLE bug
 
39
    ADD COLUMN observer_policy integer REFERENCES PillarObserverPolicy;
 
40
CREATE INDEX bug__observer_policy__idx ON bug(observer_policy);
 
41
 
 
42
ALTER TABLE branch
 
43
    ADD COLUMN observer_policy integer REFERENCES PillarObserverPolicy;
 
44
CREATE INDEX branch__observer_policy__idx ON branch(observer_policy);
 
45
 
38
46
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 99, 0);