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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1020-1026 CREATE TABLE `items` ( Link Here
1020
  `stocknumber` varchar(32) default NULL,
1020
  `stocknumber` varchar(32) default NULL,
1021
  PRIMARY KEY  (`itemnumber`),
1021
  PRIMARY KEY  (`itemnumber`),
1022
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1022
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1023
  UNIQUE KEY `itemstocknumberidx` (`stocknumber`),
1023
  KEY `itemstocknumberidx` (`stocknumber`),
1024
  KEY `itembinoidx` (`biblioitemnumber`),
1024
  KEY `itembinoidx` (`biblioitemnumber`),
1025
  KEY `itembibnoidx` (`biblionumber`),
1025
  KEY `itembibnoidx` (`biblionumber`),
1026
  KEY `homebranch` (`homebranch`),
1026
  KEY `homebranch` (`homebranch`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 4134-4139 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
4134
    SetVersion ($DBversion);
4134
    SetVersion ($DBversion);
4135
}
4135
}
4136
4136
4137
$DBversion = '3.03.00.XXX';
4138
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4139
    $dbh->do("ALTER TABLE `items` DROP INDEX `itemstocknumberidx`;");
4140
    $dbh->do("ALTER TABLE items ADD INDEX itemstocknumberidx (stocknumber);");
4141
    print "Upgrade to $DBversion done (Change items.stocknumber to be not unique)\n";
4142
    SetVersion ($DBversion);
4143
}
4144
4137
=head1 FUNCTIONS
4145
=head1 FUNCTIONS
4138
4146
4139
=head2 DropAllForeignKeys($table)
4147
=head2 DropAllForeignKeys($table)
4140
- 

Return to bug 5860