diff options
| -rw-r--r-- | Bugzilla/DB/Mysql.pm | 3 | ||||
| -rw-r--r-- | Bugzilla/DB/Schema/Mysql.pm | 4 |
2 files changed, 4 insertions, 3 deletions
diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm index c1fd52844..e0918a22a 100644 --- a/Bugzilla/DB/Mysql.pm +++ b/Bugzilla/DB/Mysql.pm @@ -278,7 +278,8 @@ sub bz_setup_database { # to a standard. We store those names here, so that they # can be properly renamed. my $bad_names = { - bugs_activity => ['bugs_activity_bugid_idx', + # 'when' is a possible leftover from Bugzillas before 2.8 + bugs_activity => ['when', 'bugs_activity_bugid_idx', 'bugs_activity_bugwhen_idx'], longdescs => ['longdescs_bugid_idx', 'longdescs_bugwhen_idx'], diff --git a/Bugzilla/DB/Schema/Mysql.pm b/Bugzilla/DB/Schema/Mysql.pm index 07d7036e4..cc30246cc 100644 --- a/Bugzilla/DB/Schema/Mysql.pm +++ b/Bugzilla/DB/Schema/Mysql.pm @@ -90,7 +90,7 @@ sub _get_create_index_ddl { my $sql = "CREATE "; $sql .= "$index_type " if ($index_type eq 'UNIQUE' || $index_type eq 'FULLTEXT'); - $sql .= "INDEX $index_name ON $table_name \(" . + $sql .= "INDEX \`$index_name\` ON $table_name \(" . join(", ", @$index_fields) . "\)"; return($sql); @@ -107,7 +107,7 @@ sub get_alter_column_ddl { sub get_drop_index_ddl { my ($self, $table, $name) = @_; - return ("DROP INDEX $name ON $table"); + return ("DROP INDEX \`$name\` ON $table"); } sub get_rename_column_ddl { |