1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
-- Copyright 2011 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 BugNotificationFilter (
bug_notification INTEGER NOT NULL
REFERENCES BugNotification(id)
ON DELETE CASCADE,
bug_subscription_filter INTEGER NOT NULL
REFERENCES BugSubscriptionFilter(id)
ON DELETE CASCADE,
CONSTRAINT bugnotificationfilter_pkey
PRIMARY KEY (bug_notification, bug_subscription_filter)
);
CREATE INDEX BugNotificationFilter__bug_subscription_filter__idx
ON BugNotificationFilter(bug_subscription_filter);
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 50, 0);
|