- Patch #164532 by catch, pwolanin, David Strauss, et al.: improve table indicies for common queries.

1 files changed, 10 insertions, 1 deletions

diff --git a/modules/block/block.install b/modules/block/block.install
index e4fc5e6dc..737f32dd4 100644
--- a/modules/block/block.install
+++ b/modules/block/block.install
@@ -29,7 +29,7 @@ function block_schema() {
       ),
       'theme' => array(
         'type' => 'varchar',
-        'length' => 255,
+        'length' => 64,
         'not null' => TRUE,
         'default' => '',
         'description' => t('The theme under which the block settings apply.'),
@@ -97,6 +97,12 @@ function block_schema() {
       ),
     ),
     'primary key' => array('bid'),
+    'unique keys' => array(
+      'tmd' => array('theme', 'module', 'delta'),
+    ),
+    'indexes' => array(
+      'list' => array('theme', 'status', 'region', 'weight', 'module'),
+    ),
   );
 
   $schema['blocks_roles'] = array(
@@ -126,6 +132,9 @@ function block_schema() {
       'delta',
       'rid'
     ),
+    'indexes' => array(
+      'rid' => array('rid'),
+    ),
   );
 
   $schema['boxes'] = array(