Manual:Msg resource table/de

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.

mr_resource
Resource name.

mr_lang
Language code.

mr_blob
JSON blob.

mr_timestamp
Timestamp of last update.

Schematische Übersicht
+--++--+-+-+---+ +--++--+-+-+---+ +--++--+-+-+---+
 * 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
 +--++--+--+-+---+-+--++--++-+---+ +--++--+--+-+---+-+--++--++-+---+ +--++--+--+-+---+-+--++--++-+---+
 * 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      |         |               |