https://bugzilla.wikimedia.org/show_bug.cgi?id=66082
Bug ID: 66082
Summary: Drop *_user_text fields in Flow
Product: Wikimedia
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: General/Unknown
Assignee: [email protected]
Reporter: [email protected]
Web browser: ---
Mobile Platform: ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
