手册:user_properties表

↑ 手冊:索引

MediaWiki数据库布局

user_properties table

MediaWiki版本：

≥ 1.16

user_properties表存储用户参数设置。

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.

字段

up_user

Foreign key to the user_id field of the user table.

up_property

The user preference, see 手册:$wgDefaultUserOptions . 例子： gender, rememberpassword, watchcreations

up_value

参数设置值。

架构摘要

MediaWiki版本：

≥ 1.30

DESCRIBE user_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版本：

1.18 – 1.29

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版本：

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