
-- Add reference_mobile and reference_customer_id columns
ALTER TABLE public.customers ADD COLUMN reference_mobile text NULL DEFAULT '';
ALTER TABLE public.customers ADD COLUMN reference_customer_id uuid NULL;

-- Drop old referral_code column
ALTER TABLE public.customers DROP COLUMN IF EXISTS referral_code;
