Manual:user_newtalk table

From mediawiki.org

Translate this page

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.

Key to user.user_id or "0" for anonymous users.

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

Timestamp for getting the difference since last view.

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

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

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

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

DESCRIBEuser_newtalk;

+---------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------+------+-----+---------+-------+
| user_id | int(11) | NO | MUL | 0 | |
| user_ip | varbinary(40) | NO | MUL | NULL | |
+---------+---------------+------+-----+---------+-------+

DESCRIBEuser_newtalk;

+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| user_id | int(5) | NO | MUL | 0 | |
| user_ip | varchar(40) | NO | MUL | NULL | |
+---------+-------------+------+-----+---------+-------+

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

Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:User_newtalk_table&oldid=6551554"

Categories:

• MediaWiki database tables
• MediaWiki database tables that lack a primary key