Manual:User table

<- MediaWiki architecture < Database layout

The user table is where MediaWiki stores information about users.

"DESCRIBE user" gives the following:

+--+-+--+-+-++ +--+-+--+-+-++ +--+-+--+-+-++
 * Field           | Type                | Null | Key | Default | Extra          |
 * user_id         | int(5) unsigned     |      | PRI | NULL    | auto_increment |
 * user_name       | varchar(255) binary |      |     |         |                |
 * user_rights     | tinyblob            |      |     |         |                |
 * user_password   | tinyblob            |      |     |         |                |
 * user_newpassword | tinyblob           |      |     |         |                |
 * user_email      | tinytext            |      |     |         |                |
 * user_options    | blob                |      |     |         |                |
 * user_touched    | varchar(14) binary  |      |     |         |                |

The fields are:
 * user_id is the primary key, used to uniquely identify a user
 * user_name: Usernames must be unique, and must not be in the form of an IP address. Shouldn't allow slashes or case conflicts. Spaces are allowed, and are not converted to underscores like titles. (Conflicts?)
 * user_real_name
 * user_rights is a comma-separated list of textual flags.
 * user_password is a hash of current password.
 * user_newpassword is generated for the mail-a-new-password feature.
 * user_email Note: email should be restricted, not public info. Same with passwords. ;)
 * user_options is a newline-separated list of name=value pairs.
 * user_touched

Some of this information was adapted from  in the MediaWiki   directory.