add a guid to directory update table to avoid recursion

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;
+}
+