aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-09-19 01:01:51 -0700
committerfriendica <info@friendica.com>2013-09-19 01:01:51 -0700
commit63fc92b9e5d75f0dda0aecaaa0e1feb56d2b9744 (patch)
tree415659dab562b71736a628be8beb7103bc543886 /install/database.sql
parent14f6bf06e7d0dd7a851715bb081e2f2a55d79c2a (diff)
downloadvolse-hubzilla-63fc92b9e5d75f0dda0aecaaa0e1feb56d2b9744.tar.gz
volse-hubzilla-63fc92b9e5d75f0dda0aecaaa0e1feb56d2b9744.tar.bz2
volse-hubzilla-63fc92b9e5d75f0dda0aecaaa0e1feb56d2b9744.zip
sync item_search with yesterday's network fix for collections. Add ud_addr to update table to store the target address since it's possible the mirroring directory won't yet have an xchan or hubloc they can link the ud_hash to and therefore mayn't know how to contact them.
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index 21d7575e9..a74b30d59 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -892,11 +892,13 @@ CREATE TABLE IF NOT EXISTS `updates` (
`ud_guid` char(255) NOT NULL DEFAULT '',
`ud_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ud_flags` int(11) NOT NULL DEFAULT '0',
+ `ud_addr` char(255) NOT NULL DEFAULT '',
PRIMARY KEY (`ud_id`),
KEY `ud_hash` (`ud_hash`),
KEY `ud_guid` (`ud_guid`),
KEY `ud_date` (`ud_date`),
- KEY `ud_flags` (`ud_flags`)
+ KEY `ud_flags` (`ud_flags`),
+ KEY `ud_addr` (`ud_addr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `verify` (