30650cf47f
- 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>
14 lines
606 B
SQL
14 lines
606 B
SQL
-- Migration 025: Add 'abandoned' status to sessions
|
|
-- Purpose: Fix CF-572 schema constraint issue preventing orphan recovery
|
|
-- Context: sessionRecoverOrphaned() tries to set status='abandoned' but constraint only allows 'active', 'completed', 'interrupted'
|
|
|
|
ALTER TABLE sessions
|
|
DROP CONSTRAINT IF EXISTS sessions_status_check;
|
|
|
|
ALTER TABLE sessions
|
|
ADD CONSTRAINT sessions_status_check
|
|
CHECK (status IN ('active', 'completed', 'interrupted', 'abandoned'));
|
|
|
|
COMMENT ON CONSTRAINT sessions_status_check ON sessions
|
|
IS 'Valid session statuses including abandoned for orphaned sessions (CF-572)';
|