-- 清理播课功能不必要的字段
-- 日期: 2025-10-14
-- 说明: 新策略下Coze工作流直接写数据库，不需要状态跟踪字段

USE kaopeilian;

-- 删除不再需要的字段
ALTER TABLE courses DROP COLUMN broadcast_status;
ALTER TABLE courses DROP COLUMN broadcast_task_id;
ALTER TABLE courses DROP COLUMN broadcast_error_message;

-- 验证剩余字段
SELECT COLUMN_NAME, COLUMN_TYPE, IS_NULLABLE, COLUMN_COMMENT 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_SCHEMA = 'kaopeilian' 
AND TABLE_NAME = 'courses' 
AND COLUMN_NAME LIKE 'broadcast%';