Draft: Support creating paywalled posts - minds#4670

Ticket(s) / Related Merge Requests

minds#4670 (closed)

Summary of Changes

Maps a new activity post to one, multiple or all site memberships

Testing Considerations

See front MR

Deployment Considerations

Apply the schema changes

CREATE TABLE IF NOT EXISTS minds_site_membership_entities (
    tenant_id int,
    entity_guid bigint,
    membership_guid  bigint,
    created_timestamp timestamp DEFAULT CURRENT_TIMESTAMP(),
    PRIMARY KEY (tenant_id, entity_guid, membership_guid)
);

ALTER TABLE minds_entities_activity
    ADD COLUMN site_membership boolean DEFAULT FALSE
    AFTER attachments;
ALTER TABLE minds_entities_activity
    ADD COLUMN paywall_thumbnail boolean DEFAULT FALSE
    AFTER site_membership;
ALTER TABLE minds_entities_activity
    ADD COLUMN link_title text DEFAULT null
    AFTER paywall_thumbnail;

Regression Scope

Minimal

Platform Affected (web, mobile, etc)

API

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