From 6b2e132ec32b657e8f806eedc4d9f06fc66131ef Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Fri, 15 Apr 2005 05:49:25 +0000
Subject: Bug 78276: change name of "when" index on bugs_activity.bug_when
 column Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=myk, a=myk

---
 Bugzilla/DB/Mysql.pm        | 3 ++-
 Bugzilla/DB/Schema/Mysql.pm | 4 ++--
 2 files changed, 4 insertions(+), 3 deletions(-)

(limited to 'Bugzilla/DB')

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 {
-- 
cgit v1.2.3-24-g4f1b