acmcc/supabase/migrations/20260506230555_d5feb745-e3db-46ff-9931-fe93afb12e04.sql

ALTER TABLE public.owners ADD COLUMN IF NOT EXISTS designations text[] NOT NULL DEFAULT '{}'::text[];
CREATE INDEX IF NOT EXISTS idx_owners_designations ON public.owners USING GIN(designations);