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 |
my $sth = $dbh->prepare("SELECT index_name FROM information_schema.statistics WHERE index_name ='itemsstocknumberidx'"); |
|
|
4221 |
$sth->execute(); |
4222 |
if (my $rows = $sth->fetchrows_hashref()){ |
4223 |
$dbh->do("ALTER TABLE `items` DROP INDEX `itemsstocknumberidx`;"); |
4224 |
} |
4225 |
else { |
4226 |
$dbh->do("ALTER TABLE `items` DROP INDEX `itemstocknumberidx`;"); |
4227 |
} |
4221 |
$dbh->do("ALTER TABLE items ADD INDEX itemstocknumberidx (stocknumber);"); |
4228 |
$dbh->do("ALTER TABLE items ADD INDEX itemstocknumberidx (stocknumber);"); |
4222 |
print "Upgrade to $DBversion done (Change items.stocknumber to be not unique)\n"; |
4229 |
print "Upgrade to $DBversion done (Change items.stocknumber to be not unique)\n"; |
4223 |
SetVersion ($DBversion); |
4230 |
SetVersion ($DBversion); |
4224 |
- |
|
|