diff --git a/keyserver/src/database/migration-config.js b/keyserver/src/database/migration-config.js --- a/keyserver/src/database/migration-config.js +++ b/keyserver/src/database/migration-config.js @@ -583,6 +583,17 @@ () => dbQuery(SQL`ALTER TABLE cookies MODIFY COLUMN hash char(64) NOT NULL`), ], + [ + 48, + async () => { + await dbQuery(SQL` + UPDATE roles + SET permissions = JSON_REMOVE(permissions, '$.descendant_open_voiced') + WHERE JSON_EXTRACT(permissions, '$.descendant_open_voiced') = 'true'; + `); + }, + ], + [49, updateRolesAndPermissionsForAllThreads], ]); const newDatabaseVersion: number = Math.max(...migrations.keys());