Merge lp:~wgrant/launchpad/accesspolicy-fks into lp:launchpad/db-devel

[William Grant]

Add missing Person foreign keys to AccessArtifactGrant and AccessPolicyGrant.

This branch adds foreign keys from AccessPolicyGrant and AccessArtifactGrant to Person. They were omitted from the original branch due to the deployment sequencing constraints surrounding person merging.

[Stuart Bishop (stub)]

iz good.

review: Approve (db)

=== added file 'database/schema/patch-2209-11-5.sql'
--- database/schema/patch-2209-11-5.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-11-5.sql	2012-03-21 00:59:21 +0000
@@ -0,0 +1,15 @@
+-- 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 AccessArtifactGrant ADD CONSTRAINT
+    accessartifactgrant__grantee__fk FOREIGN KEY (grantee) REFERENCES Person;
+ALTER TABLE AccessArtifactGrant ADD CONSTRAINT
+    accessartifactgrant__grantor__fk FOREIGN KEY (grantor) REFERENCES Person;
+ALTER TABLE AccessPolicyGrant ADD CONSTRAINT
+    accesspolicygrant__grantee__fk FOREIGN KEY (grantee) REFERENCES Person;
+ALTER TABLE AccessPolicyGrant ADD CONSTRAINT
+    accesspolicygrant__grantor__fk FOREIGN KEY (grantor) REFERENCES Person;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 11, 5);