Manual:Watchlist expiry table
| ↑ Manual:Contents | MediaWiki database layout | watchlist_expiry table |
| MediaWiki version: | ≥ 1.35 |
The watchlist_expiry table is where MediaWiki stores information about the expiry of watchlist items.
Fields
we_item
Key to watchlist.wl_id.
we_expiry
Expiry time as a MediaWiki timestamp.
Schema summary
| MediaWiki version: | ≥ 1.35 |
DESCRIBE watchlist_expiry;
+-----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+-------+ | we_item | int(10) unsigned | NO | PRI | NULL | | | we_expiry | binary(14) | NO | MUL | NULL | | +-----------+------------------+------+-----+---------+-------+
Indexes
| MediaWiki version: | ≥ 1.35 |
SHOW INDEX IN watchlist_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 | | | +------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
See also
- 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