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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 | import { MigrationInterface, QueryRunner } from "typeorm"; export class RemoveRatings1633676029867 implements MigrationInterface { public async up(queryRunner: QueryRunner): Promise<void> { await queryRunner.query(`ALTER TABLE modular_sets DROP rating`); await queryRunner.query(` ALTER TABLE scenarios DROP rating_standard_solo, DROP rating_standard_multi, DROP rating_expert_solo, DROP rating_expert_multi; `); } public async down(queryRunner: QueryRunner): Promise<void> { await queryRunner.query(` ALTER TABLE modular_sets ADD COLUMN rating INT(11) NULL DEFAULT 0; `); await queryRunner.query(`UPDATE modular_sets SET rating=-4 WHERE id=1`); await queryRunner.query(`UPDATE modular_sets SET rating=1 WHERE id=2`); await queryRunner.query(`UPDATE modular_sets SET rating=2 WHERE id=3`); await queryRunner.query(`UPDATE modular_sets SET rating=3 WHERE id=4`); await queryRunner.query(`UPDATE modular_sets SET rating=3 WHERE id=5`); await queryRunner.query(`UPDATE modular_sets SET rating=-6 WHERE id=6`); await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=7`); await queryRunner.query(`UPDATE modular_sets SET rating=-3 WHERE id=8`); await queryRunner.query(`UPDATE modular_sets SET rating=-1 WHERE id=9`); await queryRunner.query(`UPDATE modular_sets SET rating=-2 WHERE id=10`); await queryRunner.query(`UPDATE modular_sets SET rating=-1 WHERE id=11`); await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=12`); await queryRunner.query(`UPDATE modular_sets SET rating=-3 WHERE id=13`); await queryRunner.query(`UPDATE modular_sets SET rating=-3 WHERE id=14`); await queryRunner.query(`UPDATE modular_sets SET rating=4 WHERE id=15`); await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=16`); await queryRunner.query(`UPDATE modular_sets SET rating=-7 WHERE id=17`); await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=18`); await queryRunner.query(`UPDATE modular_sets SET rating=-3 WHERE id=19`); await queryRunner.query(`UPDATE modular_sets SET rating=+2 WHERE id=20`); await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=21`); await queryRunner.query(`UPDATE modular_sets SET rating=+8 WHERE id=22`); await queryRunner.query(`ALTER TABLE scenarios ADD COLUMN rating_standard_solo INT(11) NULL DEFAULT 0`); await queryRunner.query(`ALTER TABLE scenarios ADD COLUMN rating_standard_multi INT(11) NULL DEFAULT 0`); await queryRunner.query(`ALTER TABLE scenarios ADD COLUMN rating_expert_solo INT(11) NULL DEFAULT 0`); await queryRunner.query(`ALTER TABLE scenarios ADD COLUMN rating_expert_multi INT(11) NULL DEFAULT 0`); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=7, rating_standard_multi=0, rating_expert_solo=10, rating_expert_multi=4 WHERE id=1`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=10, rating_standard_multi=4, rating_expert_solo=15, rating_expert_multi=6 WHERE id=2`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=6, rating_standard_multi=8, rating_expert_solo=17, rating_expert_multi=18 WHERE id=3`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=3, rating_standard_multi=-2, rating_expert_solo=3, rating_expert_multi=3 WHERE id=4`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=9, rating_standard_multi=9, rating_expert_solo=15, rating_expert_multi=20 WHERE id=5`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=-1, rating_standard_multi=-2, rating_expert_solo=2, rating_expert_multi=7 WHERE id=6`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=2, rating_standard_multi=1, rating_expert_solo=11, rating_expert_multi=6 WHERE id=7`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=0, rating_standard_multi=-2, rating_expert_solo=9, rating_expert_multi=2 WHERE id=8`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=4, rating_standard_multi=0, rating_expert_solo=11, rating_expert_multi=7 WHERE id=9`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=13, rating_standard_multi=8, rating_expert_solo=18, rating_expert_multi=9 WHERE id=10`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=15, rating_standard_multi=14, rating_expert_solo=17, rating_expert_multi=19 WHERE id=11`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=14, rating_standard_multi=6, rating_expert_solo=11, rating_expert_multi=12 WHERE id=12`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=-2, rating_standard_multi=7, rating_expert_solo=7, rating_expert_multi=12 WHERE id=13`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=8, rating_standard_multi=6, rating_expert_solo=23, rating_expert_multi=19 WHERE id=14`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=4, rating_standard_multi=5, rating_expert_solo=16, rating_expert_multi=13 WHERE id=15`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=12, rating_standard_multi=11, rating_expert_solo=22, rating_expert_multi=23 WHERE id=16`, ); await queryRunner.query( `UPDATE scenarios SET rating_standard_solo=20, rating_standard_multi=26, rating_expert_solo=32, rating_expert_multi=25 WHERE id=17`, ); } } |