From 82b23fdf67e3e94759c28a99cd6b05d70409873f Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
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

