import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE IF NOT EXISTS \`emergency_phones\` (
  \`id\` int(11) NOT NULL AUTO_INCREMENT,
  \`name\` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  \`phone\` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  \`phone2\` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  \`phone3\` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  \`displayOrder\` int(11) DEFAULT NULL,
  \`createdAt\` datetime NOT NULL,
  \`updatedAt\` datetime NOT NULL,
  PRIMARY KEY (\`id\`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci`,
    );
  }

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