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

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 1054-1059 CREATE TABLE `items` ( -- holdings/item information Link Here
1054
  KEY `homebranch` (`homebranch`),
1054
  KEY `homebranch` (`homebranch`),
1055
  KEY `holdingbranch` (`holdingbranch`),
1055
  KEY `holdingbranch` (`holdingbranch`),
1056
  KEY `itemcallnumber` (`itemcallnumber`),
1056
  KEY `itemcallnumber` (`itemcallnumber`),
1057
  KEY `items_location` (`location`),
1058
  KEY `items_ccode` (`ccode`),
1057
  CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1059
  CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1058
  CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1060
  CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1059
  CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
1061
  CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 5159-5164 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5159
    SetVersion($DBversion);
5159
    SetVersion($DBversion);
5160
}
5160
}
5161
5161
5162
$DBversion = "3.07.00.XXX";
5163
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
5164
    $dbh->do("CREATE INDEX items_location ON items(location)");
5165
    $dbh->do("CREATE INDEX items_ccode ON items(ccode)");
5166
    print "Upgrade to $DBversion done (items_location and items_ccode indexes added for ShelfBrowser)";
5167
    SetVersion($DBversion);
5168
}
5169
5162
=head1 FUNCTIONS
5170
=head1 FUNCTIONS
5163
5171
5164
=head2 DropAllForeignKeys($table)
5172
=head2 DropAllForeignKeys($table)
5165
- 

Return to bug 7886