Manual:Watchlist table

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

wl_user
This is the key to user.user_id.

wl_namespace
This is the key to page_namespace.

wl_title
This is the key to page_title.

wl_notificationtimestamp
This is the timestamp when the user was last sent a notification e-mail; it is cleared when the user visits the page.

Schema summary
(Current as of v1.20.)

"DESCRIBE watchlist;" in version 1.16 gives the following: 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    |       |

"DESCRIBE watchlist;" in version 1.8 gives the following:

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

"DESCRIBE watchlist;" in version 1.5 gives the following:

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

"DESCRIBE watchlist;" in version 1.4 gives the following:

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

Some of this information was adapted from  in the MediaWiki   directory.