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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +6 lines)
Lines 4217-4223 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
4217
4217
4218
$DBversion = '3.03.00.042';
4218
$DBversion = '3.03.00.042';
4219
if (C4::Context->preference("Version") < TransformToNum($DBversion) && $original_version < TransformToNum("3.02.06.001")) {
4219
if (C4::Context->preference("Version") < TransformToNum($DBversion) && $original_version < TransformToNum("3.02.06.001")) {
4220
    $dbh->do("ALTER TABLE `items` DROP INDEX `itemsstocknumberidx`;");
4220
    #check old indexes and possibly remove
4221
    my @row = $dbh->selectrow_array("SHOW INDEXES FROM items WHERE key_name='itemstocknumberidx'");
4222
    $dbh->do("ALTER TABLE `items` DROP INDEX `itemstocknumberidx`;") if @row;
4223
    @row = $dbh->selectrow_array("SHOW INDEXES FROM items WHERE key_name='itemsstocknumberidx'");
4224
    $dbh->do("ALTER TABLE `items` DROP INDEX `itemsstocknumberidx`;") if @row;
4225
    #add index
4221
    $dbh->do("ALTER TABLE items ADD INDEX itemstocknumberidx (stocknumber);");
4226
    $dbh->do("ALTER TABLE items ADD INDEX itemstocknumberidx (stocknumber);");
4222
    print "Upgrade to $DBversion done (Change items.stocknumber to be not unique)\n";
4227
    print "Upgrade to $DBversion done (Change items.stocknumber to be not unique)\n";
4223
    SetVersion ($DBversion);
4228
    SetVersion ($DBversion);
4224
- 

Return to bug 5860