From 18ae2e6775c3b99b062a0705804c807f36b5da6f Mon Sep 17 00:00:00 2001
From: Angie Byron <webchick@24967.no-reply.drupal.org>
Date: Fri, 7 Aug 2009 05:38:44 +0000
Subject: #371458 by Damien Tournoud, Gerhard Killesreiter, and smk-ka: Add a
 missing index on menu_router tab_root.

---
 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 3d2244415..e3b2ca7b6 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -933,6 +933,7 @@ function system_schema() {
     'indexes' => array(
       'fit' => array('fit'),
       'tab_parent' => array('tab_parent'),
+      'tab_root_weight_title' => array(array('tab_root', 64), 'weight', 'title'),
     ),
     'primary key' => array('path'),
   );
@@ -2223,6 +2224,15 @@ function system_update_7030() {
   return $ret;
 }
 
+/**
+ * Add a missing index on the {menu_router} table.
+ */
+function system_update_7031() {
+  $ret = array();
+  db_add_index($ret, 'menu_router', 'tab_root_weight_title', array(array('tab_root', 64), 'weight', 'title'));
+  return $ret;
+}
+
 /**
  * @} End of "defgroup updates-6.x-to-7.x"
  * The next series of updates should start at 8000.
-- 
cgit v1.2.3