import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE \`cars\` ADD \`oilGovPriority\` INT NOT NULL DEFAULT '5' AFTER 
      \`engineCode\`, ADD \`oilGovStatus\` ENUM('success','normal_check','force_check','error') 
      NOT NULL DEFAULT 'normal_check' AFTER \`oilGovPriority\`,
       ADD \`oilGovAllocation\` INT NULL AFTER \`oilGovStatus\`,
        ADD \`oilGovLastChecked\` DATETIME NULL AFTER \`oilGovAllocation\`,
         ADD \`oilGovMessage\` VARCHAR(255) NULL AFTER \`oilGovLastChecked\`, 
         ADD \`oilGovErrorCode\` INT NULL AFTER \`oilGovMessage\`;
      `,
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    //
  }
}