Skip to content

⭐️⭐️⭐️ Open-source, self-hosted alternative to Linear and Plane. Project management and issue tracking where teams and AI agents work side by side to plan and ship products.

2.1 KB
Raw Blame
CREATE UNIQUE INDEX "team_role_system_default_uq" ON "team_role" USING btree ("is_default") WHERE "team_role"."team_id" IS NULL AND "team_role"."is_default";--> statement-breakpoint
-- The system role a project member gets by default. Its matrix is the one every team's default "Member" role starts with.
INSERT INTO "team_role" ("team_id", "name", "is_default", "permissions") VALUES (NULL, 'Member', true, '{"work_items":{"create":true,"edit":true,"read":true,"delete":true},"initiatives":{"create":true,"edit":true,"read":true,"delete":true},"cycles":{"create":true,"edit":true,"read":true,"delete":true},"dashboards":{"create":false,"edit":false,"read":true,"delete":false},"documents":{"create":true,"edit":true,"read":true,"delete":true},"views":{"create":false,"edit":false,"read":true,"delete":false},"members_invite":{"create":false,"edit":false,"read":true,"delete":false},"members_manage":{"create":false,"edit":false,"read":true,"delete":false},"states":{"create":false,"edit":false,"read":true,"delete":false},"issue_types":{"create":false,"edit":false,"read":true,"delete":false},"labels":{"create":false,"edit":false,"read":true,"delete":false},"ai_agents":{"create":false,"edit":false,"read":true,"delete":false},"integrations":{"create":false,"edit":false,"read":false,"delete":false},"agent_skills":{"create":false,"edit":false,"read":false,"delete":false},"agent_tools":{"create":false,"edit":false,"read":false,"delete":false},"agent_usage":{"create":false,"edit":false,"read":false,"delete":false},"custom_fields":{"create":false,"edit":false,"read":true,"delete":false},"issue_templates":{"create":false,"edit":false,"read":true,"delete":false},"workflow_config":{"create":false,"edit":false,"read":false,"delete":false},"actions":{"create":false,"edit":false,"read":false,"delete":false},"webhooks":{"create":false,"edit":false,"read":false,"delete":false},"repositories":{"create":false,"edit":false,"read":false,"delete":false},"note_boards":{"create":true,"edit":true,"read":true,"delete":true},"import_export":{"create":false,"edit":false,"read":false,"delete":false},"danger_zone":{"create":false,"edit":false,"read":false,"delete":false}}'::jsonb);