Total Complexity | 2 |
Total Lines | 18 |
Duplicated Lines | 0 % |
Changes | 0 |
1 | import {MigrationInterface, QueryRunner} from "typeorm"; |
||
2 | |||
3 | export class QuoteStatus1587565597402 implements MigrationInterface { |
||
4 | name = 'QuoteStatus1587565597402' |
||
5 | |||
6 | public async up(queryRunner: QueryRunner): Promise<any> { |
||
7 | await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined); |
||
8 | await queryRunner.query(`CREATE TYPE "quote_status_enum" AS ENUM('draft', 'sent', 'refused', 'accepted', 'canceled')`, undefined); |
||
9 | await queryRunner.query(`ALTER TABLE "quote" ADD "status" "quote_status_enum" NOT NULL`, undefined); |
||
10 | await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined); |
||
11 | await queryRunner.query(`ALTER TABLE "quote" ADD "status" character varying NOT NULL`, undefined); |
||
12 | } |
||
13 | |||
14 | public async down(queryRunner: QueryRunner): Promise<any> { |
||
15 | await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined); |
||
16 | await queryRunner.query(`ALTER TABLE "quote" ADD "status" "quote_status_enum" NOT NULL`, undefined); |
||
17 | await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined); |
||
18 | await queryRunner.query(`DROP TYPE "quote_status_enum"`, undefined); |
||
19 | await queryRunner.query(`ALTER TABLE "quote" ADD "status" character varying NOT NULL`, undefined); |
||
20 | } |
||
23 |