Adjust the field type of flaggedrevs.fr_rev_timestamp/fr_timestamp to fixed binary and drop default on wmf wikis
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Umherirrender
	Jul 13 2022, 7:15 PM

Description

Apply parts of T310437 to wmf wikis

ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/FlaggedRevs/+/804753/2/backend/schema/mysql/patch-flaggedrevs-timestamps.sql
Where to run those changes: https://noc.wikimedia.org/conf/highlight.php?file=dblists/flaggedrevs.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: not running on beta
if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

	Subject	Repo	Branch	Lines +/-
	Add fix_flaggedrevs_timestamps.py	operations/software/schema-changes	master	+50 -0

Mentioned In: T313253: Fix Flaggedrevs database schema drifts in production
rSCHCH04cf6ae8ad28: Add fix_flaggedrevs_timestamps.py
Mentioned Here: T312984: Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis
T310437: Standardise type for timestamp columns in FlaggedRevs extension

Umherirrender triaged this task as Lowest priority.Jul 13 2022, 7:16 PM

Change 813839 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/software/schema-changes@master] Add fix_flaggedrevs_timestamps.py

Change 813839 merged by jenkins-bot:

[operations/software/schema-changes@master] Add fix_flaggedrevs_timestamps.py