PhpBB3 Database Structure Overview phpbb acl groups

From PHPBB用户手册

Jump to: navigation, search
# Table: 'phpbb_acl_groups' 用户组的权限信息(相对于用户的权限信息)
CREATE TABLE phpbb_acl_groups (
	group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 对应的用户组ID
	forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 对应的版面ID
	auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 对应的权限 ID
	auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,  对应的角色 ID
	auth_setting tinyint(2) DEFAULT '0' NOT NULL, 权限的设置值,可以是0, 1, -1, 分别对应ACL_NEVER, ACL_YES, ACL_NO
	KEY group_id (group_id),
	KEY auth_opt_id (auth_option_id),
	KEY auth_role_id (auth_role_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;<pre>