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 @@ -205,6 +205,17 @@ ], [18, updateRolesAndPermissionsForAllThreads], [19, updateRolesAndPermissionsForAllThreads], + [ + 20, + async () => { + await dbQuery(SQL` + ALTER TABLE threads + ADD COLUMN IF NOT EXISTS avatar varchar(191) + COLLATE utf8mb4_bin + DEFAULT NULL; + `); + }, + ], ]); 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 @@ -154,7 +154,8 @@ creation_time bigint(20) NOT NULL, color char(6) COLLATE utf8mb4_bin NOT NULL, source_message bigint(20) DEFAULT NULL UNIQUE, - replies_count int UNSIGNED NOT NULL DEFAULT 0 + replies_count int UNSIGNED NOT NULL DEFAULT 0, + avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; CREATE TABLE updates (