import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterTripAssignmentEntity1753357603504 implements MigrationInterface {
  name = "AlterTripAssignmentEntity1753357603504"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "trip_fleet_assignments" DROP CONSTRAINT "FK_4ec11638ab137efd67788343ed6"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trip_fleet_assignments" ALTER COLUMN "trip_id" DROP NOT NULL`,
    )
    await queryRunner.query(
      `ALTER TABLE "trip_fleet_assignments" ADD CONSTRAINT "FK_4ec11638ab137efd67788343ed6" FOREIGN KEY ("trip_id") REFERENCES "trips"("id") ON DELETE CASCADE ON UPDATE NO ACTION`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "trip_fleet_assignments" DROP CONSTRAINT "FK_4ec11638ab137efd67788343ed6"`,
    )
    await queryRunner.query(
      `ALTER TABLE "trip_fleet_assignments" ALTER COLUMN "trip_id" SET NOT NULL`,
    )
    await queryRunner.query(
      `ALTER TABLE "trip_fleet_assignments" ADD CONSTRAINT "FK_4ec11638ab137efd67788343ed6" FOREIGN KEY ("trip_id") REFERENCES "trips"("id") ON DELETE CASCADE ON UPDATE NO ACTION`,
    )
  }
}