
ALTER TABLE public.hotels
  ADD COLUMN IF NOT EXISTS adr_weekday numeric,
  ADD COLUMN IF NOT EXISTS adr_weekend numeric,
  ADD COLUMN IF NOT EXISTS occupancy_pct integer,
  ADD COLUMN IF NOT EXISTS currency text NOT NULL DEFAULT 'MYR';
