From be96f6fe2a8885287764bcfd4c4ccac67f3cd0bc Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Fri, 28 Mar 2014 10:09:15 +0100 Subject: [PATCH] Bug 7290: Fix constraint name in updatedatabase.pl Set the same constraint name as in kohastructure.sql Signed-off-by: Paola Rossi --- installer/data/mysql/updatedatabase.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 18d4b22..3cc1cff 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8582,7 +8582,7 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { $dbh->do(" ALTER TABLE aqorders ADD COLUMN branch VARCHAR(10) DEFAULT NULL, - ADD CONSTRAINT aqorders_ibfk_3 FOREIGN KEY (branch) + ADD CONSTRAINT aqorders_branch FOREIGN KEY (branch) REFERENCES branches (branchcode) ON UPDATE CASCADE ON DELETE SET NULL "); $dbh->do(" -- 1.7.10.4