Bug 20581: (follow-up) Fix typo in DB upgrade

IN -> ON

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

diff --git a/installer/data/mysql/atomicupdate/bug_20581-add_new_illrequests_status_alias_column.perl b/installer/data/mysql/atomicupdate/bug_20581-add_new_illrequests_status_alias_column.perl
index 442cddb..001eb08 100644 (file)
--- a/installer/data/mysql/atomicupdate/bug_20581-add_new_illrequests_status_alias_column.perl
+++ b/installer/data/mysql/atomicupdate/bug_20581-add_new_illrequests_status_alias_column.perl
@@ -12,7 +12,7 @@ if( CheckVersion( $DBversion ) ) {
             $dbh->do( "ALTER TABLE illrequests DROP FOREIGN KEY illrequests_safk");
         }
         if ( index_exists( 'illrequests', 'illrequests_safk' ) ) {
-            $dbh->do( "DROP INDEX illrequests_safk IN illrequests" );
+            $dbh->do( "DROP INDEX illrequests_safk ON illrequests" );
         }
         # Now change the illrequests.status_alias column definition from int to varchar
         $dbh->do( "ALTER TABLE illrequests MODIFY COLUMN status_alias varchar(80)" );