From e54910dfe2b649b724db380218a9e6a5546dd7c8 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 21 Oct 2010 21:50:27 -0400 Subject: [PATCH] bug 3756: remove disused system preference from database This leaves a few system preferences displayed on the local use tab in the syspref editor that should be displayed elsewhere, but all of the ones left are actually in use. Signed-off-by: Galen Charlton --- installer/data/mysql/updatedatabase.pl | 23 +++++++++++++++++++++++ kohaversion.pl | 2 +- 2 files changed, 24 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index af13b51600..cf0c407b83 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -3752,6 +3752,29 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.02.00.001"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do(q{DELETE FROM systempreferences WHERE variable IN ( + 'holdCancelLength', + 'PINESISBN', + 'sortbynonfiling', + 'TemplateEncoding', + 'OPACSubscriptionDisplay', + 'OPACDisplayExtendedSubInfo', + 'OAI-PMH:Set', + 'OAI-PMH:Subset', + 'ILS-DI:AuthorizedIPs', + 'libraryAddress', + 'kohaspsuggest', + 'OrderPdfTemplate', + 'marc', + 'acquisitions', + 'MIME') + } + ); + print "Upgrade to $DBversion done (bug 3756: remove disused system preferences)\n"; + SetVersion ($DBversion); +} =item DropAllForeignKeys($table) diff --git a/kohaversion.pl b/kohaversion.pl index f5e35ac027..b231acdca4 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.02.00.000'; + our $VERSION = '3.02.00.001'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5