- Patch #164532 by catch, pwolanin, David Strauss, et al.: improve table indicies for common queries.

1 files changed, 7 insertions, 1 deletions

diff --git a/modules/user/user.install b/modules/user/user.install
index 3522cc91f..8bdcfc963 100644
--- a/modules/user/user.install
+++ b/modules/user/user.install
@@ -254,7 +254,10 @@ function user_schema() {
       'access' => array('access'),
       'created' => array('created')
     ),
-    'unique keys' => array('name' => array('name')),
+    'unique keys' => array(
+      'name' => array('name'),
+      'mail' => array('mail'),
+    ),
     'primary key' => array('uid'),
   );
 
@@ -277,6 +280,9 @@ function user_schema() {
       ),
     ),
     'primary key' => array('uid', 'rid'),
+    'indexes' => array(
+      'rid' => array('rid'),
+    ),
   );
 
   return $schema;