Manual:Updatelog table/en

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

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
Serialized data of the logged action; not present for old entries (pre 1.17).

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

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

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