|
12366.6.12
by Gary Poster
set omitted notifications as handled in the database. |
1 |
-- Copyright 2011 Canonical Ltd. This software is licensed under the
|
2 |
-- GNU Affero General Public License version 3 (see the file LICENSE).
|
|
3 |
SET client_min_messages=ERROR; |
|
4 |
||
|
12366.6.20
by Gary Poster
convert is_omitted to status enum on BugNotification, per review. |
5 |
-- The default value for status can be found in the
|
6 |
-- BugNotificationStatus DBEnum in lib/lp/bugs/enum.py.
|
|
|
12366.6.12
by Gary Poster
set omitted notifications as handled in the database. |
7 |
ALTER TABLE BugNotification |
|
12366.6.20
by Gary Poster
convert is_omitted to status enum on BugNotification, per review. |
8 |
ADD COLUMN status INTEGER NOT NULL DEFAULT 10; |
|
12366.6.12
by Gary Poster
set omitted notifications as handled in the database. |
9 |
|
|
12366.6.26
by Gary Poster
make changes to db patch per db review |
10 |
CLUSTER BugNotification USING bugnotification__date_emailed__idx; |
11 |
||
12 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 45, 0); |