X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=database.sql;h=69d87c3698c3a85a4a814d7885bdd32f5d93fcb6;hb=9c2b1d39ea268fbb0aec61f3d586fcb939fa26e1;hp=cf060ebf499ec43ae5894c8ed867ff83532e27b6;hpb=cc9ce39e3f1d7335de2124f78c5ecb02becd197c;p=friendica.git

diff --git a/database.sql b/database.sql
index cf060ebf49..69d87c3698 100644
--- a/database.sql
+++ b/database.sql
@@ -562,6 +562,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `forum_mode` tinyint(1) NOT NULL DEFAULT '0',
   `mention` tinyint(1) NOT NULL DEFAULT '0',
   `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1',
+  `network` char(32) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `uri` (`uri`),
   KEY `uid` (`uid`),
@@ -591,6 +592,9 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `uid_created` (`uid`, `created`),
   KEY `uid_unseen` (`uid`, `unseen`),
   KEY `mention` (`mention`),
+  KEY `resource-id` (`resource-id`),
+  KEY `event_id` (`event-id`),
+  KEY `network` (`network`),
   FULLTEXT KEY `title` (`title`),
   FULLTEXT KEY `body` (`body`),
   FULLTEXT KEY `allow_cid` (`allow_cid`),