{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_execute",
"tool_input": {
"statement": "CREATE TABLE IF NOT EXISTS code_analysis (\n id INT AUTO_INCREMENT PRIMARY KEY,\n scan_id CHAR(36) NOT NULL COMMENT 'UUID für Scan-Batch',\n file_path VARCHAR(500) NOT NULL COMMENT 'Absoluter Pfad',\n file_name VARCHAR(255) NOT NULL COMMENT 'Dateiname',\n extension VARCHAR(20) DEFAULT 'php',\n directory VARCHAR(500) NOT NULL COMMENT 'Verzeichnis',\n file_size INT DEFAULT 0 COMMENT 'Größe in Bytes',\n line_count INT DEFAULT 0,\n modified_at DATETIME NOT NULL COMMENT 'Letzte Änderung der Datei',\n namespace VARCHAR(255) DEFAULT NULL,\n classes JSON DEFAULT NULL COMMENT '[{name, type, line}]',\n functions JSON DEFAULT NULL COMMENT '[{name, visibility, line}]',\n parse_error VARCHAR(500) DEFAULT NULL,\n scanned_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n triggered_by ENUM('web','cli','cron') DEFAULT 'web',\n UNIQUE KEY unique_file_scan (scan_id, file_path),\n KEY idx_scan_id (scan_id),\n KEY idx_directory (directory(191)),\n KEY idx_namespace (namespace),\n KEY idx_scanned_at (scanned_at)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"affected_rows\": 0,\n \"error\": null,\n \"execution_ms\": 1\n}"
}
]
}