|
Lines 5486-5498
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
Link Here
|
| 5486 |
constrainttype, branchcode, notificationdate, |
5486 |
constrainttype, branchcode, notificationdate, |
| 5487 |
reminderdate, cancellationdate, reservenotes, |
5487 |
reminderdate, cancellationdate, reservenotes, |
| 5488 |
priority, found, timestamp, itemnumber, |
5488 |
priority, found, timestamp, itemnumber, |
| 5489 |
waitingdate, expirationdate, lowestPriority |
5489 |
waitingdate, expirationdate, lowestPriority, |
|
|
5490 |
suspend, suspend_until |
| 5490 |
) SELECT |
5491 |
) SELECT |
| 5491 |
borrowernumber, reservedate, biblionumber, |
5492 |
borrowernumber, reservedate, biblionumber, |
| 5492 |
constrainttype, branchcode, notificationdate, |
5493 |
constrainttype, branchcode, notificationdate, |
| 5493 |
reminderdate, cancellationdate, reservenotes, |
5494 |
reminderdate, cancellationdate, reservenotes, |
| 5494 |
priority, found, timestamp, itemnumber, |
5495 |
priority, found, timestamp, itemnumber, |
| 5495 |
waitingdate, expirationdate, lowestPriority |
5496 |
waitingdate, expirationdate, lowestPriority, |
|
|
5497 |
suspend, suspend_until |
| 5496 |
FROM old_reserves ORDER BY reservedate |
5498 |
FROM old_reserves ORDER BY reservedate |
| 5497 |
"); |
5499 |
"); |
| 5498 |
$dbh->do('SET @ai = ( SELECT MAX( reserve_id ) FROM tmp_reserves )'); |
5500 |
$dbh->do('SET @ai = ( SELECT MAX( reserve_id ) FROM tmp_reserves )'); |
|
Lines 5505-5517
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
Link Here
|
| 5505 |
constrainttype, branchcode, notificationdate, |
5507 |
constrainttype, branchcode, notificationdate, |
| 5506 |
reminderdate, cancellationdate, reservenotes, |
5508 |
reminderdate, cancellationdate, reservenotes, |
| 5507 |
priority, found, timestamp, itemnumber, |
5509 |
priority, found, timestamp, itemnumber, |
| 5508 |
waitingdate, expirationdate, lowestPriority |
5510 |
waitingdate, expirationdate, lowestPriority, |
|
|
5511 |
suspend, suspend_until |
| 5509 |
) SELECT |
5512 |
) SELECT |
| 5510 |
borrowernumber, reservedate, biblionumber, |
5513 |
borrowernumber, reservedate, biblionumber, |
| 5511 |
constrainttype, branchcode, notificationdate, |
5514 |
constrainttype, branchcode, notificationdate, |
| 5512 |
reminderdate, cancellationdate, reservenotes, |
5515 |
reminderdate, cancellationdate, reservenotes, |
| 5513 |
priority, found, timestamp, itemnumber, |
5516 |
priority, found, timestamp, itemnumber, |
| 5514 |
waitingdate, expirationdate, lowestPriority |
5517 |
waitingdate, expirationdate, lowestPriority, |
|
|
5518 |
suspend, suspend_until |
| 5515 |
FROM reserves ORDER BY reservedate |
5519 |
FROM reserves ORDER BY reservedate |
| 5516 |
"); |
5520 |
"); |
| 5517 |
$dbh->do('TRUNCATE reserves'); |
5521 |
$dbh->do('TRUNCATE reserves'); |
| 5518 |
- |
|
|