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 |
Version: unspecified
Severity: major
See Also: