import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1741604362434 implements MigrationInterface {
    name = 'Migrations1741604362434'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "subscription-history" ADD "invoice_receipt" text`);
        await queryRunner.query(`COMMENT ON COLUMN "subscription-history"."invoice_receipt" IS 'INVOICE PATH'`);
        await queryRunner.query(`ALTER TABLE "subscription-history" ADD "exchange_rate" numeric(10,2) NOT NULL DEFAULT '0'`);
        await queryRunner.query(`COMMENT ON COLUMN "subscription-history"."exchange_rate" IS 'STRIPE EXCHANGE RATE'`);
        await queryRunner.query(`ALTER TABLE "subscription-history" ADD "transaction_fee_usd" numeric(10,2) NOT NULL DEFAULT '0'`);
        await queryRunner.query(`COMMENT ON COLUMN "subscription-history"."transaction_fee_usd" IS 'STRIPE TRANSACTION FEE'`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`COMMENT ON COLUMN "subscription-history"."transaction_fee_usd" IS 'STRIPE TRANSACTION FEE'`);
        await queryRunner.query(`ALTER TABLE "subscription-history" DROP COLUMN "transaction_fee_usd"`);
        await queryRunner.query(`COMMENT ON COLUMN "subscription-history"."exchange_rate" IS 'STRIPE EXCHANGE RATE'`);
        await queryRunner.query(`ALTER TABLE "subscription-history" DROP COLUMN "exchange_rate"`);
        await queryRunner.query(`COMMENT ON COLUMN "subscription-history"."invoice_receipt" IS 'INVOICE PATH'`);
        await queryRunner.query(`ALTER TABLE "subscription-history" DROP COLUMN "invoice_receipt"`);
    }

}