Manual:Watchlist expiry table/cs

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

we_item
Klíčováno na.

we_expiry
Expiry time as a MediaWiki timestamp.



Přehled změn ve schématu tabulky
+---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field    | Type             | Null | Key | Default | Extra |
 * we_item  | int(10) unsigned | NO   | PRI | NULL    |       |
 * we_expiry | binary(14)      | NO   | MUL | NULL    |       |

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



Viz též

 * – maintenance script for deleting expired items from the watchlist_expiry and watchlist tables.