diff options
| author | friendica <info@friendica.com> | 2014-09-03 05:09:43 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2014-09-03 05:09:43 -0700 |
| commit | e8ef515b6136ee79ff17e1c143a15e29691d3d81 (patch) | |
| tree | d81e295924df1c4c9c792c4a25306b4eed16bc56 /install | |
| parent | 75d0f6329cc532c7f74927bdaa678d8d85f45a9e (diff) | |
| download | volse-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.sql | 1 | ||||
| -rw-r--r-- | install/update.php | 11 |
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; + +} + |