diff options
| author | Friendika <info@friendika.com> | 2011-08-23 18:17:35 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-08-23 18:17:35 -0700 |
| commit | 56d64316f457c85141e35356a61a4d352ed9f24c (patch) | |
| tree | 40e6bb98c68efb6623bbda25dfc799cbe5e77661 /database.sql | |
| parent | 91de9edecd2663d5e3313da1b8a01a35e7e8970e (diff) | |
| download | volse-hubzilla-56d64316f457c85141e35356a61a4d352ed9f24c.tar.gz volse-hubzilla-56d64316f457c85141e35356a61a4d352ed9f24c.tar.bz2 volse-hubzilla-56d64316f457c85141e35356a61a4d352ed9f24c.zip | |
diaspora photos ?
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 605433e6e..f659e8049 100644 --- a/database.sql +++ b/database.sql @@ -267,6 +267,7 @@ CREATE TABLE IF NOT EXISTS `photo` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, `contact-id` int(10) unsigned NOT NULL, + `guid` char(64) NOT NULL, `resource-id` char(255) NOT NULL, `created` datetime NOT NULL, `edited` datetime NOT NULL, @@ -288,7 +289,8 @@ CREATE TABLE IF NOT EXISTS `photo` ( KEY `resource-id` (`resource-id`), KEY `album` (`album`), KEY `scale` (`scale`), - KEY `profile` (`profile`) + KEY `profile` (`profile`), + KEY `guid` (`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- |