Page MenuHomePhabricator
Files F3518277

D8732.id29589.diff
No OneTemporary
Actions

D8732.id29589.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,21 @@
`);
},
],
+ [
+ 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());

File Metadata

Mime Type
text/plain
Expires
Mon, Dec 23, 7:23 PM (19 h, 12 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2694939
Default Alt Text
D8732.id29589.diff (621 B)

Event Timeline