From 98258d6c59cf01074bdfcbd127de4c40309f02df Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sat, 7 Nov 2009 22:14:58 +0000
Subject: - Patch #625942 by catch: added index to avoid filesort in
 filter_formats().

---
 modules/filter/filter.install | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'modules')

diff --git a/modules/filter/filter.install b/modules/filter/filter.install
index 3fab5b44f..389100be8 100644
--- a/modules/filter/filter.install
+++ b/modules/filter/filter.install
@@ -97,6 +97,9 @@ function filter_schema() {
     'unique keys' => array(
       'name' => array('name'),
     ),
+    'indexes' => array(
+      'weight' => array('weight'),
+    ),
   );
 
   $schema['cache_filter'] = drupal_get_schema_unprocessed('system', 'cache');
@@ -115,6 +118,7 @@ function filter_schema() {
  */
 function filter_update_7000() {
   db_add_field('filter_formats', 'weight', array('type' => 'int', 'not null' => TRUE, 'default' => 0, 'size' => 'tiny'));
+  db_add_index('filter_formats', 'weight', array('weight'));
 }
 
 /**
-- 
cgit v1.2.3