import { MigrationInterface , QueryRunner } from 'typeorm' ; export class DefaultAskPriceColumnInDevice1587979261608 implements MigrationInterface { name = 'DefaultAskPriceColumnInDevice1587979261608' ; public async up ( queryRunner ) { await queryRunner . query ( `ALTER TABLE "device" ADD "defaultAskPrice" integer` , undefined ) ; await queryRunner . query ( `ALTER TABLE "certification_request" ALTER COLUMN "id" DROP DEFAULT` , undefined ) ; await queryRunner . query ( `DROP SEQUENCE "certification_request_id_seq"` , undefined ) ; await queryRunner . query ( `ALTER TABLE "certification_request" ALTER COLUMN "energy" TYPE character varying` , undefined ) ; } public async down ( queryRunner ) { await queryRunner . query ( `ALTER TABLE "certification_request" ALTER COLUMN "energy" TYPE bigint` , undefined ) ; await queryRunner . query ( `CREATE SEQUENCE "certification_request_id_seq" OWNED BY "certification_request"."id"` , undefined ) ; await queryRunner . query ( `ALTER TABLE "certification_request" ALTER COLUMN "id" SET DEFAULT nextval('certification_request_id_seq')` , undefined ) ; await queryRunner . query ( `ALTER TABLE "device" DROP COLUMN "defaultAskPrice"` , undefined ) ; } }