-- =============================================
-- M2：定期盘点自动调度
-- mes_wm_stock_taking_plan 增加定期自动生成相关列
-- 目标库：mom-xgdl（local profile）
-- =============================================

-- 1. mes_wm_stock_taking_plan.auto_generate（是否定期自动生成盘点任务）
SET @exists = (SELECT COUNT(*) FROM information_schema.columns
               WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_plan' AND column_name = 'auto_generate');
SET @sql = IF(@exists = 0,
              'ALTER TABLE mes_wm_stock_taking_plan ADD COLUMN auto_generate TINYINT(1) NULL DEFAULT b''0'' COMMENT ''是否定期自动生成盘点任务'' AFTER frozen',
              'SELECT 1');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

-- 2. mes_wm_stock_taking_plan.generate_cron（自动生成周期 cron 表达式）
SET @exists = (SELECT COUNT(*) FROM information_schema.columns
               WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_plan' AND column_name = 'generate_cron');
SET @sql = IF(@exists = 0,
              'ALTER TABLE mes_wm_stock_taking_plan ADD COLUMN generate_cron VARCHAR(64) NULL COMMENT ''自动生成周期 cron 表达式（auto_generate=1 时必填）'' AFTER auto_generate',
              'SELECT 1');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

-- 3. mes_wm_stock_taking_plan.last_generate_time（上次自动生成时间）
SET @exists = (SELECT COUNT(*) FROM information_schema.columns
               WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_plan' AND column_name = 'last_generate_time');
SET @sql = IF(@exists = 0,
              'ALTER TABLE mes_wm_stock_taking_plan ADD COLUMN last_generate_time DATETIME NULL COMMENT ''上次自动生成时间'' AFTER generate_cron',
              'SELECT 1');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;