Actions

Tables/usergroups

From Joomla! Documentation

< Tables
Revision as of 22:17, 24 September 2011 by Cadrlp (Talk | contribs)

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