18 lines
767 B
TypeScript
18 lines
767 B
TypeScript
import { Migration } from '@mikro-orm/migrations';
|
|
|
|
export class Migration20260717100000_addReviewsAdminId extends Migration {
|
|
|
|
override async up(): Promise<void> {
|
|
this.addSql(`alter table "reviews" add column "admin_id" char(26) null;`);
|
|
this.addSql(`alter table "reviews" add constraint "reviews_admin_id_foreign" foreign key ("admin_id") references "admins" ("id") on update cascade on delete set null;`);
|
|
this.addSql(`create index "reviews_admin_id_index" on "reviews" ("admin_id");`);
|
|
}
|
|
|
|
override async down(): Promise<void> {
|
|
this.addSql(`alter table "reviews" drop constraint "reviews_admin_id_foreign";`);
|
|
this.addSql(`drop index "reviews_admin_id_index";`);
|
|
this.addSql(`alter table "reviews" drop column "admin_id";`);
|
|
}
|
|
|
|
}
|