Manual:Slot roles table/fr

La table slot_roles est une table de normalisation des noms de rôle. Elle est utilisée par la table.

In PHP code, normalization is managed via.

It was introduced in MediaWiki 1.31 as part of the project; see  for details. During migration from older versions, the table is populated by (run automatically by the upgrade script).

role_id
Clé primaire.

role_name
Description du nom de rôle.

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

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

Les index
 +++---+--+-+---+-+--++--++-+---+ +++---+--+-+---+-+--++--++-+---+ +++---+--+-+---+-+--++--++-+---+
 * 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      |         |               |