import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterTripManagementTable1754050129514 implements MigrationInterface {
  name = "AlterTripManagementTable1754050129514"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "trips" DROP CONSTRAINT "FK_eb6e01850ca892acbfacc346ccb"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" DROP COLUMN "dropup_hospital_id"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" DROP COLUMN "drop_up_location"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" DROP COLUMN "dropup_location_type"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" DROP COLUMN "dropup_custom_address"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "drop_off_location" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "dropoff_location_type" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "dropoff_hospital_id" integer`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "dropoff_custom_address" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD CONSTRAINT "FK_43ed969635f66752a2311b5d8ce" FOREIGN KEY ("dropoff_hospital_id") REFERENCES "hospitals"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "trips" DROP CONSTRAINT "FK_43ed969635f66752a2311b5d8ce"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" DROP COLUMN "dropoff_custom_address"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" DROP COLUMN "dropoff_hospital_id"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" DROP COLUMN "dropoff_location_type"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" DROP COLUMN "drop_off_location"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "dropup_custom_address" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "dropup_location_type" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "drop_up_location" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "dropup_hospital_id" integer`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD CONSTRAINT "FK_eb6e01850ca892acbfacc346ccb" FOREIGN KEY ("dropup_hospital_id") REFERENCES "hospitals"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`,
    )
  }
}