import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE \`siteinfos\` ADD \`cardBankOwner\` VARCHAR(128) NULL AFTER 
      \`freewayTollInquiryAmount\`, ADD \`cardBankNumber\`
       VARCHAR(128) NULL AFTER \`cardBankOwner\`, ADD \`cardBankName\`
        VARCHAR(128) NULL AFTER \`cardBankNumber\``,
    );
    await queryRunner.query(
      `ALTER TABLE \`orders\` ADD \`cardtoCardTrackingCode\` 
      VARCHAR(128) NULL AFTER \`governmentOilTrackingCode\`, ADD 
      \`cardToCardImageReceipt\` VARCHAR(128) NULL AFTER \`cardtoCardTrackingCode\``,
    );
  }

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