Skip to content

Commit 7882580

Browse files
EmyrkEmyrk
committed
Only affect admins
1 parent 702e9ce commit 7882580

File tree

1 file changed

+6
-1
lines changed

1 file changed

+6
-1
lines changed

‎coderd/database/migrations/000086_no_org_admins.up.sql

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1 +1,6 @@
1-
UPDATE organization_members SET roles = ARRAY ['organization-member:'||organization_id];
1+
UPDATE
2+
organization_members
3+
SET
4+
roles = ARRAY [] :: text[]
5+
WHERE
6+
'organization-admin:'||organization_id = ANY(roles);

0 commit comments

Comments
 (0)