acmcc/supabase/migrations/20260422192700_679afcf1-eb6e-4091-be16-f98bcea2fd17.sql

ALTER TABLE public.amenities
ADD COLUMN IF NOT EXISTS show_on_public_page BOOLEAN NOT NULL DEFAULT true;

CREATE INDEX IF NOT EXISTS idx_amenities_public_display
ON public.amenities (association_id, is_active, show_on_public_page, sort_order);