import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterStatusToPayrollCyclesVarchar1765453787533 implements MigrationInterface {
  name = "AlterStatusToPayrollCyclesVarchar1765453787533"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`ALTER TABLE "payroll_cycles" DROP COLUMN "status"`)
    await queryRunner.query(
      `ALTER TABLE "payroll_cycles" ADD "status" character varying NOT NULL DEFAULT '0'`,
    )
    await queryRunner.query(
      `COMMENT ON COLUMN "payroll_cycles"."status" IS '0=Draft, 1=Finalized, 2=Paid'`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `COMMENT ON COLUMN "payroll_cycles"."status" IS '0=Draft, 1=Finalized, 2=Paid'`,
    )
    await queryRunner.query(`ALTER TABLE "payroll_cycles" DROP COLUMN "status"`)
    await queryRunner.query(
      `ALTER TABLE "payroll_cycles" ADD "status" smallint NOT NULL DEFAULT '0'`,
    )
  }
}