import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterTripTableToAddPlanIdColumn1756964668306 implements MigrationInterface {
  name = "AlterTripTableToAddPlanIdColumn1756964668306"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`ALTER TABLE "trips" ADD "plan_id" integer`)
    await queryRunner.query(
      `ALTER TABLE "trips" ADD CONSTRAINT "FK_f706f993a6b289ccfaab7c08676" FOREIGN KEY ("plan_id") REFERENCES "pricing_plans"("id") ON DELETE SET NULL ON UPDATE NO ACTION`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "trips" DROP CONSTRAINT "FK_f706f993a6b289ccfaab7c08676"`,
    )
    await queryRunner.query(`ALTER TABLE "trips" DROP COLUMN "plan_id"`)
  }
}