# **ALTERs to run:** https://gerrit.wikimedia.org/r/c/mediawiki/extensions/FlaggedRevs/+/743403/2/backend/schema/mysql/patch-flaggedtemplates-fr_title.sql
# **Where to run those changes:** flaggedrevs.dblist[1]
# **When to run those changes:** Any time.
# **If the schema change is backwards compatible:** No
# **If the schema change has been tested already on some of the test/beta wikis:** Yes. Beta cluster. had some learnings[2]
# **If the data should be made available on the cloud services replicas and/or dumps:** It's public but the maintain-views has name of this field mentioned, probably we should remove that.
[1] The table exists only in fifty wikis and out of those it's mostly empty in lots of them but it's massive (~100GB) in several including arwiki, dewiki, huwiki, plwiki, ruwiki.
[2]The table might include data that cause alter to fail, we need to delete any rows that ft_tmp_rev_id is either 0 or NULL
[] s1 (enwiki)
** [] Fix clouddb views
[x] s2 (eowiki fiwiki idwiki plwiki trwiki)
** [x] Fix clouddb views
[x] s3 (alswiki bawiki bewiki bnwiki bswiki cawikinews cewiki ckbwiki de_labswikimedia dewikiquote dewiktionary elwikinews en_labswikimedia enwikibooks enwikinews eswikinews fawikinews flaggedrevs_labswikimedia frwikinews hewikisource hiwiki iawiki iswiktionary kawiki lawikisource mkwiki ptwikibooks ptwikinews ptwikisource plwikisource plwiktionary ruwikinews ruwikiquote ruwikisource ruwiktionary siwiki sqwiki tawikinews test2wiki trwikiquote ukwiktionary vecwiki zh_classicalwiki)
** [x] Fix clouddb views
[x] s5 (dewiki)
** [x] Fix clouddb views
[x] s6 (frwiki ruwiki)
** [x] Fix clouddb views
[x] s7 (arwiki fawiki huwiki ukwiki)
** [x] Fix clouddb views