Manual:Watchlist table/pl

Tabela watchlist zawiera numery id obserwowanych stron użytkowników, numer przestrzeni nazw, tytuł strony bez przestrzeni nazw oraz datę, używaną do powiadomień o zmianach na stronie.

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.

wl_id
This is the primary key for the table.

wl_user
This is the key to.

wl_namespace
This is the key to.

wl_title
This is the key to.

wl_notificationtimestamp
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.

Since, the timestamp update may be deferred to the job queue.

Poprzednie wersje
(Current as of v1.27.)

mysql> 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                | varbinary(255)   | NO   |     |         |                |
 * wl_notificationtimestamp | varbinary(14)   | YES  |     | NULL    |                |

mysql> DESCRIBE mw_watchlist; +--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+ 4 rows in set (0.00 sec)
 * Field                   | Type             | Null | Key | Default | Extra |
 * wl_user                 | int(10) unsigned | NO   | PRI | NULL    |       |
 * wl_namespace            | int(11)          | NO   | PRI | 0       |       |
 * wl_title                | varbinary(255)   | NO   | PRI |         |       |
 * wl_notificationtimestamp | varbinary(14)   | YES  |     | NULL    |       |

mysql> describe watchlist; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+ 4 rows in set (0.01 sec)
 * 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)    | NO   | PRI | NULL    |       |
 * wl_notificationtimestamp | varchar(14)    | YES  |     | NULL    |       |

mysql> 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)    | NO   | PRI | NULL    |       |
 * wl_notificationtimestamp | varchar(14)    | YES  |     | NULL    |       |

mysql> describe watchlist; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field                   | Type            | Null | Key | Default | Extra |
 * wl_user                 | int(5) unsigned | NO   | PRI |         |       |
 * wl_namespace            | int(11)         | NO   | PRI | 0       |       |
 * wl_title                | varchar(255)    | NO   | PRI |         |       |
 * wl_notificationtimestamp | varchar(14)    | NO   |     | 0       |       |

mysql> describe watchlist; +--+-+--+-+-++ +--+-+--+-+-++ +--+-+--+-+-++ Część informacji znajduje się w pliku  w katalogu MediaWiki:  
 * Field           | Type                | Null | Key | Default | Extra          |
 * wl_user         | int(5) unsigned     |      |     |         |                |
 * wl_namespace    | tinyint(2) unsigned |      |     |    0    |                |
 * wl_title        | varchar(255) binary |      |     |    ''   |                |