import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterCityStateCountryTable1743677655932 implements MigrationInterface {
  name = "AlterCityStateCountryTable1743677655932"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "currencies" DROP CONSTRAINT "UQ_46b8e68b649433979094a8c50e1"`,
    )
    await queryRunner.query(
      `ALTER TABLE "countries" DROP CONSTRAINT "UQ_fa1376321185575cf2226b1491d"`,
    )
    await queryRunner.query(
      `ALTER TABLE "cities" DROP CONSTRAINT "UQ_a0ae8d83b7d32359578c486e7f6"`,
    )
    await queryRunner.query(
      `ALTER TABLE "states" DROP CONSTRAINT "UQ_fe52f02449eaf27be2b2cb7acda"`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "states" ADD CONSTRAINT "UQ_fe52f02449eaf27be2b2cb7acda" UNIQUE ("name")`,
    )
    await queryRunner.query(
      `ALTER TABLE "cities" ADD CONSTRAINT "UQ_a0ae8d83b7d32359578c486e7f6" UNIQUE ("name")`,
    )
    await queryRunner.query(
      `ALTER TABLE "countries" ADD CONSTRAINT "UQ_fa1376321185575cf2226b1491d" UNIQUE ("name")`,
    )
    await queryRunner.query(
      `ALTER TABLE "currencies" ADD CONSTRAINT "UQ_46b8e68b649433979094a8c50e1" UNIQUE ("currency_code")`,
    )
  }
}