import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(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'
    `);
    await queryRunner.query(`
      ALTER TABLE "booking_activity_items"
      ADD COLUMN IF NOT EXISTS "ticket_status" varchar(20) NOT NULL DEFAULT 'Pending'
    `);
    await queryRunner.query(`
      ALTER TABLE "activities"
      ADD COLUMN IF NOT EXISTS "is_special" boolean NOT NULL DEFAULT false
    `);
  }

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