diff options
| author | Dries Buytaert <dries@buytaert.net> | 2009-11-07 22:14:58 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2009-11-07 22:14:58 +0000 |
| commit | 98258d6c59cf01074bdfcbd127de4c40309f02df (patch) | |
| tree | bad326f437ef35401e31ed24a581c1d85d24f6dc | |
| parent | 5a5f34b0fa3cf7b2aed87eb6e8da80f8b6c642a9 (diff) | |
| download | brdo-98258d6c59cf01074bdfcbd127de4c40309f02df.tar.gz brdo-98258d6c59cf01074bdfcbd127de4c40309f02df.tar.bz2 | |
- Patch #625942 by catch: added index to avoid filesort in filter_formats().
| -rw-r--r-- | modules/filter/filter.install | 4 |
1 files changed, 4 insertions, 0 deletions
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')); } /** |