BUG-1394project-02中已修复database-schema

bk_lead_activities 表缺失导致 CRM leads/{id} 详情页 500

发现：2026-10-17验证：2026-10-17置信度：90%

症状

浏览器访问 /api/bk/crm/leads/{id} 返回 500 Internal Server Error, CRM 线索详情弹窗打不开.

根因

bk_crm_leads_api.py bk_crm_leads_get L207 JOIN bk_lead_activities LEFT JOIN users ON performed_by=u.id, 但 migration 030 没建此表. 所有线索详情页点击都会抛 UndefinedTable.

修复方案

生产执行 CREATE TABLE IF NOT EXISTS bk_lead_activities(id, lead_id, activity_type, title, content, activity_date, performed_by, created_at) + 2 个索引 + 11 条 seed activities(10 leads 各 1-2 条). Migration 050 入库, 纯建表无需 docker restart.

错误签名

UndefinedTable: relation bk_lead_activities does not exist at bk_crm_leads_api.py:207

技术信息

来源项目

project-02

涉及文件

database/migrations/050_bk_lead_activities.sql

标签

project-02, mcp-reported, source-agent