1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
-- Copyright 2010 Canonical Ltd. This software is licensed under the
-- GNU Affero General Public License version 3 (see the file LICENSE).
SET client_min_messages=ERROR;
CREATE TABLE IncrementalDiff(
id serial PRIMARY KEY,
diff integer NOT NULL CONSTRAINT diff_fk REFERENCES Diff ON DELETE CASCADE,
branch_merge_proposal integer NOT NULL CONSTRAINT branch_merge_proposal_fk REFERENCES BranchMergeProposal ON DELETE CASCADE,
old_revision integer NOT NULL CONSTRAINT old_revision_fk REFERENCES Revision ON DELETE CASCADE,
new_revision integer NOT NULL CONSTRAINT new_revision_fk REFERENCES Revision ON DELETE CASCADE);
CREATE INDEX incrementaldiff__diff__idx ON IncrementalDiff(diff);
CREATE INDEX incrementaldiff__branch_merge_proposal__idx ON IncrementalDiff(branch_merge_proposal);
CREATE INDEX incrementaldiff__old_revision__idx ON IncrementalDiff(old_revision);
CREATE INDEX incrementaldiff__new_revision__idx ON IncrementalDiff(new_revision);
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 17, 0);
|