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

(-)a/installer/data/mysql/atomicupdate/bug_20581-add_new_illrequests_status_alias_column.perl (-2 / +1 lines)
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
- 

Return to bug 20581