1 files changed, 23 insertions, 0 deletions
diff --git a/src/util/migration/postgres/1713116476900-messageFlagsNotNull.ts b/src/util/migration/postgres/1713116476900-messageFlagsNotNull.ts
new file mode 100644
index 00000000..026b069b
--- /dev/null
+++ b/src/util/migration/postgres/1713116476900-messageFlagsNotNull.ts
@@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner } from "typeorm";
+
+export class MessageFlagsNotNull1713116476900 implements MigrationInterface {
+ name = "MessageFlagsNotNull1713116476900";
+
+ public async up(queryRunner: QueryRunner): Promise<void> {
+ await queryRunner.query(
+ "ALTER TABLE messages RENAME COLUMN flags TO flags_old;",
+ );
+ await queryRunner.query(
+ "ALTER TABLE messages ADD COLUMN flags integer NOT NULL DEFAULT 0;",
+ );
+ await queryRunner.query(
+ "UPDATE messages SET flags = COALESCE(flags_old, 0);",
+ );
+ await queryRunner.query("ALTER TABLE messages DROP COLUMN flags_old;");
+ }
+
+ public async down(): Promise<void> {
+ // dont care
+ throw new Error("Migration down is not implemented.");
+ }
+}
|
