import { MigrationInterface , QueryRunner } from 'typeorm' ; export class BlockchainAddressUnique1611928473862 implements MigrationInterface { name = 'BlockchainAddressUnique1611928473862' ; public async up ( queryRunner ) { await queryRunner . query ( `ALTER TABLE "user" DROP CONSTRAINT "UQ_6f73e3508ecb836bd99ec2ea6a0"` ) ; await queryRunner . query ( `COMMENT ON COLUMN "user"."email" IS NULL` ) ; await queryRunner . query ( `ALTER TABLE "user" ADD CONSTRAINT "UQ_e12875dfb3b1d92d7d7c5377e22" UNIQUE ("email")` ) ; await queryRunner . query ( `COMMENT ON COLUMN "user"."blockchainAccountAddress" IS NULL` ) ; await queryRunner . query ( `ALTER TABLE "user" ADD CONSTRAINT "UQ_3e71ea3e520c84b9d9ec1199432" UNIQUE ("blockchainAccountAddress")` ) ; } public async down ( queryRunner ) { await queryRunner . query ( `ALTER TABLE "user" DROP CONSTRAINT "UQ_3e71ea3e520c84b9d9ec1199432"` ) ; await queryRunner . query ( `COMMENT ON COLUMN "user"."blockchainAccountAddress" IS NULL` ) ; await queryRunner . query ( `ALTER TABLE "user" DROP CONSTRAINT "UQ_e12875dfb3b1d92d7d7c5377e22"` ) ; await queryRunner . query ( `COMMENT ON COLUMN "user"."email" IS NULL` ) ; await queryRunner . query ( `ALTER TABLE "user" ADD CONSTRAINT "UQ_6f73e3508ecb836bd99ec2ea6a0" UNIQUE ("email", "blockchainAccountAddress")` ) ; } }