Manual:user_properties/cs table
From Linux Web Expert
| ↑ Manuál:Obsah | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>user_properties/cs</tvar> table</translate> |
| Verze MediaWiki: | <translate> ≥</translate> 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.
Pole
up_user
Foreign key to the user_id field of the user table.
up_property
The user preference, see Příručka:$wgDefaultUserOptions.
Examples: gender, watchcreations
up_value
The preference value.
Přehled změn ve schématu tabulky
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.30
| <translate> MediaWiki version:</translate> |
DESCRIBE user_properties/cs;
+-------------+------------------+------+-----+---------+-------+ | 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 | | +-------------+------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.29</tvar> is unsupported version</translate>">
1.18 – 1.29
| <translate> MediaWiki versions:</translate> |
DESCRIBE user_properties/cs;
+-------------+----------------+------+-----+---------+-------+ | 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 | | +-------------+----------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.17</tvar> is unsupported version</translate>">
1.16 – 1.17
| <translate> MediaWiki versions:</translate> |
DESCRIBE user_properties/cs;
+-------------+---------------+------+-----+---------+----------------+ | 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 | | +-------------+---------------+------+-----+---------+----------------+
Indexy
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.36
| <translate> MediaWiki version:</translate> |
SHOW INDEX IN user_properties/cs;
+-----------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +-----------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
