import { MigrationInterface, QueryRunner } from 'typeorm';

/**
 * Ticket status is per booking activity (booking_activity_items), not
 * per inventory batch. Drop the batch column so Ticket Inventory no
 * longer owns a status that every assigned booking shared.
 */
export class DropBatchTicketStatus1788200000000 implements MigrationInterface {
  name = 'DropBatchTicketStatus1788200000000';

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "activity_ticket_batches" DROP COLUMN IF EXISTS "ticket_status"`,
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
      ALTER TABLE "activity_ticket_batches"
      ADD COLUMN IF NOT EXISTS "ticket_status" varchar(20) NOT NULL DEFAULT 'Pending'
    `);
  }
}