From e461f69ce54a2c01dcd50fd23098da185b79597c Mon Sep 17 00:00:00 2001 From: Jared Camins-Esakov Date: Fri, 9 Mar 2012 07:24:43 -0500 Subject: [PATCH] [SIGNED-OFF] Bug 7587: Fix table name for biblioimages table The kohastructure.sql file had the wrong name for the biblioimages table, which broke the local cover images feature for new installations, and filled the log with error messages. Signed-off-by: Katrin Fischer 1) Checked a broken installation with wrong table name. 2) Checked for a new installation Feature works perfectly. http://bugs.koha-community.org/show_bug.cgi?id=7487 --- installer/data/mysql/kohastructure.sql | 6 +++--- installer/data/mysql/updatedatabase.pl | 18 ++++++++++++++++++ 2 files changed, 21 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 9dbd032..153e17b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2695,12 +2695,12 @@ CREATE TABLE `fieldmapping` ( -- koha to keyword mapping ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- --- Table structure for table `bibliocoverimage` +-- Table structure for table `biblioimages` -- -DROP TABLE IF EXISTS `bibliocoverimage`; +DROP TABLE IF EXISTS `biblioimages`; -CREATE TABLE `bibliocoverimage` ( +CREATE TABLE `biblioimages` ( `imagenumber` int(11) NOT NULL AUTO_INCREMENT, `biblionumber` int(11) NOT NULL, `mimetype` varchar(15) NOT NULL, diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index b844560..72cbedf 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4892,6 +4892,24 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.07.00.XXX"; +if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { + $dbh->do( q|DROP TABLE bibliocoverimage;| ); + $dbh->do( + q|CREATE TABLE biblioimages ( + imagenumber int(11) NOT NULL AUTO_INCREMENT, + biblionumber int(11) NOT NULL, + mimetype varchar(15) NOT NULL, + imagefile mediumblob NOT NULL, + thumbnail mediumblob NOT NULL, + PRIMARY KEY (imagenumber), + CONSTRAINT bibliocoverimage_fk1 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE + ) ENGINE=InnoDB DEFAULT CHARSET=utf8;| + ); + print "Upgrade to $DBversion done (Correct table name for local cover images [please disregard any error messages])\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 DropAllForeignKeys($table) -- 1.7.5.4