UserMigration for Medusa

gistfile1.txt

import { Migration } from "medusa-extender";
import { MigrationInterface, QueryRunner } from "typeorm";

@Migration()
export default class addStoreIdToUser1672134240438
  implements MigrationInterface
{
  name = "addStoreIdToUser1672134240438";

  public async up(queryRunner: QueryRunner): Promise<void> {
    const query = `ALTER TABLE public."user" ADD COLUMN IF NOT EXISTS "store_id" text;`;
    await queryRunner.query(query);
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    const query = `ALTER TABLE public."user" DROP COLUMN "store_id";`;
    await queryRunner.query(query);
  }
}