import { MigrationInterface, QueryRunner } from "typeorm"

export class AddTripTrackingTable1757577370891 implements MigrationInterface {
  name = "AddTripTrackingTable1757577370891"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE "trip_tracking" ("id" SERIAL NOT NULL, "trip_id" integer NOT NULL, "latitude" character varying NOT NULL, "longitude" character varying NOT NULL, "created_at" TIMESTAMP NOT NULL DEFAULT NOW(), CONSTRAINT "PK_b822a35d4c3b741d79ef7e0831c" PRIMARY KEY ("id"))`,
    )
    await queryRunner.query(
      `ALTER TABLE "trip_tracking" ADD CONSTRAINT "FK_9a0fd402cb0359221b22ebb1c1f" FOREIGN KEY ("trip_id") REFERENCES "trips"("id") ON DELETE CASCADE ON UPDATE NO ACTION`,
    )
  }

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