Documentation contenant le détail des tables de la base de données d’un forum phpBB 3.3.10

Détails de la table phpbb_privmsgs

CREATE TABLE phpbb_privmsgs (
	msg_id int(10) unsigned NOT NULL AUTO_INCREMENT,
	root_level mediumint(8) unsigned NOT NULL DEFAULT '0',
	author_id int(10) unsigned NOT NULL DEFAULT '0',
	icon_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	author_ip varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
	message_time int(11) unsigned NOT NULL DEFAULT '0',
	enable_bbcode tinyint(1) unsigned NOT NULL DEFAULT '1',
	enable_smilies tinyint(1) unsigned NOT NULL DEFAULT '1',
	enable_magic_url tinyint(1) unsigned NOT NULL DEFAULT '1',
	enable_sig tinyint(1) unsigned NOT NULL DEFAULT '1',
	message_subject varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	message_text mediumtext COLLATE utf8_bin NOT NULL,
	message_edit_reason varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	message_edit_user int(10) unsigned NOT NULL DEFAULT '0',
	message_attachment tinyint(1) unsigned NOT NULL DEFAULT '0',
	bbcode_bitfield varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	bbcode_uid varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
	message_edit_time int(11) unsigned NOT NULL DEFAULT '0',
	message_edit_count smallint(4) unsigned NOT NULL DEFAULT '0',
	to_address text COLLATE utf8_bin NOT NULL,
	bcc_address text COLLATE utf8_bin NOT NULL,
	message_reported tinyint(1) unsigned NOT NULL DEFAULT '0',
	PRIMARY KEY (msg_id),
	KEY author_ip (author_ip),
	KEY message_time (message_time),
	KEY author_id (author_id),
	KEY root_level (root_level)
) CHARSET=utf8 COLLATE=utf8_bin;