Merge branch '5.3'

[GitHub/WoltLab/com.woltlab.wcf.conversation.git] / install.sql

diff --git a/install.sql b/install.sql
index dcf2b0f22ef668ad845fd09c747676f6b927d6d6..2a8cd2fbdc5419d57e41f1f6dc8bd188868c4cd2 100644 (file)
--- a/install.sql
+++ b/install.sql
@@ -29,6 +29,10 @@ CREATE TABLE wcf1_conversation_to_user (
        hideConversation TINYINT(1) NOT NULL DEFAULT 0,
        isInvisible TINYINT(1) NOT NULL DEFAULT 0,
        lastVisitTime INT(10) NOT NULL DEFAULT 0,
+       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)
@@ -43,10 +47,7 @@ CREATE TABLE wcf1_conversation_message (
        message MEDIUMTEXT NOT NULL,
        time INT(10) NOT NULL DEFAULT 0,
        attachments SMALLINT(5) NOT NULL DEFAULT 0,
-       enableSmilies TINYINT(1) NOT NULL DEFAULT 1,
        enableHtml TINYINT(1) NOT NULL DEFAULT 0,
-       enableBBCodes TINYINT(1) NOT NULL DEFAULT 1,
-       showSignature TINYINT(1) NOT NULL DEFAULT 1,
        ipAddress VARCHAR(39) NOT NULL DEFAULT '',
        lastEditTime INT(10) NOT NULL DEFAULT 0,
        editCount MEDIUMINT(7) NOT NULL DEFAULT 0,
@@ -73,12 +74,15 @@ 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;
 
 ALTER TABLE wcf1_conversation_to_user ADD FOREIGN KEY (conversationID) REFERENCES wcf1_conversation (conversationID) ON DELETE CASCADE;
 ALTER TABLE wcf1_conversation_to_user ADD FOREIGN KEY (participantID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
+ALTER TABLE wcf1_conversation_to_user ADD FOREIGN KEY (lastMessageID) REFERENCES wcf1_conversation_message (messageID) ON DELETE SET NULL;
 
 ALTER TABLE wcf1_conversation_message ADD FOREIGN KEY (conversationID) REFERENCES wcf1_conversation (conversationID) ON DELETE CASCADE;
 ALTER TABLE wcf1_conversation_message ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;