diff options
| -rw-r--r-- | modules/aggregator/aggregator.install | 4 | ||||
| -rw-r--r-- | modules/system/system.install | 14 |
2 files changed, 17 insertions, 1 deletions
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. |