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

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

MediaWiki version:

≥ 1.13

Timestamp for getting the difference since last view.

Versions

(Current as of v1.22)

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

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist

Language:	English  • 日本語