Skip to content

armgit / macro

Public Imported from GitHub
0

Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.

2.4 KB
Raw Blame
INSERT INTO macro_user (id, email, stripe_customer_id, username) VALUES
('11111111-1111-1111-1111-111111111111', '[email protected]', 'cus_1234', 'user');

INSERT INTO "User" ("id", "email", "name", "stripeCustomerId", macro_user_id) VALUES
('macro|[email protected]', '[email protected]', 'User', 'cus_1234', '11111111-1111-1111-1111-111111111111');

INSERT INTO "Document" ("id", "name", "fileType", "owner", "createdAt", "updatedAt")
VALUES
    ('11111111-1111-1111-1111-111111111111', 'document', 'pdf', 'macro|[email protected]', '2019-10-16 00:00:00', '2019-10-16 00:00:00');

INSERT INTO "Chat" ("id", "name", "userId", "createdAt", "updatedAt")
VALUES
    ('11111111-1111-1111-1111-111111111111', 'chat', 'macro|[email protected]', '2019-10-16 01:01:00', '2019-10-16 01:01:00');

INSERT INTO comms_channels (id, name, channel_type, org_id, owner_id)
VALUES ('11111111-1111-1111-1111-111111111111', 'channel', 'public', NULL, 'macro|[email protected]');

INSERT INTO email_links (id, macro_id, fusionauth_user_id, email_address, provider, is_sync_active, created_at,
                         updated_at)
VALUES ('11111111-1111-1111-1111-111111111111', 'macro|[email protected]', '11111111-1111-1111-1111-111111111111',
        '[email protected]', 'GMAIL', true, '2025-11-11 17:48:26.664688 +00:00',
        '2025-11-11 17:48:26.664688 +00:00');

-- Thread 1: used for condition 1 (is_sent = true)
INSERT INTO email_threads (id, link_id, inbox_visible, is_read, created_at, updated_at)
VALUES ('11111111-1111-1111-1111-111111111111',
        '11111111-1111-1111-1111-111111111111',
        false,
        false,
        NOW(),
        NOW());

INSERT INTO email_messages (id,
                            thread_id,
                            link_id,
                            provider_id,
                            is_sent,
                            from_contact_id,
                            internal_date_ts,
                            has_attachments,
                            is_read,
                            is_starred,
                            is_draft,
                            created_at,
                            updated_at,
                            subject)
VALUES ('11111111-1111-1111-1111-111111111111',
        '11111111-1111-1111-1111-111111111111',
        '11111111-1111-1111-1111-111111111111',
        'provider-msg-101',
        TRUE,
        NULL,
        NOW(),
        true,
        false,
        false,
        false,
        NOW(),
        NOW(),
        'subject');