cfc/cfc-backend/add-member-only.sql

-- MySQL script to add member_only column directly
USE zxyj;

-- 首先检查列是否存在
SELECT 
    CASE 
        WHEN COUNT(*) > 0 THEN '列已存在'
        ELSE '列不存在'
    END as column_status
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'zxyj' 
    AND TABLE_NAME = 'tasks' 
    AND COLUMN_NAME = 'member_only';

-- 如果列不存在，则添加
ALTER TABLE tasks ADD COLUMN IF NOT EXISTS member_only TINYINT DEFAULT 0 COMMENT '1=会员任务 (方案/套餐生成),执行需会员; 0=普通任务可免费执行';

-- 验证
SHOW COLUMNS FROM tasks LIKE 'member_only';