User post notification minds#4504

Ticket(s) / Related Merge Requests

minds#4504 (closed)

Summary of Changes

Allows for users to receive notifications when a user post

Testing Considerations

Deployment Considerations

CREATE TABLE IF NOT EXISTS minds_post_notification_subscriptions (
    tenant_id INT NOT NULL,
    user_guid BIGINT NOT NULL,
    entity_guid BIGINT NOT NULL,
    frequency enum ('ALWAYS', 'HIGHLIGHTS', 'NEVER') DEFAULT 'ALWAYS',
    created_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),
    updated_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),
    PRIMARY KEY (tenant_id, user_guid, entity_guid),
    INDEX (tenant_id, entity_guid)
);

Regression Scope

Low. Changes have been made to 'Follow post'.

Platform Affected (web, mobile, etc)

Developer Testing Completed

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