import { MigrationInterface , QueryRunner } from 'typeorm' ; export class IRecOrganizationContactDetails1606732581503 implements MigrationInterface { name = 'IRecOrganizationContactDetails1606732581503' ; public async up ( queryRunner ) { await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "primaryContactOrganizationName" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "primaryContactOrganizationAddress" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "primaryContactOrganizationPostalCode" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "primaryContactOrganizationCountry" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "primaryContactName" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "primaryContactEmail" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "primaryContactPhoneNumber" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "primaryContactFax" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "leadUserTitle" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "leadUserFirstName" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "leadUserLastName" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "leadUserEmail" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "leadUserPhoneNumber" character varying NOT NULL DEFAULT ''` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" ADD "leadUserFax" character varying NOT NULL DEFAULT ''` ) ; } public async down ( queryRunner ) { await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "leadUserFax"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "leadUserPhoneNumber"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "leadUserEmail"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "leadUserLastName"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "leadUserFirstName"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "leadUserTitle"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "primaryContactFax"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "primaryContactPhoneNumber"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "primaryContactEmail"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "primaryContactName"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "primaryContactOrganizationCountry"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "primaryContactOrganizationPostalCode"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "primaryContactOrganizationAddress"` ) ; await queryRunner . query ( `ALTER TABLE "irec_registration" DROP COLUMN "primaryContactOrganizationName"` ) ; } }