Passed
Pull Request — master (#212)
by
unknown
01:33
created

down   A

Complexity

Conditions 1

Size

Total Lines 4
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 4
dl 0
loc 4
rs 10
c 0
b 0
f 0
1
import {MigrationInterface, QueryRunner} from "typeorm";
2
3
export class makeMealTicketRemovalCommentNullable1633787043133 implements MigrationInterface {
4
    name = 'makeMealTicketRemovalCommentNullable1633787043133'
5
6
    public async up(queryRunner: QueryRunner): Promise<void> {
7
        await queryRunner.query(`ALTER TABLE "meal_ticket_removal" DROP CONSTRAINT "UQ_484832a1c2f5aa18b60e8ca5a93"`);
8
        await queryRunner.query(`ALTER TABLE "meal_ticket_removal" ALTER COLUMN "comment" DROP NOT NULL`);
9
    }
10
11
    public async down(queryRunner: QueryRunner): Promise<void> {
12
        await queryRunner.query(`ALTER TABLE "meal_ticket_removal" ALTER COLUMN "comment" SET NOT NULL`);
13
        await queryRunner.query(`ALTER TABLE "meal_ticket_removal" ADD CONSTRAINT "UQ_484832a1c2f5aa18b60e8ca5a93" UNIQUE ("date", "userId")`);
14
    }
15
16
}
17