import { MigrationInterface, QueryRunner } from "typeorm"

export class AddLocationFieldsToTimeTracking1766059065498 implements MigrationInterface {
  name = "AddLocationFieldsToTimeTracking1766059065498"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "time_tracking" ADD "latitude" numeric`,
    )
    await queryRunner.query(
      `ALTER TABLE "time_tracking" ADD "longitude" numeric`,
    )
    await queryRunner.query(
      `ALTER TABLE "time_tracking" ADD "address" character varying(255)`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`ALTER TABLE "time_tracking" DROP COLUMN "address"`)
    await queryRunner.query(
      `ALTER TABLE "time_tracking" DROP COLUMN "longitude"`,
    )
    await queryRunner.query(
      `ALTER TABLE "time_tracking" DROP COLUMN "latitude"`,
    )
  }
}