Manual:User newtalk table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

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

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