From cc12f07357cc4a89ef512eb0e9bda1489e0ae8fd Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Sun, 6 Sep 2009 13:54:17 -0400 Subject: [PATCH] DB rev 054->058 055: changed OPACSearchForTitleIn per requests in bug 1934 056: Bug 1172 : Add OPACPatronDetails syspref 057: Bug 2576 : Add OPACFinesTab syspref 058: Added primary keys to language tables Signed-off-by: Galen Charlton --- installer/data/mysql/updatedatabase.pl | 56 +++++++++++++------------- kohaversion.pl | 2 +- 2 files changed, 29 insertions(+), 29 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 5eb487deb6..6d648dd144 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -2614,35 +2614,35 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { print "Upgrade to $DBversion done (bug 1600, bug 3454: add altcontactcountry and B_address2 to borrowers and deletedborrowers)\n"; } -$DBversion = '3.01.00.XXX'; - if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("UPDATE systempreferences set explanation='Enter the HTML that will appear in the \'Search for this title in\' box on the detail page in the OPAC. Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable \'More Searches\' menu.', value='
  • Other Libraries (WorldCat)
    • \n
  • Other Databases (Google Scholar)
    • \n
  • Online Stores (Bookfinder.com)
    • ' WHERE variable='OPACSearchForTitleIn';"); - SetVersion ($DBversion); - print "Upgrade to $DBversion done (changed OPACSearchForTitleIn per requests in bug 1934)\n"; - } - -$DBversion = '3.01.00.XXX'; - if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACPatronDetails','1','If OFF the patron details tab in the OPAC is disabled.','','YesNo');"); - SetVersion ($DBversion); - print "Upgrade to $DBversion done (Bug 1172 : Add OPACPatronDetails syspref)\n"; - } +$DBversion = '3.01.00.055'; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do(qq|UPDATE systempreferences set explanation='Enter the HTML that will appear in the ''Search for this title in'' box on the detail page in the OPAC. Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable ''More Searches'' menu.', value='
  • Other Libraries (WorldCat)
    • \n
  • Other Databases (Google Scholar)
    • \n
  • Online Stores (Bookfinder.com)
    • ' WHERE variable='OPACSearchForTitleIn'|); + SetVersion ($DBversion); + print "Upgrade to $DBversion done (changed OPACSearchForTitleIn per requests in bug 1934)\n"; +} -$DBversion = '3.01.00.XXX'; - if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACFinesTab','1','If OFF the patron fines tab in the OPAC is disabled.','','YesNo');"); - SetVersion ($DBversion); - print "Upgrade to $DBversion done (Bug 2576 : Add OPACFinesTab syspref)\n"; - } - -$DBversion = '3.01.00.XXX'; - if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("ALTER TABLE `language_subtag_registry` ADD `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY;"); - $dbh->do("ALTER TABLE `language_rfc4646_to_iso639` ADD `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY;"); - $dbh->do("ALTER TABLE `language_descriptions` ADD `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY;"); - SetVersion ($DBversion); - print "Upgrade to $DBversion done (Added primary keys to language tables)\n"; - } +$DBversion = '3.01.00.056'; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACPatronDetails','1','If OFF the patron details tab in the OPAC is disabled.','','YesNo');"); + SetVersion ($DBversion); + print "Upgrade to $DBversion done (Bug 1172 : Add OPACPatronDetails syspref)\n"; +} + +$DBversion = '3.01.00.057'; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACFinesTab','1','If OFF the patron fines tab in the OPAC is disabled.','','YesNo');"); + SetVersion ($DBversion); + print "Upgrade to $DBversion done (Bug 2576 : Add OPACFinesTab syspref)\n"; +} + +$DBversion = '3.01.00.058'; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("ALTER TABLE `language_subtag_registry` ADD `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY;"); + $dbh->do("ALTER TABLE `language_rfc4646_to_iso639` ADD `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY;"); + $dbh->do("ALTER TABLE `language_descriptions` ADD `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY;"); + SetVersion ($DBversion); + print "Upgrade to $DBversion done (Added primary keys to language tables)\n"; +} =item DropAllForeignKeys($table) diff --git a/kohaversion.pl b/kohaversion.pl index c942b11ba0..774371a06b 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.01.00.054'; + our $VERSION = '3.01.00.058'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5