import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`ALTER TABLE \`newscomments\` 
ADD COLUMN \`userId\` CHAR(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER \`newsId\`,
ADD COLUMN \`status\` ENUM('pending','accepted','rejected') NOT NULL DEFAULT 'pending' AFTER \`message\`,
ADD COLUMN \`reasonRejected\` VARCHAR(255) NULL AFTER \`status\`,
CHANGE COLUMN \`newsId\` \`newsId\` INT(11) NOT NULL ,
ADD INDEX \`fk_newscomments_users1_idx\` (\`userId\` ASC),
ADD INDEX \`fk_newscomments_news1_idx\` (\`newsId\` ASC);
   `);

    await queryRunner.query(`ALTER TABLE \`newscomments\` 
ADD CONSTRAINT \`fk_newscomments_users1\`
  FOREIGN KEY (\`userId\`)
  REFERENCES \`users\` (\`id\`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT \`fk_newscomments_news1\`
  FOREIGN KEY (\`newsId\`)
  REFERENCES \`news\` (\`id\`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;`);
  }

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