Manuel:table user_newtalk

This page is a translated version of the page Manual:User newtalk table and the translation is 40% complete.

Schéma de base de données MédiaWiki

table user_newtalk

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.

Champs

user_id

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

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

Version de MediaWiki :

≥ 1.13

Timestamp for getting the difference since last view.

Résumé du schéma

Version de MediaWiki :

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

Versions de MediaWiki :

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

Versions de MediaWiki :

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

Versions de MediaWiki :

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

Versions de MediaWiki :

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

Versions de MediaWiki :

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

Les index

Version de MediaWiki :

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