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

(-)a/installer/data/mysql/updatedatabase.pl (-5 / +8 lines)
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
- 

Return to bug 10185