From 63fc92b9e5d75f0dda0aecaaa0e1feb56d2b9744 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Thu, 19 Sep 2013 01:01:51 -0700
Subject: sync item_search with yesterday's network fix for collections. Add
 ud_addr to update table to store the target address since it's possible the
 mirroring directory won't yet have an xchan or hubloc they can link the
 ud_hash to and therefore mayn't know how to contact them.

---
 install/database.sql |  4 +++-
 install/update.php   | 10 +++++++++-
 2 files changed, 12 insertions(+), 2 deletions(-)

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index 21d7575e9..a74b30d59 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -892,11 +892,13 @@ CREATE TABLE IF NOT EXISTS `updates` (
   `ud_guid` char(255) NOT NULL DEFAULT '',
   `ud_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `ud_flags` int(11) NOT NULL DEFAULT '0',
+  `ud_addr` char(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`ud_id`),
   KEY `ud_hash` (`ud_hash`),
   KEY `ud_guid` (`ud_guid`),
   KEY `ud_date` (`ud_date`),
-  KEY `ud_flags` (`ud_flags`)
+  KEY `ud_flags` (`ud_flags`),
+  KEY `ud_addr` (`ud_addr`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `verify` (
diff --git a/install/update.php b/install/update.php
index c135cc586..ccbdd79fd 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1071 );
+define( 'UPDATE_VERSION' , 1072 );
 
 /**
  *
@@ -805,3 +805,11 @@ ADD INDEX ( `ud_flags` )");
 	return UPDATE_FAILED;
 }
 
+function update_r1071() {
+	$r = q("ALTER TABLE `updates` ADD `ud_addr` CHAR( 255 ) NOT NULL DEFAULT '',
+ADD INDEX ( `ud_addr` ) ");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
+
-- 
cgit v1.2.3