From c8b1ddf26a299016c433c2901e519942d693430d Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 18 Dec 2007 12:59:22 +0000
Subject: - Patch #164532 by catch, pwolanin, David Strauss, et al.: improve
 table indicies for common queries.

---
 modules/upload/upload.install | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'modules/upload/upload.install')

diff --git a/modules/upload/upload.install b/modules/upload/upload.install
index 08638a7c2..2a5fa213f 100644
--- a/modules/upload/upload.install
+++ b/modules/upload/upload.install
@@ -68,8 +68,11 @@ function upload_schema() {
         'description' => t('Weight of this upload in relation to other uploads in this node.'),
       ),
     ),
-    'primary key' => array('fid', 'vid'),
-    'indexes' => array('vid' => array('vid'), 'nid' => array('nid')),
+    'primary key' => array('vid', 'fid'),
+    'indexes' => array(
+      'fid' => array('fid'),
+      'nid' => array('nid'),
+    ),
   );
 
   return $schema;
-- 
cgit v1.2.3