{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/migration\/content-pipeline\/sql\/schema.sql",
"content": " `first_mention_chunk` int(11) DEFAULT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `unique_doc_entity` (`document_id`,`entity_id`),\n KEY `idx_entity` (`entity_id`),\n CONSTRAINT `document_entities_ibfk_1` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`),\n CONSTRAINT `document_entities_ibfk_2` FOREIGN KEY (`entity_id`) REFERENCES `entities` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;\n\nCREATE TABLE `document_taxonomy` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `document_id` int(11) NOT NULL,\n `taxonomy_id` int(11) NOT NULL,\n `confidence` float DEFAULT 1,\n `created_at` datetime DEFAULT current_timestamp(),\n PRIMARY KEY (`id`),\n UNIQUE KEY `unique_doc_taxonomy` (`document_id`,`taxonomy_id`),\n KEY `idx_taxonomy` (`taxonomy_id`),\n CONSTRAINT `document_taxonomy_ibfk_1` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`),\n CONSTRAINT `document_taxonomy_ibfk_2` FOREIGN KEY (`taxonomy_id`) REFERENCES `taxonomy_terms` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;\n\n-- =====================================================\n-- PIPELINE TABLES\n-- =====================================================\n\nCREATE TABLE `pipeline_configs` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `name` varchar(100) NOT NULL,\n `description` text DEFAULT NULL,\n `is_default` tinyint(1) DEFAULT 0,\n `source_path` varchar(500) NOT NULL DEFAULT '\/path\/to\/documents',\n `extensions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`extensions`)),\n `created_at` datetime DEFAULT current_timestamp(),\n `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),\n PRIMARY KEY (`id`),\n UNIQUE KEY `name` (`name`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\n\nCREATE TABLE `pipeline_steps` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `pipeline_id` int(11) NOT NULL,\n `step_type` enum('analyze','chunk','chunk_entity_link','chunk_semantics','chunk_store','chunk_taxonomy','collection_setup','detect','doc_create','duplicate_check','embed','enrich','entity_extract','entity_normalize','entity_store','entity_taxonomy','extract','finalize','hash','index_optimize','knowledge_semantic_analyze','knowledge_semantic_store','metadata_store','ontology_classify','ontology_store','page_split','page_store','qdrant_store','queue','question_generate','relation_extract','relation_store','rotation','segment','semantic_analyze','status_update','structure','summarize','taxonomy_build','text_semantic_analyze','text_semantic_store','validate','vector_store','vision','vision_analyze','vision_store') NOT NULL,\n `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`config`)),\n `sort_order` int(11) NOT NULL DEFAULT 0,\n `enabled` tinyint(1) DEFAULT 1,\n `created_at` datetime DEFAULT current_timestamp(),\n `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),\n PRIMARY KEY (`id`),\n UNIQUE KEY `uq_pipeline_step` (`pipeline_id`,`step_type`),\n KEY `idx_pipeline_order` (`pipeline_id`,`sort_order`),",
"numLines": 50,
"startLine": 280,
"totalLines": 450
}
}
}