aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-08-31 04:30:01 -0700
committerfriendica <info@friendica.com>2013-08-31 04:30:01 -0700
commit00622779f3fd68bf9ae4860d776c65c82ae1c0c0 (patch)
treee1c1549016f1271af5269d77e82295702822a8d8 /install
parent625dcb911a01983f4767a55567a0374d6045093e (diff)
downloadvolse-hubzilla-00622779f3fd68bf9ae4860d776c65c82ae1c0c0.tar.gz
volse-hubzilla-00622779f3fd68bf9ae4860d776c65c82ae1c0c0.tar.bz2
volse-hubzilla-00622779f3fd68bf9ae4860d776c65c82ae1c0c0.zip
add a guid to directory update table to avoid recursion
Diffstat (limited to 'install')
-rw-r--r--install/database.sql2
-rw-r--r--install/update.php11
2 files changed, 12 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index dbffbf59b..2f92167c8 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -882,8 +882,10 @@ CREATE TABLE IF NOT EXISTS `tokens` (
CREATE TABLE IF NOT EXISTS `updates` (
`ud_hash` char(128) NOT NULL,
+ `ud_guid` char(255) NOT NULL DEFAULT '',
`ud_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`ud_hash`),
+ KEY `ud_guid` (`ud_guid`),
KEY `ud_date` (`ud_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/install/update.php b/install/update.php
index 9beb25254..13dded6fe 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1064 );
+define( 'UPDATE_VERSION' , 1065 );
/**
*
@@ -750,3 +750,12 @@ ADD INDEX ( `xchan_follow` ), ADD INDEX ( `xchan_connpage`) ");
return UPDATE_SUCCESS;
return UPDATE_FAILED;
}
+
+function update_r1064() {
+ $r = q("ALTER TABLE `updates` ADD `ud_guid` CHAR( 255 ) NOT NULL DEFAULT '' AFTER `ud_hash` ,
+ADD INDEX ( `ud_guid` )");
+ if($r)
+ return UPDATE_SUCCESS;
+ return UPDATE_FAILED;
+}
+