1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
-- Copyright 2011 Canonical Ltd. This software is licensed under the
-- GNU Affero General Public License version 3 (see the file LICENSE).
SET client_min_messages=ERROR;
-- Add a column to order DSP (this will allow controlling of the build
-- order for overlays).
ALTER TABLE DistroSeriesParent
ADD COLUMN ordering INTEGER NOT NULL DEFAULT 1;
-- Create index.
CREATE INDEX distroseriesparent__derived_series__ordering__idx
ON DistroSeriesParent USING btree (derived_series, ordering);
-- Drop redundant index.
DROP INDEX distroseriesparent__derivedseries__idx;
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 72, 0);
|