Manual:user_properties table

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.

Foreign key to the user_id field of the user table.

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

The preference value.

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

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

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

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

• MediaWiki database tables