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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 5516-5522 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5516
    ");
5516
    ");
5517
    $dbh->do('TRUNCATE reserves');
5517
    $dbh->do('TRUNCATE reserves');
5518
    $dbh->do('ALTER TABLE reserves ADD reserve_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST');
5518
    $dbh->do('ALTER TABLE reserves ADD reserve_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST');
5519
    $dbh->do('INSERT INTO reserves SELECT * FROM tmp_reserves WHERE reserve_id > @ai');
5519
    $dbh->do('INSERT INTO reserves SELECT * FROM tmp_reserves WHERE reserve_id > COALESCE(@ai, 0)');
5520
    $dbh->do('DROP TABLE tmp_reserves');
5520
    $dbh->do('DROP TABLE tmp_reserves');
5521
    $dbh->do('COMMIT');
5521
    $dbh->do('COMMIT');
5522
5522
5523
- 

Return to bug 10185