Actions

Tables/usergroups

From Joomla! Documentation

< Tables
Revision as of 10:39, 16 March 2013 by JoomlaWikiBot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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