-- 检查并修复任务类型和状态为NULL的记录
-- 执行时间: 2025-10-26

-- 1. 检查task_type为NULL的记录数量
SELECT COUNT(*) as null_task_type_count 
FROM sys_task 
WHERE task_type IS NULL AND del_flag = '0';

-- 2. 检查task_status为NULL的记录数量
SELECT COUNT(*) as null_task_status_count 
FROM sys_task 
WHERE task_status IS NULL AND del_flag = '0';

-- 3. 查看task_type为NULL的记录详情
SELECT task_id, task_code, task_type, task_status, create_time 
FROM sys_task 
WHERE task_type IS NULL AND del_flag = '0'
ORDER BY create_time DESC
LIMIT 10;

-- 4. 查看task_status为NULL的记录详情
SELECT task_id, task_code, task_type, task_status, create_time 
FROM sys_task 
WHERE task_status IS NULL AND del_flag = '0'
ORDER BY create_time DESC
LIMIT 10;

-- 5. 修复task_type为NULL的记录（设置为OTHER）
UPDATE sys_task 
SET task_type = 'OTHER' 
WHERE task_type IS NULL AND del_flag = '0';

-- 6. 修复task_status为NULL的记录（设置为PENDING）
UPDATE sys_task 
SET task_status = 'PENDING' 
WHERE task_status IS NULL AND del_flag = '0';

-- 7. 验证修复结果
SELECT COUNT(*) as remaining_null_task_type 
FROM sys_task 
WHERE task_type IS NULL AND del_flag = '0';

SELECT COUNT(*) as remaining_null_task_status 
FROM sys_task 
WHERE task_status IS NULL AND del_flag = '0';

-- 8. 添加NOT NULL约束（可选，确保未来不会再出现NULL值）
-- 注意：执行前需要先确保所有记录都已修复
-- ALTER TABLE sys_task MODIFY COLUMN task_type VARCHAR(50) NOT NULL DEFAULT 'OTHER';
-- ALTER TABLE sys_task MODIFY COLUMN task_status VARCHAR(50) NOT NULL DEFAULT 'PENDING';