fix: migrate older pinned messages to the new system

1 files changed, 3 insertions, 0 deletions

diff --git a/src/util/migration/postgres/1752383879533-message_pinned_at.ts b/src/util/migration/postgres/1752383879533-message_pinned_at.ts

index 62096b1a1..9736f55a6 100644
--- a/src/util/migration/postgres/1752383879533-message_pinned_at.ts
+++ b/src/util/migration/postgres/1752383879533-message_pinned_at.ts
@@ -7,6 +7,9 @@ export class MessagePinnedAt1752383879533 implements MigrationInterface {
 		await queryRunner.query(
 			`ALTER TABLE "messages" ADD "pinned_at" TIMESTAMP`,
 		);
+		await queryRunner.query(
+			`UPDATE "messages" SET "pinned_at" = NOW() WHERE "pinned" = true`,
+		);
 		await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "pinned"`);
 	}