Home

Your premium source for custom modification services for phpBB

   logo

HomeForumsBlogMOD ManagerFAQSearch Log in

The phpBB Doctor is currently available for private clients only. At this time we are not accepting any new work until we can clear out our current backlog. Thank you for your patience.

Tables — Table Structure
phpbb_groups
A group of users
Column Name Datatype Default Column Description
group_id mediumint(8)
auto_increment		 System assigned unique key, no user interaction is required for this field.
group_type tinyint(4)
 Group type is a coded field:
0 = GROUP_OPEN, 1 = GROUP_CLOSED, 2 = GROUP_HIDDEN
group_name varchar(40)
 This text field is entered via the ACP. It is the name of the group.
group_description varchar(255)
 This is a longer text field used to enter the group description.
group_moderator mediumint(8)
 This field contains the user_id for the user assigned as the group moderator.
group_single_user tinyint(1)
 In the phpBB 2.x security model, every user is a group for authorization purposes. (Every user except for ANONYMOUS that is.) This is a bit field where 0 = a true "group" record and 1 means it is actually the group entry for a single user.

Table relationships
Group with granted authorization phpbb_auth_access.group_id = phpbb_groups.group_id
Group User cross reference phpbb_groups.group_id = phpbb_user_group.group_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)] [Glossary Entry]

Glossary | Graphical Database Diagram (Future Feature)


HomeForumsMOD ManagerFAQSearch Register Log in
Not endorsed by or affiliated with the phpBB Group
Powered by phpBB © phpBB Group 		Terms of Service
Web design by MomentsOfLight.com logo