1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
SET client_min_messages=ERROR;
-- Allow for package diffs against both derived and parent versions.
ALTER TABLE DistroSeriesDifference ADD COLUMN parent_package_diff integer CONSTRAINT distroseriesdifference__parent_package_diff__fk REFERENCES packagediff;
CREATE INDEX distroseriesdifference__parent_package_diff__idx ON distroseriesdifference(parent_package_diff);
-- Add columns for source_version and parent_source_version
ALTER TABLE DistroSeriesDifference ADD COLUMN source_version text;
ALTER TABLE DistroSeriesDifference ADD CONSTRAINT valid_source_version CHECK(valid_debian_version(source_version));
ALTER TABLE DistroSeriesDifference ADD COLUMN parent_source_version text;
ALTER TABLE DistroSeriesDifference ADD CONSTRAINT valid_parent_source_version CHECK(valid_debian_version(parent_source_version));
-- Add a unique constraint/index for the source_package_name/derived series combo and drop the previous index.
ALTER TABLE DistroSeriesDifference ADD CONSTRAINT distroseriesdifference__derived_series__source_package_name__key UNIQUE (derived_series, source_package_name);
DROP INDEX distroseriesdifference__derived_series__idx;
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 12, 0);
|