From 688999790fdf1f5d49686fc97decb34cbcef6fdd 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 acf1d15..e780039 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8476,7 +8476,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