← Back to team overview

launchpad-reviewers team mailing list archive

[Merge] lp:~stevenk/launchpad/db-link-spph-pu into lp:launchpad/db-devel

 

Steve Kowalik has proposed merging lp:~stevenk/launchpad/db-link-spph-pu into lp:launchpad/db-devel.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~stevenk/launchpad/db-link-spph-pu/+merge/105592

As part of showing which archive admin was responsible for accepting an upload into the series, we should preserve part of the information by linking the packageupload with the source publication.
-- 
https://code.launchpad.net/~stevenk/launchpad/db-link-spph-pu/+merge/105592
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~stevenk/launchpad/db-link-spph-pu into lp:launchpad/db-devel.
=== added file 'database/schema/patch-2209-15-0.sql'
--- database/schema/patch-2209-15-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-15-0.sql	2012-05-14 01:00:38 +0000
@@ -0,0 +1,8 @@
+-- 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 SourcePackagePublishingHistory ADD COLUMN PackageUpload INTEGER REFERENCES PackageUpload;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 15, 0);