From 01cd9e25d7ab174664dfb024869923a99110c550 Mon Sep 17 00:00:00 2001 From: Ammar Abdulhamid 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