From 92496eb8390edd6dcb915c005be7af882712a2f3 Mon Sep 17 00:00:00 2001
From: Neil Drumm <drumm@3064.no-reply.drupal.org>
Date: Thu, 24 Aug 2006 06:27:41 +0000
Subject: #14400 by chx. Add a missing key.

---
 modules/aggregator/aggregator.install |  4 +++-
 modules/system/system.install         | 14 ++++++++++++++
 2 files changed, 17 insertions(+), 1 deletion(-)

(limited to 'modules')

diff --git a/modules/aggregator/aggregator.install b/modules/aggregator/aggregator.install
index d1d43c608..8a5d1612f 100644
--- a/modules/aggregator/aggregator.install
+++ b/modules/aggregator/aggregator.install
@@ -52,7 +52,8 @@ function aggregator_install() {
         description longtext NOT NULL,
         timestamp int default NULL,
         guid varchar(255),
-        PRIMARY KEY (iid)
+        PRIMARY KEY (iid),
+        KEY fid (fid)
       ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
 
       break;
@@ -106,6 +107,7 @@ function aggregator_install() {
         guid varchar(255),
         PRIMARY KEY (iid)
       )");
+      db_query("CREATE INDEX {aggregator_item}_fid_idx ON {aggregator_item} (fid)");
 
       break;
   }
diff --git a/modules/system/system.install b/modules/system/system.install
index 5753fe205..b7fd920dd 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -3076,6 +3076,20 @@ function system_update_1006() {
   return $ret;
 }
 
+function system_update_1007() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {aggregator_item} ADD INDEX (fid)");
+      break;
+    case 'pgsql':
+      $ret[] = update_sql("CREATE INDEX {aggregator_item}_fid_idx ON {aggregator_item} (fid)");
+      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