From 9ee4f41555059cd0f7b7b32ac7c7219d37e3939f Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 20 Feb 2014 12:40:35 +0100 Subject: [PATCH] Bug 5377: (follow-up) there is no index on deletedbiblioitems.issn This patch removes a trailing space and remove the issn index deletion (it does not exist on deletedbiblioitems). Signed-off-by: Jonathan Druart Signed-off-by: Galen Charlton --- installer/data/mysql/updatedatabase.pl | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 7a01014120..597174ba93 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8427,12 +8427,11 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { "); $dbh->do("ALTER TABLE deletedbiblioitems DROP INDEX isbn"); - $dbh->do("ALTER TABLE deletedbiblioitems DROP INDEX issn"); $dbh->do("ALTER TABLE deletedbiblioitems CHANGE isbn isbn MEDIUMTEXT NULL DEFAULT NULL, CHANGE issn issn MEDIUMTEXT NULL DEFAULT NULL "); - $dbh->do("ALTER TABLE deletedbiblioitems + $dbh->do("ALTER TABLE deletedbiblioitems ADD INDEX isbn ( isbn ( 255 ) ) "); -- 2.20.1