aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-10-27 22:04:59 -0700
committerfriendica <info@friendica.com>2013-10-27 22:04:59 -0700
commitd389ceed6cc44c54c971da4bb8538850a0fb0672 (patch)
treee9fb9d47fbbb878ca5eb81b6573de00621b83aec
parent52f447513f9b52df7e4c4c3d3622434fb63151b2 (diff)
downloadvolse-hubzilla-d389ceed6cc44c54c971da4bb8538850a0fb0672.tar.gz
volse-hubzilla-d389ceed6cc44c54c971da4bb8538850a0fb0672.tar.bz2
volse-hubzilla-d389ceed6cc44c54c971da4bb8538850a0fb0672.zip
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.
-rwxr-xr-xboot.php2
-rw-r--r--install/database.sql2
-rw-r--r--install/update.php10
3 files changed, 12 insertions, 2 deletions
diff --git a/boot.php b/boot.php
index ba62bffa6..709877472 100755
--- a/boot.php
+++ b/boot.php
@@ -45,7 +45,7 @@ define ( 'RED_PLATFORM', 'Red Matrix' );
define ( 'RED_VERSION', trim(file_get_contents('version.inc')) . 'R');
define ( 'ZOT_REVISION', 1 );
-define ( 'DB_UPDATE_VERSION', 1078 );
+define ( 'DB_UPDATE_VERSION', 1079 );
define ( 'EOL', '<br />' . "\r\n" );
define ( 'ATOM_TIME', 'Y-m-d\TH:i:s\Z' );
diff --git a/install/database.sql b/install/database.sql
index 3998c13c7..b482c3376 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -155,6 +155,7 @@ CREATE TABLE IF NOT EXISTS `channel` (
`channel_prvkey` text NOT NULL,
`channel_notifyflags` int(10) unsigned NOT NULL DEFAULT '65535',
`channel_pageflags` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_dirdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`channel_deleted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`channel_max_anon_mail` int(10) unsigned NOT NULL DEFAULT '10',
`channel_max_friend_req` int(10) unsigned NOT NULL DEFAULT '10',
@@ -192,6 +193,7 @@ CREATE TABLE IF NOT EXISTS `channel` (
KEY `channel_theme` (`channel_theme`),
KEY `channel_notifyflags` (`channel_notifyflags`),
KEY `channel_pageflags` (`channel_pageflags`),
+ KEY `channel_dirdate` (`channel_dirdate`),
KEY `channel_max_anon_mail` (`channel_max_anon_mail`),
KEY `channel_max_friend_req` (`channel_max_friend_req`),
KEY `channel_default_gid` (`channel_default_group`),
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;
+}