Added DB schema for site memberships minds#4668

Ticket(s) / Related Merge Requests

minds#4668 (closed)

Summary of Changes

Added DB schema for site memberships

Testing Considerations

Deployment Considerations

Apply schema changes to Vitess production DB:

CREATE TABLE minds_site_membership_tiers (
    tenant_id int,
    membership_tier_guid bigint,
    stripe_product_id varchar(256),
    PRIMARY KEY (tenant_id, membership_tier_guid)
);

CREATE TABLE minds_site_membership_tiers_role_assignments (
    tenant_id int NOT NULL,
    membership_tier_guid bigint NOT NULL,
    role_id int NOT NULL,
    PRIMARY KEY (tenant_id, membership_tier_guid, role_id)
);

CREATE TABLE minds_site_membership_tiers_group_assignments (
    tenant_id int NOT NULL,
    membership_tier_guid bigint NOT NULL,
    group_guid bigint NOT NULL,
    PRIMARY KEY (tenant_id, membership_tier_guid, group_guid)
);

CREATE TABLE minds_site_membership_subscriptions (
    tenant_id int NOT NULL,
    user_guid bigint NOT NULL,
    membership_tier_guid bigint NOT NULL,
    stripe_subscription_id varchar(256) NOT NULL,
    valid_from timestamp NOT NULL,
    valid_to timestamp DEFAULT NULL,
    PRIMARY KEY (tenant_id, user_guid, membership_tier_guid, valid_from)
);

Regression Scope

Platform Affected (web, mobile, etc)

Developer Testing Completed

Schema has been applied to Sandbox DB

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