aboutsummaryrefslogtreecommitdiffstats
path: root/maintenance/tables.sql
diff options
context:
space:
mode:
authorAmmar Abdulhamid <ammarpad@yahoo.com>2020-11-10 07:23:47 +0100
committerAmmar Abdulhamid <ammarpad@yahoo.com>2020-11-10 07:35:10 +0100
commit01cd9e25d7ab174664dfb024869923a99110c550 (patch)
treef172d0e491fb729cc241149467fc7c4884ffa898 /maintenance/tables.sql
parente836dfa404bbd1550f1c590faa86cfa2b0ed131e (diff)
downloadmediawikicore-01cd9e25d7ab174664dfb024869923a99110c550.tar.gz
mediawikicore-01cd9e25d7ab174664dfb024869923a99110c550.zip
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
Diffstat (limited to 'maintenance/tables.sql')
-rw-r--r--maintenance/tables.sql17
1 files changed, 0 insertions, 17 deletions
diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 2d739b251ed6..2a121ad0f0cd 100644
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -281,23 +281,6 @@ CREATE INDEX /*i*/rev_page_actor_timestamp ON /*_*/revision (rev_page,rev_actor,
-- 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.
---
--- 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_actor_temp (
-- Key to rev_id
revactor_rev int unsigned NOT NULL,