From d389ceed6cc44c54c971da4bb8538850a0fb0672 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Sun, 27 Oct 2013 22:04:59 -0700
Subject: Schema change - add channel_dirdate so we can ping a directory server
 once a month which means we can find dead channels - because they won't be
 pinging the directory server once a month.

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

(limited to 'install/update.php')

diff --git a/install/update.php b/install/update.php
index 74134f260..07a773f68 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1078 );
+define( 'UPDATE_VERSION' , 1079 );
 
 /**
  *
@@ -873,3 +873,11 @@ function update_r1077() {
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1078() {
+	$r = q("ALTER TABLE `channel` ADD `channel_dirdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `channel_pageflags` , ADD INDEX ( `channel_dirdate` )");
+
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
-- 
cgit v1.2.3


From 2035a5dd763f7524cdc1a678b0e8dbca94f270f5 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 30 Oct 2013 01:58:45 -0700
Subject: allow zot public providers to list their location, as a non US-based
 server could be a strong selling point.

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

(limited to 'install/update.php')

diff --git a/install/update.php b/install/update.php
index 07a773f68..53d487f91 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1079 );
+define( 'UPDATE_VERSION' , 1080 );
 
 /**
  *
@@ -881,3 +881,10 @@ function update_r1078() {
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1079() {
+	$r = q("ALTER TABLE `site` ADD `site_location` CHAR( 255 ) NOT NULL DEFAULT ''");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
-- 
cgit v1.2.3


From 8b9633e46b7cdd4241e369d8f9cf10cec14956d2 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 6 Nov 2013 17:27:51 -0800
Subject: DB - allow private messages to expire

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

(limited to 'install/update.php')

diff --git a/install/update.php b/install/update.php
index 53d487f91..e1fd8c7a4 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1080 );
+define( 'UPDATE_VERSION' , 1081 );
 
 /**
  *
@@ -888,3 +888,11 @@ function update_r1079() {
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1080() {
+	$r = q("ALTER TABLE `mail` ADD `expires` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+ADD INDEX ( `expires` ) ");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
-- 
cgit v1.2.3