手册:Msg resource table
↑ 手册:索引 | MediaWiki数据库布局 | msg_resource表 |
MediaWiki版本: | 1.17 – 1.26 |
The msg_resource table was a table used to cache JSON message blobs for the resource loader. 其內容可以刪除並將其從備份中排除,因為它將會在需要時重新生成。 参见Manual:Msg resource links table 。
字段
mr_resource
资源名
mr_lang
语言代码
mr_blob
JSON blob.
mr_timestamp
上次更新的时间戳
架构摘要
MediaWiki版本: | 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 | | +--------------+----------------+------+-----+---------+-------+
索引
MediaWiki版本: | 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 | | | +--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+