calendar/packages/prisma/migrations/20250714075355_add_attributes_pbac_permissions/migration.sql

-- Add attribute permissions for admin role
INSERT INTO "RolePermission" (id, "roleId", resource, action, "createdAt")
SELECT
  gen_random_uuid(), 'admin_role', resource, action, NOW()
FROM (
  VALUES
    -- Attribute permissions
    ('organization.attributes', 'create'),
    ('organization.attributes', 'read'),
    ('organization.attributes', 'update'),
    ('organization.attributes', 'delete')
) AS permissions(resource, action);

-- Add read permission for member role
INSERT INTO "RolePermission" (id, "roleId", resource, action, "createdAt")
SELECT
  gen_random_uuid(), 'member_role', resource, action, NOW()
FROM (
  VALUES
    -- Attribute permissions - read only
    ('organization.attributes', 'read')
) AS permissions(resource, action);