From 4e6baf61858bd22d91d50ad5f176f04242a23370 Mon Sep 17 00:00:00 2001 From: Brendan Gallagher Date: Wed, 27 Apr 2016 02:38:35 +0000 Subject: [PATCH] Forgot extra $dbh Signed-off-by: Brendan Gallagher --- installer/data/mysql/updatedatabase.pl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 1f1c5a0d60..1e473df0fd 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -12350,7 +12350,9 @@ $dbh->do(q{ DROP FOREIGN KEY emfk_vendor, DROP FOREIGN KEY emfk_edi_acct, DROP FOREIGN KEY emfk_basketno; + }); +$dbh->(q{ ALTER TABLE edifact_messages ADD CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE, -- 2.20.1