Handbuch:watchlist_expiry-Tabelle
| ↑ Handbuch:Inhaltsübersicht | MediaWiki-Datenbank-Layout | watchlist_expiry-Tabelle |
| MediaWiki Version: | ≥ 1.35 |
The watchlist_expiry table is where MediaWiki stores information about the expiry of watchlist items.
Felder
we_item
Schlüssel zu watchlist.wl_id.
we_expiry
Expiry time as a MediaWiki timestamp.
Schematische Übersicht
| 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 | | +-----------+------------------+------+-----+---------+-------+
Indexe
| 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 | | | +------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
Siehe auch
- Manual:purgeExpiredWatchlistItems.php – maintenance script for deleting expired items from the watchlist_expiry and watchlist tables.
- Handbuch:$wgWatchlistExpiry
- Handbuch:$wgWatchlistPurgeRate
- Handbuch:$wgWatchlistExpiryMaxDuration
- Help:Watchlist expiry