Chunk #500

Aus: Installation (Index: 2)

103 Tokens
Synced Status
« Vorheriger (#1) Nächster (#3) »

Taxonomie

Kategorie Installation
Pfad Installation > Datenbank > Datenbanktabellen
Heading-Pfad Installation > MCP-DB Installation > 5. Datenbank vorbereiten > mcp_log Tabelle

Entities

Name Typ
mcp_log CONFIG
INT TECHNOLOGY
VARCHAR TECHNOLOGY
DATETIME TECHNOLOGY
TEXT TECHNOLOGY
ENUM TECHNOLOGY

Keywords

database table log mcp_log timestamp

Inhalt

CREATE TABLE IF NOT EXISTS mcp_log (
    id INT AUTO_INCREMENT PRIMARY KEY,
    timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    client_name VARCHAR(50) NOT NULL DEFAULT 'mcp-db',
    request TEXT,
    status ENUM('success', 'error', 'denied') NOT NULL,
    duration_ms INT DEFAULT 0,
    error_message TEXT,
    INDEX idx_timestamp (timestamp),
    INDEX idx_status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Clean Content

```
`CREATE TABLE IF NOT EXISTS mcp_log (
 id INT AUTO_INCREMENT PRIMARY KEY,
 timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
 client_name VARCHAR(50) NOT NULL DEFAULT 'mcp-db',
 request TEXT,
 status ENUM('success', 'error', 'denied') NOT NULL,
 duration_ms INT DEFAULT 0,
 error_message TEXT,
 INDEX idx_timestamp (timestamp),
 INDEX idx_status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`
```

Metadaten

Analysiert am20.12.2025 12:41:20
Analyse-Modellgemma3:4b-it-qat
Embedding-Modellmxbai-embed-large
Qdrant-ID38b548b6-bda4-4ecb-915b-9b553418e93f
Erstellt20.12.2025 12:34:42
Aktualisiert20.12.2025 12:53:38