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

(-)a/installer/data/mysql/updatedatabase.pl (-3 / +13 lines)
Lines 18037-18044 if( CheckVersion( $DBversion ) ) { Link Here
18037
18037
18038
$DBversion = '18.12.00.049';
18038
$DBversion = '18.12.00.049';
18039
if( CheckVersion( $DBversion ) ) {
18039
if( CheckVersion( $DBversion ) ) {
18040
    $dbh->do( "ALTER TABLE borrowers ADD COLUMN flgAnonymized tinyint DEFAULT 0" ) if !column_exists('borrowers', 'flgAnonymized');
18040
18041
    $dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN flgAnonymized tinyint DEFAULT 0" ) if !column_exists('deletedborrowers', 'flgAnonymized');
18041
    $dbh->do(q{
18042
        ALTER TABLE borrowers
18043
            ADD COLUMN flgAnonymized tinyint DEFAULT 0
18044
            AFTER overdrive_auth_token
18045
    }) if !column_exists('borrowers', 'flgAnonymized');
18046
18047
    $dbh->do(q{
18048
        ALTER TABLE deletedborrowers
18049
            ADD COLUMN flgAnonymized tinyint DEFAULT 0
18050
            AFTER overdrive_auth_token
18051
    }) if !column_exists('deletedborrowers', 'flgAnonymized');
18052
18042
    SetVersion( $DBversion );
18053
    SetVersion( $DBversion );
18043
    print "Upgrade to $DBversion done (Bug 21336 - Add field flgAnonymized)\n";
18054
    print "Upgrade to $DBversion done (Bug 21336 - Add field flgAnonymized)\n";
18044
}
18055
}
18045
- 

Return to bug 21336