X-Git-Url: https://git.stricted.de/?a=blobdiff_plain;f=install.sql;h=2a8cd2fbdc5419d57e41f1f6dc8bd188868c4cd2;hb=5ca42b0093d6b11d30f89cb4696541b9c4dff24c;hp=4f05fdee0098b721621c3dfe5df5e37a38134601;hpb=c69e3794ccd278e39fc7dfe46a59a2090d8853cc;p=GitHub%2FWoltLab%2Fcom.woltlab.wcf.conversation.git

diff --git a/install.sql b/install.sql
index 4f05fde..2a8cd2f 100644
--- a/install.sql
+++ b/install.sql
@@ -32,6 +32,7 @@ CREATE TABLE wcf1_conversation_to_user (
 	joinedAt INT(10) NOT NULL DEFAULT 0,
 	leftAt INT(10) NOT NULL DEFAULT 0,
 	lastMessageID INT(10) NULL,
+	leftByOwnChoice TINYINT(1) NOT NULL DEFAULT 1,
 	
 	UNIQUE KEY (participantID, conversationID),
 	KEY (participantID, hideConversation)
@@ -73,6 +74,8 @@ CREATE TABLE wcf1_conversation_label_to_object (
 	UNIQUE KEY (labelID, conversationID)
 );
 
+ALTER TABLE wcf1_user_group ADD canBeAddedAsConversationParticipant TINYINT(1) NOT NULL DEFAULT 0;
+
 ALTER TABLE wcf1_conversation ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
 ALTER TABLE wcf1_conversation ADD FOREIGN KEY (lastPosterID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
 ALTER TABLE wcf1_conversation ADD FOREIGN KEY (firstMessageID) REFERENCES wcf1_conversation_message (messageID) ON DELETE SET NULL;