Files
team/server/channels/db/migrations/postgres/000157_backfill_roles_schemeid.down.sql
David KrauserandGitHub 89852b2a57 [MM-67741] Scope role_updated WS events to affected team/channel (#35497)
With this change, we now scope role_updated websocket events to users that need to receive them. Built-in and unowned role broadcast globally, team-scheme roles emit one event per team using the role, channel-scheme roles emit one event per channel using the role.

To efficiently find a role's owning scheme, a schemeid column is added to the roles table. The ID is set when the scheme creates its related roles.
2026-03-16 14:36:55 -04:00

2 lines
34 B
SQL

UPDATE roles SET schemeid = NULL;