import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1736748393721 implements MigrationInterface {
    name = 'Migrations1736748393721'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "campaign_influencers" ADD "message_id" character varying(255)`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" ADD "name" character varying(255)`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" ADD "influencer_budget" numeric(10,2) NOT NULL DEFAULT '0'`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" ADD "influencer_budget_usd" numeric(10,2) NOT NULL DEFAULT '0'`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" ADD "currencty" character varying(255)`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" ADD "message" text`);
        await queryRunner.query(`ALTER TABLE "campaigns" ADD "budget_per_influencer_usd" numeric(10,2) NOT NULL DEFAULT '0'`);
        await queryRunner.query(`ALTER TABLE "campaigns" ADD "total_budget_usd" numeric(10,2) NOT NULL DEFAULT '0'`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "campaigns" DROP COLUMN "total_budget_usd"`);
        await queryRunner.query(`ALTER TABLE "campaigns" DROP COLUMN "budget_per_influencer_usd"`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" DROP COLUMN "message"`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" DROP COLUMN "currencty"`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" DROP COLUMN "influencer_budget_usd"`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" DROP COLUMN "influencer_budget"`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" DROP COLUMN "name"`);
        await queryRunner.query(`ALTER TABLE "campaign_influencers" DROP COLUMN "message_id"`);
    }

}