Manual:updatelog table

↑ Manual:Contents

MediaWiki database layout

updatelog table

MediaWiki version:

≥ 1.13

A table to log MediaWiki updates, one text key row per executed update script.

Fields

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).

Versions

(Current as of v1.22.)

MediaWiki version:

≥ 1.19

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

MediaWiki version:

1.18

DESCRIBE updatelog:

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

MediaWiki version:

1.13

DESCRIBE updatelog:

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

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist