X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=3ca42e3377c8e974ab0daffcc71c5ae19ef56f1d;hb=1342825401e6e9e079eeec212271046930e1f475;hp=b37036762e4be0d553d5bac573326c921bea75bd;hpb=085059bd92a6d6f4734f9a26a76be995c826a763;p=friendica.git

diff --git a/database.sql b/database.sql
index b37036762e..3ca42e3377 100644
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2020.12-dev (Red Hot Poker)
--- DB_UPDATE_VERSION 1378
+-- DB_UPDATE_VERSION 1379
 -- ------------------------------------------
 
 
@@ -332,6 +332,7 @@ CREATE TABLE IF NOT EXISTS `apcontact` (
 	 INDEX `alias` (`alias`(190)),
 	 INDEX `followers` (`followers`(190)),
 	 INDEX `baseurl` (`baseurl`(190)),
+	 INDEX `sharedinbox` (`sharedinbox`(190)),
 	 INDEX `gsid` (`gsid`),
 	FOREIGN KEY (`gsid`) REFERENCES `gserver` (`id`) ON UPDATE RESTRICT ON DELETE RESTRICT
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='ActivityPub compatible contacts - used in the ActivityPub implementation';
@@ -1057,7 +1058,7 @@ CREATE TABLE IF NOT EXISTS `photo` (
 	 INDEX `uid_album_scale_created` (`uid`,`album`(32),`scale`,`created`),
 	 INDEX `uid_album_resource-id_created` (`uid`,`album`(32),`resource-id`,`created`),
 	 INDEX `resource-id` (`resource-id`),
-	FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
+	FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE RESTRICT,
 	FOREIGN KEY (`contact-id`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE RESTRICT
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='photo storage';