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.

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

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

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

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

Zobacz też

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