From 32ac3f673ee1fdb7f558d1c7abb942785a8d3f57 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Mon, 26 Mar 2012 14:51:43 +0200 Subject: [PATCH] Bug 7470 follow-up DBRev + removing ` --- installer/data/mysql/updatedatabase.pl | 26 +++++++++++++------------- kohaversion.pl | 2 +- 2 files changed, 14 insertions(+), 14 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index e158f1adba..9225c32a3e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -5062,27 +5062,27 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { $DBversion = "3.07.00.039"; if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do( qq{INSERT IGNORE INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque_url_js','','Url for Babeltheque javascript (e.g. http://www.babeltheque.com/bw_XX.js','','Free')} ); - $dbh->do( qq{CREATE TABLE IF NOT EXISTS `social_data` - ( `isbn` VARCHAR(30), - `num_critics` INT, - `num_critics_pro` INT, - `num_quotations` INT, - `num_videos` INT, - `score_avg` DECIMAL(5,2), - `num_scores` INT, - PRIMARY KEY (`isbn`) + $dbh->do( qq{INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('Babeltheque_url_js','','Url for Babeltheque javascript (e.g. http://www.babeltheque.com/bw_XX.js','','Free')} ); + $dbh->do( qq{CREATE TABLE IF NOT EXISTS social_data + ( isbn VARCHAR(30), + num_critics INT, + num_critics_pro INT, + num_quotations INT, + num_videos INT, + score_avg DECIMAL(5,2), + num_scores INT, + PRIMARY KEY (isbn) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 } ); - $dbh->do( qq{INSERT IGNORE INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('Babeltheque_url_update', '', 'Url for Babeltheque update (E.G. http://www.babeltheque.com/.../file.csv.bz2)', '', 'Free')} ); + $dbh->do( qq{INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('Babeltheque_url_update', '', 'Url for Babeltheque update (E.G. http://www.babeltheque.com/.../file.csv.bz2)', '', 'Free')} ); print "Upgrade to $DBversion done (added syspref and table for babeltheque (Babeltheque_url_js, babeltheque))\n"; SetVersion($DBversion); } $DBversion = "3.07.00.040"; if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do( qq{INSERT IGNORE INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SocialNetworks','1','Enable/Disable social networks links in opac detail','','YesNo')} ); - print "Upgrade to $DBversion done (added syspref Social_networks)\n"; + $dbh->do( qq{INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('SocialNetworks','0','Enable/Disable social networks links in opac detail','','YesNo')} ); + print "Upgrade to $DBversion done (added syspref SocialNetworks, to display facebook/ggl+ and other buttons)\n"; SetVersion($DBversion); } diff --git a/kohaversion.pl b/kohaversion.pl index e49170eef9..fed38b0157 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -16,7 +16,7 @@ the kohaversion is divided in 4 parts : use strict; sub kohaversion { - our $VERSION = '3.07.00.038'; + our $VERSION = '3.07.00.040'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.11.0