-- Migration: Location venue map column
-- Description: Adds a location_venue_map TEXT column to program_type_v1, program_v1, and
--              program_session, alongside the existing venue column on the first two, to hold
--              a map link/embed URL for the venue. Nullable; null = no map link set.
--              Column-only for now — no service-layer logic copies
--              program_type_v1.location_venue_map onto a program (or a program's onto its
--              sessions) automatically; that value is entered per row, same as venue itself.
--              Idempotent.

ALTER TABLE program_type_v1
    ADD COLUMN IF NOT EXISTS location_venue_map TEXT NULL;

COMMENT ON COLUMN program_type_v1.location_venue_map IS
    'Map link/embed URL for the venue. Nullable; null = none set.';

ALTER TABLE program_v1
    ADD COLUMN IF NOT EXISTS location_venue_map TEXT NULL;

COMMENT ON COLUMN program_v1.location_venue_map IS
    'Map link/embed URL for the venue. Nullable; null = none set.';

ALTER TABLE program_session
    ADD COLUMN IF NOT EXISTS location_venue_map TEXT NULL;

COMMENT ON COLUMN program_session.location_venue_map IS
    'Map link/embed URL for the venue. Nullable; null = none set.';
