From c8b1ddf26a299016c433c2901e519942d693430d Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 18 Dec 2007 12:59:22 +0000
Subject: - Patch #164532 by catch, pwolanin, David Strauss, et al.: improve
 table indicies for common queries.

---
 modules/user/user.install | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'modules/user')

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;
-- 
cgit v1.2.3