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


From f48a758a1e8bce122957fb2fc4c65966290cfead Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Fri, 26 Aug 2011 21:37:00 -0700
Subject: typo in update script

---
 update.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index ef036008f..d92b1dd91 100644
--- a/update.php
+++ b/update.php
@@ -676,7 +676,7 @@ function update_1080() {
 }
 
 function update_1081() {
-	q("ALTER TABLE `photo` ADD `guid` CHAR( 64 ) NOT NULL AFTER `contact`id`,
+	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)) {
-- 
cgit v1.2.3


From e3dbb6339386fce5cef2d22be6edd63b93a9b41d Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Fri, 26 Aug 2011 21:51:12 -0700
Subject: fix any update issues that may arise from update 1081

---
 update.php | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index d92b1dd91..c23ce95c6 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1082 );
+define( 'UPDATE_VERSION' , 1083 );
 
 /**
  *
@@ -676,8 +676,16 @@ function update_1080() {
 }
 
 function update_1081() {
+	// there was a typo in update 1081 so it was corrected and moved up to 1082
+}
+
+function update_1082() {
 	q("ALTER TABLE `photo` ADD `guid` CHAR( 64 ) NOT NULL AFTER `contact-id`,
 		ADD INDEX ( `guid` )  ");
+	// make certain the following code is only executed once
+	$r = q("select `id` from `photo` where `guid` != '' limit 1");
+	if($r && count($r))
+		return;
 	$r = q("SELECT distinct(`resource-id`) FROM `photo` WHERE 1 group by `id`");
 	if(count($r)) {
 		foreach($r as $rr) {
-- 
cgit v1.2.3


From 846c4cea7c0e3868a63a187ee9a504a031b2a7e4 Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sun, 28 Aug 2011 21:41:42 -0700
Subject: implement delivery queue in case notifier gets killed

---
 update.php | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index c23ce95c6..14bc48ab7 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1083 );
+define( 'UPDATE_VERSION' , 1084 );
 
 /**
  *
@@ -697,3 +697,13 @@ function update_1082() {
 		}
 	}
 }
+
+function update_1083() {
+	q("CREATE TABLE IF NOT EXISTS `deliverq` (
+	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+	`cmd` CHAR( 32 ) NOT NULL ,
+	`item` INT NOT NULL ,
+	`contact` INT NOT NULL
+	) ENGINE = MYISAM ;");
+
+}
\ No newline at end of file
-- 
cgit v1.2.3