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

(-)a/installer/data/mysql/atomicupdate/bug_41663.pl (-1 / +19 lines)
Line 0 Link Here
0
- 
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_success say_info);
3
4
return {
5
    bug_number  => "41663",
6
    description => "Change default values for sysprefs from '' to '0' where type is 'YesNo'",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        $dbh->do(
12
            q{UPDATE systempreferences SET value = 0 WHERE type = 'YesNo' AND value = ''},
13
            undef
14
        );
15
        say $out
16
            "Updated system preference default value for system preferences with empty string value and type 'YesNo'";
17
    }
18
};
19

Return to bug 41663