import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterCityTableToAddIndexing1764930600072 implements MigrationInterface {
  name = "AlterCityTableToAddIndexing1764930600072"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE INDEX "IDX_4762ffb6e5d198cfec5606bc11" ON "cities" ("id") `,
    )
    await queryRunner.query(
      `CREATE INDEX "IDX_a0ae8d83b7d32359578c486e7f" ON "cities" ("name") `,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `DROP INDEX "public"."IDX_a0ae8d83b7d32359578c486e7f"`,
    )
    await queryRunner.query(
      `DROP INDEX "public"."IDX_4762ffb6e5d198cfec5606bc11"`,
    )
  }
}