aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas')
-rw-r--r--phpBB/install/schemas/mysql_schema.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 0717e371bf..4f8d09f61d 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -78,8 +78,10 @@ CREATE TABLE phpbb_banlist (
ban_email varchar(50),
ban_start int(11),
ban_end int(11),
+ ban_reason varchar(255),
PRIMARY KEY (ban_id),
- KEY ban_ip_user_id (ban_ip, ban_userid)
+ KEY ban_ip_user_id (ban_ip, ban_userid),
+ KEY ban_email
);