aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2014-09-03 05:09:43 -0700
committerfriendica <info@friendica.com>2014-09-03 05:09:43 -0700
commite8ef515b6136ee79ff17e1c143a15e29691d3d81 (patch)
treed81e295924df1c4c9c792c4a25306b4eed16bc56 /install
parent75d0f6329cc532c7f74927bdaa678d8d85f45a9e (diff)
downloadvolse-hubzilla-e8ef515b6136ee79ff17e1c143a15e29691d3d81.tar.gz
volse-hubzilla-e8ef515b6136ee79ff17e1c143a15e29691d3d81.tar.bz2
volse-hubzilla-e8ef515b6136ee79ff17e1c143a15e29691d3d81.zip
store diaspora meta info in the item table. It has to go there or it will kill us with complex joins. We can phase out the sign table once this all checks out.
Diffstat (limited to 'install')
-rw-r--r--install/database.sql1
-rw-r--r--install/update.php11
2 files changed, 11 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index c773fab10..a49bd377c 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -535,6 +535,7 @@ CREATE TABLE IF NOT EXISTS `item` (
`resource_type` char(16) NOT NULL DEFAULT '',
`attach` mediumtext NOT NULL DEFAULT '',
`sig` text NOT NULL DEFAULT '',
+ `diaspora_meta` mediumtext NOT NULL DEFAULT '',
`location` char(255) NOT NULL DEFAULT '',
`coord` char(255) NOT NULL DEFAULT '',
`public_policy` char(255) NOT NULL DEFAULT '',
diff --git a/install/update.php b/install/update.php
index 92cb200a3..0b1fa5d2e 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1128 );
+define( 'UPDATE_VERSION' , 1129 );
/**
*
@@ -1448,3 +1448,12 @@ ADD INDEX ( `comments_closed` ), ADD INDEX ( `changed` ) ");
return UPDATE_FAILED;
}
+
+function update_r1128() {
+ $r = q("ALTER TABLE `item` ADD `diaspora_meta` MEDIUMTEXT NOT NULL DEFAULT '' AFTER `sig` ");
+ if($r)
+ return UPDATE_SUCCESS;
+ return UPDATE_FAILED;
+
+}
+