diff options
| author | friendica <info@friendica.com> | 2012-11-02 02:27:45 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-11-02 02:27:45 -0700 |
| commit | 4fb898a0a336ac0843054b8c22dd26d695d718f7 (patch) | |
| tree | bdbbe25ee051fd3a3c46d930923b4c691e9ecedf /install/database.sql | |
| parent | 9547e8004d2194f124d8ee25678c460a416c44ab (diff) | |
| download | volse-hubzilla-4fb898a0a336ac0843054b8c22dd26d695d718f7.tar.gz volse-hubzilla-4fb898a0a336ac0843054b8c22dd26d695d718f7.tar.bz2 volse-hubzilla-4fb898a0a336ac0843054b8c22dd26d695d718f7.zip | |
photo index contacts by xchan
Diffstat (limited to 'install/database.sql')
| -rw-r--r-- | install/database.sql | 4 |
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` ( |