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...) |
(No difference)
|
Revision as of 13:25, 31 August 2010
Usage:[edit]
- Since:
Description:[edit]
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[edit]
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