Attachment 118518 Details for Bug 21549 – Bug 21549: Database revision for new preference

[patch] Bug 21549: Database revision for new preference

Bug-21549-Database-revision-for-new-preference.patch (text/plain), 3.74 KB, created by Nick Clemens (kidclamp) on 2021-03-19 12:04:40 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2021-03-19 12:04:40 UTC

Size: 3.74 KB

patch

obsolete

>From 7bd086d66d47efebd2c7ee347c5610d98a8d47a3 Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Mon, 10 Aug 2020 13:37:42 +0000
>Subject: [PATCH] Bug 21549: Database revision for new preference
>
>Introducing LockExpiredDelay.
>
>Test plan:
>Run upgrade. Check syspref.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>
>Signed-off-by: Michal Denar <black23@gmail.com>
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> installer/data/mysql/atomicupdate/bug_21549.perl                 | 9 +++++++++
> installer/data/mysql/mandatory/sysprefs.sql                      | 1 +
> .../intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref | 6 ++++++
> 3 files changed, 16 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_21549.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_21549.perl b/installer/data/mysql/atomicupdate/bug_21549.perl
>new file mode 100644
>index 0000000000..ee18dbb96c
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_21549.perl
>@@ -0,0 +1,9 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do(q|
>+        INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` )
>+        VALUES ('LockExpiredDelay','','','Delay for locking expired patrons (empty means no locking)','Integer')
>+    |);
>+
>+    NewVersion( $DBversion, 21549, "Add pref LockExpiredDelay");
>+}
>diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql
>index 1034313061..a3b350c77d 100644
>--- a/installer/data/mysql/mandatory/sysprefs.sql
>+++ b/installer/data/mysql/mandatory/sysprefs.sql
>@@ -312,6 +312,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('LocalHoldsPriority',  '0', NULL,  'Enables the LocalHoldsPriority feature',  'YesNo'),
> ('LocalHoldsPriorityItemControl',  'holdingbranch',  'holdingbranch|homebranch',  'decides if the feature operates using the item''s home or holding library.',  'Choice'),
> ('LocalHoldsPriorityPatronControl',  'PickupLibrary',  'HomeLibrary|PickupLibrary',  'decides if the feature operates using the library set as the patron''s home library, or the library set as the pickup library for the given hold.',  'Choice'),
>+('LockExpiredDelay','','','Delay for locking expired patrons (empty means no locking)','Integer'),
> ('makePreviousSerialAvailable','0','','make previous serial automatically available when collecting a new serial. Please note that the item-level_itypes syspref must be set to specific item.','YesNo'),
> ('Mana','2',NULL,'request to Mana Webservice. Mana centralize common information between other Koha to facilitate the creation of new subscriptions, vendors, report queries etc... You can search, share, import and comment the content of Mana.','Choice'),
> ('ManInvInNoissuesCharge','1',NULL,'MANUAL_INV charges block checkouts (added to noissuescharge).','YesNo'),
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref
>index e599773fa2..68b6237ba2 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref
>@@ -100,6 +100,12 @@ Patrons:
>                1: Allow patrons
>                0: Allow only staff
>          - "to allow/disallow auto-renewal for account. If allowed a patron will be able to update their own account to allow/disallow auto-renewal."
>+     -
>+         - Lock expired patrons after
>+         - pref: LockExpiredDelay
>+           class: integer
>+         - days. Leave empty to disable this behavior.
>+
>     Membership expiry:
>      -
>          - When renewing borrowers, base the new expiry date on
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 21549: 108000 | 108001 | 111480 | 111481 | 113914 | 113915 | 118493 | 118494 | 118495 | 118496 | 118517 | 118518 | 118519 | 118520 | 118521 | 119457 | 119458 | 119459 | 119460 | 119461 | 119462 | 119463 | 119464 | 119525 | 119526 | 119527