-- ================================================
-- Migration: PCF-004 — Parental Consent Admin Notes
-- Date: 2026-06-12
-- Adds parental_form_admin_notes column to store the
-- optional reason/note captured when admin manually
-- sends the parental consent email.
-- Safe to re-run (IF NOT EXISTS).
-- ================================================

ALTER TABLE hdb_program_registration
  ADD COLUMN IF NOT EXISTS parental_form_admin_notes TEXT;

-- Verification
SELECT column_name, data_type, is_nullable
FROM information_schema.columns
WHERE table_name = 'hdb_program_registration'
  AND column_name = 'parental_form_admin_notes';
