Manual:Tabla watchlist

From MediaWiki.org
Jump to: navigation, search
This page is a translated version of the page Manual:Watchlist table and the translation is 15% complete.

Other languages:
English • ‎español • ‎日本語 • ‎polski
Manual:ContenidoManual:Contents MediaWiki database layoutManual:Database layout watchlist table/es


The watchlist table for each registered user contains his or her id and for all the pages the user watches, the namespace number, the page title without namespace, and a notification timestamp, used for page change notification.

Note: MediaWiki works with the assumption that when people watch pages they either watch both the talk page and the normal page, or neither. That means that for each watched page MediaWiki always automatically adds two entries: One for the page and one for its talk page. E.g. when the user watches the Main Page, then there will be two rows in the database table: One for the Main Page in namespace 0 and one for the Main Page in namespace 1 (which is the according talk page). Missing page rows are added by the maintenance script update.php.

Campos[edit]

wl_id[edit]

Versión de MediaWiki: 1.27

This is the primary key for the table.

wl_user[edit]

This is the key to user.user_idManual:User_table#user_id.

wl_namespace[edit]

This is the key to page_namespacePage_table#page_namespace.

wl_title[edit]

This is the key to page_titlePage_table#page_title.

wl_notificationtimestamp[edit]

Versión de MediaWiki: 1.4

This is the timestamp of the first change to the page made by another user after the last visit by the watching user; the timestamp is cleared when the user visits the page. When the timestamp is updated, notification email may be sent.

The timestamp is always cleared (made NULL) when the user visits the page, whatever their personal settings, as long as either either of $wgUseEnotif or $wgShowUpdatedMarker is true.


Versión de MediaWiki: 1.26

Since git #836ad263, the timestamp update may be deferred to the job queue.

Schema summary[edit]

Versión de MediaWiki: 1.27

DESCRIBE watchlist;

+--------------------------+---------------------+------+-----+---------+----------------+
| Field                    | Type                | Null | Key | Default | Extra          |
+--------------------------+---------------------+------+-----+---------+----------------+
| wl_id                    | int(10) unsigned    | NO   | PRI | NULL    | AUTO_INCREMENT |
| wl_user                  | int(10) unsigned    | NO   | MUL | NULL    |                |
| wl_namespace             | int(11)             | NO   | MUL | 0       |                |
| wl_title                 | varchar(255) binary | NO   |     | NULL    |                |
| wl_notificationtimestamp | varbinary(14)       | YES  |     | NULL    |                |
+--------------------------+---------------------+------+-----+---------+----------------+


Versiones de MediaWiki: 1.10 – 1.26

DESCRIBE watchlist;

+--------------------------+---------------------+------+-----+---------+-------+
| Field                    | Type                | Null | Key | Default | Extra |
+--------------------------+---------------------+------+-----+---------+-------+
| wl_user                  | int(10) unsigned    | NO   | PRI | NULL    |       |
| wl_namespace             | int(11)             | NO   | PRI | 0       |       |
| wl_title                 | varchar(255) binary | NO   | PRI | NULL    |       |
| wl_notificationtimestamp | varbinary(14)       | YES  |     | NULL    |       |
+--------------------------+---------------------+------+-----+---------+-------+


Versiones de MediaWiki: 1.6 – 1.9

DESCRIBE watchlist;

+--------------------------+---------------------+------+-----+---------+-------+
| Field                    | Type                | Null | Key | Default | Extra |
+--------------------------+---------------------+------+-----+---------+-------+
| wl_user                  | int(5) unsigned     | NO   | PRI | NULL    |       |
| wl_namespace             | int(11)             | NO   | PRI | 0       |       |
| wl_title                 | varchar(255) binary | NO   | PRI | NULL    |       |
| wl_notificationtimestamp | varchar(14) binary  | YES  |     | NULL    |       |
+--------------------------+---------------------+------+-----+---------+-------+


Versión de MediaWiki: 1.5

DESCRIBE watchlist;

+--------------------------+---------------------+------+-----+---------+-------+
| Field                    | Type                | Null | Key | Default | Extra |
+--------------------------+---------------------+------+-----+---------+-------+
| wl_user                  | int(5) unsigned     | NO   | PRI | NULL    |       |
| wl_namespace             | int(11)             | NO   | PRI | 0       |       |
| wl_title                 | varchar(255) binary | NO   | PRI | NULL    |       |
| wl_notificationtimestamp | varchar(14) binary  | NO   |     | NULL    |       |
+--------------------------+---------------------+------+-----+---------+-------+


Versiones de MediaWiki: 1.1 – 1.4

DESCRIBE watchlist;

+--------------+---------------------+------+-----+---------+-------+
| Field        | Type                | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| wl_user      | int(5) unsigned     | NO   | PRI | NULL    |       |
| wl_namespace | tinyint(2) unsigned | NO   | PRI | 0       |       |
| wl_title     | varchar(255) binary | NO   | PRI | NULL    |       |
+--------------+---------------------+------+-----+---------+-------+

Some of this information was adapted from schema.doc in the MediaWiki docs/ directory.

Bases de datosManual:Database layout Motores: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

Documentación técnica: EsquemaManual:Database layout (tablasCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuración: ConfiguracionesManual:Configuration_settings#Database_settingsCompartirManual:Shared database
Desarrollo: AccesoManual:Database accessOptimizaciónDatabase optimizationNormativaDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file

Core tables: archivebot_passwordscategorycategorylinkschange_tagcommentconfigexternallinksfilearchivehitcounterimageimagelinksimage_comment_tempinterwikiiwlinksipblocksip_changesjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionrevision_comment_tempsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist