X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=ea129109dc366f0672b137081a06f5aa979990f3;hb=4d274cc3ea17725a0eb1cfe81bc4c3a60b10f6c9;hp=4237bcce344bd7df88f24db0f12bc1bd99e0244a;hpb=9a764516d0c9da99a7dd4fcde252c685b9de0a99;p=friendica.git

diff --git a/database.sql b/database.sql
index 4237bcce34..ea129109dc 100644
--- a/database.sql
+++ b/database.sql
@@ -644,10 +644,13 @@ CREATE TABLE IF NOT EXISTS `group` (
 	`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
 	`visible` boolean NOT NULL DEFAULT '0' COMMENT '1 indicates the member list is not private',
 	`deleted` boolean NOT NULL DEFAULT '0' COMMENT '1 indicates the group has been deleted',
+	`cid` int unsigned COMMENT 'Contact id of forum. When this field is filled then the members are synced automatically.',
 	`name` varchar(255) NOT NULL DEFAULT '' COMMENT 'human readable name of group',
 	 PRIMARY KEY(`id`),
 	 INDEX `uid` (`uid`),
-	FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
+	 INDEX `cid` (`cid`),
+	FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
+	FOREIGN KEY (`cid`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='privacy groups, group info';
 
 --