import { MigrationInterface, QueryRunner } from 'typeorm';

export class AddVariantForRetailerProductVariant1664709874724
  implements MigrationInterface
{
  name = 'AddVariantForRetailerProductVariant1664709874724';

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ADD "variantId" uuid
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ADD CONSTRAINT "FK_027101f801f9cea54242a3f83ef" FOREIGN KEY ("variantId") REFERENCES "aggregate_product_variants"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants" DROP CONSTRAINT "FK_027101f801f9cea54242a3f83ef"
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants" DROP COLUMN "variantId"
        `);
  }
}