Manual:Watchlist expiry table/pt-br
Outdated translations are marked like this.
| ↑ Manual:Conteúdos | Leiaute do banco de dados do MediaWiki | watchlist_expiry table |
| Versão MediaWiki: | ≥ 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
| Versão MediaWiki: | ≥ 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
| Versão MediaWiki: | ≥ 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 | | | +------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
Ver também
- Manual:purgeExpiredWatchlistItems.php – script de manutenção para excluir itens expirados do watchlist_expiry e tabelas de lista de observação.
- Manual:$wgWatchlistExpiry
- Manual:$wgWatchlistPurgeRate
- Manual:$wgWatchlistExpiryMaxDuration
- Help:Watchlist expiry