migrations 1626137272998-Heroes.ts

0% Statements 0/27

0% Branches 0/1

0% Functions 0/1

0% Lines 0/27

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  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  import { MigrationInterface, QueryRunner } from "typeorm";

export class Heroes1626137272998 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        // eslint-disable-next-line no-secrets/no-secrets
        await queryRunner.query(`
            CREATE TABLE heroes (
                id int(11) NOT NULL,
                name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                alterEgo varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                aspects set('Aggression','Justice','Protection','Leadership') COLLATE utf8mb4_unicode_ci NOT NULL,
                packId varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
                PRIMARY KEY(id)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        `);

        await queryRunner.query(`
            ALTER TABLE heroes ADD CONSTRAINT fk_packs_heroes FOREIGN KEY (packId) REFERENCES packs(code) ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
    }

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