#371458 by Damien Tournoud, Gerhard Killesreiter, and smk-ka: Add a missing index on menu_router tab_root.

1 files changed, 10 insertions, 0 deletions

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'),
   );
@@ -2224,6 +2225,15 @@ function system_update_7030() {
 }
 
 /**
+ * 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.
  */