← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-08-3.sql

  • Committer: Robert Collins
  • Date: 2010-09-20 02:09:16 UTC
  • mto: (7675.785.154 launchpad)
  • mto: This revision was merged to the branch mainline in revision 11695.
  • Revision ID: robert@canonical.com-20100920020916-3w7dy8ocl4fwz9jh
Review feedback.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-08-3.sql
4
4
-- index rather than doing the full search and sorting.
5
5
 
6
6
CREATE INDEX bugtask__date_closed__id__idx2 ON BugTask (date_closed, id desc nulls first);
7
 
DROP INDEX bugtask__date_closed__id__idx;
8
7
 
9
 
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 99, 0);
 
8
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 8, 3);