Change Details

Apply T312275 to wmf wikis # **ALTERs to run:** https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CreditsSource/+/817884/3/schema/mysql/patch-swauthor_links-unique-to-pk.sql # **Where to run those changes:** wikivoyage.dblist # **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 swauthor_links drop key swal_srcwork_author_unique, ADD PRIMARY KEY (swal_srcworkid, swal_authorid); ```

Apply T312275 to wmf wikis # **ALTERs to run:** https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CreditsSource/+/817884/3/schema/mysql/patch-swauthor_links-unique-to-pk.sql # **Where to run those changes:** wikivoyage.dblist # **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 swauthor_links drop key swal_srcwork_author_unique, ADD PRIMARY KEY (swal_srcworkid, swal_authorid); ``` s3: ``` bnwikivoyage dewikivoyage elwikivoyage eswikivoyage fawikivoyage fiwikivoyage frwikivoyage hewikivoyage hiwikivoyage itwikivoyage nlwikivoyage plwikivoyage pswikivoyage ptwikivoyage rowikivoyage ruwikivoyage svwikivoyage ukwikivoyage viwikivoyage zhwikivoyage ``` s5: ``` enwikivoyage eowikivoyage jawikivoyage shnwikivoyage trwikivoyage ```

Apply T312275 to wmf wikis # **ALTERs to run:** https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CreditsSource/+/817884/3/schema/mysql/patch-swauthor_links-unique-to-pk.sql # **Where to run those changes:** wikivoyage.dblist # **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 swauthor_links drop key swal_srcwork_author_unique, ADD PRIMARY KEY (swal_srcworkid, swal_authorid); ``` s3: ``` bnwikivoyage dewikivoyage elwikivoyage eswikivoyage fawikivoyage fiwikivoyage frwikivoyage hewikivoyage hiwikivoyage itwikivoyage nlwikivoyage plwikivoyage pswikivoyage ptwikivoyage rowikivoyage ruwikivoyage svwikivoyage ukwikivoyage viwikivoyage zhwikivoyage ``` s5: ``` enwikivoyage eowikivoyage jawikivoyage shnwikivoyage trwikivoyage ```