aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-11-02 02:27:45 -0700
committerfriendica <info@friendica.com>2012-11-02 02:27:45 -0700
commit4fb898a0a336ac0843054b8c22dd26d695d718f7 (patch)
treebdbbe25ee051fd3a3c46d930923b4c691e9ecedf
parent9547e8004d2194f124d8ee25678c460a416c44ab (diff)
downloadvolse-hubzilla-4fb898a0a336ac0843054b8c22dd26d695d718f7.tar.gz
volse-hubzilla-4fb898a0a336ac0843054b8c22dd26d695d718f7.tar.bz2
volse-hubzilla-4fb898a0a336ac0843054b8c22dd26d695d718f7.zip
photo index contacts by xchan
-rw-r--r--install/database.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index 03c44e516..6acdd447c 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -707,6 +707,7 @@ CREATE TABLE IF NOT EXISTS `photo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`aid` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL,
+ `xchan` char(255) NOT NULL DEFAULT '',
`contact-id` int(10) unsigned NOT NULL DEFAULT '0',
`guid` char(64) NOT NULL,
`resource_id` char(255) NOT NULL,
@@ -734,7 +735,8 @@ CREATE TABLE IF NOT EXISTS `photo` (
KEY `profile` (`profile`),
KEY `type` (`type`),
KEY `contact-id` (`contact-id`),
- KEY `aid` (`aid`)
+ KEY `aid` (`aid`),
+ KEY `xchan` (`xchan`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `profile` (