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.

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 userManual:User table table.

up_property[edit]

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

up_value[edit]

The preference value.

DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

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: archivebot_passwordscategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist