From 99fef530a25d02c8b1acdc27e638458aaf439c37 Mon Sep 17 00:00:00 2001 From: Jared Camins-Esakov Date: Fri, 9 Mar 2012 07:24:43 -0500 Subject: [PATCH] Bug 7587: Fix table name for biblioimages table Content-Type: text/plain; charset="UTF-8" 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. --- installer/data/mysql/kohastructure.sql | 6 +++--- installer/data/mysql/updatedatabase.pl | 19 +++++++++++++++++++ 2 files changed, 22 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 06eded1..4f2e424 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4884,6 +4884,25 @@ Date due: <>
SetVersion($DBversion); } +$DBversion = "3.07.00.XXX"; +if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { + $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| + ); + $dbh->do( q|DROP TABLE bibliocoverimage| ); + 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.2.5