Wikimedia Bugzilla is closed!

Short description:

When we moved *_user_text stuff to *_user_ip, we never actually
got rid of *_user_text columns in the DB.
These columns still exist, though they shouldn't. Especially
flow_workflow.workflow_user_text, which is NOT NULL, but is now
always fed null values.
It seems that production etc. is tolerant and still lets our
inserts in, but we should definitely get rid of those columns.

Which wikis are affected:

flowdb on extension1db

Which tables:

flow_workflow, flow_tree_revision, flow_revision

What is the change to those tables:

ALTER TABLE /*_*/flow_workflow DROP workflow_user_text;

ALTER TABLE /*_*/flow_tree_revision DROP tree_orig_user_text;

ALTER TABLE /*_*/flow_revision
       DROP rev_user_text,
       DROP rev_mod_user_text,
       DROP rev_edit_user_text;

Links to gerrit changes and/or other related bug reports.

https://gerrit.wikimedia.org/r/#/c/135576/3