Merge pull request #11879 from annando/receive-reshare

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 417eddfcdec2ef6c69737873158026470af8b4b5..e363dd57dda033318ca30c9137033f58f5d438bf 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1159,7 +1159,7 @@ CREATE TABLE IF NOT EXISTS `post-collection` (
         INDEX `type` (`type`),
         INDEX `author-id` (`author-id`),
        FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
-       FOREIGN KEY (`author-id`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE RESTRICT
+       FOREIGN KEY (`author-id`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Collection of posts';
 
 --
@@ -1416,6 +1416,7 @@ CREATE TABLE IF NOT EXISTS `post-user` (
         INDEX `author-id_uid` (`author-id`,`uid`),
         INDEX `author-id_received` (`author-id`,`received`),
         INDEX `parent-uri-id_uid` (`parent-uri-id`,`uid`),
+        INDEX `uid_wall_received` (`uid`,`wall`,`received`),
         INDEX `uid_contactid` (`uid`,`contact-id`),
         INDEX `uid_unseen_contactid` (`uid`,`unseen`,`contact-id`),
         INDEX `uid_unseen` (`uid`,`unseen`),