Manual:watchlist_expiry table

↑ Manual:Contents

<translate> MediaWiki database layout</translate>

<translate> <tvar name=1>watchlist_expiry</tvar> table</translate>

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.35

<translate> MediaWiki version:</translate>

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

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.35

<translate> MediaWiki version:</translate>

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

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.35

<translate> MediaWiki version:</translate>

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