Actions

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 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

  • 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