From 58d1270a7db4d0cb44196daec318c017cbdfd2d7 Mon Sep 17 00:00:00 2001
From: Neil Drumm <drumm@3064.no-reply.drupal.org>
Date: Thu, 7 Sep 2006 07:57:20 +0000
Subject: #73045 by jhenry and davemicc. Add an index to {file_revisions} for
 faster queries.

---
 modules/system/system.install | 18 +++++++++++++++++-
 1 file changed, 17 insertions(+), 1 deletion(-)

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

diff --git a/modules/system/system.install b/modules/system/system.install
index 6962c4e3d..26750135f 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -243,7 +243,8 @@ function system_install() {
         vid int unsigned NOT NULL default 0,
         description varchar(255) NOT NULL default '',
         list tinyint unsigned NOT NULL default 0,
-        PRIMARY KEY (fid, vid)
+        PRIMARY KEY (fid, vid),
+        KEY (vid)
       ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
 
       db_query("CREATE TABLE {filter_formats} (
@@ -674,6 +675,7 @@ function system_install() {
         list smallint_unsigned NOT NULL default 0,
         PRIMARY KEY (fid, vid)
       )");
+      db_query("CREATE INDEX file_revisions_vid_idx ON file_revisions(vid)");
 
       db_query("CREATE TABLE {filter_formats} (
         format serial,
@@ -3367,6 +3369,20 @@ function system_update_1011() {
   return $ret;
 }
 
+function system_update_1012() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {file_revisions} ADD INDEX(vid)");
+      break;
+    case 'pgsql':
+      $ret[] = update_sql('CREATE INDEX {file_revisions}_vid_idx ON {file_revisions}(vid)');
+      break;
+  }
+  return $ret;
+}
+
 /**
  * @} End of "defgroup updates-4.7-to-x.x"
  * The next series of updates should start at 2000.
-- 
cgit v1.2.3