From MediaWiki.org
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
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 | |
+---------+-------------+------+-----+---------+-------+
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.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 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.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 | | | |
+---------------------+---------------+------+-----+---------+-------+