From c7231a3af3b794028332cf538f1e9771c5a6ebab Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 18 Mar 2016 14:11:11 +0100 Subject: [PATCH] Bug 16103: Remove FK sms_provider_id in deletedborrowers Content-Type: text/plain; charset=utf-8 This patch removes the FK constraint for sms_provider_id in table deletedborrowers. (We do not need FKs in that table.) It just corrects a newly added db revision in updatedatabase. If this is pushed before releasing master, no need to do anything more. Note that this key was not found in kohastructure and the DBIx schema. Signed-off-by: Marcel de Rooy --- installer/data/mysql/updatedatabase.pl | 3 --- 1 file changed, 3 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index c3cf05d..6177454 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -11755,9 +11755,6 @@ if ( CheckVersion($DBversion) ) { $dbh->do(q{ ALTER TABLE deletedborrowers ADD sms_provider_id INT( 11 ) NULL DEFAULT NULL AFTER smsalertnumber; }); - $dbh->do(q{ - ALTER TABLE deletedborrowers ADD FOREIGN KEY ( sms_provider_id ) REFERENCES sms_providers ( id ) ON UPDATE CASCADE ON DELETE SET NULL; - }); print "Upgrade to $DBversion done (Bug 9021 - Add SMS via email as an alternative to SMS services via SMS::Send drivers)\n"; SetVersion($DBversion); -- 1.7.10.4