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_reports

CREATE TABLE phpbb_reports (
	report_id int(10) unsigned NOT NULL AUTO_INCREMENT,
	reason_id smallint(4) unsigned NOT NULL DEFAULT '0',
	post_id int(10) unsigned NOT NULL DEFAULT '0',
	user_id int(10) unsigned NOT NULL DEFAULT '0',
	user_notify tinyint(1) unsigned NOT NULL DEFAULT '0',
	report_closed tinyint(1) unsigned NOT NULL DEFAULT '0',
	report_time int(11) unsigned NOT NULL DEFAULT '0',
	report_text mediumtext COLLATE utf8_bin NOT NULL,
	pm_id int(10) unsigned NOT NULL DEFAULT '0',
	reported_post_enable_bbcode tinyint(1) unsigned NOT NULL DEFAULT '1',
	reported_post_enable_smilies tinyint(1) unsigned NOT NULL DEFAULT '1',
	reported_post_enable_magic_url tinyint(1) unsigned NOT NULL DEFAULT '1',
	reported_post_text mediumtext COLLATE utf8_bin NOT NULL,
	reported_post_uid varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
	reported_post_bitfield varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	PRIMARY KEY (report_id),
	KEY post_id (post_id),
	KEY pm_id (pm_id)
) CHARSET=utf8 COLLATE=utf8_bin;