aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2002-07-28 15:18:02 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2002-07-28 15:18:02 +0000
commitcdcd5a1e4df64b10990e68c399612b47cdc8faa2 (patch)
tree2716da3fc1010627126d328e76b275906cce6510 /phpBB/install/schemas
parentb5787743515d0ef042a100b3327ed0eca0055065 (diff)
downloadforums-cdcd5a1e4df64b10990e68c399612b47cdc8faa2.tar
forums-cdcd5a1e4df64b10990e68c399612b47cdc8faa2.tar.gz
forums-cdcd5a1e4df64b10990e68c399612b47cdc8faa2.tar.bz2
forums-cdcd5a1e4df64b10990e68c399612b47cdc8faa2.tar.xz
forums-cdcd5a1e4df64b10990e68c399612b47cdc8faa2.zip
Add ban_reason
git-svn-id: file:///svn/phpbb/trunk@2771 89ea8834-ac86-4346-8a33-228a782c2dd0
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
);