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

(-)a/installer/data/mysql/atomicupdate/bug_28872_update_log_values.pl (-1 / +16 lines)
Line 0 Link Here
0
- 
1
use Modern::Perl;
2
3
{
4
    bug_number => "28872",
5
    description => "update values from on and off to 1 and 0",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        # Do you stuffs here
10
        $dbh->do(q{update systempreferences set value=1 where variable in ('AcquisitionLog', 'NewsLog', 'NoticesLog') and value='on'});
11
        $dbh->do(q{update systempreferences set value=0 where variable in ('AcquisitionLog', 'NewsLog', 'NoticesLog') and value='off'});
12
13
        # Print useful stuff here
14
        say $out "Update is going well so far";
15
    },
16
}

Return to bug 28872