From 53b5cf7f507df53d3e382b6714caacf9551ed6db Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Thu, 28 Aug 2014 16:56:13 -0700
Subject: Ability to close comments at a certain date/time - needed for loom.io
 emulation (and many other uses)

---
 install/database.sql |  3 +++
 install/update.php   | 10 +++++++++-
 2 files changed, 12 insertions(+), 1 deletion(-)

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index acf59a36d..c773fab10 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -511,6 +511,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `comments_closed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `owner_xchan` char(255) NOT NULL DEFAULT '',
   `author_xchan` char(255) NOT NULL DEFAULT '',
   `source_xchan` char(255) NOT NULL DEFAULT '',
@@ -553,6 +554,8 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `received` (`received`),
   KEY `uid_commented` (`uid`,`commented`),
   KEY `uid_created` (`uid`,`created`),
+  KEY `changed` (`changed`),
+  KEY `comments_closed` (`comments_closed`),
   KEY `aid` (`aid`),
   KEY `owner_xchan` (`owner_xchan`),
   KEY `author_xchan` (`author_xchan`),
diff --git a/install/update.php b/install/update.php
index 5319942ee..92cb200a3 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1127 );
+define( 'UPDATE_VERSION' , 1128 );
 
 /**
  *
@@ -1440,3 +1440,11 @@ ADD INDEX ( `convid` )");
 
 }
 
+function update_r1127() {
+	$r = q("ALTER TABLE `item` ADD `comments_closed` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `changed` ,
+ADD INDEX ( `comments_closed` ), ADD INDEX ( `changed` ) ");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+
+}
-- 
cgit v1.2.3