From 73f98066f5920045f9a83108f7410155564af486 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 12 Aug 2008 07:00:48 +0000
Subject: - Patch #291064 by mustafau: improve performance of aggregator by
 storing an md5 hash for the feed.

---
 modules/aggregator/aggregator.install | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

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

diff --git a/modules/aggregator/aggregator.install b/modules/aggregator/aggregator.install
index 3b9c181b4..7f672d948 100644
--- a/modules/aggregator/aggregator.install
+++ b/modules/aggregator/aggregator.install
@@ -158,6 +158,13 @@ function aggregator_schema() {
         'size' => 'big',
         'description' => t('An image representing the feed.'),
       ),
+      'hash' => array(
+        'type' => 'varchar',
+        'length' => 32,
+        'not null' => TRUE,
+        'default' => '',
+        'description' => t('Calculated md5 hash of the feed data, used for validating cache.'),
+      ),
       'etag' => array(
         'type' => 'varchar',
         'length' => 255,
@@ -247,3 +254,12 @@ function aggregator_schema() {
 
   return $schema;
 }
+
+/**
+ * Add hash column to aggregator_feed table.
+ */
+function aggregator_update_7000() {
+  $ret = array();
+  db_add_field($ret, 'aggregator_feed', 'hash', array('type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => ''));
+  return $ret;
+}
-- 
cgit v1.2.3