aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorMichael Meer <michael@meer.name>2013-09-10 14:18:51 +0200
committerMichael Meer <michael@meer.name>2013-09-10 14:18:51 +0200
commitf93e92c260ca4ef248e5b079b1cd02a4a7d08d6c (patch)
treebcbee4156a53aef18b1d58302c0b2214d780b385 /install
parent933c30d95d73c039257428081a38206cfcd3756d (diff)
downloadvolse-hubzilla-f93e92c260ca4ef248e5b079b1cd02a4a7d08d6c.tar.gz
volse-hubzilla-f93e92c260ca4ef248e5b079b1cd02a4a7d08d6c.tar.bz2
volse-hubzilla-f93e92c260ca4ef248e5b079b1cd02a4a7d08d6c.zip
extends DB in hubloc to maintain hubloc connectivity
Diffstat (limited to 'install')
-rw-r--r--install/database.sql2
-rw-r--r--install/update.php9
2 files changed, 10 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index 9b1b6cad2..9ecbad5a6 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -367,6 +367,7 @@ CREATE TABLE IF NOT EXISTS `hubloc` (
`hubloc_hash` char(255) NOT NULL,
`hubloc_addr` char(255) NOT NULL DEFAULT '',
`hubloc_flags` int(10) unsigned NOT NULL DEFAULT '0',
+ `hubloc_status` int(10) unsigned NOT NULL DEFAULT '0',
`hubloc_url` char(255) NOT NULL DEFAULT '',
`hubloc_url_sig` text NOT NULL,
`hubloc_host` char(255) NOT NULL DEFAULT '',
@@ -379,6 +380,7 @@ CREATE TABLE IF NOT EXISTS `hubloc` (
KEY `hubloc_url` (`hubloc_url`),
KEY `hubloc_guid` (`hubloc_guid`),
KEY `hubloc_flags` (`hubloc_flags`),
+ KEY `hubloc_status` (`hubloc_status`),
KEY `hubloc_connect` (`hubloc_connect`),
KEY `hubloc_host` (`hubloc_host`),
KEY `hubloc_addr` (`hubloc_addr`),
diff --git a/install/update.php b/install/update.php
index 1b6a2218e..24aed374d 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1068 );
+define( 'UPDATE_VERSION' , 1069 );
/**
*
@@ -782,3 +782,10 @@ function update_r1067() {
return UPDATE_FAILED;
}
+function update_r1068(){
+ $r = q("ALTER TABLE `hubloc` ADD `hubloc_status` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `hubloc_flags` , ADD INDEX ( `hubloc_status` )");
+ if($r)
+ return UPDATE_SUCCESS;
+ return UPDATE_FAILED;
+}
+