Manual:Watchlist table/ja

watchlist テーブルは、各登録利用者の ID とその利用者がウォッチしているすべてのページの利用者の、名前空間 ID、名前空間を除いたページ名、通知のタイムスタンプを格納します. ページの変更の通知に使用されます.

wl_id
This is the primary key for the table.

wl_user
これは へのキーです.

wl_namespace
これは へのキーです.

wl_title
これは へのキーです.

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.

スキーマの概要
+--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++
 * 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      |         |               |

関連項目

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