Merge lp:~wallyworld/launchpad/latestpublishedreleases-person-fk-1071581 into lp:launchpad/db-devel

[Ian Booth]

Add person foreign keys to the creator and maintainer columns on the LatestPersonSourcePackageReleaseCache table.

A previous db patch added a new LatestPersonSourcePackageReleaseCache table, but the person FK's could not be added immediately.

Once the necessary model code lands, the Person foreign keys can be added to the creator and maintainer columns on the LatestPersonSourcePackageReleaseCache table.

[Stuart Bishop (stub)]

Yup

review: Approve (db)

=== added file 'database/schema/patch-2209-38-1.sql'
--- database/schema/patch-2209-38-1.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-38-1.sql	2012-11-07 03:55:31 +0000
@@ -0,0 +1,14 @@
+-- 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 ONLY latestpersonsourcepackagereleasecache
+    ADD CONSTRAINT creator_fkey FOREIGN KEY (creator) REFERENCES person(id)
+    ON DELETE CASCADE;
+
+ALTER TABLE ONLY latestpersonsourcepackagereleasecache
+    ADD CONSTRAINT maintainer_fkey FOREIGN KEY (maintainer) REFERENCES person(id)
+    ON DELETE CASCADE;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 38, 1);