From c9d65585582315cd85d1d2f5046486d695443c45 Mon Sep 17 00:00:00 2001 From: Andrew Isherwood Date: Tue, 5 Feb 2019 15:19:12 +0000 Subject: [PATCH] Bug 20581: (follow-up) Fix typo in DB upgrade IN -> ON Signed-off-by: Katrin Fischer Signed-off-by: Katrin Fischer --- .../atomicupdate/bug_20581-add_new_illrequests_status_alias_column.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 442cddbe07..001eb089aa 100644 --- 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)" ); -- 2.11.0