import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterInvoiceTableToAddTaxColumn1762428054602 implements MigrationInterface {
  name = "AlterInvoiceTableToAddTaxColumn1762428054602"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "invoices" RENAME COLUMN "invoice_tax_amount" TO "invoice_tax"`,
    )
    await queryRunner.query(`ALTER TABLE "invoices" DROP COLUMN "invoice_tax"`)
    await queryRunner.query(
      `ALTER TABLE "invoices" ADD "invoice_tax" integer NOT NULL DEFAULT '0'`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`ALTER TABLE "invoices" DROP COLUMN "invoice_tax"`)
    await queryRunner.query(
      `ALTER TABLE "invoices" ADD "invoice_tax" character varying NOT NULL DEFAULT '0'`,
    )
    await queryRunner.query(
      `ALTER TABLE "invoices" RENAME COLUMN "invoice_tax" TO "invoice_tax_amount"`,
    )
  }
}