From 8e6008db6ad97a7b6bdaeffbd70216bf695a4e54 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 --- 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 09d0cfb..544eacb 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8088,7 +8088,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