aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/develop/create_schema_files.php
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/develop/create_schema_files.php')
-rw-r--r--phpBB/develop/create_schema_files.php14
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(