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.

3.3 KB
Raw Blame
INSERT INTO comms_channels (id, name, channel_type, org_id, owner_id, created_at, updated_at)
VALUES ('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'alpha', 'private', NULL, 'owner1', NOW(), NOW()),
       ('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'beta', 'private', NULL, 'owner2', NOW(), NOW()),
       ('cccccccc-cccc-cccc-cccc-cccccccccccc', 'gamma', 'private', NULL, 'owner3', NOW(), NOW()),
       ('dddddddd-dddd-dddd-dddd-dddddddddddd', 'delta', 'private', NULL, 'owner4', NOW(), NOW());

INSERT INTO comms_channel_participants (channel_id, role, user_id)
VALUES ('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'owner', 'owner1'),
       ('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'owner', 'owner2'),
       ('cccccccc-cccc-cccc-cccc-cccccccccccc', 'owner', 'owner3'),
       ('dddddddd-dddd-dddd-dddd-dddddddddddd', 'owner', 'owner4');

INSERT INTO comms_messages (id, parent_entity_type, parent_entity_id, sender_id, content, created_at, thread_id, deleted_at)
VALUES ('aaaaaa1a-0000-0000-0000-000000000001', 'channel', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'u1', 'A: first non-thread',
        '2024-01-01T10:00:00Z', NULL, NULL),
       ('aaaaaa2a-0000-0000-0000-000000000002', 'channel', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'u1', 'A: thread root',
        '2024-01-02T10:00:00Z', NULL, NULL),
       ('aaaaaa1a-0000-0000-0000-000000000003', 'channel', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'u2', 'A: reply 1',
        '2024-01-03T10:00:00Z', 'aaaaaa2a-0000-0000-0000-000000000002', NULL),
       ('aaaaaa2a-0000-0000-0000-000000000004', 'channel', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'u3', 'A: reply 2 (latest)',
        '2024-01-04T10:00:00Z', 'aaaaaa2a-0000-0000-0000-000000000002', NULL);

INSERT INTO comms_messages (id, parent_entity_type, parent_entity_id, sender_id, content, created_at, thread_id, deleted_at)
VALUES ('bbbbbbde-0000-0000-0000-000000000001', 'channel', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'u1', 'B: deleted root',
        '2024-02-01T09:00:00Z', NULL, '2024-02-01T10:00:00Z'),
       ('bbbbbb1b-0000-0000-0000-000000000002', 'channel', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'u2', 'B: reply 1',
        '2024-02-02T09:00:00Z', 'bbbbbbde-0000-0000-0000-000000000001', NULL),
       ('bbbbbb2b-0000-0000-0000-000000000003', 'channel', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'u3', 'B: reply 2',
        '2024-02-03T09:00:00Z', 'bbbbbbde-0000-0000-0000-000000000001', NULL);

INSERT INTO comms_messages (id, parent_entity_type, parent_entity_id, sender_id, content, created_at, thread_id, deleted_at)
VALUES ('cccccc1c-0000-0000-0000-000000000001', 'channel', 'cccccccc-cccc-cccc-cccc-cccccccccccc', 'u1', 'C: non-thread 1',
        '2024-03-01T08:00:00Z', NULL, NULL),
       ('cccccc2c-0000-0000-0000-000000000002', 'channel', 'cccccccc-cccc-cccc-cccc-cccccccccccc', 'u2', 'C: non-thread 2',
        '2024-03-02T08:00:00Z', NULL, NULL);

INSERT INTO comms_messages (id, parent_entity_type, parent_entity_id, sender_id, content, created_at, thread_id, deleted_at)
VALUES ('dddddd1d-0000-0000-0000-000000000001', 'channel', 'dddddddd-dddd-dddd-dddd-dddddddddddd', 'u1', 'D: visible',
        '2024-04-01T12:00:00Z', NULL, NULL),
       ('ddddddde-0000-0000-0000-000000000002', 'channel', 'dddddddd-dddd-dddd-dddd-dddddddddddd', 'u2', 'D: deleted newer',
        '2024-04-02T12:00:00Z', NULL, '2024-04-02T13:00:00Z');