ALTER TABLE public.investors 
  ADD COLUMN IF NOT EXISTS portal_enabled boolean NOT NULL DEFAULT false,
  ADD COLUMN IF NOT EXISTS portal_password_hash text,
  ADD COLUMN IF NOT EXISTS portal_last_login_at timestamp with time zone;

CREATE INDEX IF NOT EXISTS idx_investors_mobile ON public.investors(mobile);