Merge lp:~stub/launchpad/pending-db-changes into lp:launchpad/db-devel

[Stuart Bishop]

Attempt to fix patch-2208-65-0.sql against production data by making the BugSubscriptionFilter -> StructuralSubscription relationship ON DELETE CASCADE

Attempt to fix patch-2208-65-0.sql against production data by making the BugSubscriptionFilter -> StructuralSubscription relationship ON DELETE CASCADE

[Stuart Bishop (stub)]

review: Approve

[Robert Collins (lifeless)]

review: Approve (release-critical)

=== modified file 'database/schema/patch-2208-65-0.sql'
--- database/schema/patch-2208-65-0.sql	2011-04-27 14:51:54 +0000
+++ database/schema/patch-2208-65-0.sql	2011-05-02 07:21:35 +0000
@@ -3,6 +3,18 @@
 
 SET client_min_messages=ERROR;
 
+-- Before we remove unwanted StructuralSubscription rows, we can tweak
+-- some foreign key constraints to make this removal easier.
+-- StructuralSubscription is referenced by BugSubscriptionFilter
+-- BugSubscriptionFilter is referenced too by BugNotificationFilter, but
+-- that relationship is already ON DELETE CASCADE.
+ALTER TABLE BugSubscriptionFilter
+    DROP CONSTRAINT bugsubscriptionfilter_structuralsubscription_fkey,
+    ADD CONSTRAINT bugsubscriptionfilter__structuralsubscription__fk
+        FOREIGN KEY (structuralsubscription)
+        REFERENCES StructuralSubscription ON DELETE CASCADE;
+
+
 -- WHAT ARE WE DOING? -----------------------------------------------------
 
 -- These three errors have been observed, and are corrected here.