launchpad-reviewers team mailing list archive

[Michael Nelson <michael.nelson@xxxxxxxxxxxxx>]

Michael Nelson has proposed merging lp:~michael.nelson/launchpad/distro-series-difference-schema into lp:launchpad.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)


Just an in-progress MP for discussion atm.

Possible schema change to support:
https://dev.launchpad.net/LEP/DerivativeDistributions
-- 
https://code.launchpad.net/~michael.nelson/launchpad/distro-series-difference-schema/+merge/33515
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~michael.nelson/launchpad/distro-series-difference-schema into lp:launchpad.

=== modified file 'database/schema/comments.sql'
--- database/schema/comments.sql	2010-08-23 04:51:48 +0000
+++ database/schema/comments.sql	2010-08-24 12:56:44 +0000
@@ -503,6 +503,14 @@
 COMMENT ON COLUMN DistributionSourcePackageCache.changelog IS 'A concatenation of the source package release changelogs for this source package, where the status is not REMOVED.';
 COMMENT ON COLUMN DistributionSourcePackageCache.archive IS 'The archive where the source is published.';
 
+-- DistroSeriesDifference
+COMMENT ON TABLE DistroSeriesDifference IS 'A difference of versions for a package in a derived distroseries and its parent distroseries.';
+COMMENT ON COLUMN DistroSeriesDifference.derived_series IS 'The derived distroseries with the difference from its parent.';
+COMMENT ON COLUMN DistroSeriesDifference.source_package_publishing_history IS 'The latest published version of the package in the derived distro series.';
+COMMENT ON COLUMN DistroSeriesDifference.parent_source_package_publishing_history IS 'The latest published version of the package in the parent distro series.';
+COMMENT ON COLUMN DistroSeriesDifference.comment IS 'An editable comment used to note action being taken.';
+COMMENT ON COLUMN DistroSeriesDifference.status IS 'A distroseries difference can be ignored or resolved.';
+
 -- DistroSeriesPackageCache
 
 COMMENT ON TABLE DistroSeriesPackageCache IS 'A cache of the text associated with binary packages in the distroseries. This table allows for fast queries to find a binary packagename that matches a given text.';
@@ -533,13 +541,13 @@
 can be changed without restarting Launchpad
 <https://dev.launchpad.net/LEP/FeatureFlags>';
 
-COMMENT ON COLUMN FeatureFlag.scope IS 
+COMMENT ON COLUMN FeatureFlag.scope IS
     'Scope in which this setting is active';
 
-COMMENT ON COLUMN FeatureFlag.priority IS 
+COMMENT ON COLUMN FeatureFlag.priority IS
     'Higher priority flags override lower';
 
-COMMENT ON COLUMN FeatureFlag.flag IS 
+COMMENT ON COLUMN FeatureFlag.flag IS
     'Name of the flag being controlled';
 
 -- KarmaCategory

=== added file 'database/schema/patch-2208-99-0.sql'
--- database/schema/patch-2208-99-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2208-99-0.sql	2010-08-24 12:56:44 +0000
@@ -0,0 +1,15 @@
+SET client_min_messages=ERROR;
+
+CREATE TABLE DistroSeriesDifference (
+    id serial PRIMARY KEY,
+    derived_series integer NOT NULL CONSTRAINT distroseriesdifference__derived_series__fk REFERENCES distroseries,
+    source_package_publishing_history integer CONSTRAINT distroseriesdifference__spph__fk REFERENCES sourcepackagepublishinghistory,
+    parent_source_package_publishing_history integer CONSTRAINT distroseriesdifference__parent_spph__fk REFERENCES sourcepackagepublishinghistory,
+    comment text,
+    status integer NOT NULL
+);
+CREATE INDEX distroseriesdifference__derived_series__idx ON distroseriesdifference(derived_series);
+CREATE INDEX distroseriesdifference__spph__idx ON distroseriesdifference(source_package_publishing_history);
+CREATE INDEX distroseriesdifference__status__idx ON distroseriesdifference(status);
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 99, 0);

=== modified file 'database/schema/security.cfg'
--- database/schema/security.cfg	2010-08-15 11:29:23 +0000
+++ database/schema/security.cfg	2010-08-24 12:56:44 +0000
@@ -133,6 +133,7 @@
 public.distributionmirror               = SELECT, INSERT, UPDATE, DELETE
 public.distributionsourcepackage        = SELECT, INSERT, UPDATE, DELETE
 public.distributionsourcepackagecache   = SELECT
+public.distroseriesdifference           = SELECT, INSERT, UPDATE
 public.distroserieslanguage             = SELECT, INSERT, UPDATE
 public.distroseriespackagecache         = SELECT
 public.emailaddress                     = SELECT, INSERT, UPDATE, DELETE