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)
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;