Delete of item-content should work now

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index cca1163145d2e6208889598f4ed1f3d5d4096ef5..9711ace803eed6a73dee7c4bbf3d1e64a7029d9c 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -541,7 +541,8 @@ CREATE TABLE IF NOT EXISTS `item` (
         INDEX `contactid_verb` (`contact-id`,`verb`),
         INDEX `deleted_changed` (`deleted`,`changed`),
         INDEX `uid_wall_changed` (`uid`,`wall`,`changed`),
-        INDEX `uid_eventid` (`uid`,`event-id`)
+        INDEX `uid_eventid` (`uid`,`event-id`),
+        INDEX `icid` (`icid`)
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Structure for all posts';
 
 --