Manual:watchlist_expiry table

The watchlist_expiry table is where MediaWiki stores information about the expiry of watchlist items.

Key to watchlist.wl_id.

Expiry time as a MediaWiki timestamp.

DESCRIBEwatchlist_expiry;

+-----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| we_item | int(10) unsigned | NO | PRI | NULL | |
| we_expiry | binary(14) | NO | MUL | NULL | |
+-----------+------------------+------+-----+---------+-------+

SHOWINDEXINwatchlist_expiry;

+------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| watchlist_expiry | 0 | PRIMARY | 1 | we_item | A | 0 | NULL | NULL | | BTREE | | |
| watchlist_expiry | 1 | we_expiry | 1 | we_expiry | A | 0 | NULL | NULL | | BTREE | | |
+------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

• Manual:PurgeExpiredWatchlistItems.php – maintenance script for deleting expired items from the watchlist_expiry and watchlist tables.
• Manual:$wgWatchlistExpiry
• Manual:$wgWatchlistPurgeRate
• Manual:$wgWatchlistExpiryMaxDuration
• Help:Watchlist expiry

• MediaWiki database tables
• Everything to do with watchlists