X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=89c4b4267c4de032fae42a874950ad4c7f10bdf3;hb=db03b1ab173d61b1ee75271dac1e48f3475ad42c;hp=1521293378f14491e1a823f1ac1d3db11e849f98;hpb=eea493d1f575871f89ede359a9a216ff4c39ea53;p=friendica.git

diff --git a/database.sql b/database.sql
index 1521293378..89c4b4267c 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`),