← Back to branch summary

~launchpad-pqm/launchpad/devel

7675.804.16 by Michael Nelson
Initial patch with trigger for consistency. 
1
 
SET client_min_messages=ERROR;

2
 









3



-- Allow for package diffs against both derived and parent versions.










4



ALTER TABLE DistroSeriesDifference ADD COLUMN parent_package_diff integer CONSTRAINT distroseriesdifference__parent_package_diff__fk REFERENCES packagediff;










5



CREATE INDEX distroseriesdifference__parent_package_diff__idx ON distroseriesdifference(parent_package_diff);










6










7675.804.17
by Michael Nelson


Updated patch, simplifying.



7



-- Add columns for source_version and parent_source_version










8



ALTER TABLE DistroSeriesDifference ADD COLUMN source_version text;








7675.804.29
by Michael Nelson


Updates from stub's review.



9



ALTER TABLE DistroSeriesDifference ADD CONSTRAINT valid_source_version CHECK(valid_debian_version(source_version));








7675.804.17
by Michael Nelson


Updated patch, simplifying.



10



ALTER TABLE DistroSeriesDifference ADD COLUMN parent_source_version text;








7675.804.29
by Michael Nelson


Updates from stub's review.



11



ALTER TABLE DistroSeriesDifference ADD CONSTRAINT valid_parent_source_version CHECK(valid_debian_version(parent_source_version));










12












13



-- Add a unique constraint/index for the source_package_name/derived series combo and drop the previous index.










14



ALTER TABLE DistroSeriesDifference ADD CONSTRAINT distroseriesdifference__derived_series__source_package_name__key UNIQUE (derived_series, source_package_name);










15



DROP INDEX distroseriesdifference__derived_series__idx;










16












17



INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 12, 0);