Changes
Database Schema
- Complete baseline
schema.sql with all current features
- Added
ai_model column to projects and tickets tables
- Added Smart Context tables (user_preferences, project_maps, project_knowledge, conversation_extractions)
- Added all views (v_ticket_context, v_projects_needing_map, v_tickets_needing_extraction)
- Removed user-created tables from schema
Migrations
- Cleaned up migrations folder - this is the initial release baseline
- Migrations only run via
upgrade.sh for future updates
schema.sql is the complete database for fresh installs
Documentation
- Updated CLAUDE_DEV_NOTES.md with migration workflow
Installation
wget https://github.com/fotsakir/Claude-AI-developer/releases/download/v2.34.0/fotios-claude-system-2.34.0.zip
unzip fotios-claude-system-2.34.0.zip
cd fotios-claude-system
sudo ./setup.sh