diff options
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_basic.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 16 |
2 files changed, 18 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql index 2e471522f1..21b18ae5f1 100644 --- a/phpBB/install/schemas/mysql_basic.sql +++ b/phpBB/install/schemas/mysql_basic.sql @@ -116,6 +116,7 @@ INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_rate', 1); INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_print', 1); INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_ignoreflood', 1); INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_ignorequeue', 1); +INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_viewonline', 1); INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_', 1, 1); INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_edit', 1, 1); @@ -127,6 +128,7 @@ INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_merg INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_approve', 1, 1); INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_unrate', 1, 1); INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_auth', 1, 1); +INSERT INTO phpbb_auth_options (auth_value, is_local, is_global) VALUES ('m_ip', 1, 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_server', 1); diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index d0bbb77ca6..44768c5ae2 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -34,6 +34,7 @@ CREATE TABLE phpbb_auth_groups ( ); +# -------------------------------------------------------- # # Table structure for table `phpbb_auth_options` # @@ -50,6 +51,21 @@ CREATE TABLE phpbb_auth_options ( # -------------------------------------------------------- # +# Table structure for table phpbb_auth_presets +# +CREATE TABLE phpbb_auth_presets ( + preset_id tinyint(4) NOT NULL auto_increment, + preset_name varchar(50) NOT NULL, + preset_user_id mediumint(5) UNSIGNED NOT NULL, + preset_type varchar(2) NOT NULL, + preset_data text, + PRIMARY KEY (preset_id), + KEY preset_type (preset_type) +); + + +# -------------------------------------------------------- +# # Table structure for table `phpbb_auth_users` # CREATE TABLE phpbb_auth_users ( |