-- Migration 010: AI-generated PDP content per model
-- Run: psql -d sneakerpicks -f db/migrations/010_model_content_ai.sql
--
-- Adds columns to model_content for AI-generated PDP-level copy (body + variants)
-- The existing intro/description/faq columns remain owned by the template-based
-- subtype page generator and are not touched.

BEGIN;

ALTER TABLE model_content
  ADD COLUMN IF NOT EXISTS pdp_body TEXT,
  ADD COLUMN IF NOT EXISTS opener_variants JSONB,
  ADD COLUMN IF NOT EXISTS closer_variants JSONB,
  ADD COLUMN IF NOT EXISTS style_tags JSONB,
  ADD COLUMN IF NOT EXISTS ai_model TEXT,
  ADD COLUMN IF NOT EXISTS ai_generated_at TIMESTAMPTZ;

COMMIT;
