import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1729582954111 implements MigrationInterface {
    name = 'Migrations1729582954111'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "brand_industries" RENAME COLUMN "title" TO "category"`);
        await queryRunner.query(`ALTER TABLE "brand_industries" DROP COLUMN "category"`);
        await queryRunner.query(`ALTER TABLE "brand_industries" ADD "category" uuid`);
        await queryRunner.query(`ALTER TABLE "brand_industries" ADD CONSTRAINT "FK_d7e7b7fd3157bda50394e6d66f5" FOREIGN KEY ("category") REFERENCES "categories"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "brand_industries" DROP CONSTRAINT "FK_d7e7b7fd3157bda50394e6d66f5"`);
        await queryRunner.query(`ALTER TABLE "brand_industries" DROP COLUMN "category"`);
        await queryRunner.query(`ALTER TABLE "brand_industries" ADD "category" character varying NOT NULL DEFAULT ''`);
        await queryRunner.query(`ALTER TABLE "brand_industries" RENAME COLUMN "category" TO "title"`);
    }

}