import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE \`users\` 
ADD COLUMN \`customerId\` INT(11) NULL DEFAULT NULL AFTER \`deleted\`,
ADD INDEX \`fk_users_customers1_idx\` (\`customerId\` ASC);`,
    );

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

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