import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE \`products\` 
      ADD COLUMN \`creatorUserId\` CHAR(36) CHARACTER SET utf8 COLLATE utf8_bin NULL AFTER \`productId\`,
      ADD INDEX \`fk_products_users1_idx\` (\`creatorUserId\` ASC);`,
    );

    await queryRunner.query(`ALTER TABLE \`products\` 
      ADD CONSTRAINT \`fk_products_users1\`
        FOREIGN KEY (\`creatorUserId\`)
        REFERENCES \`users\` (\`id\`)
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;`);
  }

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