Handbuch:updatelog-Tabelle
Appearance
↑ Handbuch:Inhaltsübersicht | MediaWiki-Datenbank-Layout | updatelog-Tabelle |
MediaWiki Version: | ≥ 1.13 |
The updatelog table logs MediaWiki updates, one text key row per executed update script.
Felder
ul_key
Pointer to a maintenance script, which was executed during a MediaWiki update. For update.php entries are formatted like updatelist-1.22.3-1393593680. Pointer to the maintenance script, MediaWiki version and timestamp in UNIX time.
ul_value
MediaWiki Version: | ≥ 1.17 |
Serialized data of the logged action; not present for old entries (pre 1.17).
Schematische Übersicht
MediaWiki Version: | ≥ 1.17 |
DESCRIBE updatelog;
+----------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------------+------+-----+---------+-------+ | ul_key | varbinary(255) | NO | PRI | NULL | | | ul_value | blob | YES | | NULL | | +----------+----------------+------+-----+---------+-------+
MediaWiki Versions: | 1.13 – 1.16 |
DESCRIBE updatelog;
+--------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+----------------+------+-----+---------+-------+ | ul_key | varbinary(255) | NO | PRI | NULL | | +--------+----------------+------+-----+---------+-------+
Indexe
MediaWiki Version: | ≥ 1.13 |
SHOW INDEX IN updatelog;
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | updatelog | 0 | PRIMARY | 1 | ul_key | A | 0 | NULL | NULL | | BTREE | | | +-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+