https://bugzilla.wikimedia.org/show_bug.cgi?id=58650
Web browser: ---
Bug ID: 58650
Summary: Add user_ip fields to multiple flow tables on wmf's
extension1db
Product: Wikimedia
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: General/Unknown
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: ebernhard...@wikimedia.org
Classification: Unclassified
Mobile Platform: ---
Short description:
The current *_user_text fields are being replaced with nullable *_user_ip
fields containing the user_ip only for anonymous users. This first half of the
schema update adds the *_user_ip fields.
Which wikis are affected:
test, test2, and mediawiki. But the changes are only to tables
on the extension1 cluster's flowdb.
Which tables:
flow_workflow
flow_revision
flow_tree_revision
What is the change to those tables:
ALTER TABLE /*_*/flow_workflow ADD workflow_user_ip varbinary(39) default null;
ALTER TABLE /*_*/flow_tree_revision ADD tree_orig_user_ip varbinary(39) default
null;
ALTER TABLE /*_*/flow_revision
ADD rev_user_ip varbinary(39) default null,
ADD rev_mod_user_ip varbinary(39) default null,
ADD rev_edit_user_ip varbinary(39) default null;
Links to gerrit changes and/or other related bug reports.
https://gerrit.wikimedia.org/r/99789
These new columns are not queried directly, only selected as part of other
queries. They are 39 bytes to hold either ipv4 or ipv6 addresses formatted as
strings, same as they are displayed in the interface. They are superseding the
current *_user_text fields which will be dropped from the table after
migrations have run.
--
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
