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