migrations 1636155892050-AddDecks.ts

0% Statements 0/30

0% Branches 0/1

0% Functions 0/1

0% Lines 0/30

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
22
23
24
25
26
27
28
29
30
31  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  import { MigrationInterface, QueryRunner } from "typeorm";

export class AddDecks1636155892050 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 decks (
                id int(11) NOT NULL,
                name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                description varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                aspects set('Aggression','Justice','Protection','Leadership') COLLATE utf8mb4_unicode_ci NOT NULL,
                PRIMARY KEY(id)
            ) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
        `);

        // eslint-disable-next-line no-secrets/no-secrets
        await queryRunner.query(`
            CREATE TABLE IF NOT EXISTS decks_heroes (
                deck int(11) NOT NULL,
                hero int(11) NOT NULL,
                PRIMARY KEY(deck, hero)
            ) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
        `);
    }

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