Manual:User newtalk table

user_newtalk table stores the IDs or IP addresses of users whose talk pages have been changed. This information is used for the display of the "you have new messages" box. The respective row is deleted when the user looks at the page.

user_id
Key to user.user_id or "0" for anonymous users.

user_ip
If the user is an anonymous user his IP address is stored here since the user_id of 0 is ambiguous.

user_last_timestamp
Timestamp for getting the difference since last view.

Versions
(Current as of v1.22)

+-+---+--+-+-+---+ +-+---+--+-+-+---+ +-+---+--+-+-+---+
 * Field              | Type          | Null | Key | Default | Extra |
 * user_id            | int(11)       | NO   | MUL | 0       |       |
 * user_ip            | varbinary(40) | NO   | MUL |         |       |
 * user_last_timestamp | varbinary(14) | YES |     | NULL    |       |

describe user_newtalk; in version 1.13: +-+---+--+-+-+---+ +-+---+--+-+-+---+ +-+---+--+-+-+---+
 * Field              | Type          | Null | Key | Default | Extra |
 * user_id            | int(11)       | NO   | MUL | 0       |       |
 * user_ip            | varbinary(40) | NO   | MUL |         |       |
 * user_last_timestamp | binary(14)   | NO   |     |         |       |

describe user_newtalk; in version 1.12: +-+-+--+-+-+---+ +-+-+--+-+-+---+ +-+-+--+-+-+---+
 * Field  | Type        | Null | Key | Default | Extra |
 * user_id | int(5)     | NO   | MUL | 0       |       |
 * user_ip | varchar(40) | NO  | MUL | NULL    |       |

describe user_newtalk; in version 1.11: +-+-+--+-+-+---+ +-+-+--+-+-+---+ +-+-+--+-+-+---+
 * Field  | Type        | Null | Key | Default | Extra |
 * user_id | int(11)    | NO   | MUL | 0       |       |
 * user_ip | varbinary(40)| NO | MUL | NULL    |       |

describe user_newtalk; in versions 1.9 and 1.10: +-+-+--+-+-+---+ +-+-+--+-+-+---+ +-+-+--+-+-+---+
 * Field  | Type        | Null | Key | Default | Extra |
 * user_id | int(5)     | NO   | MUL | 0       |       |
 * user_ip | varchar(40) | NO  | MUL | NULL    |       |

describe user_newtalk; in version 1.8: +-+-+--+-+-+---+ +-+-+--+-+-+---+ +-+-+--+-+-+---+
 * Field  | Type        | Null | Key | Default | Extra |
 * user_id | int(5)     | NO   | MUL | 0       |       |
 * user_ip | varchar(40) | NO  | MUL | NULL    |       |