Actions

Tables/users

From Joomla! Documentation

< Tables
Revision as of 13:00, 31 August 2010 by Dsiders (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Usage:

  • Since:

Description:

users Table (#__users)
Field Type Nullable Default Key Extra Comments
id integer NOT NULL PK auto_increment
name varchar(255) NOT NULL
username varchar(150) NOT NULL
email varchar(100) NOT NULL
password varchar(100) NOT NULL
usertype varchar(25) NOT NULL
block tinyint(4) NOT NULL 0
sendEmail tinyint(4) 0
registerDate datetime NOT NULL '0000-00-00 00:00:00'
lastvisitDate datetime NOT NULL '0000-00-00 00:00:00'
activation varchar(100) NOT NULL
params text NOT NULL

Notes

Indices
Index Name Column(s) Unique?
usertype usertype No
idx_name name No
idx_block block No
username username No
email email No
  • Default character set: utf8