import { MigrationInterface, QueryRunner } from "typeorm";

export class ModifyReportAndBlog1744542899914 implements MigrationInterface {
    name = 'ModifyReportAndBlog1744542899914'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE \`reports\` ADD \`user_id\` int NULL`);
        await queryRunner.query(`ALTER TABLE \`blog_translations\` DROP COLUMN \`title\``);
        await queryRunner.query(`ALTER TABLE \`blog_translations\` ADD \`title\` text CHARACTER SET "utf8mb4" COLLATE "utf8mb4_general_ci" NOT NULL`);
        await queryRunner.query(`ALTER TABLE \`blog_translations\` DROP COLUMN \`content\``);
        await queryRunner.query(`ALTER TABLE \`blog_translations\` ADD \`content\` longtext CHARACTER SET "utf8mb4" COLLATE "utf8mb4_general_ci" NOT NULL`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE \`blog_translations\` DROP COLUMN \`content\``);
        await queryRunner.query(`ALTER TABLE \`blog_translations\` ADD \`content\` text COLLATE "latin1_general_ci" NOT NULL`);
        await queryRunner.query(`ALTER TABLE \`blog_translations\` DROP COLUMN \`title\``);
        await queryRunner.query(`ALTER TABLE \`blog_translations\` ADD \`title\` varchar(255) COLLATE "latin1_general_ci" NOT NULL`);
        await queryRunner.query(`ALTER TABLE \`reports\` DROP COLUMN \`user_id\``);
    }

}