← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-72-0.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-72-0.sql
1
 
 
2
 
SET client_min_messages=ERROR;
3
 
 
4
 
ALTER TABLE DistroSeriesParent
5
 
    ADD COLUMN ordering INTEGER NOT NULL DEFAULT 1;
6
 
 
7
 
CREATE INDEX distroseriesparent__derived_series__ordering__idx
8
 
    ON DistroSeriesParent USING btree (derived_series, ordering);
9
 
 
10
 
DROP INDEX distroseriesparent__derivedseries__idx;
11
 
 
12
 
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 72, 0);