Line 0
Link Here
|
0 |
- |
1 |
$DBversion = "16.06.00.XXX"; |
|
|
2 |
if ( CheckVersion($DBversion) ) { |
3 |
|
4 |
# If index issn_idx still exists, we assume that dbrev 3.15.00.049 failed, |
5 |
# and we repeat it (partially). |
6 |
# Note: the db rev only pertains to biblioitems and is not needed for |
7 |
# deletedbiblioitems. |
8 |
|
9 |
my $temp = $dbh->selectall_arrayref( "SHOW INDEXES FROM biblioitems WHERE key_name = 'issn_idx'" ); |
10 |
|
11 |
if( @$temp > 0 ) { |
12 |
$dbh->do( "ALTER TABLE biblioitems DROP INDEX isbn" ); |
13 |
$dbh->do( "ALTER TABLE biblioitems DROP INDEX issn" ); |
14 |
$dbh->do( "ALTER TABLE biblioitems DROP INDEX issn_idx" ); |
15 |
$dbh->do( "ALTER TABLE biblioitems CHANGE isbn isbn MEDIUMTEXT NULL DEFAULT NULL, CHANGE issn issn MEDIUMTEXT NULL DEFAULT NULL" ); |
16 |
$dbh->do( "ALTER TABLE biblioitems ADD INDEX isbn ( isbn ( 255 ) ), ADD INDEX issn ( issn ( 255 ) )" ); |
17 |
print "Upgrade to $DBversion done (Bug 8835). Removed issn_idx.\n"; |
18 |
} else { |
19 |
print "Upgrade to $DBversion done (Bug 8835). Everything is fine.\n"; |
20 |
} |
21 |
|
22 |
SetVersion($DBversion); |
23 |
} |