Prefix comment table when adding indexes

Change-Id: Ie87d2ef68050a402d6c81ca98cc7402f7c5f14aa
Follows-Up: Ic3a434c061ed6e443ea072bc62dda09acbeeed7f

diff --git a/maintenance/archives/patch-comment-table.sql b/maintenance/archives/patch-comment-table.sql
index 60c58d6..c8bf958 100644 (file)
--- a/maintenance/archives/patch-comment-table.sql
+++ b/maintenance/archives/patch-comment-table.sql
@@ -9,7 +9,7 @@ CREATE TABLE /*_*/comment (
   comment_text BLOB NOT NULL,
   comment_data BLOB
 ) /*$wgDBTableOptions*/;
-CREATE INDEX /*i*/comment_hash ON comment (comment_hash);
+CREATE INDEX /*i*/comment_hash ON /*_*/comment (comment_hash);
 
 CREATE TABLE /*_*/revision_comment_temp (
   revcomment_rev int unsigned NOT NULL,

diff --git a/maintenance/sqlite/archives/patch-comment-table.sql b/maintenance/sqlite/archives/patch-comment-table.sql
index 2017eca..f743b55 100644 (file)
--- a/maintenance/sqlite/archives/patch-comment-table.sql
+++ b/maintenance/sqlite/archives/patch-comment-table.sql
@@ -10,7 +10,7 @@ CREATE TABLE /*_*/comment (
   comment_text BLOB NOT NULL,
   comment_data BLOB
 ) /*$wgDBTableOptions*/;
-CREATE INDEX /*i*/comment_hash ON comment (comment_hash);
+CREATE INDEX /*i*/comment_hash ON /*_*/comment (comment_hash);
 
 CREATE TABLE /*_*/revision_comment_temp (
   revcomment_rev int unsigned NOT NULL,

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 3836665..d6ef40c 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -521,7 +521,7 @@ CREATE TABLE /*_*/comment (
   comment_data BLOB
 ) /*$wgDBTableOptions*/;
 -- Index used for deduplication.
-CREATE INDEX /*i*/comment_hash ON comment (comment_hash);
+CREATE INDEX /*i*/comment_hash ON /*_*/comment (comment_hash);
 
 
 --