From 0d41f5d9deb6a7e4b51f0ed16909955477546302 Mon Sep 17 00:00:00 2001
From: webchick <webchick@24967.no-reply.drupal.org>
Date: Sat, 28 Apr 2012 23:22:30 -0700
Subject: Issue #1348758 by drewish, tim.plunkett: Fixed Add an index to
 {users}.picture so user_file_delete() isn't insanely slow.

---
 modules/user/user.install | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'modules/user/user.install')

diff --git a/modules/user/user.install b/modules/user/user.install
index 852279683..e46f29d8e 100644
--- a/modules/user/user.install
+++ b/modules/user/user.install
@@ -236,6 +236,7 @@ function user_schema() {
       'access' => array('access'),
       'created' => array('created'),
       'mail' => array('mail'),
+      'picture' => array('picture'),
     ),
     'unique keys' => array(
       'name' => array('name'),
@@ -892,3 +893,21 @@ function user_update_7017() {
 /**
  * @} End of "addtogroup updates-6.x-to-7.x"
  */
+
+/**
+ * @addtogroup updates-7.x-extra
+ * @{
+ */
+
+/**
+ * Ensure there is an index on {users}.picture.
+ */
+function user_update_7018() {
+  if (!db_index_exists('users', 'picture')) {
+    db_add_index('users', 'picture', array('picture'));
+  }
+}
+
+/**
+ * @} End of "addtogroup updates-7.x-extra"
+ */
-- 
cgit v1.2.3