import { MigrationInterface, QueryRunner } from "typeorm";

export class AddTipoVehiculoToCatalogoVehicular1741252000000 implements MigrationInterface {
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE taller_catalogos_vehiculares ADD COLUMN tipoVehiculoId int NULL AFTER motor`,
    );
    await queryRunner.query(
      `CREATE INDEX IDX_cat_veh_tipo_vehiculo ON taller_catalogos_vehiculares (tipoVehiculoId)`,
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `DROP INDEX IDX_cat_veh_tipo_vehiculo ON taller_catalogos_vehiculares`,
    );
    await queryRunner.query(
      `ALTER TABLE taller_catalogos_vehiculares DROP COLUMN tipoVehiculoId`,
    );
  }
}