PhpBB3 Database Structure Overview phpbb groups

From PHPBB用户手册

Jump to: navigation, search
# Table: 'phpbb_groups'
CREATE TABLE phpbb_groups (
	group_id mediumint(8) UNSIGNED NOT NULL auto_increment, 用户组ID
	group_type tinyint(4) DEFAULT '1' NOT NULL, 用户组类型 -- 数字代表类型待补充
	group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, 是否由创始人管理
	group_name varchar(255) DEFAULT '' NOT NULL, 用户组名称
	group_desc text NOT NULL, 用户组描述
	group_desc_bitfield varchar(255) DEFAULT '' NOT NULL, ?? 
	group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, 用户组描述选项 ??
	group_desc_uid varchar(5) DEFAULT '' NOT NULL, 用户组描述区分码
	group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, 是否公开显示
	group_avatar varchar(255) DEFAULT '' NOT NULL, 用户组图标
	group_avatar_type tinyint(2) DEFAULT '0' NOT NULL, 图标类型
	group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, 图标宽度
	group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, 图标高度
	group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 用户组级别
	group_colour varchar(6) DEFAULT '' NOT NULL, 用户组颜色
	group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, ??
	group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, 是否允许接受短信 ??
	group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 用户组短信限制 ??
	group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, 用户组是否显示在首页的团队列表中
	PRIMARY KEY (group_id),
	KEY group_legend (group_legend)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;