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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1045-1050 CREATE TABLE `items` ( -- holdings/item information Link Here
1045 
  KEY `itembibnoidx` (`biblionumber`),
 1045 
  KEY `itembibnoidx` (`biblionumber`),
1046 
  KEY `homebranch` (`homebranch`),
 1046 
  KEY `homebranch` (`homebranch`),
1047 
  KEY `holdingbranch` (`holdingbranch`),
 1047 
  KEY `holdingbranch` (`holdingbranch`),
1048 
  KEY `itemcallnumber` (`itemcallnumber`),
1048 
  CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
 1049 
  CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1049 
  CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
 1050 
  CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1050 
  CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
 1051 
  CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 4684-4689 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
4684 
    SetVersion($DBversion);
 4684 
    SetVersion($DBversion);
4685 
}
 4685 
}
4686 

          4686
          

        

            

              
              
              4687
              
$DBversion = "3.07.00.XXX";

            

            

              4688
              
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {

            

            

              4689
              
    $dbh->do("ALTER TABLE items ADD KEY `itemcallnumber` (itemcallnumber)");

            

            

              4690
              
    print "Upgrade to $DBversion done (Added index on items.itemcallnumber)\n";

            

            

              4691
              
    SetVersion($DBversion);

            

            

              4692
              
}

            

            

              4693
              

            

        

          4687
          
=head1 FUNCTIONS

          4694
          
=head1 FUNCTIONS

        

        

          4688
          

          4695
          

        

        

          4689
          
=head2 DropAllForeignKeys($table)

          4696
          
=head2 DropAllForeignKeys($table)

        

            

              4690
              
- 

              
              
            






  

  Return to bug 7509