Manual:Slot roles table

The slot_roles table is a normalization table for role names, 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).

role_id
Primary key.

role_name
Description of the name of the role.

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