diff options
| author | Friendika <info@friendika.com> | 2011-08-07 17:29:26 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-08-07 17:29:26 -0700 |
| commit | 8812b7f4caa99d01ae0e082c0b29a2ee24aed67d (patch) | |
| tree | 0a5988272c513e7bcc789e7864f145f26a3bbfb0 /database.sql | |
| parent | 1eec10329a4764f132b159e7b1bbf37added6c8a (diff) | |
| download | volse-hubzilla-8812b7f4caa99d01ae0e082c0b29a2ee24aed67d.tar.gz volse-hubzilla-8812b7f4caa99d01ae0e082c0b29a2ee24aed67d.tar.bz2 volse-hubzilla-8812b7f4caa99d01ae0e082c0b29a2ee24aed67d.zip | |
item guids
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/database.sql b/database.sql index 152129337..89c4b4267 100644 --- a/database.sql +++ b/database.sql @@ -160,6 +160,7 @@ CREATE TABLE IF NOT EXISTS `intro` ( CREATE TABLE IF NOT EXISTS `item` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `guid` char(64) NOT NULL, `uri` char(255) NOT NULL, `uid` int(10) unsigned NOT NULL DEFAULT '0', `contact-id` int(10) unsigned NOT NULL DEFAULT '0', @@ -208,6 +209,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `deleted` tinyint(1) NOT NULL DEFAULT '0', `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), + KEY `guid` (`guid`), KEY `uri` (`uri`), KEY `uid` (`uid`), KEY `contact-id` (`contact-id`), |