{
"assistant_response": "---\n\n# VOLLSTÄNDIGER IMPLEMENTIERUNGSPLAN\n\n## DB-Refactoring: ki_protokoll + ki_system → ki_dev + ki_content\n\n---\n\n## PHASE 0: Vorbereitung\n\n### 0.1 Backup erstellen\n```bash\nmysqldump -u root -p ki_protokoll > \/var\/backups\/ki_protokoll_before_migration.sql\nmysqldump -u root -p ki_system > \/var\/backups\/ki_system_before_migration.sql\n```\n\n### 0.2 Wartungsmodus aktivieren\n- Apache Maintenance Page aktivieren\n- Claude Code Session beenden\n\n---\n\n## PHASE 1: Datenbank-Migration\n\n### 1.1 Neue Datenbanken erstellen\n```sql\nCREATE DATABASE ki_dev CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\nCREATE DATABASE ki_content CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n```\n\n### 1.2 Tabellen nach ki_dev verschieben\n\n**Aus ki_protokoll:**\n```sql\n-- Logs\nRENAME TABLE ki_protokoll.protokoll TO ki_dev.protokoll;\nRENAME TABLE ki_protokoll.mcp_log TO ki_dev.mcp_log;\nRENAME TABLE ki_protokoll.file_backup_history TO ki_dev.file_backup_history;\n\n-- Tasks\nRENAME TABLE ki_protokoll.tasks TO ki_dev.tasks;\nRENAME TABLE ki_protokoll.task_assignments TO ki_dev.task_assignments;\nRENAME TABLE ki_protokoll.task_results TO ki_dev.task_results;\nRENAME TABLE ki_protokoll.task_comments TO ki_dev.task_comments;\n\n-- Contracts\nRENAME TABLE ki_protokoll.contracts TO ki_dev.contracts;\nRENAME TABLE ki_protokoll.contract_history TO ki_dev.contract_history;\nRENAME TABLE ki_protokoll.contract_validations TO ki_dev.contract_validations;\n```\n\n**Aus ki_system:**\n```sql\n-- System-Docs\nRENAME TABLE ki_system.dokumentation TO ki_dev.dokumentation;\nRENAME TABLE ki_system.dokumentation_chunks TO ki_dev.dokumentation_chunks;\nRENAME TABLE ki_system.dokumentation_history TO ki_dev.dokumentation_history;\n\n-- Prompts\nRENAME TABLE ki_system.prompts TO ki_dev.prompts;\nRENAME TABLE ki_system.prompt_tests TO ki_dev.prompt_tests;\nRENAME TABLE ki_system.system_prompts TO ki_dev.system_prompts;\nRENAME TABLE ki_system.llm_requests TO ki_dev.llm_requests;\n\n-- Pipeline\nRENAME TABLE ki_system.pipeline_log TO ki_dev.pipeline_log;\nRENAME TABLE ki_system.pipeline_queue TO ki_dev.pipeline_queue;\n```\n\n### 1.3 Tabellen nach ki_content verschieben\n\n**Aus ki_system:**\n```sql\n-- Content Studio\nRENAME TABLE ki_system.content_contracts TO ki_content.content_contracts;\nRENAME TABLE ki_system.content_critiques TO ki_content.content_critiques;\nRENAME TABLE ki_system.content_orders TO ki_content.content_orders;\nRENAME TABLE ki_system.content_sources TO ki_content.content_sources;\nRENAME TABLE ki_system.content_structures TO ki_content.content_structures;\nRENAME TABLE ki_system.content_versions TO ki_content.content_versions;\nRENAME TABLE ki_system.author_profiles TO ki_content.author_profiles;\nRENAME TABLE ki_system.critics TO ki_content.critics;\n\n-- Wissen\/Knowledge Graph\nRENAME TABLE ki_system.chunks TO ki_content.chunks;\nRENAME TABLE ki_system.chunk_entities TO ki_content.chunk_entities;\nRENAME TABLE ki_system.chunk_semantics TO ki_content.chunk_semantics;\nRENAME TABLE ki_system.chunk_taxonomy TO ki_content.chunk_taxonomy;\nRENAME TABLE ki_system.entities TO ki_content.entities;\nRENAME TABLE ki_system.entity_classifications TO ki_content.entity_classifications;\nRENAME TABLE ki_system.entity_relations TO ki_content.entity_relations;\nRENAME TABLE ki_system.entity_synonyms TO ki_content.entity_synonyms;\nRENAME TABLE ki_system.documents TO ki_content.documents;\nRENAME TABLE ki_system.document_taxonomy TO ki_content.document_taxonomy;\n\n-- Taxonomie\nRENAME TABLE ki_system.taxonomy_terms TO ki_content.taxonomy_terms;\nRENAME TABLE ki_system.ontology_classes TO ki_content.ontology_classes;\n\n-- Suche\nRENAME TABLE ki_system.search_history TO ki_content.search_history;\n\n-- Chat (aus ki_system, ki_protokoll.chat_* löschen da leer)\nRENAME TABLE ki_system.chat_messages TO ki_content.chat_messages;\nRENAME TABLE ki_system.chat_sessions TO ki_content.chat_sessions;\n```\n\n### 1.4 Duplikate und alte DBs entfernen\n```sql\n-- Leere Duplikate in ki_protokoll löschen\nDROP TABLE IF EXISTS ki_protokoll.chat_messages;\nDROP TABLE IF EXISTS ki_protokoll.chat_sessions;\n\n-- Alte Datenbanken löschen (nach Verifizierung!)\nDROP DATABASE ki_protokoll;\nDROP DATABASE ki_system;\n```\n\n---\n\n## PHASE 2: MCP-Server Anpassungen\n\n### 2.1 mcp-tasks\n| Datei | Änderung |\n|-------|----------|\n| `.env` | `DB_NAME=ki_dev` |\n| `config.py` | Default `ki_dev` |\n\n### 2.2 mcp-contracts\n| Datei | Änderung |\n|-------|----------|\n| `.env` | `DB_NAME=ki_dev` |\n| `config.py` | Default `ki_dev` |\n\n### 2.3 mcp-db\n| Datei | Änderung |\n|-------|----------|\n| `.env` | `DB_NAME=ki_dev` (oder beide erlauben) |\n| `config.py` | `ALLOWED_DATABASES = [\"ki_dev\", \"ki_content\"]` |\n\n### 2.4 mcp-docs\n| Datei | Änderung |\n|-------|----------|\n| `.env` | `DB_NAME=ki_dev` (dokumentation ist in ki_dev) |\n| `config.py` | Default `ki_dev` |\n\n---\n\n## PHASE 3: Claude Code Hooks\n\n### 3.1 log_to_db.py\n```python\n# .env\nCLAUDE_DB_NAME=ki_dev\n\n# Default in Python\n'database': os.environ.get('CLAUDE_DB_NAME', 'ki_dev'),\n```\n\n### 3.2 task_hook.py\n```python\n'database': os.environ.get('CLAUDE_DB_NAME', 'ki_dev'),\n```\n\n### 3.3 file_backup_hook.py\n```python\n'database': os.environ.get('CLAUDE_DB_NAME', 'ki_dev'),\n```\n\n---\n\n## PHASE 4: PHP-Anwendung\n\n### 4.1 config\/database.php\n```php\n\/\/ ALT\ndefine('KI_PROTOKOLL_DB_NAME', 'ki_protokoll');\n\n\/\/ NEU\ndefine('KI_DEV_DB_NAME', 'ki_dev');\ndefine('KI_CONTENT_DB_NAME', 'ki_content');\n```\n\n### 4.2 ChatController.php\n```php\n\/\/ ALT\n'mysql:host=localhost;dbname=ki_protokoll;charset=utf8mb4'\n\n\/\/ NEU\n'mysql:host=localhost;dbname=ki_content;charset=utf8mb4'\n```\n\n### 4.3 ProtokollController.php\n```php\n\/\/ ALT\n'mysql:host=localhost;dbname=ki_protokoll;charset=utf8mb4'\n\n\/\/ NEU\n'mysql:host=localhost;dbname=ki_dev;charset=utf8mb4'\n```\n\n### 4.4 ContractRepository.php\n```php\n\/\/ Kommentar aktualisieren\n\/\/ Contracts sind in ki_dev Datenbank\n```\n\n### 4.5 Weitere Controller prüfen\n```bash\ngrep -r \"ki_protokoll\\|ki_system\" \/var\/www\/dev.campus.systemische-tools.de\/src\/\n```\n\n---\n\n## PHASE 5: Dokumentation\n\n### 5.1 claude.md aktualisieren\n- Alle `ki_protokoll` → `ki_dev`\n- Alle `ki_system` → entsprechend aufteilen\n- Neue DB-Struktur dokumentieren\n\n### 5.2 docs\/mcp-db-server-plan.md\n- ALLOWED_DATABASES aktualisieren\n- Beispiele anpassen\n\n### 5.3 credentials.md\n- Keine Änderung (root bleibt root)\n\n---\n\n## PHASE 6: Verifizierung\n\n### 6.1 MCP-Server testen\n```bash\n# Nach Neustart von Claude Code\nmcp__mcp-tasks__tasks_list\nmcp__mcp-contracts__contracts_list\nmcp__mcp-docs__docs_list\nmcp__mcp-db__db_schema ki_dev\nmcp__mcp-db__db_schema ki_content\n```\n\n### 6.2 Web-UI testen\n- `\/tasks` - Task-Liste\n- `\/contracts` - Contract-Liste\n- `\/protokoll` - Protokoll-Ansicht\n- `\/chat` - Chat-Funktion\n- `\/docs` - Dokumentation\n\n### 6.3 Hooks testen\n- Neue Claude Code Session starten\n- Prüfen ob protokoll-Einträge in ki_dev landen\n\n---\n\n## PHASE 7: Aufräumen\n\n### 7.1 Alte Referenzen entfernen\n```bash\n# Suche nach verbleibenden Referenzen\ngrep -r \"ki_protokoll\\|ki_system\" \/var\/www\/ \/opt\/mcp-servers\/ --include=\"*.php\" --include=\"*.py\" --include=\"*.env\" --include=\"*.json\" | grep -v backup\n```\n\n### 7.2 Backups archivieren\n```bash\nmv \/var\/backups\/ki_protokoll_before_migration.sql \/var\/backups\/archive\/\nmv \/var\/backups\/ki_system_before_migration.sql \/var\/backups\/archive\/\n```\n\n---\n\n## ZUSAMMENFASSUNG\n\n| Phase | Aufgaben | Dateien |\n|-------|----------|---------|\n| 0 | Backup + Wartung | 2 SQL Dumps |\n| 1 | DB-Migration | ~35 RENAME TABLE |\n| 2 | MCP-Server | 8 Dateien (.env + config.py × 4) |\n| 3 | Hooks | 4 Dateien (.env + 3 .py) |\n| 4 | PHP | 4-5 Dateien |\n| 5 | Docs | 3+ Dateien |\n| 6 | Tests | - |\n| 7 | Cleanup | - |\n\n**Geschätzte Dauer:** 1-2 Stunden\n\n**Rollback:** SQL-Dumps wiederherstellen, .env\/.py Dateien aus Git-freiem Backup\n\n---\n\nSoll ich mit der Umsetzung beginnen?"
}