Manual:Content models table
| ↑ Manual:Contents | MediaWiki database layout | content_models table |
| MediaWiki version: | ≥ 1.31 |
The content_models table is a normalisation table for content model names. They are referenced from the content table.
In PHP code, normalisation 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).
Fields
model_id
Primary key.
model_name
To be documented.
Schema summary
| MediaWiki version: | ≥ 1.36 |
DESCRIBE content_models;
+------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------+------+-----+---------+----------------+ | model_id | int(11) | NO | PRI | NULL | auto_increment | | model_name | varbinary(64) | NO | UNI | NULL | | +------------+---------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.31 – 1.35 |
DESCRIBE content_models;
+------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------+------+-----+---------+----------------+ | model_id | smallint(6) | NO | PRI | NULL | auto_increment | | model_name | varbinary(64) | NO | UNI | NULL | | +------------+---------------+------+-----+---------+----------------+
Indexes
| MediaWiki version: | ≥ 1.31 |
SHOW INDEX IN content_models;
+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | content_models | 0 | PRIMARY | 1 | model_id | A | 0 | NULL | NULL | | BTREE | | | | content_models | 0 | model_name | 1 | model_name | A | 0 | NULL | NULL | | BTREE | | | +----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+Category:MediaWiki database tables#Content models%20table