diff options
| -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` ( |