Raphaël Victor Badin has proposed merging lp:~rvb/launchpad/dsp-order into lp:launchpad/db-devel.
Requested reviews: Robert Collins (lifeless): db Stuart Bishop (stub): db Launchpad code reviewers (launchpad-reviewers) For more details, see: https://code.launchpad.net/~rvb/launchpad/dsp-order/+merge/61727 This branch adds ordering support to DistroSeriesParent. When a series is an overlay, this will allow to control the build order. This branch only features the db part. -- https://code.launchpad.net/~rvb/launchpad/dsp-order/+merge/61727 Your team Launchpad code reviewers is requested to review the proposed merge of lp:~rvb/launchpad/dsp-order into lp:launchpad/db-devel.
=== modified file 'database/schema/comments.sql' --- database/schema/comments.sql 2011-05-18 13:30:36 +0000 +++ database/schema/comments.sql 2011-05-20 09:58:07 +0000 @@ -596,6 +596,7 @@ COMMENT ON COLUMN DistroSeriesParent.parent_series is 'The parent distroseries'; COMMENT ON COLUMN DistroSeriesParent.initialized is 'Whether or not the derived series was initialized by copying packages from the parent.'; COMMENT ON COLUMN DistroSeriesParent.is_overlay is 'Whether or not the derived series is an overlay over the parent series.'; +COMMENT ON COLUMN DistroSeriesParent.ordering is 'The parent ordering. Parents are ordered in ascending order starting from 1.'; COMMENT ON COLUMN DistroSeriesParent.pocket is 'The pocket for this overlay.'; COMMENT ON COLUMN DistroSeriesParent.component is 'The component for this overlay.'; === 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 2011-05-20 09:58:07 +0000 @@ -0,0 +1,19 @@ +-- 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; + +-- Add a column to order DSP (will be used to control the build order +-- for overlays). +ALTER TABLE DistroSeriesParent + ADD COLUMN ordering INTEGER NOT NULL DEFAULT 1; + +-- Update existing DSPs. +UPDATE DistroSeriesParent + SET ordering = 1; + +-- Create index. +CREATE INDEX distroseriesparent__ordering + ON DistroSeriesParent (ordering); + +INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 99, 0);
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
