Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
-- Channels for testing
INSERT INTO comms_channels (id, name, channel_type, org_id, owner_id)
VALUES ('11111111-1111-1111-1111-111111111111', 'Test Public Channel', 'public', NULL, 'owner1'),
('22222222-2222-2222-2222-222222222222', 'Test Organization Channel', 'private', NULL, 'owner2'),
('33333333-3333-3333-3333-333333333333', 'Test Private Channel', 'private', NULL, 'owner3'),
('44444444-4444-4444-4444-444444444444', 'Channel With Deleted Message', 'public', NULL, 'owner4'),
('55555555-5555-5555-5555-555555555555', 'Channel With Multiple Mentions', 'public', NULL, 'owner5');
-- Channel participants
INSERT INTO comms_channel_participants (channel_id, role, user_id)
VALUES ('11111111-1111-1111-1111-111111111111', 'owner', 'user1'),
('11111111-1111-1111-1111-111111111111', 'member', 'user2'),
('11111111-1111-1111-1111-111111111111', 'member', 'user3'),
('22222222-2222-2222-2222-222222222222', 'owner', 'user3'),
('22222222-2222-2222-2222-222222222222', 'member', 'user4'),
('33333333-3333-3333-3333-333333333333', 'owner', 'user5'),
('44444444-4444-4444-4444-444444444444', 'owner', 'owner4'),
('55555555-5555-5555-5555-555555555555', 'owner', 'owner5');
-- Messages
INSERT INTO comms_messages (id, parent_entity_type, parent_entity_id, sender_id, content, thread_id, deleted_at)
VALUES
-- Message with mention in channel 1
('11111111-1111-1111-1111-111111111111', 'channel', '11111111-1111-1111-1111-111111111111', 'user1', 'Test message 1', NULL,
NULL),
-- Regular message in channel 2 (no mentions)
('22222222-2222-2222-2222-222222222222', 'channel', '22222222-2222-2222-2222-222222222222', 'user3', 'Regular message', NULL,
NULL),
-- Deleted message in channel 4
('44444444-4444-4444-4444-444444444444', 'channel', '44444444-4444-4444-4444-444444444444', 'user1', 'Deleted message', NULL,
NOW()),
-- Multiple messages in channel 5
('55555555-5555-5555-5555-555555555551', 'channel', '55555555-5555-5555-5555-555555555555', 'user1', 'Message 1', NULL, NULL),
('55555555-5555-5555-5555-555555555552', 'channel', '55555555-5555-5555-5555-555555555555', 'user2', 'Message 2', NULL, NULL);
-- Entity mentions
INSERT INTO comms_entity_mentions (id, source_entity_type, source_entity_id, entity_type, entity_id, created_at)
VALUES
-- Mention in channel 1
('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'message', '11111111-1111-1111-1111-111111111111', 'user', 'user1',
'2024-01-01 10:00:00'),
-- Mention in deleted message (channel 4)
('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'message', '44444444-4444-4444-4444-444444444444', 'user', 'user2',
'2024-01-01 11:00:00'),
-- Multiple mentions in channel 5
('cccccccc-cccc-cccc-cccc-cccccccccccc', 'message', '55555555-5555-5555-5555-555555555551', 'user', 'user3',
'2024-01-01 12:00:00'),
('dddddddd-dddd-dddd-dddd-dddddddddddd', 'message', '55555555-5555-5555-5555-555555555552', 'doc', 'doc1',
'2024-01-01 13:00:00');