|
7675.821.1
by Robert Collins
Add an index column to BugMessage to permit persistently storing the row of bug messages. |
1 |
SET client_min_messages=ERROR; |
2 |
||
3 |
-- Store the row index of bug messages so we don't have to calculate it all the time.
|
|
4 |
ALTER TABLE BugMessage ADD COLUMN index integer; |
|
5 |
||
|
7675.821.3
by Robert Collins
Stubs tweaks. |
6 |
-- BugMessage.indexes must be unique per bug.
|
7 |
ALTER TABLE BugMessage ADD CONSTRAINT bugmessage__bug__index__key UNIQUE (bug, index); |
|
|
7675.821.1
by Robert Collins
Add an index column to BugMessage to permit persistently storing the row of bug messages. |
8 |
|
|
7675.821.2
by Robert Collins
Final DB number allocated. |
9 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 14, 0); |