import { MigrationInterface, QueryRunner } from "typeorm"

export class AddFieldsToEmployeeSalaryDetails1762341373303 implements MigrationInterface {
  name = "AddFieldsToEmployeeSalaryDetails1762341373303"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "employee_salary_details" ADD "individual_value" character varying(255) NOT NULL`,
    )
    await queryRunner.query(
      `ALTER TABLE "employee_salary_details" ADD "calculated_amount" numeric(10,2)`,
    )
    await queryRunner.query(
      `ALTER TABLE "employee_salary_details" ALTER COLUMN "gross_salary" DROP NOT NULL`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "employee_salary_details" ALTER COLUMN "gross_salary" SET NOT NULL`,
    )
    await queryRunner.query(
      `ALTER TABLE "employee_salary_details" DROP COLUMN "calculated_amount"`,
    )
    await queryRunner.query(
      `ALTER TABLE "employee_salary_details" DROP COLUMN "individual_value"`,
    )
  }
}