pguerrerox
f5e7e966e3
- add migrations for owner/member workspace roles and application admins - centralize /admin access checks with DB-backed admin resolution - audit admin analytics/billing route access - update account/admin UI typing and env/docs for ADMIN_EMAILS fallback behavior
11 lines
307 B
SQL
11 lines
307 B
SQL
update public.workspace_memberships
|
|
set role = 'member'
|
|
where role = 'admin';
|
|
|
|
alter table public.workspace_memberships
|
|
drop constraint if exists workspace_memberships_role_check;
|
|
|
|
alter table public.workspace_memberships
|
|
add constraint workspace_memberships_role_check
|
|
check (role in ('owner', 'member'));
|