From b65907b89cee44f311a038b391384286772ac74d Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sun, 2 Nov 2008 14:56:15 +0000
Subject: - Patch #257910 by douggreen et al: Performance Issue during Indexing
 - search_dataset.sid_type unique key should be an Index.

---
 modules/system/system.install | 10 ++++++++++
 1 file changed, 10 insertions(+)

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

diff --git a/modules/system/system.install b/modules/system/system.install
index f84bc570c..3a7bec61c 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -3100,6 +3100,16 @@ function system_update_7011() {
   return $ret;
 }
 
+/**
+ * Replace unique key 'sid_type' by indexes in 'search_dataset' table.
+ */
+function system_update_7012() {
+  $ret = array();
+  db_drop_unique_key($ret, 'search_dataset', 'sid_type');
+  db_add_index($ret, 'search_dataset', 'sid_type', array('sid', 'type'));
+  return $ret;
+}
+
 /**
  * @} End of "defgroup updates-6.x-to-7.x"
  * The next series of updates should start at 8000.
-- 
cgit v1.2.3