diff options
| author | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-08 14:12:25 -0600 |
|---|---|---|
| committer | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-08 14:12:25 -0600 |
| commit | 0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8 (patch) | |
| tree | 2a8e26649421aac826126d5cc2be49dcf8ba9d5d /phpBB/install/database_update.php | |
| parent | 2227ceab8bf0cccf95598f4e2a59cc7134adf7f0 (diff) | |
| download | forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.tar forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.tar.gz forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.tar.bz2 forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.tar.xz forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.zip | |
[ticket/11103] Update indexes on notifications/user notifications tables
PHPBB3-11103
Diffstat (limited to 'phpBB/install/database_update.php')
| -rw-r--r-- | phpBB/install/database_update.php | 14 |
1 files changed, 2 insertions, 12 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 33e8795327..a4739b7212 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -1122,13 +1122,8 @@ function database_update_info() ), 'PRIMARY_KEY' => 'notification_id', 'KEYS' => array( - 'item_type' => array('INDEX', 'item_type'), - 'item_id' => array('INDEX', 'item_id'), - 'item_pid' => array('INDEX', 'item_parent_id'), - 'user_id' => array('INDEX', 'user_id'), - 'time' => array('INDEX', 'time'), - 'unread' => array('INDEX', 'unread'), - 'is_enabled' => array('INDEX', 'is_enabled'), + 'item_ident' => array('INDEX', array('item_type', 'item_id')), + 'user' => array('INDEX', array('user_id', 'unread')), ), ), $table_prefix . 'user_notifications' => array( @@ -1145,11 +1140,6 @@ function database_update_info() 'user_id', 'method', ), - 'KEYS' => array( - 'it' => array('INDEX', 'item_type'), - 'uid' => array('INDEX', 'user_id'), - 'no' => array('INDEX', 'notify'), - ), ), ), 'add_columns' => array( |