From 073de2c2eae30f71b612b69e1622d8d01c850533 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 6 Sep 2024 09:58:18 +0000 Subject: [PATCH] Bug 23685: (follow-up) Dbrev for new preferences Test plan: Run updatedatabase. Signed-off-by: Marcel de Rooy Signed-off-by: Nick Clemens Signed-off-by: Katrin Fischer --- installer/data/mysql/atomicupdate/bug23685.pl | 21 +++++++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 2 ++ 2 files changed, 23 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug23685.pl diff --git a/installer/data/mysql/atomicupdate/bug23685.pl b/installer/data/mysql/atomicupdate/bug23685.pl new file mode 100755 index 0000000000..f17fb3dad0 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug23685.pl @@ -0,0 +1,21 @@ +use Modern::Perl; +use Koha::Installer::Output qw(say_warning say_failure say_success say_info); + +return { + bug_number => "23685", + description => "Add prefs ReportsExportFormatODS and ReportsExportLimit", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + # sysprefs + $dbh->do( + q{ + INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type ) VALUES + ('ReportsExportFormatODS',1,NULL,'Show ODS download in Reports','YesNo'), + ('ReportsExportLimit',NULL,NULL,'Limit for report downloads','Integer'); + } + ); + say $out "Added new system preferences: ReportsExportFormatODS and ReportsExportLimit"; + }, +}; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index 20d11d36ab..925c1a4de0 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -655,6 +655,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('RenewalSendNotice','0','',NULL,'YesNo'), ('RenewSerialAddsSuggestion','0',NULL,'If ON, adds a new suggestion at serial subscription renewal','YesNo'), ('RentalFeesCheckoutConfirmation', '0', NULL , 'Allow user to confirm when checking out an item with rental fees.', 'YesNo'), +('ReportsExportFormatODS',1,NULL,'Show ODS download in Reports','YesNo'), +('ReportsExportLimit',NULL,NULL,'Limit for report downloads','Integer'), ('ReplytoDefault','',NULL,'Use this email address as the replyto in emails','Free'), ('ReportsLog','0',NULL,'If ON, log information about reports.','YesNo'), ('RequireCashRegister','0',NULL,'Require a cash register when collecting a payment','YesNo'), -- 2.39.5