| 123456789101112131415161718192021222324 |
- -- =====================================================
- -- 数字员工六大能力升级 — 数据库迁移
- -- 1. company_lobster_profile_config: 加 stage_adjustments + dynamic_threshold_enabled
- -- 2. lobster_learning_corpus: 加 quality_score
- -- 3. lobster_node_execution_log: 加 dimension_scores + regen_triggered + original_score + regenerated_score + scene_code + node_code
- -- =====================================================
- -- 1. 画像配置表: 支持按对话阶段动态调整抽取策略
- ALTER TABLE `company_lobster_profile_config`
- ADD COLUMN IF NOT EXISTS `stage_adjustments` JSON DEFAULT NULL COMMENT '按对话阶段的调整配置JSON: {"node_open":{"confidence_threshold":0.3,"priority":"basic"},...}',
- ADD COLUMN IF NOT EXISTS `dynamic_threshold_enabled` TINYINT DEFAULT 0 COMMENT '1=启用动态阈值，按对话阶段自动调整抽取置信度';
- -- 2. 行业语料表: 加质量分字段，与 lobster_sales_corpus.score 对齐
- ALTER TABLE `lobster_learning_corpus`
- ADD COLUMN IF NOT EXISTS `quality_score` INT DEFAULT 0 COMMENT '语料质量分(0-100)，用于统一检索排序';
- -- 3. 节点执行日志表: 加维度详情和重生成追踪字段
- ALTER TABLE `lobster_node_execution_log`
- ADD COLUMN IF NOT EXISTS `dimension_scores` JSON DEFAULT NULL COMMENT '8维度分数JSON: {"relevance":18,"professionalism":15,...}',
- ADD COLUMN IF NOT EXISTS `regen_triggered` TINYINT DEFAULT 0 COMMENT '是否触发重生成',
- ADD COLUMN IF NOT EXISTS `original_score` INT DEFAULT NULL COMMENT '重生成前原始评分(0-160)',
- ADD COLUMN IF NOT EXISTS `regenerated_score` INT DEFAULT NULL COMMENT '重生成后评分(0-160)',
- ADD COLUMN IF NOT EXISTS `scene_code` VARCHAR(64) DEFAULT NULL COMMENT 'AI场景编码',
- ADD COLUMN IF NOT EXISTS `node_code` VARCHAR(64) DEFAULT NULL COMMENT '节点编码(用于按节点维度统计)';
|
