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
[x] dbstore2002.codfw.wmnet
[x] db2036.codfw.wmnet
[x] db2043.codfw.wmnet
[x] db2050.codfw.wmnet
[x] db2057.codfw.wmnet
[x] 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