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

---
 boot.php             |  2 +-
 install/database.sql |  2 ++
 install/update.php   | 11 ++++++++++-
 3 files changed, 13 insertions(+), 2 deletions(-)

diff --git a/boot.php b/boot.php
index 5e8b52d0d..ae27d65ab 100755
--- a/boot.php
+++ b/boot.php
@@ -43,7 +43,7 @@ require_once('include/taxonomy.php');
 define ( 'RED_PLATFORM',            'Red Matrix' );
 define ( 'RED_VERSION',             trim(file_get_contents('version.inc')) . 'R');
 define ( 'ZOT_REVISION',            1     ); 
-define ( 'DB_UPDATE_VERSION',       1064  );
+define ( 'DB_UPDATE_VERSION',       1065  );
 
 define ( 'EOL',                    '<br />' . "\r\n"     );
 define ( 'ATOM_TIME',              'Y-m-d\TH:i:s\Z' );
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