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


From a33edb00424882258a90b138c634a466c92faf61 Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Thu, 1 Sep 2011 18:02:08 -0700
Subject: infrastructure for personalised @ tags (no UI/settings form yet),
 allow own comments through statusnet connector

---
 update.php | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index 14bc48ab7..80761cce4 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1084 );
+define( 'UPDATE_VERSION' , 1085 );
 
 /**
  *
@@ -706,4 +706,8 @@ function update_1083() {
 	`contact` INT NOT NULL
 	) ENGINE = MYISAM ;");
 
-}
\ No newline at end of file
+}
+
+function update_1084() {
+	q("ALTER TABLE `contact` ADD `attag` CHAR( 255 ) NOT NULL AFTER `nick` ");
+}
-- 
cgit v1.2.3


From 481853d2cc44a4bf6c540e72c741ff453305a925 Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sun, 4 Sep 2011 17:35:06 -0700
Subject: saved searches on network page

---
 update.php | 14 ++++++++++++--
 1 file changed, 12 insertions(+), 2 deletions(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index 80761cce4..3d7b31813 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1085 );
+define( 'UPDATE_VERSION' , 1086 );
 
 /**
  *
@@ -704,10 +704,20 @@ function update_1083() {
 	`cmd` CHAR( 32 ) NOT NULL ,
 	`item` INT NOT NULL ,
 	`contact` INT NOT NULL
-	) ENGINE = MYISAM ;");
+	) ENGINE = MYISAM ");
 
 }
 
 function update_1084() {
 	q("ALTER TABLE `contact` ADD `attag` CHAR( 255 ) NOT NULL AFTER `nick` ");
 }
+
+function update_1085() {
+	q("CREATE TABLE IF NOT EXISTS `search` (
+	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+	`uid` INT NOT NULL ,
+	`term` CHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
+	INDEX ( `uid` ),
+	INDEX ( `term` )
+	) ENGINE = MYISAM ");
+}
-- 
cgit v1.2.3


From 82f7f33cf58774ac6b07acd64fe0b49cd5b0aa30 Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sun, 4 Sep 2011 19:58:03 -0700
Subject: bookmarks + bug #140

---
 update.php | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index 3d7b31813..f94e78d72 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1086 );
+define( 'UPDATE_VERSION' , 1087 );
 
 /**
  *
@@ -721,3 +721,8 @@ function update_1085() {
 	INDEX ( `term` )
 	) ENGINE = MYISAM ");
 }
+
+function update_1086() {
+	q("ALTER TABLE `item` ADD `bookmark` tinyint(1) NOT NULL DEFAULT '0' AFTER `starred` ");
+}
+
-- 
cgit v1.2.3