Difference between revisions of "Tables/users"
From Joomla! Documentation
< Tables
(New page: == Usage: == * Since: == Description: == {| border="1" |+ '''users Table (#__users)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- | id ...) |
m (categorisation) |
||
(One intermediate revision by one other user not shown) | |||
Line 1: | Line 1: | ||
− | == Usage | + | == Usage == |
* Since: | * Since: | ||
− | == Description | + | == Description == |
− | {| border="1" | + | {| class="wikitable" border="1" |
|+ '''users Table (#__users)''' | |+ '''users Table (#__users)''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
Line 36: | Line 36: | ||
== Notes == | == Notes == | ||
− | {| border="1" | + | {| class="wikitable" border="1" |
|+ '''Indices''' | |+ '''Indices''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
Line 53: | Line 53: | ||
* Default character set: '''utf8''' | * Default character set: '''utf8''' | ||
+ | |||
+ | <noinclude>[[Category:Database]]</noinclude> |
Latest revision as of 10:39, 16 March 2013
Usage[edit]
- Since:
Description[edit]
Field | Type | Nullable | Default | Key | Extra | Comments |
id | integer | NOT NULL | PK | auto_increment | ||
name | varchar(255) | NOT NULL | ||||
username | varchar(150) | NOT NULL | ||||
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[edit]
Index Name | Column(s) | Unique? |
usertype | usertype | No |
idx_name | name | No |
idx_block | block | No |
username | username | No |
No |
- Default character set: utf8