import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1741608228086 implements MigrationInterface {
    name = 'Migrations1741608228086'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "campaign_payment_history" ADD "exchange_rate" numeric(10,2) NOT NULL DEFAULT '0'`);
        await queryRunner.query(`COMMENT ON COLUMN "campaign_payment_history"."exchange_rate" IS 'STRIPE EXCHANGE RATE'`);
        await queryRunner.query(`ALTER TABLE "campaign_payment_history" ADD "transaction_fee_usd" numeric(10,2) NOT NULL DEFAULT '0'`);
        await queryRunner.query(`COMMENT ON COLUMN "campaign_payment_history"."transaction_fee_usd" IS 'STRIPE TRANSACTION FEE'`);
        await queryRunner.query(`ALTER TABLE "campaign_payment_history" ADD "final_amount_usd" numeric(10,2) NOT NULL DEFAULT '0'`);
        await queryRunner.query(`COMMENT ON COLUMN "campaign_payment_history"."final_amount_usd" IS 'FINAL AMOUNT IN USD'`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`COMMENT ON COLUMN "campaign_payment_history"."final_amount_usd" IS 'FINAL AMOUNT IN USD'`);
        await queryRunner.query(`ALTER TABLE "campaign_payment_history" DROP COLUMN "final_amount_usd"`);
        await queryRunner.query(`COMMENT ON COLUMN "campaign_payment_history"."transaction_fee_usd" IS 'STRIPE TRANSACTION FEE'`);
        await queryRunner.query(`ALTER TABLE "campaign_payment_history" DROP COLUMN "transaction_fee_usd"`);
        await queryRunner.query(`COMMENT ON COLUMN "campaign_payment_history"."exchange_rate" IS 'STRIPE EXCHANGE RATE'`);
        await queryRunner.query(`ALTER TABLE "campaign_payment_history" DROP COLUMN "exchange_rate"`);
    }

}