Manual:user properties table

From MediaWiki.org
Jump to: navigation, search


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.


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 | edit source]

up_user[edit | edit source]

Foreign key to the user_id field of the user table.

up_property[edit | edit source]

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

up_value[edit | edit source]

The preference value.

Databases Engines: MySQLOraclePostgreSQLSQLite
Technical documentation: Schema (tables) – API property associationsField prefixesPrimary key storage in other fieldsWikimedia extension tables
Configuration: SettingsSharing
Development: AccessOptimizationPolicyUpdaterExtension schema updatesPatch file
Core tables: archivecategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiesvalid_tagwatchlist
Language: English  • polski