← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

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

  • Committer: Robert Collins
  • Date: 2010-09-16 07:00:26 UTC
  • mto: (7675.785.142 launchpad)
  • mto: This revision was merged to the branch mainline in revision 11695.
  • Revision ID: robert@canonical.com-20100916070026-hpochcbx6k3ldk31
Stubs tweaks.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-14-0.sql
3
3
-- Store the row index of bug messages so we don't have to calculate it all the time.
4
4
ALTER TABLE BugMessage ADD COLUMN index integer;
5
5
 
6
 
CREATE UNIQUE INDEX bugmessage__bug_index_unique ON BugMessage (bug, index);
7
 
 
 
6
-- BugMessage.indexes must be unique per bug.
 
7
ALTER TABLE BugMessage ADD CONSTRAINT bugmessage__bug__index__key UNIQUE (bug, index);
8
8
 
9
9
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 14, 0);