From ab077b2de189b81d3b6569614b62bfa50aeef9ec Mon Sep 17 00:00:00 2001 From: Rory& Date: Fri, 3 Jul 2026 15:34:07 +0200 Subject: Fix instance ban index names --- .../migration/postgres/1782925307189-NameIndexes.ts | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 src/database/migration/postgres/1782925307189-NameIndexes.ts (limited to 'src/database/migration/postgres') diff --git a/src/database/migration/postgres/1782925307189-NameIndexes.ts b/src/database/migration/postgres/1782925307189-NameIndexes.ts new file mode 100644 index 000000000..c6f568546 --- /dev/null +++ b/src/database/migration/postgres/1782925307189-NameIndexes.ts @@ -0,0 +1,17 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class NameIndexes1782925307189 implements MigrationInterface { + name = "NameIndexes1782925307189"; + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query(`ALTER INDEX "instance_bans_fingerprint_idx" RENAME TO "IDX_instance_ban_fingerprint"`); + await queryRunner.query(`ALTER INDEX "instance_bans_ip_address_idx" RENAME TO "IDX_instance_ban_ip_address"`); + await queryRunner.query(`ALTER INDEX "instance_bans_user_id_idx" RENAME TO "IDX_instance_ban_user_id"`); + } + + public async down(queryRunner: QueryRunner): Promise { + await queryRunner.query(`ALTER INDEX "IDX_instance_ban_fingerprint" RENAME TO "instance_bans_fingerprint_idx"`); + await queryRunner.query(`ALTER INDEX "IDX_instance_ban_ip_address" RENAME TO "instance_bans_ip_address_idx"`); + await queryRunner.query(`ALTER INDEX "IDX_instance_ban_user_id" RENAME TO "instance_bans_user_id_idx"`); + } +} -- cgit 1.5.1