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

diff --git a/database.sql b/database.sql
index 50697845a3..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`),
@@ -573,3 +575,9 @@ CREATE TABLE IF NOT EXISTS `attach` (
 `deny_gid` MEDIUMTEXT NOT NULL
 ) ENGINE = MYISAM DEFAULT CHARSET=utf8;
 
+CREATE TABLE IF NOT EXISTS `guid` (
+`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`guid` CHAR( 64 ) NOT NULL ,
+INDEX ( `guid` )
+) ENGINE = MYISAM  DEFAULT CHARSET=utf8;
+