Lines 1-11
Link Here
|
1 |
$DBversion = "XXX"; |
1 |
$DBversion = "XXX"; |
2 |
if(CheckVersion($DBversion)) { |
2 |
if(CheckVersion($DBversion)) { |
3 |
# Drop index that might exist because of bug 5337 |
3 |
# Drop index that might exist because of bug 5337 |
4 |
my $temp = $dbh->selectall_arrayref(q{ |
4 |
if( index_exists('biblioitems', 'ean')) { |
5 |
SHOW INDEXES FROM biblioitems WHERE key_name = 'ean' }); |
|
|
6 |
if( @$temp > 0 ) { |
7 |
$dbh->do(q{ ALTER TABLE biblioitems DROP INDEX ean }); |
5 |
$dbh->do(q{ ALTER TABLE biblioitems DROP INDEX ean }); |
8 |
} |
6 |
} |
|
|
7 |
if( index_exists('deletedbiblioitems', 'ean')) { |
8 |
$dbh->do(q{ ALTER TABLE deletedbiblioitems DROP INDEX ean }); |
9 |
} |
9 |
|
10 |
|
10 |
# Change data type of column |
11 |
# Change data type of column |
11 |
$dbh->do(q{ ALTER TABLE biblioitems MODIFY COLUMN ean MEDIUMTEXT default NULL }); |
12 |
$dbh->do(q{ ALTER TABLE biblioitems MODIFY COLUMN ean MEDIUMTEXT default NULL }); |
12 |
- |
|
|