aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/database_update.php
diff options
context:
space:
mode:
authorNathan Guse <nathaniel.guse@gmail.com>2012-12-15 19:18:26 -0600
committerNathan Guse <nathaniel.guse@gmail.com>2012-12-15 19:18:26 -0600
commitf47e51d6dea9d59a36a6babf1f4033104c93a53d (patch)
tree8987bce353d678fcf3bd1d57cef27fe4d2a2ce87 /phpBB/install/database_update.php
parentc6f138ff12f015543f92d07fb5c93c083a246bab (diff)
downloadforums-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.php11
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'),