-- ================================================
-- Migration: PCF-005 — Parental Consent Generated PDF URL
-- Date: 2026-06-12
-- Adds parental_form_generated_pdf_url to store the
-- auto-generated blank consent form sent to the seeker,
-- separate from parental_form_pdf_url which holds the
-- seeker/admin-uploaded signed form.
-- Safe to re-run (IF NOT EXISTS).
-- ================================================

ALTER TABLE hdb_program_registration
  ADD COLUMN IF NOT EXISTS parental_form_generated_pdf_url TEXT;

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