Chunk #608
Aus: Installation (Index: 3)
264
Tokens
Synced
Status
Taxonomie
| Kategorie | Installation |
|---|---|
| Pfad | Installation > Datenbank > Tabellen |
| Heading-Pfad | Installation > MCP-Tasks Installation > 5. Datenbank vorbereiten > Task-Tabellen erstellen |
Entities
| Name | Typ |
|---|---|
| task_results | TECHNOLOGY|TABLE |
| task_comments | TECHNOLOGY|TABLE |
| InnoDB | TECHNOLOGY |
| MySQL | TECHNOLOGY |
| AUTO_INCREMENT | CONFIG |
| PRIMARY KEY | CONFIG |
| FOREIGN KEY | CONFIG |
| ENUM | CONFIG |
| TEXT | CONFIG |
| VARCHAR | CONFIG |
| INT | CONFIG |
| DECIMAL | CONFIG |
| DATETIME | CONFIG |
Keywords
Inhalt
-- Ergebnisse
CREATE TABLE IF NOT EXISTS task_results (
id INT AUTO_INCREMENT PRIMARY KEY,
task_id INT NOT NULL,
response TEXT NOT NULL,
executor VARCHAR(100) NOT NULL,
executor_type ENUM('human', 'ollama', 'claude', 'anthropic_api') NOT NULL,
model_name VARCHAR(100) DEFAULT NULL,
status ENUM('success', 'error', 'partial') DEFAULT 'success',
tokens_input INT DEFAULT 0,
tokens_output INT DEFAULT 0,
cost_usd DECIMAL(10,6) DEFAULT 0,
duration_ms INT DEFAULT 0,
error_message TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE,
INDEX idx_task_id (task_id),
INDEX idx_executor_type (executor_type)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Kommentare (optional)
CREATE TABLE IF NOT EXISTS task_comments (
id INT AUTO_INCREMENT PRIMARY KEY,
task_id INT NOT NULL,
author VARCHAR(100) NOT NULL,
content TEXT NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`
```
Clean Content
-- Ergebnisse
CREATE TABLE IF NOT EXISTS task_results (
id INT AUTO_INCREMENT PRIMARY KEY,
task_id INT NOT NULL,
response TEXT NOT NULL,
executor VARCHAR(100) NOT NULL,
executor_type ENUM('human', 'ollama', 'claude', 'anthropic_api') NOT NULL,
model_name VARCHAR(100) DEFAULT NULL,
status ENUM('success', 'error', 'partial') DEFAULT 'success',
tokens_input INT DEFAULT 0,
tokens_output INT DEFAULT 0,
cost_usd DECIMAL(10,6) DEFAULT 0,
duration_ms INT DEFAULT 0,
error_message TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE,
INDEX idx_task_id (task_id),
INDEX idx_executor_type (executor_type)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Kommentare (optional)
CREATE TABLE IF NOT EXISTS task_comments (
id INT AUTO_INCREMENT PRIMARY KEY,
task_id INT NOT NULL,
author VARCHAR(100) NOT NULL,
content TEXT NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`
```
Metadaten
| Analysiert am | 20.12.2025 12:47:12 |
|---|---|
| Analyse-Modell | gemma3:4b-it-qat |
| Embedding-Modell | mxbai-embed-large |
| Qdrant-ID | c4963ae3-0796-4391-b8dd-dca690e5b82a |
| Erstellt | 20.12.2025 12:34:42 |
| Aktualisiert | 20.12.2025 12:53:40 |