User:RichMorin/mw user newtalk

Stores notifications of user talk page changes, for the display of the "you have new messages" box


Inter-table Relationships

edit
  • user_id - user ID ( user.user_id)


MySQL Table Description

edit
mysql> desc mw_user_newtalk;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| user_id | int(5)      |      | MUL | 0       |       |
| user_ip | varchar(40) |      | MUL |         |       |
+---------+-------------+------+-----+---------+-------+
2 rows in set


Annotated Table Creation Code

edit
-- Stores notifications of user talk page changes,
-- for the display of the "you have new messages" box

CREATE TABLE /*$wgDBprefix*/user_newtalk (

  -- Key to user.user_id

  user_id             int(5)                      NOT NULL  default '0',

  -- If the user is an anonymous user,
  -- hir IP address is stored here,
  -- because the user_id of 0 is ambiguous.

  user_ip             varchar(40)                 NOT NULL  default '',
 
INDEX                 user_id (user_id),
INDEX                 user_ip (user_ip)

);