Files
dpage-api/database/migrations/Migration20260518092926_addCatalogueSlug.ts
2026-05-18 13:51:34 +03:30

12 lines
419 B
TypeScript

import { Migration } from '@mikro-orm/migrations';
export class Migration20260518092926_addCatalogueSlug extends Migration {
override async up(): Promise<void> {
this.addSql(`alter table "catalogue" add column "slug" varchar(255);`);
this.addSql(`update "catalogue" set "slug" = lower("id"::text) where "slug" is null;`);
this.addSql(`alter table "catalogue" alter column "slug" set not null;`);
}
}