diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-01-29 18:16:48 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-01-29 18:16:48 +0000 |
| commit | 09d4e7cf7cabc8ea29aa2d9b7e48a4b5a30b567a (patch) | |
| tree | 583b794be612079ec36ca883bde10d35dca9eb9b | |
| parent | 6c4096c67bb5438a552208025f6f7ee35cedca32 (diff) | |
| download | forums-09d4e7cf7cabc8ea29aa2d9b7e48a4b5a30b567a.tar forums-09d4e7cf7cabc8ea29aa2d9b7e48a4b5a30b567a.tar.gz forums-09d4e7cf7cabc8ea29aa2d9b7e48a4b5a30b567a.tar.bz2 forums-09d4e7cf7cabc8ea29aa2d9b7e48a4b5a30b567a.tar.xz forums-09d4e7cf7cabc8ea29aa2d9b7e48a4b5a30b567a.zip | |
NOT NULL when should be NULL, doubled up a_event
git-svn-id: file:///svn/phpbb/trunk@3403 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/install/schemas/mysql_basic.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 4 |
2 files changed, 2 insertions, 3 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql index b35ac9a1a9..c77044a67a 100644 --- a/phpBB/install/schemas/mysql_basic.sql +++ b/phpBB/install/schemas/mysql_basic.sql @@ -139,7 +139,6 @@ INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_words', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_icons', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_bbcode', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_attach', 1); -INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_events', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_email', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_styles', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_user', 1); diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 74edf6a475..9a922d0357 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -85,8 +85,8 @@ CREATE TABLE phpbb_auth_users ( # CREATE TABLE phpbb_banlist ( ban_id mediumint(8) UNSIGNED NOT NULL auto_increment, - ban_userid mediumint(8) UNSIGNED NOT NULL, - ban_ip varchar(40) NOT NULL, + ban_userid mediumint(8) UNSIGNED, + ban_ip varchar(40), ban_email varchar(50), ban_start int(11), ban_end int(11), |