From 96648b651eaab8b37dc809ec48acb09bce834ea1 Mon Sep 17 00:00:00 2001 From: syuilo Date: Thu, 30 Jan 2020 05:56:14 +0900 Subject: isMarkedAsClosed --> isSuspended --- migration/1580331224276-v12-11.ts | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 migration/1580331224276-v12-11.ts (limited to 'migration') diff --git a/migration/1580331224276-v12-11.ts b/migration/1580331224276-v12-11.ts new file mode 100644 index 0000000000..30794b80e3 --- /dev/null +++ b/migration/1580331224276-v12-11.ts @@ -0,0 +1,18 @@ +import {MigrationInterface, QueryRunner} from "typeorm"; + +export class v12111580331224276 implements MigrationInterface { + name = 'v12111580331224276' + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query(`ALTER TABLE "instance" DROP COLUMN "isMarkedAsClosed"`, undefined); + await queryRunner.query(`ALTER TABLE "instance" ADD "isSuspended" boolean NOT NULL DEFAULT false`, undefined); + await queryRunner.query(`CREATE INDEX "IDX_34500da2e38ac393f7bb6b299c" ON "instance" ("isSuspended") `, undefined); + } + + public async down(queryRunner: QueryRunner): Promise { + await queryRunner.query(`DROP INDEX "IDX_34500da2e38ac393f7bb6b299c"`, undefined); + await queryRunner.query(`ALTER TABLE "instance" DROP COLUMN "isSuspended"`, undefined); + await queryRunner.query(`ALTER TABLE "instance" ADD "isMarkedAsClosed" boolean NOT NULL DEFAULT false`, undefined); + } + +} -- cgit v1.2.3-freya