import { MigrationInterface, QueryRunner } from 'typeorm';

export class AddSlackUserTable1619436718077 implements MigrationInterface {
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE slack_user (
          id            int          NOT NULL AUTO_INCREMENT,
          slackId       varchar(255),
          name          varchar(255) NOT NULL,
          avatarUrl     varchar(255),
          PRIMARY KEY (id)
       )`
    );

    await queryRunner.query(
      `INSERT INTO slack_user
        (slackId, name, avatarUrl)
        VALUES (NULL, 'CENOS Support', NULL)`
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query('DROP TABLE slack_user');
  }
}