import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1751889533140 implements MigrationInterface {
    name = 'Migrations1751889533140'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "plans" DROP CONSTRAINT "FK_d753c9d91b66b123f7178be4a6b"`);
        await queryRunner.query(`ALTER TABLE "plans" DROP CONSTRAINT "UQ_d753c9d91b66b123f7178be4a6b"`);
        await queryRunner.query(`ALTER TABLE "plans" ADD CONSTRAINT "FK_d753c9d91b66b123f7178be4a6b" FOREIGN KEY ("parent_plan_id") REFERENCES "plans"("id") ON DELETE SET NULL ON UPDATE NO ACTION`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "plans" DROP CONSTRAINT "FK_d753c9d91b66b123f7178be4a6b"`);
        await queryRunner.query(`ALTER TABLE "plans" ADD CONSTRAINT "UQ_d753c9d91b66b123f7178be4a6b" UNIQUE ("parent_plan_id")`);
        await queryRunner.query(`ALTER TABLE "plans" ADD CONSTRAINT "FK_d753c9d91b66b123f7178be4a6b" FOREIGN KEY ("parent_plan_id") REFERENCES "plans"("id") ON DELETE SET NULL ON UPDATE NO ACTION`);
    }

}