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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1023-1029 CREATE TABLE `items` ( Link Here
1023
  `stocknumber` varchar(32) default NULL,
1023
  `stocknumber` varchar(32) default NULL,
1024
  PRIMARY KEY  (`itemnumber`),
1024
  PRIMARY KEY  (`itemnumber`),
1025
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1025
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1026
  UNIQUE KEY `itemstocknumberidx` (`stocknumber`),
1026
  KEY `itemstocknumberidx` (`stocknumber`),
1027
  KEY `itembinoidx` (`biblioitemnumber`),
1027
  KEY `itembinoidx` (`biblioitemnumber`),
1028
  KEY `itembibnoidx` (`biblionumber`),
1028
  KEY `itembibnoidx` (`biblionumber`),
1029
  KEY `homebranch` (`homebranch`),
1029
  KEY `homebranch` (`homebranch`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 4209-4214 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
4209
    SetVersion ($DBversion);
4209
    SetVersion ($DBversion);
4210
}
4210
}
4211
4211
4212
$DBversion = '3.03.00.XXX';
4213
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4214
    $dbh->do("ALTER TABLE `items` DROP INDEX `itemsstocknumberidx`;");
4215
    $dbh->do("ALTER TABLE items ADD INDEX itemstocknumberidx (stocknumber);");
4216
    print "Upgrade to $DBversion done (Change items.stocknumber to be not unique)\n";
4217
    SetVersion ($DBversion);
4218
}
4219
4212
=head1 FUNCTIONS
4220
=head1 FUNCTIONS
4213
4221
4214
=head2 DropAllForeignKeys($table)
4222
=head2 DropAllForeignKeys($table)
4215
- 

Return to bug 5860