From 4fb898a0a336ac0843054b8c22dd26d695d718f7 Mon Sep 17 00:00:00 2001 From: friendica Date: Fri, 2 Nov 2012 02:27:45 -0700 Subject: photo index contacts by xchan --- install/database.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'install/database.sql') 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` ( -- cgit v1.2.3