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