Tables/usergroups: Difference between revisions
From Joomla! Documentation
< Tables
< 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 03:17, 25 September 2011
Usage:
- Since:
Description:
| 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
| 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