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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 23575-23581 if( CheckVersion( $DBversion ) ) { Link Here
23575
        UPDATE items
23575
        UPDATE items
23576
        LEFT JOIN issues ON issues.itemnumber=items.itemnumber
23576
        LEFT JOIN issues ON issues.itemnumber=items.itemnumber
23577
        SET items.onloan=CAST(issues.date_due AS DATE)
23577
        SET items.onloan=CAST(issues.date_due AS DATE)
23578
        WHERE items.onloan IS NULL
23578
        WHERE items.onloan IS NULL AND issues.issue_id IS NOT NULL
23579
    |);
23579
    |);
23580
23580
23581
    NewVersion( $DBversion, 27808, "Adjust items.onloan if needed" );
23581
    NewVersion( $DBversion, 27808, "Adjust items.onloan if needed" );
23582
- 

Return to bug 27808