X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=3622e27930c845f70aa1ace683710fff2d409003;hb=1493875ec989ae4d7d124248d67b8f4fa8359d5b;hp=f544d319bffe4c62167d1913fbac909eb18f2c30;hpb=17dbffe8246619a1a9814e5419c4ff3974bc4e84;p=friendica.git

diff --git a/database.sql b/database.sql
index f544d319bf..3622e27930 100644
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2020.09-dev (Red Hot Poker)
--- DB_UPDATE_VERSION 1362
+-- DB_UPDATE_VERSION 1363
 -- ------------------------------------------
 
 
@@ -922,7 +922,8 @@ CREATE TABLE IF NOT EXISTS `photo` (
 	 INDEX `uid_profile` (`uid`,`profile`),
 	 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`)
+	 INDEX `resource-id` (`resource-id`),
+	FOREIGN KEY (`contact-id`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE RESTRICT
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='photo storage';
 
 --