Manual:Module deps table

Manual:Contents MediaWiki database layout module_deps table
MediaWiki version:
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 CSS depends on.

Fields

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.

Schema summary

MediaWiki version:
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    |       |
+-----------+----------------+------+-----+---------+-------+

Indexes

MediaWiki version:
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      |         |               |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+