From 01cd9e25d7ab174664dfb024869923a99110c550 Mon Sep 17 00:00:00 2001
From: Ammar Abdulhamid <ammarpad@yahoo.com>
Date: Tue, 10 Nov 2020 07:23:47 +0100
Subject: Migrate revision_comment_temp to abstract schema

For Postgres:
 - Change 'revcomment_comment_id' to BigInt as it's in MySQL/SQLite

Bug: T230428
Bug: T164898
Change-Id: I4b5af210b63d932e2eb0120075a5fa5250924ace
---
 maintenance/tables.sql | 17 -----------------
 1 file changed, 17 deletions(-)

(limited to 'maintenance/tables.sql')

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 2d739b251ed6..2a121ad0f0cd 100644
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -274,23 +274,6 @@ CREATE INDEX /*i*/rev_actor_timestamp ON /*_*/revision (rev_actor,rev_timestamp,
 -- in ApiQueryContributors. Also for ApiQueryRevisions if rvuser is specified.
 CREATE INDEX /*i*/rev_page_actor_timestamp ON /*_*/revision (rev_page,rev_actor,rev_timestamp);
 
---
--- Temporary table to avoid blocking on an alter of revision.
---
--- On large wikis like the English Wikipedia, altering the revision table is a
--- months-long process. This table is being created to avoid such an alter, and
--- will be merged back into revision in the future.
---
-CREATE TABLE /*_*/revision_comment_temp (
-  -- Key to rev_id
-  revcomment_rev int unsigned NOT NULL,
-  -- Key to comment_id
-  revcomment_comment_id bigint unsigned NOT NULL,
-  PRIMARY KEY (revcomment_rev, revcomment_comment_id)
-) /*$wgDBTableOptions*/;
--- Ensure uniqueness
-CREATE UNIQUE INDEX /*i*/revcomment_rev ON /*_*/revision_comment_temp (revcomment_rev);
-
 --
 -- Temporary table to avoid blocking on an alter of revision.
 --
-- 
cgit v1.2.3

