Bugzilla – Attachment 166123 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.43 KB, created by
Kyle M Hall (khall)
on 2024-05-03 14:11:20 UTC
(
hide
)
Description:
Bug 35169: update sysprefs.sql
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2024-05-03 14:11:20 UTC
Size:
3.43 KB
patch
obsolete
>From f02d4f8d432e2c25a6e8c9ecb3d34066347c84ff 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 > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > 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 6ca2a0f294a..8d9cf8358d8 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 8c19ccd1272..8768e884255 100644 >--- a/installer/data/mysql/mandatory/sysprefs.sql >+++ b/installer/data/mysql/mandatory/sysprefs.sql >@@ -195,9 +195,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.30.2
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