Apply T312272 to wmf wikis
- ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CentralNotice/+/817880/2/sql/mysql/patch-cn_notice_projects-unique-to-pk.sql
- Where to run those changes: centralnotice
- When to run those changes: any time
- If the schema change is backwards compatible: Yes
- If the schema change has been tested already on some of the test/beta wikis: beta already running with the new schema
- if the data should be made available on the labs replicas and/or dumps: no change of the existing rules
Due to a bug in the schema change generator (T314138) the DROP + ALTER should be rewritten to be atomic:
alter table cn_notice_projects drop key np_notice_id_project, ADD PRIMARY KEY (np_notice_id, np_project);