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/develop/create_schema_files.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/develop/create_schema_files.php')
-rw-r--r-- | phpBB/develop/create_schema_files.php | 14 |
1 files changed, 2 insertions, 12 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index 3548bc5f05..87204f9e26 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -1309,13 +1309,8 @@ function get_schema_struct() ), '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')), ), ); @@ -1791,11 +1786,6 @@ function get_schema_struct() 'user_id', 'method', ), - 'KEYS' => array( - 'it' => array('INDEX', 'item_type'), - 'uid' => array('INDEX', 'user_id'), - 'no' => array('INDEX', 'notify'), - ), ); $schema_data['phpbb_user_group'] = array( |