Manual:slot_roles/cs table
From Linux Web Expert
| ↑ Manuál:Obsah | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>slot_roles/cs</tvar> table</translate> |
<translate> ≥</translate> 1.31
| <translate> MediaWiki version:</translate> |
The slot_roles table is a normalization table for role names. It is used by the slots table.
In PHP code, normalization is managed via NameTableStore.
It was introduced in MediaWiki 1.31 as part of the Multi-Content Revisions project; see Multi-Content Revisions/Content Meta-Data for details. During migration from older versions, the table is populated by populateContentTables.php (run automatically by the upgrade script).
Pole
role_id
Primární klíč.
role_name
Description of the name of the role.
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.36
| <translate> MediaWiki version:</translate> |
DESCRIBE slot_roles/cs;
+-----------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+----------------+ | role_id | int(11) | NO | PRI | NULL | auto_increment | | role_name | varbinary(64) | NO | UNI | NULL | | +-----------+---------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>">
1.31 – 1.35
| <translate> MediaWiki versions:</translate> |
DESCRIBE slot_roles/cs;
+-----------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+----------------+ | role_id | smallint(6) | NO | PRI | NULL | auto_increment | | role_name | varbinary(64) | NO | UNI | 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.31
| <translate> MediaWiki version:</translate> |
SHOW INDEX IN slot_roles/cs;
+------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | slot_roles | 0 | PRIMARY | 1 | role_id | A | 0 | NULL | NULL | | BTREE | | | | slot_roles | 0 | role_name | 1 | role_name | A | 0 | NULL | NULL | | BTREE | | | +------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
