Bugzilla – Attachment 162611 Details for
Bug 35169
Make long overdue patron category options configurable in interface
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 35169: update sysprefs.sql
Bug-35169-update-sysprefssql.patch (text/plain), 3.38 KB, created by
Matthias Le Gac
on 2024-02-29 17:12:42 UTC
(
hide
)
Description:
Bug 35169: update sysprefs.sql
Filename:
MIME Type:
Creator:
Matthias Le Gac
Created:
2024-02-29 17:12:42 UTC
Size:
3.38 KB
patch
obsolete
>From 3b1ce3df02671e2378aead0ff2039c7a000c24c1 Mon Sep 17 00:00:00 2001 >From: Matthias Le Gac <matthias.le-gac@inlibro.com> >Date: Thu, 29 Feb 2024 12:08:00 -0500 >Subject: [PATCH] Bug 35169: update sysprefs.sql > >--- > installer/data/mysql/atomicupdate/bug_35169.pl | 2 +- > installer/data/mysql/mandatory/sysprefs.sql | 2 ++ > 2 files changed, 3 insertions(+), 1 deletion(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_35169.pl b/installer/data/mysql/atomicupdate/bug_35169.pl >index 6ca2a0f294..8d9cf8358d 100755 >--- a/installer/data/mysql/atomicupdate/bug_35169.pl >+++ b/installer/data/mysql/atomicupdate/bug_35169.pl >@@ -10,7 +10,7 @@ return { > # Do you stuffs here > $dbh->do( > q{ >- INSERT INTO systempreferences (variable, value, options, explanation, type) VALUES >+ INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES > ('DefaultLongOverdueBorrowerCategories', '', NULL, NULL, NULL), > ('DefaultLongOverdueSkipBorrowerCategories', '', NULL, NULL, NULL); > } >diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql >index 669074aa50..2a15be971c 100644 >--- a/installer/data/mysql/mandatory/sysprefs.sql >+++ b/installer/data/mysql/mandatory/sysprefs.sql >@@ -194,9 +194,11 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('DefaultHoldExpirationdateUnitOfTime','days','days|months|years','Which unit of time is used when setting the default expiration date. ','choice'), > ('DefaultHoldPickupLocation','loggedinlibrary','loggedinlibrary|homebranch|holdingbranch','Which branch should a hold pickup location default to. ','choice'), > ('DefaultLanguageField008','','','Fill in the default language for field 008 Range 35-37 of MARC21 records (e.g. eng, nor, ger, see <a href=\"http://www.loc.gov/marc/languages/language_code.html\">MARC Code List for Languages</a>)','Free'), >+('DefaultLongOverdueBorrowerCategories', '', NULL, "Set the borrower categories that will be listed when longoverdue cronjob is executed", 'choice'), > ('DefaultLongOverdueChargeValue', '', NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer'), > ('DefaultLongOverdueDays', '', NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer'), > ('DefaultLongOverdueLostValue', '', NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer'), >+('DefaultLongOverdueSkipBorrowerCategories', '', NULL, "Set the borrower categories that will not be listed when longoverdue cronjob is executed", 'choice'), > ('DefaultLongOverdueSkipLostStatuses', '', NULL, 'Skip these lost statuses by default in longoverdue.pl', 'Free'), > ('DefaultPatronSearchFields', 'firstname|middle_name|surname|othernames|cardnumber|userid',NULL,'Pipe separated list defining the default fields to be used during a patron search using the "standard" option. If empty Koha will default to "firstname|surname|othernames|cardnumber|userid". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page.','free'), > ('DefaultPatronSearchMethod','starts_with','Choose which search method to use by default when searching with PatronAutoComplete','starts_with|contains','Choice'), >-- >2.34.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 35169
:
162340
|
162345
|
162346
|
162611
|
162667
|
162688
|
163008
|
166121
|
166122
|
166123
|
166124
|
166125
|
166126
|
166127
|
166256