The last shard to unify the revision table on is s3.
This is going to be a tricky one as we need to see how many versions of the revision table we have there.
wikis that are correct:
dtywiki ecwikimedia fiwikivoyage olowiki pawikisource projectcomwiki ptwikimedia wbwikimedia
Special cases - this is needed: drop key rev_page_id, add key rev_page_id (rev_page,rev_id)
adywiki azbwiki cawikimedia elwikivoyage enwikivoyage eswikivoyage fawikivoyage fdcwiki frwikivoyage gomwiki hewikivoyage iegcomwiki jamwiki kowikiversity legalteamwiki loginwiki lrcwiki maiwiki minwiki nlwikivoyage ombudsmenwiki orwikisource plwikivoyage ptwikivoyage rowikivoyage ruwikivoyage sawikiquote svwikivoyage tcywiki testwikidatawiki transitionteamwiki tyvwiki ukwikivoyage vecwiktionary viwikivoyage votewiki wikimania2013wiki wikimania2014wiki wikimania2015wiki wikimania2016wiki wikimania2017wiki zerowiki zhwikivoyage
Special cases - this is needed: drop key rev_id, drop primary key, add primary key (rev_id), add key rev_page_id (rev_page,rev_id)
dewikivoyage itwikivoyage
Special cases - this is needed: drop key rev_page_id, add key rev_page_id (rev_page,rev_id), add key page_user_timestamp (rev_page,rev_user,rev_timestamp)
acewiki arbcom_cswiki arbcom_fiwiki arwikimedia arwikiversity aswikisource (does not need add key page_user_timestamp (rev_page,rev_user,rev_timestamp) ) bdwikimedia bewikimedia bewikisource bjnwiki boardgovcomwiki brwikimedia brwikisource checkuserwiki ckbwiki cnwikimedia (does not need add key page_user_timestamp (rev_page,rev_user,rev_timestamp) ) cowikimedia dkwikimedia donatewiki elwikinews eowikinews eowikisource etwikimedia fawikinews fiwikimedia fiwikiversity flaggedrevs_labswikimedia frrwiki gagwiki guwikisource kbdwiki koiwiki kowikinews krcwiki lezwiki liquidthreads_labswikimedia liwikibooks ltgwiki mhrwiki mkwikimedia movementroleswiki mrjwiki mrwikisource mwlwiki mxwikimedia noboard_chapterswikimedia noboardwiki nsowiki nycwikimedia outreachwiki pcdwiki pflwiki pnbwiki pnbwiktionary pntwiki readerfeedback_labswikimedia ruewiki ruwikimedia ruwikiversity sahwikisource sawikisource slwikiversity sqwikinews steward stewardwiki strategyappswiki strategywiki svwikiversity tenwiki test2wiki trwikimedia trwikinews uawikimedia usabilitywiki vecwikisource vepwiki vewikimedia wikimania2010wiki wikimania2011wiki wikimania2012wiki xmfwiki
The rest of the wikis - need: drop key rev_id, drop primary key, add primary key (rev_id), add key page_user_timestamp (rev_page,rev_user,rev_timestamp), add key rev_page_id (rev_page,rev_id)
Where to apply it:
- dbstore2001.codfw.wmnet
- dbstore2002.codfw.wmnet
- db2036.codfw.wmnet
- db2043.codfw.wmnet
- db2050.codfw.wmnet
- db2057.codfw.wmnet
- db2018.codfw.wmnet
- labsdb1001.eqiad.wmnet
- labsdb1003.eqiad.wmnet
- db1069.eqiad.wmnet
- labsdb1009.eqiad.wmnet
- labsdb1010.eqiad.wmnet
- labsdb1011.eqiad.wmnet
- dbstore1001.eqiad.wmnet
- dbstore1002.eqiad.wmnet
- db1095.eqiad.wmnet
- db1015.eqiad.wmnet
- db1035.eqiad.wmnet
- db1038.eqiad.wmnet
- db1044.eqiad.wmnet
- db1077.eqiad.wmnet
- db1078.eqiad.wmnet
- db1075.eqiad.wmnet