import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`ALTER TABLE \`emergency_phones\` DROP \`phone3\``);
    await queryRunner.query(`ALTER TABLE \`emergency_phones\` DROP \`phone2\``);
    await queryRunner.query(
      `ALTER TABLE \`emergency_phones\` ADD \`site\` VARCHAR(255) NULL AFTER \`phone\``,
    );
  }

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