Actions

Difference between revisions of "Tables/usergroups"

From Joomla! Documentation

< Tables
(New page: == Usage: == * Since: == Description: == {| border="1" |+ '''usergroups Table (#__usergroups)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments...)
 
(class="wikitable")
Line 4: Line 4:
 
== Description: ==
 
== Description: ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''usergroups Table (#__usergroups)'''
 
|+ '''usergroups Table (#__usergroups)'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
Line 22: Line 22:
 
== Notes ==
 
== Notes ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''Indices'''
 
|+ '''Indices'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"

Revision as of 22:17, 24 September 2011

Usage:

  • Since:

Description:

usergroups Table (#__usergroups)
Field Type Nullable Default Key Extra Comments
id integer unsigned NOT NULL PK auto_increment Primary Key
parent_id integer unsigned NOT NULL 0 Adjacency List Reference ID
lft integer NOT NULL 0 Nested set lft.
rgt integer NOT NULL 0 Nested set rgt.
title varchar(100) NOT NULL

Notes

Indices
Index Name Column(s) Unique? Comments
idx_usergroup_title_lookup title Yes
idx_usergroup_adjacency_lookup parent_id No
idx_usergroup_nested_set_lookup lft, rgt No BTREE
  • Default character set: utf8