import { MigrationInterface, QueryRunner } from "typeorm"

export class AddFieldsToSalarySettingsHistoryTable1767353981231 implements MigrationInterface {
  name = "AddFieldsToSalarySettingsHistoryTable1767353981231"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "employees" ADD "tds_amount" numeric(10,2)`,
    )
    await queryRunner.query(
      `ALTER TABLE "employees" ADD "regime_type" character varying(50) NOT NULL DEFAULT 'new'`,
    )
    await queryRunner.query(
      `ALTER TABLE "employee_salary_history" ADD "tds_amount" numeric(10,2)`,
    )
    await queryRunner.query(
      `ALTER TABLE "employee_salary_history" ADD "regime_type" character varying(50) NOT NULL DEFAULT 'new'`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "employee_salary_history" DROP COLUMN "regime_type"`,
    )
    await queryRunner.query(
      `ALTER TABLE "employee_salary_history" DROP COLUMN "tds_amount"`,
    )
    await queryRunner.query(`ALTER TABLE "employees" DROP COLUMN "regime_type"`)
    await queryRunner.query(`ALTER TABLE "employees" DROP COLUMN "tds_amount"`)
  }
}