Manual:slots table
Jump to navigation
Jump to search
↑ Manual:Contents | MediaWiki database layout | slots table |
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.
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 | | +------------------+----------------------+------+-----+---------+-------+