D8732.1768769427.diff
No OneTemporary
Actions

Size

570 B

Referenced Files

None

Subscribers

None

D8732.1768769427.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
	@@ -499,6 +499,19 @@
	`);
	},
	],
	+ [
	+ 43,
	+ () =>
	+ dbQuery(SQL`
	+ UPDATE threads
	+ SET pinned_count = (
	+ SELECT COUNT(*)
	+ FROM messages
	+ WHERE messages.thread = threads.id
	+ AND messages.pinned = 1
	+ )
	+ `),
	+ ],
	]);
	const newDatabaseVersion: number = Math.max(...migrations.keys());