Manual:user_newtalk table
↑ Manual:Contents | MediaWiki database layout | user_newtalk table |
The 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.
Fields edit
user_id edit
Key to user.user_id or "0" for anonymous users.
user_ip edit
If the user is an anonymous user their IP address is stored here since the user_id of 0 is ambiguous.
user_last_timestamp edit
MediaWiki version: | ≥ 1.13 |
Timestamp for getting the difference since last view.
Schema summary edit
MediaWiki version: | ≥ 1.36 |
DESCRIBE user_newtalk;
+---------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+-------+ | user_id | int(10) unsigned | NO | MUL | 0 | | | user_ip | varbinary(40) | NO | | | | | user_last_timestamp | binary(14) | YES | | NULL | | +---------------------+------------------+------+-----+---------+-------+
MediaWiki versions: | 1.25 – 1.35 |
DESCRIBE user_newtalk;
+---------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+-------+ | user_id | int(10) unsigned | NO | MUL | 0 | | | user_ip | varbinary(40) | NO | MUL | | | | user_last_timestamp | varbinary(14) | YES | | NULL | | +---------------------+------------------+------+-----+---------+-------+
MediaWiki versions: | 1.18 – 1.24 |
DESCRIBE user_newtalk;
+---------------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+---------------+------+-----+---------+-------+ | user_id | int(11) | NO | MUL | 0 | | | user_ip | varbinary(40) | NO | MUL | NULL | | | user_last_timestamp | varbinary(14) | YES | | NULL | | +---------------------+---------------+------+-----+---------+-------+
MediaWiki versions: | 1.13 – 1.17 |
DESCRIBE user_newtalk;
+---------------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+---------------+------+-----+---------+-------+ | user_id | int(11) | NO | MUL | 0 | | | user_ip | varbinary(40) | NO | MUL | NULL | | | user_last_timestamp | binary(14) | NO | | NULL | | +---------------------+---------------+------+-----+---------+-------+
MediaWiki versions: | 1.10 – 1.12 |
DESCRIBE user_newtalk;
+---------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------+------+-----+---------+-------+ | user_id | int(11) | NO | MUL | 0 | | | user_ip | varbinary(40) | NO | MUL | NULL | | +---------+---------------+------+-----+---------+-------+
MediaWiki versions: | 1.1 – 1.9 |
DESCRIBE user_newtalk;
+---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | user_id | int(5) | NO | MUL | 0 | | | user_ip | varchar(40) | NO | MUL | NULL | | +---------+-------------+------+-----+---------+-------+
Indexes edit
MediaWiki version: | ≥ 1.15 |
SHOW INDEX IN user_newtalk;
+--------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +--------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | user_newtalk | 1 | un_user_id | 1 | user_id | A | 0 | NULL | NULL | | BTREE | | | | user_newtalk | 1 | un_user_ip | 1 | user_ip | A | 0 | NULL | NULL | | BTREE | | | +--------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+