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 @@ -664,6 +664,14 @@ }, ], [52, updateRolesAndPermissionsForAllThreads], + [ + 53, + async () => + dbQuery(SQL` + ALTER TABLE invite_links + ADD COLUMN blob_holder char(36) CHARSET latin1 + `), + ], ]); const newDatabaseVersion: number = Math.max(...migrations.keys()); diff --git a/keyserver/src/database/setup-db.js b/keyserver/src/database/setup-db.js --- a/keyserver/src/database/setup-db.js +++ b/keyserver/src/database/setup-db.js @@ -263,7 +263,8 @@ community bigint(20) NOT NULL, expiration_time bigint(20), limit_of_uses int UNSIGNED, - number_of_uses int UNSIGNED NOT NULL DEFAULT 0 + number_of_uses int UNSIGNED NOT NULL DEFAULT 0, + blob_holder char(36) CHARSET latin1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE olm_sessions (