Manual:msg_resource table
From Linux Web Expert
| ↑ Manual:Contents | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>msg_resource</tvar> table</translate> |
1.17 – 1.26
| <translate> MediaWiki versions:</translate> |
The msg_resource table was a table used to cache JSON message blobs for the resource loader. Its content can be deleted and excluded from backups as it will be regenerated when needed. See also Manual:Msg resource links table.
Field
mr_resource
Resource name.
mr_lang
Language code.
mr_blob
JSON blob.
mr_timestamp
Timestamp of last update.
Schema summary
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.26</tvar> is unsupported version</translate>"> 1.17 – 1.26
| <translate> MediaWiki versions:</translate> |
DESCRIBE msg_resource;
+--------------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+----------------+------+-----+---------+-------+ | mr_resource | varbinary(255) | NO | PRI | NULL | | | mr_lang | varbinary(32) | NO | PRI | NULL | | | mr_blob | mediumblob | NO | | NULL | | | mr_timestamp | binary(14) | NO | | NULL | | +--------------+----------------+------+-----+---------+-------+
Indexes
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.26</tvar> is unsupported version</translate>"> 1.17 – 1.26
| <translate> MediaWiki versions:</translate> |
SHOW INDEX IN msg_resource;
+--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | msg_resource | 0 | mr_resource_lang | 1 | mr_resource | A | 0 | NULL | NULL | | BTREE | | | | msg_resource | 0 | mr_resource_lang | 2 | mr_lang | A | 0 | NULL | NULL | | BTREE | | | +--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
