Handbuch:msg_resource-Tabelle
↑ Handbuch:Inhaltsübersicht | MediaWiki-Datenbank-Layout | msg_resource-Tabelle |
MediaWiki Versions: | 1.17 – 1.26 |
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. Siehe auch Handbuch:msg_resource_links-Tabelle .
Felder
mr_resource
Resource name.
mr_lang
Sprachcode.
mr_blob
JSON blob.
mr_timestamp
Timestamp of last update.
Schematische Übersicht
MediaWiki Versions: | 1.17 – 1.26 |
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 | | +--------------+----------------+------+-----+---------+-------+
Indexe
MediaWiki Versions: | 1.17 – 1.26 |
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 | | | +--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+