Manual:updatelog table

The updatelog table logs MediaWiki updates, one text key row per executed update script.

Pointer to a maintenance script, which was executed during a MediaWiki update. For update.php, entries are formatted like updatelist-1.22.3-1393593680. The pointer to the maintenance script contains the MediaWiki version and a UNIX timestamp.

Serialized data of the logged action; not present for old entries (pre 1.17).

DESCRIBEupdatelog;

+----------+----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+----------------+------+-----+---------+-------+
| ul_key | varbinary(255) | NO | PRI | NULL | |
| ul_value | blob | YES | | NULL | |
+----------+----------------+------+-----+---------+-------+

DESCRIBEupdatelog;

+--------+----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+----------------+------+-----+---------+-------+
| ul_key | varbinary(255) | NO | PRI | NULL | |
+--------+----------------+------+-----+---------+-------+

SHOWINDEXINupdatelog;

+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| 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 | | |
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

• MediaWiki database tables