Table: user_group

KB61 Last reviewed 27 November 2013
A description of the user_group table within the Camino CMS database schema.

Stores user group data. This is limited to the definition of user groups, not individual ACLs which are stored in the user_group_acl table.

Field Type Null Key Default Description
group_id int(10) No Primary
group_ownername varchar(50) No Multiple The user group owner identity
group_ownerid int(10) No 0 The user group owner ID
group_type varchar(40) Yes User group type. Either Security or Distribution
group_identityname varchar(100) Yes Multiple The identity name for the user group
group_verbosename varchar(255) Yes The verbose name for the group
group_description mediumtext No A description of this group and its' usage
group_status tinyint(2) No 0 1 or 0 indicating whether this group is active or inactive
group_permitdeletion tinyint(2) No 0 1 or 0 indicating whether this group may be deleted
group_created datetime No 0000-00-00 00:00:00 The MySQL timestamp of when the group was created
group_lastmodified datetime No 0000-00-00 00:00:00 The MySQL timestampe of when the group was last updated

Indexes

Keyname Type Cardinality Field(s) Description
PRIMARY PRIMARY 0 group_id Primary
group_owner Index n/a group_owner
group_identityname Index n/a group_identityname
group_owner_and_identity Index n/a group_owner, group_identityname
3
Please wait, loading ...
Copyright © 2011 - 2017 Calzada Media Limited. All Rights Reserved.