migrations 1626135664098-ModularSets.ts

0% Statements 0/25

0% Branches 0/1

0% Functions 0/1

0% Lines 0/25

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

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

        await queryRunner.query(`
            ALTER TABLE modular_sets ADD CONSTRAINT fk_packs_modular_sets FOREIGN KEY (pack) REFERENCES packs(code) ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
    }

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