import { Migration } from '@mikro-orm/migrations';

export class Migration20260716120000_addReviewsParentId extends Migration {

  override async up(): Promise<void> {
    this.addSql(`alter table "reviews" add column "parent_id" char(26) null;`);
    this.addSql(`alter table "reviews" add constraint "reviews_parent_id_foreign" foreign key ("parent_id") references "reviews" ("id") on update cascade on delete set null;`);
    this.addSql(`create index "reviews_parent_id_index" on "reviews" ("parent_id");`);
  }

  override async down(): Promise<void> {
    this.addSql(`alter table "reviews" drop constraint "reviews_parent_id_foreign";`);
    this.addSql(`drop index "reviews_parent_id_index";`);
    this.addSql(`alter table "reviews" drop column "parent_id";`);
  }

}