Bug 1633: QA follow-up

[koha_gimpoz] / installer / data / mysql / atomicupdate / local_cover_images.pl

diff --git a/installer/data/mysql/atomicupdate/local_cover_images.pl b/installer/data/mysql/atomicupdate/local_cover_images.pl
index a698e7f..6a804fe 100755 (executable)
--- a/installer/data/mysql/atomicupdate/local_cover_images.pl
+++ b/installer/data/mysql/atomicupdate/local_cover_images.pl
@@ -2,9 +2,10 @@
 use strict;
 use warnings;
 use C4::Context;
-my $dbh=C4::Context->dbh;
+my $dbh = C4::Context->dbh;
 
-$dbh->do( q|CREATE TABLE `biblioimages` (
+$dbh->do(
+    q|CREATE TABLE `biblioimages` (
       `imagenumber` int(11) NOT NULL AUTO_INCREMENT,
       `biblionumber` int(11) NOT NULL,
       `mimetype` varchar(15) NOT NULL,
@@ -12,9 +13,18 @@ $dbh->do( q|CREATE TABLE `biblioimages` (
       `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|INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACLocalCoverImages','0','Display local cover images on OPAC search and details pages.','1','YesNo')|);
-$dbh->do( q|INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('LocalCoverImages','0','Display local cover images on intranet search and details pages.','1','YesNo')|);
-$dbh->do( q|INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('AllowMultipleCovers','0','Allow multiple cover images to be attached to each bibliographic record.','1','YesNo')|);
-$dbh->do( q|INSERT INTO permissions (module_bit, code, description) VALUES (13, 'upload_local_cover_images', 'Upload local cover images')|);
+      ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
+);
+$dbh->do(
+q|INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACLocalCoverImages','0','Display local cover images on OPAC search and details pages.','1','YesNo')|
+);
+$dbh->do(
+q|INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('LocalCoverImages','0','Display local cover images on intranet search and details pages.','1','YesNo')|
+);
+$dbh->do(
+q|INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('AllowMultipleCovers','0','Allow multiple cover images to be attached to each bibliographic record.','1','YesNo')|
+);
+$dbh->do(
+q|INSERT INTO permissions (module_bit, code, description) VALUES (13, 'upload_local_cover_images', 'Upload local cover images')|
+);
 print "Upgrade done (Added support for local cover images)\n";