Attachment 34599 Details for Bug 13436 – Bug 13436: (RM followup) university -> academic DB update

[patch] Bug 13436: (RM followup) university -> academic DB update

Bug-13436-RM-followup-university---academic-DB-upd.patch (text/plain), 2.76 KB, created by Tomás Cohen Arazi (tcohen) on 2014-12-19 19:48:54 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2014-12-19 19:48:54 UTC

Size: 2.76 KB

patch

obsolete

>From 281b3225fcbafbb26568f57c2547c4fe13bde017 Mon Sep 17 00:00:00 2001
>From: Tomas Cohen Arazi <tomascohen@gmail.com>
>Date: Fri, 19 Dec 2014 16:45:23 -0300
>Subject: [PATCH] Bug 13436: (RM followup) university -> academic DB update
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
>---
> installer/data/mysql/sysprefs.sql      |  2 +-
> installer/data/mysql/updatedatabase.pl | 14 ++++++++++++++
> 2 files changed, 15 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index c3e308f..db9fd84 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -448,7 +448,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('UsageStatsID', '', NULL, 'This preference is part of Koha but it should not be deleted or updated manually.',  'Free'),
> ('UsageStatsLastUpdateTime', '', NULL, 'This preference is part of Koha but it should not be deleted or updated manually.', 'Free'),
> ('UsageStatsLibraryName', '', NULL, 'The library name to be shown on Hea Koha community website', 'Free'),
>-('UsageStatsLibraryType', 'public', 'public|university', 'The library type to be shown on the Hea Koha community website', 'Choice'),
>+('UsageStatsLibraryType', 'public', 'public|school|academic|research|private|societyAssociation|corporate|government|religiousOrg|subscription', 'The library type to be shown on the Hea Koha community website', 'Choice'),
> ('UsageStatsLibraryUrl', '', NULL, 'The library URL to be shown on Hea Koha community website', 'Free'),
> ('UseAuthoritiesForTracings','1','0','Use authority record numbers for subject tracings instead of heading strings.','YesNo'),
> ('UseBranchTransferLimits','0','','If ON, Koha will will use the rules defined in branch_transfer_limits to decide if an item transfer should be allowed.','YesNo'),
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index a0698ef..2c34148 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -9585,6 +9585,20 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion ($DBversion);
> }
> 
>+$DBversion = "3.19.00.XXX";
>+if ( CheckVersion($DBversion) ) {
>+    $dbh->do("
>+        UPDATE systempreferences
>+        SET options = 'public|school|academic|research|private|societyAssociation|corporate|government|religiousOrg|subscription'
>+        WHERE variable = 'UsageStatsLibraryType'
>+    ");
>+    if ( C4::Context->preference("UsageStatsLibraryType") eq "university" ) {
>+        C4::Context->set_preference("UsageStatsLibraryType", "academic")
>+    }
>+    print "Upgrade to $DBversion done (Bug 13436: Add more options to UsageStatsLibraryType)\n";
>+    SetVersion ($DBversion);
>+}
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>1.9.1

Actions: View | Diff | Splinter Review

Attachments on bug 13436: 34443 | 34500 | 34510 | 34576 | 34599