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
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
