https://bugzilla.wikimedia.org/show_bug.cgi?id=58196
Web browser: ---
Bug ID: 58196
Summary: user_properties table not available on tool labs
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: tools
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Classification: Unclassified
Mobile Platform: ---
Toolserver has a limited and anonimized view of the user_properties table
available. This is used for reports like
https://en.wikipedia.org/wiki/Wikipedia:Database_reports/User_preferences
mysql> describe user_properties;
+-------------+----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------+------+-----+---------+-------+
| up_user | int(11) | NO | | 0 | |
| up_property | varbinary(255) | YES | | NULL | |
| up_value | blob | YES | | NULL | |
+-------------+----------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> describe user_properties_anonym;
+-------------------------+----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------+----------------+------+-----+---------+-------+
| up_property | varbinary(255) | YES | | NULL | |
| up_value | blob | YES | | NULL | |
| ts_user_touched_cropped | varbinary(8) | NO | | | |
+-------------------------+----------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
Only preferences that are considered to be public are replicated, the list from
enwiki_p is:
mysql> select distinct(up_property) from user_properties;
+----------------+
| up_property |
+----------------+
| disablemail |
| fancysig |
| gender |
| language |
| nickname |
| skin |
| timecorrection |
| variant |
+----------------+
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
