import { MigrationInterface, QueryRunner } from "typeorm"

export class RemoveIsActiveFromMenuTables1728328000000 implements MigrationInterface {

    public async up(queryRunner: QueryRunner): Promise<void> {
        // Remove isActive column from Disclaimer table
        await queryRunner.query(`ALTER TABLE \`Disclaimer\` DROP COLUMN \`isActive\``);

        // Remove isActive column from HowItWorksSteps table
        await queryRunner.query(`ALTER TABLE \`HowItWorksSteps\` DROP COLUMN \`isActive\``);

        // Remove isActive column from Testimonials table
        await queryRunner.query(`ALTER TABLE \`Testimonials\` DROP COLUMN \`isActive\``);

        // Remove isActive column from EducationCourses table
        await queryRunner.query(`ALTER TABLE \`EducationCourses\` DROP COLUMN \`isActive\``);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        // Add back isActive column to Disclaimer table
        await queryRunner.query(`ALTER TABLE \`Disclaimer\` ADD \`isActive\` tinyint NOT NULL DEFAULT 1`);

        // Add back isActive column to HowItWorksSteps table
        await queryRunner.query(`ALTER TABLE \`HowItWorksSteps\` ADD \`isActive\` tinyint NOT NULL DEFAULT 1`);

        // Add back isActive column to Testimonials table
        await queryRunner.query(`ALTER TABLE \`Testimonials\` ADD \`isActive\` tinyint NOT NULL DEFAULT 1`);

        // Add back isActive column to EducationCourses table
        await queryRunner.query(`ALTER TABLE \`EducationCourses\` ADD \`isActive\` tinyint NOT NULL DEFAULT 1`);
    }
}