-- 区域代理：单个代理自定义佣金字段
-- 请将 fa_ 替换为实际表前缀
-- 可重复执行

SET @sql = IF(
    (SELECT COUNT(*) FROM information_schema.COLUMNS
     WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'fa_shopro_regional_agent' AND COLUMN_NAME = 'commission_type') = 0,
    'ALTER TABLE `fa_shopro_regional_agent`
        ADD COLUMN `commission_type` enum(''rate'',''money'') DEFAULT NULL COMMENT ''自定义佣金类型，空=跟随等级'' AFTER `area_name`,
        ADD COLUMN `commission_rate` decimal(5,2) DEFAULT NULL COMMENT ''自定义佣金比例(%)'' AFTER `commission_type`,
        ADD COLUMN `commission_money` decimal(10,2) DEFAULT NULL COMMENT ''自定义固定佣金(每单)'' AFTER `commission_rate`',
    'SELECT ''skip: fa_shopro_regional_agent commission 字段已存在'' AS info'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;