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
INSERT INTO public."Organization" ("id","name")
(SELECT 1, 'organization-one');
INSERT INTO public."macro_user" ("id", "username", "email", "stripe_customer_id")
VALUES ('a1111111-1111-1111-1111-111111111111', 'user', '[email protected]', 'stripe_id'),
('a2222222-2222-2222-2222-222222222222', 'user2', '[email protected]', 'stripe_id2'),
('a3333333-3333-3333-3333-333333333333', 'user3', '[email protected]', 'stripe_id3'),
('a5555555-5555-5555-5555-555555555555', 'user5', '[email protected]', 'stripe_id5');
INSERT INTO public."User" ("id","email","stripeCustomerId","macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]','stripe_id', 'a1111111-1111-1111-1111-111111111111');
INSERT INTO public."User" ("id","email","stripeCustomerId","macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]','stripe_id2', 'a2222222-2222-2222-2222-222222222222');
INSERT INTO public."User" ("id","email","stripeCustomerId","macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]','stripe_id3', 'a3333333-3333-3333-3333-333333333333');
INSERT INTO public."User" ("id","email","stripeCustomerId", "organizationId","macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]','stripe_id5', 1, 'a5555555-5555-5555-5555-555555555555');
INSERT INTO public."Project" ("id", "name", "userId", "createdAt", "updatedAt")
(SELECT 'p1', 'a', 'macro|[email protected]', '2019-10-16 00:00:00', '2019-10-16 00:00:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel", "createdAt", "updatedAt")
(SELECT 'sp-project1', NULL, NULL, '2019-10-16 00:00:00', '2019-10-16 01:00:00');
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p1', 'sp-project1');
INSERT INTO public."Project" ("id", "name", "userId", "parentId", "createdAt", "updatedAt")
(SELECT 'p2', 'a1', 'macro|[email protected]', 'p1', '2019-10-16 00:00:00', '2019-10-16 01:00:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel")
(SELECT 'sp-project2', NULL, NULL);
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p2', 'sp-project2');
INSERT INTO public."Document" ("id","name","fileType", "owner", "createdAt", "updatedAt", "projectId")
(SELECT 'd1', 'test_document_name','pdf', 'macro|[email protected]', '2019-10-16 00:00:00', '2019-10-16 00:00:00', 'p1');
INSERT INTO public."DocumentInstance" ("revisionName", "documentId", "createdAt", "updatedAt", "sha")
(SELECT 'test_document_name', 'd1', '2019-10-16 00:00:00', '2019-10-16 00:00:00', 'sha');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel", "createdAt", "updatedAt")
(SELECT 'sp-document1', 'PUBLIC', 'view', '2019-10-16 00:00:00', '2019-10-16 00:00:00');
INSERT INTO public."DocumentPermission" ("documentId", "sharePermissionId")
(SELECT 'd1', 'sp-document1');
INSERT INTO public."Document" ("id","name","fileType", "owner", "createdAt", "updatedAt")
(SELECT 'd2', 'test_document_name','docx', 'macro|[email protected]', '2019-10-16 00:10:00', '2019-10-16 00:10:00');
INSERT INTO public."DocumentBom" ("documentId", "createdAt", "updatedAt")
(SELECT 'd2', '2019-10-16 00:10:00', '2019-10-16 00:10:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel", "createdAt", "updatedAt")
(SELECT 'sp-document2', NULL, NULL, '2019-10-16 00:00:00', '2019-10-16 00:00:00');
INSERT INTO public."DocumentPermission" ("documentId", "sharePermissionId")
(SELECT 'd2', 'sp-document2');
INSERT INTO public."Chat" ("id","name","userId", "createdAt", "updatedAt", "projectId")
(SELECT 'c1', 'test-chat', 'macro|[email protected]', '2019-10-16 01:01:00', '2019-10-16 01:01:00', 'p1');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel", "createdAt", "updatedAt")
(SELECT 'sp-chat1', 'PUBLIC', 'view', '2019-10-16 00:00:00', '2019-10-16 00:00:00');
INSERT INTO public."ChatPermission" ("chatId", "sharePermissionId")
(SELECT 'c1', 'sp-chat1');
INSERT INTO public."Chat" ("id","name","userId", "createdAt", "updatedAt")
(SELECT 'c2', 'test-chat', 'macro|[email protected]', '2019-10-16 01:01:00', '2019-10-16 01:01:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel", "createdAt", "updatedAt")
(SELECT 'sp-chat2', NULL, NULL, '2019-10-16 00:00:00', '2019-10-16 00:00:00');
INSERT INTO public."ChatPermission" ("chatId", "sharePermissionId")
(SELECT 'c2', 'sp-chat2');