Manual:Watchlist table/hu

The watchlist table for each registered user contains their 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.

wl_id
This is the primary key for the table.

wl_user
Ez a kulcsa.

wl_namespace
Ez a kulcsa.

wl_title
Ez a kulcsa.

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 of or  is true.

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



Séma összefoglalója
+--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++
 * 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    |                |

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

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

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

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

Indexek
 +---++---+--+--+---+-+--++--++-+---+ +---++---+--+--+---+-+--++--++-+---+ +---++---+--+--+---+-+--++--++-+---+
 * Table    | Non_unique | Key_name                      | Seq_in_index | Column_name              | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * watchlist |         0 | PRIMARY                       |            1 | wl_id                    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * watchlist |         0 | wl_user                       |            1 | wl_user                  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * watchlist |         0 | wl_user                       |            2 | wl_namespace             | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * watchlist |         0 | wl_user                       |            3 | wl_title                 | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * watchlist |         1 | wl_namespace_title            |            1 | wl_namespace             | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * watchlist |         1 | wl_namespace_title            |            2 | wl_title                 | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * watchlist |         1 | wl_user_notificationtimestamp |            1 | wl_user                  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * watchlist |         1 | wl_user_notificationtimestamp |            2 | wl_notificationtimestamp | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |



Lásd még

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