# 2026-02-24 — Builder Daily Log

## No-Show Columns Migration — DONE ✅
- **Time:** ~06:20 AEDT
- **Trigger:** Michael said to stop waiting, run migrations myself
- **Migration:** `supabase/add-no-show-columns.sql`
- **Method:** Supabase Management API (`POST /v1/projects/{ref}/database/query`) with access token from `/root/.clawdbot/secrets.json`
- **Result:** 3 columns added to `matches` table:
  - `no_show` (boolean, default false, NOT NULL)
  - `no_show_reported_at` (timestamptz, nullable)
  - `no_show_reported_by` (uuid, nullable, FK to auth.users)
- **Index:** `idx_matches_no_show` created (partial, WHERE no_show = true)
- **Verified:** Columns confirmed in information_schema
- **Build:** Green after migration
- **Key learning:** psql via pooler connection fails ("Tenant or user not found") — use Management API instead

## VAPI Sales Training Mode — DONE ✅
- **Time:** ~09:15–09:30 AEDT
- **Trigger:** Rivet task from Michael — wants to practice cold calls
- **Created:** New VAPI assistant `a668e7f2-2e1f-4409-80db-1c0f578c72b7`
- **Persona:** Sceptical Aussie contractor, 14 objections, varies personality each call
- **Voice:** OpenAI "echo", GPT-4o, temp 0.85
- **Phone:** Same number +61238205443 — swap script toggles between production/training
- **Scripts:** `training-mode.sh` (on/off/status), `fetch-training-logs.sh` (transcripts)
- **Existing VAPI assistants:** 8 total, only 1 phone number on account

## P0 Fix: Post-Hire Contact Flow — DONE ✅ (early 25th)
- Workers couldn't find contact details after being hired — the "You're Hired!" button was disabled/dead
- Fixed: Button now links to `/worker/hired/[matchId]`, hired cards navigate directly, dashboard shows hired jobs
- Also: Created `/contractor/profile/edit` — Michael can now edit his own profile
- Commit: ca4c665

## Discovery: Database Access
- I have full DB migration capability via Supabase Management API
- Access token in `/root/.clawdbot/secrets.json` → `supabase_access_token`
- No more blocking on "need someone to run migrations"
- Updated MEMORY.md with this pattern