import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1741263090315 implements MigrationInterface {
    name = 'Migrations1741263090315'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "users" ADD "currency" character varying`);
        await queryRunner.query(`CREATE INDEX "IDX_706e2793a6ddb78e8f2600646f" ON "campaigns" ("platforms") `);
        await queryRunner.query(`CREATE INDEX "IDX_a0d3060d1a3a5a74ae34c8155b" ON "campaigns" ("campaign_country") `);
        await queryRunner.query(`CREATE INDEX "IDX_f3d1d6b6523dc2c93bc2304803" ON "users" ("currency") `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`DROP INDEX "public"."IDX_f3d1d6b6523dc2c93bc2304803"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_a0d3060d1a3a5a74ae34c8155b"`);
        await queryRunner.query(`DROP INDEX "public"."IDX_706e2793a6ddb78e8f2600646f"`);
        await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "currency"`);
    }

}