-- Migration: Dating Bio Generation System (Compatible)
-- Created: 2025-11-12
-- Phase 4: Dating Improvements - Component 33
-- Compatible with JSON blob storage in lifesim_savegames

-- =====================================================
-- NPC BIO GENERATION SYSTEM
-- =====================================================

-- NOTE: This system stores bios in the JSON blob within lifesim_savegames
-- No table alterations needed - bios are stored as:
--   person.bio (string)
--   person.last_bio_update (datetime)
--
-- The backend dating/bio_generation.py module handles this automatically

SELECT 'Migration 002: Dating Bio Generation (Compatible) - COMPLETED' AS status,
       'Bios stored in lifesim_savegames JSON blob' AS note;
