1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
-- 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;
-- Convert DistroSeriesDifference source_version, parent_source_version,
-- and base_version types to debversion.
-- Change types.
ALTER TABLE DistroSeriesDifference
ALTER COLUMN source_version TYPE debversion,
ALTER COLUMN parent_source_version TYPE debversion,
ALTER COLUMN base_version TYPE debversion;
-- Create indexes.
CREATE INDEX distroseriesdifference__source_version__idx
ON DistroSeriesDifference(source_version);
CREATE INDEX distroseriesdifference__parent_source_version__idx
ON DistroSeriesDifference(parent_source_version);
CREATE INDEX distroseriesdifference__base_version__idx
ON DistroSeriesDifference(base_version);
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 55, 0);
|