import { type MigrationInterface, type QueryRunner } from 'typeorm';

export class TicketBatchBookingRefToText1778700000000 implements MigrationInterface {
  async up(qr: QueryRunner): Promise<void> {
    // Widen booking_reference_no from varchar(100) to text so it can
    // store multiple comma-separated booking UUIDs.
    await qr.query(`
      ALTER TABLE activity_ticket_batches
        ALTER COLUMN booking_reference_no TYPE text;
    `);
  }

  async down(qr: QueryRunner): Promise<void> {
    await qr.query(`
      ALTER TABLE activity_ticket_batches
        ALTER COLUMN booking_reference_no TYPE varchar(100);
    `);
  }
}