PhpBB3 Database Structure Overview phpbb acl roles data

From PHPBB用户手册

Jump to: navigation, search
# Table: 'phpbb_acl_roles_data' 角色数据表
CREATE TABLE phpbb_acl_roles_data (
	role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 对应的角色ID
	auth_option_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
	PRIMARY KEY (role_id, auth_option_id),
	KEY ath_op_id (auth_option_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;