import { MigrationInterface, QueryRunner } from 'typeorm';

/**
 * Optional row-level visibility expander on roles — see common/auth/visibility.ts.
 * Does not grant module permissions; works only with QUERY/BOOKING view+.
 */
export class RoleViewAllBookingsQueries1787100000000 implements MigrationInterface {
  name = 'RoleViewAllBookingsQueries1787100000000';

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
      ALTER TABLE "roles"
        ADD COLUMN IF NOT EXISTS "view_all_bookings_queries" boolean NOT NULL DEFAULT false
    `);
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
      ALTER TABLE "roles" DROP COLUMN IF EXISTS "view_all_bookings_queries"
    `);
  }
}