Manual:User properties table

↑ Manual:Contents

MediaWiki database layout

User properties table

MediaWiki version:

≥ 1.16

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.

MediaWiki version:

1.16

and newer

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

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

Language:	English  • Polski