From 38cf37d3c3a4bc9873aa12eed5167b356282385f Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Thu, 23 Jun 2011 17:56:59 -0700
Subject: new item view, sort by received date - not posted date.

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

(limited to 'update.php')

diff --git a/update.php b/update.php
index 8edd2aa92..13187ac51 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1066 );
+define( 'UPDATE_VERSION' , 1067 );
 
 /**
  *
@@ -529,3 +529,10 @@ function update_1065() {
 	q("ALTER TABLE `intro` ADD `fid` INT NOT NULL DEFAULT '0' AFTER `uid`");
 }
 
+function update_1066() {
+	$r = q("ALTER TABLE `item` ADD `received` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `edited` ");
+	if($r)
+		q("ALTER TABLE `item` ADD INDEX ( `received` ) ");
+
+	$r = q("UPDATE `item` SET `received` = `edited` WHERE 1");
+}
\ No newline at end of file
-- 
cgit v1.2.3


From 22e89220889759256b48323ee1a66257e2121ef7 Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sun, 26 Jun 2011 05:42:32 -0700
Subject: friend suggest structures, cont.

---
 update.php | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index 13187ac51..409e5d48e 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1067 );
+define( 'UPDATE_VERSION' , 1068 );
 
 /**
  *
@@ -535,4 +535,9 @@ function update_1066() {
 		q("ALTER TABLE `item` ADD INDEX ( `received` ) ");
 
 	$r = q("UPDATE `item` SET `received` = `edited` WHERE 1");
-}
\ No newline at end of file
+}
+
+function update_1067() {
+	q("ALTER TABLE `ffinder` ADD `type` CHAR( 16 ) NOT NULL AFTER `id` ,
+	ADD `note` TEXT NOT NULL AFTER `type` ");
+}
-- 
cgit v1.2.3


From f7964efa52f7efa8159403568a59e320209cbffa Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sun, 26 Jun 2011 17:57:23 -0700
Subject: revisit friend suggestion structures

---
 update.php | 23 ++++++++++++++++++++++-
 1 file changed, 22 insertions(+), 1 deletion(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index 409e5d48e..2e22b9d1c 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1068 );
+define( 'UPDATE_VERSION' , 1069 );
 
 /**
  *
@@ -541,3 +541,24 @@ function update_1067() {
 	q("ALTER TABLE `ffinder` ADD `type` CHAR( 16 ) NOT NULL AFTER `id` ,
 	ADD `note` TEXT NOT NULL AFTER `type` ");
 }
+
+function update_1068() {
+	// 1067 was short-sighted. Undo it.
+	q("ALTER TABLE `ffinder` DROP `type` , DROP `note` ");
+
+	// and do this instead.
+
+	q("CREATE TABLE IF NOT EXISTS `fsuggest` (
+	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+	`uid` INT NOT NULL ,
+	`cid` INT NOT NULL ,
+	`name` CHAR( 255 ) NOT NULL ,
+	`url` CHAR( 255 ) NOT NULL ,
+	`photo` CHAR( 255 ) NOT NULL ,
+	`note` TEXT NOT NULL ,
+	`created` DATETIME NOT NULL 
+	) ENGINE = MYISAM DEFAULT CHARSET=utf8");
+
+}
+
+
-- 
cgit v1.2.3


From 3fe1e197254f62e5377c28a24e4d5a75014e931b Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sun, 26 Jun 2011 19:30:57 -0700
Subject: pass notify endpoint with friend suggestions

---
 update.php | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index 2e22b9d1c..ce8c694ca 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1069 );
+define( 'UPDATE_VERSION' , 1070 );
 
 /**
  *
@@ -561,4 +561,7 @@ function update_1068() {
 
 }
 
-
+function update_1069() {
+	q("ALTER TABLE `fsuggest` ADD `request` CHAR( 255 ) NOT NULL AFTER `url` ");
+	q("ALTER TABLE `fcontact` ADD `request` CHAR( 255 ) NOT NULL AFTER `photo` ");
+}
-- 
cgit v1.2.3


From 48521fa4e131cd77cb8e8cdb32ff1f96120ec4f5 Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Tue, 28 Jun 2011 23:20:58 -0700
Subject: document better the UPDATE_VERSION

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

(limited to 'update.php')

diff --git a/update.php b/update.php
index ce8c694ca..306731a13 100644
--- a/update.php
+++ b/update.php
@@ -15,7 +15,7 @@ define( 'UPDATE_VERSION' , 1070 );
  * 
  * At the top of the file "boot.php" is a define for DB_UPDATE_VERSION. Any time there is a change
  * to the database schema or one which requires an upgrade path from the existing application,
- * the DB_UPDATE_VERSION is incremented.
+ * the DB_UPDATE_VERSION and the UPDATE_VERSION at the top of this file are incremented.
  *
  * The current DB_UPDATE_VERSION is stored in the config area of the database. If the application starts up
  * and DB_UPDATE_VERSION is greater than the last stored build number, we will process every update function 
-- 
cgit v1.2.3


From cdddfca0b5971d2437eee09ad6985f3df5ae5bfd Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Thu, 30 Jun 2011 19:02:11 -0700
Subject: photos were not working in private mail

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

(limited to 'update.php')

diff --git a/update.php b/update.php
index 306731a13..187662901 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1070 );
+define( 'UPDATE_VERSION' , 1071 );
 
 /**
  *
@@ -565,3 +565,10 @@ function update_1069() {
 	q("ALTER TABLE `fsuggest` ADD `request` CHAR( 255 ) NOT NULL AFTER `url` ");
 	q("ALTER TABLE `fcontact` ADD `request` CHAR( 255 ) NOT NULL AFTER `photo` ");
 }
+
+// mail body needs to accomodate private photos
+
+function update_1070() {
+	q("ALTER TABLE `mail` CHANGE `body` `body` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ");
+}
+
-- 
cgit v1.2.3


From fb0e758ce79c5c6a70d41766e3581bf756881d03 Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Fri, 1 Jul 2011 22:36:33 -0700
Subject: add some indexes to photos

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

(limited to 'update.php')

diff --git a/update.php b/update.php
index 187662901..775bf7b92 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1071 );
+define( 'UPDATE_VERSION' , 1072 );
 
 /**
  *
@@ -572,3 +572,11 @@ function update_1070() {
 	q("ALTER TABLE `mail` CHANGE `body` `body` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ");
 }
 
+function update_1071() {
+	q("ALTER TABLE `photo` ADD INDEX ( `uid` ) ");
+	q("ALTER TABLE `photo` ADD INDEX ( `resource-id` ) ");
+	q("ALTER TABLE `photo` ADD INDEX ( `album` ) ");
+	q("ALTER TABLE `photo` ADD INDEX ( `scale` ) ");
+	q("ALTER TABLE `photo` ADD INDEX ( `profile` ) ");
+
+}
-- 
cgit v1.2.3


From 07dc1c3ca931322af683edf9791ef47e295ca6cc Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sat, 2 Jul 2011 17:56:57 -0700
Subject: db support for starred (favorited) items

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

(limited to 'update.php')

diff --git a/update.php b/update.php
index 775bf7b92..08f1e6854 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1072 );
+define( 'UPDATE_VERSION' , 1073 );
 
 /**
  *
@@ -580,3 +580,8 @@ function update_1071() {
 	q("ALTER TABLE `photo` ADD INDEX ( `profile` ) ");
 
 }
+
+function update_1072() {
+	q("ALTER TABLE `item` ADD `starred` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `visible` ");
+	q("ALTER TABLE `item` ADD INDEX ( `starred` ) ");
+}
-- 
cgit v1.2.3