Manual:user newtalk table

↑ 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.

Fields

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

MediaWiki version:

≥ 1.13

For getting diff since last view

Versions

(Current as of v1.20)

MediaWiki version:

≥ 1.19

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

MediaWiki version:

1.13

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

MediaWiki version:

1.12

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

MediaWiki version:

1.11

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

MediaWiki version:

1.10

MediaWiki version:

1.9

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

MediaWiki version:

1.8

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

Language:	English  • 日本語