From 56d64316f457c85141e35356a61a4d352ed9f24c Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Tue, 23 Aug 2011 18:17:35 -0700
Subject: diaspora photos ?

---
 update.php | 19 +++++++++++++++++--
 1 file changed, 17 insertions(+), 2 deletions(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index adfb5fe02..ef036008f 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1081 );
+define( 'UPDATE_VERSION' , 1082 );
 
 /**
  *
@@ -673,4 +673,19 @@ function update_1079() {
 
 function update_1080() {
 	q("ALTER TABLE `fcontact` ADD `updated` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'");
-}
\ No newline at end of file
+}
+
+function update_1081() {
+	q("ALTER TABLE `photo` ADD `guid` CHAR( 64 ) NOT NULL AFTER `contact`id`,
+		ADD INDEX ( `guid` )  ");
+	$r = q("SELECT distinct(`resource-id`) FROM `photo` WHERE 1 group by `id`");
+	if(count($r)) {
+		foreach($r as $rr) {
+			$guid = get_guid();
+			q("update `photo` set `guid` = '%s' where `resource-id` = '%s'",
+				dbesc($guid),
+				dbesc($rr['resource-id'])
+			);
+		}
+	}
+}
-- 
cgit v1.2.3