Manual:slot_roles テーブル
↑ Manual:コンテンツ | MediaWiki のデータベース レイアウト | slot_roles テーブル |
MediaWiki バージョン: | ≧ 1.31 |
slot_roles テーブルはロール名の正規化テーブルです。 slots テーブルによって使用されます。
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
主キーです。
role_name
Description of the name of the role.
スキーマ
MediaWiki バージョン: | ≧ 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 バージョン: | 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 | | +-----------+---------------+------+-----+---------+----------------+
インデックス
MediaWiki バージョン: | ≧ 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 | | | +------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+