Bugzilla – Attachment 140270 Details for
Bug 31333
Add the ability to limit purchase suggestions by patron category
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 31333: Database changes
Bug-31333-Database-changes.patch (text/plain), 2.59 KB, created by
Katrin Fischer
on 2022-09-07 11:33:03 UTC
(
hide
)
Description:
Bug 31333: Database changes
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2022-09-07 11:33:03 UTC
Size:
2.59 KB
patch
obsolete
>From f4cb21b0383e2c6997dbf7380bab407cf5e49fae Mon Sep 17 00:00:00 2001 >From: Alex Buckley <alexbuckley@catalyst.net.nz> >Date: Tue, 9 Aug 2022 02:01:57 +0000 >Subject: [PATCH] Bug 31333: Database changes > >Sponsored-by: Catalyst IT, New Zealand > >Signed-off-by: Owen Leonard <oleonard@myacpl.org> > >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > ...add_suggestionPatronCategoryExceptions_syspref.pl | 12 ++++++++++++ > installer/data/mysql/mandatory/sysprefs.sql | 1 + > 2 files changed, 13 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_31333-add_suggestionPatronCategoryExceptions_syspref.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_31333-add_suggestionPatronCategoryExceptions_syspref.pl b/installer/data/mysql/atomicupdate/bug_31333-add_suggestionPatronCategoryExceptions_syspref.pl >new file mode 100755 >index 0000000000..ba4a1e18cd >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_31333-add_suggestionPatronCategoryExceptions_syspref.pl >@@ -0,0 +1,12 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "31333", >+ description => "Add new suggestionPatronCategoryExceptions system preference", >+ up => sub { >+ my ($args) = @_; >+ my ($dbh, $out) = @$args{qw(dbh out)}; >+ >+ $dbh->do(q{INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('suggestionPatronCategoryExceptions', '', '', 'List the patron categories not affected by suggestion system preference if on', 'Free') }); >+ }, >+}; >diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql >index 9a5cb2e0a8..212d646589 100644 >--- a/installer/data/mysql/mandatory/sysprefs.sql >+++ b/installer/data/mysql/mandatory/sysprefs.sql >@@ -679,6 +679,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('SubscriptionHistory','simplified','simplified|full','Define the display preference for serials issue history in OPAC','Choice'), > ('SubscriptionLog','1',NULL,'If ON, enables subscriptions log','YesNo'), > ('suggestion','1','','If ON, enables patron suggestions feature in OPAC','YesNo'), >+('suggestionPatronCategoryExceptions', '', '', 'List the patron categories not affected by suggestion system preference if on', 'Free'), > ('SuspendHoldsIntranet','1','Allow holds to be suspended from the intranet.',NULL,'YesNo'), > ('SuspendHoldsOpac','1','Allow holds to be suspended from the OPAC.',NULL,'YesNo'), > ('SuspensionsCalendar','noSuspensionsWhenClosed','ignoreCalendar|noSuspensionsWhenClosed','Specify whether to use the Calendar in calculating suspension expiration','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 31333
:
139112
|
139113
|
139114
|
139165
|
139897
|
139898
|
139935
|
139936
|
140169
|
140170
|
140171
|
140172
|
140173
|
140174
| 140270 |
140271
|
140272
|
140273
|
140274
|
140275
|
140276
|
141392
|
141393