From 828a90dafd2fa529dc0fb630533bd59e562ebe2c Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 20 Feb 2014 12:40:35 +0100 Subject: [PATCH] Bug 5377: 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 --- 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 2768426..792b972 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -7967,12 +7967,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 ) ) "); -- 1.7.10.4