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 @@ -325,6 +325,16 @@ await dbQuery(SQL`DROP TABLE versions;`); }, ], + [ + 31, + async () => { + await dbQuery(SQL` + UPDATE messages + SET target_message = JSON_VALUE(content, "$.sourceMessageID") + WHERE type = 17; + `); + }, + ], ]); const newDatabaseVersion: number = Math.max(...migrations.keys());