Manual:User properties table

From MediaWiki.org
Jump to: navigation, search

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



MediaWiki version: 1.16

The user_properties table stores user preferences. It replaces the old user.user_optionsManual:User table 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 userManual:User table table.

up_property[edit | edit source]

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

up_value[edit | edit source]

The preference value.

DatabasesManual:Database layout Engines: MySQLManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLite
Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file
Core tables: archivecategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiesvalid_tagwatchlist