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

(-)a/installer/data/mysql/atomicupdate/bug_22824.perl (-1 / +16 lines)
Line 0 Link Here
0
- 
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        UPDATE systempreferences SET type="Free" WHERE variable="OverDriveClientSecret" OR variable="RecordedBooksClientSecret"
5
    });
6
    $dbh->do(q{
7
        UPDATE systempreferences SET type="integer" WHERE variable="UsageStats"
8
    });
9
    $dbh->do(q{
10
        UPDATE systempreferences
11
        SET value="0"
12
        WHERE ( ( type = "YesNo" AND ( value NOT IN ( "1", "0" ) OR value IS NULL ) ) )
13
    });
14
15
    NewVersion( $DBversion, 22824, "Update syspref values for YesNo");
16
}

Return to bug 22824