Once T243073: Add primary key to pagetriage_page_tags is merged, the alters will need to be run on WMF wikis
- ALTERs to run: https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/PageTriage/+/567390/7/sql/PageTriagePageTagsPatch-pk.sql[1]
- Where to run those changes: testwiki, test2wiki, enwiki[2]
- When to run those changes: Whenever is convenient
- If the schema change is backwards compatible: Yes (converts unique index to primary key)
- If the schema change has been tested already on some of the test/beta wikis: Not yet
- If the data should be made available on the labs replicas and/or dumps: Yes, data in this table is public.
[1] Alter
ALTER TABLE /*_*/pagetriage_page_tags DROP INDEX /*i*/ptrpt_page_tag_id, ADD PRIMARY KEY (ptrpt_page_id,ptrpt_tag_id);
[2] wmgEnablePageTriage
'wmgEnablePageTriage' => [ 'default' => false, 'testwiki' => true, 'test2wiki' => true, 'enwiki' => true, ],
Schema change progress:
- enwiki
- eqiad progress T243804#5847199
- codfw
- testwiki
- test2wiki