Joomla! Documentation™

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