create table prospects (
  id uuid default gen_random_uuid() primary key,
  agent_name text not null,
  first_name text not null,
  last_name text,
  brokerage text,
  state text,
  temp text default 'cold',
  stage text default 'new',
  source text,
  notes text,
  touches integer default 0,
  added_at timestamp default now(),
  updated_at timestamp default now()
);

alter table prospects enable row level security;
create policy "allow all" on prospects for all using (true);