Manual:User properties table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

User properties table

This table stores user preferences. It replaces the old user.user_options blob. Only non-default settings are stored, so changes to the defaults are now reflected for everybody that hasn't saved an alternative preference, not only new accounts.

 +-------------+------------------+------+-----+---------+----------------+
 | Field       | Type             | Null | Key | Default | Extra          |
 +-------------+------------------+------+-----+---------+----------------+
 | up_user     | int(10) unsigned |      | UNI |         |                |
 | up_property | varbinary(32)    |      | MUL |         |                |
 | up_value    | blob             |      |     |         |                |
 +-------------+------------------+------+-----+---------+----------------+

[edit] Fields

up_user 

Foreign key to the user_id field of the user table.

up_property 

The user preference.

up_value 

The preference setting itself