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_banlist

CREATE TABLE phpbb_banlist (
	ban_id int(10) unsigned NOT NULL AUTO_INCREMENT,
	ban_userid int(10) unsigned NOT NULL DEFAULT '0',
	ban_ip varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
	ban_email varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
	ban_start int(11) unsigned NOT NULL DEFAULT '0',
	ban_end int(11) unsigned NOT NULL DEFAULT '0',
	ban_exclude tinyint(1) unsigned NOT NULL DEFAULT '0',
	ban_reason varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	ban_give_reason varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	PRIMARY KEY (ban_id),
	KEY ban_end (ban_end),
	KEY ban_user (ban_userid,ban_exclude),
	KEY ban_email (ban_email,ban_exclude),
	KEY ban_ip (ban_ip,ban_exclude)
) CHARSET=utf8 COLLATE=utf8_bin;