Manual:Watchlist expiry table/en

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

we_item
Key to.

we_expiry
Expiry time as a MediaWiki timestamp.

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

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