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.0 KB
Raw Blame
INSERT INTO "Organization" (id, name) VALUES (1, 'test organization');

INSERT INTO "macro_user" (id, username, email, stripe_customer_id)
VALUES
    ('a1111111-1111-1111-1111-111111111111', '[email protected]', '[email protected]', 'stripe_id'),
    ('a2222222-2222-2222-2222-222222222222', '[email protected]', '[email protected]', 'stripe_id2'),
    ('a3333333-3333-3333-3333-333333333333', '[email protected]', '[email protected]', 'stripe_id3');

INSERT INTO public."User" ("id","email","stripeCustomerId", "organizationId", "macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]','stripe_id', 1, 'a1111111-1111-1111-1111-111111111111');
INSERT INTO public."User" ("id","email","stripeCustomerId", "organizationId", "macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]','stripe_id2', 1, '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."Document" ("id","name","fileType", "owner")
(SELECT 'd1', 'test_document_name','pdf', 'macro|[email protected]');
INSERT INTO public."ItemLastAccessed" ("item_id", "item_type", "last_accessed")
(SELECT 'd1', 'document', NOW() - INTERVAL '5 days');

INSERT INTO public."Document" ("id","name","fileType", "owner")
(SELECT 'd1a', 'test_document_name','pdf', 'macro|[email protected]');
INSERT INTO public."ItemLastAccessed" ("item_id", "item_type", "last_accessed")
(SELECT 'd1a', 'document', NOW() - INTERVAL '1 days');

INSERT INTO public."Document" ("id","name","fileType", "owner")
(SELECT 'd2', 'test_document_name','docx', 'macro|[email protected]');
INSERT INTO public."ItemLastAccessed" ("item_id", "item_type", "last_accessed")
(SELECT 'd2', 'document', NOW() - INTERVAL '2 days');

INSERT INTO public."Document" ("id","name","fileType", "owner")
(SELECT 'd3', 'test_document_name','md', 'macro|[email protected]');
INSERT INTO public."ItemLastAccessed" ("item_id", "item_type", "last_accessed")
(SELECT 'd3', 'document', NOW() - INTERVAL '33 days');

INSERT INTO public."Chat" ("id","name","userId")
(SELECT 'c1', 'test_chat_name', 'macro|[email protected]');
INSERT INTO public."ItemLastAccessed" ("item_id", "item_type", "last_accessed")
(SELECT 'c1', 'chat', NOW() - INTERVAL '5 days');

INSERT INTO public."Chat" ("id","name","userId")
(SELECT 'c1a', 'test_chat_name', 'macro|[email protected]');
INSERT INTO public."ItemLastAccessed" ("item_id", "item_type", "last_accessed")
(SELECT 'c1a', 'chat', NOW() - INTERVAL '1 days');

INSERT INTO public."Chat" ("id","name","userId")
(SELECT 'c2', 'test_chat_name', 'macro|[email protected]');
INSERT INTO public."ItemLastAccessed" ("item_id", "item_type", "last_accessed")
(SELECT 'c2', 'chat', NOW() - INTERVAL '2 days');

INSERT INTO public."Chat" ("id","name","userId")
(SELECT 'c3', 'test_chat_name', 'macro|[email protected]');
INSERT INTO public."ItemLastAccessed" ("item_id", "item_type", "last_accessed")
(SELECT 'c3', 'chat', NOW() - INTERVAL '33 days');