Manual:user_properties table

↑ 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.

Fields

up_user

Foreign key to the user_id field of the user table.

up_property

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

up_value

The preference value.

Schema summary

MediaWiki version:

≥ 1.30

DESCRIBEuser_properties;

+-------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+-------+ | up_user | int(10) unsigned | NO | PRI | NULL | | | up_property | varbinary(255) | NO | PRI | NULL | | | up_value | blob | YES | | NULL | | +-------------+------------------+------+-----+---------+-------+ 

MediaWiki versions:

1.18 – 1.29

DESCRIBEuser_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

DESCRIBEuser_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 | | +-------------+---------------+------+-----+---------+----------------+ 

Indexes

MediaWiki version:

≥ 1.36

SHOWINDEXINuser_properties;

+-----------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-----------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | user_properties | 0 | PRIMARY | 1 | up_user | A | 0 | NULL | NULL | | BTREE | | | | user_properties | 0 | PRIMARY | 2 | up_property | A | 0 | NULL | NULL | | BTREE | | | | user_properties | 1 | up_property | 1 | up_property | A | 0 | NULL | NULL | | BTREE | | | +-----------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+