import { MigrationInterface, QueryRunner } from 'typeorm';

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

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

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

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