import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterCustomerTableToAddPricingCityColumn1773387112664 implements MigrationInterface {
  name = "AlterCustomerTableToAddPricingCityColumn1773387112664"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "customers" ADD "pricing_city_id" integer`,
    )

    await queryRunner.query(
      `ALTER TABLE "customers" ADD CONSTRAINT "FK_99e7d715acaca5d9359015f36f2" FOREIGN KEY ("pricing_city_id") REFERENCES "cities"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "customers" DROP CONSTRAINT "FK_99e7d715acaca5d9359015f36f2"`,
    )
    await queryRunner.query(
      `ALTER TABLE "customers" DROP COLUMN "pricing_city_id"`,
    )
  }
}