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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1555-1560 CREATE TABLE `reserves` ( Link Here
1555
  `waitingdate` date default NULL,
1555
  `waitingdate` date default NULL,
1556
  `expirationdate` DATE DEFAULT NULL,
1556
  `expirationdate` DATE DEFAULT NULL,
1557
  `lowestPriority` tinyint(1) NOT NULL,
1557
  `lowestPriority` tinyint(1) NOT NULL,
1558
  KEY priorityfoundidx (priority,found),
1558
  KEY `borrowernumber` (`borrowernumber`),
1559
  KEY `borrowernumber` (`borrowernumber`),
1559
  KEY `biblionumber` (`biblionumber`),
1560
  KEY `biblionumber` (`biblionumber`),
1560
  KEY `itemnumber` (`itemnumber`),
1561
  KEY `itemnumber` (`itemnumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 4432-4437 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
4432
    SetVersion ($DBversion);
4432
    SetVersion ($DBversion);
4433
}
4433
}
4434
4434
4435
$DBversion = "3.05.00.XXX";
4436
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4437
    $dbh->do("CREATE INDEX priorityfoundidx ON reserves (priority,found)");
4438
    print "Create an index on reserves to speed up holds awaiting pickup report bug 5866\n";
4439
    SetVersion($DBversion);
4440
}
4441
4442
4435
=head1 FUNCTIONS
4443
=head1 FUNCTIONS
4436
4444
4437
=head2 DropAllForeignKeys($table)
4445
=head2 DropAllForeignKeys($table)
4438
- 

Return to bug 5866