Reporter account

Create a CivicPulse profile.

Registration creates a Supabase Auth user and a profile row for role-aware access. Admin promotion is intentionally a manual database step.