Manual:user_properties table

From MediaWiki.org
Jump to navigation Jump to search

Other languages:
Deutsch • ‎English • ‎español • ‎français • ‎polski • ‎中文 • ‎日本語
Manual:Contents MediaWiki database layout user_properties table


MediaWiki version: 1.16

The user_properties 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.

Schema summary[edit]

MediaWiki version: 1.18

DESCRIBE user_properties;

+-------------+----------------+------+-----+---------+----------------+
| Field       | Type           | Null | Key | Default | Extra          |
+-------------+----------------+------+-----+---------+----------------+
| up_user     | int(11)        | NO   | PRI | NULL    |                |
| up_property | varbinary(255) | NO   | PRI | NULL    |                |
| up_value    | blob           | YES  |     | NULL    |                |
+-------------+----------------+------+-----+---------+----------------+
MediaWiki versions: 1.16 – 1.17

DESCRIBE user_properties;

+-------------+---------------+------+-----+---------+----------------+
| Field       | Type          | Null | Key | Default | Extra          |
+-------------+---------------+------+-----+---------+----------------+
| up_user     | int(11)       | NO   | PRI | NULL    |                |
| up_property | varbinary(32) | NO   | PRI | NULL    |                |
| up_value    | blob          | YES  |     | NULL    |                |
+-------------+---------------+------+-----+---------+----------------+

Fields[edit]

up_user[edit]

Foreign key to the user_id field of the user table.

up_property[edit]

The user preference, see Manual:$wgDefaultUserOptions . Examples: gender, rememberpassword, watchcreations

up_value[edit]

The preference value.