import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1736418560636 implements MigrationInterface {
    name = 'Migrations1736418560636'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "campaigns" DROP COLUMN "content_type"`);
        await queryRunner.query(`ALTER TABLE "campaigns" ADD "content_type" jsonb`);
        await queryRunner.query(`ALTER TABLE "campaigns" DROP COLUMN "job_requirement"`);
        await queryRunner.query(`ALTER TABLE "campaigns" ADD "job_requirement" jsonb`);
        await queryRunner.query(`ALTER TABLE "campaigns" DROP COLUMN "attachment"`);
        await queryRunner.query(`ALTER TABLE "campaigns" ADD "attachment" jsonb`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "campaigns" DROP COLUMN "attachment"`);
        await queryRunner.query(`ALTER TABLE "campaigns" ADD "attachment" character varying(255)`);
        await queryRunner.query(`ALTER TABLE "campaigns" DROP COLUMN "job_requirement"`);
        await queryRunner.query(`ALTER TABLE "campaigns" ADD "job_requirement" character varying(255) NOT NULL`);
        await queryRunner.query(`ALTER TABLE "campaigns" DROP COLUMN "content_type"`);
        await queryRunner.query(`ALTER TABLE "campaigns" ADD "content_type" character varying(255) NOT NULL`);
    }

}