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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +15 lines)
Lines 7613-7620 CREATE TABLE borrower_debarments ( Link Here
7613
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
7613
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
7614
    });
7614
    });
7615
7615
7616
    # debarments with end date
7616
    $dbh->do(q{
7617
    $dbh->do(q{
7617
INSERT INTO borrower_debarments ( borrowernumber, expiration, comment ) SELECT borrowernumber, debarred, debarredcomment FROM borrowers WHERE debarred IS NOT NULL
7618
INSERT INTO borrower_debarments ( borrowernumber, expiration, comment ) SELECT borrowernumber, debarred, debarredcomment FROM borrowers WHERE debarred IS NOT NULL AND debarred <> '9999-12-31'
7619
    });
7620
    # debarments with no end date
7621
    $dbh->do(q{
7622
INSERT INTO borrower_debarments ( borrowernumber, comment ) SELECT borrowernumber, debarredcomment FROM borrowers WHERE debarred = '9999-12-31'
7618
    });
7623
    });
7619
7624
7620
    $dbh->do(q{
7625
    $dbh->do(q{
Lines 7953-7958 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
7953
    SetVersion($DBversion);
7958
    SetVersion($DBversion);
7954
}
7959
}
7955
7960
7961
$DBversion = "3.15.00.XXX";
7962
if ( CheckVersion($DBversion) ) {
7963
    $dbh->do(q{
7964
        UPDATE borrower_debarments SET debarred = NULL WHERE debarred = '9999-12-31'
7965
    });
7966
    print "Upgrade to $DBversion done (Bug 2720 - correct debarments with 9999-12-31)\n";
7967
    SetVersion($DBversion);
7968
}
7969
7956
=head1 FUNCTIONS
7970
=head1 FUNCTIONS
7957
7971
7958
=head2 TableExists($table)
7972
=head2 TableExists($table)
7959
- 

Return to bug 2720