diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-01-07 18:39:24 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-01-07 18:39:24 +0000 |
| commit | 82b23fdf67e3e94759c28a99cd6b05d70409873f (patch) | |
| tree | 0752dad56c6969ef9d3d216828ab9ae0a7de0c8d /phpBB/install/schemas/mysql_schema.sql | |
| parent | 493a689b1eddc2d8db2078e487596322ce86dfc2 (diff) | |
| download | forums-82b23fdf67e3e94759c28a99cd6b05d70409873f.tar forums-82b23fdf67e3e94759c28a99cd6b05d70409873f.tar.gz forums-82b23fdf67e3e94759c28a99cd6b05d70409873f.tar.bz2 forums-82b23fdf67e3e94759c28a99cd6b05d70409873f.tar.xz forums-82b23fdf67e3e94759c28a99cd6b05d70409873f.zip | |
Enable exclusion from bans for users, IP's or email addresses
git-svn-id: file:///svn/phpbb/trunk@3267 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 7 |
1 files changed, 3 insertions, 4 deletions
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, |