Attachment 32030 Details for Bug 11926 – Bug 11926: DB changes

[patch] Bug 11926: DB changes

Bug-11926-DB-changes.patch (text/plain), 3.69 KB, created by Jonathan Druart on 2014-10-06 21:45:01 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2014-10-06 21:45:01 UTC

Size: 3.69 KB

patch

obsolete

>From e2dd32faeaff444fd2933f0415078c6b9a625d4e Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@biblibre.com>
>Date: Mon, 6 Oct 2014 23:42:19 +0200
>Subject: [PATCH] Bug 11926: DB changes
>
>This patch adds the syspref in the database.
>---
> installer/data/mysql/sysprefs.sql      |  7 +++++++
> installer/data/mysql/updatedatabase.pl | 18 ++++++++++++++++++
> 2 files changed, 25 insertions(+)
>
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index b06b163..db6cd80 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -424,6 +424,13 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('UpdateTotalIssuesOnCirc','0',NULL,'Whether to update the totalissues field in the biblio on each circ.','YesNo'),
> ('uppercasesurnames','0',NULL,'If ON, surnames are converted to upper case in patron entry form','YesNo'),
> ('URLLinkText','',NULL,'Text to display as the link anchor in the OPAC','free'),
>+('UsageStatsCountry', '', 'The country where your library is to show on hea Koha community website', NULL, 'YesNo'),
>+('UsageStatsID', '', 'This pref is part of Koha but it should not be deleted or updated manually.', '', 'Free'),
>+('UsageStatsLastUpdateTime', '', 'This pref is part of Koha but it should not be deleted or updated manually.', '', 'Free'),
>+('UsageStatsLibraryName', '', 'The library name to show on hea Koha community website', NULL, 'Free'),
>+('UsageStatsLibraryType', 'public', 'public|university', 'The library type to show on hea Koha community website', NULL, 'Choice'),
>+('UsageStatsLibraryUrl', '', 'The library url to show on hea Koha community website', NULL, 'Free'),
>+('UsageStatsShare', 0, 'Share data volumetry with Koha community (HEA).', NULL, 'YesNo'),
> ('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'),
> ('UseControlNumber','0','','If ON, record control number (w subfields) and control number (001) are used for linking of bibliographic records.','YesNo'),
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 6ea5911..10fcd86 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -8781,6 +8781,24 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = "3.17.00.XXX";
>+if ( CheckVersion($DBversion) ) {
>+    $dbh->do(
>+        q{
>+       INSERT INTO systempreferences (variable, value, options, explanation, type )
>+       VALUES
>+        ('UsageStatsCountry', '', NULL, 'The country where your library is to show on hea Koha community website', 'YesNo'),
>+        ('UsageStatsID', '', NULL, 'This pref is part of Koha but it should not be deleted or updated manually.',  'Free'),
>+        ('UsageStatsLastUpdateTime', '', NULL, 'This pref is part of Koha but it should not be deleted or updated manually.', 'Free'),
>+        ('UsageStatsLibraryName', '', NULL, 'The library name to show on hea Koha community website', 'Free'),
>+        ('UsageStatsLibraryType', 'public', 'public|university', 'The library type to show on hea Koha community website', 'Choice'),
>+        ('UsageStatsLibraryUrl', '', NULL, 'The library url to show on hea Koha community website', 'Free'),
>+        ('UsageStatsShare', 0, NULL, 'Share data volumetry with Koha community (HEA).', 'YesNo')
>+    });
>+    print "Upgrade to $DBversion done (Bug 11926: Add UsageStats systempreferences (HEA))\n";
>+    SetVersion($DBversion);
>+}
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>2.1.0

Actions: View | Diff | Splinter Review

Attachments on bug 11926: 26203 | 26346 | 26352 | 31369 | 31370 | 31373 | 32024 | 32025 | 32026 | 32027 | 32028 | 32029 | 32030 | 32262 | 32263 | 32264 | 32265 | 32266 | 32267 | 32268 | 32455 | 32456 | 32457 | 32458 | 32459 | 32460 | 32461 | 32462 | 32463 | 32464 | 32465 | 32466 | 32467 | 32468 | 32469 | 32470 | 32471 | 32472 | 32582