MediaWiki version:
|
≥
1.31
|
The
slots
table represent an n:m relation between revisions and
content objects
.
A content object can have a specific "
role
" in one or more revisions.
Each revision can have multiple content objects, each having a different role.
The table 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).
Fields
[
edit
]
slot_revision_id
[
edit
]
Reference to
revision.rev_id
or
archive.ar_rev_id
.
slot_revision_id and slot_role_id together comprise the primary key.
slot_role_id
[
edit
]
Reference to
slot_roles.role_id
slot_content_id
[
edit
]
Reference to
content.content_id
slot_origin
[
edit
]
The
revision.rev_id
of the revision that originated the slot's content.
To find revisions that changed slots, look for slot_origin = slot_revision_id.
Schema
[
edit
]
MediaWiki version:
|
≥
1.31
|
DESCRIBE
slots
;
+------------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+----------------------+------+-----+---------+-------+
| slot_revision_id | bigint(20) unsigned | NO | PRI | NULL | |
| slot_role_id | smallint(5) unsigned | NO | PRI | NULL | |
| slot_content_id | bigint(20) unsigned | NO | | NULL | |
| slot_origin | bigint(20) unsigned | NO | | NULL | |
+------------------+----------------------+------+-----+---------+-------+
Indexes
[
edit
]
MediaWiki version:
|
≥
1.31
|
SHOW
INDEX
IN
slots
;
+-------+------------+---------------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+---------------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| slots | 0 | PRIMARY | 1 | slot_revision_id | A | 0 | NULL | NULL | | BTREE | | |
| slots | 0 | PRIMARY | 2 | slot_role_id | A | 0 | NULL | NULL | | BTREE | | |
| slots | 1 | slot_revision_origin_role | 1 | slot_revision_id | A | 0 | NULL | NULL | | BTREE | | |
| slots | 1 | slot_revision_origin_role | 2 | slot_origin | A | 0 | NULL | NULL | | BTREE | | |
| slots | 1 | slot_revision_origin_role | 3 | slot_role_id | A | 0 | NULL | NULL | | BTREE | | |
+-------+------------+---------------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|