While working on T288398 I found these MyISAM flaggedrevs related tables on some sections like `ruwiki` (see full list below):
```
mysql:root@localhost [information_schema]> select table_name,create_time,update_time from tables where engine='MyISAM' and table_name like 'flagged%';
+--------------------+---------------------+---------------------+
| table_name | create_time | update_time |
+--------------------+---------------------+---------------------+
| flaggedrevs_stats2 | 2013-10-07 11:26:02 | 2013-10-07 11:26:02 |
| flaggedrevs_stats | 2013-10-07 11:26:02 | 2013-10-07 11:26:02 |
+--------------------+---------------------+---------------------+
2 rows in set (0.003 sec)
```
```
mysql:root@localhost [information_schema]> use ruwiki;show create table flaggedrevs_stats2\G show create table flaggedrevs_stats\G
Database changed
*************************** 1. row ***************************
Table: flaggedrevs_stats2
Create Table: CREATE TABLE `flaggedrevs_stats2` (
`stat_id` int(10) unsigned NOT NULL DEFAULT 1,
`ave_review_time` int(10) unsigned NOT NULL DEFAULT 0,
`med_review_time` int(10) unsigned NOT NULL DEFAULT 0,
`ave_pending_time` int(10) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`stat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=binary
1 row in set (0.000 sec)
*************************** 1. row ***************************
Table: flaggedrevs_stats
Create Table: CREATE TABLE `flaggedrevs_stats` (
`namespace` int(11) NOT NULL DEFAULT 0,
`total` int(11) NOT NULL DEFAULT 0,
`reviewed` int(11) NOT NULL DEFAULT 0,
`synced` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`namespace`)
) ENGINE=MyISAM DEFAULT CHARSET=binary
1 row in set (0.000 sec)
```
I guess they are just ancient history and they are not updated, so can we drop them?
We should probably check all the otherwikis where we have flaggedrevs enabled.
This table is present on:
s1: `enwiki`
s2:
```
eowiki
idwiki
plwiki
trwiki
```
s3:
```
alswiki
bewiki
bnwiki
bswiki
de_labswikimedia
dewikiquote
dewiktionary
en_labswikimedia
enwikibooks
enwikinews
eswikinews
fawikinews
flaggedrevs_labswikimedia
frwikinews
hewikisource
hiwiki
iawiki
iswiktionary
kawiki
mkwiki
ptwikinews
ptwikisource
plwikisource
plwiktionary
ruwikiquote
ruwikisource
sqwiki
tawikinews
ukwiktionary
zh_classicalwiki
```
s5: `dewiki`
s6: `ruwiki`
s7:
```
arwiki
huwiki
```