Handbuch:slot_roles-Tabelle

From mediawiki.org
This page is a translated version of the page Manual:Slot roles table and the translation is 75% complete.
Other languages:
Handbuch:Inhaltsübersicht MediaWiki-Datenbank-Layout slot_roles-Tabelle
MediaWiki Version:
1.31

The slot_roles table is a normalization table for role names. Es wird von der slots -Tabelle verwendet.

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

Felder

role_id

Primärschlüssel.

role_name

Description of the name of the role.

Schema

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

Indexe

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