- Migration 025: Add 'abandoned' status to sessions CHECK constraint (fixes blocking issue)
- Migration 026: Add recovery metadata columns (recovered_from, recovered_at) to track note recovery source
- Update sessionRecoverOrphaned to recover notes from temp files when marking sessions abandoned
- Update notes-parser to track recovery source and timestamp for analytics
These changes complete Priority 3, 5 and part of Priority 1 for CF-572 Session Notes Loss fix.
Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com>