← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-63-2.sql

  • Committer: Launchpad Patch Queue Manager
  • Date: 2011-05-23 18:43:31 UTC
  • mfrom: (13084.2.6 page-match-rewrite-url)
  • Revision ID: launchpad@pqm.canonical.com-20110523184331-dhd2c7cgfuu49epw
[r=sinzui][bug=784273] Adds facility to the PageMatch to handle bad
        URIs

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-63-2.sql
1
 
 
2
 
SET client_min_messages=ERROR;
3
 
 
4
 
CREATE INDEX bugsummary__milestone__idx
5
 
ON BugSummary(milestone) WHERE milestone IS NOT NULL;
6
 
 
7
 
 
8
 
CREATE INDEX bugsummary__full__idx
9
 
ON BugSummary(status, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, milestone, tag);
10
 
 
11
 
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 63, 2);