Manual:User properties table

---

↑ 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

up_user

Foreign key to the user_id field of the userManual:User table table.

up_property

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

up_value

The preference value.

DatabasesManual:Database layout

Engines: MySQLManual:MySQL – OracleManual:Oracle – PostgreSQLManual:PostgreSQL – SQLiteManual:SQLite Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associations – Field prefixesDatabase field prefixes – Primary key storage in other fieldsManual:Primary key storage in other fields – Wikimedia extension tablesCategory:Wikimedia extension database tables Configuration: SettingsManual:Configuration_settings#Database_settings – SharingManual:Shared database Development: AccessManual:Database access – OptimizationDatabase optimization – PolicyDevelopment policy#Database_patches – UpdaterManual:DatabaseUpdater.php – Extension schema updatesManual:Hooks/LoadExtensionSchemaUpdates – Patch fileManual:SQL patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist