Description de la table
Table contenant les journaux du forum (journal d’administration, journal de modération, journal des erreurs).
CREATE TABLE phpbb_log ( log_id int(10) unsigned NOT NULL AUTO_INCREMENT, log_type tinyint(4) NOT NULL DEFAULT '0', user_id int(10) unsigned NOT NULL DEFAULT '0', forum_id mediumint(8) unsigned NOT NULL DEFAULT '0', topic_id int(10) unsigned NOT NULL DEFAULT '0', post_id int(10) unsigned NOT NULL DEFAULT '0', reportee_id int(10) unsigned NOT NULL DEFAULT '0', log_ip varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '', log_time int(11) unsigned NOT NULL DEFAULT '0', log_operation text COLLATE utf8_bin NOT NULL, log_data mediumtext COLLATE utf8_bin NOT NULL, PRIMARY KEY (log_id), KEY log_type (log_type), KEY forum_id (forum_id), KEY topic_id (topic_id), KEY reportee_id (reportee_id), KEY user_id (user_id), KEY log_time (log_time) ) CHARSET=utf8 COLLATE=utf8_bin;