Manual:user properties table
From MediaWiki.org
| ↑ Manual:Contents | MediaWiki database layout | user properties table |
Contents |
| 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.
| MediaWiki version: | ≥ 1.16 |
+-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | up_user | int(10) unsigned | | UNI | | | | up_property | varbinary(255) | | MUL | | | | up_value | blob | | | | | +-------------+------------------+------+-----+---------+----------------+
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.
| Language: | English • polski |
|---|
