Manual:content_models/cs table
From Linux Web Expert
| ↑ Manuál:Obsah | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>content_models/cs</tvar> table</translate> |
<translate> ≥</translate> 1.31
| <translate> MediaWiki version:</translate> |
Tabulka content_models je normalizační tabulka pro názvy modelů obsahu. Odkazují se na ně z tabulky content.
V PHP kódu je normalizace spravována přes NameTableStore.
Byl představen v MediaWiki 1.31 jako součást projektu Multi-Content Revisions. Podrobnosti viz Multi-Content Revisions/Content Meta-Data. Během migrace ze starších verzí je tabulka naplněna populateContentTables.php (spouští se automaticky skriptem aktualizace).
Pole
model_id
Primární klíč.
model_name
To be documented.
Přehled změn ve schématu tabulky
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.36
| <translate> MediaWiki version:</translate> |
DESCRIBE content_models/cs;
+------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------+------+-----+---------+----------------+ | model_id | int(11) | NO | PRI | NULL | auto_increment | | model_name | varbinary(64) | NO | UNI | NULL | | +------------+---------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>">
1.31 – 1.35
| <translate> MediaWiki versions:</translate> |
DESCRIBE content_models/cs;
+------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------+------+-----+---------+----------------+ | model_id | smallint(6) | NO | PRI | NULL | auto_increment | | model_name | varbinary(64) | NO | UNI | NULL | | +------------+---------------+------+-----+---------+----------------+
Indexy
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.31
| <translate> MediaWiki version:</translate> |
SHOW INDEX IN content_models/cs;
+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
