diff options
author | Ammar Abdulhamid <ammarpad@yahoo.com> | 2020-11-10 07:23:47 +0100 |
---|---|---|
committer | Ammar Abdulhamid <ammarpad@yahoo.com> | 2020-11-10 07:35:10 +0100 |
commit | 01cd9e25d7ab174664dfb024869923a99110c550 (patch) | |
tree | f172d0e491fb729cc241149467fc7c4884ffa898 /maintenance/tables.sql | |
parent | e836dfa404bbd1550f1c590faa86cfa2b0ed131e (diff) | |
download | mediawikicore-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.sql | 17 |
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, |