Chat Read Receipts #2714

Ticket(s) / Related Merge Requests

#2714 (closed)

Summary of Changes

Introduces read receipts for chat

Testing Considerations

• Send a message from another
• Unread dot should show on clients

Deployment Considerations

CREATE TABLE IF NOT EXISTS minds_chat_receipts
(
    tenant_id           INT,
    room_guid           BIGINT,
    member_guid         BIGINT,
    message_guid        BIGINT,
    last_read_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),
    PRIMARY KEY (tenant_id, room_guid, member_guid),
    FOREIGN KEY (tenant_id, room_guid) REFERENCES minds_chat_rooms (tenant_id, room_guid),
    FOREIGN KEY (tenant_id, room_guid, message_guid) REFERENCES minds_chat_messages (tenant_id, room_guid, guid)
);

Regression Scope

None

Platform Affected (web, mobile, etc)

Web

Developer Testing Completed

@markharding 👍

Screenshots / Screen Recording

Does this impact

• Localization
• Dark/light mode
• Guest mode

Definition of Done Checklist

• The Acceptance Criteria has been met
• Code is tested: Testing includes unit/spec, E2E/automated and manual testing
• Merge requests description has been filled out