16 lines
682 B
TypeScript
16 lines
682 B
TypeScript
import { MigrationInterface, QueryRunner } from "typeorm";
|
|
|
|
export class AddTitleToPermission1784465631499 implements MigrationInterface {
|
|
name = "AddTitleToPermission1784465631499";
|
|
|
|
public async up(queryRunner: QueryRunner): Promise<void> {
|
|
await queryRunner.query(`ALTER TABLE "permission" ADD "title" character varying(150)`);
|
|
await queryRunner.query(`UPDATE "permission" SET "title" = "name"::text WHERE "title" IS NULL`);
|
|
await queryRunner.query(`ALTER TABLE "permission" ALTER COLUMN "title" SET NOT NULL`);
|
|
}
|
|
|
|
public async down(queryRunner: QueryRunner): Promise<void> {
|
|
await queryRunner.query(`ALTER TABLE "permission" DROP COLUMN "title"`);
|
|
}
|
|
}
|