Manual:slot_roles table
| MediaWiki version: | ≥ 1.31 |
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).
Fields
[edit]role_id
[edit]Primary key.
role_name
[edit]Description of the name of the role.
Schema
[edit]| MediaWiki version: | ≥ 1.36 |
DESCRIBE slot_roles;
+-----------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+----------------+ | role_id | int(11) | NO | PRI | NULL | auto_increment | | role_name | varbinary(64) | NO | UNI | NULL | | +-----------+---------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.31 – 1.35 |
DESCRIBE slot_roles;
+-----------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+----------------+ | role_id | smallint(6) | NO | PRI | NULL | auto_increment | | role_name | varbinary(64) | NO | UNI | NULL | | +-----------+---------------+------+-----+---------+----------------+
Indexes
[edit]| MediaWiki version: | ≥ 1.31 |
SHOW INDEX IN slot_roles;
+------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+