D7098.diff
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

D7098.diff
View Options

	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 (