{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/migration\/content-pipeline\/sql\/schema.sql",
"content": ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\n\nCREATE TABLE `provenance` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `artifact_type` enum('document','chunk','entity','relation','statement','embedding') NOT NULL,\n `artifact_id` int(11) NOT NULL,\n `source_type` enum('file','extraction','analysis','merge','manual') NOT NULL,\n `source_id` int(11) DEFAULT NULL,\n `pipeline_run_id` int(11) DEFAULT NULL,\n `pipeline_step` varchar(50) DEFAULT NULL,\n `model_used` varchar(100) DEFAULT NULL,\n `prompt_version` varchar(20) DEFAULT NULL,\n `created_at` datetime DEFAULT current_timestamp(),\n PRIMARY KEY (`id`),\n KEY `idx_artifact` (`artifact_type`,`artifact_id`),\n KEY `idx_pipeline` (`pipeline_run_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\n\nCREATE TABLE `semantic_queue` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `item_type` enum('chunk','entity','document') NOT NULL,\n `item_id` int(11) NOT NULL,\n `status` enum('pending','processing','completed','failed') DEFAULT 'pending',\n `priority` int(11) DEFAULT 0,\n `retry_count` int(11) DEFAULT 0,\n `error_message` text DEFAULT NULL,\n `created_at` datetime DEFAULT current_timestamp(),\n `processed_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `idx_status_priority` (`status`,`priority`),\n KEY `idx_item` (`item_type`,`item_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\n\nSET FOREIGN_KEY_CHECKS = 1;\n\n-- =====================================================\n-- INITIAL DATA: Default Pipeline Configuration\n-- =====================================================\n\nINSERT INTO `pipeline_configs` (`name`, `description`, `is_default`, `source_path`, `extensions`) VALUES\n('default', 'Standard Document Pipeline', 1, '\/path\/to\/documents', '[\"pdf\",\"docx\",\"pptx\",\"md\",\"txt\"]');\n\n-- Default pipeline steps\nINSERT INTO `pipeline_steps` (`pipeline_id`, `step_type`, `sort_order`, `enabled`) VALUES\n(1, 'detect', 10, 1),\n(1, 'extract', 20, 1),\n(1, 'chunk', 30, 1),\n(1, 'embed', 40, 1),\n(1, 'entity_extract', 50, 1),\n(1, 'semantic_analyze', 60, 1);",
"numLines": 50,
"startLine": 400,
"totalLines": 450
}
}
}