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

(-)a/installer/data/mysql/atomicupdate/bug_10215.perl (-1 / +3 lines)
Lines 4-9 if ( CheckVersion($DBversion) ) { Link Here
4 
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE opacnote opacnote LONGTEXT NULL});
 4 
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE opacnote opacnote LONGTEXT NULL});
5 
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE librariannote librariannote LONGTEXT NULL});
 5 
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE librariannote librariannote LONGTEXT NULL});
6 

          6
          

        

            

              
              
              7
              
    $dbh->do(q{UPDATE subscriptionhistory SET opacnote = NULL WHERE opacnote = ''});

            

            

              8
              
    $dbh->do(q{UPDATE subscriptionhistory SET librariannote = NULL WHERE librariannote = ''});

            

            

              9
              

            

        

          7
          
    SetVersion ($DBversion);

          10
          
    SetVersion ($DBversion);

        

        

          8
          
    print "Upgrade to $DBversion done (Bug 10215 - Increase the size of opacnote and librariannote for table subscriptionhistory)\n";

          11
          
    print "Upgrade to $DBversion done (Bug 10215 - Increase the size of opacnote and librariannote for table subscriptionhistory)\n";

        

        

          9
          
}

          12
          
}

        

            

              10
              
- 

              
              
            






  

  Return to bug 10215