Příručka:Databázová tabulka module_deps

From mediawiki.org
This page is a translated version of the page Manual:Module deps table and the translation is 31% complete.
Manuál:Obsah MediaWiki schéma databáze Tabulka module_deps
Verze MediaWiki:
1.17

The module_deps table is for caching which local files a skin/module depends on that aren't registered directly.

Currently used for tracking images and LESS files that Příručka:CSS depends on.

Pole

md_module

Module name

md_skin

Skin name

md_deps

JSON blob with file dependencies.

Contains absolute file paths, which are used to locate the according files. These paths will break when the wiki is e.g. moved to another folder or to another server.

Since MediaWiki 1.25 (phabricator:T37472), update.php now deletes the contents of the module_deps table, thus clearing the cache. For versions of MediaWiki which do not yet have this fix in update.php, the workaround is to manually delete the contents of the module_deps table.

Přehled změn ve schématu tabulky

Verze MediaWiki:
1.17

DESCRIBE module_deps;

+-----------+----------------+------+-----+---------+-------+
| Field     | Type           | Null | Key | Default | Extra |
+-----------+----------------+------+-----+---------+-------+
| md_module | varbinary(255) | NO   | PRI | NULL    |       |
| md_skin   | varbinary(32)  | NO   | PRI | NULL    |       |
| md_deps   | mediumblob     | NO   |     | NULL    |       |
+-----------+----------------+------+-----+---------+-------+

Indexy

Verze MediaWiki:
1.30

SHOW INDEX IN module_deps;

+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table       | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| module_deps |          0 | PRIMARY  |            1 | md_module   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| module_deps |          0 | PRIMARY  |            2 | md_skin     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+