Tables/users
From Joomla! Documentation
Usage
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