PhpBB3 Database Structure Overview phpbb privmsgs

From PHPBB用户手册

Jump to: navigation, search
# Table: 'phpbb_privmsgs'
CREATE TABLE phpbb_privmsgs (
	msg_id mediumint(8) UNSIGNED NOT NULL auto_increment, 短信的ID
	root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, ??
	author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 短信作者的用户ID
	icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 短信的主题图标ID
	author_ip varchar(40) DEFAULT '' NOT NULL, 短信作者的ip地址
	message_time int(11) UNSIGNED DEFAULT '0' NOT NULL, 短信发送时间
	enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, 是否允许使用BBCode
	enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, 是否允许使用表情图标
	enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, 是否允许使用优化链接
	enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, 是否允许使用签名档
	message_subject varchar(100) DEFAULT '' NOT NULL, 短信标题
	message_text mediumtext NOT NULL, 短信内容
	message_edit_reason varchar(255) DEFAULT '' NOT NULL, 短信的编辑原因
	message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 短信的编辑者
	message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, 短信是否带附件
	bbcode_bitfield varchar(255) DEFAULT '' NOT NULL, ????
	bbcode_uid varchar(5) DEFAULT '' NOT NULL, BBCode的区分码
	message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, 短信最后编辑时间
	message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL, 短信的编辑次数
	to_address text NOT NULL, 短信目的地址
	bcc_address text NOT NULL, 附加发送的目的地址
	PRIMARY KEY (msg_id),
	KEY author_ip (author_ip),
	KEY message_time (message_time),
	KEY author_id (author_id),
	KEY root_level (root_level)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;