All files / projects-dev/apps/mc-api/src/migrations 1626077951561-Pack.ts

0% Statements 0/20
0% Branches 0/1
0% Functions 0/1
0% Lines 0/20

Press n or j to go to the next uncovered block, b, p or k for the previous block.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21                                         
import { MigrationInterface, QueryRunner } from "typeorm";

export class Pack1626077951561 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        // eslint-disable-next-line no-secrets/no-secrets
        await queryRunner.query(`
            CREATE TABLE IF NOT EXISTS packs(
                code varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
                name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                PRIMARY KEY(code)
            ) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
        `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            DROP TABLE packs
        `);
    }
}