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.

5.0 KB
Raw Blame
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", "createdAt", "updatedAt")
(SELECT 'pb1', 'b', 'macro|[email protected]', '2019-10-16 00:00:00', '2019-10-16 00:00:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel")
(SELECT 'sp-projectb1', 'PUBLIC', 'view');
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'pb1', 'sp-projectb1');

-- Sub projects of p1
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."Project" ("id", "name", "userId", "parentId", "createdAt", "updatedAt")
(SELECT 'p3', 'a2', '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-project3', NULL, NULL);
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p3', 'sp-project3');

INSERT INTO public."Project" ("id", "name", "userId", "parentId", "createdAt", "updatedAt")
(SELECT 'p4', 'a3', '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-project4', NULL, NULL);
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p4', 'sp-project4');

INSERT INTO public."Project" ("id", "name", "userId", "parentId", "createdAt", "updatedAt")
(SELECT 'p5', 'a4', '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-project5', NULL, NULL);
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p5', 'sp-project5');


-- Sub projects of p2
INSERT INTO public."Project" ("id", "name", "userId", "parentId", "createdAt", "updatedAt")
(SELECT 'p6', 'b1', 'macro|[email protected]', 'p2', '2019-10-16 00:00:00', '2019-10-16 01:00:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel")
(SELECT 'sp-project6', NULL, NULL);
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p6', 'sp-project6');

INSERT INTO public."Project" ("id", "name", "userId", "parentId", "createdAt", "updatedAt")
(SELECT 'p7', 'b2', 'macro|[email protected]', 'p2', '2019-10-16 00:00:00', '2019-10-16 01:00:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel")
(SELECT 'sp-project7', NULL, NULL);
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p7', 'sp-project7');

-- Sub projects of project-six
INSERT INTO public."Project" ("id", "name", "userId", "parentId", "createdAt", "updatedAt")
(SELECT 'p8', 'c1', 'macro|[email protected]', 'p6', '2019-10-16 00:00:00', '2019-10-16 01:00:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel")
(SELECT 'sp-project8', NULL, NULL);
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p8', 'sp-project8');

-- Project 9 is a project user does not have access to
INSERT INTO public."Project" ("id", "name", "userId", "parentId", "createdAt", "updatedAt")
(SELECT 'p9', 'd1', 'macro|[email protected]', 'p8', '2019-10-16 00:00:00', '2019-10-16 01:00:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel")
(SELECT 'sp-project9', NULL, NULL);
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p9', 'sp-project9');

INSERT INTO public."Project" ("id", "name", "userId", "parentId", "createdAt", "updatedAt")
(SELECT 'p10', 'e1', 'macro|[email protected]', 'p9', '2019-10-16 00:00:00', '2019-10-16 01:00:00');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel")
(SELECT 'sp-project10', NULL, NULL);
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p10', 'sp-project10');


INSERT INTO public."Project" ("id", "name", "userId", "parentId")
(SELECT 'p11', 'f1', 'macro|[email protected]', 'p2');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel", "createdAt", "updatedAt")
(SELECT 'sp-project11', 'PUBLIC', 'view', '2019-10-16 00:00:00', '2019-10-16 01:00:00');
INSERT INTO public."ProjectPermission" ("projectId", "sharePermissionId")
(SELECT 'p11', 'sp-project11');