Manual:User newtalk table

user_newtalk table stores notifications of user talk page changes, for the display of the "you have new messages" box.

user_id
Key to user.user_id.

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

user_last_timestamp
For getting diff since last view

Versions
(Current as of v1.20)

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