From PHPBB用户手册

# Table: 'phpbb_banlist'
CREATE TABLE phpbb_banlist (
	ban_id mediumint(8) UNSIGNED NOT NULL auto_increment, 封禁记录ID
	ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 封禁的用户ID(如果封禁的是IP, 则此值为0)
	ban_ip varchar(40) DEFAULT '' NOT NULL, 封禁的IP
	ban_email varchar(100) DEFAULT '' NOT NULL, 封禁的email帐号(如果封禁的是IP, 此值留空)
	ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL, 封禁开始时间
	ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL, 封禁结束时间
	ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, 为1表示封禁定义外的情况(补集)
	ban_reason varchar(255) DEFAULT '' NOT NULL, 封禁原因
	ban_give_reason varchar(255) DEFAULT '' NOT NULL, 
	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)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;