From 82b23fdf67e3e94759c28a99cd6b05d70409873f Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Tue, 7 Jan 2003 18:39:24 +0000 Subject: Enable exclusion from bans for users, IP's or email addresses git-svn-id: file:///svn/phpbb/trunk@3267 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/schemas/mysql_schema.sql | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'phpBB/install/schemas/mysql_schema.sql') diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 26b756b2db..3602843d05 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -73,10 +73,9 @@ CREATE TABLE phpbb_banlist ( ban_email varchar(50), ban_start int(11), ban_end int(11), + ban_exclude tinyint(1) DEFAULT '0' NOT NULL, ban_reason varchar(255), - PRIMARY KEY (ban_id), - KEY ban_ip_user_id (ban_ip, ban_userid), - KEY ban_email (ban_email) + PRIMARY KEY (ban_id) ); @@ -95,7 +94,7 @@ CREATE TABLE phpbb_config ( # -------------------------------------------------------- # -# Table structure for table 'phpbb_disallow' <- combine with banlist +# Table structure for table 'phpbb_disallow' # CREATE TABLE phpbb_disallow ( disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment, -- cgit v1.2.1