Manual:slot_roles table

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).

Primary key.

Description of the name of the role.

DESCRIBEslot_roles;

+-----------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------+----------------+
| role_id | int(11) | NO | PRI | NULL | auto_increment |
| role_name | varbinary(64) | NO | UNI | NULL | |
+-----------+---------------+------+-----+---------+----------------+

DESCRIBEslot_roles;

+-----------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------+----------------+
| role_id | smallint(6) | NO | PRI | NULL | auto_increment |
| role_name | varbinary(64) | NO | UNI | NULL | |
+-----------+---------------+------+-----+---------+----------------+

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

• MediaWiki database tables