Manual:Tabella de segmentos

This page is a translated version of the page Manual:Slots table and the translation is 81% complete.

MediaWiki database layout

slots table

MediaWiki version:

≥ 1.31

Le tabella slots (segmentos) representa un relation n:m inter versiones e objectos de contento. Un objecto de contento pote haber un "rolo" specific in un o plus versiones. Cata version pote haber plure objectos de contento, cata un del quales ha un rolo differente.

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).

Campos

slot_revision_id

Referentia a revision.rev_id o archive.ar_rev_id. slot_revision_id e slot_role_id insimul constitue le clave primari.

slot_role_id

Referentia a slot_roles.role_id

slot_content_id

Referentia a content.content_id

slot_origin

Le revision.rev_id del version que ha originate le contento del segmento. Pro trovar versiones que ha cambiate segmentos, cerca slot_origin = slot_revision_id.

Schema

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

Indices

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