import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1780493688747 implements MigrationInterface {
    name = 'Migrations1780493688747'

    public async up(queryRunner: QueryRunner): Promise<void> {

        await queryRunner.query(`ALTER TABLE "category_translations" ADD "display_title" character varying NOT NULL DEFAULT ''`);
        await queryRunner.query(`CREATE INDEX "IDX_dbc28ccf6ed3e6f9455c38f3b0" ON "category_translations" ("display_title") `);
        // UPDATE category_translations SET display_title = title WHERE display_title = '';
        await queryRunner.query(`UPDATE category_translations SET display_title = title WHERE display_title = ''`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`DROP INDEX "public"."IDX_dbc28ccf6ed3e6f9455c38f3b0"`);
        await queryRunner.query(`ALTER TABLE "category_translations" DROP COLUMN "display_title"`);
    }

}