From 2018b88093a72a66a3e61c76794d8b967f7b2f4f Mon Sep 17 00:00:00 2001
From: redmatrix <redmatrix@redmatrix.me>
Date: Wed, 2 Sep 2015 20:53:26 -0700
Subject: dummy update

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

(limited to 'install/update.php')

diff --git a/install/update.php b/install/update.php
index d84b8c6d7..3fd75754d 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1150 );
+define( 'UPDATE_VERSION' , 1151 );
 
 /**
  *
@@ -1739,4 +1739,12 @@ function update_r1149() {
 	// hubzilla update does not apply here, but we're keeping the numbers in sync
 	return UPDATE_SUCCESS;
 
-}
\ No newline at end of file
+}
+
+function update_r1150() {
+
+	// hubzilla update does not apply here, but we're keeping the numbers in sync
+	return UPDATE_SUCCESS;
+
+}
+
-- 
cgit v1.2.3


From 669e1111187d1d1888358d833c62b5445a2b360b Mon Sep 17 00:00:00 2001
From: redmatrix <redmatrix@redmatrix.me>
Date: Wed, 2 Sep 2015 21:07:24 -0700
Subject: add timestamps for syncing apps

---
 install/update.php | 18 ++++++++++++++++--
 1 file changed, 16 insertions(+), 2 deletions(-)

(limited to 'install/update.php')

diff --git a/install/update.php b/install/update.php
index d0a0454fb..8e531b595 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1779,8 +1779,22 @@ function update_r1149() {
 
 function update_r1150() {
 
-	// hubzilla update does not apply here, but we're keeping the numbers in sync
-	return UPDATE_SUCCESS;
+	if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { 
+		$r1 = q("ALTER TABLE app ADD app_created timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
+			ADD app_edited timestamp NOT NULL DEFAULT '0001-01-01 00:00:00' ");
+	}
+	else {
+		$r1 = q("ALTER TABLE app ADD app_created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+			ADD app_edited DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ");
+	}
+
+	$r2 = q("create index app_created on app ( app_created ) ");
+	$r3 = q("create index app_edited on app ( app_edited ) ");
+
+	$r = $r1 && $r2 && $r3;
+    if($r)
+        return UPDATE_SUCCESS;
+    return UPDATE_FAILED;
 
 }
 
-- 
cgit v1.2.3