|
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 |
- |
|
|