import { MigrationInterface, QueryRunner } from "typeorm"

export class AlterBusinessVerticalDbName1742901328282 implements MigrationInterface {
  name = "AlterBusinessVerticalDbName1742901328282"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE "business_verticals" ("id" SERIAL NOT NULL, "name" character varying NOT NULL, "team_member_id" integer NOT NULL, "deleted_at" TIMESTAMP, "created_at" TIMESTAMP DEFAULT NOW(), "updated_at" TIMESTAMP DEFAULT NOW(), CONSTRAINT "PK_77a859b5ef1f1b268dab76d9b00" PRIMARY KEY ("id"))`,
    )
    await queryRunner.query(
      `ALTER TABLE "business_verticals" ADD CONSTRAINT "FK_3b51db612575dc419ccb412720d" FOREIGN KEY ("team_member_id") REFERENCES "team_members"("id") ON DELETE CASCADE ON UPDATE NO ACTION`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "business_verticals" DROP CONSTRAINT "FK_3b51db612575dc419ccb412720d"`,
    )
    await queryRunner.query(`DROP TABLE "business_verticals"`)
  }
}