|
Lines 12-18
if( CheckVersion( $DBversion ) ) {
Link Here
|
| 12 |
$dbh->do( "ALTER TABLE illrequests DROP FOREIGN KEY illrequests_safk"); |
12 |
$dbh->do( "ALTER TABLE illrequests DROP FOREIGN KEY illrequests_safk"); |
| 13 |
} |
13 |
} |
| 14 |
if ( index_exists( 'illrequests', 'illrequests_safk' ) ) { |
14 |
if ( index_exists( 'illrequests', 'illrequests_safk' ) ) { |
| 15 |
$dbh->do( "DROP INDEX illrequests_safk IN illrequests" ); |
15 |
$dbh->do( "DROP INDEX illrequests_safk ON illrequests" ); |
| 16 |
} |
16 |
} |
| 17 |
# Now change the illrequests.status_alias column definition from int to varchar |
17 |
# Now change the illrequests.status_alias column definition from int to varchar |
| 18 |
$dbh->do( "ALTER TABLE illrequests MODIFY COLUMN status_alias varchar(80)" ); |
18 |
$dbh->do( "ALTER TABLE illrequests MODIFY COLUMN status_alias varchar(80)" ); |
| 19 |
- |
|
|