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**:
https://bugzilla.wikimedia.org/show_bug.cgi?id=25302
https://bugzilla.wikimedia.org/show_bug.cgi?id=19288