Christian Gick
|
00de7f1299
|
Add database migrations for session context system
Phase 1: Database Schema Implementation
- Migration 010: Sessions table with bulletproof auto-incrementing
- Unique session IDs across all projects
- Per-project session numbers (1, 2, 3, ...)
- Atomic sequence generation (no race conditions)
- Session-task and session-commit linking
- Semantic search with pgvector HNSW indexes
- Migration 011: Memories table with enhanced schema
- Migrated existing session_memories to memories
- Added session_id and task_id foreign keys
- Renamed columns for consistency
- HNSW indexing for semantic search
- Migration 012: Builds table for CI/CD tracking
- Links builds to sessions and versions
- Tracks build status, timing, and metadata
All migrations tested and verified on agiliton database.
Related: CF-167 (Fix shared session-summary.md file conflict)
|
2026-01-17 07:41:03 +02:00 |
|