From: Reedy <reedy@wikimedia.org>
Date: Wed, 30 Aug 2017 15:33:14 +0000 (+0100)
Subject: Prefix comment table when adding indexes
X-Git-Tag: 1.31.0-rc.0~2261^2
X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fwiklou.git;a=commitdiff_plain;h=f0f839c969184660aa55a03e7a81fabe887aebc9

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 60c58d6e68..c8bf958036 100644
--- 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 2017ecaccd..f743b55c1e 100644
--- 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 3836665d90..d6ef40c73b 100644
--- 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);
 
 
 --