jeff-claw

-- Clients table
CREATE TABLE IF NOT EXISTS public.clients (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  company_name TEXT NOT NULL,
  contact_name TEXT DEFAULT '',
  email TEXT DEFAULT '',
  phone TEXT DEFAULT '',
  client_type TEXT DEFAULT 'end_user' CHECK (client_type IN ('reseller', 'end_user')),
  region TEXT DEFAULT 'Gauteng',
  notes TEXT DEFAULT '',