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

(-)a/installer/data/mysql/atomicupdate/bug_27808.perl (-2 / +1 lines)
Lines 5-11 if( CheckVersion( $DBversion ) ) { Link Here
5
        UPDATE items
5
        UPDATE items
6
        LEFT JOIN issues ON issues.itemnumber=items.itemnumber
6
        LEFT JOIN issues ON issues.itemnumber=items.itemnumber
7
        SET items.onloan=CAST(issues.date_due AS DATE)
7
        SET items.onloan=CAST(issues.date_due AS DATE)
8
        WHERE items.onloan IS NULL
8
        WHERE items.onloan IS NULL AND issues.issue_id IS NOT NULL
9
    |);
9
    |);
10
10
11
    NewVersion( $DBversion, 27808, "Adjust items.onloan if needed");
11
    NewVersion( $DBversion, 27808, "Adjust items.onloan if needed");
12
- 

Return to bug 27808