From 00622779f3fd68bf9ae4860d776c65c82ae1c0c0 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Sat, 31 Aug 2013 04:30:01 -0700
Subject: add a guid to directory update table to avoid recursion

---
 install/database.sql |  2 ++
 install/update.php   | 11 ++++++++++-
 2 files changed, 12 insertions(+), 1 deletion(-)

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index dbffbf59b..2f92167c8 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -882,8 +882,10 @@ CREATE TABLE IF NOT EXISTS `tokens` (
 
 CREATE TABLE IF NOT EXISTS `updates` (
   `ud_hash` char(128) NOT NULL,
+  `ud_guid` char(255) NOT NULL DEFAULT '',
   `ud_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   PRIMARY KEY (`ud_hash`),
+  KEY `ud_guid` (`ud_guid`),
   KEY `ud_date` (`ud_date`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
diff --git a/install/update.php b/install/update.php
index 9beb25254..13dded6fe 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1064 );
+define( 'UPDATE_VERSION' , 1065 );
 
 /**
  *
@@ -750,3 +750,12 @@ ADD INDEX ( `xchan_follow` ), ADD INDEX ( `xchan_connpage`) ");
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1064() {
+	$r = q("ALTER TABLE `updates` ADD `ud_guid` CHAR( 255 ) NOT NULL DEFAULT '' AFTER `ud_hash` ,
+ADD INDEX ( `ud_guid` )");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
+
-- 
cgit v1.2.3