import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterDriverAvailabiltyHistoryEntity_1754049663361 implements MigrationInterface {
  name = "AlterDriverAvailabiltyHistoryEntity_1754049663361"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "driver_availability_history" DROP COLUMN "logged_at"`,
    )
    await queryRunner.query(
      `ALTER TABLE "driver_availability_history" DROP COLUMN "day_of_week"`,
    )
    await queryRunner.query(
      `ALTER TABLE "driver_availability_history" DROP COLUMN "availability_id"`,
    )
    await queryRunner.query(
      `ALTER TABLE "driver_availability_history" ADD "duty_status" character varying`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "driver_availability_history" DROP COLUMN "duty_status"`,
    )
    await queryRunner.query(
      `ALTER TABLE "driver_availability_history" ADD "availability_id" integer NOT NULL`,
    )
    await queryRunner.query(
      `ALTER TABLE "driver_availability_history" ADD "day_of_week" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "driver_availability_history" ADD "logged_at" TIMESTAMP NOT NULL DEFAULT now()`,
    )
  }
}