import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterDepartmentDatabase1742970658040 implements MigrationInterface {
  name = "AlterDepartmentDatabase1742970658040"

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

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