diff options
author | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-15 19:18:26 -0600 |
---|---|---|
committer | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-15 19:18:26 -0600 |
commit | f47e51d6dea9d59a36a6babf1f4033104c93a53d (patch) | |
tree | 8987bce353d678fcf3bd1d57cef27fe4d2a2ce87 /phpBB/install/database_update.php | |
parent | c6f138ff12f015543f92d07fb5c93c083a246bab (diff) | |
download | forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar.gz forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar.bz2 forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar.xz forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.zip |
[ticket/11103] Move is_enabled to a separate table for better performance
PHPBB3-11103
Diffstat (limited to 'phpBB/install/database_update.php')
-rw-r--r-- | phpBB/install/database_update.php | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 0250b53a19..ae810e1022 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -93,6 +93,10 @@ if (!defined('LOGIN_ATTEMPT_TABLE')) { define('LOGIN_ATTEMPT_TABLE', $table_prefix . 'login_attempts'); } +if (!defined('NOTIFICATION_TYPES_TABLE')) +{ + define('NOTIFICATION_TYPES_TABLE', $table_prefix . 'notification_types'); +} if (!defined('NOTIFICATIONS_TABLE')) { define('NOTIFICATIONS_TABLE', $table_prefix . 'notifications'); @@ -1179,6 +1183,13 @@ function database_update_info() 'ext_name' => array('UNIQUE', 'ext_name'), ), ), + NOTIFICATION_TYPES_TABLE => array( + 'COLUMNS' => array( + 'notification_type' => array('VCHAR:255', ''), + 'notification_type_enabled' => array('BOOL', 1), + ), + 'PRIMARY_KEY' => array('notification_type', 'notification_type_enabled'), + ), NOTIFICATIONS_TABLE => array( 'COLUMNS' => array( 'notification_id' => array('UINT', NULL, 'auto_increment'), |