From 83e60464ad2675f09ddee02f6b166bef22f53f33 Mon Sep 17 00:00:00 2001 From: Rory& Date: Thu, 11 Jun 2026 23:18:02 +0200 Subject: Move migrations to database --- .../postgres/1723644478176-webhookSourceChannel.ts | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 src/database/migration/postgres/1723644478176-webhookSourceChannel.ts (limited to 'src/database/migration/postgres/1723644478176-webhookSourceChannel.ts') diff --git a/src/database/migration/postgres/1723644478176-webhookSourceChannel.ts b/src/database/migration/postgres/1723644478176-webhookSourceChannel.ts new file mode 100644 index 00000000..00fe413f --- /dev/null +++ b/src/database/migration/postgres/1723644478176-webhookSourceChannel.ts @@ -0,0 +1,17 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class WebhookSourceChannel1723644478176 implements MigrationInterface { + name = "WebhookSourceChannel1723644478176"; + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query("ALTER TABLE webhooks ADD COLUMN source_channel_id VARCHAR(255) NULL DEFAULT NULL"); + await queryRunner.query( + "ALTER TABLE webhooks ADD CONSTRAINT FK_d64f38834fa676f6caa4786ddd6 FOREIGN KEY (source_channel_id) REFERENCES channels (id) ON UPDATE NO ACTION ON DELETE CASCADE", + ); + } + + public async down(queryRunner: QueryRunner): Promise { + await queryRunner.query("ALTER TABLE webhooks DROP CONSTRAINT FK_d64f38834fa676f6caa4786ddd6"); + await queryRunner.query("ALTER TABLE webhooks DROP COLUMN source_channel_id"); + } +} -- cgit 1.5.1