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