launchpad-reviewers team mailing list archive

[Iain Lane <iain@xxxxxxxxxxxxxxxxxxx>]

Iain Lane has proposed merging lp:~laney/launchpad/db-proposed-not-automatic-pre-release into lp:launchpad/db-devel.

Requested reviews:
  Stuart Bishop (stub): db
  Robert Collins (lifeless): db
  Launchpad code reviewers (launchpad-reviewers)
Related bugs:
  Bug #1016776 in Launchpad itself: "Users are offered updates to packages in the -proposed staging area pre-release"
  https://bugs.launchpad.net/launchpad/+bug/1016776

For more details, see:
https://code.launchpad.net/~laney/launchpad/db-proposed-not-automatic-pre-release/+merge/112134
-- 
https://code.launchpad.net/~laney/launchpad/db-proposed-not-automatic-pre-release/+merge/112134
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~laney/launchpad/db-proposed-not-automatic-pre-release into lp:launchpad/db-devel.

=== modified file 'database/schema/comments.sql'
--- database/schema/comments.sql	2012-06-15 05:49:38 +0000
+++ database/schema/comments.sql	2012-06-26 15:08:27 +0000
@@ -1151,6 +1151,7 @@
 COMMENT ON COLUMN DistroSeries.language_pack_delta IS 'Current language pack update based on language_pack_base information.';
 COMMENT ON COLUMN DistroSeries.language_pack_proposed IS 'Either a full or update language pack being tested to be used in language_pack_base or language_pack_delta.';
 COMMENT ON COLUMN DistroSeries.language_pack_full_export_requested IS 'Whether next language pack export should be a full export or an update.';
+COMMENT ON COLUMN DistroSeries.proposed_not_automatic_pre_release IS 'Whether the -proposed pocket is set NotAutomatic and ButAutomaticUpgrades when this distro release is pre-release (DEVELOPMENT or FROZEN) so that apt does not offer users upgrades into -proposed, but does offer upgrades within it.'
 
 
 -- PackageCopyJob

=== added file 'database/schema/patch-2209-25-1.sql'
--- database/schema/patch-2209-25-1.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-25-1.sql	2012-06-26 15:08:27 +0000
@@ -0,0 +1,9 @@
+-- Copyright 2012 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+ALTER TABLE distroseries
+    ADD COLUMN proposed_not_automatic_pre_release BOOLEAN NOT NULL DEFAULT FALSE;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 25, 1);