View | Details | Raw Unified | Return to bug 23685
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug23685.pl (+21 lines)
Line 0 Link Here
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
3
4
return {
5
    bug_number  => "23685",
6
    description => "Add prefs ReportsExportFormatODS and ReportsExportLimit",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        # sysprefs
12
        $dbh->do(
13
            q{
14
            INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type ) VALUES
15
            ('ReportsExportFormatODS',1,NULL,'Show ODS download in Reports','YesNo'),
16
            ('ReportsExportLimit',NULL,NULL,'Limit for report downloads','Integer');
17
        }
18
        );
19
        say $out "Added new system preferences: ReportsExportFormatODS and ReportsExportLimit";
20
    },
21
};
(-)a/installer/data/mysql/mandatory/sysprefs.sql (-1 / +2 lines)
Lines 655-660 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
655
('RenewalSendNotice','0','',NULL,'YesNo'),
655
('RenewalSendNotice','0','',NULL,'YesNo'),
656
('RenewSerialAddsSuggestion','0',NULL,'If ON, adds a new suggestion at serial subscription renewal','YesNo'),
656
('RenewSerialAddsSuggestion','0',NULL,'If ON, adds a new suggestion at serial subscription renewal','YesNo'),
657
('RentalFeesCheckoutConfirmation', '0', NULL , 'Allow user to confirm when checking out an item with rental fees.', 'YesNo'),
657
('RentalFeesCheckoutConfirmation', '0', NULL , 'Allow user to confirm when checking out an item with rental fees.', 'YesNo'),
658
('ReportsExportFormatODS',1,NULL,'Show ODS download in Reports','YesNo'),
659
('ReportsExportLimit',NULL,NULL,'Limit for report downloads','Integer'),
658
('ReplytoDefault','',NULL,'Use this email address as the replyto in emails','Free'),
660
('ReplytoDefault','',NULL,'Use this email address as the replyto in emails','Free'),
659
('ReportsLog','0',NULL,'If ON, log information about reports.','YesNo'),
661
('ReportsLog','0',NULL,'If ON, log information about reports.','YesNo'),
660
('RequireCashRegister','0',NULL,'Require a cash register when collecting a payment','YesNo'),
662
('RequireCashRegister','0',NULL,'Require a cash register when collecting a payment','YesNo'),
661
- 

Return to bug 23685